| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP03B: Enhanced Accounts Receivable |
1 | F03B14 | A/R Check Detail File | 2 | RZ | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
2 | F03B14P | Receipts Detail Purge File | 2 | RZ | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
3 | F03B14Z2 | F03B14 Interoperability Table | 15 | SZ | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
4 | F03B21 | A/R Notification History Detail | 2 | ZS | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
5 | F03B23 | A/R Fee Journal History Detail | 2 | RT | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
6 | F03B40 | A/R Deduction Management | 23 | RB | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
TOP04: Accounts Payable |
7 | F0414 | Accounts Payable Matching Document Detail | 2 | RN | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
8 | F0414A | WF - As Of - Accounts Payable Payment Detail | 2 | RN | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
9 | F0414P | Purge - Accounts Payable Matching Document Detail | 2 | RN | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
10 | F0414Z1 | F0414 Interoperability Table | 15 | SZ | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
TOP10: Financial Reporting |
11 | F1002 | Multi-Site Consolidation Transfer File | 4 | GQ | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
12 | F1002Z1 | Unedited MSC Interoperability Table | 4 | SZ | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
13 | F1003 | Multi-Site Consolidation Transfer File - Category Codes | 4 | GR | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
14 | F10UI006 | MSC - F1002 Elimination Work File | 5 | GE | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
TOP47: Electronic Commerce |
15 | F47057 | EDI Payment Order Remittance Advice - Outbound | 106 | D3 | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
16 | F47057W | EDI Payment Order Remittance Advice - Work | 106 | D3 | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
TOP55: Reserved for Clients |
17 | F74W300 | A/R Fee Journal History Detail Tag File - 74W | 2 | RU | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
TOP74: EMEA Localization |
18 | F7400006 | Processed Documents in Legal Applications - COMM - 00 | 6 | PD | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
19 | F7400C2A | Tag file for R7400C2-French VAT on A/R | 2 | FC | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
20 | F7400C3 | R7400C3 Work File | 2 | TG | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
TOP74P: Poland |
21 | F74P03BW | A/R Trial Balance - POL - 03B - 74P | 17 | P3 | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
22 | F74P04W | A/P Trial Balance Work Table - POL - 04 - 74P | 18 | P2 | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
23 | 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 |
24 | F74R0018 | Russian Tax File - 74R | 66 | TD | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
25 | F74R3B14 | F03B14 Tag File - RUS - 03B - 74R | 2 | TF | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
26 | F74R4014 | F0414 Tag File - RUS - 04 - 74R | 2 | TF | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
TOP74Y: Italy - Reporting System Only |
27 | F743B14I | Suspended IVA Generation - Receipt/Rebate Control-Italy | 3 | TI | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
TOP75A: Australia - Reporting System Only |
28 | F75A200 | GST - Tax Invoice / Adjustment Note Tag file | 2 | TF | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
TOP76A: Argentina |
29 | F760414A | A/P Payment Detail Tag File - ARG - 04 | 2 | V1 | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
30 | F76A414P | Purge - A/P Payment Detail - ARG - 04 - 76A | 2 | V1 | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
31 | F76A8500 | Tag File F03B14 - ARG - 03B - 76A | 2 | TF | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
32 | F76AUI81 | Draft - Invoices Work File - ARG - 03B - 76A | 33 | WF | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
33 | 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 |
34 | F76B8602 | IN86-Work Table for Suppliers and Customers - 04 | 21 | PR | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
TOP76C: Colombia |
35 | F76C034A | A/R Check Detail file As Of - COL - 76C | 3 | RZ | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
TOP76H: Chile |
36 | 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 |
37 | F76M0314 | Receipt Detail Tag File - Mexico | 2 | MA | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
38 | F76M0414 | F0414 - Payment Detail Tag File - Mexico | 2 | RT | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
TOP76P: Peru |
39 | F76P414T | F0414 Tag File - PER - 04 - 76P | 2 | P4 | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |
TOP89: Conversion Programs |
40 | F0086 | Conversion Audit File for Euro Conversion | 5 | AU | RC5 | File Line Identifier 5.0 | Numeric | Generic Edit | 5 | 0 |