GL12000 - Budget Transaction Work | Prospr - Dynamics GP Table Reference

GL12000 - Budget Transaction Work

Select * from GL12000

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
BCHSOURC	Batch Source	String	16	View
BACHNUMB	Batch Number	String	16	View
JRNENTRY	Journal Entry	Long Integer	4	View
BUDGETID	Budget ID	String	16	View
REFRENCE	Reference	String	32	View
TRXDATE	TRX Date	Date	4	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
SOURCDOC	Source Document 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo	String	12	View
TRXSORCE	TRX Source	String	14	View
ERRSTATE	Error State	Long Integer	4	View
GLHDRVAL	GL Header Valid	Long Integer	4	View
GLHDRMSG	GL HDR Messages	Long Integer	4	View
GLHDRMS2	GL HDR Messages2	Long Integer	4	View
NOTEINDX	Note Index	Currency	10	View