Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/FA00905
Product: Fixed Assets (309)
Series:
Display Name: Fixed Assets General Ledger Interface WORK
Physical Name: FA00905
Technical Name: FA_GL_Interface_WORKSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 GLINTBTCHNUM 
GL Interface Batch Number String STR15_LBAU 15 2 GLINTTRXDATE GL Interface TRX Date Date DT 8 3 FINANCIALINDX Financial Index Long Integer LI_14 14 4 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['Fixed Assets General Ledger Interface WORK'].ACTINDX AS 'Fixed Assets General Ledger Interface WORK-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
FA00905 AS ['Fixed Assets General Ledger Interface WORK']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['Fixed Assets General Ledger Interface WORK'].ACTINDX = ['Account Index Master'].ACTINDX5 ASSETINDEX Asset Index Long Integer LI9_Asset_Index 9 Key to the Asset General Information Master (FA00100).
Click to show/hide
SELECT
['Fixed Assets General Ledger Interface WORK'].ASSETINDEX AS 'Fixed Assets General Ledger Interface WORK-Asset Index'
,['Asset General Information Master'].ASSETINDEX AS 'Asset General Information Master-Asset Index'
FROM
FA00905 AS ['Fixed Assets General Ledger Interface WORK']
INNER JOIN
FA00100 AS ['Asset General Information Master']
ON
['Fixed Assets General Ledger Interface WORK'].ASSETINDEX = ['Asset General Information Master'].ASSETINDEX6 FAYEAR FA Year Integer Year 4 7 FAPERIOD FA Period Integer INT3 3 8 DEPRFROMDATE Depreciation from Date Date DT 8 9 DEPRTODATE Depreciated to Date Date DT 8 10 SOURCDOC Source Document String STR10_Source_Document 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['Fixed Assets General Ledger Interface WORK'].SOURCDOC AS 'Fixed Assets General Ledger Interface WORK-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
FA00905 AS ['Fixed Assets General Ledger Interface WORK']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['Fixed Assets General Ledger Interface WORK'].SOURCDOC = ['Source Document Master'].SOURCDOC11 AMOUNT Amount Currency DLR17_RBS0_STR$ 17 12 BOOKINDX Book Index Long Integer LI_14 14 13 Ledger_ID Ledger ID Integer INT2 2 14 TRANSACCTTYPE Transaction Account Type Integer DDL_Transaction_Account_Type 0 15 REFRENCE Reference String STR30 30 16 FA_Doc_Number FA Document Number String STR16_LBAU 16