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

azurecurve Products Microsoft Dynamics GP (0)FinancialGeneral Ledger Report Options (GL70500)

Leave a Reply Cancel reply