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: Financial

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 TypeSQL DB LengthKeyable Length
1FILEXPNM SearchFile Export NameSTR255String256255
2EXPTTYPE SearchExport TypeINTInteger20
3ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
4IFFILXST SearchIf File ExistingGBInteger20
5PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean20
6PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean20
7PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean20
8PRNTTYPE SearchPrint TypeGBInteger20
9RPTGRIND SearchReport Group IndexINTInteger20
10RTPACHIN SearchReport Palette Choice IndexINTInteger20
11RTGRSBIN SearchReport Group Sub IndexDLR14Currency1014
12REPORTID SearchReport IDINT_STORAGEInteger20
13FAREPTNAME SearchFixed Assets Report NameSTR50String5250
14SORTBY SearchSort ByDDL_Sort_ByInteger20
15Sort_By_Value SearchSort By ValueSTR40String4240
16BOOKINDX SearchBook IndexLI_14Long Integer414
17BOOKID SearchBook IDSTR15_Book_IDString1615
18CURRFISCALYR SearchCurrent Fiscal YearYearInteger24
19Begin_Current_Fiscal_Yr SearchBegin Current Fiscal YearDTDate48
20End_Current_Fiscal_Year SearchEnd Current Fiscal YearDTDate48
21Second_Book_Index SearchSecond Book IndexLI_14Long Integer414
22Second_Book_ID SearchSecond Book IDSTR15_Book_IDString1615
23Current_Fiscal_Year_2 SearchSecond Current Fiscal YearYearInteger24
24Second_Begin_Current_FY SearchSecond Begin Current Fiscal YearDTDate48
25Second_End_Current_FY SearchSecond End Current Fiscal YearDTDate48
26ACTIVE SearchActiveCB_ActiveBoolean20
27RETIRED SearchRetiredCB_RetiredBoolean20
28PARTIALOPEN SearchPartial OpenCB_Partial_OpenBoolean20
29Multicurrency_Information SearchMulticurrency Information CBCB_Include_Multicurrency_InfoBoolean20
30In_Detail SearchIn DetailCB_In_DetailBoolean20
31Only_Not_Interfaced SearchOnly Not InterfacedCB_Only_Not_InterfacedBoolean20
32Start_Master_Asset_ID SearchStart Master Asset IDSTR19_Master_Asset_IDString2019
33End_Master_Asset_ID SearchEnd Master Asset IDSTR19_Master_Asset_IDString2019
34Start_Asset_ID SearchStart Asset IDSTR15_Asset_IDString1615
35End_Asset_ID SearchEnd Asset IDSTR15_Asset_IDString1615
36Start_Asset_ID_Suffix SearchStart Asset ID SuffixINT3_U0Integer23
37End_Asset_ID_Suffix SearchEnd Asset ID SuffixINT3_U0Integer23
38Start_Asset_Description SearchStart Asset DescriptionSTR40_Asset_DescriptionString4240
39End_Asset_Description SearchEnd Asset DescriptionSTR40_Asset_DescriptionString4240
40Start_Structure_ID SearchStart Structure IDSTR30_Structure_IDString3230
41End_Structure_ID SearchEnd Structure IDSTR30_Structure_IDString3230
42STTCLSID SearchStart Class IDSTR15_LBAUString1615
43ENDCLSID SearchEnd Class IDSTR15_LBAUString1615
44STTLOCID SearchStart Location IDSTR15_Location_IDString1615
45ENDLOCID SearchEnd Location IDSTR15_Location_IDString1615
46Start_YTD_Depreciation SearchStart YTD Depreciation AmountDLR17_RBS0_STR$Currency1017
47End_YTD_Depreciation SearchEnd YTD Depreciation AmountDLR17_RBS0_STR$Currency1017
48Start_LTD_Depreciation SearchStart LTD Depreciation AmountDLR17_RBS0_STR$Currency1017
49End_LTD_Depreciation SearchEnd LTD Depreciation AmountDLR17_RBS0_STR$Currency1017
50Start_Net_Book_Value SearchStart Net Book ValueDLR17_RBS0_STR$Currency1017
51End_Net_Book_Value SearchEnd Net Book ValueDLR17_RBS0_STR$Currency1017
52SSRCEDOC SearchStart Source DocumentSTR10_Source_DocumentString1210
53ENDSRCDC SearchEnd Source DocumentSTR10_Source_DocumentString1210
54Start_GL_Account_Index SearchStart G/L Account IndexLI_14Long Integer414
55End_GL_Account_Index SearchEnd G/L Account IndexLI_14Long Integer414
56Start_FA_Year SearchStart FA YearYearInteger24
57End_FA_Year SearchEnd FA YearYearInteger24
58Start_FA_Period SearchStart FA PeriodINT3Integer23
59End_FA_Period SearchEnd FA PeriodINT3Integer23
60Start_Property_Type SearchStart Property TypeDDL_Property_TypeInteger20
61End_Property_Type SearchEnd Property TypeDDL_Property_TypeInteger20
62Start_Asset_Type SearchStart Asset TypeDDL_Asset_TypeInteger20
63End_Asset_Type SearchEnd Asset TypeDDL_Asset_TypeInteger20
64Start_Asset_Quantity SearchStart Asset QuantityLI6_ST0Long Integer46
65End_Asset_Quantity SearchEnd Asset QuantityLI6_ST0Long Integer46
66Start_Original_Life_Year SearchStart Original Life YearsINT2_Life_YearsInteger22
67End_Original_Life_Years SearchEnd Original Life YearsINT2_Life_YearsInteger22
68Start_Original_Life_Days SearchStart Original Life DaysINT3_Life_DaysInteger23
69End_Original_Life_Days SearchEnd Original Life DaysINT3_Life_DaysInteger23
70Start_Remaining_Life_Yea SearchStart Remaining Life YearsINT2_Life_YearsInteger22
71End_Remaining_Life_Years SearchEnd Remaining Life YearsINT2_Life_YearsInteger22
72Start_Remaining_Life_Day SearchStart Remaining Life DaysINT3_Life_DaysInteger23
73End_Remaining_Life_Days SearchEnd Remaining Life DaysINT3_Life_DaysInteger23
74Start_Depr_Method SearchStart Depreciation MethodDDL_Depreciation_MethodInteger20
75End_Depreciation_Method SearchEnd Depreciation MethodDDL_Depreciation_MethodInteger20
76Start_Averaging_Conventi SearchStart Averaging ConventionDDL_Averaging_ConventionInteger20
77End_Averaging_Convention SearchEnd Averaging ConventionDDL_Averaging_ConventionInteger20
78Start_Amortization_Code SearchStart Amortization CodeDDL_Amortization_CodeInteger20
79End_Amortization_Code SearchEnd Amortization CodeDDL_Amortization_CodeInteger20
80Start_Retirement_Type SearchStart Retirement TypeDDL_Retirement_TypeInteger20
81End_Retirement_Type SearchEnd Retirement TypeDDL_Retirement_TypeInteger20
82Start_Trx_Acct_Type SearchStart Transaction Account TypeDDL_Transaction_Account_TypeInteger20
83End_Trx_Acct_Type SearchEnd Transaction Account TypeDDL_Transaction_Account_TypeInteger20
84Start_Cost_Basis SearchStart Cost BasisDLR17_RBS0_STR$Currency1017
85End_Cost_Basis SearchEnd Cost BasisDLR17_RBS0_STR$Currency1017
86Start_Fiscal_Year_Added SearchStart Fiscal Year AddedINT4_U0Integer24
87End_Fiscal_Year_Added SearchEnd Fiscal Year AddedINT4_U0Integer24
88Start_Place_in_Service SearchStart Place in Service DateDTDate48
89End_Place_in_Service SearchEnd Place in Service DateDTDate48
90Start_PIS_Token SearchStart Place in Service Date TokenSTR240String2624
91End_PIS_Token SearchEnd Place in Service Date TokenSTR240String2624
92Start_Acquisition_Date SearchStart Acquisition DateDTDate48
93End_Acquisition_Date SearchEnd Acquisition DateDTDate48
94Start_Acq_Token SearchStart Acquisition Date TokenSTR240String2624
95End_Acq_Token SearchEnd Acquisition Date TokenSTR240String2624
96Start_Date_Added SearchStart Date AddedDTDate48
97End_Date_Added SearchEnd Date AddedDTDate48
98Start_Date_Added_Token SearchStart Date Added TokenSTR240String2624
99End_Date_Added_Token SearchEnd Date Added TokenSTR240String2624
100Start_Fully_Depr_Date SearchStart Fully Depreciated DateDTDate48
101End_Fully_Depr_Date SearchEnd Fully Depreciated DateDTDate48
102Start_Fully_DTD_Token SearchStart Fully Depreciated Date TokenSTR240String2624
103End_Fully_DTD_Token SearchEnd Fully Depreciated Date TokenSTR240String2624
104Start_Retirement_Date SearchStart Retirement DateDTDate48
105End_Retirement_Date SearchEnd Retirement DateDTDate48
106Start_Ret_Date_Token SearchStart Retirement Date TokenSTR240String2624
107End_Ret_Date_Token SearchEnd Retirement Date TokenSTR240String2624
108Start_Transfer_Date SearchStart Transfer DateDTDate48
109End_Transfer_Date SearchEnd Transfer DateDTDate48
110Start_Transfer_Date_Toke SearchStart Transfer Date TokenSTR240String2624
111End_Transfer_Date_Token SearchEnd Transfer Date TokenSTR240String2624
112Start_Switchover_Date SearchStart Switchover DateDTDate48
113End_Switchover_Date SearchEnd Switchover DateDTDate48
114Start_Switch_Date_Token SearchStart Switchover Date TokenSTR240String2624
115End_Switch_Date_Token SearchEnd Switchover Date TokenSTR240String2624
116Start_GL_Intf_TRX_Date SearchStart G/L Interface TRX DateDTDate48
117End_GL_Intf_TRX_Date SearchEnd G/L Interface TRX DateDTDate48
118Start_GL_Intf_Date_Token SearchStart G/L Interface TRX Date TokenSTR240String2624
119End_GL_Intf_Date_Token SearchEnd G/L Interface TRX Date TokenSTR240String2624
120STBCHNUM SearchStart Batch NumberSTR15_LBAUString1615
121ENDBNMBR SearchEnd Batch NumberSTR15_LBAUString1615
122FISCALYEAR SearchFiscal YearINT4_U0Integer24
123PROJFROM SearchProject From DateDTDate48
124PROJTO SearchProject To DateDTDate48
125FA_Depreciation_As_Of SearchFA Depreciation As OfDDL_FA_Depreciation_As_OfInteger20
126FA_Depreciation_As_Of_Dt SearchFA Depreciation As Of DateDTDate48
127FA_Calc_With_Reset_Amts SearchFA Calc With Reset AmtsCB_FA_Calculate_with_Reset_AmountsBoolean20
128FA_Display_Reset_Amounts SearchFA Display Reset AmountsCB_FA_Display_Reset_AmountsBoolean20
129DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

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

Leave a Reply

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