| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0911 | Account Ledger | 38 | GL | R1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 |
TOP03B: Enhanced Accounts Receivable |
2 | F09UI011 | Receipt Prepost Work File | 29 | GL | R1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 |
TOP05T: Time Entry |
3 | F063951 | Payroll Journal (Compressed) File | 10 | GL | R1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 |
TOP07: Payroll |
4 | F05290 | WF - Payroll Journal (Detail) | 10 | JR | R1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 |
TOP09: General Accounting |
5 | F0911P | Purge - Account Ledger | 38 | GL | R1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 |
6 | F0911R | WF - Account Ledger Reconciliation | 35 | GL | R1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 |
7 | F0911Z1 | Journal Entry Transactions - Batch File | 55 | VN | R1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 |
8 | F0911Z4 | F0911 Interoperability Table | 60 | SZ | R1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 |
9 | F0912 | Cost Allocations/Flex Budgeting | 21 | RJ | R1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 |
10 | F0912A | Index Computation Entry File | 17 | RI | R1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 |
11 | F0917 | Bank Statement Detail | 41 | GD | R1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 |
12 | F09617 | Auto Bank Statement Detail | 40 | GM | R1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 |
13 | F09UI015 | Indexed Computations Multi-Tiered Entries | 38 | GL | R1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 |
14 | F09UI618 | Auto Bank Statement Process Work Table | 25 | NB | R1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 |
TOP42: Sales Management |
15 | F42800G | Sales Update G Batch Workfile | 22 | SG | R1 | Reference 1 - JE Voucher Invoice etc. | String | Generic Edit | 8 | 0 |