Sales Setup (SOP40100)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SOP40100

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Sales Setup
Physical Name: SOP40100
Technical Name: SOP_SETP

Group Display Name: Sales Setup
Group Technical Name: Sales Setup

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	COMMNTID	Comment ID	STR15_Comment_ID	String	15
	Key to the Comment Master (SY04200). Click to show/hide SELECT ['Sales Setup'].COMMNTID AS 'Sales Setup-Comment ID' ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID' FROM SOP40100 AS ['Sales Setup'] INNER JOIN SY04200 AS ['Comment Master'] ON ['Sales Setup'].COMMNTID = ['Comment Master'].COMMNTID
2	SETUPKEY	Setup Key	INT	Integer	0
3	DPYITMCS	Display Item Unit Cost	CB_Display_Item_Unit_Cost	Boolean	0
4	DQTYSWAR	Display Quantity Distribution Warning	CB_Display_Quantity_Distribution_Warning	Boolean	0
5	TRKVDTRX	Track Voided Trx In History	CB_Track_Voided_Trx_In_History	Boolean	0
6	CALCKITC	Calculate Kit Price Based On Component Cost	CB_Calculate_Kit_Price_Based_On_Component_Cost	Boolean	0
7	NEWRATES	Search for New Rates During Transfer	CB_Pull_New_Exchange_Rates	Boolean	0
8	TRMSTNUM	Track Master Numbers	CB_Track_Master_Numbers	Boolean	0
9	NXTMSTNO	Next Master Number	LI_MasterNumber	Long Integer	9
10	QUOTE	Quote	CB_Quote	Boolean	0
11	PRDER	Order	CB_Order	Boolean	0
12	INVORETU	Invoice/Return	CB_Invoice/Return	Boolean	0
13	ACDSTRBN	Account Distributions	CB_Account_Distributions	Boolean	0
14	LOCNCODE	Location Code	STR10_Location_Code	String	10
	Key to the Site Setup (IV40700). Click to show/hide SELECT ['Sales Setup'].LOCNCODE AS 'Sales Setup-Location Code' ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code' FROM SOP40100 AS ['Sales Setup'] INNER JOIN IV40700 AS ['Site Setup'] ON ['Sales Setup'].LOCNCODE = ['Site Setup'].LOCNCODE
15	CHEKBKID	Checkbook ID	STR15_Checkbook_ID	String	15
	Key to the CM Checkbook Master (CM00100). Click to show/hide SELECT ['Sales Setup'].CHEKBKID AS 'Sales Setup-Checkbook ID' ,['CM Checkbook Master'].CHEKBKID AS 'CM Checkbook Master-Checkbook ID' FROM SOP40100 AS ['Sales Setup'] INNER JOIN CM00100 AS ['CM Checkbook Master'] ON ['Sales Setup'].CHEKBKID = ['CM Checkbook Master'].CHEKBKID
