Fixed Assets Report Options (FA45000)

azurecurve Products Fixed Assets (309)FinancialFixed Assets Report Options (FA45000)

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

Display Name: Fixed Assets Report Options
Physical Name: FA45000
Technical Name: FA_Options_ROPT

Group Display Name: Fixed Assets Report Options
Group Technical Name: Fixed Assets Report Options

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	FILEXPNM	File Export Name	String	STR255	255
2	EXPTTYPE	Export Type	Integer	INT	0
3	ASKECHTM	Ask Each Time	Boolean	CB_Ask_Each_Time	0
4	IFFILXST	If File Existing	Integer	GB	0
5	PRNTOFIL	Print to File	Boolean	CB_Print_to_File	0
6	PRTOPRTR	Print to Printer	Boolean	CB_Print_to_Printer	0
7	PRTOSCRN	Print to Screen	Boolean	CB_Print_to_Screen	0
8	PRNTTYPE	Print Type	Integer	GB	0
9	RPTGRIND	Report Group Index	Integer	INT	0
10	RTPACHIN	Report Palette Choice Index	Integer	INT	0
11	RTGRSBIN	Report Group Sub Index	Currency	DLR14	14
12	REPORTID	Report ID	Integer	INT_STORAGE	0
13	FAREPTNAME	Fixed Assets Report Name	String	STR50	50
14	SORTBY	Sort By	Integer	DDL_Sort_By	0
15	Sort_By_Value	Sort By Value	String	STR40	40
16	BOOKINDX	Book Index	Long Integer	LI_14	14
17	BOOKID	Book ID	String	STR15_Book_ID	15
18	CURRFISCALYR	Current Fiscal Year	Integer	Year	4
19	Begin_Current_Fiscal_Yr	Begin Current Fiscal Year	Date	DT	8
20	End_Current_Fiscal_Year	End Current Fiscal Year	Date	DT	8
21	Second_Book_Index	Second Book Index	Long Integer	LI_14	14
22	Second_Book_ID	Second Book ID	String	STR15_Book_ID	15
23	Current_Fiscal_Year_2	Second Current Fiscal Year	Integer	Year	4
24	Second_Begin_Current_FY	Second Begin Current Fiscal Year	Date	DT	8
25	Second_End_Current_FY	Second End Current Fiscal Year	Date	DT	8
26	ACTIVE	Active	Boolean	CB_Active	0
27	RETIRED	Retired	Boolean	CB_Retired	0
28	PARTIALOPEN	Partial Open	Boolean	CB_Partial_Open	0
29	Multicurrency_Information	Multicurrency Information CB	Boolean	CB_Include_Multicurrency_Info	0
30	In_Detail	In Detail	Boolean	CB_In_Detail	0
31	Only_Not_Interfaced	Only Not Interfaced	Boolean	CB_Only_Not_Interfaced	0
32	Start_Master_Asset_ID	Start Master Asset ID	String	STR19_Master_Asset_ID	19
33	End_Master_Asset_ID	End Master Asset ID	String	STR19_Master_Asset_ID	19
34	Start_Asset_ID	Start Asset ID	String	STR15_Asset_ID	15
35	End_Asset_ID	End Asset ID	String	STR15_Asset_ID	15
36	Start_Asset_ID_Suffix	Start Asset ID Suffix	Integer	INT3_U0	3
37	End_Asset_ID_Suffix	End Asset ID Suffix	Integer	INT3_U0	3
38	Start_Asset_Description	Start Asset Description	String	STR40_Asset_Description	40
39	End_Asset_Description	End Asset Description	String	STR40_Asset_Description	40
40	Start_Structure_ID	Start Structure ID	String	STR30_Structure_ID	30
41	End_Structure_ID	End Structure ID	String	STR30_Structure_ID	30
42	STTCLSID	Start Class ID	String	STR15_LBAU	15
43	ENDCLSID	End Class ID	String	STR15_LBAU	15
44	STTLOCID	Start Location ID	String	STR15_Location_ID	15
45	ENDLOCID	End Location ID	String	STR15_Location_ID	15
46	Start_YTD_Depreciation	Start YTD Depreciation Amount	Currency	DLR17_RBS0_STR$	17
47	End_YTD_Depreciation	End YTD Depreciation Amount	Currency	DLR17_RBS0_STR$	17
48	Start_LTD_Depreciation	Start LTD Depreciation Amount	Currency	DLR17_RBS0_STR$	17
49	End_LTD_Depreciation	End LTD Depreciation Amount	Currency	DLR17_RBS0_STR$	17
50	Start_Net_Book_Value	Start Net Book Value	Currency	DLR17_RBS0_STR$	17
51	End_Net_Book_Value	End Net Book Value	Currency	DLR17_RBS0_STR$	17
52	SSRCEDOC	Start Source Document	String	STR10_Source_Document	10
53	ENDSRCDC	End Source Document	String	STR10_Source_Document	10
54	Start_GL_Account_Index	Start G/L Account Index	Long Integer	LI_14	14
55	End_GL_Account_Index	End G/L Account Index	Long Integer	LI_14	14
56	Start_FA_Year	Start FA Year	Integer	Year	4
57	End_FA_Year	End FA Year	Integer	Year	4
58	Start_FA_Period	Start FA Period	Integer	INT3	3
59	End_FA_Period	End FA Period	Integer	INT3	3
60	Start_Property_Type	Start Property Type	Integer	DDL_Property_Type	0
61	End_Property_Type	End Property Type	Integer	DDL_Property_Type	0
62	Start_Asset_Type	Start Asset Type	Integer	DDL_Asset_Type	0
63	End_Asset_Type	End Asset Type	Integer	DDL_Asset_Type	0
64	Start_Asset_Quantity	Start Asset Quantity	Long Integer	LI6_ST0	6
65	End_Asset_Quantity	End Asset Quantity	Long Integer	LI6_ST0	6
66	Start_Original_Life_Year	Start Original Life Years	Integer	INT2_Life_Years	2
67	End_Original_Life_Years	End Original Life Years	Integer	INT2_Life_Years	2
68	Start_Original_Life_Days	Start Original Life Days	Integer	INT3_Life_Days	3
69	End_Original_Life_Days	End Original Life Days	Integer	INT3_Life_Days	3
70	Start_Remaining_Life_Yea	Start Remaining Life Years	Integer	INT2_Life_Years	2
71	End_Remaining_Life_Years	End Remaining Life Years	Integer	INT2_Life_Years	2
72	Start_Remaining_Life_Day	Start Remaining Life Days	Integer	INT3_Life_Days	3
73	End_Remaining_Life_Days	End Remaining Life Days	Integer	INT3_Life_Days	3
74	Start_Depr_Method	Start Depreciation Method	Integer	DDL_Depreciation_Method	0
75	End_Depreciation_Method	End Depreciation Method	Integer	DDL_Depreciation_Method	0
76	Start_Averaging_Conventi	Start Averaging Convention	Integer	DDL_Averaging_Convention	0
77	End_Averaging_Convention	End Averaging Convention	Integer	DDL_Averaging_Convention	0
78	Start_Amortization_Code	Start Amortization Code	Integer	DDL_Amortization_Code	0
79	End_Amortization_Code	End Amortization Code	Integer	DDL_Amortization_Code	0
80	Start_Retirement_Type	Start Retirement Type	Integer	DDL_Retirement_Type	0
81	End_Retirement_Type	End Retirement Type	Integer	DDL_Retirement_Type	0
82	Start_Trx_Acct_Type	Start Transaction Account Type	Integer	DDL_Transaction_Account_Type	0
83	End_Trx_Acct_Type	End Transaction Account Type	Integer	DDL_Transaction_Account_Type	0
84	Start_Cost_Basis	Start Cost Basis	Currency	DLR17_RBS0_STR$	17
85	End_Cost_Basis	End Cost Basis	Currency	DLR17_RBS0_STR$	17
86	Start_Fiscal_Year_Added	Start Fiscal Year Added	Integer	INT4_U0	4
87	End_Fiscal_Year_Added	End Fiscal Year Added	Integer	INT4_U0	4
88	Start_Place_in_Service	Start Place in Service Date	Date	DT	8
89	End_Place_in_Service	End Place in Service Date	Date	DT	8
90	Start_PIS_Token	Start Place in Service Date Token	String	STR240	24
91	End_PIS_Token	End Place in Service Date Token	String	STR240	24
92	Start_Acquisition_Date	Start Acquisition Date	Date	DT	8
93	End_Acquisition_Date	End Acquisition Date	Date	DT	8
94	Start_Acq_Token	Start Acquisition Date Token	String	STR240	24
95	End_Acq_Token	End Acquisition Date Token	String	STR240	24
96	Start_Date_Added	Start Date Added	Date	DT	8
97	End_Date_Added	End Date Added	Date	DT	8
98	Start_Date_Added_Token	Start Date Added Token	String	STR240	24
99	End_Date_Added_Token	End Date Added Token	String	STR240	24
100	Start_Fully_Depr_Date	Start Fully Depreciated Date	Date	DT	8
101	End_Fully_Depr_Date	End Fully Depreciated Date	Date	DT	8
102	Start_Fully_DTD_Token	Start Fully Depreciated Date Token	String	STR240	24
103	End_Fully_DTD_Token	End Fully Depreciated Date Token	String	STR240	24
104	Start_Retirement_Date	Start Retirement Date	Date	DT	8
105	End_Retirement_Date	End Retirement Date	Date	DT	8
106	Start_Ret_Date_Token	Start Retirement Date Token	String	STR240	24
107	End_Ret_Date_Token	End Retirement Date Token	String	STR240	24
108	Start_Transfer_Date	Start Transfer Date	Date	DT	8
109	End_Transfer_Date	End Transfer Date	Date	DT	8
110	Start_Transfer_Date_Toke	Start Transfer Date Token	String	STR240	24
111	End_Transfer_Date_Token	End Transfer Date Token	String	STR240	24
112	Start_Switchover_Date	Start Switchover Date	Date	DT	8
113	End_Switchover_Date	End Switchover Date	Date	DT	8
114	Start_Switch_Date_Token	Start Switchover Date Token	String	STR240	24
115	End_Switch_Date_Token	End Switchover Date Token	String	STR240	24
116	Start_GL_Intf_TRX_Date	Start G/L Interface TRX Date	Date	DT	8
117	End_GL_Intf_TRX_Date	End G/L Interface TRX Date	Date	DT	8
118	Start_GL_Intf_Date_Token	Start G/L Interface TRX Date Token	String	STR240	24
119	End_GL_Intf_Date_Token	End G/L Interface TRX Date Token	String	STR240	24
120	STBCHNUM	Start Batch Number	String	STR15_LBAU	15
121	ENDBNMBR	End Batch Number	String	STR15_LBAU	15
122	FISCALYEAR	Fiscal Year	Integer	INT4_U0	4
123	PROJFROM	Project From Date	Date	DT	8
124	PROJTO	Project To Date	Date	DT	8
125	FA_Depreciation_As_Of	FA Depreciation As Of	Integer	DDL_FA_Depreciation_As_Of	0
126	FA_Depreciation_As_Of_Dt	FA Depreciation As Of Date	Date	DT	8
127	FA_Calc_With_Reset_Amts	FA Calc With Reset Amts	Boolean	CB_FA_Calculate_with_Reset_Amounts	0
128	FA_Display_Reset_Amounts	FA Display Reset Amounts	Boolean	CB_FA_Display_Reset_Amounts	0

azurecurve Products Fixed Assets (309)FinancialFixed Assets Report Options (FA45000)

Leave a Reply Cancel reply