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 TypeLength
1ASSETINDEX SearchAsset IndexLI9_Asset_IndexLong Integer9
2ASSETID SearchAsset IDSTR15_Asset_IDString15
3ASSETIDSUF SearchAsset ID SuffixINT3_U0Integer3
4SHRTNAME SearchShort NameSTR15String15
5ASSETDESC SearchAsset DescriptionSTR40_Asset_DescriptionString40
6EXTASSETDESC SearchExtended Asset DescriptionSTR40_Asset_DescriptionString40
7Master_Asset_ID SearchMaster Asset IDSTR19_Master_Asset_IDString19
8STRUCTUREID SearchStructure IDSTR30_Structure_IDString30
9ASSETCLASSID SearchAsset Class IDSTR15_Asset_Class_IDString15
10LOCATNID SearchLocation IDSTR15_Location_IDString15
11ACQDATE SearchAcquisition DateDTDate8
12Acquisition_Cost SearchAcquisition CostDLR14_RBS2_TCurrency14
13Acquisition_Cost SearchAcquisition CostDLR17_RBS0_STR$Currency17
14ASSETTYPE SearchAsset TypeDDL_Asset_TypeInteger0
15ASSETSTATUS SearchAsset StatusVS_Asset_StatusInteger0
16PROPTYPE SearchProperty TypeDDL_Property_TypeInteger0
17ASSETQTY SearchAsset QuantityLI6_ST0Long Integer6
18ASSETBEGQTY SearchAsset Begin QuantityLI6_ST0Long Integer6
19ASSETCURRMAINT SearchCurrent Maintenance AmountDLR14_RBS2_TCurrency14
20ASSETCURRMAINT SearchCurrent Maintenance AmountDLR17_RBS0_STR$Currency17
21ASSETYTDMAINT SearchYTD Maintenance AmountDLR17_RBS0_STR$Currency17
22ASSETYTDMAINT SearchYTD Maintenance AmountDLR14_RBS2_TCurrency14
23ASSETLTDMAINT SearchLTD Maintenance AmountDLR14_RBS2_TCurrency14
24ASSETLTDMAINT SearchLTD Maintenance AmountDLR17_RBS0_STR$Currency17
25LASTMAINTDATE SearchLast Maintenance DateDTDate8
26ASSESSEDVALUE SearchAssessed ValueDLR14_RBS0_TCurrency14
27ASSESSEDVALUE SearchAssessed ValueDLR17_RBS0_STR$Currency17
28MFGRNAME SearchManufacturer NameSTR25_LBString25
29SERLNMBR SearchSerial NumberSTR20_LBAUString20
30MODELNUMBER SearchModel NumberSTR20_LBAUString20
31WARRENTYDATE SearchWarranty DateDTDate8
32CUSTODIAN SearchCustodianSTR25_LBString25
33NOTEINDX SearchNote IndexDLR14Currency14
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 AddedDTDate8
35DELETEDATE SearchDelete DateDTDate8
36Physical_Location_ID SearchPhysical Location IDSTR15_Physical_Location_IDString15
37Asset_Label SearchAsset LabelSTR19_Asset_LabelString19
38Verified_Date SearchVerified DateDTDate8
39PIN SearchPINSTR15_PINString15
40LASTPURCHLINESEQ SearchLast Purchase Line SequenceLI9_PurchaseLineSequenceLong Integer9
41LASTPURCHLINESEQ SearchLast Purchase Line SequenceLong IntLong Integer8
42LASTMNTDDATE SearchLast Maintained DateDTDate8
43LASTMNTDTIME SearchLast Maintained TimeTM6Time6
44LASTMNTDUSERID SearchLast Maintained User IDUser_IDString15
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 Integer8
46IncludeTaxInAcqustCost SearchInclude Tax in Acquisition CostCBIncludeTaxinAcquisitionCostBoolean0
47DEX_ROW_ID Searchintint10

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 *