FA00200 - Asset Book Master | Prospr - Dynamics GP Table Reference

FA00200 - Asset Book Master

Query Builder

Select * from FA00200

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

FA00200 - Asset Book Master

Query Builder

Customer Service

Information

My Account

Contact Us