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 NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1COMMNTID SearchComment IDSTR15_Comment_IDString1615
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
2SETUPKEY SearchSetup KeyINTInteger20
3DPYITMCS SearchDisplay Item Unit CostCB_Display_Item_Unit_CostBoolean20
4DQTYSWAR SearchDisplay Quantity Distribution WarningCB_Display_Quantity_Distribution_WarningBoolean20
5TRKVDTRX SearchTrack Voided Trx In HistoryCB_Track_Voided_Trx_In_HistoryBoolean20
6CALCKITC SearchCalculate Kit Price Based On Component CostCB_Calculate_Kit_Price_Based_On_Component_CostBoolean20
7NEWRATES SearchSearch for New Rates During TransferCB_Pull_New_Exchange_RatesBoolean20
8TRMSTNUM SearchTrack Master NumbersCB_Track_Master_NumbersBoolean20
9NXTMSTNO SearchNext Master NumberLI_MasterNumberLong Integer49
10QUOTE SearchQuoteCB_QuoteBoolean20
11PRDER SearchOrderCB_OrderBoolean20
12INVORETU SearchInvoice/ReturnCB_Invoice/ReturnBoolean20
13ACDSTRBN SearchAccount DistributionsCB_Account_DistributionsBoolean20
14LOCNCODE SearchLocation CodeSTR10_Location_CodeString1210
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
15CHEKBKID SearchCheckbook IDSTR15_Checkbook_IDString1615
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
16DFQTYSOP SearchDefault Quantity Shortage OptionsDDL_Quantity_Shortage_OptionsInteger20
17QUODOCID SearchQuote Document IDSTR15_LBAUString1615
18ORDDOCID SearchOrder Document IDSTR15_LBAUString1615
19BACDOCID SearchBack Order Document IDSTR15_LBAUString1615
20INVDOCID SearchInvoice Document IDSTR15_LBAUString1615
21RETDOCID SearchReturn Document IDSTR15_LBAUString1615
22DECPLQTY SearchDecimal Places QTYSDDL_Decimal_Places_QTYSInteger20
23DECPLCUR SearchDecimal Places CurrencyDDL_Decimal_Places_DollarsInteger20
24USEACFRM SearchUse Posting Accounts FromGBInteger20
25USEADVTX SearchUse Advanced TaxesGBInteger20
26TAXSCHID SearchTax Schedule IDSTR15_Tax_Schedule_IDString1615
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
27NONIVTXB SearchNon IV TaxableDDL_Tax_OptionsInteger20
28NONIVSCH SearchNon IV Item Schedule IDSTR15_Tax_Schedule_IDString1615
29FRGTTXBL SearchFreight TaxableDDL_Tax_OptionsInteger20
30FRTSCHID SearchFreight Schedule IDSTR15_LBAUString1615
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
31MISCTXBL SearchMisc TaxableDDL_Tax_OptionsInteger20
32MSCSCHID SearchMisc Schedule IDSTR15_LBAUString1615
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
33MPACKSLP SearchMatch Packing SlipDDL_Match_Packing_SlipInteger20
34MPICKTIC SearchMatch Picking TicketDDL_Match_Picking_TicketInteger20
35PriceLevelWarning SearchPriceLevelWarningPriceLevelWarningInteger20
36SOPALLOW SearchSOP AllowCBBoolean20
37SOPALLOW_1 SearchSOP Allow[1]CBBoolean20
38SOPALLOW_2 SearchSOP Allow[2]CBBoolean20
39SOPALLOW_3 SearchSOP Allow[3]CBBoolean20
40SOPALLOW_4 SearchSOP Allow[4]CBBoolean20
41SOPALLOW_5 SearchSOP Allow[5]CBBoolean20
42SOPALLOW_6 SearchSOP Allow[6]CBBoolean20
43SOPALLOW_7 SearchSOP Allow[7]CBBoolean20
44SOPALLOW_8 SearchSOP Allow[8]CBBoolean20
45SOPALLOW_9 SearchSOP Allow[9]CBBoolean20
46SOPALLOW_10 SearchSOP Allow[10]CBBoolean20
47SOPPSSWD SearchSOP PasswordPasswordString1210
48SOPPSSWD_1 SearchSOP Password[1]PasswordString1210
49SOPPSSWD_2 SearchSOP Password[2]PasswordString1210
50SOPPSSWD_3 SearchSOP Password[3]PasswordString1210
51SOPPSSWD_4 SearchSOP Password[4]PasswordString1210
52SOPPSSWD_5 SearchSOP Password[5]PasswordString1210
53SOPPSSWD_6 SearchSOP Password[6]PasswordString1210
54SOPPSSWD_7 SearchSOP Password[7]PasswordString1210
55SOPPSSWD_8 SearchSOP Password[8]PasswordString1210
56SOPPSSWD_9 SearchSOP Password[9]PasswordString1210
57SOPPSSWD_10 SearchSOP Password[10]PasswordString1210
58IVCDSTCK SearchIVC Dist CheckML_IVC_Dist_CheckLong Integer40
59NUMOFTRX SearchNumber Of TRXLI6_U0Long Integer46
60USRDFPR1 SearchUser Defined Prompt 1STR15String1615
61USRDRPR2 SearchUser Defined Prompt 2STR15String1615
62USRDRPR3 SearchUser Defined Prompt 3STR15String1615
63USRDRPR4 SearchUser Defined Prompt 4STR15String1615
64USRDRPR5 SearchUser Defined Prompt 5STR15String1615
65USRDRPR6 SearchUser Defined Prompt 6STR15String1615
66USRDRPR7 SearchUser Defined Prompt 7STR15String1615
67USRDRPR8 SearchUser Defined Prompt 8STR15String1615
68USRDRPR9 SearchUser Defined Prompt 9STR15String1615
69USRDRP10 SearchUser Defined Prompt 10STR15String1615
70USRDRP11 SearchUser Defined Prompt 11STR15String1615
71USRDRP12 SearchUser Defined Prompt 12STR15String1615
72USRDFPR13 SearchUser Defined Prompt 13STR15String1615
73USRDFPR14 SearchUser Defined Prompt 14STR15String1615
74USRDFPR15 SearchUser Defined Prompt 15STR15String1615
75USRDFPR16 SearchUser Defined Prompt 16STR15String1615
76USRDFPR17 SearchUser Defined Prompt 17STR15String1615
77CREATDDT SearchCreated DateDTDate48
78MODIFDT SearchModified DateDTDate48
79REQSHIP SearchRequested Date for PODDL_ReqShipDateInteger20
80REQDAYS SearchRequested Days AfterINT3_RB0_UInteger23
81SITEPREF SearchSite PreferenceDDL_SitePrefInteger20
82PREFSITE SearchPreferred SiteSTR10_Location_CodeString1210
83REQDATEPO SearchRequired Date for PODDL_ReqDatePOInteger20
84Required_Days SearchRequired DaysINT3_RB0_UInteger23
85UMDEFAULT SearchU of M SelectionDDL_UofMSelectionInteger20
86COMBONPO SearchCombine On PO LineCB_CombineOnPOBoolean20
87TXBASECS SearchTax Base on CustomersCB_Tax_Base_On_CustomersBoolean20
88USEORGUC SearchUse Original Unit CostCB_Use_Original_Unit_CostBoolean20
89Prices_Not_Required_In_Pr SearchPrices Not Required In Price ListCB_Prices_Not_Required_In_Price_ListBoolean20
90PasswordUpper SearchPassword UpperPasswordString1210
91Convert_Functional_Price SearchConvert Functional PriceCB_Convert_Functional_PriceBoolean20
92INDVPICKTICKETSORT SearchIndividual Picking Ticket SortDDL_IndividualPickTicketSortInteger20
93PRINTAVAILABLEBINS SearchPrint Available BinsDDL_PrintAvailableBinsInteger20
94FODOCID SearchFulfillment Order Document IDSTR15_LBAUString1615
95CombineDropshipSOLines SearchCombine Dropship SO LinesCB_CombineDropshipSOLinesBoolean20
96CombineDropshipSODocs SearchCombine Dropship SO DocumentsCB_CombineDropshipSODocumentsBoolean20
97DEX_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 *