Trx Matching Link Header (LK000002)

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

Display Name: Trx Matching Link Header
Physical Name: LK000002
Technical Name: LK_Link_HDR

Group Display Name: Transaction Matching
Group Technical Name: Transaction Matching

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	LK_Link_No	LK_Link_No	Long Integer	Long_10U	10
2	DSCRIPTN	Description	String	STR30	30
3	LK_Link_Date	LK_Link_Date	Date	DATE_LONG	8
4	CREATDDT	Created Date	Date	DT	8
5	LSTDTEDT	Last Date Edited	Date	DT_Date	6
6	LK_Link_Balance	LK_Link_Balance	Currency	DLR19_$U2	19
7	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Trx Matching Link Header'].USERID AS 'Trx Matching Link Header-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM LK000002 AS ['Trx Matching Link Header'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Trx Matching Link Header'].USERID = ['Users Master'].USERID
8	LSTUSRED	Last User to Edit	String	STR15	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Trx Matching Link Header'].LSTUSRED AS 'Trx Matching Link Header-Last User to Edit' ,['Users Master'].USERID AS 'Users Master-User ID' FROM LK000002 AS ['Trx Matching Link Header'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Trx Matching Link Header'].LSTUSRED = ['Users Master'].USERID