FA00200 - Asset Book Master

Dynamics GP table FA00200 (Asset Book Master) contains 57 columns including ASSETINDEX, BOOKINDX, PLINSERVDATE....

SQL Query Builder

SELECT * FROM FA00200

57 Columns

Select all

Column	Description	Type	Length	Shared With
ASSETINDEX	Asset Index	Long Integer	4	3 tables
BOOKINDX	Book Index	Long Integer	4	1 tables
PLINSERVDATE	Place in Service Date	Date	4	-
DELETEDATE	Delete Date	Date	4	1 tables
DEPRBEGDATE	Depreciation Begin Date	Date	4	-
FULLYDEPRFLAG	Fully Depreciated Flag	String	2	-
FULLYDEPRDATE	Fully Depreciated Date	Date	4	-
ORIGINALLIFEYEARS	Original Life Years	Integer	2	-
ORIGINALLIFEDAYS	Original Life Days	Integer	2	-
REMAININGLIFEYEARS	Remaining Life Years	Integer	2	-
REMAININGLIFEDAYS	Remaining Life Days	Integer	2	-
DEPRTODATE	Depreciated to Date	Date	4	-
LASTRECALCDATE	Last Recalc Date	Date	4	-
LASTRECALCDATEFISYR	Last Recalc Date Fiscal Year	Integer	2	-
BEGINYEARCOST	Begin Year Cost	Currency	10	-
BAGINSALVAGE	Begin Salvage	Currency	10	-
BEGINRESERVE	Begin Reserve	Currency	10	-
COSTBASIS	Cost Basis	Currency	10	-
SALVAGEVALUE	Salvage Value	Currency	10	-
DEPRECIATIONMETHOD	Depreciation Method	Integer	2	-
AVERAGINGCONV	Averaging Convention	Integer	2	-
SWITCHOVER	Switchover	Integer	2	-
SWITCHFM1METHOD	Switch from 1 Method	Integer	2	-
SWITCHFM1AMOUNT	Switch from 1 Amount	Currency	10	-
SWITCHFM1DATE	Switch from 1 Date	Date	4	-
DLYDEPRRATE	Daily Depreciation Rate	Currency	10	-
PERDEPRRATE	Periodic Depreciation Rate	Currency	10	-
YRLYDEPRRATE	Yearly Depreciation Rate	Currency	10	-
SAVEDLYDEPRRATE	Save Daily Depreciation Rate	Currency	10	-
SAVEPERDEPRRATE	Save Periodic Depreciation Rate	Currency	10	-
SAVEYRLYDEPRRATE	Save Yearly Depreciation Rate	Currency	10	-
AMORTIZATIONCODE	Amortization Code	Integer	2	-
AMORTIZATIONAMOUNT	Amortization Amount	Currency	10	-
CURRUNDEPRAMT	Current Run Depreciation Amount	Currency	10	-
PREVRUNDEPRAMT	Previous Run Depreciation Amount	Currency	10	-
YTDDEPRAMT	YTD Depreciation Amount	Currency	10	-
LTDDEPRAMT	LTD Depreciation Amount	Currency	10	-
NETBOOKVALUE	Net Book Value	Currency	10	-
LUXAUTOIND	Luxury Automobile Indicator	Integer	2	-
PRORATEDRETDATE	Prorated Retirement Date	Date	4	-
DEPRTODATEBFRET	Depreciated to Date Before Retire	Date	4	-
RECGAINLOSS	Recognized Gain Loss	Currency	10	-
NONRECGAINLOSS	Non-Recognized Gain Loss	Currency	10	-
STLINEDEPRATRET	Straight Line Depreciation at Retirement	Currency	10	-
COSTBFRETORDEL	Cost Before Retire or Delete	Currency	10	-
Initial_Allowance_Perc	Initial Allowance Percentage	Integer	2	-
Initial_Allowance_Amount	Initial Allowance Amount	Currency	10	-
SPECDEPRALLOW	Special Depreciation Allowance	Integer	2	-
SPECDEPRALLOWPCT	Special Depreciation Allowance Percentage	Integer	2	-
SPECDEPRALLOWAMT	Special Depreciation Allowance Amount	Currency	10	-
NOTEINDX	Note Index	Currency	10	114 tables
DATEADDED	Date Added	Date	4	1 tables
LASTMNTDDATE	Last Maintained Date	Date	4	3 tables
LASTMNTDTIME	Last Maintained Time	Time	4	3 tables
LASTMNTDUSERID	Last Maintained User ID	String	16	3 tables
LUXVANTRUCK	Luxury Van or Truck	Boolean	2	-
LUXELAUTO	Luxury Electric Auto	Boolean	2	-