| 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 |
| 7 | F48164 | Failure Analysis Detail | 39 | KB | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP17C: Call Management |
| 8 | F1790 | Product Family/Model Master | 10 | PM | 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 | F3003T | Routing Tag File - not used in B9 - obsolete in B10 | 2 | IR | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 14 | F3003Z1 | Routing Transactions File | 15 | SZ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 15 | F30UI010 | Bill Of Material Work File | 2 | WF | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 16 | F30UI014 | BOM Header Work File for BI | 1 | BH | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 17 | F30UI015 | BOM Item Fact Work File for BI | 2 | BD | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 18 | F30UI016 | BOM Explosion Work File for BI | 2 | BE | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP30A: Product Costing |
| 19 | F30UI012 | Work File for Parent Child | 7 | PC | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP31: Shop Floor Control |
| 20 | F3112 | Work Order Routing | 5 | WL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 21 | F31122 | Work Order Time Transactions | 6 | WT | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 22 | F31122S | Purge Work Order Time Transactions | 6 | WT | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 23 | F31122Z1 | Work Order Time Transactions Unedited Transaction Table | 19 | SZ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 24 | F3112S | Purge Shop Floor Control Routing Instructions | 5 | WL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 25 | F3112Z1 | Outbound Work Order Routings | 18 | SZ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP32: Configuration Management |
| 26 | F3211 | Configurator Segment Detail | 5 | KZ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 27 | F32119 | Configurator Segment Detail History | 5 | KS | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 28 | F3212 | Configurator Routings File | 3 | RC | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 29 | F3215 | Configurator Component Table | 13 | CC | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 30 | F32159 | Configurator Component History Table | 13 | CH | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 31 | F3282 | Configured Item/Rules Table Cross Reference | 4 | RK | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 32 | F32821 | Rules Table Value Definition | 4 | RL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 33 | F3290 | Configured Item Information | 1 | C3 | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 34 | F3291 | Configured Item Segments | 1 | KW | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 35 | F3292 | Cross Segment Editing Rules | 1 | KU | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 36 | F32921 | Cross Segment Editing Rules - Values | 2 | KX | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 37 | F32922 | Cross Segment Editing Rules - Range | 2 | KV | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 38 | F3293 | Assembly Inclusions Rules | 2 | KY | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 39 | F3295 | Needed for upgrade from Xe and below | 1 | KS | 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 | F34A180 | Routing Master Resource Set | 2 | RR | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 45 | F34A190 | Routing Master Resource and Set XRef | 2 | RD | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 46 | F34A90 | Last Outbound Phantom Information | 1 | PI | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP40: Inventory/OP Base |
| 47 | F3002 | Bill of Material Master File | 2 | IX | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 48 | F3003 | Routing Master File | 2 | IR | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 49 | F3011 | Bill of Materials Change File | 2 | IZ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 50 | F3013 | ECO Parts List Detail | 5 | CY | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 51 | F3015 | Component Locator File | 1 | CQ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 52 | F30UI002 | Bill of Material Structure Analysis Work File | 5 | IX | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 53 | F30UI004 | Bill of Material Update Work File | 12 | WF | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 54 | F30UI006 | Lot Tracking Work File | 10 | IL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 55 | F4013Z | Kit Components Batch File | 7 | KS | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP41: Inventory Management |
| 56 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 16 | SZ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 57 | F4101Z1A | F4101 Detail Item Master Unedited Transaction | 18 | SZ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 58 | F4111 | Item Ledger File | 17 | IL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 59 | F41UI001 | Inventory Transactions Detail File | 35 | IT | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP41F: Apparel Management |
| 60 | FCW48 | Bill of Material Association Header | 1 | BH | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 61 | FCW49 | Bill of Material Association Detail | 1 | BD | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 62 | FCW50 | Bill of Material Association Matrix | 1 | BX | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 63 | FCW51 | BOM Usage | 1 | BU | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 64 | FCW52 | Style Routing Master File | 1 | RC | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 65 | FCW68 | Style Work Order Routings | 6 | WL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 66 | FCW86 | BOM Quantity Work File | 2 | WF | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP75I: India |
| 67 | F75I395B | ER - 5 (2) | 3 | ER | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 68 | F75I395T | ER - 5 (temp) | 3 | ER | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 69 | F75I396B | ER-6 | 2 | SE | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 70 | F75I396T | ER-6 Temp | 3 | SE | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP76B: Brazil - Reporting System Only |
| 71 | F76B3010 | Work Table for Item/Part List - 30 | 1 | IP | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP76H: Chile |
| 72 | F76H611 | Actual Item Ledger File - CHI - 41 - 76H | 17 | AL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOP89: Conversion Programs |
| 73 | F3294 | Needed for upgrade from Xe and below | 1 | KZ | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 74 | F32941 | Needed for upgrade from Xe and below | 1 | SM | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 75 | F32942 | Needed for upgrade from Xe and below | 2 | SG | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 76 | F32943 | Needed for upgrade from Xe and below | 1 | KO | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 77 | F32944 | Needed for upgrade from Xe and below | 1 | KT | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 78 | F32945 | Needed for upgrade from Xe and below | 2 | SI | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 79 | F3296 | Needed for upgrade from Xe and below | 9 | KR | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| TOPF31: Lean Transactions |
| 80 | FF31011 | TransactionID Master File | 14 | EH | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 81 | FF31011S | Purge - TransactionID Master File | 14 | ER | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 82 | FF31111 | Lean Transaction Parts List | 6 | PL | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 83 | FF31111S | Purge - Lean Transaction Parts List | 6 | PR | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 84 | FF31112 | Routing Transaction Table | 13 | EH | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 85 | FF31112S | Purge - Routing Transaction Table | 13 | ET | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 86 | FF31113 | Lean Transaction Labor Detail | 7 | LD | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
| 87 | FF31113S | Purge - Lean Transaction Labor Detail | 7 | LR | KIT | Parent (short) Item Number | Numeric | Generic Edit | 8 | 0 |
