Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SF010502
Product: Manufacturing (346)
Series:
Display Name: Automated Data Collection Matched Records Group Display Name: Manufacturing WIP
Physical Name: SF010502
Technical Name: ADC_Matched_Records
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 | DATAENTRYTYPEADC_I | Data Entry Type ADC | Integer | DDL_Data_Entry_Type_ADC | 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
['Automated Data Collection Matched Records'].ITEMNMBR AS 'Automated Data Collection Matched Records-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
SF010502 AS ['Automated Data Collection Matched Records']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Automated Data Collection Matched Records'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
5 | ROUTINGNAME_I | RoutingName | String | STR30_Item_Number | 30 | |
6 | RTSEQNUM_I | rtseqnum | String | STR10 | 10 | |
7 | DONECB_I | done_cb | Boolean | CB_Done | 0 | |
8 | LABORCODE_I | Labor Code | String | STR10 | 10 | |
9 | ACTUALSTARTDATE_I | ActualStartDate | Date | DATE | 6 | |
10 | ACTUALSTARTTIME_I | ActualStartTime | Time | TM | 6 | |
11 | ACTUALFINISHDATE_I | ActualFinishDate | Date | DATE | 6 | |
12 | ACTUALFINISHTIME_I | ActualFinishTime | Time | TM | 6 | |
13 | IDDSCRPT | ID Description | String | STR30 | 30 | |
14 | LABCODEDESC_I | Labor Code Description | String | STR_30 | 30 | |
15 | LABCODEPAYCODESEL_I | Labor Code PayCode Select | Integer | GB | 0 | |
16 | ELAPSEDTIME_I | Elapsed Time | Currency | hr | 10 | |
17 | NUMBERSCRAPPED_I | Number Scrapped | Currency | DLR_14_MRP | 14 | |
18 | PIECES_I | Pieces | Currency | DLR_14_MRP | 14 | |
19 | REJECTS_I | Rejects | Currency | DLR_14_MRP | 14 | |
20 | CHANGEDATE_I | Change Date | Date | DT | 8 | |
21 | USERID | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['Automated Data Collection Matched Records'].USERID AS 'Automated Data Collection Matched Records-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
SF010502 AS ['Automated Data Collection Matched Records']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Automated Data Collection Matched Records'].USERID = ['Users Master'].USERID | ||||||
22 | SEQUENCECOST_I | Sequence Cost | Currency | DLR17_RBS0_UTR$ | 17 | |
23 | SETUPCB_I | Setup CB | Boolean | CB | 0 | |
24 | CB_I | CB | Boolean | CB | 0 | |
25 | POSTABLE_I | Postable | Boolean | CB | 0 | |
26 | PAYRCORD | Pay Record | String | STR6_Payroll_Code | 6 | |
27 | PAYTYPE | Pay Type | Integer | DDL_Pay_Types | 0 | |
28 | PAYUNITRATE_I | Pay Unit Rate | Currency | DLR11_$S2 | 14 | |
29 | PIECECOST_I | Piece Cost | Currency | DLR14_Salary | 14 | |
30 | OPERATINGCOST_I | Operating Cost | Currency | DLR14_Salary | 14 | |
31 | FIXOVERMARK_I | Fixed Overhead Markup | Currency | DLR17_RBS0_UTR$ | 17 | |
32 | HOURPIECE1_I | Hour Piece1 | Integer | DDL_Hour_Piece | 0 | |
33 | VAROVERHDMARK_I | Variable Overhead Markup | Currency | DLR17_RBS0_UTR$ | 17 | |
34 | HOURPIECE2_I | Hour Piece2 | Integer | DDL_Hour_Piece | 0 | |
35 | DATACOLLECTERR_I | Data Collection Error | Long Integer | ML_DataColl_Error | 0 | |
36 | BACHNUMB | Batch Number | String | STR15_LBAU | 15 | |
37 | COMPTRNM | Computer TRX Number | Long Integer | LI8_U0 | 8 | |
38 | MFGNOTEINDEX_I | MFG Note Index | Currency | DLR14 | 14 | |
39 | Fixed_Overhead_Amount | Fixed Overhead Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
40 | Variable_Overhead_Amount | Variable Overhead Amount | Currency | DLR17_RBS0_UTR$ | 17 | |
41 | Acct_Array_1 | Acct Array[1] | Long Integer | LI_14 | 14 | |
42 | Acct_Array_2 | Acct Array[2] | Long Integer | LI_14 | 14 | |
43 | Acct_Array_3 | Acct Array[3] | Long Integer | LI_14 | 14 | |
44 | Acct_Array_4 | Acct Array[4] | Long Integer | LI_14 | 14 | |
45 | Acct_Array_5 | Acct Array[5] | Long Integer | LI_14 | 14 | |
46 | Acct_Array_6 | Acct Array[6] | Long Integer | LI_14 | 14 | |
47 | Cost_Array_1 | Cost Array[1] | Currency | DLR17_RBS0_UTR$ | 17 | |
48 | Cost_Array_2 | Cost Array[2] | Currency | DLR17_RBS0_UTR$ | 17 | |
49 | Cost_Array_3 | Cost Array[3] | Currency | DLR17_RBS0_UTR$ | 17 | |
50 | Cost_Array_4 | Cost Array[4] | Currency | DLR17_RBS0_UTR$ | 17 | |
51 | Cost_Array_5 | Cost Array[5] | Currency | DLR17_RBS0_UTR$ | 17 | |
52 | Cost_Array_6 | Cost Array[6] | Currency | DLR17_RBS0_UTR$ | 17 | |
53 | Job_Number | IC Job Number | String | STR30 | 30 | |
54 | SEQ_I | Seq | Long Integer | LINT_10 | 10 |