| 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 |
TOP09: General Accounting |
2 | F0911P | Purge - Account Ledger | 35 | GL | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
3 | F0911R | WF - Account Ledger Reconciliation | 32 | GL | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
4 | F0911Z1 | Journal Entry Transactions - Batch File | 52 | VN | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
5 | F0911Z4 | F0911 Interoperability Table | 57 | SZ | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
6 | F0912 | Cost Allocations/Flex Budgeting | 35 | RJ | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
7 | F0912A | Index Computation Entry File | 30 | RI | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
8 | F09UI015 | Indexed Computations Multi-Tiered Entries | 35 | GL | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
9 | F70UI001 | Work File for G/L by Cat. Code Localization | 20 | WA | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
10 | 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 |
11 | F4111 | Item Ledger File | 57 | IL | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
TOP42: Sales Management |
12 | F42800G | Sales Update G Batch Workfile | 26 | SG | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
TOP75C: China - Reporting System Only |
13 | F75C015 | Cash Flow Data - China | 27 | CF | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
TOP76C: Colombia |
14 | F76C9F02 | DIAN Formats by AccountID - COL - 09 | 19 | DF | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
TOP79A: Greenhouse Gas Accounting |
15 | F79A11 | GHG Ledger | 28 | GR | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
16 | F79A11Z1 | GHG Ledger - Batch File | 46 | GL | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
17 | F79A12 | GHG Ledger Audit | 29 | GR | RE | Reverse or Void (R/V) | Character | UDC | 1 | 0 |
18 | 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.