| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP13: Plant/Equipment Management |
1 | F13017 | Equipment Parts List | 13 | PL | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
TOP17: Customer Service Management |
2 | F3111Z2 | Warranty Claim/Supplier Recovery processing | 43 | WP | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
TOP30: Product Data Management |
3 | F300210 | Lean Multi Level Bill of Material Header | 9 | EH | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
4 | F300211 | Lean Multi Level Bill of Material Detail | 11 | ED | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
5 | F3002Z1 | Bill of Material Transaction File | 22 | SZ | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
6 | F300311 | Lean Multi-Level Routing Detail File | 47 | EH | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
7 | F30UI008 | Bill of Material Comparison Work File | 9 | IJ | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
8 | F30UI015 | BOM Item Fact Work File for BI | 8 | BD | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
9 | F30UI016 | BOM Explosion Work File for BI | 12 | BE | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
TOP30A: Product Costing |
10 | F30UI011 | Work File for Cost Component | 5 | CC | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
11 | F30UI012 | Work File for Parent Child | 4 | PC | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
TOP31: Shop Floor Control |
12 | F3111 | Work Order Parts List | 30 | WM | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
13 | F3111S | Purge - Shop Floor Parts List | 30 | WM | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
14 | F3111Z1 | Outbound Work Order Parts List | 43 | SZ | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
15 | F31UI427 | Labor Variance User Index | 10 | W1 | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
TOP31B: Blend Management |
16 | F31B62 | Sample Search Work Table | 23 | SS | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
TOP32: Configuration Management |
17 | F3212 | Configurator Routings File | 6 | RC | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
18 | F3290 | Configured Item Information | 6 | C3 | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
19 | F3293 | Assembly Inclusions Rules | 9 | KY | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
20 | F3295 | Needed for upgrade from Xe and below | 11 | KS | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
TOP34: Requirements Planning |
21 | F3403 | Branch Relationships Master File | 2 | MP | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
22 | F3404 | Co-Products Planning/Costing Table | 4 | PM | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
TOP34A: Advanced Planning & Scheduling |
23 | F34A90 | Last Outbound Phantom Information | 4 | PI | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
TOP37: Quality Management |
24 | F3712 | Sample Detail | 22 | SD | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
TOP40: Inventory/OP Base |
25 | F3002 | Bill of Material Master File | 9 | IX | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
26 | F3011 | Bill of Materials Change File | 9 | IZ | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
27 | F3013 | ECO Parts List Detail | 10 | CY | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
28 | F30UI002 | Bill of Material Structure Analysis Work File | 7 | IX | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
29 | F30UI004 | Bill of Material Update Work File | 18 | WF | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
30 | F4013Z | Kit Components Batch File | 17 | KS | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
TOP41F: Apparel Management |
31 | FCW67 | Style Work Order Parts List | 36 | WM | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
32 | FCW89 | Work Order Inventory Issues for Style Items | 9 | WM | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
33 | FCW93 | Copy to Outsource Operations for Style Items | 5 | ST | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
34 | FCW961 | Simulation Detailed Parts List | 13 | DL | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
35 | FCW962 | Simulation Consolidated Parts List | 5 | CL | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
TOP75I: India |
36 | F75I395B | ER - 5 (2) | 12 | ER | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
37 | F75I395T | ER - 5 (temp) | 12 | ER | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
38 | F75I396B | ER-6 | 11 | SE | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
39 | F75I396T | ER-6 Temp | 12 | SE | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
TOP76B: Brazil - Reporting System Only |
40 | F76B3010 | Work Table for Item/Part List - 30 | 8 | IP | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
TOP89: Conversion Programs |
41 | F3294 | Needed for upgrade from Xe and below | 14 | KZ | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
42 | F32943 | Needed for upgrade from Xe and below | 15 | KO | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
43 | F3296T | Needed for upgrade from Xe and below | 10 | KA | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
TOPF31: Lean Transactions |
44 | FF31111 | Lean Transaction Parts List | 9 | PL | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
45 | FF311114 | Related Purchase Orders for Lean Pay on Consumption Issues | 6 | PC | CMCU | Component Branch | String | Generic Edit | 12 | 0 |
46 | FF31111S | Purge - Lean Transaction Parts List | 9 | PR | CMCU | Component Branch | String | Generic Edit | 12 | 0 |