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 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
14STGENINT1 SearchStart Generic Integer1INTInteger20
15ENDGENINT1 SearchEnd Generic Integer1INTInteger20
16STGENINT2 SearchStart Generic Integer2INTInteger20
17ENDGENINT2 SearchEnd Generic Integer2INTInteger20
18STRTNGDT SearchStarting DateDTDate48
19ENDINGDT SearchEnding DateDTDate48
20STTCATEG SearchStart CategoryINT2_U0Integer22
21STTUDEF1 SearchStart User Defined 1STR20String2220
22ENUSRDF1 SearchEnd User Defined 1STR20String2220
23ENDCATEG SearchEnd CategoryINT2_U0Integer22
24STTCATNM SearchStart Category NameSTR40_CategoryString4240
25ENDCATNM SearchEnd Category NameSTR40_CategoryString4240
26STRTJRNL SearchStart JournalLI8_U0Long Integer48
27ENDJRNAL SearchEnd JournalLI8_U0Long Integer48
28STRXSRC SearchStart TRX SourceSTR13String1413
29ENTRXSRC SearchEnd TRX SourceSTR13String1413
30STRTCMTRXNUM SearchStart CM Trx NumberSTR20_Document_NumberString2220
31ENDCMTRXNUM SearchEnd CM Trx NumberSTR20_Document_NumberString2220
32SSRCEDOC SearchStart Source DocumentSTR10_Source_DocumentString1210
33ENDSRCDC SearchEnd Source DocumentSTR10_Source_DocumentString1210
34STTACDSC SearchStart Account DescriptionSTR50String5250
35ENDACDSC SearchEnd Account DescriptionSTR50String5250
36STBDBSID SearchStart Budget Business IDSTR15String1615
37ENBDBSID SearchEnd Budget Business IDSTR15String1615
38STBDBSDS SearchStart Budget Business DescriptionSTR30String3230
39ENBDBSDS SearchEnd Budget Business DescriptionSTR30String3230
40STCHBKID SearchStart Checkbook IDSTR15_LBUString1615
41ENCHBKID SearchEnd Checkbook IDSTR15_LBUString1615
42STRTDSCR SearchStart DescriptionSTR50String5250
43ENDDESCR SearchEnd DescriptionSTR50String5250
44STTSEGID SearchStart Segment IDSTR10String1210
45ENDSEGID SearchEnd Segment IDSTR10String1210
46STCTRNUM SearchStart Control NumberSTR20String2220
47ENCNTNUM SearchEnd Control NumberSTR20String2220
48STDOCNUM SearchStart Document NumberSTR20String2220
49ENDOCNUM SearchEnd Document NumberSTR20String2220
50STMASTID SearchStart Master IDSTR20String2220
51ENMASTID SearchEnd Master IDSTR20String2220
52STMASTNM SearchStart Master NameSTR30String3230
53ENMASTNM SearchEnd Master NameSTR30String3230
54SORTBY SearchSort ByDDL_Sort_ByInteger20
55CBINACTS SearchCB Inactive AccountsCB_Inactive_AccountsBoolean20
56PSTNGACT SearchPosting AccountINT1Integer21
57UNITACCT SearchUnit AccountINT1Integer21
58RPRTSHOW SearchReports ShowDDLInteger20
59PRRPTFOR SearchPrint Report ForGBInteger20
60PRVYRCMB SearchPrevious Year CMBCMBString64
61RPTDETAL SearchReport DetailReport DetailInteger20
62INDIVDUL SearchIndividualCBBoolean20
63INDIVDUL_1 SearchIndividual[1]CBBoolean20
64INDIVDUL_2 SearchIndividual[2]CBBoolean20
65INDIVDUL_3 SearchIndividual[3]CBBoolean20
66INDIVDUL_4 SearchIndividual[4]CBBoolean20
67INDIVDUL_5 SearchIndividual[5]CBBoolean20
68INDIVDUL_6 SearchIndividual[6]CBBoolean20
69INDIVDUL_7 SearchIndividual[7]CBBoolean20
70INDIVDUL_8 SearchIndividual[8]CBBoolean20
71INDIVDUL_9 SearchIndividual[9]CBBoolean20
72INDIVDUL_10 SearchIndividual[10]CBBoolean20
73INDIVDUL_11 SearchIndividual[11]CBBoolean20
74INDIVDUL_12 SearchIndividual[12]CBBoolean20
75INDIVDUL_13 SearchIndividual[13]CBBoolean20
76INDIVDUL_14 SearchIndividual[14]CBBoolean20
77INDIVDUL_15 SearchIndividual[15]CBBoolean20
78INDIVDUL_16 SearchIndividual[16]CBBoolean20
79INDIVDUL_17 SearchIndividual[17]CBBoolean20
80INDIVDUL_18 SearchIndividual[18]CBBoolean20
81INDIVDUL_19 SearchIndividual[19]CBBoolean20
82INDIVDUL_20 SearchIndividual[20]CBBoolean20
83INDIVDUL_21 SearchIndividual[21]CBBoolean20
84INDIVDUL_22 SearchIndividual[22]CBBoolean20
85INDIVDUL_23 SearchIndividual[23]CBBoolean20
86INDIVDUL_24 SearchIndividual[24]CBBoolean20
87INDIVDUL_25 SearchIndividual[25]CBBoolean20
88INDIVDUL_26 SearchIndividual[26]CBBoolean20
89INDIVDUL_27 SearchIndividual[27]CBBoolean20
90INDIVDUL_28 SearchIndividual[28]CBBoolean20
91INDIVDUL_29 SearchIndividual[29]CBBoolean20
92INDIVDUL_30 SearchIndividual[30]CBBoolean20
93INDIVDUL_31 SearchIndividual[31]CBBoolean20
94INDIVDUL_32 SearchIndividual[32]CBBoolean20
95INDIVDUL_33 SearchIndividual[33]CBBoolean20
96INDIVDUL_34 SearchIndividual[34]CBBoolean20
97INDIVDUL_35 SearchIndividual[35]CBBoolean20
98INDIVDUL_36 SearchIndividual[36]CBBoolean20
99INDIVDUL_37 SearchIndividual[37]CBBoolean20
100INDIVDUL_38 SearchIndividual[38]CBBoolean20
101INDIVDUL_39 SearchIndividual[39]CBBoolean20
102INDIVDUL_40 SearchIndividual[40]CBBoolean20
103INDIVDUL_41 SearchIndividual[41]CBBoolean20
104PRNTDSCR SearchPrint DescriptionGBInteger20
105PRZROBAL SearchPrint Zero BalancesYNBoolean20
106CLCRATIO SearchCalculate RatioGBInteger20
107INCLGNDS SearchInclude LegendsCB_Include_LegendsBoolean20
108GLSTTKDT SearchGL Start Token DateDDL_GL_Token_DatesInteger20
109GLENTKDT SearchGL End Token DateDDL_GL_Token_DatesInteger20
110PRUNTACT SearchPrint Unit AccountsCB_Print_Unit_AccountsBoolean20
111STACCNUM SearchStarting Account NumberAccount_NumberComposite 8080
112STACCNUM_1 SearchStarting Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
113STACCNUM_2 SearchStarting Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
114STACCNUM_3 SearchStarting Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
115STACCNUM_4 SearchStarting Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
116STACCNUM_5 SearchStarting Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
117STACCNUM_6 SearchStarting Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
118STACCNUM_7 SearchStarting Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
119STACCNUM_8 SearchStarting Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
120STACCNUM_9 SearchStarting Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
121STACCNUM_10 SearchStarting Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
122EDGACNUM SearchEnding Account NumberAccount_NumberComposite 8080
123EDGACNUM_1 SearchEnding Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
124EDGACNUM_2 SearchEnding Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
125EDGACNUM_3 SearchEnding Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
126EDGACNUM_4 SearchEnding Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
127EDGACNUM_5 SearchEnding Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
128EDGACNUM_6 SearchEnding Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
129EDGACNUM_7 SearchEnding Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
130EDGACNUM_8 SearchEnding Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
131EDGACNUM_9 SearchEnding Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
132EDGACNUM_10 SearchEnding Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
133SEGSRTBY SearchSegment Sort ByINT1Integer21
134RANGEBY SearchRange ByINTInteger20
135ACCLSTAT SearchAccelerator StatusINTInteger20
136USEACCEL SearchUse AcceleratorCB_Use_Accelerator_InformationBoolean20
137CBZBNA SearchZero Balance And No ActivityCB_Zero_AccountsBoolean20
138Accounts_Included SearchAccounts IncludedGBInteger20
139Start_Position_String SearchStart Position StringSTR89String9089
140End_Position_String SearchEnd Position StringSTR89String9089
141RPTXRATE SearchReporting Exchange RateDLR14_Exchange_RateCurrency (Variable)1014
142RPRTCLMD SearchReporting Rate Calculation MethodDDL_Rate_Calculation_MethodInteger20
143PRTCURIN SearchPrint Currency InGBInteger20
144Checkbook_Date SearchCheckbook DateDTDate48
145End_Month SearchEnd MonthINT2_U0Integer22
146Start_Month SearchStart MonthINT2_U0Integer22
147YEAR1 SearchYearYearInteger24
148INCMCINF SearchInclude Multicurrency InfoCB_Include_Multicurrency_InfoBoolean20
149STCURRID SearchStart Currency IDSTR15_Currency_IDString1615
150ENDCURID SearchEnd Currency IDSTR15_Currency_IDString1615
151Include_Voided_Trx SearchInclude Voided TrxCB_Include_Voided_TrxBoolean20
152UseLedgersForAcctBalance SearchUse Ledgers For Account BalanceML_MultiSelectListBoxLong Integer40
153DEX_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.

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

Leave a Reply

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