QA_HIST_Incoming_LINE (QA010332)

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

Display Name: QA_HIST_Incoming_LINE
Physical Name: QA010332
Technical Name: QA_HIST_Incoming_LINE

Group Display Name: Manufacturing QA
Group Technical Name: Manufacturing QA

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	RECEIVINGNUMBER_I	Receiving Number	String	STR20_Document_Number	20
2	RECTRANSNUMBER_I	Receiving Transaction Number	Integer	INT4	4
3	QALOTNUM	QA Lot Number	String	STR20	20
4	QALOTSEQNUMI	QA Lot SEQ Number	Long Integer	LI_Sequence_Number	10
5	Procedure_stepnumber	Procedure stepnumber	Integer	INT4_RB_U0	4
6	SERLTNUM	Serial/Lot Number	String	STR20	20
7	Passed_Inspection	Passed Inspection	Boolean	CB_Passed_Failed	0
8	Destroyed_in_Testing	Destroyed in Testing	Boolean	Destroyed in Testing	0
9	defcode	Defect Code	String	STR10_LBAU	10
10	Disposition_Code	Disposition Code	String	STR10_LBAU	10
11	Inspector_ID	Inspector ID	String	STR10_LBAU	10
12	DATEINSPECTED_I	Date Inspected	Date	DATE	6
13	SLTSQNUM	Serial/Lot SEQ Number	Long Integer	LI_Sequence_Number	10
14	SERLTQTY	Serial/Lot QTY	Currency	DLR17_QTY_RBS0_UTR	17
15	Actual_Measurement	Actual Measurement	Currency	DLR5_QA_RHV	11
16	Measurement_Unit	Measurement Unit	String	STR15	15
17	MEASUREMENTQTYI	Measurement Quantity	Currency	DLR12_QTYU	12
18	Time_Inspected	Time Inspected	Time	TM	6
19	CHANGEDATE_I	Change Date	Date	DT	8
20	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['QA_HIST_Incoming_LINE'].USERID AS 'QA_HIST_Incoming_LINE-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM QA010332 AS ['QA_HIST_Incoming_LINE'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['QA_HIST_Incoming_LINE'].USERID = ['Users Master'].USERID
21	MFGNOTEINDEX2_I	MFG Note Index2	Currency	DLR14	14