mrpItemSitesList (MRP0101)

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

Product: Manufacturing (346)
Series:

Display Name: mrpItemSitesList
Physical Name: MRP0101
Technical Name: mrpItemSitesList

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

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1ITEMNMBR SearchItem NumberStringSTR30_Item_Number30
Key to the Item Master (IV00101).

Click to show/hide

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

Click to show/hide

SELECT
       ['mrpItemSitesList'].LOCNCODE AS 'mrpItemSitesList-Location Code'
       ,['Site Setup'].LOCNCODE AS 'Site Setup-Location Code'
FROM
       MRP0101 AS ['mrpItemSitesList']
INNER JOIN
       IV40700 AS ['Site Setup']
              ON
                     ['mrpItemSitesList'].LOCNCODE = ['Site Setup'].LOCNCODE
3REPLENISHMENTMETHOD SearchReplenishment MethodIntegerDDL_Replenishment_Method0
4PRIMVNDR SearchPrimary VendorStringSTR_15_Vendor_ID15
5PRCHSNGLDTM SearchPurchasing Lead TimeCurrencyDLR4_U29
6MNFCTRNGFXDLDTM SearchManufacturing Fixed Lead TimeCurrencyDLR4_U29
7MNFCTRNGVRBLLDTM SearchManufacturing Variable Lead TimeCurrencyDLR3_U48
8MNMMORDRQTY SearchMinimum Order QtyCurrencyDLR17_QTY_RBS0_UTR17
9MXMMORDRQTY SearchMaximum Order QtyCurrencyDLR17_QTY_RBS0_UTR17
10ORDERMULTIPLE SearchOrder MultipleCurrencyDLR17_QTY_RBS0_UTR17
11FXDORDRQTY SearchFixed Order QtyCurrencyDLR17_QTY_RBS0_UTR17
12NMBROFDYS SearchNumber of DaysIntegerINT3_U03
13ORDRPNTQTY SearchOrder Point QtyCurrencyDLR17_QTY_RBS0_UTR17
14ORDRUPTOLVL SearchOrder Up To LevelCurrencyDLR17_QTY_RBS0_UTR17
15SFTYSTCKQTY SearchSafety Stock QtyCurrencyDLR17_QTY_RBS0_UTR17
16ORDERPOLICY SearchOrder PolicyIntegerDDL_Order_Policy0
17SHRINKAGEFACTOR SearchShrinkage FactorCurrencyDLR1_46
18PLNNNGTMFNCDYS SearchPlanning Time Fence DaysIntegerINT3_U03
19PLANNERID SearchPlanner IDStringSTR15_User_ID15
20BUYERID SearchBuyer IDStringSTR15_User_ID15
21MOVEIN SearchMoveInBooleanBoolean0
22MOVEOUT SearchMoveOutBooleanCB0
23CANCELED SearchCancelledBooleanYN0
24Move_Out_Fence SearchMove-Out FenceIntegerINT3_U03

Leave a Reply

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