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 TypeLength
1COMMNTID SearchComment IDStringSTR15_Comment_ID15
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 KeyIntegerINT0
3DPYITMCS SearchDisplay Item Unit CostBooleanCB_Display_Item_Unit_Cost0
4DQTYSWAR SearchDisplay Quantity Distribution WarningBooleanCB_Display_Quantity_Distribution_Warning0
5TRKVDTRX SearchTrack Voided Trx In HistoryBooleanCB_Track_Voided_Trx_In_History0
6CALCKITC SearchCalculate Kit Price Based On Component CostBooleanCB_Calculate_Kit_Price_Based_On_Component_Cost0
7NEWRATES SearchSearch for New Rates During TransferBooleanCB_Pull_New_Exchange_Rates0
8TRMSTNUM SearchTrack Master NumbersBooleanCB_Track_Master_Numbers0
9NXTMSTNO SearchNext Master NumberLong IntegerLI_MasterNumber9
10QUOTE SearchQuoteBooleanCB_Quote0
11PRDER SearchOrderBooleanCB_Order0
12INVORETU SearchInvoice/ReturnBooleanCB_Invoice/Return0
13ACDSTRBN SearchAccount DistributionsBooleanCB_Account_Distributions0
14LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
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 IDStringSTR15_Checkbook_ID15
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 OptionsIntegerDDL_Quantity_Shortage_Options0
17QUODOCID SearchQuote Document IDStringSTR15_LBAU15
18ORDDOCID SearchOrder Document IDStringSTR15_LBAU15
19BACDOCID SearchBack Order Document IDStringSTR15_LBAU15
20INVDOCID SearchInvoice Document IDStringSTR15_LBAU15
21RETDOCID SearchReturn Document IDStringSTR15_LBAU15
22DECPLQTY SearchDecimal Places QTYSIntegerDDL_Decimal_Places_QTYS0
23DECPLCUR SearchDecimal Places CurrencyIntegerDDL_Decimal_Places_Dollars0
24USEACFRM SearchUse Posting Accounts FromIntegerGB0
25USEADVTX SearchUse Advanced TaxesIntegerGB0
26TAXSCHID SearchTax Schedule IDStringSTR15_Tax_Schedule_ID15
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 TaxableIntegerDDL_Tax_Options0
28NONIVSCH SearchNon IV Item Schedule IDStringSTR15_Tax_Schedule_ID15
29FRGTTXBL SearchFreight TaxableIntegerDDL_Tax_Options0
30FRTSCHID SearchFreight Schedule IDStringSTR15_LBAU15
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 TaxableIntegerDDL_Tax_Options0
32MSCSCHID SearchMisc Schedule IDStringSTR15_LBAU15
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 SlipIntegerDDL_Match_Packing_Slip0
34MPICKTIC SearchMatch Picking TicketIntegerDDL_Match_Picking_Ticket0
35PriceLevelWarning SearchPriceLevelWarningIntegerPriceLevelWarning0
36SOPALLOW SearchSOP AllowCBBoolean0
37SOPALLOW_1 SearchSOP Allow[1]BooleanCB0
38SOPALLOW_2 SearchSOP Allow[2]BooleanCB0
39SOPALLOW_3 SearchSOP Allow[3]BooleanCB0
40SOPALLOW_4 SearchSOP Allow[4]BooleanCB0
41SOPALLOW_5 SearchSOP Allow[5]BooleanCB0
42SOPALLOW_6 SearchSOP Allow[6]BooleanCB0
43SOPALLOW_7 SearchSOP Allow[7]BooleanCB0
44SOPALLOW_8 SearchSOP Allow[8]BooleanCB0
45SOPALLOW_9 SearchSOP Allow[9]BooleanCB0
46SOPALLOW_10 SearchSOP Allow[10]BooleanCB0
47SOPPSSWD_1 SearchSOP Password[1]StringPassword10
48SOPPSSWD SearchSOP PasswordPasswordString10
49SOPPSSWD_2 SearchSOP Password[2]StringPassword10
50SOPPSSWD_3 SearchSOP Password[3]StringPassword10
51SOPPSSWD_4 SearchSOP Password[4]StringPassword10
52SOPPSSWD_5 SearchSOP Password[5]StringPassword10
53SOPPSSWD_6 SearchSOP Password[6]StringPassword10
54SOPPSSWD_7 SearchSOP Password[7]StringPassword10
55SOPPSSWD_8 SearchSOP Password[8]StringPassword10
56SOPPSSWD_9 SearchSOP Password[9]StringPassword10
57SOPPSSWD_10 SearchSOP Password[10]StringPassword10
58IVCDSTCK SearchIVC Dist CheckLong IntegerML_IVC_Dist_Check0
59NUMOFTRX SearchNumber Of TRXLong IntegerLI6_U06
60USRDFPR1 SearchUser Defined Prompt 1StringSTR1515
61USRDRPR2 SearchUser Defined Prompt 2StringSTR1515
62USRDRPR3 SearchUser Defined Prompt 3StringSTR1515
63USRDRPR4 SearchUser Defined Prompt 4StringSTR1515
64USRDRPR5 SearchUser Defined Prompt 5StringSTR1515
65USRDRPR6 SearchUser Defined Prompt 6StringSTR1515
66USRDRPR7 SearchUser Defined Prompt 7StringSTR1515
67USRDRPR8 SearchUser Defined Prompt 8StringSTR1515
68USRDRPR9 SearchUser Defined Prompt 9StringSTR1515
69USRDRP10 SearchUser Defined Prompt 10StringSTR1515
70USRDRP11 SearchUser Defined Prompt 11StringSTR1515
71USRDRP12 SearchUser Defined Prompt 12StringSTR1515
72USRDFPR13 SearchUser Defined Prompt 13StringSTR1515
73USRDFPR14 SearchUser Defined Prompt 14StringSTR1515
74USRDFPR15 SearchUser Defined Prompt 15StringSTR1515
75USRDFPR16 SearchUser Defined Prompt 16StringSTR1515
76USRDFPR17 SearchUser Defined Prompt 17StringSTR1515
77CREATDDT SearchCreated DateDateDT8
78MODIFDT SearchModified DateDateDT8
79REQSHIP SearchRequested Date for POIntegerDDL_ReqShipDate0
80REQDAYS SearchRequested Days AfterIntegerINT3_RB0_U3
81SITEPREF SearchSite PreferenceIntegerDDL_SitePref0
82PREFSITE SearchPreferred SiteStringSTR10_Location_Code10
83REQDATEPO SearchRequired Date for POIntegerDDL_ReqDatePO0
84Required_Days SearchRequired DaysIntegerINT3_RB0_U3
85UMDEFAULT SearchU of M SelectionIntegerDDL_UofMSelection0
86COMBONPO SearchCombine On PO LineBooleanCB_CombineOnPO0
87TXBASECS SearchTax Base on CustomersBooleanCB_Tax_Base_On_Customers0
88USEORGUC SearchUse Original Unit CostBooleanCB_Use_Original_Unit_Cost0
89Prices_Not_Required_In_Pr SearchPrices Not Required In Price ListBooleanCB_Prices_Not_Required_In_Price_List0
90PasswordUpper SearchPassword UpperStringPassword10
91Convert_Functional_Price SearchConvert Functional PriceBooleanCB_Convert_Functional_Price0
92INDVPICKTICKETSORT SearchIndividual Picking Ticket SortIntegerDDL_IndividualPickTicketSort0
93PRINTAVAILABLEBINS SearchPrint Available BinsIntegerDDL_PrintAvailableBins0
94FODOCID SearchFulfillment Order Document IDStringSTR15_LBAU15
95CombineDropshipSOLines SearchCombine Dropship SO LinesBooleanCB_CombineDropshipSOLines0
96CombineDropshipSODocs SearchCombine Dropship SO DocumentsBooleanCB_CombineDropshipSODocuments0

Leave a Reply

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