aaGLWorkAssignReport (AAG60002)

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

Display Name: aaGLWorkAssignReport
Physical Name: AAG60002
Technical Name: aaGLWorkAssignReport

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	SQL DB Length	Keyable Length
1	USERID	User ID	STR15_User_ID	String	16	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['aaGLWorkAssignReport'].USERID AS 'aaGLWorkAssignReport-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM AAG60002 AS ['aaGLWorkAssignReport'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['aaGLWorkAssignReport'].USERID = ['Users Master'].USERID
2	TRXBTCHSRC	aaTRXBatchSource	aaStr50	String	52	50
3	aaGLWorkHdrID	aaGLWorkHdrID	aaLONG_INT	Long Integer	4	8
4	aaGLWorkDistID	aaGLWorkDistID	aaLONG_INT	Long Integer	4	8
5	aaGLWorkAssignID	aaGLWorkAssignID	aaLONG_INT	Long Integer	4	8
6	DEBITAMT	Debit Amount	DLR19_$S2	Currency	10	19
7	SERIES	Series	DDL_Series	Integer	2	0
8	CRDTAMNT	Credit Amount	DLR19_$S2	Currency	10	19
9	ORDBTAMT	Originating Debit Amount	DLR19_$S2	Currency	10	19
10	ORCRDAMT	Originating Credit Amount	DLR19_$S2	Currency	10	19
11	DistRef	Distribution Reference	STR30	String	32	30
12	DEX_ROW_ID		int	int	10	10
	DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.