User Data Master WORK (FA19900)

azurecurveProductsFixed Assets (309)SystemUser Data Master WORK (FA19900)

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

Product: Fixed Assets (309)
Series: Financial

Display Name: User Data Master
Physical Name: FA19900
Technical Name: FA_User_Data_WORK

Group Display Name: Fixed Assets Master
Group Technical Name: Fixed Assets Master

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ASSETINDEX SearchAsset IndexLI9_Asset_IndexLong Integer49
Key to the Asset General Information Master (FA00100).

Click to show/hide

SELECT
       ['User Data Master'].ASSETINDEX AS 'User Data Master-Asset Index'
       ,['Asset General Information Master'].ASSETINDEX AS 'Asset General Information Master-Asset Index'
FROM
       FA19900 AS ['User Data Master']
INNER JOIN
       FA00100 AS ['Asset General Information Master']
              ON
                     ['User Data Master'].ASSETINDEX = ['Asset General Information Master'].ASSETINDEX
2USRFIELD1 SearchUser Field 1STR6_User_Field_1String86
3USRFIELD2 SearchUser Field 2STR6_User_Field_2String86
4USRFIELD3 SearchUser Field 3STR10_User_Field_3String1210
5USRFIELD4 SearchUser Field 4STR10_User_Field_4String1210
6USRFIELD5 SearchUser Field 5STR20_User_Field_5String2220
7USRFIELD6 SearchUser Field 6STR20_User_Field_6String2220
8USRFIELD7 SearchUser Field 7STR20_User_Field_7String2220
9USRFIELD8 SearchUser Field 8STR20_User_Field_8String2220
10USRFIELD9 SearchUser Field 9STR40_User_Field_9String4240
11USRFIELD10 SearchUser Field 10STR40_User_Field_10String4240
12USRFIELD11 SearchUser Field 11DLR17_RBS0_STR$Currency1017
13USRFIELD12 SearchUser Field 12DLR17_RBS0_STR$Currency1017
14USRFIELD13 SearchUser Field 13DLR17_RBS0_STR$Currency1017
15USRFIELD14 SearchUser Field 14DLR17_RBS0_STR$Currency1017
16USRFIELD15 SearchUser Field 15DLR17_RBS0_STR$Currency1017
17NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['User Data Master'].NOTEINDX AS 'User Data Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       FA19900 AS ['User Data Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['User Data Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
18LASTMNTDDATE SearchLast Maintained DateDTDate48
19LASTMNTDTIME SearchLast Maintained TimeTM6Time46
20LASTMNTDUSERID SearchLast Maintained User IDUser_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['User Data Master'].LASTMNTDUSERID AS 'User Data Master-Last Maintained User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       FA19900 AS ['User Data Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['User Data Master'].LASTMNTDUSERID = ['Users Master'].USERID
21DEX_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.

azurecurveProductsFixed Assets (309)SystemUser Data Master WORK (FA19900)

Leave a Reply

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