16	DFQTYSOP	Default Quantity Shortage Options	DDL_Quantity_Shortage_Options	Integer	0
17	QUODOCID	Quote Document ID	STR15_LBAU	String	15
18	ORDDOCID	Order Document ID	STR15_LBAU	String	15
19	BACDOCID	Back Order Document ID	STR15_LBAU	String	15
20	INVDOCID	Invoice Document ID	STR15_LBAU	String	15
21	RETDOCID	Return Document ID	STR15_LBAU	String	15
22	DECPLQTY	Decimal Places QTYS	DDL_Decimal_Places_QTYS	Integer	0
23	DECPLCUR	Decimal Places Currency	DDL_Decimal_Places_Dollars	Integer	0
24	USEACFRM	Use Posting Accounts From	GB	Integer	0
25	USEADVTX	Use Advanced Taxes	GB	Integer	0
26	TAXSCHID	Tax Schedule ID	STR15_Tax_Schedule_ID	String	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Sales Setup'].TAXSCHID AS 'Sales Setup-Tax Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM SOP40100 AS ['Sales Setup'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Sales Setup'].TAXSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
27	NONIVTXB	Non IV Taxable	DDL_Tax_Options	Integer	0
28	NONIVSCH	Non IV Item Schedule ID	STR15_Tax_Schedule_ID	String	15
29	FRGTTXBL	Freight Taxable	DDL_Tax_Options	Integer	0
30	FRTSCHID	Freight Schedule ID	STR15_LBAU	String	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Sales Setup'].FRTSCHID AS 'Sales Setup-Freight Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM SOP40100 AS ['Sales Setup'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Sales Setup'].FRTSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
31	MISCTXBL	Misc Taxable	DDL_Tax_Options	Integer	0
32	MSCSCHID	Misc Schedule ID	STR15_LBAU	String	15
	Key to the Sales/Purchases Tax Schedule Header Master (TX00101). Click to show/hide SELECT ['Sales Setup'].MSCSCHID AS 'Sales Setup-Misc Schedule ID' ,['Sales/Purchases Tax Schedule Header Master'].TAXSCHID AS 'Sales/Purchases Tax Schedule Header Master-Tax Schedule ID' FROM SOP40100 AS ['Sales Setup'] INNER JOIN TX00101 AS ['Sales/Purchases Tax Schedule Header Master'] ON ['Sales Setup'].MSCSCHID = ['Sales/Purchases Tax Schedule Header Master'].TAXSCHID
33	MPACKSLP	Match Packing Slip	DDL_Match_Packing_Slip	Integer	0
34	MPICKTIC	Match Picking Ticket	DDL_Match_Picking_Ticket	Integer	0
35	PriceLevelWarning	PriceLevelWarning	PriceLevelWarning	Integer	0
36	SOPALLOW	SOP Allow	CB	Boolean	0
37	SOPALLOW_1	SOP Allow[1]	CB	Boolean	0
38	SOPALLOW_2	SOP Allow[2]	CB	Boolean	0
39	SOPALLOW_3	SOP Allow[3]	CB	Boolean	0
40	SOPALLOW_4	SOP Allow[4]	CB	Boolean	0
41	SOPALLOW_5	SOP Allow[5]	CB	Boolean	0
42	SOPALLOW_6	SOP Allow[6]	CB	Boolean	0
43	SOPALLOW_7	SOP Allow[7]	CB	Boolean	0
44	SOPALLOW_8	SOP Allow[8]	CB	Boolean	0
45	SOPALLOW_9	SOP Allow[9]	CB	Boolean	0
46	SOPALLOW_10	SOP Allow[10]	CB	Boolean	0
47	SOPPSSWD	SOP Password	Password	String	10
48	SOPPSSWD_1	SOP Password[1]	Password	String	10
49	SOPPSSWD_2	SOP Password[2]	Password	String	10
50	SOPPSSWD_3	SOP Password[3]	Password	String	10
51	SOPPSSWD_4	SOP Password[4]	Password	String	10
52	SOPPSSWD_5	SOP Password[5]	Password	String	10
53	SOPPSSWD_6	SOP Password[6]	Password	String	10
54	SOPPSSWD_7	SOP Password[7]	Password	String	10
55	SOPPSSWD_8	SOP Password[8]	Password	String	10
56	SOPPSSWD_9	SOP Password[9]	Password	String	10
57	SOPPSSWD_10	SOP Password[10]	Password	String	10
58	IVCDSTCK	IVC Dist Check	ML_IVC_Dist_Check	Long Integer	0
59	NUMOFTRX	Number Of TRX	LI6_U0	Long Integer	6
60	USRDFPR1	User Defined Prompt 1	STR15	String	15
61	USRDRPR2	User Defined Prompt 2	STR15	String	15
62	USRDRPR3	User Defined Prompt 3	STR15	String	15
63	USRDRPR4	User Defined Prompt 4	STR15	String	15
64	USRDRPR5	User Defined Prompt 5	STR15	String	15
65	USRDRPR6	User Defined Prompt 6	STR15	String	15
66	USRDRPR7	User Defined Prompt 7	STR15	String	15
67	USRDRPR8	User Defined Prompt 8	STR15	String	15
68	USRDRPR9	User Defined Prompt 9	STR15	String	15
69	USRDRP10	User Defined Prompt 10	STR15	String	15
70	USRDRP11	User Defined Prompt 11	STR15	String	15
71	USRDRP12	User Defined Prompt 12	STR15	String	15
72	USRDFPR13	User Defined Prompt 13	STR15	String	15
73	USRDFPR14	User Defined Prompt 14	STR15	String	15
74	USRDFPR15	User Defined Prompt 15	STR15	String	15
75	USRDFPR16	User Defined Prompt 16	STR15	String	15
76	USRDFPR17	User Defined Prompt 17	STR15	String	15
77	CREATDDT	Created Date	DT	Date	8
78	MODIFDT	Modified Date	DT	Date	8
79	REQSHIP	Requested Date for PO	DDL_ReqShipDate	Integer	0
80	REQDAYS	Requested Days After	INT3_RB0_U	Integer	3
81	SITEPREF	Site Preference	DDL_SitePref	Integer	0
82	PREFSITE	Preferred Site	STR10_Location_Code	String	10
83	REQDATEPO	Required Date for PO	DDL_ReqDatePO	Integer	0
84	Required_Days	Required Days	INT3_RB0_U	Integer	3
85	UMDEFAULT	U of M Selection	DDL_UofMSelection	Integer	0
86	COMBONPO	Combine On PO Line	CB_CombineOnPO	Boolean	0
87	TXBASECS	Tax Base on Customers	CB_Tax_Base_On_Customers	Boolean	0
88	USEORGUC	Use Original Unit Cost	CB_Use_Original_Unit_Cost	Boolean	0
89	Prices_Not_Required_In_Pr	Prices Not Required In Price List	CB_Prices_Not_Required_In_Price_List	Boolean	0
90	PasswordUpper	Password Upper	Password	String	10
91	Convert_Functional_Price	Convert Functional Price	CB_Convert_Functional_Price	Boolean	0
92	INDVPICKTICKETSORT	Individual Picking Ticket Sort	DDL_IndividualPickTicketSort	Integer	0
93	PRINTAVAILABLEBINS	Print Available Bins	DDL_PrintAvailableBins	Integer	0
94	FODOCID	Fulfillment Order Document ID	STR15_LBAU	String	15
95	CombineDropshipSOLines	Combine Dropship SO Lines	CB_CombineDropshipSOLines	Boolean	0
96	CombineDropshipSODocs	Combine Dropship SO Documents	CB_CombineDropshipSODocuments	Boolean	0
97	DEX_ROW_ID		int	int	10
	DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

azurecurve Products Microsoft Dynamics GP (0)SalesSales Setup (SOP40100)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply