| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0911 | Account Ledger | 88 | GL | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| TOP03: Accounts Receivable |
| 2 | F0311 | Accounts Receivable Ledger | 97 | RP | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 3 | F03B11 | Customer Ledger | 94 | RP | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 4 | F03B11P | Customer Ledger Purge File | 94 | RP | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 5 | F03B11Z1 | Batch Invoices | 110 | VJ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 6 | F03B11Z2 | F03B11 Interoperability Table | 107 | SY | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 7 | F03B14 | Receipts Detail | 78 | RZ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 8 | F03B14P | Receipts Detail Purge File | 78 | RZ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 9 | F03B14Z2 | F03B14 Interoperability Table | 91 | SZ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 10 | F03B465 | A/R Netting Workfile | 31 | RO | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 11 | F03B575 | Auto Debit Invoice Select and Build | 103 | RD | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| TOP04: Accounts Payable |
| 12 | F0411 | Accounts Payable Ledger | 75 | RP | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 13 | F0411A | WF - As Of Accounts Payable Ledger | 75 | RP | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 14 | F0411P | Purge - Accounts Payable Ledger | 75 | RP | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 15 | F0411Z1 | Voucher Transactions - Batch Upload | 93 | VL | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 16 | F0411Z3 | F0411 Interoperability Table | 98 | SZ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 17 | F0414 | Accounts Payable Matching Document Detail | 24 | RN | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 18 | F0414A | WF - As Of Accounts Payable Payment Detail | 24 | RN | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 19 | F0414P | Purge - Accounts Payable Matching Document Detail | 24 | RN | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 20 | F0414Z1 | F0414 Interoperability Table | 37 | SZ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| TOP09: General Accounting |
| 21 | F0911P | Purge - Account Ledger | 88 | GL | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 22 | F0911Z1 | Journal Entry Transactions - Batch File | 105 | VN | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 23 | F0911Z4 | F0911 Interoperability Table | 110 | SZ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 24 | F09UI015 | Indexed Computations Multi-Tiered Entries | 88 | GL | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| TOP42: Sales Management |
| 25 | F42800G1 | Sales Update G Batch Detail Workfile | 80 | DG | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| TOP43: Procurement |
| 26 | F43080 | Approvals Fields Constants | 143 | PD | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 27 | F4311 | Purchase Order Detail File | 143 | PD | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 28 | F4311Z | Purchase Order Generator File | 147 | PW | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 29 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 156 | SZ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 30 | F43199 | P.O. Detail Ledger File - Flexible Version | 143 | OL | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| TOP47: Electronic Commerce |
| 31 | F47017 | EDI Purchase Order Detail - Outbound | 157 | SZ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 32 | F47022 | EDI P.O. Acknowledgment Detail - Inbound | 157 | SZ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 33 | F47057 | EDI Payment Order Remittance Advice - Outbound | 86 | D3 | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 34 | F47057W | EDI Payment Order Remittance Advice - Work | 86 | D3 | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 35 | F47072 | EDI Receiving Advice Detail - Inbound | 158 | SZ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 36 | F47077 | EDI Receiving Advice Detail - Outbound | 158 | SZ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 37 | F47097 | EDI Request for Quote Detail - Outbound | 157 | SZ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 38 | F47102 | EDI Response to RFQ Detail - Inbound | 157 | SZ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 39 | F47137 | EDI Purchase Order Change Detail - Outbound | 158 | SZ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 40 | F47142 | EDI P.O. Change Acknowledgment Detail - Inbound | 159 | SZ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| 41 | F47157 | EDI Shipping Schedule Detail - Outbound | 166 | SZ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| TOP74Y: Italy - Reporting System Only |
| 42 | F743B14I | Suspended IVA Generation - Receipt/Rebate Control-Ita - 03B | 37 | TI | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| TOP76C: Colombia |
| 43 | F76C034A | A/R Check Detail file As Of - COL - 03B | 78 | RZ | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
| TOP89: Conversion Programs |
| 44 | F43199A | Temp F43199 for ERP 9.0 Upgrade | 143 | OL | FNLP | Closed Item - As Of Processing | Character | Generic Edit | 1 | 0 |
