| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints | |
|---|---|---|---|---|---|---|---|---|---|---|
| Banking | ||||||||||
| 1 | ARCT | Incoming Payment - History | 126 | TransCode | Transaction Code | nVarChar | 4 | 0 | ||
| 2 | OPDF | Payment Draft | 126 | TransCode | Transaction Code | nVarChar | 4 | 0 | ||
| 3 | ORCT | Incoming Payment | 126 | TransCode | Transaction Code | nVarChar | 4 | 0 | ||
| 4 | OVPM | Outgoing Payments | 126 | TransCode | Transaction Code | nVarChar | 4 | 0 | ||
| Finance | ||||||||||
| 5 | AACT | G/L Account - History | 81 | TransCode | Transaction Code | nVarChar | 4 | 0 | ||
| 6 | AJD1 | Journal Entry - History - Rows | 28 | TransCode | Transaction Code | nVarChar | 4 | 0 | ||
| 7 | AJDT | Journal Entry - History | 14 | TransCode | Transaction Code | nVarChar | 4 | 0 | ||
| 8 | BTF1 | Journal Voucher - Rows | 28 | TransCode | Transaction Code | nVarChar | 4 | 0 | ||
| 9 | JDT1 | Journal Entry - Rows | 28 | TransCode | Transaction Code | nVarChar | 4 | 0 | ||
| 10 | OACT | G/L Accounts | 81 | TransCode | Transaction Code | nVarChar | 4 | 0 | ||
| 11 | OBTF | Journal Voucher Entry | 14 | TransCode | Transaction Code | nVarChar | 4 | 0 | ||
| 12 | OJDT | Journal Entry | 14 | TransCode | Transaction Code | nVarChar | 4 | 0 | ||
| 13 | ORCR | Recurring Postings | 13 | TransCode | Transaction Code | nVarChar | 4 | 0 | ||
| 14 | OTRT | Posting Templates | 5 | TransCode | Transaction Code | nVarChar | 4 | 0 | ||
| Marketing Documents | ||||||||||
| 15 | GPA3 | Gross Profit Adjustment - JE Details | 7 | TransCode | Transaction Code | nVarChar | 4 | 0 | ||