FA45000 - Fixed Assets Report Options | Prospr

FA45000 - Fixed Assets Report Options

Query Builder

Select * from FA45000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
FILEXPNM	File Export Name	String	256	View
EXPTTYPE	Export Type	Integer	2	View
ASKECHTM	Ask Each Time	Boolean	2	View
IFFILXST	If File Existing	Integer	2	View
PRNTOFIL	Print to File	Boolean	2	View
PRTOPRTR	Print to Printer	Boolean	2	View
PRTOSCRN	Print to Screen	Boolean	2	View
PRNTTYPE	Print Type	Integer	2	View
RPTGRIND	Report Group Index	Integer	2	View
RTPACHIN	Report Palette Choice Index	Integer	2	View
RTGRSBIN	Report Group Sub Index	Currency	10	View
REPORTID	Report ID	Integer	2	View
FAREPTNAME	Fixed Assets Report Name	String	52	View
SORTBY	Sort By	Integer	2	View
Sort_By_Value	Sort By Value	String	42	View
BOOKINDX	Book Index	Long Integer	4	View
BOOKID	Book ID	String	16	View
CURRFISCALYR	Current Fiscal Year	Integer	2	View
Begin_Current_Fiscal_Yr	Begin Current Fiscal Year	Date	4	View
End_Current_Fiscal_Year	End Current Fiscal Year	Date	4	View
Second_Book_Index	Second Book Index	Long Integer	4	View
Second_Book_ID	Second Book ID	String	16	View
Current_Fiscal_Year_2	Second Current Fiscal Year	Integer	2	View
Second_Begin_Current_FY	Second Begin Current Fiscal Year	Date	4	View
Second_End_Current_FY	Second End Current Fiscal Year	Date	4	View
ACTIVE	Active 0 = False, for inactive records 1 = True, for active records	Boolean	2	View
RETIRED	Retired	Boolean	2	View
PARTIALOPEN	Partial Open	Boolean	2	View
Multicurrency_Information	Multicurrency Information CB	Boolean	2	View
In_Detail	In Detail	Boolean	2	View
Only_Not_Interfaced	Only Not Interfaced	Boolean	2	View
Start_Master_Asset_ID	Start Master Asset ID	String	20	View
End_Master_Asset_ID	End Master Asset ID	String	20	View
Start_Asset_ID	Start Asset ID	String	16	View
End_Asset_ID	End Asset ID	String	16	View
Start_Asset_ID_Suffix	Start Asset ID Suffix	Integer	2	View
End_Asset_ID_Suffix	End Asset ID Suffix	Integer	2	View
Start_Asset_Description	Start Asset Description	String	42	View
End_Asset_Description	End Asset Description	String	42	View
Start_Structure_ID	Start Structure ID	String	32	View
End_Structure_ID	End Structure ID	String	32	View
STTCLSID	Start Class ID	String	16	View
ENDCLSID	End Class ID	String	16	View
STTLOCID	Start Location ID	String	16	View
ENDLOCID	End Location ID	String	16	View
Start_YTD_Depreciation	Start YTD Depreciation Amount	Currency	10	View
End_YTD_Depreciation	End YTD Depreciation Amount	Currency	10	View
Start_LTD_Depreciation	Start LTD Depreciation Amount	Currency	10	View
End_LTD_Depreciation	End LTD Depreciation Amount	Currency	10	View
Start_Net_Book_Value	Start Net Book Value	Currency	10	View
End_Net_Book_Value	End Net Book Value	Currency	10	View
SSRCEDOC	Start Source Document	String	12	View
ENDSRCDC	End Source Document	String	12	View
Start_GL_Account_Index	Start G/L Account Index	Long Integer	4	View
End_GL_Account_Index	End G/L Account Index	Long Integer	4	View
Start_FA_Year	Start FA Year	Integer	2	View
End_FA_Year	End FA Year	Integer	2	View
Start_FA_Period	Start FA Period	Integer	2	View
End_FA_Period	End FA Period	Integer	2	View
Start_Property_Type	Start Property Type	Integer	2	View
End_Property_Type	End Property Type	Integer	2	View
Start_Asset_Type	Start Asset Type	Integer	2	View
End_Asset_Type	End Asset Type	Integer	2	View
Start_Asset_Quantity	Start Asset Quantity	Long Integer	4	View
End_Asset_Quantity	End Asset Quantity	Long Integer	4	View
Start_Original_Life_Year	Start Original Life Years	Integer	2	View
End_Original_Life_Years	End Original Life Years	Integer	2	View
Start_Original_Life_Days	Start Original Life Days	Integer	2	View
End_Original_Life_Days	End Original Life Days	Integer	2	View
Start_Remaining_Life_Yea	Start Remaining Life Years	Integer	2	View
End_Remaining_Life_Years	End Remaining Life Years	Integer	2	View
Start_Remaining_Life_Day	Start Remaining Life Days	Integer	2	View
End_Remaining_Life_Days	End Remaining Life Days	Integer	2	View
Start_Depr_Method	Start Depreciation Method	Integer	2	View
End_Depreciation_Method	End Depreciation Method	Integer	2	View
Start_Averaging_Conventi	Start Averaging Convention	Integer	2	View
End_Averaging_Convention	End Averaging Convention	Integer	2	View
Start_Amortization_Code	Start Amortization Code	Integer	2	View
End_Amortization_Code	End Amortization Code	Integer	2	View
Start_Retirement_Type	Start Retirement Type	Integer	2	View
End_Retirement_Type	End Retirement Type	Integer	2	View
Start_Trx_Acct_Type	Start Transaction Account Type	Integer	2	View
End_Trx_Acct_Type	End Transaction Account Type	Integer	2	View
Start_Cost_Basis	Start Cost Basis	Currency	10	View
End_Cost_Basis	End Cost Basis	Currency	10	View
Start_Fiscal_Year_Added	Start Fiscal Year Added	Integer	2	View
End_Fiscal_Year_Added	End Fiscal Year Added	Integer	2	View
Start_Place_in_Service	Start Place in Service Date	Date	4	View
End_Place_in_Service	End Place in Service Date	Date	4	View
Start_PIS_Token	Start Place in Service Date Token	String	26	View
End_PIS_Token	End Place in Service Date Token	String	26	View
Start_Acquisition_Date	Start Acquisition Date	Date	4	View
End_Acquisition_Date	End Acquisition Date	Date	4	View
Start_Acq_Token	Start Acquisition Date Token	String	26	View
End_Acq_Token	End Acquisition Date Token	String	26	View
Start_Date_Added	Start Date Added	Date	4	View
End_Date_Added	End Date Added	Date	4	View
Start_Date_Added_Token	Start Date Added Token	String	26	View
End_Date_Added_Token	End Date Added Token	String	26	View
Start_Fully_Depr_Date	Start Fully Depreciated Date	Date	4	View
End_Fully_Depr_Date	End Fully Depreciated Date	Date	4	View
Start_Fully_DTD_Token	Start Fully Depreciated Date Token	String	26	View
End_Fully_DTD_Token	End Fully Depreciated Date Token	String	26	View
Start_Retirement_Date	Start Retirement Date	Date	4	View
End_Retirement_Date	End Retirement Date	Date	4	View
Start_Ret_Date_Token	Start Retirement Date Token	String	26	View
End_Ret_Date_Token	End Retirement Date Token	String	26	View
Start_Transfer_Date	Start Transfer Date	Date	4	View
End_Transfer_Date	End Transfer Date	Date	4	View
Start_Transfer_Date_Toke	Start Transfer Date Token	String	26	View
End_Transfer_Date_Token	End Transfer Date Token	String	26	View
Start_Switchover_Date	Start Switchover Date	Date	4	View
End_Switchover_Date	End Switchover Date	Date	4	View
Start_Switch_Date_Token	Start Switchover Date Token	String	26	View
End_Switch_Date_Token	End Switchover Date Token	String	26	View
Start_GL_Intf_TRX_Date	Start G/L Interface TRX Date	Date	4	View
End_GL_Intf_TRX_Date	End G/L Interface TRX Date	Date	4	View
Start_GL_Intf_Date_Token	Start G/L Interface TRX Date Token	String	26	View
End_GL_Intf_Date_Token	End G/L Interface TRX Date Token	String	26	View
STBCHNUM	Start Batch Number	String	16	View
ENDBNMBR	End Batch Number	String	16	View
FISCALYEAR	Fiscal Year	Integer	2	View
PROJFROM	Project From Date	Date	4	View
PROJTO	Project To Date	Date	4	View
FA_Depreciation_As_Of	FA Depreciation As Of	Integer	2	View
FA_Depreciation_As_Of_Dt	FA Depreciation As Of Date	Date	4	View
FA_Calc_With_Reset_Amts	FA Calc With Reset Amts	Boolean	2	View
FA_Display_Reset_Amounts	FA Display Reset Amounts	Boolean	2	View

FA45000 - Fixed Assets Report Options

Query Builder

Customer Service

Information

My Account

Contact Us