| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOPF30L: DFM Line Design |
1 | FF30L002 | DFM Bill of Material Master | 62 | DH | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
2 | FF30L005 | DFM Task Master | 4 | TM | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
3 | FF30L010 | Scenario Master | 1 | SC | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
4 | FF30L011 | Line Design Control Parameters | 1 | LD | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
5 | FF30L012 | Kanban Control Parameters | 1 | KB | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
6 | FF30L013 | Default User Scenario | 2 | DS | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
7 | FF30L014 | Branch/Plant Master | 2 | BP | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
8 | FF30L015 | Resource Master | 2 | RE | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
9 | FF30L016 | Default User Branch/Plant | 2 | DB | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
10 | FF30L017 | DFM Work Center Master | 1 | WM | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
11 | FF30L101 | Mixed Model Family Master | 2 | FM | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
12 | FF30L102 | Mixed Model Family Items | 4 | FD | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
13 | FF30L110 | Standard Sequence Of Events | 5 | SS | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
14 | FF30L115 | Sequence Of Events | 10 | SE | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
15 | FF30L116 | Components Consumed | 7 | CC | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
16 | FF30L117 | DFM Event Summary Table | 2 | ES | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
17 | FF30L201 | Volume Design Master | 2 | VM | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
18 | FF30L202 | Volume By Family | 3 | VF | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
19 | FF30L203 | Volume By Family By Part | 5 | FP | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
20 | FF30L301 | DFM Customer Master | 2 | CM | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
21 | FF30L401 | DFM Supplier Master | 2 | SM | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
22 | FF30L501 | DFM Item Definition Master | 1 | IB | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
23 | FF30L512 | DFM Item Units of Measure Conversion Factors | 3 | UM | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
24 | FF30L601 | DFM Employee Master | 2 | EM | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
25 | FF30L701 | DFM Process Master | 12 | PM | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
26 | FF30L702 | Path Master | 5 | PH | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
27 | FF30L703 | Process Path Relationship | 14 | PP | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
28 | FF30L707 | Path Links | 12 | PL | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
29 | FF30L708 | Product Synchronization Results | 4 | PS | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
30 | FF30L801 | Sales Order Master | 4 | SD | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
31 | FF30L901 | Process Map Header Table | 2 | PH | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
32 | FF30L902 | Process Map Detail Table | 2 | PD | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
33 | FF30L904 | Process Map Work Content Table | 2 | WC | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
34 | FF30L905 | Cell Master | 4 | CM | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
35 | FF30L910 | Mixed Model Line Design Header | 3 | LH | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
36 | FF30L911 | Mixed Model Line Design Detail | 4 | LD | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
37 | FF30L912 | Line Master | 4 | LM | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
38 | FF30L920 | Total Product Cycle Time Header | 4 | CH | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
39 | FF30L921 | Total Product Cycle Time Detail | 5 | CL | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
40 | FF30L930 | DFM Routings | 1 | LR | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
41 | FF30L950 | DFM Operation Definition Header | 8 | OD | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
42 | FF30L951 | DFM Operation Definition Detail | 7 | OM | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
43 | FF30L990 | DFM Data Move Configuration Header | 3 | MH | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
44 | FF30L991 | DFM Data Move Configuration Detail | 18 | MD | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
TOPF31K: DFM Kanban Management |
45 | FF31K10 | DFM Kanban Flow Capacity | 1 | FC | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
46 | FF31K11 | DFM Kanban Parent Items | 1 | PI | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
47 | FF31K20 | DFM Kanban Component | 1 | KC | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
48 | FF31K21 | DFM Kanban Component Pull Chain | 1 | CP | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
49 | FF31K22 | DFM Kanban Component Pull Sequence | 1 | PS | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
50 | FF31K25 | DFM Kanban Master -- TEMP | 1 | KM | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
51 | FF31K30 | DFM Kanban Master | 1 | KM | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
52 | FF31K41 | DFM Kanban Pull Chain | 1 | PC | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
53 | FF31K42 | DFM Kanban Location | 1 | LC | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
54 | FF31K50 | DFM Kanban Constants | 1 | DF | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
55 | FF31K51 | DFM Kanban Resize Filter | 1 | RF | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
TOPF34R: DFM Resource Management |
56 | FF34R010 | Resource Design Master | 7 | RM | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
57 | FF34R011 | Resource Calendar Master | 3 | RC | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
58 | FF34R012 | Resource Simulation Master | 8 | RS | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
TOPF34S: DFM Production Sequencing |
59 | FF34S001 | Sequence Detail | 1 | SQ | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
60 | FF34S002 | Daily Plan | 2 | DP | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |
61 | FF34S003 | DFM Planning Parameters | 1 | PP | FSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 |