Sales Type ID Setup (SOP40200)

azurecurve Products Microsoft Dynamics GP (0)SalesSales Type ID Setup (SOP40200)

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

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Sales Type ID Setup
Physical Name: SOP40200
Technical Name: SOP_ID_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	DOCID	Document ID	String	STR15_LBAU	15
2	NOTEINDX	Note Index	Currency	DLR14	14
	Key to the Record Notes Master (SY03900). Click to show/hide SELECT ['Sales Type ID Setup'].NOTEINDX AS 'Sales Type ID Setup-Note Index' ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index' FROM SOP40200 AS ['Sales Type ID Setup'] INNER JOIN SY03900 AS ['Record Notes Master'] ON ['Sales Type ID Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX
3	SOPTYPE	SOP Type	Integer	DDL_SOP_Type	0
4	SETUPKEY	Setup Key	Integer	INT	0
5	DOCTYABR	Document Type Abbreviation	String	STR3	3
6	SOPNUMBE	SOP Number	String	STR20_SOP_Number	17
7	COMMNTID	Comment ID	String	STR15_Comment_ID	15
	Key to the Comment Master (SY04200). Click to show/hide SELECT ['Sales Type ID Setup'].COMMNTID AS 'Sales Type ID Setup-Comment ID' ,['Comment Master'].COMMNTID AS 'Comment Master-Comment ID' FROM SOP40200 AS ['Sales Type ID Setup'] INNER JOIN SY04200 AS ['Comment Master'] ON ['Sales Type ID Setup'].COMMNTID = ['Comment Master'].COMMNTID
