Asset Book Master (FA00200)

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

Product: Fixed Assets (309)
Series: Financial

Display Name: Asset Book Master
Physical Name: FA00200
Technical Name: FA_Book_Asset_WORK

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1ASSETINDEX SearchAsset IndexLI9_Asset_IndexLong Integer49
Key to the Asset General Information Master (FA00100).

Click to show/hide

SELECT
       ['Asset Book Master'].ASSETINDEX AS 'Asset Book Master-Asset Index'
       ,['Asset General Information Master'].ASSETINDEX AS 'Asset General Information Master-Asset Index'
FROM
       FA00200 AS ['Asset Book Master']
INNER JOIN
       FA00100 AS ['Asset General Information Master']
              ON
                     ['Asset Book Master'].ASSETINDEX = ['Asset General Information Master'].ASSETINDEX
2BOOKINDX SearchBook IndexLI_14Long Integer414
3PLINSERVDATE SearchPlace in Service DateDTDate48
4DELETEDATE SearchDelete DateDTDate48
5DEPRBEGDATE SearchDepreciation Begin DateDTDate48
6FULLYDEPRFLAG SearchFully Depreciated FlagSTR1String21
7FULLYDEPRDATE SearchFully Depreciated DateDTDate48
8ORIGINALLIFEYEARS SearchOriginal Life YearsINT2_Life_YearsInteger22
9ORIGINALLIFEDAYS SearchOriginal Life DaysINT3_Life_DaysInteger23
10REMAININGLIFEYEARS SearchRemaining Life YearsINT2_Life_YearsInteger22
11REMAININGLIFEDAYS SearchRemaining Life DaysINT3_Life_DaysInteger23
12DEPRTODATE SearchDepreciated to DateDTDate48
13LASTRECALCDATE SearchLast Recalc DateDTDate48
14LASTRECALCDATEFISYR SearchLast Recalc Date Fiscal YearINT4_U0Integer24
15BEGINYEARCOST SearchBegin Year CostDLR17_RBS0_STR$Currency1017
16BAGINSALVAGE SearchBegin SalvageDLR17_RBS0_STR$Currency1017
17BEGINRESERVE SearchBegin ReserveDLR17_RBS0_STR$Currency1017
18COSTBASIS SearchCost BasisDLR17_RBS0_STR$Currency1017
19SALVAGEVALUE SearchSalvage ValueDLR17_RBS0_STR$Currency1017
20DEPRECIATIONMETHOD SearchDepreciation MethodDDL_Depreciation_MethodInteger20
21AVERAGINGCONV SearchAveraging ConventionDDL_Averaging_ConventionInteger20
22SWITCHOVER SearchSwitchoverDDL_SwitchoverInteger20
23SWITCHFM1METHOD SearchSwitch from 1 MethodDDL_Depreciation_MethodInteger20
24SWITCHFM1AMOUNT SearchSwitch from 1 AmountDLR17_RBS0_STR$Currency1017
25SWITCHFM1DATE SearchSwitch from 1 DateDTDate48
26DLYDEPRRATE SearchDaily Depreciation RateDLR17_RBS4_STR$Currency1017
27PERDEPRRATE SearchPeriodic Depreciation RateDLR17_RBS4_STR$Currency1017
28YRLYDEPRRATE SearchYearly Depreciation RateDLR17_RBS4_STR$Currency1017
29SAVEDLYDEPRRATE SearchSave Daily Depreciation RateDLR17_RBS4_STR$Currency1017
30SAVEPERDEPRRATE SearchSave Periodic Depreciation RateDLR17_RBS4_STR$Currency1017
31SAVEYRLYDEPRRATE SearchSave Yearly Depreciation RateDLR17_RBS4_STR$Currency1017
32AMORTIZATIONCODE SearchAmortization CodeDDL_Amortization_CodeInteger20
33AMORTIZATIONAMOUNT SearchAmortization AmountDLR17_RBS0_STR$Currency1017
34CURRUNDEPRAMT SearchCurrent Run Depreciation AmountDLR17_RBS0_STR$Currency1017
35PREVRUNDEPRAMT SearchPrevious Run Depreciation AmountDLR17_RBS0_STR$Currency1017
36YTDDEPRAMT SearchYTD Depreciation AmountDLR17_RBS0_STR$Currency1017
37LTDDEPRAMT SearchLTD Depreciation AmountDLR17_RBS0_STR$Currency1017
38NETBOOKVALUE SearchNet Book ValueDLR17_RBS0_STR$Currency1017
39LUXAUTOIND SearchLuxury Automobile IndicatorDDL_Luxury_AutomobileInteger20
40PRORATEDRETDATE SearchProrated Retirement DateDTDate48
41DEPRTODATEBFRET SearchDepreciated to Date Before RetireDTDate48
42RECGAINLOSS SearchRecognized Gain LossDLR17_RBS0_STR$Currency1017
43NONRECGAINLOSS SearchNon-Recognized Gain LossDLR17_RBS0_STR$Currency1017
44STLINEDEPRATRET SearchStraight Line Depreciation at RetirementDLR17_RBS0_STR$Currency1017
45COSTBFRETORDEL SearchCost Before Retire or DeleteDLR17_RBS0_STR$Currency1017
46Initial_Allowance_Perc SearchInitial Allowance PercentageINT5_%2Integer25
47Initial_Allowance_Amount SearchInitial Allowance AmountDLR17_RBS0_STR$Currency1017
48SPECDEPRALLOW SearchSpecial Depreciation AllowanceDDL_SpecialDepreciationAllowanceInteger20
49SPECDEPRALLOWPCT SearchSpecial Depreciation Allowance PercentageINT5_%2Integer25
50SPECDEPRALLOWAMT SearchSpecial Depreciation Allowance AmountDLR17_RBS0_STR$Currency1017
51NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['Asset Book Master'].NOTEINDX AS 'Asset Book Master-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       FA00200 AS ['Asset Book Master']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['Asset Book Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX
52DATEADDED SearchDate AddedDTDate48
53LASTMNTDDATE SearchLast Maintained DateDTDate48
54LASTMNTDTIME SearchLast Maintained TimeTM6Time46
55LASTMNTDUSERID SearchLast Maintained User IDUser_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['Asset Book Master'].LASTMNTDUSERID AS 'Asset Book Master-Last Maintained User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       FA00200 AS ['Asset Book Master']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Asset Book Master'].LASTMNTDUSERID = ['Users Master'].USERID
56LUXVANTRUCK SearchLuxury Van or TruckCBBoolean20
57LUXELAUTO SearchLuxury Electric AutoCBBoolean20
58DEX_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.

Leave a Reply

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