GL10100 - Quick Journal Work | Prospr - Dynamics GP Table Reference

GL10100 - Quick Journal Work

Select * from GL10100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
BSNSFMID	Business Form ID	String	16	View
JRNENTRY	Journal Entry	Long Integer	4	View
CURNCYID	Currency ID	String	16	View
OFFINDX	Offset Account Index	Long Integer	4	View
TRXDATE	TRX Date	Date	4	View
TRXBALNC	TRX Balance	Currency	10	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
PSTDAMNT	Posted Amount	Currency	10	View
REFRENCE	Reference	String	32	View
SOURCDOC	Source Document 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo	String	12	View
SQNCLINE	Sequence Line	Currency	10	View
TRXSORCE	TRX Source	String	14	View
GLHDRMSG	GL HDR Messages	Long Integer	4	View
GLHDRMS2	GL HDR Messages2	Long Integer	4	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
ERRSTATE	Error State	Long Integer	4	View
HISTRX	History TRX	Boolean	2	View
OFFACTYP	Offset Account Type	Integer	2	View
OFFBLCLC	Offset Bal For Cal	Integer	2	View
OFFXVAR	Offset Fixed Or Variable	Integer	2	View
OFFPSTYP	Offset Posting Type	Integer	2	View
DOCDATE	Document Date	Date	4	View
VOIDED	Voided	Boolean	2	View