1.Functional Description
1.1Purpose
This function is equivalent to S006P-Analysis Item Table for Process subroutine in P3482.
This function is the main function of P3482 MRP Planning Program for Process Items. Based on the
Process Requirements and Orders , the function will generate and schedule orders for a given Item/Branch
combination.
1.2Setup Notes and Prerequisites
1.3Special Logic
D3401240 - MRP, Plan And Schedule Process Orders
Data Item Data Structure DescriptionI/OReqNotes
JOBS Job Number IYJOB Number from B3100710
JOB Job Number String IYJob Number as string value
CTID Computer Id IYComputer Id from B9800180
MCU Branch IYSVMCU - From F4102
ITM Short Item Number IYSVITM - From F4102
MRPP Lead Time Type IYSVMRPP - From F4102
LTLV Lead Time Level IYSVLTLV - From F4102
LTPU Lead Time Per Unit IYSVLTPU - From F4102
STKT Stocking Type IYSVSTKT - From F4102
SETL Setup Labor Hours IYSVSETL - From F4102
QUED Queue Hours IYSVQUED - From F4102
STKT 2nd Stocking Type IY$$STKT - From UDC Table F0005
MPST Planning Code IYSVMPST - From F4102
OPC Order Policy Code IYSVOPC - From F4102
OPV Order Policy Value IYSVOPV - From F4102
RQMN Minimum Order Qty IYSVRQMN - From F4102
RQMX Maximum Order Qty IYSVRQMX - From F4102
SAFE Safety Stocks IYSVSAFE - From F4102
RATE Time Basis Rate IYSVRATE - TIMB Conv into Rate
SRKF Shrink Factor IYSVSRKF - From F4102
SRNK Shrinkage IYSVSRNK - From F4102
MULT Multiple Order Qty IYSVMULT - From F4102
FRMP From Potency IYSVFRMP - From F4102
THRP Thru Potency IYSVTHRP - From F4102
FRGD From Grade IYSVFRGD - From F4102
THGD Thru Grade IYSVTHGD - From F4102
VEND Vendor Number IYSVVEND - From F4102
WRHR Work Hours IYSVWRHR - From F3009
UOM1 Primary UOM IYSVUOM1 - From F4101
SNS Rounding Flag IYSVSNS - From F4101
CLEV Cost Level IYSVCLEV - From F4101
OT1Y Potency Control Flag IYSVOT1Y - From F4101
STDP Standard Potency IYSVSTDP - From F4101
TFLA Standard UOM Conversion IYFrom F4101
EV02 Warning Message flag IYFrom UDC Msg $@A
EV03 Decrease Message flag IYFrom UDC Msg $@L
EV04 Increase Message flag IYFrom UDC Msg $@G
DSC1 Lead Time Zero Msg Desc IYVTX001
DSC1 Planned Order Exceeds MOQ Msg DescIYVTX006
DSC1 Planned Order Exceeds FOQ Msg DescIYVTX007
DSC1 Required Start Before Beginning Msg DescIYVTX008
DSC1 Manual Adjustment Necessary Msg DescIYVTX011
DSC1 Increase FPO Msg Desc IYVTX017
DSC1 Decrease FPO Msg Desc IYVTX018
DSC1 Expedite FPO Msg Desc IYVTX019
DSC1 Defer FPO Msg Desc IYVTX020
DSC1 Cancel FPO Msg Desc IYVTX021
DSC1 Expedite In Damper Days Msg DescIYVTX022
DSC1 Defer In Damper Days Msg Desc IYVTX023
DSC1 Shop Calender Not Setup Msg DescIYVTX010
EV04 Work Order Flag IYGlobal Variable $WOFLG
DATE01 Frozen Date IY Global Variable $$FRDT
DATE02 Message Date IY Global Variable $$MSGD
DATE01 Beginning Date IY Global Variable $$BEG
DATE01 End Date IY Global Variable $$ENDD
DATE01 Start Date IYGlobal Variable $FIRST
EV02 Multi Level Flag IY Global Variable $$MRP
EV01 Date Error Flag IYGlobal Variable
EV01 Phantom flag IYProc Option $$PHAN
EV06 Generation Type IProc Option $$GEN
DEFD Defer Damper Days IYProc Option $$DDMP
EXPD Expedite Damper Days IYProc Option $$EDMP
INT02 Mfg Safety Lead Time IYProc Option $$MSLT
INT03 Pur Safety Lead Time IYProc Option $$PSLT
DCTO Pur Order Docu Type IYProc Option $PDCTO
DCTO Work Order Docu Type IYProc Option $WDCTO
UKID F3411 Unique ID I/OY$SUKID for F3411
UKID F3412 Unique ID I/OY $SUKID for F3412
INT01 No of Bucketless Dates IY$$PND
INT01 No of Co/By Products IY$CEND
SRST Work Order Status IYProc Option $USRST
EV05 Process Flag IYProc Option $$PROC
INT01 No of Bucket Elements IY$$PN
MRPD MRP Message Flag I/OY'2' if Messages written ($$MRPD)
EV01 Suppress Error Messages I'1' - Suppress Error Messages
ERRC Error Code O'0' = Success (Default) '1' = Error
in
function
DTAI Error Message ID O' ' - Success '3143' = Error
PID Program ID I
EV01 Work Order Adjust Flag IY@Q,6
EV01 Consolidation Method IY
MCU Date Branch IY
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnJobNumber | JOBS | MATH_NUMERIC | NONE | NONE |
The job number (work station ID) which executed the particular job. | ||||
szComputerID | CTID | char | NONE | NONE |
szBranch | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
mnShortItemNumber | ITM | MATH_NUMERIC | NONE | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
cLeadtimeType | MRPP | char | NONE | NONE |
A code that determines whether the system uses fixed or variable leadtimes.
This code works in conjunction with the value from either the
| ||||
mnLeadtimeLevel | LTLV | MATH_NUMERIC | NONE | NONE |
A value that represents the leadtime for an item at its assigned level in the production process, as defined on Plant Manufacturing Data.
| ||||
mnLeadtimePerUnit | LTPU | MATH_NUMERIC | NONE | NONE |
The total number of hours required to build one unit as specified on the routing. This value is factored by the time basis code.
You can enter
| ||||
cStockingType | STKT | char | NONE | NONE |
A user defined code (41/I) that indicates how you stock an item, for example, as finished goods or as raw materials. The following stocking
| ||||
mnSetupLaborHours | SETL | MATH_NUMERIC | NONE | NONE |
The standard setup hours that you expect to incur in the normal completion of this item. This value is not affected by crew size. | ||||
mnQueueHours | QUED | MATH_NUMERIC | NONE | NONE |
The total hours that an order is expected to be in queue at work centers and moving between work centers.
The system stores this value in
| ||||
c2ndStockingType | STKT | char | NONE | NONE |
A user defined code (41/I) that indicates how you stock an item, for example, as finished goods or as raw materials. The following stocking
| ||||
cPlanningCode | MPST | char | NONE | NONE |
A code that indicates how Master Production Schedule (MPS), Material Requirements Planning (MRP), or Distribution Requirements
| ||||
cOrderPolicyCode | OPC | char | NONE | NONE |
A code that specifies the rules for inventory reordering in the Requirements Planning and Procurement systems. Valid values are:
0
Reorder
| ||||
mnOrderPolicyValue | OPV | MATH_NUMERIC | NONE | NONE |
A value that the system uses in conjunction with the order policy code to represent one of the following:
o When you select order policy
| ||||
mnMinimumOrderQty | RQMN | MATH_NUMERIC | NONE | NONE |
The minimum order quantity for an item. You can base the quantity on factors other than usage, such as perishability, storage capacity, and
| ||||
mnMaximumOrderQty | RQMX | MATH_NUMERIC | NONE | NONE |
The maximum order quantity for an item. You can base the quantity on factors other than usage, such as perishability, storage capacity,
| ||||
mnSafetyStocks | SAFE | MATH_NUMERIC | NONE | NONE |
The quantity of stock kept on hand to cover high-side variations in demand. | ||||
mnTimeBasisRate | RATE | MATH_NUMERIC | NONE | NONE |
A code used to define rate information in the General Rate/Message Records table (F00191). | ||||
cShrinkFactorMethod | SRKF | char | NONE | NONE |
A value that determines whether the shrink factor you enter for this item is a percentage or a fixed quantity. Valid values are:
%
| ||||
mnShrinkFactor | SRNK | MATH_NUMERIC | NONE | NONE |
A fixed quantity or percentage that the system uses to determine inventory shrinkage for an item. The system increases the planned order
| ||||
mnMultipleOrderQty | MULT | MATH_NUMERIC | NONE | NONE |
A multiple for rounding up planned order quantities in MPS/MRP. The system rounds up the planned order quantity to the nearest multiple
| ||||
mnFromPotency | FRMP | MATH_NUMERIC | NONE | NONE |
A number that indicates the minimum potency or percentage of active ingredients acceptable for an item.
The system displays a warning
| ||||
mnThruPotency | THRP | MATH_NUMERIC | NONE | NONE |
A number that indicates the maximum potency or percentage of active ingredients that is acceptable for an item.
The system displays a
| ||||
szFromGrade | FRGD | char | NONE | NONE |
A user defined code (40/LG) that indicates the minimum grade that is acceptable for an item.
The system displays a warning message if
| ||||
szThruGrade | THGD | char | NONE | NONE |
A user defined code (40/LG) that indicates the maximum grade that is acceptable for an item.
The system displays a warning message if
| ||||
mnVendorNumber | VEND | MATH_NUMERIC | NONE | NONE |
The address book number of the preferred provider of this item. | ||||
mnWorkHours | WRHR | MATH_NUMERIC | NONE | NONE |
The number of work hours that the manufacturing plant operates per day. | ||||
szPrimaryUnitOfMeasure | UOM1 | char | NONE | NONE |
A user defined code (00/UM) that identifies the unit of measure that the system uses to express the quantity of an item, for example, EA
| ||||
cRoundingFlag | SNS | char | NONE | NONE |
A code that determines whether the system performs rounding for planning purposes. Valid values are:
R Round either up or down to the
| ||||
cCostLevel | CLEV | char | NONE | NONE |
A code that indicates whether the system maintains one overall inventory cost for the item, a different cost for each branch/plant, or a
| ||||
cPotencyControlFlag | OT1Y | char | NONE | NONE |
A code that indicates whether you control the item by potency. | ||||
mnStandardPotency | STDP | MATH_NUMERIC | NONE | NONE |
The percentage of active ingredients normally found in an item. | ||||
szStandardUOMConversion | TFLA | char | NONE | NONE |
Allows you to bypass the item-specific unit of measure and use the standard unit of measure. Valid values are:
blank Use the item-specific
| ||||
cWarningMessageFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cDecreaseMessageFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cIncreaseMessageFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szLeadTimeZeroMsgDesc | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
szPlanOrderExceedsMOQMsgDesc | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
szPlanOrderExceedsFOQMsgDesc | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
szReqdStartBeforeBeginMsgDesc | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
szManualAdjustReqdMsgDesc | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
szIncreaseFPOMsgDesc | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
szDecreaseFPOMsgDesc | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
szExpediteFPOMsgDesc | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
szDeferFPOMsgDesc | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
szCancelFPOMsgDesc | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
szExpediteInDamperDaysMsgDesc | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
szDeferInDamperDaysMsgDesc | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
szShopCalendarNotSetupMsgDesc | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
cWorkOrderFlag | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
jdFrozenDate | DATE01 | JDEDATE | NONE | NONE |
Event point for JDE Date. | ||||
jdMessageDate | DATE01 | JDEDATE | NONE | NONE |
Event point for JDE Date. | ||||
jdBeginningDate | DATE01 | JDEDATE | NONE | NONE |
Event point for JDE Date. | ||||
jdEndDate | DATE01 | JDEDATE | NONE | NONE |
Event point for JDE Date. | ||||
jdStartDate | DATE01 | JDEDATE | NONE | NONE |
Event point for JDE Date. | ||||
cMultiLevelFlag | EV03 | char | NONE | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
cDateErrorFlag | EV03 | char | NONE | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
cPhantomFlag | EV03 | char | NONE | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
cGenerationType | EV03 | char | NONE | NONE |
A radio button that specifies the level at which trace/track result is to be displayed. Select the Detail to display all transactions except IB, IX,
| ||||
mnDeferDamperDays | DEFD | MATH_NUMERIC | NONE | NONE |
mnExpediteDamperDays | EXPD | MATH_NUMERIC | NONE | NONE |
nPurSafetyLeadtime | INT02 | integer | NONE | NONE |
Number of Days in the Past to Query for Quote Requests Received. | ||||
nMfgSafetyLeadtime | INT03 | integer | NONE | NONE |
Event point for Integer. | ||||
szWorkOrderType | DCTO | char | NONE | NONE |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
szPurchaseOrderType | DCTO | char | NONE | NONE |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
mnF3411UniqueID | UKID | MATH_NUMERIC | NONE | NONE |
This field is a unique number used to identify a record in a file. | ||||
mnF3412UniqueID | UKID | MATH_NUMERIC | NONE | NONE |
This field is a unique number used to identify a record in a file. | ||||
nNumBucketlessDates | INT01 | integer | NONE | NONE |
Number of Days in Future to Query for Responses Due. | ||||
nNumCoByProducts | INT01 | integer | NONE | NONE |
Number of Days in Future to Query for Responses Due. | ||||
nNumBucketElements | INT01 | integer | NONE | NONE |
Number of Days in Future to Query for Responses Due. | ||||
szWorkOrderStatus | SRST | char | NONE | NONE |
A user defined code (00/SS) that describes the status of a work order, rate schedule, or engineering change order. Any status change from
| ||||
cProcessFlag | EV05 | char | NONE | NONE |
A flag that indicates whether automatic spell check is turned on. | ||||
cMRPMessageFlag | MRPD | char | NONE | NONE |
This code may be used as an additional field to select Item information to print on reports. Once values are loaded into this field, The
| ||||
cSuppressErrorMessages | EV06 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cErrorCode | ERRC | char | NONE | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
szErrorMessageID | DTAI | char | NONE | NONE |
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
| ||||
szJobNumberString | JOB | char | NONE | NONE |
Job Number | ||||
szProgramId | PID | char | NONE | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
cWorkOrderAdjustFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cConsolidationMethod | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szDateBranch | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
mnReorderQuantity | ROQI | MATH_NUMERIC | NONE | NONE |
The estimated reorder quantity for an item. You can enter this quantity if there is not enough sales history available for the system to
| ||||
szRateOrderType | DCTO | char | OPT | NONE |
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
| ||||
cMnWkDyHr | MWDH | char | OPT | NONE |
A code that determines the frequency of the schedule. Valid values are: 1 Monthly 2 Weekly 3 Daily 4 Per Shift (for future use) | ||||
cExtendRate | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnUniqueKeyIDOffset | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. | ||||
mnLotEffectiveDefaultDays | LEDD | MATH_NUMERIC | OPT | NONE |
The number of days that an item must remain in inventory before the system considers the item to be available for sales and manufacturing
|
B3400450 MRP, Write Lower Level Pegging Records from BOM | ||||
B3400540 MRP, Calculate Schedule Dates for Planning | ||||
B3401270 Cache, Process MRP Bucketless Dates | ||||
B3401280 Cache, Process MRP Co/By Products | ||||
B3401310 Cache, Process MRP Work Orders | ||||
B3401340 MRP, Return Work Days | ||||
B3401540 Cache, Process MRP Batch Bills | ||||
B4000520 Get Item UoM Conversion Factor | ||||
B4001120 Calculate EOQ and ROP | ||||
B9800100 Get Audit Information | ||||
B9800420 Get Data Dictionary Definition | ||||
XF4105 Item Cost I/O |
F3002 Bill of Material Master File | ||||
F3111 Work Order Parts List | ||||
F3404 Co-Products Planning/Costing Table | ||||
F3411 MPS/MRP/DRP Message File | ||||
F3412 MPS/MRP/DRP Lower Level Requirements File | ||||
F34UI005 MRP Orders/Requirements User Index-Process Item | ||||
F34UI006 MRP Co/By Product Net Quantity User Index | ||||
F4101 Item Master | ||||
F4102 Item Branch File |