8	DOCUFORM	Document Format	Integer	DDL_SOP_Document_Formats	0
9	DAYTOEXP	Days To Expire	Integer	INT4_Days_To_Expire	4
10	ALLREPEA	Allow Repeating	Boolean	CB_Allow_Repeating_Documents	0
11	ALLOCABY	Allocate By	Integer	DDL_Allocate_By	0
12	USEPROSP	Use Prospects	Boolean	CB_Use_Prospects	0
13	USNXTINV	Use Next Invoice	Boolean	CB	0
14	USPFULPR	Use Separate Fulfillment Process	Boolean	CB_Use_Separate_Fulfillment_Process	0
15	QUOTOINV	Transfer Quote To Invoice	Boolean	CB	0
16	QUOTOORD	Transfer Quote To Order	Boolean	CB_Transfer_Quote_To_Order	0
17	INVTOBAC	Transfer Invoice To Back Order	Boolean	CB	0
18	BACTOINV	Transfer Back Order To Invoice	Boolean	CB	0
19	BACTOORD	Transfer Back Order To Order	Boolean	CB_Transfer_Back_Order_To_Order	0
20	ORDTOBAC	Transfer Order To Back Order	Boolean	CB_Transfer_Order_To_Back_Order	0
21	ORDTOORD	Transfer Order To Order	Boolean	CB_Transfer_Order_To_Order	0
22	USDOCID1	Use Document ID 1	String	STR15_LBAU	15
23	USDOCID2	Use Document ID 2	String	STR15_LBAU	15
24	QTYDEFAU	QTY Default	Integer	DDL_QTY_Default	0
25	SOPALLOW	SOP Allow	CB	Boolean	0
26	SOPALLOW_1	SOP Allow[1]	Boolean	CB	0
27	SOPALLOW_2	SOP Allow[2]	Boolean	CB	0
28	SOPALLOW_3	SOP Allow[3]	Boolean	CB	0
29	SOPALLOW_4	SOP Allow[4]	Boolean	CB	0
30	SOPALLOW_5	SOP Allow[5]	Boolean	CB	0
31	SOPALLOW_6	SOP Allow[6]	Boolean	CB	0
32	SOPALLOW_7	SOP Allow[7]	Boolean	CB	0
33	SOPALLOW_8	SOP Allow[8]	Boolean	CB	0
34	SOPALLOW_9	SOP Allow[9]	Boolean	CB	0
35	SOPALLOW_10	SOP Allow[10]	Boolean	CB	0
36	SOPPSSWD_1	SOP Password[1]	String	Password	10
37	SOPPSSWD_2	SOP Password[2]	String	Password	10
38	SOPPSSWD	SOP Password	Password	String	10
39	SOPPSSWD_3	SOP Password[3]	String	Password	10
40	SOPPSSWD_4	SOP Password[4]	String	Password	10
41	SOPPSSWD_5	SOP Password[5]	String	Password	10
42	SOPPSSWD_6	SOP Password[6]	String	Password	10
43	SOPPSSWD_7	SOP Password[7]	String	Password	10
44	SOPPSSWD_8	SOP Password[8]	String	Password	10
45	SOPPSSWD_9	SOP Password[9]	String	Password	10
46	SOPPSSWD_10	SOP Password[10]	String	Password	10
47	SOPSEQNC_1	SOP Sequence[1]	Integer	INT4	4
48	SOPSEQNC_2	SOP Sequence[2]	Integer	INT4	4
49	SOPSEQNC_3	SOP Sequence[3]	Integer	INT4	4
50	SOPSEQNC	SOP Sequence	INT4	Integer	4
51	SOPSEQNC_4	SOP Sequence[4]	Integer	INT4	4
52	SOPSEQNC_5	SOP Sequence[5]	Integer	INT4	4
53	SOPSEQNC_6	SOP Sequence[6]	Integer	INT4	4
54	SOPSEQNC_7	SOP Sequence[7]	Integer	INT4	4
55	SOPSEQNC_8	SOP Sequence[8]	Integer	INT4	4
56	USER2ENT	User To Enter	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['Sales Type ID Setup'].USER2ENT AS 'Sales Type ID Setup-User To Enter' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SOP40200 AS ['Sales Type ID Setup'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['Sales Type ID Setup'].USER2ENT = ['Users Master'].USERID
57	CREATDDT	Created Date	Date	DT	8
58	MODIFDT	Modified Date	Date	DT	8
59	SHPPGDOC	Shipping Document	Boolean	CB_Shipping_Document	0
60	CORRCTN	Correction	Boolean	CB_Correction	0
61	SIMPLIFD	Simplified	Boolean	CB_Simplified	0
62	ALLBACKODPRT	Allow Backorder Printing	Boolean	CB_Allow_Backorder_Printing	0
63	XORDINVC	Transfer Order To Invoice	Boolean	CB	0
64	USDOCID3	Use Document ID 3	String	STR15_LBAU	15
65	WORKFLOWENABLED	Workflow Enabled	Boolean	CB_WorkflowEnabled	0
66	UPDTONPRINT	Update Invoice Date on First Print	Boolean	CB_UpdateInvoiceDt	0
67	CREDITLIMITHOLDID	Credit Limit Hold ID	String	STR15_LBAU	15
68	UPDTACTUALSHPDT	Update Actual Ship Date	Boolean	CB_UpdateActualShipDate	0
69	WORKFLOWHOLDID	Workflow Advancement Hold ID	String	STR15_LBAU	15
70	OVERRIDEIVCBILLQTY	Override Invoice/Billed QTY	Boolean	CB	0
71	ENABLEBACKORDER	Enable Back Order	Boolean	CB_EnableBackOrder	0
72	ENABLECANCELED	Enable Canceled	Boolean	CB_EnableCanceled	0
73	SOPSTATUSACTIVE_1	SOP Status Active[1]	Boolean	CB	0
74	SOPSTATUSACTIVE_2	SOP Status Active[2]	Boolean	CB	0
75	SOPSTATUSACTIVE_3	SOP Status Active[3]	Boolean	CB	0
76	SOPSTATUSACTIVE_4	SOP Status Active[4]	Boolean	CB	0
77	SOPSTATUSACTIVE	SOP Status Active	CB	Boolean	0
78	SOPSTATUSACTIVE_5	SOP Status Active[5]	Boolean	CB	0
79	SOPSTATUSACTIVE_6	SOP Status Active[6]	Boolean	CB	0
80	SOPSTATUSACTIVE_7	SOP Status Active[7]	Boolean	CB	0
81	SOPSTATUSACTIVE_8	SOP Status Active[8]	Boolean	CB	0
82	SOPSTATUSACTIVE_9	SOP Status Active[9]	Boolean	CB	0

azurecurve Products Microsoft Dynamics GP (0)SalesSales Type ID Setup (SOP40200)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply