Fixed Assets General Ledger Interface WORK (FA00905)

azurecurveProductsFixed Assets (309)SystemFixed Assets General Ledger Interface WORK (FA00905)

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

Product: Fixed Assets (309)
Series: Financial

Display Name: Fixed Assets General Ledger Interface WORK
Physical Name: FA00905
Technical Name: FA_GL_Interface_WORK

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1GLINTBTCHNUM SearchGL Interface Batch NumberSTR15_LBAUString1615
2GLINTTRXDATE SearchGL Interface TRX DateDTDate48
3FINANCIALINDX SearchFinancial IndexLI_14Long Integer414
4ACTINDX SearchAccount IndexLI_14Long Integer414
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'].ACTINDX
5ASSETINDEX SearchAsset IndexLI9_Asset_IndexLong Integer49
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'].ASSETINDEX
6FAYEAR SearchFA YearYearInteger24
7FAPERIOD SearchFA PeriodINT3Integer23
8DEPRFROMDATE SearchDepreciation from DateDTDate48
9DEPRTODATE SearchDepreciated to DateDTDate48
10SOURCDOC SearchSource DocumentSTR10_Source_DocumentString1210
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'].SOURCDOC
11AMOUNT SearchAmountDLR17_RBS0_STR$Currency1017
12BOOKINDX SearchBook IndexLI_14Long Integer414
13Ledger_ID SearchLedger IDINT2Integer22
14TRANSACCTTYPE SearchTransaction Account TypeDDL_Transaction_Account_TypeInteger20
15REFRENCE SearchReferenceSTR30String3230
16FA_Doc_Number SearchFA Document NumberSTR16_LBAUString1816
17DEX_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)SystemFixed Assets General Ledger Interface WORK (FA00905)

Leave a Reply

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