Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SF010501
Product: Manufacturing (346)
Series:
Display Name: Automated Data Collection Records Group Display Name: Manufacturing WIP
Physical Name: SF010501
Technical Name: ADC_Records
Group Technical Name: Manufacturing WIP
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | DATAENTRYTYPEADC_I | Data Entry Type ADC | Integer | DDL_Data_Entry_Type_ADC | 0 | |
2 | MANUFACTUREORDER_I | Manufacture Order | String | STR30_UC | 30 | |
3 | RTSEQNUM_I | rtseqnum | String | STR10 | 10 | |
4 | DONECB_I | done_cb | Boolean | CB_Done | 0 | |
5 | EMPLOYID | Employee ID | String | STR15_Employee_ID | 15 | |
6 | MACHINEID_I | Machine ID IC | String | STR10_Location_Code | 10 | |
7 | ITEMNMBR | Item Number | String | STR30_Item_Number | 30 | |
Key to the Item Master (IV00101).
Click to show/hideSELECT
['Automated Data Collection Records'].ITEMNMBR AS 'Automated Data Collection Records-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
SF010501 AS ['Automated Data Collection Records']
INNER JOIN
IV00101 AS ['Item Master']
ON
['Automated Data Collection Records'].ITEMNMBR = ['Item Master'].ITEMNMBR | ||||||
8 | ADCDATE_I | ADCDate | Date | DATE | 6 | |
9 | ADCTIME_I | ADCTime | Time | TM | 6 | |
10 | TRXTYPE | Transaction Type | Integer | GB | 0 | |
11 | LABORCODE_I | Labor Code | String | STR10 | 10 | |
12 | PAYRCORD | Pay Record | String | STR6_Payroll_Code | 6 | |
13 | PAYTYPE | Pay Type | Integer | DDL_Pay_Types | 0 | |
14 | LABCODEPAYCODESEL_I | Labor Code PayCode Select | Integer | GB | 0 | |
15 | SETUPCB_I | Setup CB | Boolean | CB | 0 | |
16 | NUMBERSCRAPPED_I | Number Scrapped | Currency | DLR_14_MRP | 14 | |
17 | PIECES_I | Pieces | Currency | DLR_14_MRP | 14 | |
18 | REJECTS_I | Rejects | Currency | DLR_14_MRP | 14 | |
19 | ADCDEVICEID_I | ADC Device ID | String | STR15_User_ID | 15 | |
20 | CHANGEBY_I | Change By | String | STR15_User_ID | 15 | |
21 | CHANGEDATE_I | Change Date | Date | DT | 8 | |
22 | CHANGETIME_I | Change Time | Time | TM | 6 | |
23 | ADCSTATUS_I | ADCStatus | Integer | DDL | 0 | |
24 | Job_Number | IC Job Number | String | STR30 | 30 |