| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0911 | Account Ledger | 42 | GL | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP03: Accounts Receivable |
| 2 | F0311 | Accounts Receivable Ledger | 75 | RP | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 3 | F03B11 | Customer Ledger | 70 | RP | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 4 | F03B112 | Invoice Revisions | 6 | RW | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 5 | F03B112P | Invoice Revisions Purge File | 6 | RW | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 6 | F03B11P | Customer Ledger Purge File | 70 | RP | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 7 | F03B11Z1 | Batch Invoices | 86 | VJ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 8 | F03B11Z2 | F03B11 Interoperability Table | 83 | SY | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 9 | F03B14 | Receipts Detail | 80 | RZ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 10 | F03B14P | Receipts Detail Purge File | 80 | RZ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 11 | F03B14Z2 | F03B14 Interoperability Table | 93 | SZ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 12 | F03B40 | A/R Deduction Management | 14 | RB | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 13 | F03B575 | Auto Debit Invoice Select and Build | 79 | RD | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 14 | F09UI011 | Receipt Prepost Work File | 46 | GL | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP04: Accounts Payable |
| 15 | F0411 | Accounts Payable Ledger | 58 | RP | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 16 | F0411A | WF - 'As Of' Accounts Payable Ledger | 58 | RP | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 17 | F0411P | Purge - Accounts Payable Ledger | 58 | RP | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 18 | F0411Z1 | Voucher Transactions - Batch Upload | 76 | VL | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 19 | F0411Z3 | F0411 Interoperability Table | 81 | SZ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 20 | F09UI005 | Tax Offsets User Index | 51 | GL | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP09: General Accounting |
| 21 | F0911P | Purge - Account Ledger | 42 | GL | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 22 | F0911Z1 | Journal Entry Transactions - Batch File | 59 | VN | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 23 | F0911Z4 | F0911 Interoperability Table | 64 | SZ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 24 | F09UI015 | Indexed Computations Multi-Tiered Entries | 42 | GL | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP15: Real Estate Management |
| 25 | F1511 | Tenant/Lease Billings Detail | 82 | NJ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 26 | F1511B | Lease Billings Master | 78 | NJ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 27 | F1511H | Tenant/Lease Billings Detail History | 81 | N# | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 28 | F1511HB | Lease Billings History | 77 | NC | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP40: Inventory/OP Base |
| 29 | F4011Z | Batch Receiver File - Order Details | 118 | SZ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 30 | F4211Z1 | Sales Order Detail Unedited Transaction File | 112 | SZ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP42: Sales Management |
| 31 | F4211 | Sales Order Detail File | 99 | SD | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 32 | F42119 | Sales Order History File | 99 | SD | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 33 | F42199 | S.O. Detail Ledger File | 99 | SL | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 34 | F42565 | Invoice Print File | 166 | IW | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 35 | F42800G1 | Sales Update G Batch Detail Workfile | 83 | DG | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 36 | F42UI11 | SO Detail Cache File (MBF) | 77 | ZD | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP44H: Homebuilder Management |
| 37 | F44H611W | Bid Details Work File | 8 | BW | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP45: Advanced Pricing |
| 38 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 146 | Z1 | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP47: Electronic Commerce |
| 39 | F47012 | EDI Purchase Order Detail - Inbound | 119 | SZ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 40 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 119 | SZ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 41 | F47037 | EDI Shipping Notice Detail - Outbound | 109 | SZ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 42 | F470371 | EDI Shipping Notice Detail - Outbound | 125 | SZ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 43 | F47047 | EDI Invoice Detail (Sales) - Outbound | 119 | SZ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 44 | F47057 | EDI Payment Order Remittance Advice - Outbound | 43 | D3 | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 45 | F47057W | EDI Payment Order Remittance Advice - Work | 43 | D3 | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 46 | F47092 | EDI Request for Quote Detail - Inbound | 119 | SZ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 47 | F47107 | EDI Response to RFQ Detail - Outbound | 119 | SZ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 48 | F47132 | EDI Purchase Order Change Detail - Inbound | 120 | SZ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 49 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 121 | SZ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP48S: Service Billing |
| 50 | F4812 | Billing Detail Workfile | 23 | WD | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 51 | F4812H | Billing Workfile History | 23 | WD | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 52 | F4812HS | Billing Workfile History Purged Save | 23 | WD | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 53 | F48SUI01 | Billing Detail Print Workfile | 23 | WD | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP49: Transportation Management |
| 54 | F4981 | Freight Audit History | 42 | FH | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP70: Multi-National Products |
| 55 | F704001 | Payment WH Info TEMP - COMM - 04 | 8 | PT | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 56 | F704002 | Payment WH Info - COMM - 04 | 7 | PF | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 57 | F704002P | Payment WH Info Purge - COMM - 04 | 7 | PF | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP74: EMEA Localization |
| 58 | F7430015 | Invoices Related to AR DN/CN - COMM - 03B | 6 | DR | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP74H: Hungary |
| 59 | F74H309 | Gains & Losses Unrealized Account ing - HUN - 03B | 6 | GL | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 60 | F74H409 | A/P Gains & Losses Unrealized Accounting - HUN - 04 | 6 | GL | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP74P: Poland |
| 61 | F74P411H | F0411 Header File - POL - 04 - 74P | 5 | P4 | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP74R: Russia |
| 62 | F74R0401 | Adjustment to Voucher - RUS - 04 - 74R | 4 | AD | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 63 | F74R0402 | Correction to Voucher - RUS - 04 - 74R | 6 | CO | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 64 | F74R3037 | Adjustment Invoice Relationship in AR/SOP - RUS - 74R | 6 | AR | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP74Y: Italy |
| 65 | F74Y015 | Yearly List Declaration - WF - IT - 00 | 28 | YL | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 66 | F74Y018 | Intrastat Additional Info for Services - ITA - 00 | 15 | IA | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 67 | F74Y171 | Contract Relations - IT - 00 | 16 | CR | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 68 | F74Y315 | Invoices Related to AR DN/CN - ITA - 03B | 7 | RI | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 69 | F74Y415 | Vouchers Related to AP DN/CN - ITA - 04 | 8 | RV | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP74Z: Czech Republic |
| 70 | F74Z0010 | Cash Desk Document Printed - CZE - 74Z | 7 | ZO | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP75I: India |
| 71 | F75I3574 | Consignment - Issues/Receipts Transactions | 25 | CT | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 72 | F75I3576 | Stock Transfer - Work Orders | 10 | SW | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 73 | F75I380 | Excise - RG-1 - Transaction File - IND | 19 | RG | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 74 | F75I411 | F0411 Tag File - IN - 04 | 14 | TF | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP75T: Taiwan |
| 75 | F75T004Z | GUI/VAT Transaction Header - Work - 75T | 5 | ZH | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 76 | F75T005Z | GUI/VAT Transaction Detail - Work - 75T | 5 | ZD | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP76A: Argentina |
| 77 | F76A0209 | Header & Footer Invoice/ShipmentNote History WF - ARG - 76A | 41 | HF | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 78 | F76A020P | Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A | 41 | HF | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 79 | F76A81 | A/P Payment Control Group File - ARG - 04 - 76A | 24 | C5 | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 80 | F76A82 | A/P Payment Control Group File - ARG - 04 - 76A | 35 | C6 | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 81 | F76AUI20 | Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A | 41 | HF | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP76B: Brazil |
| 82 | F76B0411 | Voucher Additional Information Brazil - 04 | 25 | VB | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 83 | F76B473T | F04573 Brazilian Temp WH File - BR - 04 | 29 | W3 | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP76C: Colombia |
| 84 | F76C031A | A/R Customer ledger As Of - F76C031A - COL - 04 | 69 | RP | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 85 | F76C034A | A/R Check Detail file As Of - COL - 03B | 79 | RZ | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 86 | F76C575 | Work File Magnetic Media - COL - 04 | 46 | Q1 | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP76H: Chile |
| 87 | F76H3B15 | NC/ND - Invoice Related - CHI - 03B - 76H | 6 | IR | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 88 | F76H3B20 | Invoices not Printed - CHI - 03B - 76H | 14 | AD | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 89 | F76HUI31 | Document Related Work File - CHI - 42 - 76H | 8 | DR | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP76M: Mexico |
| 90 | F76M0314 | Receipt Detail Tag File - Mexico | 13 | MA | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 91 | F76M0414 | F0414 - Payment Detail Tag File - Mexico | 14 | RT | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 92 | F76M990 | GL VAT on Gain/loss MEX - 76M | 23 | GL | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP76P: Peru |
| 93 | F76P411T | Peru AP Tag File - PER - 04 - 76P | 21 | T4 | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 94 | F76P480 | SPOT Voucher Information - PER - 04 - 76P | 6 | SV | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| TOP76V: Venezuela |
| 95 | F76V4015 | Vouchers Related to Credit/Debit Notes - VEN - 04 | 6 | CD | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
| 96 | F76V4581 | Withholding Historical File - VEN - 04 | 13 | HR | ODOC | Document - Original | Numeric | Generic Edit | 8 | 0 |
