GL10000 - Transaction Work | Prospr - Dynamics GP Table Reference

GL10000 - Transaction Work

Query Builder

Select * from GL10000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
BACHNUMB	Batch Number	String	16	View
BCHSOURC	Batch Source	String	16	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
TRXDATE	TRX Date	Date	4	View
RVRSNGDT	Reversing Date	Date	4	View
RCRNGTRX	Recurring TRX	Boolean	2	View
BALFRCLC	Balance For Calculation 0 = Year To Date 1 = TRX Period	Integer	2	View
PSTGSTUS	Posting Status 1 = Work 2 = Open 3 = History 4 = Originating	Integer	2	View
LASTUSER	Last User	String	16	View
LSTDTEDT	Last Date Edited	Date	4	View
USWHPSTD	User Who Posted	String	16	View
TRXTYPE	Transaction Type	Integer	2	View
SQNCLINE	Sequence Line	Currency	10	View
GLHDRMSG	GL HDR Messages	Long Integer	4	View
GLHDRMS2	GL HDR Messages2	Long Integer	4	View
TRXSORCE	TRX Source	String	14	View
RVTRXSRC	Reversing TRX Source	String	14	View
SERIES	Series 1 = All 2 = Financial 3 = Sales 4 = Purchasing 5 = Inventory 6 = Payroll - USA 7 = Project	Integer	2	View
ORPSTDDT	Originating Posted Date	Date	4	View
ORTRXSRC	Originating TRX Source	String	14	View
OrigDTASeries	Originating DTA Series	Integer	2	View
DTAControlNum	DTA Control Number	String	22	View
DTATRXType	DTA TRX Type	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
GLHDRVAL	GL Header Valid	Long Integer	4	View
PERIODID	Period ID	Integer	2	View
OPENYEAR	Open Year	Integer	2	View
CLOSEDYR	Closed Year	Integer	2	View
HISTRX	History TRX	Boolean	2	View
REVPRDID	Reversing Period ID	Integer	2	View
REVYEAR	Reversing Year	Integer	2	View
REVCLYR	Reversing Closed Year	Integer	2	View
REVHIST	Reversing History TRX	Boolean	2	View
ERRSTATE	Error State	Long Integer	4	View
ICTRX	IC TRX	Boolean	2	View
ORCOMID	Originating Company ID	String	6	View
ORIGINJE	Originating Journal Entry	Long Integer	4	View
ICDISTS	ICDists	Boolean	2	View
PRNTSTUS	Printing Status	Integer	2	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
DOCDATE	Document Date	Date	4	View
Tax_Date	Tax Date	Date	4	View
VOIDED	Voided	Boolean	2	View
Original_JE	Original JE	Long Integer	4	View
Original_JE_Year	Original JE Year	Integer	2	View
Original_JE_Seq_Num	Original JE Seq Num	Currency	10	View
Correcting_Trx_Type	Correcting Trx Type	Integer	2	View
Ledger_ID	Ledger ID	Integer	2	View
Adjustment_Transaction	Adjustment Transaction	Boolean	2	View

GL10000 - Transaction Work

Query Builder

Customer Service

Information

My Account

Contact Us