Asset Financial Detail Master WORK (FA00904)

azurecurveProductsFixed Assets (309)FinancialAsset Financial Detail Master WORK (FA00904)

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

Product: Fixed Assets (309)
Series: Financial

Display Name: Asset Financial Detail Master WORK
Physical Name: FA00904
Technical Name: FA_Financial_DTL_WORK

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

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 WORK'].ASSETINDEX AS 'Asset Financial Detail Master WORK-Asset Index'
       ,['Asset General Information Master'].ASSETINDEX AS 'Asset General Information Master-Asset Index'
FROM
       FA00904 AS ['Asset Financial Detail Master WORK']
INNER JOIN
       FA00100 AS ['Asset General Information Master']
              ON
                     ['Asset Financial Detail Master WORK'].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
11DEPRTODATE SearchDepreciated to DateDTDate48
12AMOUNT SearchAmountDLR17_RBS0_STR$Currency1017
13TRANSUSERID SearchTransaction User IDUser_IDString1615
14SOURCDOC SearchSource DocumentSTR10_Source_DocumentString1210
Key to the Source Document Master (SY00900).

Click to show/hide

SELECT
       ['Asset Financial Detail Master WORK'].SOURCDOC AS 'Asset Financial Detail Master WORK-Source Document'
       ,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
       FA00904 AS ['Asset Financial Detail Master WORK']
INNER JOIN
       SY00900 AS ['Source Document Master']
              ON
                     ['Asset Financial Detail Master WORK'].SOURCDOC = ['Source Document Master'].SOURCDOC
15TRANSACCTTYPE SearchTransaction Account TypeDDL_Transaction_Account_TypeInteger20
16INTERFACEGL SearchInterface to GLCB_Interface_to_GLBoolean20
17GLINTTRXDATE SearchGL Interface TRX DateDTDate48
18GLINTDATESTAMP SearchGL Interface Date StampDTDate48
19GLINTTIMESTAMP SearchGL Interface Time StampTM6Time46
20GLINTACCTINDX SearchGL Interface Account IndexLI_14Long Integer414
21GLINTBTCHNUM SearchGL Interface Batch NumberSTR15_LBAUString1615
22FA_Reset_Offset_Index SearchFA Reset Offset IndexLI_14Long Integer414
23FA_Reset_User_ID SearchFA Reset User IDUser_IDString1615
24FA_Reset_Date SearchFA Reset DateDTDate48
25FA_Reset_Time SearchFA Reset TimeTM6Time46
26Ledger_ID SearchLedger IDINT2Integer22
27REFRENCE SearchReferenceSTR30String3230
28DEX_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 WORK (FA00904)

Leave a Reply

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