| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP17C: Call Management |
1 | F1790 | Product Family/Model Master | 13 | PM | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
TOP30: Product Data Management |
2 | F3002Z1 | Bill of Material Transaction File | 28 | SZ | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
3 | F300311 | Lean Multi-Level Routing Detail File | 15 | EH | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
4 | F3003T | Routing Tag File - not used in B9, obsolete in B10 | 7 | IR | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
5 | F3003Z1 | Routing Transactions File | 30 | SZ | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
6 | F30UI014 | BOM Header Work File for BI | 3 | BH | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
7 | F30UI015 | BOM Item Fact Work File for BI | 5 | BD | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
8 | F30UI016 | BOM Explosion Work File for BI | 4 | BE | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
TOP30A: Product Costing |
9 | F30UI011 | Work File for Cost Component | 8 | CC | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
10 | F30UI012 | Work File for Parent Child | 10 | PC | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
TOP34A: Advanced Planning & Scheduling |
11 | F34A120 | Routing Master Resource Table | 7 | N0 | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
12 | F34A180 | Routing Master Resource Set | 7 | RR | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
13 | F34A190 | Routing Master Resource and Set XRef | 7 | RD | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
14 | F34A90 | Last Outbound Phantom Information | 8 | PI | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
TOP40: Inventory/OP Base |
15 | F3002 | Bill of Material Master File | 15 | IX | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
16 | F3003 | Routing Master File | 17 | IR | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
17 | F3011 | Bill of Materials Change File | 15 | IZ | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
18 | F3013 | ECO Parts List Detail | 12 | CY | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
19 | F30UI002 | Bill of Material Structure Analysis Work File | 8 | IX | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
20 | F30UI004 | Bill of Material Update Work File | 15 | WF | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
TOP41: Inventory Management |
21 | F4101A | Item File | 83 | IM | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
22 | F4101Z1 | F4101 Item Master Unedited Transaction Table | 180 | SZ | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
23 | F4102 | Item Branch File | 110 | IB | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
TOP41F: Apparel Management |
24 | FCW48 | Bill of Material Association Header | 4 | BH | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
25 | FCW49 | Bill of Material Association Detail | 4 | BD | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
26 | FCW50 | Bill of Material Association Matrix | 4 | BX | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
27 | FCW51 | BOM Usage | 4 | BU | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
28 | FCW52 | Style Routing Master File | 4 | RC | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
29 | FCW86 | BOM Quantity Work File | 5 | WF | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
TOP75I: India |
30 | F75I395B | ER - 5 (2) | 18 | ER | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
31 | F75I395T | ER - 5 (temp) | 19 | ER | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
32 | F75I396B | ER-6 | 22 | SE | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
33 | F75I396T | ER-6 Temp | 21 | SE | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
TOP76B: Brazil |
34 | F76B3010 | Work Table for Item/Part List - 30 | 15 | IP | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
TOPF30L: DFM Line Design |
35 | FF30L002 | DFM Bill of Material Master | 11 | DH | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
36 | FF30L501 | DFM Item Definition Master | 74 | IB | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |
37 | FF30L930 | DFM Routings | 16 | LR | BQTY | Units - Batch Quantity | Numeric | Generic Edit | 15 | 0 |