General Ledger Report Options (GL70500)

azurecurveProductsMicrosoft Dynamics GP (0)FinancialGeneral Ledger Report Options (GL70500)

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

Product: Microsoft Dynamics GP (0)
Series: Financial

Display Name: General Ledger Report Options
Physical Name: GL70500
Technical Name: GL_Options_ROPT

Group Display Name: General Ledger Report Options
Group Technical Name: General Ledger Report Options

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
14STGENINT1 SearchStart Generic Integer1INTInteger0
15ENDGENINT1 SearchEnd Generic Integer1INTInteger0
16STGENINT2 SearchStart Generic Integer2INTInteger0
17ENDGENINT2 SearchEnd Generic Integer2INTInteger0
18STRTNGDT SearchStarting DateDTDate8
19ENDINGDT SearchEnding DateDTDate8
20STTCATEG SearchStart CategoryINT2_U0Integer2
21STTUDEF1 SearchStart User Defined 1STR20String20
22ENUSRDF1 SearchEnd User Defined 1STR20String20
23ENDCATEG SearchEnd CategoryINT2_U0Integer2
24STTCATNM SearchStart Category NameSTR40_CategoryString40
25ENDCATNM SearchEnd Category NameSTR40_CategoryString40
26STRTJRNL SearchStart JournalLI8_U0Long Integer8
27ENDJRNAL SearchEnd JournalLI8_U0Long Integer8
28STRXSRC SearchStart TRX SourceSTR13String13
29ENTRXSRC SearchEnd TRX SourceSTR13String13
30STRTCMTRXNUM SearchStart CM Trx NumberSTR20_Document_NumberString20
31ENDCMTRXNUM SearchEnd CM Trx NumberSTR20_Document_NumberString20
32SSRCEDOC SearchStart Source DocumentSTR10_Source_DocumentString10
33ENDSRCDC SearchEnd Source DocumentSTR10_Source_DocumentString10
34STTACDSC SearchStart Account DescriptionSTR50String50
35ENDACDSC SearchEnd Account DescriptionSTR50String50
36STBDBSID SearchStart Budget Business IDSTR15String15
37ENBDBSID SearchEnd Budget Business IDSTR15String15
38STBDBSDS SearchStart Budget Business DescriptionSTR30String30
39ENBDBSDS SearchEnd Budget Business DescriptionSTR30String30
40STCHBKID SearchStart Checkbook IDSTR15_LBUString15
41ENCHBKID SearchEnd Checkbook IDSTR15_LBUString15
42STRTDSCR SearchStart DescriptionSTR50String50
43ENDDESCR SearchEnd DescriptionSTR50String50
44STTSEGID SearchStart Segment IDSTR10String10
45ENDSEGID SearchEnd Segment IDSTR10String10
46STCTRNUM SearchStart Control NumberSTR20String20
47ENCNTNUM SearchEnd Control NumberSTR20String20
48STDOCNUM SearchStart Document NumberSTR20String20
49ENDOCNUM SearchEnd Document NumberSTR20String20
50STMASTID SearchStart Master IDSTR20String20
51ENMASTID SearchEnd Master IDSTR20String20
52STMASTNM SearchStart Master NameSTR30String30
53ENMASTNM SearchEnd Master NameSTR30String30
54SORTBY SearchSort ByDDL_Sort_ByInteger0
55CBINACTS SearchCB Inactive AccountsCB_Inactive_AccountsBoolean0
56PSTNGACT SearchPosting AccountINT1Integer1
57UNITACCT SearchUnit AccountINT1Integer1
58RPRTSHOW SearchReports ShowDDLInteger0
59PRRPTFOR SearchPrint Report ForGBInteger0
60PRVYRCMB SearchPrevious Year CMBCMBString4
61RPTDETAL SearchReport DetailReport DetailInteger0
62INDIVDUL SearchIndividualCBBoolean0
63INDIVDUL_1 SearchIndividual[1]CBBoolean0
64INDIVDUL_2 SearchIndividual[2]CBBoolean0
65INDIVDUL_3 SearchIndividual[3]CBBoolean0
66INDIVDUL_4 SearchIndividual[4]CBBoolean0
67INDIVDUL_5 SearchIndividual[5]CBBoolean0
68INDIVDUL_6 SearchIndividual[6]CBBoolean0
69INDIVDUL_7 SearchIndividual[7]CBBoolean0
70INDIVDUL_8 SearchIndividual[8]CBBoolean0
71INDIVDUL_9 SearchIndividual[9]CBBoolean0
72INDIVDUL_10 SearchIndividual[10]CBBoolean0
73INDIVDUL_11 SearchIndividual[11]CBBoolean0
74INDIVDUL_12 SearchIndividual[12]CBBoolean0
75INDIVDUL_13 SearchIndividual[13]CBBoolean0
76INDIVDUL_14 SearchIndividual[14]CBBoolean0
77INDIVDUL_15 SearchIndividual[15]CBBoolean0
78INDIVDUL_16 SearchIndividual[16]CBBoolean0
79INDIVDUL_17 SearchIndividual[17]CBBoolean0
80INDIVDUL_18 SearchIndividual[18]CBBoolean0
81INDIVDUL_19 SearchIndividual[19]CBBoolean0
82INDIVDUL_20 SearchIndividual[20]CBBoolean0
83INDIVDUL_21 SearchIndividual[21]CBBoolean0
84INDIVDUL_22 SearchIndividual[22]CBBoolean0
85INDIVDUL_23 SearchIndividual[23]CBBoolean0
86INDIVDUL_24 SearchIndividual[24]CBBoolean0
87INDIVDUL_25 SearchIndividual[25]CBBoolean0
88INDIVDUL_26 SearchIndividual[26]CBBoolean0
89INDIVDUL_27 SearchIndividual[27]CBBoolean0
90INDIVDUL_28 SearchIndividual[28]CBBoolean0
91INDIVDUL_29 SearchIndividual[29]CBBoolean0
92INDIVDUL_30 SearchIndividual[30]CBBoolean0
93INDIVDUL_31 SearchIndividual[31]CBBoolean0
94INDIVDUL_32 SearchIndividual[32]CBBoolean0
95INDIVDUL_33 SearchIndividual[33]CBBoolean0
96INDIVDUL_34 SearchIndividual[34]CBBoolean0
97INDIVDUL_35 SearchIndividual[35]CBBoolean0
98INDIVDUL_36 SearchIndividual[36]CBBoolean0
99INDIVDUL_37 SearchIndividual[37]CBBoolean0
100INDIVDUL_38 SearchIndividual[38]CBBoolean0
101INDIVDUL_39 SearchIndividual[39]CBBoolean0
102INDIVDUL_40 SearchIndividual[40]CBBoolean0
103INDIVDUL_41 SearchIndividual[41]CBBoolean0
104PRNTDSCR SearchPrint DescriptionGBInteger0
105PRZROBAL SearchPrint Zero BalancesYNBoolean0
106CLCRATIO SearchCalculate RatioGBInteger0
107INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean0
108GLSTTKDT SearchGL Start Token DateDDL_GL_Token_DatesInteger0
109GLENTKDT SearchGL End Token DateDDL_GL_Token_DatesInteger0
110PRUNTACT SearchPrint Unit AccountsCB_Print_Unit_AccountsBoolean0
111STACCNUM SearchStarting Account NumberAccount_NumberComposite 80
112STACCNUM_1 SearchStarting Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
113STACCNUM_2 SearchStarting Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
114STACCNUM_3 SearchStarting Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
115STACCNUM_4 SearchStarting Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
116STACCNUM_5 SearchStarting Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
117STACCNUM_6 SearchStarting Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
118STACCNUM_7 SearchStarting Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
119STACCNUM_8 SearchStarting Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
120STACCNUM_9 SearchStarting Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
121STACCNUM_10 SearchStarting Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
122EDGACNUM SearchEnding Account NumberAccount_NumberComposite 80
123EDGACNUM_1 SearchEnding Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
124EDGACNUM_2 SearchEnding Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
125EDGACNUM_3 SearchEnding Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
126EDGACNUM_4 SearchEnding Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
127EDGACNUM_5 SearchEnding Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
128EDGACNUM_6 SearchEnding Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
129EDGACNUM_7 SearchEnding Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
130EDGACNUM_8 SearchEnding Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
131EDGACNUM_9 SearchEnding Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
132EDGACNUM_10 SearchEnding Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
133SEGSRTBY SearchSegment Sort ByINT1Integer1
134RANGEBY SearchRange ByINTInteger0
135ACCLSTAT SearchAccelerator StatusINTInteger0
136USEACCEL SearchUse AcceleratorCB_Use_Accelerator_InformationBoolean0
137CBZBNA SearchZero Balance And No ActivityCB_Zero_AccountsBoolean0
138Accounts_Included SearchAccounts IncludedGBInteger0
139Start_Position_String SearchStart Position StringSTR89String89
140End_Position_String SearchEnd Position StringSTR89String89
141RPTXRATE SearchReporting Exchange RateDLR14_Exchange_RateCurrency (Variable)14
142RPRTCLMD SearchReporting Rate Calculation MethodDDL_Rate_Calculation_MethodInteger0
143PRTCURIN SearchPrint Currency InGBInteger0
144Checkbook_Date SearchCheckbook DateDTDate8
145End_Month SearchEnd MonthINT2_U0Integer2
146Start_Month SearchStart MonthINT2_U0Integer2
147YEAR1 SearchYearYearInteger4
148INCMCINF SearchInclude Multicurrency InfoCB_Include_Multicurrency_InfoBoolean0
149STCURRID SearchStart Currency IDSTR15_Currency_IDString15
150ENDCURID SearchEnd Currency IDSTR15_Currency_IDString15
151Include_Voided_Trx SearchInclude Voided TrxCB_Include_Voided_TrxBoolean0
152UseLedgersForAcctBalance SearchUse Ledgers For Account BalanceML_MultiSelectListBoxLong Integer0
153DEX_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.

azurecurveProductsMicrosoft Dynamics GP (0)FinancialGeneral Ledger Report Options (GL70500)

Leave a Reply

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