| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0911 | Account Ledger | 54 | GL | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 2 | F03B13 | Receipts Header | 96 | RY | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| 3 | F03B13P | Receipts Header Purge File | 96 | RY | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| 4 | F03B13Z2 | F03B13 Interoperability Table | 109 | SY | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| 5 | F09UI011 | Receipt Prepost Work File | 40 | GL | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| TOP04: Accounts Payable |
| 6 | F0413 | Accounts Payable - Matching Document | 37 | RM | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| 7 | F0413A | WF - As Of Accounts Payable Payment Register | 37 | RM | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| 8 | F0413P | Purge - Accounts Payable Matching Documents | 37 | RM | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| 9 | F0413Z1 | F0413 Interoperability Table | 58 | SY | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| 10 | F09UI005 | Tax Offsets User Index | 44 | GL | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| TOP05A: OW HR & PR Foundation |
| 11 | F06345 | Historical Payroll Register | 54 | JL | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| TOP07: Payroll |
| 12 | F06156 | Pay Check History Summary | 20 | YU | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| TOP09: General Accounting |
| 13 | F0911P | Purge - Account Ledger | 54 | GL | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| 14 | F0911R | WF - Account Ledger Reconciliation | 44 | GL | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| 15 | F0911Z1 | Journal Entry Transactions - Batch File | 71 | VN | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| 16 | F0911Z4 | F0911 Interoperability Table | 76 | SZ | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| 17 | F09UI015 | Indexed Computations Multi-Tiered Entries | 54 | GL | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| 18 | F70UI001 | Work File for G/L by Cat. Code Localization | 19 | WA | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| 19 | F740911 | Work File for G/L Report by Category Code Localization | 22 | WA | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| TOP09E: Expense Reimbursment |
| 20 | F20112 | Expense Report Detail | 62 | ED | RCND | Reconciled Code | Character | UDC | 1 | 0 |
| TOP42: Sales Management |
| 21 | F42800G1 | Sales Update G Batch Detail Workfile | 93 | DG | RCND | Reconciled Code | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
