Deferral Report Options (PP000060)

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

Product: Revenue Expense Deferrals (1045)
Series: Financial

Display Name: Deferral Report Options
Physical Name: PP000060
Technical Name: PP_Options_ROPT

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1IFFILXST SearchIf File ExistingGBInteger20
2FILEXPNM SearchFile Export NameSTR255String256255
3EXPTTYPE SearchExport TypeINTInteger20
4ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean20
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
13FINRPTNM SearchFinancial Report NameSTR30String3230
14STRTNGDT SearchStarting DateDTDate48
15ENDINGDT SearchEnding DateDTDate48
16STTSEGID SearchStart Segment IDSTR10String1210
17ENDSEGID SearchEnd Segment IDSTR10String1210
18STGENINT1 SearchStart Generic Integer1INTInteger20
19ENDGENINT1 SearchEnd Generic Integer1INTInteger20
20STDOCNUM SearchStart Document NumberSTR20String2220
21ENDOCNUM SearchEnd Document NumberSTR20String2220
22STRMTKDT SearchStart RM Token DateDDL_RM_Token_DatesInteger20
23ENRMTKDT SearchEnd RM Token DateDDL_RM_Token_DatesInteger20
24SORTBY SearchSort ByDDL_Sort_ByInteger20
25CBINACTS SearchCB Inactive AccountsCB_Inactive_AccountsBoolean20
26PSTNGACT SearchPosting AccountINT1Integer21
27UNITACCT SearchUnit AccountINT1Integer21
28RPRTSHOW SearchReports ShowDDLInteger20
29PRRPTFOR SearchPrint Report ForGBInteger20
30PRVYRCMB SearchPrevious Year CMBCMBString64
31RPTDETAL SearchReport DetailReport DetailInteger20
32INDIVDUL SearchIndividualCBBoolean20
33INDIVDUL_1 SearchIndividual[1]CBBoolean20
34INDIVDUL_2 SearchIndividual[2]CBBoolean20
35INDIVDUL_3 SearchIndividual[3]CBBoolean20
36INDIVDUL_4 SearchIndividual[4]CBBoolean20
37INDIVDUL_5 SearchIndividual[5]CBBoolean20
38INDIVDUL_6 SearchIndividual[6]CBBoolean20
39INDIVDUL_7 SearchIndividual[7]CBBoolean20
40INDIVDUL_8 SearchIndividual[8]CBBoolean20
41INDIVDUL_9 SearchIndividual[9]CBBoolean20
42INDIVDUL_10 SearchIndividual[10]CBBoolean20
43INDIVDUL_11 SearchIndividual[11]CBBoolean20
44INDIVDUL_12 SearchIndividual[12]CBBoolean20
45INDIVDUL_13 SearchIndividual[13]CBBoolean20
46INDIVDUL_14 SearchIndividual[14]CBBoolean20
47INDIVDUL_15 SearchIndividual[15]CBBoolean20
48INDIVDUL_16 SearchIndividual[16]CBBoolean20
49INDIVDUL_17 SearchIndividual[17]CBBoolean20
50INDIVDUL_18 SearchIndividual[18]CBBoolean20
51INDIVDUL_19 SearchIndividual[19]CBBoolean20
52INDIVDUL_20 SearchIndividual[20]CBBoolean20
53INDIVDUL_21 SearchIndividual[21]CBBoolean20
54INDIVDUL_22 SearchIndividual[22]CBBoolean20
55INDIVDUL_23 SearchIndividual[23]CBBoolean20
56INDIVDUL_24 SearchIndividual[24]CBBoolean20
57INDIVDUL_25 SearchIndividual[25]CBBoolean20
58INDIVDUL_26 SearchIndividual[26]CBBoolean20
59INDIVDUL_27 SearchIndividual[27]CBBoolean20
60INDIVDUL_28 SearchIndividual[28]CBBoolean20
61INDIVDUL_29 SearchIndividual[29]CBBoolean20
62INDIVDUL_30 SearchIndividual[30]CBBoolean20
63INDIVDUL_31 SearchIndividual[31]CBBoolean20
64INDIVDUL_32 SearchIndividual[32]CBBoolean20
65INDIVDUL_33 SearchIndividual[33]CBBoolean20
66INDIVDUL_34 SearchIndividual[34]CBBoolean20
67INDIVDUL_35 SearchIndividual[35]CBBoolean20
68INDIVDUL_36 SearchIndividual[36]CBBoolean20
69INDIVDUL_37 SearchIndividual[37]CBBoolean20
70INDIVDUL_38 SearchIndividual[38]CBBoolean20
71INDIVDUL_39 SearchIndividual[39]CBBoolean20
72INDIVDUL_40 SearchIndividual[40]CBBoolean20
73INDIVDUL_41 SearchIndividual[41]CBBoolean20
74PRNTDSCR SearchPrint DescriptionGBInteger20
75PRZROBAL SearchPrint Zero BalancesYNBoolean20
76CLCRATIO SearchCalculate RatioGBInteger20
77INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean20
78GLSTTKDT SearchGL Start Token DateDDL_GL_Token_DatesInteger20
79GLENTKDT SearchGL End Token DateDDL_GL_Token_DatesInteger20
80PRUNTACT SearchPrint Unit AccountsCB_Print_Unit_AccountsBoolean20
81STACCNUM SearchStarting Account NumberAccount_NumberComposite 8080
82STACCNUM_1 SearchStarting Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
83STACCNUM_2 SearchStarting Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
84STACCNUM_3 SearchStarting Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
85STACCNUM_4 SearchStarting Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
86STACCNUM_5 SearchStarting Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
87STACCNUM_6 SearchStarting Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
88STACCNUM_7 SearchStarting Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
89STACCNUM_8 SearchStarting Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
90STACCNUM_9 SearchStarting Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
91STACCNUM_10 SearchStarting Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
92EDGACNUM SearchEnding Account NumberAccount_NumberComposite 8080
93EDGACNUM_1 SearchEnding Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
94EDGACNUM_2 SearchEnding Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
95EDGACNUM_3 SearchEnding Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
96EDGACNUM_4 SearchEnding Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
97EDGACNUM_5 SearchEnding Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
98EDGACNUM_6 SearchEnding Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
99EDGACNUM_7 SearchEnding Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
100EDGACNUM_8 SearchEnding Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
101EDGACNUM_9 SearchEnding Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
102EDGACNUM_10 SearchEnding Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
103SEGSRTBY SearchSegment Sort ByINT1Integer21
104RANGEBY SearchRange ByINTInteger20
105ACCLSTAT SearchAccelerator StatusINTInteger20
106USEACCEL SearchUse AcceleratorCB_Use_Accelerator_InformationBoolean20
107CBZBNA SearchZero Balance And No ActivityCB_Zero_AccountsBoolean20
108Accounts_Included SearchAccounts IncludedGBInteger20
109Start_Position_String SearchStart Position StringSTR89String9089
110End_Position_String SearchEnd Position StringSTR89String9089
111RPTXRATE SearchReporting Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
112RPRTCLMD SearchReporting Rate Calculation MethodDDL_Rate_Calculation_MethodInteger20
113PRTCURIN SearchPrint Currency InGBInteger20
114Checkbook_Date SearchCheckbook DateDTDate48
115End_Month SearchEnd MonthINT2_U0Integer22
116Start_Month SearchStart MonthINT2_U0Integer22
117YEAR1 SearchYearYearInteger24
118PP_Start_Profile SearchPP Start ProfileSTR20_Document_NumberString2220
119PP_End_Profile SearchPP End ProfileSTR20_Document_NumberString2220
120STVNDRID SearchStart Vendor IDSTR15_LBUString1615
121STCUSTID SearchStart Customer IDSTR15_RM_Customer_NumberString1615
122ENCUSTID SearchEnd Customer IDSTR15_RM_Customer_NumberString1615
123ENDVNDID SearchEnd Vendor IDSTR15_LBUString1615
124PP_Report_Sort SearchPP_Report_SortPP_Report_SortInteger20
125PP_Last_Date SearchPP_Last_DateDATEDate46
126PP_User_Access SearchPP_User_AccessPP_User_AccessBoolean20
127DEX_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.

Leave a Reply

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