| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0902 | Account Balances | 42 | GB | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
2 | F0911 | Account Ledger | 126 | GL | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
TOP01: Address Book |
3 | F0101 | Address Book Master | 77 | AB | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
4 | F0101Z2 | Address Book - Interoperability | 109 | SZ | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
TOP03: Accounts Receivable |
5 | F03012 | Customer Master by Line of Business | 193 | AI | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
6 | F03012Z1 | Customer Master LOB-Batch Table | 208 | VO | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
TOP03B: Enhanced Accounts Receivable |
7 | F03B11 | Customer Ledger | 143 | RP | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
8 | F03B11P | Customer Ledger Purge File | 143 | RP | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
9 | F03B11Z1 | Batch Invoices | 193 | VJ | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
10 | F03B11Z2 | F03B11 Interoperability Table | 157 | SY | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
11 | F03B13 | Receipts Header | 78 | RY | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
12 | F03B13P | Receipts Header Purge File | 78 | RY | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
13 | F03B13Z2 | F03B13 Interoperability Table | 86 | SY | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
14 | F03B14 | Receipts Detail | 107 | RZ | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
15 | F03B14P | Receipts Detail Purge File | 107 | RZ | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
16 | F03B14Z2 | F03B14 Interoperability Table | 120 | SZ | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
TOP04: Accounts Payable |
17 | F0411 | Accounts Payable Ledger | 119 | RP | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
18 | F0411A | WF - 'As Of' Accounts Payable Ledger | 119 | RP | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
19 | F0411P | Purge - Accounts Payable Ledger | 119 | RP | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
20 | F0411Z1 | Voucher Transactions - Batch Upload | 166 | VL | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
21 | F0411Z3 | F0411 Interoperability Table | 173 | SZ | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
22 | F0413 | Accounts Payable - Matching Document | 28 | RM | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
23 | F0413A | WF - 'As Of' Accounts Payable Payment Register | 28 | RM | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
24 | F0413P | Purge - Accounts Payable Matching Documents | 28 | RM | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
25 | F0413Z1 | F0413 Interoperability Table | 49 | SY | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
TOP08: Human Resources |
26 | F087711B | Performance Appraisal Header Template Keys | 9 | XK | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
TOP09: General Accounting |
27 | F0901 | Account Master | 61 | GM | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
28 | F0902B | Account Balances - 52 Period Accounting | 82 | GB | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
29 | F0902P | Purge - Account Balances | 42 | GB | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
30 | F0902Z1 | Account Balances - Batch File | 46 | GB | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
31 | F0911P | Purge - Account Ledger | 126 | GL | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
32 | F52G02 | Burdening Summarized Ledger | 43 | BS | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
TOP74R: Russia |
33 | F74R9002 | Correspondence Balance - RUS- 09 - 74R | 46 | GB | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |
TOP76C: Colombia |
34 | F76C034A | A/R Check Detail file As Of - COL - 03B | 110 | RZ | PRGF | Purge Flag | Character | Generic Edit | 1 | 0 |