Asset Book Master (FA00200)

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

Product: Fixed Assets (309)
Series:

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

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ASSETINDEX SearchAsset IndexLong IntegerLI9_Asset_Index9
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 IndexLong IntegerLI_1414
3PLINSERVDATE SearchPlace in Service DateDateDT8
4DELETEDATE SearchDelete DateDateDT8
5DEPRBEGDATE SearchDepreciation Begin DateDateDT8
6FULLYDEPRFLAG SearchFully Depreciated FlagStringSTR11
7FULLYDEPRDATE SearchFully Depreciated DateDateDT8
8ORIGINALLIFEYEARS SearchOriginal Life YearsIntegerINT2_Life_Years2
9ORIGINALLIFEDAYS SearchOriginal Life DaysIntegerINT3_Life_Days3
10REMAININGLIFEYEARS SearchRemaining Life YearsIntegerINT2_Life_Years2
11REMAININGLIFEDAYS SearchRemaining Life DaysIntegerINT3_Life_Days3
12DEPRTODATE SearchDepreciated to DateDateDT8
13LASTRECALCDATE SearchLast Recalc DateDateDT8
14LASTRECALCDATEFISYR SearchLast Recalc Date Fiscal YearIntegerINT4_U04
15BEGINYEARCOST SearchBegin Year CostCurrencyDLR17_RBS0_STR$17
16BAGINSALVAGE SearchBegin SalvageCurrencyDLR17_RBS0_STR$17
17BEGINRESERVE SearchBegin ReserveCurrencyDLR17_RBS0_STR$17
18COSTBASIS SearchCost BasisCurrencyDLR17_RBS0_STR$17
19SALVAGEVALUE SearchSalvage ValueCurrencyDLR17_RBS0_STR$17
20DEPRECIATIONMETHOD SearchDepreciation MethodIntegerDDL_Depreciation_Method0
21AVERAGINGCONV SearchAveraging ConventionIntegerDDL_Averaging_Convention0
22SWITCHOVER SearchSwitchoverIntegerDDL_Switchover0
23SWITCHFM1METHOD SearchSwitch from 1 MethodIntegerDDL_Depreciation_Method0
24SWITCHFM1AMOUNT SearchSwitch from 1 AmountCurrencyDLR17_RBS0_STR$17
25SWITCHFM1DATE SearchSwitch from 1 DateDateDT8
26DLYDEPRRATE SearchDaily Depreciation RateCurrencyDLR17_RBS4_STR$17
27PERDEPRRATE SearchPeriodic Depreciation RateCurrencyDLR17_RBS4_STR$17
28YRLYDEPRRATE SearchYearly Depreciation RateCurrencyDLR17_RBS4_STR$17
29SAVEDLYDEPRRATE SearchSave Daily Depreciation RateCurrencyDLR17_RBS4_STR$17
30SAVEPERDEPRRATE SearchSave Periodic Depreciation RateCurrencyDLR17_RBS4_STR$17
31SAVEYRLYDEPRRATE SearchSave Yearly Depreciation RateCurrencyDLR17_RBS4_STR$17
32AMORTIZATIONCODE SearchAmortization CodeIntegerDDL_Amortization_Code0
33AMORTIZATIONAMOUNT SearchAmortization AmountCurrencyDLR17_RBS0_STR$17
34CURRUNDEPRAMT SearchCurrent Run Depreciation AmountCurrencyDLR17_RBS0_STR$17
35PREVRUNDEPRAMT SearchPrevious Run Depreciation AmountCurrencyDLR17_RBS0_STR$17
36YTDDEPRAMT SearchYTD Depreciation AmountCurrencyDLR17_RBS0_STR$17
37LTDDEPRAMT SearchLTD Depreciation AmountCurrencyDLR17_RBS0_STR$17
38NETBOOKVALUE SearchNet Book ValueCurrencyDLR17_RBS0_STR$17
39LUXAUTOIND SearchLuxury Automobile IndicatorIntegerDDL_Luxury_Automobile0
40PRORATEDRETDATE SearchProrated Retirement DateDateDT8
41DEPRTODATEBFRET SearchDepreciated to Date Before RetireDateDT8
42RECGAINLOSS SearchRecognized Gain LossCurrencyDLR17_RBS0_STR$17
43NONRECGAINLOSS SearchNon-Recognized Gain LossCurrencyDLR17_RBS0_STR$17
44STLINEDEPRATRET SearchStraight Line Depreciation at RetirementCurrencyDLR17_RBS0_STR$17
45COSTBFRETORDEL SearchCost Before Retire or DeleteCurrencyDLR17_RBS0_STR$17
46Initial_Allowance_Perc SearchInitial Allowance PercentageIntegerINT5_%25
47Initial_Allowance_Amount SearchInitial Allowance AmountCurrencyDLR17_RBS0_STR$17
48SPECDEPRALLOW SearchSpecial Depreciation AllowanceIntegerDDL_SpecialDepreciationAllowance0
49SPECDEPRALLOWPCT SearchSpecial Depreciation Allowance PercentageIntegerINT5_%25
50SPECDEPRALLOWAMT SearchSpecial Depreciation Allowance AmountCurrencyDLR17_RBS0_STR$17
51NOTEINDX SearchNote IndexCurrencyDLR1414
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 AddedDateDT8
53LASTMNTDDATE SearchLast Maintained DateDateDT8
54LASTMNTDTIME SearchLast Maintained TimeTimeTM66
55LASTMNTDUSERID SearchLast Maintained User IDStringUser_ID15
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 TruckBooleanCB0
57LUXELAUTO SearchLuxury Electric AutoBooleanCB0

Leave a Reply

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