Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SF010115
Product: Manufacturing (346)
Series:
Display Name: Data Collection Line Items Group Display Name: Manufacturing WIP
Physical Name: SF010115
Technical Name: Data_Collection_Line
Group Technical Name: Manufacturing WIP
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | EMPLOYID  | Employee ID | String | STR15_Employee_ID | 15 | |
| 2 | DATAENTRYTYPE_I | Data Entry Type | Integer | DDL_Data_Entry_Type | 0 | |
| 3 | MANUFACTUREORDER_I | Manufacture Order | String | STR30_UC | 30 | |
| 4 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['Data Collection Line Items'].ITEMNMBR AS 'Data Collection Line Items-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
SF010115 AS ['Data Collection Line Items']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Data Collection Line Items'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
| 5 | ROUTINGNAME_I | RoutingName | String | STR30_Item_Number | 30 | |
| 6 | RTSEQNUM_I | rtseqnum | String | STR10 | 10 | |
| 7 | LABORCODE_I | Labor Code | String | STR10 | 10 | |
| 8 | ACTUALSTARTDATE_I | ActualStartDate | Date | DATE | 6 | |
| 9 | ACTUALSTARTTIME_I | ActualStartTime | Time | TM | 6 | |
| 10 | ACTUALFINISHDATE_I | ActualFinishDate | Date | DATE | 6 | |
| 11 | ACTUALFINISHTIME_I | ActualFinishTime | Time | TM | 6 | |
| 12 | IDDSCRPT | ID Description | String | STR30 | 30 | |
| 13 | LABCODEDESC_I | Labor Code Description | String | STR_30 | 30 | |
| 14 | LABCODEPAYCODESEL_I | Labor Code PayCode Select | Integer | GB | 0 | |
| 15 | ELAPSEDTIME_I | Elapsed Time | Currency | hr | 10 | |
| 16 | PIECES_I | Pieces | Currency | DLR_14_MRP | 14 | |
| 17 | REJECTS_I | Rejects | Currency | DLR_14_MRP | 14 | |
| 18 | CHANGEDATE_I | Change Date | Date | DT | 8 | |
| 19 | USERID | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Data Collection Line Items'].USERID AS 'Data Collection Line Items-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SF010115 AS ['Data Collection Line Items']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Data Collection Line Items'].USERID = ['Users Master'].USERID | ||||||
| 20 | SEQUENCECOST_I | Sequence Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
| 21 | SETUPCB_I | Setup CB | Boolean | CB | 0 | |
| 22 | CB_I | CB | Boolean | CB | 0 | |
| 23 | POSTABLE_I | Postable | Boolean | CB | 0 | |
| 24 | PAYRCORD | Pay Record | String | STR6_Payroll_Code | 6 | |
| 25 | PAYTYPE | Pay Type | Integer | DDL_Pay_Types | 0 | |
| 26 | PAYUNITRATE_I | Pay Unit Rate | Currency | DLR11_$S2 | 14 | |
| 27 | PIECECOST_I | Piece Cost | Currency | DLR14_Salary | 14 | |
| 28 | OPERATINGCOST_I | Operating Cost | Currency | DLR14_Salary | 14 | |
| 29 | FIXOVERMARK_I | Fixed Overhead Markup | Currency | DLR17_RBS0_UTR$ | 17 | |
| 30 | HOURPIECE1_I | Hour Piece1 | Integer | DDL_Hour_Piece | 0 | |
| 31 | VAROVERHDMARK_I | Variable Overhead Markup | Currency | DLR17_RBS0_UTR$ | 17 | |
| 32 | HOURPIECE2_I | Hour Piece2 | Integer | DDL_Hour_Piece | 0 | |
| 33 | DATACOLLECTERR_I | Data Collection Error | Long Integer | ML_DataColl_Error | 0 | |
| 34 | BACHNUMB | Batch Number | String | STR15_LBAU | 15 | |
| 35 | COMPTRNM | Computer TRX Number | Long Integer | LI8_U0 | 8 | |
| 36 | MFGNOTEINDEX_I | MFG Note Index | Currency | DLR14 | 14 | |
| 37 | Fixed_Overhead_Amount | Fixed Overhead Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
| 38 | Variable_Overhead_Amount | Variable Overhead Amount | Currency | DLR17_RBS0_UTR$ | 17 | |