GL70500 - General Ledger Report Options | Prospr

GL70500 - General Ledger Report Options

Query Builder

Select * from GL70500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
IFFILXST	If File Existing	Integer	2	View
FILEXPNM	File Export Name	String	256	View
EXPTTYPE	Export Type	Integer	2	View
ASKECHTM	Ask Each Time	Boolean	2	View
PRNTOFIL	Print to File	Boolean	2	View
PRTOPRTR	Print to Printer	Boolean	2	View
PRTOSCRN	Print to Screen	Boolean	2	View
PRNTTYPE	Print Type	Integer	2	View
RPTGRIND	Report Group Index	Integer	2	View
RTPACHIN	Report Palette Choice Index	Integer	2	View
RTGRSBIN	Report Group Sub Index	Currency	10	View
REPORTID	Report ID	Integer	2	View
FINRPTNM	Financial Report Name	String	32	View
STGENINT1	Start Generic Integer1	Integer	2	View
ENDGENINT1	End Generic Integer1	Integer	2	View
STGENINT2	Start Generic Integer2	Integer	2	View
ENDGENINT2	End Generic Integer2	Integer	2	View
STRTNGDT	Starting Date	Date	4	View
ENDINGDT	Ending Date	Date	4	View
STTCATEG	Start Category	Integer	2	View
STTUDEF1	Start User Defined 1	String	22	View
ENUSRDF1	End User Defined 1	String	22	View
ENDCATEG	End Category	Integer	2	View
STTCATNM	Start Category Name	String	42	View
ENDCATNM	End Category Name	String	42	View
STRTJRNL	Start Journal	Long Integer	4	View
ENDJRNAL	End Journal	Long Integer	4	View
STRXSRC	Start TRX Source	String	14	View
ENTRXSRC	End TRX Source	String	14	View
STRTCMTRXNUM	Start CM Trx Number	String	22	View
ENDCMTRXNUM	End CM Trx Number	String	22	View
SSRCEDOC	Start Source Document	String	12	View
ENDSRCDC	End Source Document	String	12	View
STTACDSC	Start Account Description	String	52	View
ENDACDSC	End Account Description	String	52	View
STBDBSID	Start Budget Business ID	String	16	View
ENBDBSID	End Budget Business ID	String	16	View
STBDBSDS	Start Budget Business Description	String	32	View
ENBDBSDS	End Budget Business Description	String	32	View
STCHBKID	Start Checkbook ID	String	16	View
ENCHBKID	End Checkbook ID	String	16	View
STRTDSCR	Start Description	String	52	View
ENDDESCR	End Description	String	52	View
STTSEGID	Start Segment ID	String	12	View
ENDSEGID	End Segment ID	String	12	View
STCTRNUM	Start Control Number	String	22	View
ENCNTNUM	End Control Number	String	22	View
STDOCNUM	Start Document Number	String	22	View
ENDOCNUM	End Document Number	String	22	View
STMASTID	Start Master ID	String	22	View
ENMASTID	End Master ID	String	22	View
STMASTNM	Start Master Name	String	32	View
ENMASTNM	End Master Name	String	32	View
SORTBY	Sort By	Integer	2	View
CBINACTS	CB Inactive Accounts	Boolean	2	View
PSTNGACT	Posting Account	Integer	2	View
UNITACCT	Unit Account	Integer	2	View
RPRTSHOW	Reports Show	Integer	2	View
PRRPTFOR	Print Report For	Integer	2	View
PRVYRCMB	Previous Year CMB	String	6	View
RPTDETAL	Report Detail	Integer	2	View
INDIVDUL_1	Individual[1]	Boolean	2	View
INDIVDUL_2	Individual[2]	Boolean	2	View
INDIVDUL_3	Individual[3]	Boolean	2	View
INDIVDUL_4	Individual[4]	Boolean	2	View
INDIVDUL_5	Individual[5]	Boolean	2	View
INDIVDUL_6	Individual[6]	Boolean	2	View
INDIVDUL_7	Individual[7]	Boolean	2	View
INDIVDUL_8	Individual[8]	Boolean	2	View
INDIVDUL_9	Individual[9]	Boolean	2	View
INDIVDUL_10	Individual[10]	Boolean	2	View
INDIVDUL_11	Individual[11]	Boolean	2	View
INDIVDUL_12	Individual[12]	Boolean	2	View
INDIVDUL_13	Individual[13]	Boolean	2	View
INDIVDUL_14	Individual[14]	Boolean	2	View
INDIVDUL_15	Individual[15]	Boolean	2	View
INDIVDUL_16	Individual[16]	Boolean	2	View
INDIVDUL_17	Individual[17]	Boolean	2	View
INDIVDUL_18	Individual[18]	Boolean	2	View
INDIVDUL_19	Individual[19]	Boolean	2	View
INDIVDUL_20	Individual[20]	Boolean	2	View
INDIVDUL_21	Individual[21]	Boolean	2	View
INDIVDUL_22	Individual[22]	Boolean	2	View
INDIVDUL_23	Individual[23]	Boolean	2	View
INDIVDUL_24	Individual[24]	Boolean	2	View
INDIVDUL_25	Individual[25]	Boolean	2	View
INDIVDUL_26	Individual[26]	Boolean	2	View
INDIVDUL_27	Individual[27]	Boolean	2	View
INDIVDUL_28	Individual[28]	Boolean	2	View
INDIVDUL_29	Individual[29]	Boolean	2	View
INDIVDUL_30	Individual[30]	Boolean	2	View
INDIVDUL_31	Individual[31]	Boolean	2	View
INDIVDUL_32	Individual[32]	Boolean	2	View
INDIVDUL_33	Individual[33]	Boolean	2	View
INDIVDUL_34	Individual[34]	Boolean	2	View
INDIVDUL_35	Individual[35]	Boolean	2	View
INDIVDUL_36	Individual[36]	Boolean	2	View
INDIVDUL_37	Individual[37]	Boolean	2	View
INDIVDUL_38	Individual[38]	Boolean	2	View
INDIVDUL_39	Individual[39]	Boolean	2	View
INDIVDUL_40	Individual[40]	Boolean	2	View
INDIVDUL_41	Individual[41]	Boolean	2	View
PRNTDSCR	Print Description	Integer	2	View
PRZROBAL	Print Zero Balances	Boolean	2	View
CLCRATIO	Calculate Ratio	Integer	2	View
INCLGNDS	Include Legends	Boolean	2	View
GLSTTKDT	GL Start Token Date	Integer	2	View
GLENTKDT	GL End Token Date	Integer	2	View
PRUNTACT	Print Unit Accounts	Boolean	2	View
STACCNUM_1	Starting Account Number:Account_Segment_Pool1	String	10	View
STACCNUM_2	Starting Account Number:Account_Segment_Pool2	String	10	View
STACCNUM_3	Starting Account Number:Account_Segment_Pool3	String	10	View
STACCNUM_4	Starting Account Number:Account_Segment_Pool4	String	10	View
STACCNUM_5	Starting Account Number:Account_Segment_Pool5	String	10	View
EDGACNUM_1	Ending Account Number:Account_Segment_Pool1	String	10	View
EDGACNUM_2	Ending Account Number:Account_Segment_Pool2	String	10	View
EDGACNUM_3	Ending Account Number:Account_Segment_Pool3	String	10	View
EDGACNUM_4	Ending Account Number:Account_Segment_Pool4	String	10	View
EDGACNUM_5	Ending Account Number:Account_Segment_Pool5	String	10	View
SEGSRTBY	Segment Sort By	Integer	2	View
RANGEBY	Range By	Integer	2	View
ACCLSTAT	Accelerator Status	Integer	2	View
USEACCEL	Use Accelerator	Boolean	2	View
CBZBNA	Zero Balance And No Activity	Boolean	2	View
Accounts_Included	Accounts Included	Integer	2	View
Start_Position_String	Start Position String	String	90	View
End_Position_String	End Position String	String	90	View
RPTXRATE	Reporting Exchange Rate	Currency (Variable)	10	View
RPRTCLMD	Reporting Rate Calculation Method	Integer	2	View
PRTCURIN	Print Currency In	Integer	2	View
Checkbook_Date	Checkbook Date	Date	4	View
End_Month	End Month	Integer	2	View
Start_Month	Start Month	Integer	2	View
YEAR1	Year	Integer	2	View
INCMCINF	Include Multicurrency Info	Boolean	2	View
STCURRID	Start Currency ID	String	16	View
ENDCURID	End Currency ID	String	16	View
Include_Voided_Trx	Include Voided Trx	Boolean	2	View
UseLedgersForAcctBalance	Use Ledgers For Account Balance	Long Integer	4	View

GL70500 - General Ledger Report Options

Query Builder

Customer Service

Information

My Account

Contact Us