SOP30100 - Sales Batch History | Prospr - Dynamics GP Table Reference

SOP30100 - Sales Batch History

Query Builder

Select * from SOP30100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
TRXSORCE	TRX Source	String	14	View
BCHSOURC	Batch Source	String	16	View
BACHNUMB	Batch Number	String	16	View
BCHCOMNT	Batch Comment	String	62	View
CHEKBKID	Checkbook ID	String	16	View
GLPOSTDT	GL Posting Date	Date	4	View
APPROVL	Approval	Boolean	2	View
APPRVLDT	Approval Date	Date	4	View
APRVLUSERID	Approval User ID	String	16	View
BCHTOTAL	Batch Total	Currency	10	View
CNTRLTOT	Control Total	Currency	10	View
NUMOFTRX	Number Of TRX	Long Integer	4	View
CNTRLTRX	Control TRX Count	Long Integer	4	View
REPRNTNT	Reprint NT	Boolean	2	View
USERID	User ID	String	16	View
NOTEINDX	Note Index	Currency	10	View
TRXMISNG	TRX Missing	Boolean	2	View