Sales Inquiry Restrictions (SOP70100)

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

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SOP70100

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 TypeLength
1INQID SearchInquiry IDSTR15_LBAUString15
2HISTORY SearchHistoryCB_HistoryBoolean0
3UNPSTTRX SearchUnposted TrxCB_Unposted_TrxBoolean0
4SORTBY SearchSort ByDDL_Sort_ByInteger0
5NOTEINDX SearchNote IndexDLR14Currency14
Key to the Record Notes Master (SY03900).

Click to show/hide

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

Click to show/hide

SELECT
       ['Sales Inquiry Restrictions'].USER2ENT AS 'Sales Inquiry Restrictions-User To Enter'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SOP70100 AS ['Sales Inquiry Restrictions']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['Sales Inquiry Restrictions'].USER2ENT = ['Users Master'].USERID
9STCUSTID SearchStart Customer IDSTR15_RM_Customer_NumberString15
10ENCUSTID SearchEnd Customer IDSTR15_RM_Customer_NumberString15
11STCUSTNM SearchStart Customer NameSTR64_Customer_NameString64
12ENCSTNAM SearchEnd Customer NameSTR64_Customer_NameString64
13STTDOCDT SearchStart Document DateDTDate8
14ENDDOCDT SearchEnd Document DateDTDate8
15STDOCNUM SearchStart Document NumberSTR20String20
16ENDOCNUM SearchEnd Document NumberSTR20String20
17STSOPTYP SearchStart SOP TypeDDL_SOP_TypeInteger0
18EDSOPTYP SearchEnd SOP TypeDDL_SOP_TypeInteger0
19STTDOCID SearchStart Document IDSTR15_LBAUString15
20ENDDOCID SearchEnd Document IDSTR15_LBAUString15
21STTITNUM SearchStart Item NumberSTR30_Item_NumberString30
22ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString30
23STMSTNMB SearchStart Master NumberLI_MasterNumberLong Integer9
24EDMASNMB SearchEnd Master NumberLI_MasterNumberLong Integer9
25STTPHON1 SearchStart Phone 1Phone_NumberString14
26ENDPHON1 SearchEnd Phone 1Phone_NumberString14
27STQUOEXD SearchStart Quote Expiration DateDTDate8
28EDQUOEXD SearchEnd Quote Expiration DateDTDate8
29STREQDAT SearchStart Requested Ship DateDATEDate6
30ENDREQDT SearchEnd Requested Ship DateDATEDate6
31STSPRSID SearchStart Salesperson IDSTR15_LBAUString15
32ENSPSNID SearchEnd Salesperson IDSTR15_LBAUString15
33STTUDEF1 SearchStart User Defined 1STR20String20
34ENUSRDF1 SearchEnd User Defined 1STR20String20
35Start_Purchasing_Status SearchStart Purchasing StatusDDL_PurchasingStatusInteger0
36End_Purchasing_Status SearchEnd Purchasing StatusDDL_PurchasingStatusInteger0
37DEX_ROW_ID Searchintint10

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 *