Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/LK000102
Product: Microsoft Dynamics GP (0)
Series: Financial
Display Name: Trx Matching Link Header History Group Display Name: Transaction Matching
Physical Name: LK000102
Technical Name: LK_Link_HDR_HIST
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 History'].USERID AS 'Trx Matching Link Header History-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
LK000102 AS ['Trx Matching Link Header History']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Trx Matching Link Header History'].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 History'].LSTUSRED AS 'Trx Matching Link Header History-Last User to Edit'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
LK000102 AS ['Trx Matching Link Header History']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['Trx Matching Link Header History'].LSTUSRED = ['Users Master'].USERID | ||||||