Fixed Assets Report Options (FA45000)

azurecurveProductsFixed Assets (309)FinancialFixed Assets Report Options (FA45000)

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

Product: Fixed Assets (309)
Series:

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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1FILEXPNM SearchFile Export NameStringSTR255255
2EXPTTYPE SearchExport TypeIntegerINT0
3ASKECHTM SearchAsk Each TimeBooleanCB_Ask_Each_Time0
4IFFILXST SearchIf File ExistingIntegerGB0
5PRNTOFIL SearchPrint to FileBooleanCB_Print_to_File0
6PRTOPRTR SearchPrint to PrinterBooleanCB_Print_to_Printer0
7PRTOSCRN SearchPrint to ScreenBooleanCB_Print_to_Screen0
8PRNTTYPE SearchPrint TypeIntegerGB0
9RPTGRIND SearchReport Group IndexIntegerINT0
10RTPACHIN SearchReport Palette Choice IndexIntegerINT0
11RTGRSBIN SearchReport Group Sub IndexCurrencyDLR1414
12REPORTID SearchReport IDIntegerINT_STORAGE0
13FAREPTNAME SearchFixed Assets Report NameStringSTR5050
14SORTBY SearchSort ByIntegerDDL_Sort_By0
15Sort_By_Value SearchSort By ValueStringSTR4040
16BOOKINDX SearchBook IndexLong IntegerLI_1414
17BOOKID SearchBook IDStringSTR15_Book_ID15
18CURRFISCALYR SearchCurrent Fiscal YearIntegerYear4
19Begin_Current_Fiscal_Yr SearchBegin Current Fiscal YearDateDT8
20End_Current_Fiscal_Year SearchEnd Current Fiscal YearDateDT8
21Second_Book_Index SearchSecond Book IndexLong IntegerLI_1414
22Second_Book_ID SearchSecond Book IDStringSTR15_Book_ID15
23Current_Fiscal_Year_2 SearchSecond Current Fiscal YearIntegerYear4
24Second_Begin_Current_FY SearchSecond Begin Current Fiscal YearDateDT8
25Second_End_Current_FY SearchSecond End Current Fiscal YearDateDT8
26ACTIVE SearchActiveBooleanCB_Active0
27RETIRED SearchRetiredBooleanCB_Retired0
28PARTIALOPEN SearchPartial OpenBooleanCB_Partial_Open0
29Multicurrency_Information SearchMulticurrency Information CBBooleanCB_Include_Multicurrency_Info0
30In_Detail SearchIn DetailBooleanCB_In_Detail0
31Only_Not_Interfaced SearchOnly Not InterfacedBooleanCB_Only_Not_Interfaced0
32Start_Master_Asset_ID SearchStart Master Asset IDStringSTR19_Master_Asset_ID19
33End_Master_Asset_ID SearchEnd Master Asset IDStringSTR19_Master_Asset_ID19
34Start_Asset_ID SearchStart Asset IDStringSTR15_Asset_ID15
35End_Asset_ID SearchEnd Asset IDStringSTR15_Asset_ID15
36Start_Asset_ID_Suffix SearchStart Asset ID SuffixIntegerINT3_U03
37End_Asset_ID_Suffix SearchEnd Asset ID SuffixIntegerINT3_U03
38Start_Asset_Description SearchStart Asset DescriptionStringSTR40_Asset_Description40
39End_Asset_Description SearchEnd Asset DescriptionStringSTR40_Asset_Description40
40Start_Structure_ID SearchStart Structure IDStringSTR30_Structure_ID30
41End_Structure_ID SearchEnd Structure IDStringSTR30_Structure_ID30
42STTCLSID SearchStart Class IDStringSTR15_LBAU15
43ENDCLSID SearchEnd Class IDStringSTR15_LBAU15
44STTLOCID SearchStart Location IDStringSTR15_Location_ID15
45ENDLOCID SearchEnd Location IDStringSTR15_Location_ID15
46Start_YTD_Depreciation SearchStart YTD Depreciation AmountCurrencyDLR17_RBS0_STR$17
47End_YTD_Depreciation SearchEnd YTD Depreciation AmountCurrencyDLR17_RBS0_STR$17
48Start_LTD_Depreciation SearchStart LTD Depreciation AmountCurrencyDLR17_RBS0_STR$17
49End_LTD_Depreciation SearchEnd LTD Depreciation AmountCurrencyDLR17_RBS0_STR$17
50Start_Net_Book_Value SearchStart Net Book ValueCurrencyDLR17_RBS0_STR$17
51End_Net_Book_Value SearchEnd Net Book ValueCurrencyDLR17_RBS0_STR$17
52SSRCEDOC SearchStart Source DocumentStringSTR10_Source_Document10
53ENDSRCDC SearchEnd Source DocumentStringSTR10_Source_Document10
54Start_GL_Account_Index SearchStart G/L Account IndexLong IntegerLI_1414
55End_GL_Account_Index SearchEnd G/L Account IndexLong IntegerLI_1414
56Start_FA_Year SearchStart FA YearIntegerYear4
57End_FA_Year SearchEnd FA YearIntegerYear4
58Start_FA_Period SearchStart FA PeriodIntegerINT33
59End_FA_Period SearchEnd FA PeriodIntegerINT33
60Start_Property_Type SearchStart Property TypeIntegerDDL_Property_Type0
61End_Property_Type SearchEnd Property TypeIntegerDDL_Property_Type0
62Start_Asset_Type SearchStart Asset TypeIntegerDDL_Asset_Type0
63End_Asset_Type SearchEnd Asset TypeIntegerDDL_Asset_Type0
64Start_Asset_Quantity SearchStart Asset QuantityLong IntegerLI6_ST06
65End_Asset_Quantity SearchEnd Asset QuantityLong IntegerLI6_ST06
66Start_Original_Life_Year SearchStart Original Life YearsIntegerINT2_Life_Years2
67End_Original_Life_Years SearchEnd Original Life YearsIntegerINT2_Life_Years2
68Start_Original_Life_Days SearchStart Original Life DaysIntegerINT3_Life_Days3
69End_Original_Life_Days SearchEnd Original Life DaysIntegerINT3_Life_Days3
70Start_Remaining_Life_Yea SearchStart Remaining Life YearsIntegerINT2_Life_Years2
71End_Remaining_Life_Years SearchEnd Remaining Life YearsIntegerINT2_Life_Years2
72Start_Remaining_Life_Day SearchStart Remaining Life DaysIntegerINT3_Life_Days3
73End_Remaining_Life_Days SearchEnd Remaining Life DaysIntegerINT3_Life_Days3
74Start_Depr_Method SearchStart Depreciation MethodIntegerDDL_Depreciation_Method0
75End_Depreciation_Method SearchEnd Depreciation MethodIntegerDDL_Depreciation_Method0
76Start_Averaging_Conventi SearchStart Averaging ConventionIntegerDDL_Averaging_Convention0
77End_Averaging_Convention SearchEnd Averaging ConventionIntegerDDL_Averaging_Convention0
78Start_Amortization_Code SearchStart Amortization CodeIntegerDDL_Amortization_Code0
79End_Amortization_Code SearchEnd Amortization CodeIntegerDDL_Amortization_Code0
80Start_Retirement_Type SearchStart Retirement TypeIntegerDDL_Retirement_Type0
81End_Retirement_Type SearchEnd Retirement TypeIntegerDDL_Retirement_Type0
82Start_Trx_Acct_Type SearchStart Transaction Account TypeIntegerDDL_Transaction_Account_Type0
83End_Trx_Acct_Type SearchEnd Transaction Account TypeIntegerDDL_Transaction_Account_Type0
84Start_Cost_Basis SearchStart Cost BasisCurrencyDLR17_RBS0_STR$17
85End_Cost_Basis SearchEnd Cost BasisCurrencyDLR17_RBS0_STR$17
86Start_Fiscal_Year_Added SearchStart Fiscal Year AddedIntegerINT4_U04
87End_Fiscal_Year_Added SearchEnd Fiscal Year AddedIntegerINT4_U04
88Start_Place_in_Service SearchStart Place in Service DateDateDT8
89End_Place_in_Service SearchEnd Place in Service DateDateDT8
90Start_PIS_Token SearchStart Place in Service Date TokenStringSTR24024
91End_PIS_Token SearchEnd Place in Service Date TokenStringSTR24024
92Start_Acquisition_Date SearchStart Acquisition DateDateDT8
93End_Acquisition_Date SearchEnd Acquisition DateDateDT8
94Start_Acq_Token SearchStart Acquisition Date TokenStringSTR24024
95End_Acq_Token SearchEnd Acquisition Date TokenStringSTR24024
96Start_Date_Added SearchStart Date AddedDateDT8
97End_Date_Added SearchEnd Date AddedDateDT8
98Start_Date_Added_Token SearchStart Date Added TokenStringSTR24024
99End_Date_Added_Token SearchEnd Date Added TokenStringSTR24024
100Start_Fully_Depr_Date SearchStart Fully Depreciated DateDateDT8
101End_Fully_Depr_Date SearchEnd Fully Depreciated DateDateDT8
102Start_Fully_DTD_Token SearchStart Fully Depreciated Date TokenStringSTR24024
103End_Fully_DTD_Token SearchEnd Fully Depreciated Date TokenStringSTR24024
104Start_Retirement_Date SearchStart Retirement DateDateDT8
105End_Retirement_Date SearchEnd Retirement DateDateDT8
106Start_Ret_Date_Token SearchStart Retirement Date TokenStringSTR24024
107End_Ret_Date_Token SearchEnd Retirement Date TokenStringSTR24024
108Start_Transfer_Date SearchStart Transfer DateDateDT8
109End_Transfer_Date SearchEnd Transfer DateDateDT8
110Start_Transfer_Date_Toke SearchStart Transfer Date TokenStringSTR24024
111End_Transfer_Date_Token SearchEnd Transfer Date TokenStringSTR24024
112Start_Switchover_Date SearchStart Switchover DateDateDT8
113End_Switchover_Date SearchEnd Switchover DateDateDT8
114Start_Switch_Date_Token SearchStart Switchover Date TokenStringSTR24024
115End_Switch_Date_Token SearchEnd Switchover Date TokenStringSTR24024
116Start_GL_Intf_TRX_Date SearchStart G/L Interface TRX DateDateDT8
117End_GL_Intf_TRX_Date SearchEnd G/L Interface TRX DateDateDT8
118Start_GL_Intf_Date_Token SearchStart G/L Interface TRX Date TokenStringSTR24024
119End_GL_Intf_Date_Token SearchEnd G/L Interface TRX Date TokenStringSTR24024
120STBCHNUM SearchStart Batch NumberStringSTR15_LBAU15
121ENDBNMBR SearchEnd Batch NumberStringSTR15_LBAU15
122FISCALYEAR SearchFiscal YearIntegerINT4_U04
123PROJFROM SearchProject From DateDateDT8
124PROJTO SearchProject To DateDateDT8
125FA_Depreciation_As_Of SearchFA Depreciation As OfIntegerDDL_FA_Depreciation_As_Of0
126FA_Depreciation_As_Of_Dt SearchFA Depreciation As Of DateDateDT8
127FA_Calc_With_Reset_Amts SearchFA Calc With Reset AmtsBooleanCB_FA_Calculate_with_Reset_Amounts0
128FA_Display_Reset_Amounts SearchFA Display Reset AmountsBooleanCB_FA_Display_Reset_Amounts0
azurecurveProductsFixed Assets (309)FinancialFixed Assets Report Options (FA45000)

Leave a Reply

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