Sales Inquiry Restrictions (SOP70100)

azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Inquiry Restrictions (SOP70100)

Easily find this page again using the shortlink:

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: Sales Inquiry Restrictions
Physical Name: SOP70100
Technical Name: SOP_Restrictions_MSTR

Group Display Name: Sales Inquiry
Group Technical Name: Sales Inquiry

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1INQID SearchInquiry IDSTR15_LBAUString1615
2HISTORY SearchHistoryCB_HistoryBoolean20
3UNPSTTRX SearchUnposted TrxCB_Unposted_TrxBoolean20
4SORTBY SearchSort ByDDL_Sort_ByInteger20
5NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

       ['Sales Inquiry Restrictions'].NOTEINDX AS 'Sales Inquiry Restrictions-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
       SOP70100 AS ['Sales Inquiry Restrictions']
       SY03900 AS ['Record Notes Master']
                     ['Sales Inquiry Restrictions'].NOTEINDX = ['Record Notes Master'].NOTEINDX
6CREATDDT SearchCreated DateDTDate48
7MODIFDT SearchModified DateDTDate48
8USER2ENT SearchUser To EnterSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

       ['Sales Inquiry Restrictions'].USER2ENT AS 'Sales Inquiry Restrictions-User To Enter'
       ,['Users Master'].USERID AS 'Users Master-User ID'
       SOP70100 AS ['Sales Inquiry Restrictions']
       DYNAMICS..SY01400 AS ['Users Master']
                     ['Sales Inquiry Restrictions'].USER2ENT = ['Users Master'].USERID
9STCUSTID SearchStart Customer IDSTR15_RM_Customer_NumberString1615
10ENCUSTID SearchEnd Customer IDSTR15_RM_Customer_NumberString1615
11STCUSTNM SearchStart Customer NameSTR64_Customer_NameString6664
12ENCSTNAM SearchEnd Customer NameSTR64_Customer_NameString6664
13STTDOCDT SearchStart Document DateDTDate48
14ENDDOCDT SearchEnd Document DateDTDate48
15STDOCNUM SearchStart Document NumberSTR20String2220
16ENDOCNUM SearchEnd Document NumberSTR20String2220
17STSOPTYP SearchStart SOP TypeDDL_SOP_TypeInteger20
18EDSOPTYP SearchEnd SOP TypeDDL_SOP_TypeInteger20
19STTDOCID SearchStart Document IDSTR15_LBAUString1615
20ENDDOCID SearchEnd Document IDSTR15_LBAUString1615
21STTITNUM SearchStart Item NumberSTR30_Item_NumberString3230
22ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString3230
23STMSTNMB SearchStart Master NumberLI_MasterNumberLong Integer49
24EDMASNMB SearchEnd Master NumberLI_MasterNumberLong Integer49
25STTPHON1 SearchStart Phone 1Phone_NumberString2214
26ENDPHON1 SearchEnd Phone 1Phone_NumberString2214
27STQUOEXD SearchStart Quote Expiration DateDTDate48
28EDQUOEXD SearchEnd Quote Expiration DateDTDate48
29STREQDAT SearchStart Requested Ship DateDATEDate46
30ENDREQDT SearchEnd Requested Ship DateDATEDate46
31STSPRSID SearchStart Salesperson IDSTR15_LBAUString1615
32ENSPSNID SearchEnd Salesperson IDSTR15_LBAUString1615
33STTUDEF1 SearchStart User Defined 1STR20String2220
34ENUSRDF1 SearchEnd User Defined 1STR20String2220
35Start_Purchasing_Status SearchStart Purchasing StatusDDL_PurchasingStatusInteger20
36End_Purchasing_Status SearchEnd Purchasing StatusDDL_PurchasingStatusInteger20
37DEX_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.

azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Inquiry Restrictions (SOP70100)

Leave a Reply

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