GL20000 - Year-to-Date Transaction Open | Prospr

GL20000 - Year-to-Date Transaction Open

Query Builder

Select * from GL20000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
OPENYEAR	Open Year	Integer	2	View
JRNENTRY	Journal Entry	Long Integer	4	View
RCTRXSEQ	Recurring TRX Sequence	Currency	10	View
SOURCDOC	Source Document 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo	String	12	View
REFRENCE	Reference	String	32	View
DSCRIPTN	Description	String	32	View
TRXDATE	TRX Date	Date	4	View
TRXSORCE	TRX Source	String	14	View
ACTINDX	Account Index	Long Integer	4	View
POLLDTRX	Polled Transaction	Boolean	2	View
LASTUSER	Last User	String	16	View
LSTDTEDT	Last Date Edited	Date	4	View
USWHPSTD	User Who Posted	String	16	View
ORGNTSRC	Originating Source	String	16	View
ORGNATYP	Originating Type	Integer	2	View
QKOFSET	Quick Offset	Integer	2	View
SERIES	Series 1 = All 2 = Financial 3 = Sales 4 = Purchasing 5 = Inventory 6 = Payroll - USA 7 = Project	Integer	2	View
ORTRXTYP	Originating TRX Type	Integer	2	View
ORCTRNUM	Originating Control Number	String	22	View
ORMSTRID	Originating Master ID	String	32	View
ORMSTRNM	Originating Master Name	String	66	View
ORDOCNUM	Originating Document Number	String	22	View
ORPSTDDT	Originating Posted Date	Date	4	View
ORTRXSRC	Originating TRX Source	String	14	View
OrigDTASeries	Originating DTA Series	Integer	2	View
OrigSeqNum	Originating Sequence Number	Long Integer	4	View
SEQNUMBR	Sequence Number	Long Integer	4	View
DTA_GL_Status	DTA GL Status	Integer	2	View
DTA_Index	DTA Index	Currency	10	View
CURNCYID	Currency ID	String	16	View
CURRNIDX	Currency Index	Integer	2	View
RATETPID	Rate Type ID	String	16	View
EXGTBLID	Exchange Table ID	String	16	View
XCHGRATE	Exchange Rate	Currency (Variable)	10	View
EXCHDATE	Exchange Date	Date	4	View
TIME1	Time	Time	4	View
RTCLCMTD	Rate Calculation Method	Integer	2	View
NOTEINDX	Note Index	Currency	10	View
ICTRX	IC TRX	Boolean	2	View
ORCOMID	Originating Company ID	String	6	View
ORIGINJE	Originating Journal Entry	Long Integer	4	View
PERIODID	Period ID	Integer	2	View
CRDTAMNT	Credit Amount	Currency	10	View
DEBITAMT	Debit Amount	Currency	10	View
ORCRDAMT	Originating Credit Amount	Currency	10	View
ORDBTAMT	Originating Debit Amount	Currency	10	View
DOCDATE	Document Date	Date	4	View
PSTGNMBR	Posting Number	Long Integer	4	View
PPSGNMBR	Period Posting Number	Long Integer	4	View
DENXRATE	Denomination Exchange Rate	Currency (Variable)	10	View
MCTRXSTT	MC Transaction State 0 = Euro currency is not created or no denomination currencies are enabled. 1 = Originating is not a denomination; Functional is not a denomination 2 = Originating is not a denomination; Functional is the Euro currency. 3 = Originating is not a denomination; Functional is a denomination. 4 = Originating is a denomination; Functional is not a denomination. 5 = Originating is a denomination; Functional is a denomination. 6 = Originating is a denomination; Functional is the Euro currency. 7 = Originating is the Euro currency; Functional is a denomination. 8 = Originating is the Euro currency; Functional is not a denomination.	Integer	2	View
CorrespondingUnit	CorrespondingUnit	String	6	View
VOIDED	Voided	Boolean	2	View
Back_Out_JE	Back Out JE	Long Integer	4	View
Back_Out_JE_Year	Back Out JE Year	Integer	2	View
Correcting_JE	Correcting JE	Long Integer	4	View
Correcting_JE_Year	Correcting JE Year	Integer	2	View
Original_JE	Original JE	Long Integer	4	View
Original_JE_Seq_Num	Original JE Seq Num	Currency	10	View
Original_JE_Year	Original JE Year	Integer	2	View
Ledger_ID	Ledger ID	Integer	2	View
Adjustment_Transaction	Adjustment Transaction	Boolean	2	View
APRVLUSERID	Approval User ID	String	16	View
APPRVLDT	Approval Date	Date	4	View

GL20000 - Year-to-Date Transaction Open

Query Builder

Customer Service

Information

My Account

Contact Us