SOP40100 - Sales Setup | Prospr - Dynamics GP Table Reference

SOP40100 - Sales Setup

Query Builder

Select * from SOP40100

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
COMMNTID	Comment ID	String	16	View
SETUPKEY	Setup Key	Integer	2	View
DPYITMCS	Display Item Unit Cost	Boolean	2	View
DQTYSWAR	Display Quantity Distribution Warning	Boolean	2	View
TRKVDTRX	Track Voided Trx In History	Boolean	2	View
CALCKITC	Calculate Kit Price Based On Component Cost	Boolean	2	View
NEWRATES	Search for New Rates During Transfer	Boolean	2	View
TRMSTNUM	Track Master Numbers	Boolean	2	View
NXTMSTNO	Next Master Number	Long Integer	4	View
QUOTE	Quote	Boolean	2	View
PRDER	Order	Boolean	2	View
INVORETU	Invoice/Return	Boolean	2	View
ACDSTRBN	Account Distributions	Boolean	2	View
LOCNCODE	Location Code	String	12	View
CHEKBKID	Checkbook ID	String	16	View
DFQTYSOP	Default Quantity Shortage Options	Integer	2	View
QUODOCID	Quote Document ID	String	16	View
ORDDOCID	Order Document ID	String	16	View
BACDOCID	Back Order Document ID	String	16	View
INVDOCID	Invoice Document ID	String	16	View
RETDOCID	Return Document ID	String	16	View
DECPLQTY	Decimal Places QTYS	Integer	2	View
DECPLCUR	Decimal Places Currency	Integer	2	View
USEACFRM	Use Posting Accounts From	Integer	2	View
USEADVTX	Use Advanced Taxes	Integer	2	View
TAXSCHID	Tax Schedule ID	String	16	View
NONIVTXB	Non IV Taxable	Integer	2	View
NONIVSCH	Non IV Item Schedule ID	String	16	View
FRGTTXBL	Freight Taxable 1 = Taxable 2 = Nontaxable 3 = Base on customers	Integer	2	View
FRTSCHID	Freight Schedule ID	String	16	View
MISCTXBL	Misc Taxable 1 = Taxable 2 = Nontaxable 3 = Base on customers	Integer	2	View
MSCSCHID	Misc Schedule ID	String	16	View
MPACKSLP	Match Packing Slip	Integer	2	View
MPICKTIC	Match Picking Ticket	Integer	2	View
PriceLevelWarning	PriceLevelWarning	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
IVCDSTCK	IVC Dist Check	Long Integer	4	View
NUMOFTRX	Number Of TRX	Long Integer	4	View
USRDFPR1	User Defined Prompt 1	String	16	View
USRDRPR2	User Defined Prompt 2	String	16	View
USRDRPR3	User Defined Prompt 3	String	16	View
USRDRPR4	User Defined Prompt 4	String	16	View
USRDRPR5	User Defined Prompt 5	String	16	View
USRDRPR6	User Defined Prompt 6	String	16	View
USRDRPR7	User Defined Prompt 7	String	16	View
USRDRPR8	User Defined Prompt 8	String	16	View
USRDRPR9	User Defined Prompt 9	String	16	View
USRDRP10	User Defined Prompt 10	String	16	View
USRDRP11	User Defined Prompt 11	String	16	View
USRDRP12	User Defined Prompt 12	String	16	View
USRDFPR13	User Defined Prompt 13	String	16	View
USRDFPR14	User Defined Prompt 14	String	16	View
USRDFPR15	User Defined Prompt 15	String	16	View
USRDFPR16	User Defined Prompt 16	String	16	View
USRDFPR17	User Defined Prompt 17	String	16	View
CREATDDT	Created Date	Date	4	View
MODIFDT	Modified Date	Date	4	View
REQSHIP	Requested Date for PO	Integer	2	View
REQDAYS	Requested Days After	Integer	2	View
SITEPREF	Site Preference	Integer	2	View
PREFSITE	Preferred Site	String	12	View
REQDATEPO	Required Date for PO	Integer	2	View
Required_Days	Required Days	Integer	2	View
UMDEFAULT	U of M Selection	Integer	2	View
COMBONPO	Combine On PO Line	Boolean	2	View
TXBASECS	Tax Base on Customers	Boolean	2	View
USEORGUC	Use Original Unit Cost	Boolean	2	View
Prices_Not_Required_In_Pr	Prices Not Required In Price List	Boolean	2	View
PasswordUpper	Password Upper	String	12	View
Convert_Functional_Price	Convert Functional Price	Boolean	2	View
INDVPICKTICKETSORT	Individual Picking Ticket Sort	Integer	2	View
PRINTAVAILABLEBINS	Print Available Bins	Integer	2	View
FODOCID	Fulfillment Order Document ID	String	16	View
CombineDropshipSOLines	Combine Dropship SO Lines	Boolean	2	View
CombineDropshipSODocs	Combine Dropship SO Documents	Boolean	2	View

SOP40100 - Sales Setup

Query Builder

Customer Service

Information

My Account

Contact Us