| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0911 | Account Ledger | 35 | GL | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 2 | F03B117 | Revenue Recognition GL Info | 41 | RL | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| 3 | F03B119 | Revenue Recognition GL Info Audit | 36 | RN | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| TOP09: General Accounting |
| 4 | F0911P | Purge - Account Ledger | 35 | GL | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| 5 | F0911R | WF - Account Ledger Reconciliation | 32 | GL | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| 6 | F0911Z1 | Journal Entry Transactions - Batch File | 52 | VN | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| 7 | F0911Z4 | F0911 Interoperability Table | 57 | SZ | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| 8 | F0912 | Cost Allocations/Flex Budgeting | 35 | RJ | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| 9 | F0912A | Index Computation Entry File | 30 | RI | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| 10 | F09UI015 | Indexed Computations Multi-Tiered Entries | 35 | GL | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| 11 | F70UI001 | Work File for G/L by Cat. Code Localization | 20 | WA | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| 12 | F740911 | Work File for G/L Report by Category Code Localization | 24 | WA | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| TOP41: Inventory Management |
| 13 | F4111 | Item Ledger File | 57 | IL | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| TOP42: Sales Management |
| 14 | F42800G | Sales Update G Batch Workfile | 26 | SG | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| TOP75C: China |
| 15 | F75C015 | Cash Flow Data - China | 27 | CF | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| TOP76C: Colombia |
| 16 | F76C9F02 | DIAN Formats by AccountID - COL - 09 | 19 | DF | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| TOP79A: Greenhouse Gas Accounting |
| 17 | F79A11 | GHG Ledger | 28 | GR | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| 18 | F79A11Z1 | GHG Ledger - Batch File | 46 | GL | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| 19 | F79A12 | GHG Ledger Audit | 29 | GR | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
| 20 | F79AU11 | GHG Ledger Work Table | 31 | GR | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.
