| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Administration | ||||||||||
| 1 | DAR1 | Data Archive - Transaction Log | 7 | RefDate | Posting Date | Date | 8 | 0 | ||
| 2 | DAR2 | Data Archive - Transaction Log | 8 | RefDate | Posting Date | Date | 8 | 0 | ||
| Banking | ||||||||||
| 3 | MTH1V | Journal Entries of External Reconciliation | 6 | RefDate | Posting Date | Date | 8 | 0 | ||
| Finance | ||||||||||
| 4 | AJD1 | Journal Entry - History - Rows | 21 | RefDate | Posting Date | Date | 8 | 0 | ||
| 5 | AJDT | Journal Entry - History | 6 | RefDate | Posting Date | Date | 8 | 0 | ||
| 6 | BTF1 | Journal Voucher - Rows | 21 | RefDate | Posting Date | Date | 8 | 0 | ||
| 7 | CCPD | Period-End Closing | 7 | RefDate | Posting Date | Date | 8 | 0 | ||
| 8 | FIX1 | Fixed Asset Transaction - Rows | 7 | RefDate | Posting Date | Date | 8 | 0 | ||
| 9 | JDT1 | Journal Entry - Rows | 21 | RefDate | Posting Date | Date | 8 | 0 | ||
| 10 | OBTF | Journal Voucher Entry | 6 | RefDate | Posting Date | Date | 8 | 0 | ||
| 11 | ODRN | Depreciation Run | 7 | RefDate | Posting Date | Date | 8 | 0 | ||
| 12 | OHSV | Hasavsevet Journal Entry | 4 | RefDate | Posting Date | nVarChar | 6 | 0 | ||
| 13 | OJDT | Journal Entry | 6 | RefDate | Posting Date | Date | 8 | 0 | ||
| 14 | RTM1 | Rate Differences - Rows | 15 | RefDate | Posting Date | Date | 8 | 0 | ||