QA_Incoming_MSTR (QAD10132)

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

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