Sales 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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1DOCID SearchDocument IDSTR15_LBAUString1615
2NOTEINDX SearchNote IndexDLR14Currency1014
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
3SOPTYPE SearchSOP TypeDDL_SOP_TypeInteger20
4SETUPKEY SearchSetup KeyINTInteger20
5DOCTYABR SearchDocument Type AbbreviationSTR3String43
6SOPNUMBE SearchSOP NumberSTR20_SOP_NumberString2217
7COMMNTID SearchComment IDSTR15_Comment_IDString1615
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
8DOCUFORM SearchDocument FormatDDL_SOP_Document_FormatsInteger20
9DAYTOEXP SearchDays To ExpireINT4_Days_To_ExpireInteger24
10ALLREPEA SearchAllow RepeatingCB_Allow_Repeating_DocumentsBoolean20
11ALLOCABY SearchAllocate ByDDL_Allocate_ByInteger20
12USEPROSP SearchUse ProspectsCB_Use_ProspectsBoolean20
13USNXTINV SearchUse Next InvoiceCBBoolean20
14USPFULPR SearchUse Separate Fulfillment ProcessCB_Use_Separate_Fulfillment_ProcessBoolean20
15QUOTOINV SearchTransfer Quote To InvoiceCBBoolean20
16QUOTOORD SearchTransfer Quote To OrderCB_Transfer_Quote_To_OrderBoolean20
17INVTOBAC SearchTransfer Invoice To Back OrderCBBoolean20
18BACTOINV SearchTransfer Back Order To InvoiceCBBoolean20
19BACTOORD SearchTransfer Back Order To OrderCB_Transfer_Back_Order_To_OrderBoolean20
20ORDTOBAC SearchTransfer Order To Back OrderCB_Transfer_Order_To_Back_OrderBoolean20
21ORDTOORD SearchTransfer Order To OrderCB_Transfer_Order_To_OrderBoolean20
22USDOCID1 SearchUse Document ID 1STR15_LBAUString1615
23USDOCID2 SearchUse Document ID 2STR15_LBAUString1615
24QTYDEFAU SearchQTY DefaultDDL_QTY_DefaultInteger20
25SOPALLOW SearchSOP AllowCBBoolean20
26SOPALLOW_1 SearchSOP Allow[1]CBBoolean20
27SOPALLOW_2 SearchSOP Allow[2]CBBoolean20
28SOPALLOW_3 SearchSOP Allow[3]CBBoolean20
29SOPALLOW_4 SearchSOP Allow[4]CBBoolean20
30SOPALLOW_5 SearchSOP Allow[5]CBBoolean20
31SOPALLOW_6 SearchSOP Allow[6]CBBoolean20
32SOPALLOW_7 SearchSOP Allow[7]CBBoolean20
33SOPALLOW_8 SearchSOP Allow[8]CBBoolean20
34SOPALLOW_9 SearchSOP Allow[9]CBBoolean20
35SOPALLOW_10 SearchSOP Allow[10]CBBoolean20
36SOPPSSWD SearchSOP PasswordPasswordString1210
37SOPPSSWD_1 SearchSOP Password[1]PasswordString1210
38SOPPSSWD_2 SearchSOP Password[2]PasswordString1210
39SOPPSSWD_3 SearchSOP Password[3]PasswordString1210
40SOPPSSWD_4 SearchSOP Password[4]PasswordString1210
41SOPPSSWD_5 SearchSOP Password[5]PasswordString1210
42SOPPSSWD_6 SearchSOP Password[6]PasswordString1210
43SOPPSSWD_7 SearchSOP Password[7]PasswordString1210
44SOPPSSWD_8 SearchSOP Password[8]PasswordString1210
45SOPPSSWD_9 SearchSOP Password[9]PasswordString1210
46SOPPSSWD_10 SearchSOP Password[10]PasswordString1210
47SOPSEQNC SearchSOP SequenceINT4Integer24
48SOPSEQNC_1 SearchSOP Sequence[1]INT4Integer24
49SOPSEQNC_2 SearchSOP Sequence[2]INT4Integer24
50SOPSEQNC_3 SearchSOP Sequence[3]INT4Integer24
51SOPSEQNC_4 SearchSOP Sequence[4]INT4Integer24
52SOPSEQNC_5 SearchSOP Sequence[5]INT4Integer24
53SOPSEQNC_6 SearchSOP Sequence[6]INT4Integer24
54SOPSEQNC_7 SearchSOP Sequence[7]INT4Integer24
55SOPSEQNC_8 SearchSOP Sequence[8]INT4Integer24
56USER2ENT SearchUser To EnterSTR15_User_IDString1615
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
57CREATDDT SearchCreated DateDTDate48
58MODIFDT SearchModified DateDTDate48
59SHPPGDOC SearchShipping DocumentCB_Shipping_DocumentBoolean20
60CORRCTN SearchCorrectionCB_CorrectionBoolean20
61SIMPLIFD SearchSimplifiedCB_SimplifiedBoolean20
62ALLBACKODPRT SearchAllow Backorder PrintingCB_Allow_Backorder_PrintingBoolean20
63XORDINVC SearchTransfer Order To InvoiceCBBoolean20
64USDOCID3 SearchUse Document ID 3STR15_LBAUString1615
65WORKFLOWENABLED SearchWorkflow EnabledCB_WorkflowEnabledBoolean20
66UPDTONPRINT SearchUpdate Invoice Date on First PrintCB_UpdateInvoiceDtBoolean20
67CREDITLIMITHOLDID SearchCredit Limit Hold IDSTR15_LBAUString1615
68UPDTACTUALSHPDT SearchUpdate Actual Ship DateCB_UpdateActualShipDateBoolean20
69WORKFLOWHOLDID SearchWorkflow Advancement Hold IDSTR15_LBAUString1615
70OVERRIDEIVCBILLQTY SearchOverride Invoice/Billed QTYCBBoolean20
71ENABLEBACKORDER SearchEnable Back OrderCB_EnableBackOrderBoolean20
72ENABLECANCELED SearchEnable CanceledCB_EnableCanceledBoolean20
73SOPSTATUSACTIVE SearchSOP Status ActiveCBBoolean20
74SOPSTATUSACTIVE_1 SearchSOP Status Active[1]CBBoolean20
75SOPSTATUSACTIVE_2 SearchSOP Status Active[2]CBBoolean20
76SOPSTATUSACTIVE_3 SearchSOP Status Active[3]CBBoolean20
77SOPSTATUSACTIVE_4 SearchSOP Status Active[4]CBBoolean20
78SOPSTATUSACTIVE_5 SearchSOP Status Active[5]CBBoolean20
79SOPSTATUSACTIVE_6 SearchSOP Status Active[6]CBBoolean20
80SOPSTATUSACTIVE_7 SearchSOP Status Active[7]CBBoolean20
81SOPSTATUSACTIVE_8 SearchSOP Status Active[8]CBBoolean20
82SOPSTATUSACTIVE_9 SearchSOP Status Active[9]CBBoolean20
83DEX_ROW_ID Searchintint1010

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.

Leave a Reply

Your email address will not be published. Required fields are marked *