Assembly Batch History (BM30100)

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

Display Name: Assembly Batch History
Physical Name: BM30100
Technical Name: bmBatchHist

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	TRXSORCE	TRX Source	String	STR13	13
2	BACHNUMB	Batch Number	String	STR15_LBAU	15
3	BCHSOURC	Batch Source	String	STR15	15
4	BCHCOMNT	Batch Comment	String	STR60	60
5	BACHFREQ	Batch Frequency	Integer	DDL_Frequency	0
6	PSTGDATE	Posting Date	Date	DT	8
7	NUMOFTRX	Number Of TRX	Long Integer	LI6_U0	6
8	BCHTOTAL	Batch Total	Currency	DLR19_RBS0_STR$	19
9	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Assembly Batch History'].NOTEINDX AS 'Assembly Batch History-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM BM30100 AS ['Assembly Batch History'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Assembly Batch History'].NOTEINDX = ['Record Notes Master'].NOTEINDX
10	ORIGIN	Origin	Integer	DDL	0
11	APPROVL	Approval	Boolean	CB_Approval	0
12	APRVLUSERID	Approval User ID	String	STR15_User_ID	15
	The key to the Users Master (SY01400). Click to show/hide SELECT ['Assembly Batch History'].APRVLUSERID AS 'Assembly Batch History-Approval User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM BM30100 AS ['Assembly Batch History'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Assembly Batch History'].APRVLUSERID = ['Users Master'].USERID
13	APPRVLDT	Approval Date	Date	DATE	6
14	CNTRLTRX	Control TRX Count	Long Integer	LI6_U0	6
15	CNTRLTOT	Control Total	Currency	DLR19_RBS0_UTR$	19