FA_Intercompany_Transfer_Report (FA00802)

azurecurveProductsFixed Assets (309)FinancialFA_Intercompany_Transfer_Report (FA00802)

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

Product: Fixed Assets (309)
Series:

Display Name: FA_Intercompany_Transfer_Report
Physical Name: FA00802
Technical Name: FA_Intercompany_Transfer_Report

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1TRANSFERINDX SearchTransfer IndexLong IntegerLI_1414
2TRANSFEREVENT SearchTransfer EventLong IntegerLI_1414
3ASSETID SearchAsset IDStringSTR15_Asset_ID15
4ASSETINDEX SearchAsset IndexLong IntegerLI9_Asset_Index9
Key to the Asset General Information Master (FA00100).

Click to show/hide

SELECT
       ['FA_Intercompany_Transfer_Report'].ASSETINDEX AS 'FA_Intercompany_Transfer_Report-Asset Index'
       ,['Asset General Information Master'].ASSETINDEX AS 'Asset General Information Master-Asset Index'
FROM
       FA00802 AS ['FA_Intercompany_Transfer_Report']
INNER JOIN
       FA00100 AS ['Asset General Information Master']
              ON
                     ['FA_Intercompany_Transfer_Report'].ASSETINDEX = ['Asset General Information Master'].ASSETINDEX
5DSCRIPTN SearchDescriptionStringSTR3030
6RETIREMENTDATE SearchRetirement DateDateDT8
7Dest_Asset_ID SearchDest Asset IDStringSTR15_Asset_ID15
8Acquisition_Cost SearchAcquisition CostCurrencyDLR17_RBS0_STR$17
9ACQDATE SearchAcquisition DateDateDT8
10Physical_Location_ID SearchPhysical Location IDStringSTR15_Physical_Location_ID15
11LOCATNID SearchLocation IDStringSTR15_Location_ID15
12ERRVAL SearchErrorValueLong IntegerLong Int8
azurecurveProductsFixed Assets (309)FinancialFA_Intercompany_Transfer_Report (FA00802)

Leave a Reply

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