QA_HIST_Incoming_MSTR (QA010132)

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

Display Name: QA_HIST_Incoming_MSTR
Physical Name: QA010132
Technical Name: QA_HIST_Incoming_MSTR

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	SERLTNUM	Serial/Lot Number	String	STR20	20
4	SLTSQNUM	Serial/Lot SEQ Number	Long Integer	LI_Sequence_Number	10
5	SERLTQTY	Serial/Lot QTY	Currency	DLR17_QTY_RBS0_UTR	17
6	Lot_QA_Completed	Lot QA Completed	Boolean	CB	0
7	Lot_Passed_Inspection	Lot Passed Inspection	Boolean	CB	0
8	LOTREDPOSTI	Lot Ready to Post	Boolean	CB	0
9	LOTSAVBATCHI	Lot Saved to Batch	Boolean	CB	0
10	LOTPOSTEDTOINVI	Lot Posted to Inventory	Boolean	CB	0
11	LOTQTYPASS	Lot QTY Passed	Currency	DLR17_QTY_RBU2	17
12	LOTQTYFAIL	Lot QTY Failed	Currency	DLR17_QTY_RBU2	17
13	Lot_QTY_Destroyed_in_Tes	Lot QTY Destroyed in Testing	Currency	DLR17_QTY_RBU2	17
14	CHANGEDATE_I	Change Date	Date	DT	8
15	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['QA_HIST_Incoming_MSTR'].USERID AS 'QA_HIST_Incoming_MSTR-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM QA010132 AS ['QA_HIST_Incoming_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['QA_HIST_Incoming_MSTR'].USERID = ['Users Master'].USERID