aurora_standard.v_pa_journal_entries
| Field | Type | Null | Default | Key | Extra | Comment |
|---|---|---|---|---|---|---|
| jid | bigint(20) unsigned | NO | 0 | |||
| Original_Journal | varchar(2) | YES | ||||
| Original_Journal_Description | varchar(19) | YES | ||||
| Facility_No | varchar(3) | YES | ||||
| Facility_Name | varchar(40) | YES | ||||
| TF_Posted | int(0) | YES | ||||
| Document_No | varchar(11) | NO | ||||
| Document_Description | varchar(70) | NO | ||||
| DT_Documented | datetime | YES | ||||
| Account_ID | varchar(11) | NO | ||||
| Department_ID | varchar(3) | NO | ||||
| Account_Department_ID | varchar(15) | NO | ||||
| Account_Name | varchar(63) | NO | ||||
| Account_Desc | varchar(30) | NO | ||||
| Department_Desc | varchar(30) | NO | ||||
| Accounting_Period | varchar(7) | NO | ||||
| Post_No | varchar(11) | NO | ||||
| DT_Posted | datetime | YES | ||||
| Reference_Code | varchar(6) | NO | ||||
| Posting_Type | varchar(1) | YES | ||||
| Transaction_Amount | decimal(12,2) | YES |
References
| Local Column | References |
|---|