| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
|---|
| TOP12: Fixed Assets |
| 1 | F1201 | Asset Master File | 80 | FA | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 2 | F1201P | Asset Master Purge Table | 80 | FA | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 3 | F1201Z1 | Unedited Asset Master Transactions | 91 | FA | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP13: Plant/Equipment Management |
| 4 | F13017 | Equipment Parts List | 3 | PL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP13E: Equipment Cost Analysis |
| 5 | F1381 | Equipment Analysis Filters | 15 | EF | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP17: Customer Service Management |
| 6 | F3112Z2 | Warranty Claim/Supplier Recovery processing | 18 | WL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP17C: Call Management |
| 7 | F1790 | Product Family/Model Master | 10 | PM | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 8 | F48164 | Knowledge Base Detail | 39 | KB | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP30: Product Data Management |
| 9 | F300210 | Lean Multi Level Bill of Material Header | 2 | EH | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 10 | F300211 | Lean Multi Level Bill of Material Detail | 6 | ED | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 11 | F3002Z1 | Bill of Material Transaction File | 15 | SZ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 12 | F300311 | Lean Multi Level Routing Detail File | 3 | EH | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 13 | F3003Z1 | Routing Transactions File | 15 | SZ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 14 | F30UI010 | Bill Of Material Work File | 2 | WF | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP31: Shop Floor Control |
| 15 | F3112 | Work Order Routing | 5 | WL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 16 | F31122 | Work Order Time Transactions | 6 | WT | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 17 | F31122S | Purge Work Order Time Transactions | 6 | WT | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 18 | F31122Z1 | Work Order Time Transactions Unedited Transaction Table | 19 | SZ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 19 | F3112S | Purge Shop Floor Control Routing Instructions | 5 | WL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 20 | F3112Z1 | Outbound Work Order Routings | 18 | SZ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP32: Configuration Management |
| 21 | F3211 | Configurator Segment Detail | 5 | KZ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 22 | F32119 | Configurator Segment Detail History | 5 | KS | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 23 | F3212 | Configurator Routings File | 3 | RC | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 24 | F3215 | Configurator Component Table | 13 | CC | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 25 | F32159 | Configurator Component History Table | 13 | CH | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 26 | F3282 | Configured Item/Rules Table Cross Reference | 4 | RK | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 27 | F32821 | Rules Table Value Definition | 4 | RL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 28 | F3290 | Configured Item Information | 1 | C3 | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 29 | F3291 | Configured Item Segments | 1 | KW | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 30 | F3292 | Cross Segment Editing Rules | 1 | KU | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 31 | F32921 | Cross Segment Editing Rules - Values | 2 | KX | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 32 | F32922 | Cross Segment Editing Rules - Range | 2 | KV | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 33 | F3293 | Assembly Inclusions Rules | 2 | KY | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 34 | F3294 | Configured String History File | 1 | KZ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 35 | F32941 | Configured String Master | 1 | SM | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 36 | F32943 | Configured String History - OneWorld | 1 | KO | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 37 | F32944 | Configured String Master - OneWorld | 1 | KT | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 38 | F3295 | Segment Value History File | 1 | KS | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 39 | F3296 | Configurator Level/Sequence File | 9 | KR | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP33: Capacity Planning |
| 40 | F33UI001 | Shop Floor Control Routing Instructions | 1 | WL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP34: Requirements Planning |
| 41 | F3404 | Co-Products Planning/Costing Table | 13 | PM | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 42 | F3412 | MPS/MRP/DRP Lower Level Requirements File | 5 | MW | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP34A: Advanced Planning & Scheduling |
| 43 | F34A120 | Routing Master Resource Table | 2 | N0 | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 44 | F34A90 | Last Outbound Phantom Information | 1 | PI | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP40: Inventory/OP Base |
| 45 | F3002 | Bill of Material Master File | 2 | IX | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 46 | F3003 | Routing Master File | 2 | IR | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 47 | F3003T | Routing Tag File | 2 | IR | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 48 | F3011 | Bill of Materials Change File | 2 | IZ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 49 | F3013 | ECO Parts List Detail | 5 | CY | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 50 | F3015 | Component Locator File | 1 | CQ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 51 | F30UI002 | Bill of Material Structure Analysis Work File | 5 | IX | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 52 | F30UI004 | Bill of Material Update Work File | 12 | WF | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 53 | F30UI006 | Lot Tracking Work File | 10 | IL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 54 | F32942 | Configured String Detail | 2 | SG | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 55 | F32945 | Configured String Detail - One World | 2 | SI | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 56 | F4013Z | Kit Components Batch File | 7 | KS | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP41: Inventory Management |
| 57 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 16 | SZ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 58 | F4101Z1A | F4101 Detail Item Master Unedited Transaction | 18 | SZ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 59 | F4111 | Item Ledger File | 17 | IL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 60 | F41UI001 | Inventory Transactions Detail File | 35 | IT | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP76B: Brazil - Reporting System Only |
| 61 | F76B3010 | Work Table for Item/Part List - 30 | 1 | IP | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP76H: Chile |
| 62 | F76H611 | Actual Item Ledger File - CHI - 41 - 76H | 17 | AL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOPF31: Lean Transactions |
| 63 | FF31011 | TransactionID Master File | 14 | EH | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 64 | FF31011S | Purge - TransactionID Master File | 14 | ER | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 65 | FF31111 | Lean Transaction Parts List | 6 | PL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 66 | FF31111S | Purge - Lean Transaction Parts List | 6 | PR | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 67 | FF31112 | Routing Transaction Table | 13 | EH | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 68 | FF31112S | Purge - Routing Transaction Table | 13 | ET | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 69 | FF31113 | Lean Transaction Labor Detail | 7 | LD | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 70 | FF31113S | Purge - Lean Transaction Labor Detail | 7 | LR | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
