User Data Master (FA19900)

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

Product: Fixed Assets (309)
Series:

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

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASSETINDEX SearchAsset IndexLong IntegerLI9_Asset_Index9
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 1StringSTR6_User_Field_16
3USRFIELD2 SearchUser Field 2StringSTR6_User_Field_26
4USRFIELD3 SearchUser Field 3StringSTR10_User_Field_310
5USRFIELD4 SearchUser Field 4StringSTR10_User_Field_410
6USRFIELD5 SearchUser Field 5StringSTR20_User_Field_520
7USRFIELD6 SearchUser Field 6StringSTR20_User_Field_620
8USRFIELD7 SearchUser Field 7StringSTR20_User_Field_720
9USRFIELD8 SearchUser Field 8StringSTR20_User_Field_820
10USRFIELD9 SearchUser Field 9StringSTR40_User_Field_940
11USRFIELD10 SearchUser Field 10StringSTR40_User_Field_1040
12USRFIELD11 SearchUser Field 11CurrencyDLR17_RBS0_STR$17
13USRFIELD12 SearchUser Field 12CurrencyDLR17_RBS0_STR$17
14USRFIELD13 SearchUser Field 13CurrencyDLR17_RBS0_STR$17
15USRFIELD14 SearchUser Field 14CurrencyDLR17_RBS0_STR$17
16USRFIELD15 SearchUser Field 15CurrencyDLR17_RBS0_STR$17
17NOTEINDX SearchNote IndexCurrencyDLR1414
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 DateDateDT8
19LASTMNTDTIME SearchLast Maintained TimeTimeTM66
20LASTMNTDUSERID SearchLast Maintained User IDStringUser_ID15
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

Leave a Reply

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