CFM30500 - CFM_SOPSQL | Prospr - Dynamics GP Table Reference

CFM30500 - CFM_SOPSQL

Select * from CFM30500

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CUSTNMBR	Customer Number	String	16	View
SOPNUMBE	SOP Number	String	22	View
SOPTYPE	SOP Type 1 = Quote 2 = Order 3 = Invoice 4 = Return 5 = Back Order 6 = Fulfillment Order (In SBF, this value is not available.)	Integer	2	View
DOCDATE	Document Date	Date	4	View
DUEDATE	Due Date	Date	4	View
PYMTRMID	Payment Terms ID	String	22	View
DISGRPER	Discount Grace Period	Integer	2	View
DUEGRPER	Due Date Grace Period	Integer	2	View
Amount	Amount	Currency	10	View
AMNTPAID	Amount Paid	Currency	10	View