Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/MRP4070
Product: Manufacturing (346)
Series:
Display Name: mrpSuggestionsEPS
Physical Name: MRP4070
Technical Name: mrpSuggestionsEPSSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ITEMNMBR Item Number String STR30_Item_Number 30 Key to the Item Master (IV00101).
Click to show/hide
SELECT
['mrpSuggestionsEPS'].ITEMNMBR AS 'mrpSuggestionsEPS-Item Number'
,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
MRP4070 AS ['mrpSuggestionsEPS']
INNER JOIN
IV00101 AS ['Item Master']
ON
['mrpSuggestionsEPS'].ITEMNMBR = ['Item Master'].ITEMNMBR
2 LOCNCODE Location Code String STR10_Location_Code 10 Key to the Site Setup (IV40700).
Click to show/hide
SELECT
['mrpSuggestionsEPS'].LOCNCODE AS 'mrpSuggestionsEPS-Location Code'
,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
MRP4070 AS ['mrpSuggestionsEPS']
INNER JOIN
IV40700 AS ['Site Setup']
ON
['mrpSuggestionsEPS'].LOCNCODE = ['Site Setup'].LOCNCODE
3 DUEDATE Due Date Date DT 8 4 RELEASEDATE_I Release Date Date DT 8 5 ORDERNUMBER Order Number String STR30 30 6 MRPTYPE MRP_Type Integer MRP_Type 0 7 ORD Ord Long Integer LI_Sequence_Number 10 8 Status Status Integer INT 0 9 STSDESCR Status Description String STR30 30 10 MRPSUGGESTIONS MRPSuggestions Currency DLR17_QTY_RBS0_STR 17 11 MOVEIN MoveIn Boolean Boolean 0 12 MOVEOUT MoveOut Boolean CB 0 13 ORGNLDUEDT Original Due Date Date DT 8 14 ORGNLRLSDT Original Release Date Date DT 8 15 CANCELED Cancelled Boolean YN 0 16 HASMRPEXCEPTION HasMRPException CB Boolean 0 17 HASMRPEXCEPTION_1 HasMRPException[1] Boolean CB 0 18 HASMRPEXCEPTION_2 HasMRPException[2] Boolean CB 0 19 HASMRPEXCEPTION_3 HasMRPException[3] Boolean CB 0 20 HASMRPEXCEPTION_4 HasMRPException[4] Boolean CB 0 21 HASMRPEXCEPTION_5 HasMRPException[5] Boolean CB 0 22 HASMRPEXCEPTION_6 HasMRPException[6] Boolean CB 0 23 HASMRPEXCEPTION_7 HasMRPException[7] Boolean CB 0 24 HASMRPEXCEPTION_8 HasMRPException[8] Boolean CB 0 25 HASMRPEXCEPTION_9 HasMRPException[9] Boolean CB 0 26 HASMRPEXCEPTION_10 HasMRPException[10] Boolean CB 0 27 HASMRPEXCEPTION_11 HasMRPException[11] Boolean CB 0 28 HASMRPEXCEPTION_12 HasMRPException[12] Boolean CB 0 29 HASMRPEXCEPTION_13 HasMRPException[13] Boolean CB 0 30 HASMRPEXCEPTION_14 HasMRPException[14] Boolean CB 0 31 HASMRPEXCEPTION_15 HasMRPException[15] Boolean CB 0 32 HASMRPEXCEPTION_16 HasMRPException[16] Boolean CB 0 33 HASMRPEXCEPTION_17 HasMRPException[17] Boolean CB 0 34 HASMRPEXCEPTION_18 HasMRPException[18] Boolean CB 0 35 HASMRPEXCEPTION_19 HasMRPException[19] Boolean CB 0 36 HASMRPEXCEPTION_20 HasMRPException[20] Boolean CB 0