| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP00: Foundation Environment |
| 1 | F004201 | Prepayment Transaction Table | 42 | PT | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| TOP32: Configuration Management |
| 2 | F3201 | Configurator Master Table | 11 | CM | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 3 | F32019 | Configurator Master History Table | 11 | CH | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 4 | F3292 | Cross Segment Editing Rules | 11 | KU | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 5 | F3293 | Assembly Inclusions Rules | 16 | KY | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| TOP40: Inventory/OP Base |
| 6 | F4011Z | Batch Receiver File - Order Details | 64 | SZ | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 7 | F40303 | Preference Profile - Revenue Cost Center | 12 | RV | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 8 | F40303R | Preference Resolution Ledger - Revenue Business Unit | 14 | RV | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 9 | F40349 | Preference Profile - Revenue Business Unit (Branch) | 16 | RV | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 10 | F40349R | Preference Resolution Ledger - Revenue Bus Unit (Branch) | 18 | RV | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 11 | F4211AU | Sales Order Detail Audit File | 8 | AU | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 12 | F4211Z1 | Sales Order Detail Unedited Transaction File | 61 | SZ | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| TOP42: Sales Management |
| 13 | F4211 | Sales Order Detail File | 48 | SD | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 14 | F42119 | Sales Order History File | 48 | SD | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 15 | F42199 | S.O. Detail Ledger File | 48 | SL | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 16 | F42565 | Invoice Print File | 99 | IW | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 17 | F42UI12 | Sales Order Detail Cache 2 (MBF) | 14 | ZD | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 18 | F42UI521 | Pick Slips Detail File | 44 | S9 | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 19 | F42UI800 | Sales Detail Work File - Sales Update | 11 | SD | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 20 | F470371T | Tag for F470371- EDI shipping Notice Detail - Outbound | 94 | UZ | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| TOP42B: Sales Order Entry |
| 21 | F42420 | Audit Log Transaction | 55 | AL | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| TOP45: Advanced Pricing |
| 22 | F4575 | Ship and Debit History | 57 | AH | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 23 | F4575TMP | Ship and Debit History - Temp Table | 57 | AH | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 24 | F4576 | Ship and Debit Claims | 85 | AC | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 25 | F4576TMP | Ship and Debit Claims- Temp Table | 85 | AC | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 26 | F4576Z1 | Ship and Debit Claims Unedited Transaction Table | 82 | Z1 | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| TOP47: Electronic Commerce |
| 27 | F47012 | EDI Purchase Order Detail - Inbound | 65 | SZ | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 28 | F47027 | EDI P.O. Acknowledgment Detail - Outbound | 65 | SZ | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 29 | F47037 | EDI Shipping Notice Detail - Outbound | 65 | SZ | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 30 | F470371 | EDI Shipping Notice Detail - Outbound | 73 | SZ | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 31 | F47047 | EDI Invoice Detail (Sales) - Outbound | 65 | SZ | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 32 | F47092 | EDI Request for Quote Detail - Inbound | 65 | SZ | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 33 | F47107 | EDI Response to RFQ Detail - Outbound | 65 | SZ | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 34 | F47132 | EDI Purchase Order Change Detail - Inbound | 66 | SZ | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 35 | F47147 | EDI P.O. Change Acknowledgment Detail - Outbound | 67 | SZ | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| TOP49: Transportation Management |
| 36 | F49110 | Transportation Bill of Lading Workfile | 30 | BW | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 37 | F49130 | Shipment Document Workfile | 34 | BW | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 38 | F49141 | Packing List Workfile | 15 | PW | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 39 | F49160 | Document Next Number | 2 | NN | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 40 | F49197 | Depot Document Print Set Up (Conversion from World File) | 12 | OQ | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 41 | F49198 | Depot Document Print Setup | 14 | OQ | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 42 | F49592 | Document Print Batch Document Header | 11 | DH | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 43 | F49594 | Document Print - Document Detail | 15 | DI | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 44 | F49595 | Document Print - Document Summary | 4 | DK | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 45 | F49695 | Document Register | 2 | DR | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 46 | F49696 | Document Register Detail | 2 | DJ | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
| 47 | F49697 | Document Register Summary | 2 | DN | EMCU | Business Unit - Header | String | Generic Edit | 12 | 0 |
