Trx Matching Link Header (LK000002)

azurecurveProductsMicrosoft Dynamics GP (0)FinancialTrx Matching Link Header (LK000002)

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
Physical Name: LK000002
Technical Name: LK_Link_HDR

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1LK_Link_No SearchLK_Link_NoLong_10ULong Integer410
2DSCRIPTN SearchDescriptionSTR30String3230
3LK_Link_Date SearchLK_Link_DateDATE_LONGDate48
4CREATDDT SearchCreated DateDTDate48
5LSTDTEDT SearchLast Date EditedDT_DateDate46
6LK_Link_Balance SearchLK_Link_BalanceDLR19_$U2Currency1019
7USERID SearchUser IDSTR15_User_IDString1615
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
8LSTUSRED SearchLast User to EditSTR15String1615
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
9DEX_ROW_ID Searchintint1010

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.

azurecurveProductsMicrosoft Dynamics GP (0)FinancialTrx Matching Link Header (LK000002)

Leave a Reply

Your email address will not be published. Required fields are marked *