mrpQuantitiesQuery (MRP6060)

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

Product: Manufacturing (346)
Series: 3rd Party

Display Name: mrpQuantitiesQuery
Physical Name: MRP6060
Technical Name: mrpQuantitiesQuery

Group Display Name: Manufacturing MRP
Group Technical Name: Manufacturing MRP

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['mrpQuantitiesQuery'].USERID AS 'mrpQuantitiesQuery-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       MRP6060 AS ['mrpQuantitiesQuery']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['mrpQuantitiesQuery'].USERID = ['Users Master'].USERID
2QUERYNAME SearchQuery NameSTR50String50
3MRPQTYNUM_I SearchMRP_Quantity_NumberINT2Integer2
4STTITNUM SearchStart Item NumberSTR30_Item_NumberString30
5ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString30
6ITEMDESC SearchItem DescriptionSTR100String100
7STTITCLS SearchStart Item ClassSTR10_Item_Class_CodeString10
8ENITMCLS SearchEnd Item ClassSTR10_Item_Class_CodeString10
9STTLOCCD SearchStart Location CodeSTR10_Location_CodeString10
10ENLOCNCD SearchEnd Location CodeSTR10_Location_CodeString10
11STARTORDERNMBR SearchStart Order NumberSTR30String30
12ENDORDERNMBR SearchEnd Order NumberSTR30String30
13STARTBUYERID SearchStart Buyer IDSTR15_User_IDString15
14ENDBUYERID SearchEnd Buyer IDSTR15_User_IDString15
15STARTPLANNERID SearchStart Planner IDSTR15_User_IDString15
16ENDPLANNERID SearchEnd Planner IDSTR15_User_IDString15
17STARTRELEASEDATE SearchStart Release DateDTDate8
18ENDRELEASEDATE SearchEnd Release DateDTDate8
19STTDUEDT SearchStart Due DateDTDate8
20ENDDUEDT SearchEnd Due DateDTDate8
21MRPQUERYIV_1 SearchMRPQueryIV[1]CBBoolean0
22MRPQUERYIV SearchMRPQueryIVCBBoolean0
23MRPQUERYPO SearchMRPQueryPOCBBoolean0
24MRPQUERYIV_2 SearchMRPQueryIV[2]CBBoolean0
25MRPQUERYSO SearchMRPQuerySOCBBoolean0
26MRPQUERYIV_3 SearchMRPQueryIV[3]CBBoolean0
27MRPQUERYMO SearchMRPQueryMOCBBoolean0
28MRPQUERYIV_4 SearchMRPQueryIV[4]CBBoolean0
29MRPQUERYPO_1 SearchMRPQueryPO[1]CBBoolean0
30MRPQUERYPK SearchMRPQueryPKCBBoolean0
31MRPQUERYSUGGESTIONS SearchMRPQuerySuggestionsCBBoolean0
32MRPQUERYPO_2 SearchMRPQueryPO[2]CBBoolean0
33MRPQUERYPO_3 SearchMRPQueryPO[3]CBBoolean0
34MRPQUERYEXCEPTIONS SearchMRPQueryExceptionsCBBoolean0
35MRPQUERYPO_4 SearchMRPQueryPO[4]CBBoolean0
36MRPQUERYDUEDATE SearchMRPQueryDueDateMRPQueryDateInteger0
37MRPQUERYSO_1 SearchMRPQuerySO[1]CBBoolean0
38MRPQUERYRLSDATE SearchMRPQueryReleaseDateMRPQueryDateInteger0
39MRPQUERYSO_2 SearchMRPQuerySO[2]CBBoolean0
40MRPQUERYSO_3 SearchMRPQuerySO[3]CBBoolean0
41MRPQUERYSO_4 SearchMRPQuerySO[4]CBBoolean0
42MRPQUERYSO_5 SearchMRPQuerySO[5]CBBoolean0
43MRPQUERYSO_6 SearchMRPQuerySO[6]CBBoolean0
44MRPQUERYSO_7 SearchMRPQuerySO[7]CBBoolean0
45MRPQUERYMO_1 SearchMRPQueryMO[1]CBBoolean0
46MRPQUERYMO_2 SearchMRPQueryMO[2]CBBoolean0
47MRPQUERYMO_3 SearchMRPQueryMO[3]CBBoolean0
48MRPQUERYMO_4 SearchMRPQueryMO[4]CBBoolean0
49MRPQUERYMO_5 SearchMRPQueryMO[5]CBBoolean0
50MRPQUERYMO_6 SearchMRPQueryMO[6]CBBoolean0
51MRPQUERYPK_1 SearchMRPQueryPK[1]CBBoolean0
52MRPQUERYPK_2 SearchMRPQueryPK[2]CBBoolean0
53MRPQUERYPK_3 SearchMRPQueryPK[3]CBBoolean0
54MRPQUERYPK_4 SearchMRPQueryPK[4]CBBoolean0
55MRPQUERYPK_5 SearchMRPQueryPK[5]CBBoolean0
56MRPQUERYPK_6 SearchMRPQueryPK[6]CBBoolean0
57MRPQUERYSUGGESTIONS_1 SearchMRPQuerySuggestions[1]CBBoolean0
58MRPQUERYSUGGESTIONS_2 SearchMRPQuerySuggestions[2]CBBoolean0
59MRPQUERYSUGGESTIONS_3 SearchMRPQuerySuggestions[3]CBBoolean0
60MRPQUERYSUGGESTIONS_4 SearchMRPQuerySuggestions[4]CBBoolean0
61MRPQUERYEXCEPTIONS_1 SearchMRPQueryExceptions[1]CBBoolean0
62MRPQUERYEXCEPTIONS_2 SearchMRPQueryExceptions[2]CBBoolean0
63MRPQUERYEXCEPTIONS_3 SearchMRPQueryExceptions[3]CBBoolean0
64MRPQUERYEXCEPTIONS_4 SearchMRPQueryExceptions[4]CBBoolean0
65MRPQUERYEXCEPTIONS_5 SearchMRPQueryExceptions[5]CBBoolean0
66MRPQUERYEXCEPTIONS_6 SearchMRPQueryExceptions[6]CBBoolean0
67MRPQUERYEXCEPTIONS_7 SearchMRPQueryExceptions[7]CBBoolean0
68MRPQUERYEXCEPTIONS_8 SearchMRPQueryExceptions[8]CBBoolean0
69MRPQUERYEXCEPTIONS_9 SearchMRPQueryExceptions[9]CBBoolean0
70DEX_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.

Leave a Reply

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