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 TypeLength
1ASSETINDEX SearchAsset IndexLI9_Asset_IndexLong Integer9
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 Integer14
3PLINSERVDATE SearchPlace in Service DateDTDate8
4DELETEDATE SearchDelete DateDTDate8
5DEPRBEGDATE SearchDepreciation Begin DateDTDate8
6FULLYDEPRFLAG SearchFully Depreciated FlagSTR1String1
7FULLYDEPRDATE SearchFully Depreciated DateDTDate8
8ORIGINALLIFEYEARS SearchOriginal Life YearsINT2_Life_YearsInteger2
9ORIGINALLIFEDAYS SearchOriginal Life DaysINT3_Life_DaysInteger3
10REMAININGLIFEYEARS SearchRemaining Life YearsINT2_Life_YearsInteger2
11REMAININGLIFEDAYS SearchRemaining Life DaysINT3_Life_DaysInteger3
12DEPRTODATE SearchDepreciated to DateDTDate8
13LASTRECALCDATE SearchLast Recalc DateDTDate8
14LASTRECALCDATEFISYR SearchLast Recalc Date Fiscal YearINT4_U0Integer4
15BEGINYEARCOST SearchBegin Year CostDLR17_RBS0_STR$Currency17
16BAGINSALVAGE SearchBegin SalvageDLR17_RBS0_STR$Currency17
17BEGINRESERVE SearchBegin ReserveDLR17_RBS0_STR$Currency17
18COSTBASIS SearchCost BasisDLR17_RBS0_STR$Currency17
19SALVAGEVALUE SearchSalvage ValueDLR17_RBS0_STR$Currency17
20DEPRECIATIONMETHOD SearchDepreciation MethodDDL_Depreciation_MethodInteger0
21AVERAGINGCONV SearchAveraging ConventionDDL_Averaging_ConventionInteger0
22SWITCHOVER SearchSwitchoverDDL_SwitchoverInteger0
23SWITCHFM1METHOD SearchSwitch from 1 MethodDDL_Depreciation_MethodInteger0
24SWITCHFM1AMOUNT SearchSwitch from 1 AmountDLR17_RBS0_STR$Currency17
25SWITCHFM1DATE SearchSwitch from 1 DateDTDate8
26DLYDEPRRATE SearchDaily Depreciation RateDLR17_RBS4_STR$Currency17
27PERDEPRRATE SearchPeriodic Depreciation RateDLR17_RBS4_STR$Currency17
28YRLYDEPRRATE SearchYearly Depreciation RateDLR17_RBS4_STR$Currency17
29SAVEDLYDEPRRATE SearchSave Daily Depreciation RateDLR17_RBS4_STR$Currency17
30SAVEPERDEPRRATE SearchSave Periodic Depreciation RateDLR17_RBS4_STR$Currency17
31SAVEYRLYDEPRRATE SearchSave Yearly Depreciation RateDLR17_RBS4_STR$Currency17
32AMORTIZATIONCODE SearchAmortization CodeDDL_Amortization_CodeInteger0
33AMORTIZATIONAMOUNT SearchAmortization AmountDLR17_RBS0_STR$Currency17
34CURRUNDEPRAMT SearchCurrent Run Depreciation AmountDLR17_RBS0_STR$Currency17
35PREVRUNDEPRAMT SearchPrevious Run Depreciation AmountDLR17_RBS0_STR$Currency17
36YTDDEPRAMT SearchYTD Depreciation AmountDLR17_RBS0_STR$Currency17
37LTDDEPRAMT SearchLTD Depreciation AmountDLR17_RBS0_STR$Currency17
38NETBOOKVALUE SearchNet Book ValueDLR17_RBS0_STR$Currency17
39LUXAUTOIND SearchLuxury Automobile IndicatorDDL_Luxury_AutomobileInteger0
40PRORATEDRETDATE SearchProrated Retirement DateDTDate8
41DEPRTODATEBFRET SearchDepreciated to Date Before RetireDTDate8
42RECGAINLOSS SearchRecognized Gain LossDLR17_RBS0_STR$Currency17
43NONRECGAINLOSS SearchNon-Recognized Gain LossDLR17_RBS0_STR$Currency17
44STLINEDEPRATRET SearchStraight Line Depreciation at RetirementDLR17_RBS0_STR$Currency17
45COSTBFRETORDEL SearchCost Before Retire or DeleteDLR17_RBS0_STR$Currency17
46Initial_Allowance_Perc SearchInitial Allowance PercentageINT5_%2Integer5
47Initial_Allowance_Amount SearchInitial Allowance AmountDLR17_RBS0_STR$Currency17
48SPECDEPRALLOW SearchSpecial Depreciation AllowanceDDL_SpecialDepreciationAllowanceInteger0
49SPECDEPRALLOWPCT SearchSpecial Depreciation Allowance PercentageINT5_%2Integer5
50SPECDEPRALLOWAMT SearchSpecial Depreciation Allowance AmountDLR17_RBS0_STR$Currency17
51NOTEINDX SearchNote IndexDLR14Currency14
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 AddedDTDate8
53LASTMNTDDATE SearchLast Maintained DateDTDate8
54LASTMNTDTIME SearchLast Maintained TimeTM6Time6
55LASTMNTDUSERID SearchLast Maintained User IDUser_IDString15
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 TruckCBBoolean0
57LUXELAUTO SearchLuxury Electric AutoCBBoolean0
58DEX_ROW_ID Searchintint10

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 *