| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0911 | Account Ledger | 39 | GL | R2 | Reference 2 | String | Generic Edit | 8 | 0 |
TOP03B: Enhanced Accounts Receivable |
2 | F09UI011 | Receipt Prepost Work File | 30 | GL | R2 | Reference 2 | String | Generic Edit | 8 | 0 |
TOP05T: Time Entry |
3 | F063951 | Payroll Journal (Compressed) File | 11 | GL | R2 | Reference 2 | String | Generic Edit | 8 | 0 |
TOP07: Payroll |
4 | F05290 | WF - Payroll Journal (Detail) | 11 | JR | R2 | Reference 2 | String | Generic Edit | 8 | 0 |
TOP09: General Accounting |
5 | F0911P | Purge - Account Ledger | 39 | GL | R2 | Reference 2 | String | Generic Edit | 8 | 0 |
6 | F0911R | WF - Account Ledger Reconciliation | 36 | GL | R2 | Reference 2 | String | Generic Edit | 8 | 0 |
7 | F0911Z1 | Journal Entry Transactions - Batch File | 56 | VN | R2 | Reference 2 | String | Generic Edit | 8 | 0 |
8 | F0911Z4 | F0911 Interoperability Table | 61 | SZ | R2 | Reference 2 | String | Generic Edit | 8 | 0 |
9 | F0912 | Cost Allocations/Flex Budgeting | 22 | RJ | R2 | Reference 2 | String | Generic Edit | 8 | 0 |
10 | F0912A | Index Computation Entry File | 18 | RI | R2 | Reference 2 | String | Generic Edit | 8 | 0 |
11 | F09UI015 | Indexed Computations Multi-Tiered Entries | 39 | GL | R2 | Reference 2 | String | Generic Edit | 8 | 0 |
12 | F70UI001 | Work File for G/L by Cat. Code Localization | 18 | WA | R2 | Reference 2 | String | Generic Edit | 8 | 0 |
13 | F740911 | Work File for G/L Report by Category Code Localization | 21 | WA | R2 | Reference 2 | String | Generic Edit | 8 | 0 |
TOP42: Sales Management |
14 | F42800G1 | Sales Update G Batch Detail Workfile | 29 | DG | R2 | Reference 2 | String | Generic Edit | 8 | 0 |
TOP76B: Brazil - Reporting System Only |
15 | F7601B | Nota Fiscal Header - BRA - 42 | 66 | FH | R2 | Reference 2 | String | Generic Edit | 8 | 0 |