PO Additional Information Master (FA01300)

azurecurveProductsFixed Assets (309)FinancialPO Additional Information Master (FA01300)

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

Product: Fixed Assets (309)
Series:

Display Name: PO Additional Information Master
Physical Name: FA01300
Technical Name: FA_PO_Additional_Information_MSTR

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1POPRCTNM SearchPOP Receipt NumberStringSTR17_POP_Number17
2RCPTLNNM SearchReceipt Line NumberLong IntegerLI_Sequence_Number10
3ASSETID SearchAsset IDStringSTR15_Asset_ID15
4ASSETIDSUF SearchAsset ID SuffixIntegerINT3_U03
5SHRTNAME SearchShort NameStringSTR1515
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
11ASSETTYPE SearchAsset TypeIntegerDDL_Asset_Type0
12PROPTYPE SearchProperty TypeIntegerDDL_Property_Type0
13Create_Multiple_Fixed_As SearchCreate Multiple Fixed AssetsBooleanCB_Create_Multiple_Fixed_Assets0
14ASSETCURRMAINT SearchCurrent Maintenance AmountCurrencyDLR17_RBS0_STR$17
15ASSETYTDMAINT SearchYTD Maintenance AmountCurrencyDLR17_RBS0_STR$17
16ASSETLTDMAINT SearchLTD Maintenance AmountCurrencyDLR17_RBS0_STR$17
17LASTMAINTDATE SearchLast Maintenance DateDateDT8
18ASSESSEDVALUE SearchAssessed ValueCurrencyDLR17_RBS0_STR$17
19MFGRNAME SearchManufacturer NameStringSTR25_LB25
20SERLNMBR SearchSerial NumberStringSTR20_LBAU20
21MODELNUMBER SearchModel NumberStringSTR20_LBAU20
22WARRENTYDATE SearchWarranty DateDateDT8
23CUSTODIAN SearchCustodianStringSTR25_LB25
24Physical_Location_ID SearchPhysical Location IDStringSTR15_Physical_Location_ID15
25Asset_Label SearchAsset LabelStringSTR19_Asset_Label19
26Verified_Date SearchVerified DateDateDT8
27PIN SearchPINStringSTR15_PIN15
28LASTMNTDDATE SearchLast Maintained DateDateDT8
29LASTMNTDTIME SearchLast Maintained TimeTimeTM66
30LASTMNTDUSERID SearchLast Maintained User IDStringUser_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['PO Additional Information Master'].LASTMNTDUSERID AS 'PO Additional Information Master-Last Maintained User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       FA01300 AS ['PO Additional Information Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['PO Additional Information Master'].LASTMNTDUSERID = ['Users Master'].USERID
31ORTAXAMT SearchOriginating Tax AmountCurrencyDLR17_RBS0_UTR$17
32IncludeTaxInAcqustCost SearchInclude Tax in Acquisition CostBooleanCBIncludeTaxinAcquisitionCost0
azurecurveProductsFixed Assets (309)FinancialPO Additional Information Master (FA01300)

Leave a Reply

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