ABR GL Lines for Consolidation (NCABR041)

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

Display Name: ABR GL Lines for Consolidation
Physical Name: NCABR041
Technical Name: NC_GL_Consolidate_Lines

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	USERID	User ID	STR15_User_ID	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['ABR GL Lines for Consolidation'].USERID AS 'ABR GL Lines for Consolidation-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM NCABR041 AS ['ABR GL Lines for Consolidation'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['ABR GL Lines for Consolidation'].USERID = ['Users Master'].USERID
2	NC_Bank_ID	NC_Bank_ID	STR15_Bank_ID	String	15
3	NC_Sequence_Number	NC_Sequence_Number	NC_Sequence_Number	Long Integer	10
4	REFRENCE	Reference	STR30	String	30
5	ORDOCNUM	Originating Document Number	STR20	String	20
6	TRXDATE	TRX Date	DT_Date	Date	6
7	NC_Bank_Amount	NC Bank Amount	DLR19_$S2	Currency	19
8	NC_Marked	NC_Marked	NC_Marked	Boolean	0