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_ReportSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 TRANSFERINDX 
Transfer Index Long Integer LI_14 14 2 TRANSFEREVENT Transfer Event Long Integer LI_14 14 3 ASSETID Asset ID String STR15_Asset_ID 15 4 ASSETINDEX Asset Index Long Integer LI9_Asset_Index 9 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'].ASSETINDEX5 DSCRIPTN Description String STR30 30 6 RETIREMENTDATE Retirement Date Date DT 8 7 Dest_Asset_ID Dest Asset ID String STR15_Asset_ID 15 8 Acquisition_Cost Acquisition Cost Currency DLR17_RBS0_STR$ 17 9 ACQDATE Acquisition Date Date DT 8 10 Physical_Location_ID Physical Location ID String STR15_Physical_Location_ID 15 11 LOCATNID Location ID String STR15_Location_ID 15 12 ERRVAL ErrorValue Long Integer Long Int 8