Asset Financial Detail Master (FA00902)

azurecurveProductsFixed Assets (309)FinancialAsset Financial Detail Master (FA00902)

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

Product: Fixed Assets (309)
Series:

Display Name: Asset Financial Detail Master
Physical Name: FA00902
Technical Name: FA_Financial_DTL_MSTR

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1FINANCIALINDX SearchFinancial IndexLong IntegerLI_1414
2ASSETINDEX SearchAsset IndexLong IntegerLI9_Asset_Index9
Key to the Asset General Information Master (FA00100).

Click to show/hide

SELECT
       ['Asset Financial Detail Master'].ASSETINDEX AS 'Asset Financial Detail Master-Asset Index'
       ,['Asset General Information Master'].ASSETINDEX AS 'Asset General Information Master-Asset Index'
FROM
       FA00902 AS ['Asset Financial Detail Master']
INNER JOIN
       FA00100 AS ['Asset General Information Master']
              ON
                     ['Asset Financial Detail Master'].ASSETINDEX = ['Asset General Information Master'].ASSETINDEX
3BOOKINDX SearchBook IndexLong IntegerLI_1414
4FA_Doc_Number SearchFA Document NumberStringSTR16_LBAU16
5TRANSDATESTAMP SearchTransaction Date StampDateDT8
6TRANSTIMESTAMP SearchTransaction Time StampTimeTM66
7FISCALYRADDED SearchFiscal Year AddedIntegerINT4_U04
8FAYEAR SearchFA YearIntegerYear4
9FAPERIOD SearchFA PeriodIntegerINT33
10DEPRFROMDATE SearchDepreciation from DateDateDT8
11DEPRTODATE SearchDepreciated to DateDateDT8
12AMOUNT SearchAmountCurrencyDLR17_RBS0_STR$17
13TRANSUSERID SearchTransaction User IDStringUser_ID15
14SOURCDOC SearchSource DocumentStringSTR10_Source_Document10
Key to the Source Document Master (SY00900).

Click to show/hide

SELECT
       ['Asset Financial Detail Master'].SOURCDOC AS 'Asset Financial Detail Master-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       FA00902 AS ['Asset Financial Detail Master']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['Asset Financial Detail Master'].SOURCDOC = ['Source Document Master'].SOURCDOC
15TRANSACCTTYPE SearchTransaction Account TypeIntegerDDL_Transaction_Account_Type0
16INTERFACEGL SearchInterface to GLBooleanCB_Interface_to_GL0
17GLINTTRXDATE SearchGL Interface TRX DateDateDT8
18GLINTDATESTAMP SearchGL Interface Date StampDateDT8
19GLINTTIMESTAMP SearchGL Interface Time StampTimeTM66
20GLINTACCTINDX SearchGL Interface Account IndexLong IntegerLI_1414
21GLINTBTCHNUM SearchGL Interface Batch NumberStringSTR15_LBAU15
22FA_Reset_Offset_Index SearchFA Reset Offset IndexLong IntegerLI_1414
23FA_Reset_User_ID SearchFA Reset User IDStringUser_ID15
24FA_Reset_Date SearchFA Reset DateDateDT8
25FA_Reset_Time SearchFA Reset TimeTimeTM66
26Ledger_ID SearchLedger IDIntegerINT22
27REFRENCE SearchReferenceStringSTR3030
azurecurveProductsFixed Assets (309)FinancialAsset Financial Detail Master (FA00902)

Leave a Reply

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