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 TypeLength
1IFFILXST SearchIf File ExistingGBInteger0
2FILEXPNM SearchFile Export NameSTR255String255
3EXPTTYPE SearchExport TypeINTInteger0
4ASKECHTM SearchAsk Each TimeCB_Ask_Each_TimeBoolean0
5PRNTOFIL SearchPrint to FileCB_Print_to_FileBoolean0
6PRTOPRTR SearchPrint to PrinterCB_Print_to_PrinterBoolean0
7PRTOSCRN SearchPrint to ScreenCB_Print_to_ScreenBoolean0
8PRNTTYPE SearchPrint TypeGBInteger0
9RPTGRIND SearchReport Group IndexINTInteger0
10RTPACHIN SearchReport Palette Choice IndexINTInteger0
11RTGRSBIN SearchReport Group Sub IndexDLR14Currency14
12REPORTID SearchReport IDINT_STORAGEInteger0
13FINRPTNM SearchFinancial Report NameSTR30String30
14STRTNGDT SearchStarting DateDTDate8
15ENDINGDT SearchEnding DateDTDate8
16STTSEGID SearchStart Segment IDSTR10String10
17ENDSEGID SearchEnd Segment IDSTR10String10
18STGENINT1 SearchStart Generic Integer1INTInteger0
19ENDGENINT1 SearchEnd Generic Integer1INTInteger0
20STDOCNUM SearchStart Document NumberSTR20String20
21ENDOCNUM SearchEnd Document NumberSTR20String20
22STRMTKDT SearchStart RM Token DateDDL_RM_Token_DatesInteger0
23ENRMTKDT SearchEnd RM Token DateDDL_RM_Token_DatesInteger0
24SORTBY SearchSort ByDDL_Sort_ByInteger0
25CBINACTS SearchCB Inactive AccountsCB_Inactive_AccountsBoolean0
26PSTNGACT SearchPosting AccountINT1Integer1
27UNITACCT SearchUnit AccountINT1Integer1
28RPRTSHOW SearchReports ShowDDLInteger0
29PRRPTFOR SearchPrint Report ForGBInteger0
30PRVYRCMB SearchPrevious Year CMBCMBString4
31RPTDETAL SearchReport DetailReport DetailInteger0
32INDIVDUL SearchIndividualCBBoolean0
33INDIVDUL_1 SearchIndividual[1]CBBoolean0
34INDIVDUL_2 SearchIndividual[2]CBBoolean0
35INDIVDUL_3 SearchIndividual[3]CBBoolean0
36INDIVDUL_4 SearchIndividual[4]CBBoolean0
37INDIVDUL_5 SearchIndividual[5]CBBoolean0
38INDIVDUL_6 SearchIndividual[6]CBBoolean0
39INDIVDUL_7 SearchIndividual[7]CBBoolean0
40INDIVDUL_8 SearchIndividual[8]CBBoolean0
41INDIVDUL_9 SearchIndividual[9]CBBoolean0
42INDIVDUL_10 SearchIndividual[10]CBBoolean0
43INDIVDUL_11 SearchIndividual[11]CBBoolean0
44INDIVDUL_12 SearchIndividual[12]CBBoolean0
45INDIVDUL_13 SearchIndividual[13]CBBoolean0
46INDIVDUL_14 SearchIndividual[14]CBBoolean0
47INDIVDUL_15 SearchIndividual[15]CBBoolean0
48INDIVDUL_16 SearchIndividual[16]CBBoolean0
49INDIVDUL_17 SearchIndividual[17]CBBoolean0
50INDIVDUL_18 SearchIndividual[18]CBBoolean0
51INDIVDUL_19 SearchIndividual[19]CBBoolean0
52INDIVDUL_20 SearchIndividual[20]CBBoolean0
53INDIVDUL_21 SearchIndividual[21]CBBoolean0
54INDIVDUL_22 SearchIndividual[22]CBBoolean0
55INDIVDUL_23 SearchIndividual[23]CBBoolean0
56INDIVDUL_24 SearchIndividual[24]CBBoolean0
57INDIVDUL_25 SearchIndividual[25]CBBoolean0
58INDIVDUL_26 SearchIndividual[26]CBBoolean0
59INDIVDUL_27 SearchIndividual[27]CBBoolean0
60INDIVDUL_28 SearchIndividual[28]CBBoolean0
61INDIVDUL_29 SearchIndividual[29]CBBoolean0
62INDIVDUL_30 SearchIndividual[30]CBBoolean0
63INDIVDUL_31 SearchIndividual[31]CBBoolean0
64INDIVDUL_32 SearchIndividual[32]CBBoolean0
65INDIVDUL_33 SearchIndividual[33]CBBoolean0
66INDIVDUL_34 SearchIndividual[34]CBBoolean0
67INDIVDUL_35 SearchIndividual[35]CBBoolean0
68INDIVDUL_36 SearchIndividual[36]CBBoolean0
69INDIVDUL_37 SearchIndividual[37]CBBoolean0
70INDIVDUL_38 SearchIndividual[38]CBBoolean0
71INDIVDUL_39 SearchIndividual[39]CBBoolean0
72INDIVDUL_40 SearchIndividual[40]CBBoolean0
73INDIVDUL_41 SearchIndividual[41]CBBoolean0
74PRNTDSCR SearchPrint DescriptionGBInteger0
75PRZROBAL SearchPrint Zero BalancesYNBoolean0
76CLCRATIO SearchCalculate RatioGBInteger0
77INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean0
78GLSTTKDT SearchGL Start Token DateDDL_GL_Token_DatesInteger0
79GLENTKDT SearchGL End Token DateDDL_GL_Token_DatesInteger0
80PRUNTACT SearchPrint Unit AccountsCB_Print_Unit_AccountsBoolean0
81STACCNUM SearchStarting Account NumberAccount_NumberComposite 80
82STACCNUM_1 SearchStarting Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
83STACCNUM_2 SearchStarting Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
84STACCNUM_3 SearchStarting Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
85STACCNUM_4 SearchStarting Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
86STACCNUM_5 SearchStarting Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
87STACCNUM_6 SearchStarting Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
88STACCNUM_7 SearchStarting Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
89STACCNUM_8 SearchStarting Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
90STACCNUM_9 SearchStarting Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
91STACCNUM_10 SearchStarting Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
92EDGACNUM SearchEnding Account NumberAccount_NumberComposite 80
93EDGACNUM_1 SearchEnding Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
94EDGACNUM_2 SearchEnding Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
95EDGACNUM_3 SearchEnding Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
96EDGACNUM_4 SearchEnding Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
97EDGACNUM_5 SearchEnding Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
98EDGACNUM_6 SearchEnding Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
99EDGACNUM_7 SearchEnding Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
100EDGACNUM_8 SearchEnding Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
101EDGACNUM_9 SearchEnding Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
102EDGACNUM_10 SearchEnding Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
103SEGSRTBY SearchSegment Sort ByINT1Integer1
104RANGEBY SearchRange ByINTInteger0
105ACCLSTAT SearchAccelerator StatusINTInteger0
106USEACCEL SearchUse AcceleratorCB_Use_Accelerator_InformationBoolean0
107CBZBNA SearchZero Balance And No ActivityCB_Zero_AccountsBoolean0
108Accounts_Included SearchAccounts IncludedGBInteger0
109Start_Position_String SearchStart Position StringSTR89String89
110End_Position_String SearchEnd Position StringSTR89String89
111RPTXRATE SearchReporting Exchange RateDLR14_Exchange_RateCurrency (Variable)14
112RPRTCLMD SearchReporting Rate Calculation MethodDDL_Rate_Calculation_MethodInteger0
113PRTCURIN SearchPrint Currency InGBInteger0
114Checkbook_Date SearchCheckbook DateDTDate8
115End_Month SearchEnd MonthINT2_U0Integer2
116Start_Month SearchStart MonthINT2_U0Integer2
117YEAR1 SearchYearYearInteger4
118PP_Start_Profile SearchPP Start ProfileSTR20_Document_NumberString20
119PP_End_Profile SearchPP End ProfileSTR20_Document_NumberString20
120STVNDRID SearchStart Vendor IDSTR15_LBUString15
121STCUSTID SearchStart Customer IDSTR15_RM_Customer_NumberString15
122ENCUSTID SearchEnd Customer IDSTR15_RM_Customer_NumberString15
123ENDVNDID SearchEnd Vendor IDSTR15_LBUString15
124PP_Report_Sort SearchPP_Report_SortPP_Report_SortInteger0
125PP_Last_Date SearchPP_Last_DateDATEDate6
126PP_User_Access SearchPP_User_AccessPP_User_AccessBoolean0
127DEX_ROW_ID Searchintint10

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 *