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 TypeSQL DB LengthKeyable Length
1USERID SearchUser IDSTR15_User_IDString1615
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 NameSTR50String5250
3MRPQTYNUM_I SearchMRP_Quantity_NumberINT2Integer22
4STTITNUM SearchStart Item NumberSTR30_Item_NumberString3230
5ENITMNBR SearchEnd Item NumberSTR30_Item_NumberString3230
6ITEMDESC SearchItem DescriptionSTR100String102100
7STTITCLS SearchStart Item ClassSTR10_Item_Class_CodeString1210
8ENITMCLS SearchEnd Item ClassSTR10_Item_Class_CodeString1210
9STTLOCCD SearchStart Location CodeSTR10_Location_CodeString1210
10ENLOCNCD SearchEnd Location CodeSTR10_Location_CodeString1210
11STARTORDERNMBR SearchStart Order NumberSTR30String3230
12ENDORDERNMBR SearchEnd Order NumberSTR30String3230
13STARTBUYERID SearchStart Buyer IDSTR15_User_IDString1615
14ENDBUYERID SearchEnd Buyer IDSTR15_User_IDString1615
15STARTPLANNERID SearchStart Planner IDSTR15_User_IDString1615
16ENDPLANNERID SearchEnd Planner IDSTR15_User_IDString1615
17STARTRELEASEDATE SearchStart Release DateDTDate48
18ENDRELEASEDATE SearchEnd Release DateDTDate48
19STTDUEDT SearchStart Due DateDTDate48
20ENDDUEDT SearchEnd Due DateDTDate48
21MRPQUERYIV_1 SearchMRPQueryIV[1]CBBoolean20
22MRPQUERYIV SearchMRPQueryIVCBBoolean20
23MRPQUERYPO SearchMRPQueryPOCBBoolean20
24MRPQUERYIV_2 SearchMRPQueryIV[2]CBBoolean20
25MRPQUERYSO SearchMRPQuerySOCBBoolean20
26MRPQUERYIV_3 SearchMRPQueryIV[3]CBBoolean20
27MRPQUERYMO SearchMRPQueryMOCBBoolean20
28MRPQUERYIV_4 SearchMRPQueryIV[4]CBBoolean20
29MRPQUERYPO_1 SearchMRPQueryPO[1]CBBoolean20
30MRPQUERYPK SearchMRPQueryPKCBBoolean20
31MRPQUERYSUGGESTIONS SearchMRPQuerySuggestionsCBBoolean20
32MRPQUERYPO_2 SearchMRPQueryPO[2]CBBoolean20
33MRPQUERYPO_3 SearchMRPQueryPO[3]CBBoolean20
34MRPQUERYEXCEPTIONS SearchMRPQueryExceptionsCBBoolean20
35MRPQUERYPO_4 SearchMRPQueryPO[4]CBBoolean20
36MRPQUERYDUEDATE SearchMRPQueryDueDateMRPQueryDateInteger20
37MRPQUERYSO_1 SearchMRPQuerySO[1]CBBoolean20
38MRPQUERYRLSDATE SearchMRPQueryReleaseDateMRPQueryDateInteger20
39MRPQUERYSO_2 SearchMRPQuerySO[2]CBBoolean20
40MRPQUERYSO_3 SearchMRPQuerySO[3]CBBoolean20
41MRPQUERYSO_4 SearchMRPQuerySO[4]CBBoolean20
42MRPQUERYSO_5 SearchMRPQuerySO[5]CBBoolean20
43MRPQUERYSO_6 SearchMRPQuerySO[6]CBBoolean20
44MRPQUERYSO_7 SearchMRPQuerySO[7]CBBoolean20
45MRPQUERYMO_1 SearchMRPQueryMO[1]CBBoolean20
46MRPQUERYMO_2 SearchMRPQueryMO[2]CBBoolean20
47MRPQUERYMO_3 SearchMRPQueryMO[3]CBBoolean20
48MRPQUERYMO_4 SearchMRPQueryMO[4]CBBoolean20
49MRPQUERYMO_5 SearchMRPQueryMO[5]CBBoolean20
50MRPQUERYMO_6 SearchMRPQueryMO[6]CBBoolean20
51MRPQUERYPK_1 SearchMRPQueryPK[1]CBBoolean20
52MRPQUERYPK_2 SearchMRPQueryPK[2]CBBoolean20
53MRPQUERYPK_3 SearchMRPQueryPK[3]CBBoolean20
54MRPQUERYPK_4 SearchMRPQueryPK[4]CBBoolean20
55MRPQUERYPK_5 SearchMRPQueryPK[5]CBBoolean20
56MRPQUERYPK_6 SearchMRPQueryPK[6]CBBoolean20
57MRPQUERYSUGGESTIONS_1 SearchMRPQuerySuggestions[1]CBBoolean20
58MRPQUERYSUGGESTIONS_2 SearchMRPQuerySuggestions[2]CBBoolean20
59MRPQUERYSUGGESTIONS_3 SearchMRPQuerySuggestions[3]CBBoolean20
60MRPQUERYSUGGESTIONS_4 SearchMRPQuerySuggestions[4]CBBoolean20
61MRPQUERYEXCEPTIONS_1 SearchMRPQueryExceptions[1]CBBoolean20
62MRPQUERYEXCEPTIONS_2 SearchMRPQueryExceptions[2]CBBoolean20
63MRPQUERYEXCEPTIONS_3 SearchMRPQueryExceptions[3]CBBoolean20
64MRPQUERYEXCEPTIONS_4 SearchMRPQueryExceptions[4]CBBoolean20
65MRPQUERYEXCEPTIONS_5 SearchMRPQueryExceptions[5]CBBoolean20
66MRPQUERYEXCEPTIONS_6 SearchMRPQueryExceptions[6]CBBoolean20
67MRPQUERYEXCEPTIONS_7 SearchMRPQueryExceptions[7]CBBoolean20
68MRPQUERYEXCEPTIONS_8 SearchMRPQueryExceptions[8]CBBoolean20
69MRPQUERYEXCEPTIONS_9 SearchMRPQueryExceptions[9]CBBoolean20
70DEX_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.

Leave a Reply

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