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 TypeLength
1DOCID SearchDocument IDStringSTR15_LBAU15
2NOTEINDX SearchNote IndexCurrencyDLR1414
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 TypeIntegerDDL_SOP_Type0
4SETUPKEY SearchSetup KeyIntegerINT0
5DOCTYABR SearchDocument Type AbbreviationStringSTR33
6SOPNUMBE SearchSOP NumberStringSTR20_SOP_Number17
7COMMNTID SearchComment IDStringSTR15_Comment_ID15
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 FormatIntegerDDL_SOP_Document_Formats0
9DAYTOEXP SearchDays To ExpireIntegerINT4_Days_To_Expire4
10ALLREPEA SearchAllow RepeatingBooleanCB_Allow_Repeating_Documents0
11ALLOCABY SearchAllocate ByIntegerDDL_Allocate_By0
12USEPROSP SearchUse ProspectsBooleanCB_Use_Prospects0
13USNXTINV SearchUse Next InvoiceBooleanCB0
14USPFULPR SearchUse Separate Fulfillment ProcessBooleanCB_Use_Separate_Fulfillment_Process0
15QUOTOINV SearchTransfer Quote To InvoiceBooleanCB0
16QUOTOORD SearchTransfer Quote To OrderBooleanCB_Transfer_Quote_To_Order0
17INVTOBAC SearchTransfer Invoice To Back OrderBooleanCB0
18BACTOINV SearchTransfer Back Order To InvoiceBooleanCB0
19BACTOORD SearchTransfer Back Order To OrderBooleanCB_Transfer_Back_Order_To_Order0
20ORDTOBAC SearchTransfer Order To Back OrderBooleanCB_Transfer_Order_To_Back_Order0
21ORDTOORD SearchTransfer Order To OrderBooleanCB_Transfer_Order_To_Order0
22USDOCID1 SearchUse Document ID 1StringSTR15_LBAU15
23USDOCID2 SearchUse Document ID 2StringSTR15_LBAU15
24QTYDEFAU SearchQTY DefaultIntegerDDL_QTY_Default0
25SOPALLOW_1 SearchSOP Allow[1]BooleanCB0
26SOPALLOW SearchSOP AllowCBBoolean0
27SOPALLOW_2 SearchSOP Allow[2]BooleanCB0
28SOPALLOW_3 SearchSOP Allow[3]BooleanCB0
29SOPALLOW_4 SearchSOP Allow[4]BooleanCB0
30SOPALLOW_5 SearchSOP Allow[5]BooleanCB0
31SOPALLOW_6 SearchSOP Allow[6]BooleanCB0
32SOPALLOW_7 SearchSOP Allow[7]BooleanCB0
33SOPALLOW_8 SearchSOP Allow[8]BooleanCB0
34SOPALLOW_9 SearchSOP Allow[9]BooleanCB0
35SOPALLOW_10 SearchSOP Allow[10]BooleanCB0
36SOPPSSWD_1 SearchSOP Password[1]StringPassword10
37SOPPSSWD SearchSOP PasswordPasswordString10
38SOPPSSWD_2 SearchSOP Password[2]StringPassword10
39SOPPSSWD_3 SearchSOP Password[3]StringPassword10
40SOPPSSWD_4 SearchSOP Password[4]StringPassword10
41SOPPSSWD_5 SearchSOP Password[5]StringPassword10
42SOPPSSWD_6 SearchSOP Password[6]StringPassword10
43SOPPSSWD_7 SearchSOP Password[7]StringPassword10
44SOPPSSWD_8 SearchSOP Password[8]StringPassword10
45SOPPSSWD_9 SearchSOP Password[9]StringPassword10
46SOPPSSWD_10 SearchSOP Password[10]StringPassword10
47SOPSEQNC_1 SearchSOP Sequence[1]IntegerINT44
48SOPSEQNC_2 SearchSOP Sequence[2]IntegerINT44
49SOPSEQNC SearchSOP SequenceINT4Integer4
50SOPSEQNC_3 SearchSOP Sequence[3]IntegerINT44
51SOPSEQNC_4 SearchSOP Sequence[4]IntegerINT44
52SOPSEQNC_5 SearchSOP Sequence[5]IntegerINT44
53SOPSEQNC_6 SearchSOP Sequence[6]IntegerINT44
54SOPSEQNC_7 SearchSOP Sequence[7]IntegerINT44
55SOPSEQNC_8 SearchSOP Sequence[8]IntegerINT44
56USER2ENT SearchUser To EnterStringSTR15_User_ID15
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 DateDateDT8
58MODIFDT SearchModified DateDateDT8
59SHPPGDOC SearchShipping DocumentBooleanCB_Shipping_Document0
60CORRCTN SearchCorrectionBooleanCB_Correction0
61SIMPLIFD SearchSimplifiedBooleanCB_Simplified0
62ALLBACKODPRT SearchAllow Backorder PrintingBooleanCB_Allow_Backorder_Printing0
63XORDINVC SearchTransfer Order To InvoiceBooleanCB0
64USDOCID3 SearchUse Document ID 3StringSTR15_LBAU15
65WORKFLOWENABLED SearchWorkflow EnabledBooleanCB_WorkflowEnabled0
66UPDTONPRINT SearchUpdate Invoice Date on First PrintBooleanCB_UpdateInvoiceDt0
67CREDITLIMITHOLDID SearchCredit Limit Hold IDStringSTR15_LBAU15
68UPDTACTUALSHPDT SearchUpdate Actual Ship DateBooleanCB_UpdateActualShipDate0
69WORKFLOWHOLDID SearchWorkflow Advancement Hold IDStringSTR15_LBAU15
70OVERRIDEIVCBILLQTY SearchOverride Invoice/Billed QTYBooleanCB0
71ENABLEBACKORDER SearchEnable Back OrderBooleanCB_EnableBackOrder0
72ENABLECANCELED SearchEnable CanceledBooleanCB_EnableCanceled0
73SOPSTATUSACTIVE_1 SearchSOP Status Active[1]BooleanCB0
74SOPSTATUSACTIVE_2 SearchSOP Status Active[2]BooleanCB0
75SOPSTATUSACTIVE_3 SearchSOP Status Active[3]BooleanCB0
76SOPSTATUSACTIVE_4 SearchSOP Status Active[4]BooleanCB0
77SOPSTATUSACTIVE SearchSOP Status ActiveCBBoolean0
78SOPSTATUSACTIVE_5 SearchSOP Status Active[5]BooleanCB0
79SOPSTATUSACTIVE_6 SearchSOP Status Active[6]BooleanCB0
80SOPSTATUSACTIVE_7 SearchSOP Status Active[7]BooleanCB0
81SOPSTATUSACTIVE_8 SearchSOP Status Active[8]BooleanCB0
82SOPSTATUSACTIVE_9 SearchSOP Status Active[9]BooleanCB0

Leave a Reply

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