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 IDStringSTR15_LBAU15
2HISTORY SearchHistoryBooleanCB_History0
3UNPSTTRX SearchUnposted TrxBooleanCB_Unposted_Trx0
4SORTBY SearchSort ByIntegerDDL_Sort_By0
5NOTEINDX SearchNote IndexCurrencyDLR1414
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 DateDateDT8
7MODIFDT SearchModified DateDateDT8
8USER2ENT SearchUser To EnterStringSTR15_User_ID15
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 IDStringSTR15_RM_Customer_Number15
10ENCUSTID SearchEnd Customer IDStringSTR15_RM_Customer_Number15
11STCUSTNM SearchStart Customer NameStringSTR64_Customer_Name64
12ENCSTNAM SearchEnd Customer NameStringSTR64_Customer_Name64
13STTDOCDT SearchStart Document DateDateDT8
14ENDDOCDT SearchEnd Document DateDateDT8
15STDOCNUM SearchStart Document NumberStringSTR2020
16ENDOCNUM SearchEnd Document NumberStringSTR2020
17STSOPTYP SearchStart SOP TypeIntegerDDL_SOP_Type0
18EDSOPTYP SearchEnd SOP TypeIntegerDDL_SOP_Type0
19STTDOCID SearchStart Document IDStringSTR15_LBAU15
20ENDDOCID SearchEnd Document IDStringSTR15_LBAU15
21STTITNUM SearchStart Item NumberStringSTR30_Item_Number30
22ENITMNBR SearchEnd Item NumberStringSTR30_Item_Number30
23STMSTNMB SearchStart Master NumberLong IntegerLI_MasterNumber9
24EDMASNMB SearchEnd Master NumberLong IntegerLI_MasterNumber9
25STTPHON1 SearchStart Phone 1StringPhone_Number14
26ENDPHON1 SearchEnd Phone 1StringPhone_Number14
27STQUOEXD SearchStart Quote Expiration DateDateDT8
28EDQUOEXD SearchEnd Quote Expiration DateDateDT8
29STREQDAT SearchStart Requested Ship DateDateDATE6
30ENDREQDT SearchEnd Requested Ship DateDateDATE6
31STSPRSID SearchStart Salesperson IDStringSTR15_LBAU15
32ENSPSNID SearchEnd Salesperson IDStringSTR15_LBAU15
33STTUDEF1 SearchStart User Defined 1StringSTR2020
34ENUSRDF1 SearchEnd User Defined 1StringSTR2020
35Start_Purchasing_Status SearchStart Purchasing StatusIntegerDDL_PurchasingStatus0
36End_Purchasing_Status SearchEnd Purchasing StatusIntegerDDL_PurchasingStatus0
azurecurveProductsMicrosoft Dynamics GP (0)SalesSales Inquiry Restrictions (SOP70100)

Leave a Reply

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