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: Financial

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 TypeSQL DB LengthKeyable Length
1FINANCIALINDX SearchFinancial IndexLI_14Long Integer414
2ASSETINDEX SearchAsset IndexLI9_Asset_IndexLong Integer49
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 IndexLI_14Long Integer414
4FA_Doc_Number SearchFA Document NumberSTR16_LBAUString1816
5TRANSDATESTAMP SearchTransaction Date StampDTDate48
6TRANSTIMESTAMP SearchTransaction Time StampTM6Time46
7FISCALYRADDED SearchFiscal Year AddedINT4_U0Integer24
8FAYEAR SearchFA YearYearInteger24
9FAPERIOD SearchFA PeriodINT3Integer23
10DEPRFROMDATE SearchDepreciation from DateDTDate48
11AMOUNT SearchAmountDLR19_RBS0_STR$Currency1019
12DEPRTODATE SearchDepreciated to DateDTDate48
13AMOUNT SearchAmountDLR17_RBS0_STR$Currency1017
14TRANSUSERID SearchTransaction User IDUser_IDString1615
15SOURCDOC SearchSource DocumentSTR10_Source_DocumentString1210
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
16TRANSACCTTYPE SearchTransaction Account TypeDDL_Transaction_Account_TypeInteger20
17INTERFACEGL SearchInterface to GLCB_Interface_to_GLBoolean20
18GLINTTRXDATE SearchGL Interface TRX DateDTDate48
19GLINTDATESTAMP SearchGL Interface Date StampDTDate48
20GLINTTIMESTAMP SearchGL Interface Time StampTM6Time46
21GLINTACCTINDX SearchGL Interface Account IndexLI_14Long Integer414
22GLINTBTCHNUM SearchGL Interface Batch NumberSTR15_LBAUString1615
23FA_Reset_Offset_Index SearchFA Reset Offset IndexLI_14Long Integer414
24FA_Reset_User_ID SearchFA Reset User IDUser_IDString1615
25FA_Reset_Date SearchFA Reset DateDTDate48
26FA_Reset_Time SearchFA Reset TimeTM6Time46
27Ledger_ID SearchLedger IDINT2Integer22
28REFRENCE SearchReferenceSTR30String3230
29DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

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

Leave a Reply

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