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 Group Display Name: General Ledger Report Options
Physical Name: GL70500
Technical Name: GL_Options_ROPT
Group Technical Name: General Ledger Report Options
Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
---|---|---|---|---|---|---|
1 | IFFILXST ![]() | If File Existing | GB | Integer | 0 | |
2 | FILEXPNM ![]() | File Export Name | STR255 | String | 255 | |
3 | EXPTTYPE ![]() | Export Type | INT | Integer | 0 | |
4 | ASKECHTM ![]() | Ask Each Time | CB_Ask_Each_Time | Boolean | 0 | |
5 | PRNTOFIL ![]() | Print to File | CB_Print_to_File | Boolean | 0 | |
6 | PRTOPRTR ![]() | Print to Printer | CB_Print_to_Printer | Boolean | 0 | |
7 | PRTOSCRN ![]() | Print to Screen | CB_Print_to_Screen | Boolean | 0 | |
8 | PRNTTYPE ![]() | Print Type | GB | Integer | 0 | |
9 | RPTGRIND ![]() | Report Group Index | INT | Integer | 0 | |
10 | RTPACHIN ![]() | Report Palette Choice Index | INT | Integer | 0 | |
11 | RTGRSBIN ![]() | Report Group Sub Index | DLR14 | Currency | 14 | |
12 | REPORTID ![]() | Report ID | INT_STORAGE | Integer | 0 | |
13 | FINRPTNM ![]() | Financial Report Name | STR30 | String | 30 | |
14 | STGENINT1 ![]() | Start Generic Integer1 | INT | Integer | 0 | |
15 | ENDGENINT1 ![]() | End Generic Integer1 | INT | Integer | 0 | |
16 | STGENINT2 ![]() | Start Generic Integer2 | INT | Integer | 0 | |
17 | ENDGENINT2 ![]() | End Generic Integer2 | INT | Integer | 0 | |
18 | STRTNGDT ![]() | Starting Date | DT | Date | 8 | |
19 | ENDINGDT ![]() | Ending Date | DT | Date | 8 | |
20 | STTCATEG ![]() | Start Category | INT2_U0 | Integer | 2 | |
21 | STTUDEF1 ![]() | Start User Defined 1 | STR20 | String | 20 | |
22 | ENUSRDF1 ![]() | End User Defined 1 | STR20 | String | 20 | |
23 | ENDCATEG ![]() | End Category | INT2_U0 | Integer | 2 | |
24 | STTCATNM ![]() | Start Category Name | STR40_Category | String | 40 | |
25 | ENDCATNM ![]() | End Category Name | STR40_Category | String | 40 | |
26 | STRTJRNL ![]() | Start Journal | LI8_U0 | Long Integer | 8 | |
27 | ENDJRNAL ![]() | End Journal | LI8_U0 | Long Integer | 8 | |
28 | STRXSRC ![]() | Start TRX Source | STR13 | String | 13 | |
29 | ENTRXSRC ![]() | End TRX Source | STR13 | String | 13 | |
30 | STRTCMTRXNUM ![]() | Start CM Trx Number | STR20_Document_Number | String | 20 | |
31 | ENDCMTRXNUM ![]() | End CM Trx Number | STR20_Document_Number | String | 20 | |
32 | SSRCEDOC ![]() | Start Source Document | STR10_Source_Document | String | 10 | |
33 | ENDSRCDC ![]() | End Source Document | STR10_Source_Document | String | 10 | |
34 | STTACDSC ![]() | Start Account Description | STR50 | String | 50 | |
35 | ENDACDSC ![]() | End Account Description | STR50 | String | 50 | |
36 | STBDBSID ![]() | Start Budget Business ID | STR15 | String | 15 | |
37 | ENBDBSID ![]() | End Budget Business ID | STR15 | String | 15 | |
38 | STBDBSDS ![]() | Start Budget Business Description | STR30 | String | 30 | |
39 | ENBDBSDS ![]() | End Budget Business Description | STR30 | String | 30 | |
40 | STCHBKID ![]() | Start Checkbook ID | STR15_LBU | String | 15 | |
41 | ENCHBKID ![]() | End Checkbook ID | STR15_LBU | String | 15 | |
42 | STRTDSCR ![]() | Start Description | STR50 | String | 50 | |
43 | ENDDESCR ![]() | End Description | STR50 | String | 50 | |
44 | STTSEGID ![]() | Start Segment ID | STR10 | String | 10 | |
45 | ENDSEGID ![]() | End Segment ID | STR10 | String | 10 | |
46 | STCTRNUM ![]() | Start Control Number | STR20 | String | 20 | |
47 | ENCNTNUM ![]() | End Control Number | STR20 | String | 20 | |
48 | STDOCNUM ![]() | Start Document Number | STR20 | String | 20 | |
49 | ENDOCNUM ![]() | End Document Number | STR20 | String | 20 | |
50 | STMASTID ![]() | Start Master ID | STR20 | String | 20 | |
51 | ENMASTID ![]() | End Master ID | STR20 | String | 20 | |
52 | STMASTNM ![]() | Start Master Name | STR30 | String | 30 | |
53 | ENMASTNM ![]() | End Master Name | STR30 | String | 30 | |
54 | SORTBY ![]() | Sort By | DDL_Sort_By | Integer | 0 | |
55 | CBINACTS ![]() | CB Inactive Accounts | CB_Inactive_Accounts | Boolean | 0 | |
56 | PSTNGACT ![]() | Posting Account | INT1 | Integer | 1 | |
57 | UNITACCT ![]() | Unit Account | INT1 | Integer | 1 | |
58 | RPRTSHOW ![]() | Reports Show | DDL | Integer | 0 | |
59 | PRRPTFOR ![]() | Print Report For | GB | Integer | 0 | |
60 | PRVYRCMB ![]() | Previous Year CMB | CMB | String | 4 | |
61 | RPTDETAL ![]() | Report Detail | Report Detail | Integer | 0 | |
62 | INDIVDUL ![]() | Individual | CB | Boolean | 0 | |
63 | INDIVDUL_1 ![]() | Individual[1] | CB | Boolean | 0 | |
64 | INDIVDUL_2 ![]() | Individual[2] | CB | Boolean | 0 | |
65 | INDIVDUL_3 ![]() | Individual[3] | CB | Boolean | 0 | |
66 | INDIVDUL_4 ![]() | Individual[4] | CB | Boolean | 0 | |
67 | INDIVDUL_5 ![]() | Individual[5] | CB | Boolean | 0 | |
68 | INDIVDUL_6 ![]() | Individual[6] | CB | Boolean | 0 | |
69 | INDIVDUL_7 ![]() | Individual[7] | CB | Boolean | 0 | |
70 | INDIVDUL_8 ![]() | Individual[8] | CB | Boolean | 0 | |
71 | INDIVDUL_9 ![]() | Individual[9] | CB | Boolean | 0 | |
72 | INDIVDUL_10 ![]() | Individual[10] | CB | Boolean | 0 | |
73 | INDIVDUL_11 ![]() | Individual[11] | CB | Boolean | 0 | |
74 | INDIVDUL_12 ![]() | Individual[12] | CB | Boolean | 0 | |
75 | INDIVDUL_13 ![]() | Individual[13] | CB | Boolean | 0 | |
76 | INDIVDUL_14 ![]() | Individual[14] | CB | Boolean | 0 | |
77 | INDIVDUL_15 ![]() | Individual[15] | CB | Boolean | 0 | |
78 | INDIVDUL_16 ![]() | Individual[16] | CB | Boolean | 0 | |
79 | INDIVDUL_17 ![]() | Individual[17] | CB | Boolean | 0 | |
80 | INDIVDUL_18 ![]() | Individual[18] | CB | Boolean | 0 | |
81 | INDIVDUL_19 ![]() | Individual[19] | CB | Boolean | 0 | |
82 | INDIVDUL_20 ![]() | Individual[20] | CB | Boolean | 0 | |
83 | INDIVDUL_21 ![]() | Individual[21] | CB | Boolean | 0 | |
84 | INDIVDUL_22 ![]() | Individual[22] | CB | Boolean | 0 | |
85 | INDIVDUL_23 ![]() | Individual[23] | CB | Boolean | 0 | |
86 | INDIVDUL_24 ![]() | Individual[24] | CB | Boolean | 0 | |
87 | INDIVDUL_25 ![]() | Individual[25] | CB | Boolean | 0 | |
88 | INDIVDUL_26 ![]() | Individual[26] | CB | Boolean | 0 | |
89 | INDIVDUL_27 ![]() | Individual[27] | CB | Boolean | 0 | |
90 | INDIVDUL_28 ![]() | Individual[28] | CB | Boolean | 0 | |
91 | INDIVDUL_29 ![]() | Individual[29] | CB | Boolean | 0 | |
92 | INDIVDUL_30 ![]() | Individual[30] | CB | Boolean | 0 | |
93 | INDIVDUL_31 ![]() | Individual[31] | CB | Boolean | 0 | |
94 | INDIVDUL_32 ![]() | Individual[32] | CB | Boolean | 0 | |
95 | INDIVDUL_33 ![]() | Individual[33] | CB | Boolean | 0 | |
96 | INDIVDUL_34 ![]() | Individual[34] | CB | Boolean | 0 | |
97 | INDIVDUL_35 ![]() | Individual[35] | CB | Boolean | 0 | |
98 | INDIVDUL_36 ![]() | Individual[36] | CB | Boolean | 0 | |
99 | INDIVDUL_37 ![]() | Individual[37] | CB | Boolean | 0 | |
100 | INDIVDUL_38 ![]() | Individual[38] | CB | Boolean | 0 | |
101 | INDIVDUL_39 ![]() | Individual[39] | CB | Boolean | 0 | |
102 | INDIVDUL_40 ![]() | Individual[40] | CB | Boolean | 0 | |
103 | INDIVDUL_41 ![]() | Individual[41] | CB | Boolean | 0 | |
104 | PRNTDSCR ![]() | Print Description | GB | Integer | 0 | |
105 | PRZROBAL ![]() | Print Zero Balances | YN | Boolean | 0 | |
106 | CLCRATIO ![]() | Calculate Ratio | GB | Integer | 0 | |
107 | INCLGNDS ![]() | Include Legends | CB_Include_Legends | Boolean | 0 | |
108 | GLSTTKDT ![]() | GL Start Token Date | DDL_GL_Token_Dates | Integer | 0 | |
109 | GLENTKDT ![]() | GL End Token Date | DDL_GL_Token_Dates | Integer | 0 | |
110 | PRUNTACT ![]() | Print Unit Accounts | CB_Print_Unit_Accounts | Boolean | 0 | |
111 | STACCNUM ![]() | Starting Account Number | Account_Number | Composite | 80 | |
112 | STACCNUM_1 ![]() | Starting Account Number:Account_Segment_Pool1 | Account_Segment_Pool1 | String | 6 | |
113 | STACCNUM_2 ![]() | Starting Account Number:Account_Segment_Pool2 | Account_Segment_Pool2 | String | 6 | |
114 | STACCNUM_3 ![]() | Starting Account Number:Account_Segment_Pool3 | Account_Segment_Pool3 | String | 6 | |
115 | STACCNUM_4 ![]() | Starting Account Number:Account_Segment_Pool4 | Account_Segment_Pool4 | String | 6 | |
116 | STACCNUM_5 ![]() | Starting Account Number:Account_Segment_Pool5 | Account_Segment_Pool5 | String | 6 | |
117 | STACCNUM_6 ![]() | Starting Account Number:Account_Segment_Pool6 | Account_Segment_Pool6 | String | 6 | |
118 | STACCNUM_7 ![]() | Starting Account Number:Account_Segment_Pool7 | Account_Segment_Pool7 | String | 6 | |
119 | STACCNUM_8 ![]() | Starting Account Number:Account_Segment_Pool8 | Account_Segment_Pool8 | String | 6 | |
120 | STACCNUM_9 ![]() | Starting Account Number:Account_Segment_Pool9 | Account_Segment_Pool9 | String | 6 | |
121 | STACCNUM_10 ![]() | Starting Account Number:Account_Segment_Pool10 | Account_Segment_Pool10 | String | 6 | |
122 | EDGACNUM ![]() | Ending Account Number | Account_Number | Composite | 80 | |
123 | EDGACNUM_1 ![]() | Ending Account Number:Account_Segment_Pool1 | Account_Segment_Pool1 | String | 6 | |
124 | EDGACNUM_2 ![]() | Ending Account Number:Account_Segment_Pool2 | Account_Segment_Pool2 | String | 6 | |
125 | EDGACNUM_3 ![]() | Ending Account Number:Account_Segment_Pool3 | Account_Segment_Pool3 | String | 6 | |
126 | EDGACNUM_4 ![]() | Ending Account Number:Account_Segment_Pool4 | Account_Segment_Pool4 | String | 6 | |
127 | EDGACNUM_5 ![]() | Ending Account Number:Account_Segment_Pool5 | Account_Segment_Pool5 | String | 6 | |
128 | EDGACNUM_6 ![]() | Ending Account Number:Account_Segment_Pool6 | Account_Segment_Pool6 | String | 6 | |
129 | EDGACNUM_7 ![]() | Ending Account Number:Account_Segment_Pool7 | Account_Segment_Pool7 | String | 6 | |
130 | EDGACNUM_8 ![]() | Ending Account Number:Account_Segment_Pool8 | Account_Segment_Pool8 | String | 6 | |
131 | EDGACNUM_9 ![]() | Ending Account Number:Account_Segment_Pool9 | Account_Segment_Pool9 | String | 6 | |
132 | EDGACNUM_10 ![]() | Ending Account Number:Account_Segment_Pool10 | Account_Segment_Pool10 | String | 6 | |
133 | SEGSRTBY ![]() | Segment Sort By | INT1 | Integer | 1 | |
134 | RANGEBY ![]() | Range By | INT | Integer | 0 | |
135 | ACCLSTAT ![]() | Accelerator Status | INT | Integer | 0 | |
136 | USEACCEL ![]() | Use Accelerator | CB_Use_Accelerator_Information | Boolean | 0 | |
137 | CBZBNA ![]() | Zero Balance And No Activity | CB_Zero_Accounts | Boolean | 0 | |
138 | Accounts_Included ![]() | Accounts Included | GB | Integer | 0 | |
139 | Start_Position_String ![]() | Start Position String | STR89 | String | 89 | |
140 | End_Position_String ![]() | End Position String | STR89 | String | 89 | |
141 | RPTXRATE ![]() | Reporting Exchange Rate | DLR14_Exchange_Rate | Currency (Variable) | 14 | |
142 | RPRTCLMD ![]() | Reporting Rate Calculation Method | DDL_Rate_Calculation_Method | Integer | 0 | |
143 | PRTCURIN ![]() | Print Currency In | GB | Integer | 0 | |
144 | Checkbook_Date ![]() | Checkbook Date | DT | Date | 8 | |
145 | End_Month ![]() | End Month | INT2_U0 | Integer | 2 | |
146 | Start_Month ![]() | Start Month | INT2_U0 | Integer | 2 | |
147 | YEAR1 ![]() | Year | Year | Integer | 4 | |
148 | INCMCINF ![]() | Include Multicurrency Info | CB_Include_Multicurrency_Info | Boolean | 0 | |
149 | STCURRID ![]() | Start Currency ID | STR15_Currency_ID | String | 15 | |
150 | ENDCURID ![]() | End Currency ID | STR15_Currency_ID | String | 15 | |
151 | Include_Voided_Trx ![]() | Include Voided Trx | CB_Include_Voided_Trx | Boolean | 0 | |
152 | UseLedgersForAcctBalance ![]() | Use Ledgers For Account Balance | ML_MultiSelectListBox | Long Integer | 0 | |
153 | DEX_ROW_ID ![]() | int | int | 10 | ||
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. |