| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F0006Z1 | Cost Center Unedited Transaction Table | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 2 | F0048 | Code Mappings Master | 5 | CM | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 3 | F0401Z1 | Supplier Master - Batch File | 9 | VO | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP01: Address Book |
| 4 | F0101Z2 | Address Book - Interoperability | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 5 | F01111Z1 | Batch - Contact Information | 9 | CB | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 6 | F01112Z1 | Batch - Related Person | 9 | PB | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 7 | F0111Z1 | Batch Who's Who Information | 9 | BW | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 8 | F01151Z1 | Batch - Electronic Address | 9 | EB | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 9 | F0115Z1 | Phones - Interoperability | 10 | PI | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 10 | F01161Z1 | Batch - Alternative Address | 9 | LB | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP03: Accounts Receivable |
| 11 | F03012Z1 | Customer Master LOB-Batch File | 9 | VO | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP03B: Enhanced Accounts Receivable |
| 12 | F03B11Z2 | F03B11 Interoperability Table | 9 | SY | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 13 | F03B13Z2 | F03B13 Interoperability Table | 9 | SY | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 14 | F03B14Z2 | F03B14 Interoperability Table | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 15 | F03B41Z1 | Inteoperability - Deductions Management | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP04: Accounts Payable |
| 16 | F0411Z3 | F0411 Interoperability Table | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 17 | F0413Z1 | F0413 Interoperability Table | 9 | SY | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 18 | F0414Z1 | F0414 Interoperability Table | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP05A: OW HR & PR Foundation |
| 19 | F060116Z | Unedited Quick Hire Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP09: General Accounting |
| 20 | F0911Z4 | F0911 Interoperability Table | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP10: Financial Reporting |
| 21 | F1001Z1 | Unedited MSC Interoperability Header Table | 9 | IA | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 22 | F1002Z1 | Unedited MSC Interoperability Table | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP11: Multi Currency |
| 23 | F0015Z1 | External Currency Exchange Rates | 9 | ZE | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP12: Fixed Assets |
| 24 | F1201Z1 | Unedited Asset Master Transactions | 9 | FA | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 25 | F1217Z1 | Unedited Equipment Tag Transactions | 9 | WR | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 26 | F1217Z2 | Unedited Equipment Tag Transactions | 9 | WR | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP13: Plant/Equipment Management |
| 27 | F12120Z1 | Unedited Meter Reading Transactions | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP13C: Condition-Base Maintenance |
| 28 | F1310Z1 | Unedited Condition-Based Alerts | 9 | CB | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP16: Profit Management (EPS) |
| 29 | F1602Z1 | External Cost Analyzer Balances - Interoperability Table | 9 | CZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 30 | F1632Z1 | External Driver Balances-Interoperability Table | 9 | CY | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP17: Customer Service Management |
| 31 | F3111Z2 | Warranty Claim/Supplier Recovery processing | 9 | WP | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 32 | F3112Z2 | Warranty Claim/Supplier Recovery processing | 9 | WL | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 33 | F4801TZ2 | Warranty Claim/Supplier Recovery processing | 9 | WQ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 34 | F4801Z2 | Warranty Claim/Supplier Recovery processing | 9 | WS | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP30: Product Data Management |
| 35 | F0007Z1 | Work Day Calendar Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 36 | F30006Z1 | Work Center Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 37 | F3002Z1 | Bill of Material Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 38 | F3003Z1 | Routing Transactions File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP31: Shop Floor Control |
| 39 | F30161Z1 | Inbound Kanban Card Detail | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 40 | F3111Z1 | Outbound Work Order Parts List | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 41 | F31122Z1 | Work Order Time Transactions Unedited Transaction Table | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 42 | F3112Z1 | Outbound Work Order Routings | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 43 | F4801Z1 | Outbound Work Order Header | 9 | SY | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP31B: Blend Management |
| 44 | F31B17Z1 | Operation EUR Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 45 | F31B18Z1 | VBT Barrel Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 46 | F31B19Z1 | Instructed Attributes Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 47 | F31B31Z1 | Operations Composition Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 48 | F31B34Z1 | Operations Style Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 49 | F31B3CZ1 | Operations Cost Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 50 | F31B52Z1 | Operations Equipment Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 51 | F31B53Z1 | Operations Consumables Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 52 | F31B65Z1 | Operations Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 53 | F31B93Z1 | WIM Work Order Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 54 | F31B97Z1 | Operations Resource Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 55 | F31BQAZ1 | Operations Quality Test Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP36: Forecasting |
| 56 | F3460Z1 | Forecast Unedited Transactions | 9 | FT | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP37: Quality Management |
| 57 | F3711Z1 | Test Results Unedited Transaction Table | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP40: Inventory/OP Base |
| 58 | F4106NC | Base Price Extraction | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 59 | F4201Z1 | Sales Order Header Unedited Transaction File | 9 | SY | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 60 | F4211Z1 | Sales Order Detail Unedited Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 61 | F49211Z1 | Sales Order Detail Tag Unedited Transaction File | 9 | S1 | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP41: Inventory Management |
| 62 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 63 | F4101Z1A | F4101 Detail Item Master Unedited Transaction | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 64 | F41021Z1 | Item Location Unedited Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 65 | F4105Z1 | Unedited Transaction Table - Item Cost | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 66 | F4141Z1 | F4141 Cycle Count Unedited Transaction Table | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP43: Procurement |
| 67 | F4301Z1 | Purchase Order Header Unedited Transaction Table | 9 | SY | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 68 | F43092Z1 | Receipt Routing Unedited Transaction Table | 11 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 69 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 70 | F43121Z1 | Receipts Unedited Transaction Table | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP44H: Homebuilder Management |
| 71 | F44H101Z | HB Community Master Unedited Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 72 | F44H201Z | HB Lot Master Unedited Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 73 | F44H501Z | HB Sales Master Unedited Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 74 | F44H604Z | HB Vendor Assignment Unedited Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 75 | F44H711Z | HB Lot Start Unedited Transaction File | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP45: Advanced Pricing |
| 76 | F4572Z1 | Live Promotions Interface - Inbound / Outbound | 16 | LP | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 77 | F4572ZP | Purge Live Promotions Interface | 16 | PG | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 78 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 9 | Z1 | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP46: Warehouse Management |
| 79 | F4611Z1 | Unedited Suggestion Table | 9 | SZ | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 80 | F4942Z1 | Work File for F4942 | 9 | SY | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP47: Electronic Commerce |
| 81 | F47002 | Flat File Cross-Reference Table | 2 | SV | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| TOP76B: Brazil - Reporting System Only |
| 82 | F76B472 | Dynamic Formater Layout Transaction and Line Types - 03B | 2 | DD | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 83 | F76B473 | Dynamic Formater Layouts Specification - 03B | 2 | DS | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
| 84 | F76B474 | Dynamic Formater Bank Attributes - 03B | 3 | BA | DRIN | Direction Indicator | Character | UDC | 1 | 0 |
