Automated Data Collection Matched Records (SF010502)

azurecurve Products Manufacturing (346)3rd PartyAutomated Data Collection Matched Records (SF010502)

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

Display Name: Automated Data Collection Matched Records
Physical Name: SF010502
Technical Name: ADC_Matched_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	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/hide SELECT ['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/hide SELECT ['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

azurecurve Products Manufacturing (346)3rd PartyAutomated Data Collection Matched Records (SF010502)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply