mrpExceptionsEPS (MRP0300)

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

Product: Manufacturing (346)
Series:

Display Name: mrpExceptionsEPS
Physical Name: MRP0300
Technical Name: mrpExceptionsEPS

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1GUID SearchGUIDStringGUIDString36
2RUNNUMBER SearchMRP_Run_NumberLong IntegerINT99
3ORDERNUMBER SearchOrder NumberStringSTR3030
4MRPTYPE SearchMRP_TypeIntegerMRP_Type0
5ORD SearchOrdLong IntegerLI_Sequence_Number10
6SOPTYPE SearchSOP TypeIntegerDDL_SOP_Type0
7CMPNTSEQ SearchComponent SequenceLong IntegerLI_Sequence_Number10
8DUEDATE SearchDue DateDateDT8
9RELEASEDATE_I SearchRelease DateDateDT8
10ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

SELECT
       ['mrpExceptionsEPS'].ITEMNMBR AS 'mrpExceptionsEPS-Item Number'
       ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number'
FROM
       MRP0300 AS ['mrpExceptionsEPS']
INNER JOIN
       IV00101 AS ['Item Master']
              ON
                     ['mrpExceptionsEPS'].ITEMNMBR = ['Item Master'].ITEMNMBR
11LOCNCODE SearchLocation CodeStringSTR10_Location_Code10
Key to the Site Setup (IV40700).

Click to show/hide

SELECT
       ['mrpExceptionsEPS'].LOCNCODE AS 'mrpExceptionsEPS-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       MRP0300 AS ['mrpExceptionsEPS']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['mrpExceptionsEPS'].LOCNCODE = ['Site Setup'].LOCNCODE
12MRP_EXCEPTION_STATUS SearchMRP_Exception_StatusStringMRP_Status_String20
13SUPPLYQTY SearchSupplyQuantityCurrencyDLR17_QTY_RBS0_STR17
14DEMANDQTY SearchDemandQuantityCurrencyDLR17_QTY_RBS0_STR17
15BUYERID SearchBuyer IDStringSTR15_User_ID15
16PLANNERID SearchPlanner IDStringSTR15_User_ID15
17MRPEXCEPTIONS SearchMRP_ExceptionsIntegerMRP_Exceptions0
18Status SearchStatusIntegerINT0
19QUANTITY SearchQTYCurrencyDLR17_QTY_RBS0_STR17
20REPORTGROUP SearchReportGroupLong IntegerLI_Sequence_Number10
21LOTNUMBR SearchLot NumberStringSTR20_LBAU20
22DUEDATE2 SearchDueDate2DateDT8

Leave a Reply

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