Asset General Information Master (FA00100)

azurecurveProductsFixed Assets (309)FinancialAsset General Information Master (FA00100)

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

Product: Fixed Assets (309)
Series:

Display Name: Asset General Information Master
Physical Name: FA00100
Technical Name: FA_General_Information_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
2ASSETID SearchAsset IDStringSTR15_Asset_ID15
3ASSETIDSUF SearchAsset ID SuffixIntegerINT3_U03
4SHRTNAME SearchShort NameStringSTR1515
5ASSETDESC SearchAsset DescriptionStringSTR40_Asset_Description40
6EXTASSETDESC SearchExtended Asset DescriptionStringSTR40_Asset_Description40
7Master_Asset_ID SearchMaster Asset IDStringSTR19_Master_Asset_ID19
8STRUCTUREID SearchStructure IDStringSTR30_Structure_ID30
9ASSETCLASSID SearchAsset Class IDStringSTR15_Asset_Class_ID15
10LOCATNID SearchLocation IDStringSTR15_Location_ID15
11ACQDATE SearchAcquisition DateDateDT8
12Acquisition_Cost SearchAcquisition CostCurrencyDLR17_RBS0_STR$17
13ASSETTYPE SearchAsset TypeIntegerDDL_Asset_Type0
14ASSETSTATUS SearchAsset StatusIntegerVS_Asset_Status0
15PROPTYPE SearchProperty TypeIntegerDDL_Property_Type0
16ASSETQTY SearchAsset QuantityLong IntegerLI6_ST06
17ASSETBEGQTY SearchAsset Begin QuantityLong IntegerLI6_ST06
18ASSETCURRMAINT SearchCurrent Maintenance AmountCurrencyDLR17_RBS0_STR$17
19ASSETYTDMAINT SearchYTD Maintenance AmountCurrencyDLR17_RBS0_STR$17
20ASSETLTDMAINT SearchLTD Maintenance AmountCurrencyDLR17_RBS0_STR$17
21LASTMAINTDATE SearchLast Maintenance DateDateDT8
22ASSESSEDVALUE SearchAssessed ValueCurrencyDLR17_RBS0_STR$17
23MFGRNAME SearchManufacturer NameStringSTR25_LB25
24SERLNMBR SearchSerial NumberStringSTR20_LBAU20
25MODELNUMBER SearchModel NumberStringSTR20_LBAU20
26WARRENTYDATE SearchWarranty DateDateDT8
27CUSTODIAN SearchCustodianStringSTR25_LB25
28NOTEINDX SearchNote IndexCurrencyDLR1414
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Asset General Information Master'].NOTEINDX AS 'Asset General Information Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       FA00100 AS ['Asset General Information Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Asset General Information Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
29DATEADDED SearchDate AddedDateDT8
30DELETEDATE SearchDelete DateDateDT8
31Physical_Location_ID SearchPhysical Location IDStringSTR15_Physical_Location_ID15
32Asset_Label SearchAsset LabelStringSTR19_Asset_Label19
33Verified_Date SearchVerified DateDateDT8
34PIN SearchPINStringSTR15_PIN15
35LASTPURCHLINESEQ SearchLast Purchase Line SequenceLong IntegerLI9_PurchaseLineSequence9
36LASTMNTDDATE SearchLast Maintained DateDateDT8
37LASTMNTDTIME SearchLast Maintained TimeTimeTM66
38LASTMNTDUSERID SearchLast Maintained User IDStringUser_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Asset General Information Master'].LASTMNTDUSERID AS 'Asset General Information Master-Last Maintained User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       FA00100 AS ['Asset General Information Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Asset General Information Master'].LASTMNTDUSERID = ['Users Master'].USERID
39aaAliasID SearchaaAliasIDLong IntegerLong Int8
40IncludeTaxInAcqustCost SearchInclude Tax in Acquisition CostBooleanCBIncludeTaxinAcquisitionCost0
azurecurveProductsFixed Assets (309)FinancialAsset General Information Master (FA00100)

Leave a Reply

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