| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | LDLNDSID | DFM Line Design ID | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 2 | LDPROID | Process Id | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 3 | LDCELLID | Cell Identifier | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 4 | LDFSCID | Scenario ID | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 5 | LDNUMSHFD | Number of Shifts per Day | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 6 | LDDFEPH | Effective Hours Per Shift | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 7 | LDLNTAKT | Takt | Numeric | Generic Edit | 20 | 5 | Allow NULL? |
| 8 | LDDFATWL | Actual Time Weighted Labor | Numeric | Generic Edit | 20 | 5 | Allow NULL? |
| 9 | LDDFATWM | Actual Time Weighted Machine | Numeric | Generic Edit | 20 | 5 | Allow NULL? |
| 10 | LDLDNOMA | Calculated Machine Operations | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 11 | LDLDNOLA | Calculated Labor Operations | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 12 | LDLDNOMD | Designed Machines | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 13 | LDLDNOLD | Designed Labor Operations | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 14 | LDCOPPC | Calculated Output Percentage | Numeric | Generic Edit | 29 | 8 | Allow NULL? |
| 15 | LDLDOQ | Output Quantity | Numeric | Generic Edit | 20 | 4 | Allow NULL? |
| 16 | LDCSCPC | Calculated Scrap Percentage | Numeric | Generic Edit | 29 | 8 | Allow NULL? |
| 17 | LDLDSCQ | Scrap Quantity | Numeric | Generic Edit | 20 | 4 | Allow NULL? |
| 18 | LDCTPPC | Calculated Throughput Percentage | Numeric | Generic Edit | 29 | 8 | Allow NULL? |
| 19 | LDLDTQ | Throughput Quantity | Numeric | Generic Edit | 20 | 4 | Allow NULL? |
| 20 | LDURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 21 | LDURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 22 | LDURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 23 | LDURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 24 | LDURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 25 | LDUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 26 | LDMKEY | Machine Key | String | Generic Edit | 15 | 0 | Allow NULL? |
| 27 | LDPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 28 | LDUUPMJ | Universal Date Updated | JDE UTime | Generic Edit | 11 | 0 | |