Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/LK000002
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: Trx Matching Link Header Group Display Name: Transaction Matching
Physical Name: LK000002
Technical Name: LK_Link_HDR
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/hideSELECT
['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/hideSELECT
['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 | ||||||