| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0040Z1 | Error Message Log Table | 1 | ZB | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 2 | F0041Z1 | Transaction Control File | 1 | ZF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 3 | F00UI391 | Generated Document Work Table | 1 | GW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 4 | F00UI392 | Text Substitution Work Table | 2 | GW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 5 | F00UI393 | Bookmark Work Table | 1 | GW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 6 | F03BUI05 | Auto Receipts Batch Workfile | 1 | R5 | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP04: Accounts Payable |
| 7 | F04UI006 | 1099 Workfiles User Index | 6 | G1 | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP09: General Accounting |
| 8 | F0902Z1 | Account Balances - Batch File | 9 | GB | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 9 | F09UI008 | Global Business Unit Change | 1 | GM | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 10 | F09UI009 | Trial Balance Generic Work File - OneWorld ONLY | 2 | GB | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP15L: Adv Real Estate Forecasting |
| 11 | F15L302 | AREF Prior Gross Billings | 1 | PG | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP16: Profit Management (EPS) |
| 12 | F16UI001 | Enabled Tables by Application work file | 1 | CA | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP30: Product Data Management |
| 13 | F30UI008 | Bill of Material Comparison Work File | 2 | IJ | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP31: Shop Floor Control |
| 14 | F31UI002 | User Index - Variances | 21 | IG | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 15 | F31UI006 | Line Scheduling Workbench - Work File | 1 | LS | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 16 | F31UI427 | Labor Variance User Index | 2 | W1 | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 17 | F31UI802 | Accumulate Amounts by Account | 14 | WG | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 18 | F31UI803 | Work File for Summarizing Journal Entries | 14 | SG | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 19 | F31UI804 | Exception Report Work FIle | 12 | WR | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP31B: Blend Management |
| 20 | F31B33DC | Dependency Chain Cache Structure | 2 | DT | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP32: Configuration Management |
| 21 | F32UI002 | External Data Item Work File | 1 | WY | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP33: Capacity Planning |
| 22 | F33UI001 | Shop Floor Control Routing Instructions | 24 | WL | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP34: Requirements Planning |
| 23 | F34UI003 | MPS Time Series User Index | 60 | M8 | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 24 | F34UI004 | MPS Net Change User Index | 2 | M8 | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 25 | F34UI005 | MRP Orders/Requirements User Index-Process Item | 2 | F5 | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 26 | F34UI006 | MRP Co/By Product Net Quantity User Index | 2 | W6 | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP35: Enterprise Facility Planning |
| 27 | F35UI001 | MPS/MRP Planning - Multiple Plant User Index | 2 | MA | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP40: Inventory/OP Base |
| 28 | F30UI001 | Component Locators Work File | 1 | WF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 29 | F30UI002 | Bill of Material Structure Analysis Work File | 4 | IX | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 30 | F30UI004 | Bill of Material Update Work File | 1 | WF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 31 | F30UI006 | Lot Tracking Work File | 1 | IL | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 32 | F40UI00T | Tax Work File | 28 | PN | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 33 | F40UI16 | Preference Print Message Work File | 1 | DS | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 34 | F40UI17 | Allocation Work File | 1 | ZG | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 35 | F40UI74 | Price Adjustment History Work File | 1 | AW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 36 | F40UI801 | Generic Error Table | 1 | ZB | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP40R: Demand Scheduling |
| 37 | F40R12WF | CUM Rollback Workfile | 2 | CQ | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 38 | F40R30WF | Demand Work File | 1 | DS | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 39 | F47UI002 | ASN Extract Packaging Work File | 1 | SP | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP40S: Supply Chain Self Service |
| 40 | F4947SW | Self-Service Shipment Tracking Work File | 2 | SW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP41: Inventory Management |
| 41 | F41021WF | F41021 Transaction Workfile | 2 | LW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 42 | F41291Z | Landed Cost Cache Table | 1 | IG | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 43 | F41UI001 | Inventory Transactions Detail File | 1 | IT | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 44 | F41UI003 | ABC Analysis Detail - Work File | 1 | AA | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP42: Sales Management |
| 45 | F42565 | Invoice Print File | 1 | IW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 46 | F42A011 | Campaigns | 41 | CA | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 47 | F42A012 | Opportunity | 41 | OP | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 48 | F42CSS | Customer Self Service Workfile | 9 | CS | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 49 | F42UI005 | Sales Commission File | 54 | SC | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 50 | F42UI01 | SO Header Cache File (MBF) | 1 | ZH | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 51 | F42UI11 | SO Detail Cache File (MBF) | 1 | ZD | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 52 | F42UI11C | Customer Self Service Shopping Cart Workfile | 1 | SC | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 53 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 1 | ZD | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 54 | F42UI130 | Commitment Work File | 3 | ZC | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 55 | F42UI150 | Sales Order Header Commission Information Work File | 2 | ZH | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 56 | F42UI160 | Sales Order Detail Commission Information Work File | 2 | ZD | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 57 | F42UI520 | Pick Slips Header File | 52 | S8 | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 58 | F42UI521 | Pick Slips Detail File | 135 | S9 | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 59 | F42UI800 | Sales Detail Work File - Sales Update | 1 | SD | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP42B: Sales Order Entry |
| 60 | F42UI440 | Customer Segment Items - Work File | 15 | CS | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP43: Procurement |
| 61 | F40910 | Commitment Integrity Report Work File | 2 | P# | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 62 | F4301Z | PO Header Work File | 1 | PA | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 63 | F43092Z | Receipt Routing Work File | 1 | PV | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 64 | F4311Z | Purchase Order Generator File | 1 | PW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 65 | F43121Z | Receiver workfile | 9 | PW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 66 | F4314Z | Voucher Match Selection File | 1 | PN | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 67 | F43632Z | Open Purchase Order by Item Work File | 4 | OI | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 68 | F4371 | Suggested Reorder Stock Items | 27 | PD | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 69 | F43UI50D | PO Print Detail Work File | 68 | PW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 70 | F43UI50H | PO Print Header Work File | 63 | PA | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP45: Advanced Pricing |
| 71 | F4072W | Price Adjustment Detail Work File | 37 | AD | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 72 | F40UI84 | Orders Affected by Price Change (Work-file) | 6 | XR | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 73 | F4511W | Pricing Structure View | 1 | AP | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 74 | F45511W | Search Agent Directives Work File | 1 | SW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP46R: RFID Outbound |
| 75 | F46R010 | EPC Segment Definition | 16 | SD | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 76 | F46R020 | EPC Manager Master | 16 | EM | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP47: Electronic Commerce |
| 77 | F47003 | EDI Discrepancy Report Work File | 1 | SX | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 78 | F47UI001 | ASN Extract Work File | 1 | SZ | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP48: Work Order Processing |
| 79 | F48UI001 | X4801 Master Business Function Workfile | 2 | WA | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP49: Transportation Management |
| 80 | F49110 | Transportation Bill of Lading Workfile | 6 | BW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 81 | F49111 | Carton Detail Shipment Workfile | 6 | CD | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 82 | F49130 | Shipment Document Workfile | 4 | BW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 83 | F49140 | SSCC Print Label Workfile | 4 | BW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 84 | F49141 | Packing List Workfile | 4 | PW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP74W: Sweden - Reporting System Only |
| 85 | F74W210 | A/P Automatic Payments Spot Rate - 74W | 8 | K5 | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP76A: Argentina |
| 86 | F76A0209 | Header and Footer Invoice/ShipmentNote History WF - ARG - 76A | 2 | HF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 87 | F76A020P | Header/Footer Inv./ShipmentNote History WF Purge - AR - 76A | 2 | HF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 88 | F76A0219 | Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A | 2 | DL | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 89 | F76A021P | Detail Lines Inv./ShipmentNote History WF Purge - ARG - 76A | 2 | DL | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 90 | F76A20 | Credit Invoice Constants - ARG - 03B - 76A | 23 | IC | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 91 | F76A21 | Credit Invoice Header - F76A21 - ARG - 3B - 76A | 26 | IH | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 92 | F76A21P | Credit Invoice Header Purge - ARG - 03B - 76A | 26 | IH | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 93 | F76A22 | Credit Invoice Detail - F76A22 - ARG - 03B - 76A | 20 | ID | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 94 | F76A22P | Credit Invoice Detail Purge - ARG - 03B - 76A | 20 | ID | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 95 | F76A23 | Credit Invoice Withholdings - F76A23 - ARG - 03B - 76A | 14 | IW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 96 | F76A23P | Credit Invoice Withholdings Purge - ARG - 03B - 76A | 14 | IW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 97 | F76A24 | Credit Invoice Information - Accounts Payable - ARG - - 76A | 35 | IE | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 98 | F76A25 | Credit Invoice Tax Area Relationship - ARG - 04 - 76A | 13 | IF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 99 | F76A26 | Credit Invoice Status Rules - ARG - 04 - 76A | 14 | IG | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 100 | F76A8230 | Percentages by state / agreement Gross Income - ARG - - 76A | 14 | C1 | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 101 | F76A8231 | States members by Multilateral Agreement Gross Inc AR - 76A | 3 | C2 | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 102 | F76A8500 | Tag File F03B14 - ARG - 03B - 76A | 38 | TF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 103 | F76A8510 | Tag File F76A60 - ARG - 03B - 76A | 25 | TF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 104 | F76A85Z1 | Tag File F76A60 Batch Entry - ARG - 03B - 76A | 30 | BE | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 105 | F76AUI18 | Taxes - Tax amount by order line - Work File - ARG - 42 | 2 | WF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 106 | F76AUI20 | Header and Footer Invoice/ShipmentNote Workfile - ARG - - 00 | 2 | HF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 107 | F76AUI21 | Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 00 | 2 | DL | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 108 | F76AUI22 | WF - Legal Reports Errors - ARG - 00 | 2 | WF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 109 | F76AUI23 | Taxes - Totals by Tax Code - ARG | 2 | TW | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 110 | F76AUI24 | Taxes Work File - ARG - 00 | 22 | TI | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 111 | F76AUI81 | Draft - Invoices Work File - ARG - 03B - 76A | 42 | WF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 112 | F76AUI82 | Draft - Drafts Work File - ARG - 03B - 03B | 33 | WF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 113 | F76AUI83 | Draft - Application Drafts - Invoices Work File - ARG - 76A | 48 | WF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 114 | F76AUI89 | Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A | 2 | WF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 115 | F76AUI98 | Cost Account Work Table - Work in Progress Adjustment - 76A | 2 | CA | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP76C: Colombia |
| 116 | F76C311T | A/R Tag File - Recycle Recurring - COL - 03B - 76C | 5 | RP | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 117 | F76CUI04 | Tax Detail for Distribution - Work File - COL - 76C | 65 | TD | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP76E: Ecuador |
| 118 | F76E0018 | Print Withholding Workfile - EC - 04 | 2 | TD | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP76H: Chile |
| 119 | F76HUI31 | Document Related Work File - CHI - 42 - 76H | 1 | DR | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 120 | F76HUI32 | Workfile for R76H3B40 - CHI - 42 - 76H | 1 | WF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 121 | F76HUI33 | Workfile for R76H3B40 - CHI - 42 - 76H | 1 | WF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 122 | F76HUI34 | Order Related Work File - CHI - 42 - 76H | 2 | OR | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 123 | F76HUI52 | Document Selection Work File - CHI - 42 - 76H | 1 | DR | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| 124 | F76HUI61 | Cache F76H3B1Z EDI Tag File - CHI - 03B - 76H | 2 | ZT | CTID | Computer ID | String | Generic Edit | 15 | 0 |
| TOP76P: Peru |
| 125 | F76PUI45 | Workfile VAT Purchasing Ledger - PER - 04 - 76P | 1 | WF | CTID | Computer ID | String | Generic Edit | 15 | 0 |
