General Ledger Report Options (GL70500)

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

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

Leave a Reply Cancel reply