| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0911 | Account Ledger | 139 | GL | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 2 | F03B14 | Receipts Detail | 2 | RZ | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 3 | F03B14P | Receipts Detail Purge File | 2 | RZ | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 4 | F03B14Z2 | F03B14 Interoperability Table | 15 | SZ | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 5 | F03B21 | A/R Notification History Detail | 2 | ZS | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 6 | F03B23 | A/R Fee Journal History Detail | 2 | RT | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 7 | F03B40 | A/R Deduction Management | 23 | RB | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 8 | F09UI011 | Receipt Prepost Work File | 43 | GL | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 9 | F74W300 | A/R Fee Journal History Detail Tag File | 2 | RU | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP04: Accounts Payable |
| 10 | F0414 | Accounts Payable Matching Document Detail | 2 | RN | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 11 | F0414A | WF - As Of Accounts Payable Payment Detail | 2 | RN | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 12 | F0414P | Purge - Accounts Payable Matching Document Detail | 2 | RN | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 13 | F0414Z1 | F0414 Interoperability Table | 15 | SZ | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 14 | F09UI005 | Tax Offsets User Index | 49 | GL | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP09: General Accounting |
| 15 | F0911P | Purge - Account Ledger | 139 | GL | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 16 | F0911R | WF - Account Ledger Reconciliation | 77 | GL | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 17 | F0911Z1 | Journal Entry Transactions - Batch File | 191 | VN | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 18 | F0911Z4 | F0911 Interoperability Table | 166 | SZ | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP10: Financial Reporting |
| 19 | F1002 | Multi-Site Consolidation Transfer File | 4 | GQ | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 20 | F1002Z1 | Unedited MSC Interoperability Table | 4 | SZ | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 21 | F1003 | Multi-Site Consolidation Transfer File - Category Codes | 4 | GR | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 22 | F10UI006 | MSC - F1002 Elimination Work File | 5 | GE | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP47: Electronic Commerce |
| 23 | F47057 | EDI Payment Order Remittance Advice - Outbound | 106 | D3 | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 24 | F47057W | EDI Payment Order Remittance Advice - Work | 106 | D3 | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP74: EMEA Localization |
| 25 | F7400006 | Processed Documents in Legal Applications - COMM - 00 | 6 | PD | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 26 | F7400C2A | French VAT on A/R | 2 | FC | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 27 | F7400C3 | French VAT on A/P | 2 | TG | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP74P: Poland |
| 28 | F74P03BW | A/R Trial Balance - POL - 03B - 74P | 17 | P3 | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 29 | F74P04W | A/P Trial Balance Work Table - POL - 04 - 74P | 18 | P2 | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 30 | F74P3B23 | A/R Fee Journal History Detail for Poland - POL - 03B | 2 | HD | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP74R: CIS |
| 31 | F74R0018 | Russian Tax File - 74R | 66 | TD | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 32 | F74R311 | Prepayment Detail Tax File - RUS - 03B | 7 | DE | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 33 | F74R3B14 | F03B14 Tag File - RUS - 03B - 74R | 2 | TF | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 34 | F74R4014 | F0414 Tag File - RUS - 04 - 74R | 2 | TF | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP74U: United Kingdom Localizations |
| 35 | F74U0445 | SPC Accounts Payable Match Doc Detail Tag File - UK - 43 | 2 | RN | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP74Y: Italy - Reporting System Only |
| 36 | F743B14I | Suspended IVA Generation - Receipt/Rebate Control-Ita - 03B | 3 | TI | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP75A: Australia - Reporting System Only |
| 37 | F75A200 | GST - Tax Invoice / Adjustment Note Tag file | 2 | TF | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP75I: India |
| 38 | F75I611 | TCS Prepayment Transaction File - IND-03B | 6 | TT | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 39 | F75I732 | Service Tax A/R File Additional Info - IND - 03B | 7 | ST | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 40 | F75I734 | Service Tax Received File - IND - 03B | 2 | PF | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 41 | F75I742 | Service Tax A/P File Additional Info - IND - 04 | 8 | ST | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 42 | F75I744 | Service Tax Payment File - IND - 04 | 2 | PF | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 43 | F75I754 | Advance Service Tax Payment File - IND -04 | 2 | AP | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 44 | F75IUI7 | Service Tax Credit Register - Work File - IND | 2 | WF | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP76A: Argentina |
| 45 | F760414A | A/P Payment Detail Tag Table - ARG - 04 - 76A | 2 | V1 | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 46 | F76A414P | Purge - A/P Payment Detail - ARG - 04 - 76A | 2 | V1 | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 47 | F76A8500 | Tag File F03B14 - ARG - 03B - 76A | 2 | TF | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 48 | F76AUI81 | Draft - Invoices Work File - ARG - 03B - 76A | 33 | WF | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 49 | F76AUI83 | Draft - Application Drafts - Invoices Work File - ARG - 76A | 8 | WF | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP76B: Brazil - Reporting System Only |
| 50 | F76B12TE | NF-e Status Log - BRA - 76B | 5 | SL | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 51 | F76B8602 | IN86-Work Table for Suppliers and Customers - 04 | 21 | PR | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP76C: Colombia |
| 52 | F76C034A | A/R Check Detail file As Of - COL - 03B | 3 | RZ | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 53 | F76C4F01 | DIAN Formats File by Payment - COL - 04 | 3 | FP | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP76H: Chile |
| 54 | F76H402 | Chilean A/P Doc Lines Print Mark - CHI - 04 - 76H | 2 | LP | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP76M: Mexico |
| 55 | F76M0314 | Receipt Detail Tag File - Mexico | 2 | MA | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 56 | F76M0414 | F0414 - Payment Detail Tag File - Mexico | 2 | RT | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 57 | F76M414 | A/P Matching Detail Withholding Information - MEX - 04 | 2 | MW | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 58 | F76M930 | AR VAT on Gain/loss MEX - 76M | 2 | AP | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 59 | F76M940 | AP VAT on Gain/loss - MEX - 76M | 2 | AP | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| 60 | F76M990 | GL VAT on Gain/loss MEX - 76M | 19 | GL | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP76P: Peru |
| 61 | F76P414T | F0414 Tag File - PER - 04 - 76P | 2 | P4 | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
| TOP89: Conversion Programs |
| 62 | F0086 | Conversion Audit File for Euro Conversion | 5 | AU | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
