Automated Data Collection Records (SF010501)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SF010501

Display Name: Automated Data Collection Records
Physical Name: SF010501
Technical Name: ADC_Records

Group Display Name: Manufacturing WIP
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/hide SELECT ['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