SOP40200 - Sales Type ID Setup | Prospr - Dynamics GP Table Reference

SOP40200 - Sales Type ID Setup

Query Builder

Select * from SOP40200

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
DOCID	Document ID	String	16	View
NOTEINDX	Note Index	Currency	10	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
SETUPKEY	Setup Key	Integer	2	View
DOCTYABR	Document Type Abbreviation	String	4	View
SOPNUMBE	SOP Number	String	22	View
COMMNTID	Comment ID	String	16	View
DOCUFORM	Document Format	Integer	2	View
DAYTOEXP	Days To Expire	Integer	2	View
ALLREPEA	Allow Repeating	Boolean	2	View
ALLOCABY	Allocate By	Integer	2	View
USEPROSP	Use Prospects	Boolean	2	View
USNXTINV	Use Next Invoice	Boolean	2	View
USPFULPR	Use Separate Fulfillment Process	Boolean	2	View
QUOTOINV	Transfer Quote To Invoice	Boolean	2	View
QUOTOORD	Transfer Quote To Order	Boolean	2	View
INVTOBAC	Transfer Invoice To Back Order	Boolean	2	View
BACTOINV	Transfer Back Order To Invoice	Boolean	2	View
BACTOORD	Transfer Back Order To Order	Boolean	2	View
ORDTOBAC	Transfer Order To Back Order	Boolean	2	View
ORDTOORD	Transfer Order To Order	Boolean	2	View
USDOCID1	Use Document ID 1	String	16	View
USDOCID2	Use Document ID 2	String	16	View
QTYDEFAU	QTY Default	Integer	2	View
SOPALLOW_1	SOP Allow[1]	Boolean	2	View
SOPALLOW_2	SOP Allow[2]	Boolean	2	View
SOPALLOW_3	SOP Allow[3]	Boolean	2	View
SOPALLOW_4	SOP Allow[4]	Boolean	2	View
SOPALLOW_5	SOP Allow[5]	Boolean	2	View
SOPALLOW_6	SOP Allow[6]	Boolean	2	View
SOPALLOW_7	SOP Allow[7]	Boolean	2	View
SOPALLOW_8	SOP Allow[8]	Boolean	2	View
SOPALLOW_9	SOP Allow[9]	Boolean	2	View
SOPALLOW_10	SOP Allow[10]	Boolean	2	View
SOPPSSWD_1	SOP Password[1]	String	12	View
SOPPSSWD_2	SOP Password[2]	String	12	View
SOPPSSWD_3	SOP Password[3]	String	12	View
SOPPSSWD_4	SOP Password[4]	String	12	View
SOPPSSWD_5	SOP Password[5]	String	12	View
SOPPSSWD_6	SOP Password[6]	String	12	View
SOPPSSWD_7	SOP Password[7]	String	12	View
SOPPSSWD_8	SOP Password[8]	String	12	View
SOPPSSWD_9	SOP Password[9]	String	12	View
SOPPSSWD_10	SOP Password[10]	String	12	View
SOPSEQNC_1	SOP Sequence[1]	Integer	2	View
SOPSEQNC_2	SOP Sequence[2]	Integer	2	View
SOPSEQNC_3	SOP Sequence[3]	Integer	2	View
SOPSEQNC_4	SOP Sequence[4]	Integer	2	View
SOPSEQNC_5	SOP Sequence[5]	Integer	2	View
SOPSEQNC_6	SOP Sequence[6]	Integer	2	View
SOPSEQNC_7	SOP Sequence[7]	Integer	2	View
SOPSEQNC_8	SOP Sequence[8]	Integer	2	View
USER2ENT	User To Enter	String	16	View
CREATDDT	Created Date	Date	4	View
MODIFDT	Modified Date	Date	4	View
SHPPGDOC	Shipping Document	Boolean	2	View
CORRCTN	Correction	Boolean	2	View
SIMPLIFD	Simplified	Boolean	2	View
ALLBACKODPRT	Allow Backorder Printing	Boolean	2	View
XORDINVC	Transfer Order To Invoice	Boolean	2	View
USDOCID3	Use Document ID 3	String	16	View
WORKFLOWENABLED	Workflow Enabled	Boolean	2	View
UPDTONPRINT	Update Invoice Date on First Print	Boolean	2	View
CREDITLIMITHOLDID	Credit Limit Hold ID	String	16	View
UPDTACTUALSHPDT	Update Actual Ship Date	Boolean	2	View
WORKFLOWHOLDID	Workflow Advancement Hold ID	String	16	View
OVERRIDEIVCBILLQTY	Override Invoice/Billed QTY	Boolean	2	View
ENABLEBACKORDER	Enable Back Order	Boolean	2	View
ENABLECANCELED	Enable Canceled	Boolean	2	View
SOPSTATUSACTIVE_1	SOP Status Active[1]	Boolean	2	View
SOPSTATUSACTIVE_2	SOP Status Active[2]	Boolean	2	View
SOPSTATUSACTIVE_3	SOP Status Active[3]	Boolean	2	View
SOPSTATUSACTIVE_4	SOP Status Active[4]	Boolean	2	View
SOPSTATUSACTIVE_5	SOP Status Active[5]	Boolean	2	View
SOPSTATUSACTIVE_6	SOP Status Active[6]	Boolean	2	View
SOPSTATUSACTIVE_7	SOP Status Active[7]	Boolean	2	View
SOPSTATUSACTIVE_8	SOP Status Active[8]	Boolean	2	View
SOPSTATUSACTIVE_9	SOP Status Active[9]	Boolean	2	View

SOP40200 - Sales Type ID Setup

Query Builder

Customer Service

Information

My Account

Contact Us