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: Financial

Display Name: Asset General Information Master
Physical Name: FA00100
Technical Name: FA_General_Information_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
2ASSETID SearchAsset IDSTR15_Asset_IDString1615
3ASSETIDSUF SearchAsset ID SuffixINT3_U0Integer23
4SHRTNAME SearchShort NameSTR15String1615
5ASSETDESC SearchAsset DescriptionSTR40_Asset_DescriptionString4240
6EXTASSETDESC SearchExtended Asset DescriptionSTR40_Asset_DescriptionString4240
7Master_Asset_ID SearchMaster Asset IDSTR19_Master_Asset_IDString2019
8STRUCTUREID SearchStructure IDSTR30_Structure_IDString3230
9ASSETCLASSID SearchAsset Class IDSTR15_Asset_Class_IDString1615
10LOCATNID SearchLocation IDSTR15_Location_IDString1615
11ACQDATE SearchAcquisition DateDTDate48
12Acquisition_Cost SearchAcquisition CostDLR14_RBS2_TCurrency1014
13Acquisition_Cost SearchAcquisition CostDLR17_RBS0_STR$Currency1017
14ASSETTYPE SearchAsset TypeDDL_Asset_TypeInteger20
15ASSETSTATUS SearchAsset StatusVS_Asset_StatusInteger20
16PROPTYPE SearchProperty TypeDDL_Property_TypeInteger20
17ASSETQTY SearchAsset QuantityLI6_ST0Long Integer46
18ASSETBEGQTY SearchAsset Begin QuantityLI6_ST0Long Integer46
19ASSETCURRMAINT SearchCurrent Maintenance AmountDLR14_RBS2_TCurrency1014
20ASSETCURRMAINT SearchCurrent Maintenance AmountDLR17_RBS0_STR$Currency1017
21ASSETYTDMAINT SearchYTD Maintenance AmountDLR17_RBS0_STR$Currency1017
22ASSETYTDMAINT SearchYTD Maintenance AmountDLR14_RBS2_TCurrency1014
23ASSETLTDMAINT SearchLTD Maintenance AmountDLR14_RBS2_TCurrency1014
24ASSETLTDMAINT SearchLTD Maintenance AmountDLR17_RBS0_STR$Currency1017
25LASTMAINTDATE SearchLast Maintenance DateDTDate48
26ASSESSEDVALUE SearchAssessed ValueDLR14_RBS0_TCurrency1014
27ASSESSEDVALUE SearchAssessed ValueDLR17_RBS0_STR$Currency1017
28MFGRNAME SearchManufacturer NameSTR25_LBString2625
29SERLNMBR SearchSerial NumberSTR20_LBAUString2220
30MODELNUMBER SearchModel NumberSTR20_LBAUString2220
31WARRENTYDATE SearchWarranty DateDTDate48
32CUSTODIAN SearchCustodianSTR25_LBString2625
33NOTEINDX SearchNote IndexDLR14Currency1014
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
34DATEADDED SearchDate AddedDTDate48
35DELETEDATE SearchDelete DateDTDate48
36Physical_Location_ID SearchPhysical Location IDSTR15_Physical_Location_IDString1615
37Asset_Label SearchAsset LabelSTR19_Asset_LabelString2019
38Verified_Date SearchVerified DateDTDate48
39PIN SearchPINSTR15_PINString1615
40LASTPURCHLINESEQ SearchLast Purchase Line SequenceLI9_PurchaseLineSequenceLong Integer49
41LASTPURCHLINESEQ SearchLast Purchase Line SequenceLong IntLong Integer48
42LASTMNTDDATE SearchLast Maintained DateDTDate48
43LASTMNTDTIME SearchLast Maintained TimeTM6Time46
44LASTMNTDUSERID SearchLast Maintained User IDUser_IDString1615
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
45aaAliasID SearchaaAliasIDLong IntLong Integer48
46IncludeTaxInAcqustCost SearchInclude Tax in Acquisition CostCBIncludeTaxinAcquisitionCostBoolean20
47DEX_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)FinancialAsset General Information Master (FA00100)

Leave a Reply

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