| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F40081 | Alternate Tax Rate/Area Definition | 18 | EU | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 2 | F007101 | Text Processor Header | 12 | TA | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 3 | F007111 | Text Processor Detail Table | 6 | TB | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 4 | F03B11 | Customer Ledger | 117 | RP | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 5 | F03B11P | Customer Ledger Purge File | 117 | RP | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 6 | F03B11Z1 | Batch Invoices | 131 | VJ | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 7 | F03B13 | Receipts Header | 72 | RY | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 8 | F03B13P | Receipts Header Purge File | 72 | RY | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 9 | F03B14 | Receipts Detail | 118 | RZ | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 10 | F03B14P | Receipts Detail Purge File | 118 | RZ | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 11 | F03B14Z2 | F03B14 Interoperability Table | 145 | SZ | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 12 | F03B575 | Auto Debit Invoice Select and Build | 126 | RD | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 13 | F03B672 | Draft Remittance | 70 | RD | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| TOP04: Accounts Payable |
| 14 | F0411 | Accounts Payable Ledger | 90 | RP | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 15 | F0411A | WF - 'As Of' Accounts Payable Ledger | 90 | RP | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 16 | F0411P | Purge - Accounts Payable Ledger | 90 | RP | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 17 | F0411Z1 | Voucher Transactions - Batch Upload | 108 | VL | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 18 | F0411Z3 | F0411 Interoperability Table | 142 | SZ | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| TOP10: Financial Reporting |
| 19 | F1001 | Multi-Site Consolidation Transfer File Header | 31 | GP | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 20 | F1001Z1 | Unedited MSC Interoperability Header Table | 41 | IA | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 21 | F1002 | Multi-Site Consolidation Transfer File | 38 | GQ | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 22 | F1002Z1 | Unedited MSC Interoperability Table | 47 | SZ | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| TOP15L: Adv Real Estate Forecasting |
| 23 | F15L301 | AREF Projected Sales | 26 | PS | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| TOP34: Requirements Planning |
| 24 | F3435 | Vendor Schedule Commitment File | 18 | MC | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 25 | F3440 | Vendor Schedule History File | 17 | MH | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 26 | F3450 | Adhoc Vendor Schedule File | 19 | MA | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| TOP41: Inventory Management |
| 27 | F4118 | Container Deposit File | 27 | CN | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 28 | F41181 | Container Transaction File | 34 | CM | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| TOP45: Advanced Pricing |
| 29 | F4077 | Rebate Thresholds | 25 | RT | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 30 | F4077P | Rebate Thresholds Purge | 26 | RT | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 31 | F4078 | Rebate Transaction Summary | 27 | RH | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 32 | F4079 | Rebate Transaction Detail | 26 | SV | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| TOP70: Multi-National Products |
| 33 | F704001 | Payment WH Info TEMP - COMM - 04 | 57 | PT | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 34 | F704002 | Payment WH Info - COMM - 04 | 56 | PF | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 35 | F704002P | Payment WH Info Purge - COMM - 04 | 56 | PF | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 36 | F704003 | Payment Done - Accum - COMM - 04 | 15 | PD | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 37 | F707111 | Text Processor Detail Table - 70 | 6 | TB | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| TOP74: EMEA Localization |
| 38 | F740018T | Tag File F0018 - EMEA - 74 | 7 | TF | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 39 | F74900 | Foreign Receivables and Payables - EMEA | 65 | RP | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| TOP74R: Russia |
| 40 | F74R0401 | Adjustment to Voucher - RUS - 04 - 74R | 8 | AD | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 41 | F74R0402 | Correction to Voucher - RUS - 04 - 74R | 9 | CO | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 42 | F74R3038 | Adjustment Invoice Header Info AR/SOP - RUS - 74R | 39 | AI | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 43 | F74R311 | Prepayment Detail Tax File - RUS - 03B | 42 | DE | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| TOP74U: United Kingdom Localizations |
| 44 | F74U0445 | SPC Accounts Payable Match Doc Detail Tag File - UK - 43 | 13 | RN | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| TOP75T: Taiwan |
| 45 | F75T001 | GUI/VAT Declaration Site - 75T | 38 | DS | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 46 | F75T001P | GUI/VAT Declaration Period - 75T | 10 | DP | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 47 | F75T002 | GUI/VAT Number Register - 75T | 14 | NR | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 48 | F75T0029 | GUI/VAT Number Register History - 75T | 14 | NR | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 49 | F75T003 | GUI/VAT Number Segment - 75T | 19 | NS | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 50 | F75T0039 | GUI/VAT Number Segment History - 75T | 19 | NS | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 51 | F75T004 | GUI/VAT Transaction Header - 75T | 100 | TH | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 52 | F75T0049 | GUI/VAT Transaction Header History - 75T | 100 | TH | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 53 | F75T004P | GUI/VAT Transaction Header POS - 75T | 101 | TH | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 54 | F75T005 | GUI/VAT Transaction Detail - 75T | 48 | TD | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 55 | F75T0059 | GUI/VAT Transaction Detail History - 75T | 48 | TD | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 56 | F75T005P | GUI/VAT Transaction Detail POS - 75T | 47 | TD | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 57 | F75T005T | GUI/VAT Transaction Detail Temp - 75T | 48 | TD | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 58 | F75T008 | GUI/VAT Tax Type Mapping - 75T | 5 | TM | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 59 | F75T009 | GUI/VAT Customer Constants - 75T | 17 | DV | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 60 | F75T0091 | GUI/VAT Supplier Constants - 75T | 13 | SD | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 61 | F75T010 | GUI/VAT User / Declaration Site Mapping - 75T | 9 | UM | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 62 | F75T012 | GUI/VAT GL Account Mapping - 75T | 7 | GL | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 63 | F75T403 | GUI/VAT Declaration Report 403 - 75T | 116 | D3 | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| TOP76A: Argentina |
| 64 | F760101A | A/B Tag Table - ARG - 04 - 76A | 22 | V0 | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 65 | F760411A | A/P Ledger Tag Table - ARG - 04 - 76A | 30 | B2 | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 66 | F760414A | A/P Payment Detail Tag Table - ARG - 04 - 76A | 33 | V1 | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 67 | F760473A | PCG Detail Information Tag Table - ARG - 04 - 76A | 31 | E5 | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 68 | F76A010Z | F0101Z2 Argentinean Tag Table - ARG - 01 - 76A | 25 | V9 | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 69 | F76A0209 | Header & Footer Invoice/ShipmentNote History WF - ARG - 76A | 80 | HF | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 70 | F76A020P | Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A | 80 | HF | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 71 | F76A0219 | Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A | 51 | DL | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 72 | F76A021P | Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A | 51 | DL | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 73 | F76A20 | Credit Invoice Constants - ARG - 03B - 76A | 14 | IC | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 74 | F76A24 | Credit Invoice Information - Accounts Payable - ARG - - 76A | 26 | IE | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 75 | F76A25 | Credit Invoice Tax Area Relationship - ARG - 04 - 76A | 4 | IF | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 76 | F76A26 | Credit Invoice Status Rules - ARG - 04 - 76A | 5 | IG | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 77 | F76A30 | F0411Z1 Tag Table - ARG - 04 - 76A | 29 | V8 | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 78 | F76A33 | Receipt Invoice - Audit Log ARG - 03B - 76A | 13 | X4 | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 79 | F76A392 | Calculated costs header - 76A | 11 | C2 | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 80 | F76A393 | Calculated costs detail - 76A | 22 | C3 | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 81 | F76A394 | Adjustments - 76A | 18 | C4 | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 82 | F76A411P | Purge A/P Tag Ledger Tag - ARG - 04 - 76A | 30 | B2 | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 83 | F76A414P | Purge - A/P Payment Detail - ARG - 04 - 76A | 33 | V1 | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 84 | F76A48 | CERG A/P - Control Payments -ARG - 04 - 76A | 4 | PI | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 85 | F76A49 | CERG A/R - Control Receipts - ARG - 03B - 76A | 4 | CR | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 86 | F76A7101 | Batch for Remittance - ARG - 03B - 76A | 9 | TA | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 87 | F76A8011 | Supplier Information RG 726 - ARG - 04 - 76A | 15 | PA | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 88 | F76A8090 | V.A.T. Witholding Percentage Rg726 - ARG - 04 - 76A | 14 | VP | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 89 | F76AUI04 | A/P Legel Tax Tag Table - ARG - 04 - 76A | 30 | WC | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 90 | F76AUI20 | Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A | 80 | HF | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 91 | F76AUI21 | Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A | 51 | DL | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 92 | F76AUI46 | CERG A/R -Work File - ARG - 03B - 76A | 16 | WF | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| TOP76C: Colombia |
| 93 | F76C0101 | A/B Tag File - COL - 76C | 14 | V0 | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 94 | F76C0411 | A/P Tag File - COL - 76C | 18 | RP | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| TOP76P: Peru |
| 95 | F76P480 | SPOT Voucher Information - PER - 04 - 76P | 12 | SV | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| TOP76V: Venezuela |
| 96 | F76V0311 | Exportation Number - VEN - 76V | 5 | TF | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
| 97 | F76V4581 | Withholding Historical File - VEN - 04 | 25 | HR | URC1 | User Reserved Code | String | Generic Edit | 3 | 0 |
