Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MRP6060
Product: Manufacturing (346)
Series:
Display Name: mrpQuantitiesQuery Group Display Name: Manufacturing MRP
Physical Name: MRP6060
Technical Name: mrpQuantitiesQuery
Group Technical Name: Manufacturing MRP
| Seq No | Physical Name | Display Name | Dexterity Data Type | SQL Data Type | Length | |
|---|---|---|---|---|---|---|
| 1 | USERID  | User ID | String | STR15_User_ID | 15 | |
Key to the Users Master (SY01400).
Click to show/hideSELECT
['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 | ||||||
| 2 | QUERYNAME | Query Name | String | STR50 | 50 | |
| 3 | MRPQTYNUM_I | MRP_Quantity_Number | Integer | INT2 | 2 | |
| 4 | STTITNUM | Start Item Number | String | STR30_Item_Number | 30 | |
| 5 | ENITMNBR | End Item Number | String | STR30_Item_Number | 30 | |
| 6 | ITEMDESC | Item Description | String | STR100 | 100 | |
| 7 | STTITCLS | Start Item Class | String | STR10_Item_Class_Code | 10 | |
| 8 | ENITMCLS | End Item Class | String | STR10_Item_Class_Code | 10 | |
| 9 | STTLOCCD | Start Location Code | String | STR10_Location_Code | 10 | |
| 10 | ENLOCNCD | End Location Code | String | STR10_Location_Code | 10 | |
| 11 | STARTORDERNMBR | Start Order Number | String | STR30 | 30 | |
| 12 | ENDORDERNMBR | End Order Number | String | STR30 | 30 | |
| 13 | STARTBUYERID | Start Buyer ID | String | STR15_User_ID | 15 | |
| 14 | ENDBUYERID | End Buyer ID | String | STR15_User_ID | 15 | |
| 15 | STARTPLANNERID | Start Planner ID | String | STR15_User_ID | 15 | |
| 16 | ENDPLANNERID | End Planner ID | String | STR15_User_ID | 15 | |
| 17 | STARTRELEASEDATE | Start Release Date | Date | DT | 8 | |
| 18 | ENDRELEASEDATE | End Release Date | Date | DT | 8 | |
| 19 | STTDUEDT | Start Due Date | Date | DT | 8 | |
| 20 | ENDDUEDT | End Due Date | Date | DT | 8 | |
| 21 | MRPQUERYIV | MRPQueryIV | CB | Boolean | 0 | |
| 22 | MRPQUERYIV_1 | MRPQueryIV[1] | Boolean | CB | 0 | |
| 23 | MRPQUERYIV_2 | MRPQueryIV[2] | Boolean | CB | 0 | |
| 24 | MRPQUERYPO | MRPQueryPO | CB | Boolean | 0 | |
| 25 | MRPQUERYIV_3 | MRPQueryIV[3] | Boolean | CB | 0 | |
| 26 | MRPQUERYSO | MRPQuerySO | CB | Boolean | 0 | |
| 27 | MRPQUERYMO | MRPQueryMO | CB | Boolean | 0 | |
| 28 | MRPQUERYIV_4 | MRPQueryIV[4] | Boolean | CB | 0 | |
| 29 | MRPQUERYPO_1 | MRPQueryPO[1] | Boolean | CB | 0 | |
| 30 | MRPQUERYPK | MRPQueryPK | CB | Boolean | 0 | |
| 31 | MRPQUERYSUGGESTIONS | MRPQuerySuggestions | CB | Boolean | 0 | |
| 32 | MRPQUERYPO_2 | MRPQueryPO[2] | Boolean | CB | 0 | |
| 33 | MRPQUERYEXCEPTIONS | MRPQueryExceptions | CB | Boolean | 0 | |
| 34 | MRPQUERYPO_3 | MRPQueryPO[3] | Boolean | CB | 0 | |
| 35 | MRPQUERYPO_4 | MRPQueryPO[4] | Boolean | CB | 0 | |
| 36 | MRPQUERYSO_1 | MRPQuerySO[1] | Boolean | CB | 0 | |
| 37 | MRPQUERYSO_2 | MRPQuerySO[2] | Boolean | CB | 0 | |
| 38 | MRPQUERYSO_3 | MRPQuerySO[3] | Boolean | CB | 0 | |
| 39 | MRPQUERYSO_4 | MRPQuerySO[4] | Boolean | CB | 0 | |
| 40 | MRPQUERYSO_5 | MRPQuerySO[5] | Boolean | CB | 0 | |
| 41 | MRPQUERYSO_6 | MRPQuerySO[6] | Boolean | CB | 0 | |
| 42 | MRPQUERYSO_7 | MRPQuerySO[7] | Boolean | CB | 0 | |
| 43 | MRPQUERYMO_1 | MRPQueryMO[1] | Boolean | CB | 0 | |
| 44 | MRPQUERYMO_2 | MRPQueryMO[2] | Boolean | CB | 0 | |
| 45 | MRPQUERYMO_3 | MRPQueryMO[3] | Boolean | CB | 0 | |
| 46 | MRPQUERYMO_4 | MRPQueryMO[4] | Boolean | CB | 0 | |
| 47 | MRPQUERYMO_5 | MRPQueryMO[5] | Boolean | CB | 0 | |
| 48 | MRPQUERYMO_6 | MRPQueryMO[6] | Boolean | CB | 0 | |
| 49 | MRPQUERYPK_1 | MRPQueryPK[1] | Boolean | CB | 0 | |
| 50 | MRPQUERYPK_2 | MRPQueryPK[2] | Boolean | CB | 0 | |
| 51 | MRPQUERYPK_3 | MRPQueryPK[3] | Boolean | CB | 0 | |
| 52 | MRPQUERYPK_4 | MRPQueryPK[4] | Boolean | CB | 0 | |
| 53 | MRPQUERYPK_5 | MRPQueryPK[5] | Boolean | CB | 0 | |
| 54 | MRPQUERYPK_6 | MRPQueryPK[6] | Boolean | CB | 0 | |
| 55 | MRPQUERYSUGGESTIONS_1 | MRPQuerySuggestions[1] | Boolean | CB | 0 | |
| 56 | MRPQUERYSUGGESTIONS_2 | MRPQuerySuggestions[2] | Boolean | CB | 0 | |
| 57 | MRPQUERYSUGGESTIONS_3 | MRPQuerySuggestions[3] | Boolean | CB | 0 | |
| 58 | MRPQUERYSUGGESTIONS_4 | MRPQuerySuggestions[4] | Boolean | CB | 0 | |
| 59 | MRPQUERYEXCEPTIONS_1 | MRPQueryExceptions[1] | Boolean | CB | 0 | |
| 60 | MRPQUERYEXCEPTIONS_2 | MRPQueryExceptions[2] | Boolean | CB | 0 | |
| 61 | MRPQUERYEXCEPTIONS_3 | MRPQueryExceptions[3] | Boolean | CB | 0 | |
| 62 | MRPQUERYEXCEPTIONS_4 | MRPQueryExceptions[4] | Boolean | CB | 0 | |
| 63 | MRPQUERYEXCEPTIONS_5 | MRPQueryExceptions[5] | Boolean | CB | 0 | |
| 64 | MRPQUERYEXCEPTIONS_6 | MRPQueryExceptions[6] | Boolean | CB | 0 | |
| 65 | MRPQUERYEXCEPTIONS_7 | MRPQueryExceptions[7] | Boolean | CB | 0 | |
| 66 | MRPQUERYEXCEPTIONS_8 | MRPQueryExceptions[8] | Boolean | CB | 0 | |
| 67 | MRPQUERYEXCEPTIONS_9 | MRPQueryExceptions[9] | Boolean | CB | 0 | |
| 68 | MRPQUERYDUEDATE | MRPQueryDueDate | Integer | MRPQueryDate | 0 | |
| 69 | MRPQUERYRLSDATE | MRPQueryReleaseDate | Integer | MRPQueryDate | 0 | |