MRP Troubleshooting Guide (R3483)

Purpose of Document

This note is to discuss general routine of R3483 to help you to troubleshoot further.

his note is not completed yet
- detail routine will be added with flowchart
- detail DML statement will be added in adding supply/demand cache
- detail parameters are to be implemented for each business functions (updated on 10 Aug 2012)

R3482 shall be prepared in different note because routine between R3482 and R3483 are very much different from each other. In R3482 demand and supply information gets called from R3482 directly but in R3483 these information is to be handled by N3500110 - MRPMultiplePlantLoadAndPlan (MRP, Multiple Plant Load and Plan).

The purpose of this document is to help troubleshooting or possibly narrow down the issue through simplified routine of MRP. Note that this document is written based on EnterpriseOne application release 9.1

Table of Contents:

Layout of R3483

Business Functions implemented in Report Level Events
Business Functions implemented in Sections
Others

Layout of R3483 (Master Planning Schedule - Multiple Plant):

Report Level

Initialize Report: Report Level Initialization including parallel processing

Section Level

Read Item Branch Records (Read Item Branch Records and Build UI)

Initialize Section: Make data selection against F4102 (Item Branch File)
Do Section: Edit, Validate, Create Cache for message
End Section: Write messages based on cache created during Do Section

(Conditional) Write Time Series for CoBy Products

Do Section

Report Level

End Report: Terminate cache, close tables and ends parallel processing

Note:

Do Section events read data from target table row by row whereas all other events are getting called only once in a routine
Conditional section [Write Time Series for CoBy Products] can be called when item handled in [Read Item Branch Record] is not a process item (then check if the item is a Co-Product). If it is co-by product and it is consolidation mode
Report level event can be accessed via Report Design Aid > File > Event Rule Operations > Edit Report Level Event Rules

Before start:
- Refer below flow chart to have simplified routine for R3483 (based on consolidation method 1)

MRP Flow - Method1

- Make it sure you have set routine to write UI files (size of work file and information written in it)
#describe further detail on the size of cache vs. workfile F34UI005, F34UI006

Business Functions implemented in Report Level Events
Initialize Report: This event initialize the cache to be used in the routine. This events gets fired before main section handles data selection and data sequence. And this event has to be working with a pair with "End Report" event.

Source	BSFN	Table Reference	Purpose	Others
N40R0940	IsDemandSchedulingDelivered (Is Demand Scheduling Delivered For Use)	N/A	To check whether to populate Demand Scheduling. By default this module is active which is enhancement piece for Automotive Industry	Not In Use. Only when PO cUseForecastConsumption is '2' System Code: 40R - Demand Scheduling Obsolete: UDC 00/RE against code 'DS' to get Special Handling Code
B3401360 #ref1	ProcessMessagesBeginDoc (Process Messages Begin Doc)	N/A	Initialize MRP process by getting Job Number and Machine ID 1. Retrieve Computer ID: this will be used basic key for cache to be created along the process 2. Get Job Number: lJobNumber = JDB_GetInternalNextNumber(); *JobNumber set here will be used till end of routine	Master Business Function to handle MRP Messages, which is made up of * ProcessMessagesBeginDoc * ProcessMessagesEditLine * ProcessMessagesEndDoc As we can see above this function does not have End Doc routine because commitments are performed by other functions.
B3400520 #ref2	UpdateF4102PrintCode (F4102 Update Print Code)	F4102	This function duplicates the functionality of the RPG program P34815, Update MPS/MRP Print Code. The function sets the Item Display Code (MRPD) column of all records in the Item Branch table (F4102) to blank (' '). The purpose of the function is to blank out the Item Display Code (MRPD) in each record in the Item Branch table (F4102).	Table Reference: F4102 (MCU,ITM,MRPD) This function gets called only when the Processing Option item #3. Initialize MPS/MRP Print Code (in Performance Tab) is 1 (=Initialize the Item Branch file)
B3401280 #ref3	CacheProcessMRPCoByProducts (Cache, Process MRP Co/By Product)	N/A	This function manages access to the MRP Co/By Products Cache. The function will perform Get, Add, Update, Delete, Delete All, Get Next, Add/Update, and Terminate accesses on the cache for the MRP/MPS planning programs R3482 and R3483.	MRP_COBY_PROD_CACHE_ID: "CB" (ID used to form Co/By Product Cache name) MAX_NUM_COBY_PROD_CACHE_KEYS = 2 (szBranch, mnShortItemNumber) Cache cCacheActionCode = 'I' (Check to see if the cache has already been created. If not, setup the structure specifying how the MRP Co/By PRoduct Cache is indexed and create the cache.)
B3500060 #ref4	CacheProcessMultiPlants (Cache, Process Multi Plants)	N/A	This function will perform Get, Add, Update, Delete, Delete All, Get Next, Add/Update, and Terminate functions on the MRP Multi-Plants Cache used in the Multi-Plant MRP/MPS planning programs (R3483). The calling application is responsible for loading all appropriate key values to the data structure and identifying the number of keys to use in retrieval/update processes. Number of Keys: If the number of keys is passed as a parameter, the business function uses this value to setup key values for a Get, Update, Delete, Get Next and Add/Update, as well as Mode '9'. A zero may be passed to retrieve, update, or delete the first record. When action code GET is used, the function saves the cache cursor pointer if the fetch is successful and SequentialFetch = ‘1’. This allows the calling application to use GET NEXT to fetch elements from the cache sequentially. If GET NEXT is called until the end of the keyed cache dataset is found, the function automatically closes the open cursor. Otherwise, the calling application is responsible for closing the cursor Special Logic: This function creates a unique cache for each Multi-plant MRP/MPS planning process. The function appends the input Job Number string to the two character ID 'MP' to build the cache name used for the calling application.	MRP_CACHE_ID: "MP" (ID used to form Date Cache name) MAX_NUM_CACHE_KEYS = 2 (cRecordType, szBranch) cCacheActionCode = 'I' (This function retrieves the handle for the Multi-Plant Cache. If the cache does not exist, it is created)
B3500140 #ref5	CacheProcessMultiplantSequence (Cache, Process Multiplant Sequence)	N/A	This Cache Function replaces the user index table F35UI001. This function performs Get, Add, Update, Delete, Delete All, Get Next, Add/Update, and Terminate functions on the Multiplant Quantity Cache used in the MRP/MPS planning program, R3483. This Cache functions uses multiple indices.	MULTIPLANT_CACHE_ID: "PM" (ID used to form Item Quantity Cache name) MAX_NUM_CACHE_KEYS = 3 - (Index 1) mnJobNumber, szComputerID, szBranch - (Index 2) OR, mnJobNumber, szComputerID, mnBranchSequence cCacheActionCode = I (This function retrieves the handle for the MRP Item Quantity Cache. If the cache does not exist, it is created.)
B3401300 #Ref6	CacheProcessMRPInclusionRules (Cache, Process MRP Inclusion Rules)	F34004	This function performs Get, Add, Update, Delete, Delete All, Add/Update, and Terminate functions on the MRP Inclusion Rules Cache used in the MRP/MPS planning programs, R3482 and R3483.	RP_RULES_CACHE_ID: "IR" (ID used to form Inclusion Rules Cache name) MAX_NUM_RULES_CACHE_KEYS = 3 (szOrderType, szStatus, szLineType) #Indicate all the Functions which call B3401300 #Refer detail below,
B3401310 #ref7	CacheProcessMRPWorkOrders (Cache, Process MRP Work Orders)	N/A	This function will perform Get, Add, Update, Delete, Delete All, Get Next, Add/Update, and Terminate functions on the MRP Work Order Cache used in the MRP/MPS planning programs (R3482 and R3483).	MRP_WO_CACHE_ID: "WO" (ID used to form Work Order Cache name) MAX_NUM_WO_CACHE_KEYS = 5 (mnShortItemNumber, szBranch, jdDate, mnProductionNumberShort, mnOrderNumber) cCacheActionCode = I (This function retrieves the handle for the MRP Work Order Cache. If the cache does not exist, it is created.)
B3401320 #ref8	CacheProcessMRPPurchaseOrders (Cache, Process MRP Purchase Orders)	N/A	This function will perform Get, Add, Update, Delete, Delete All, Get Next, Add/Update, and Terminate functions on the MRP Purchase Order Cache used in the MRP/MPS planning programs (P3482 and P3483).	MRP_PO_CACHE_ID: "PO" (ID used to form Purchase Order Cache name) MAX_NUM_PO_CACHE_KEYS = 9 (mnShortItemNumber, szBranch, jdPromisedDeliveryDate, mnProductionNumberShort, mnOrderNumber, szOrderType, szCompany, szOrderSuffix, mnLineNumber) cCacheActionCode = I
B3401340 #ref9	MRPReturnWorkDays (MRP, Return Work Days)	F0007	This function will handle all cache operations for the D2 Cache for MRP programs as well as calculations of work days for WO Start Dates < the First WD After the Generation Start Date. The calling application/business function must call this function again to destroy the D2 cache. R3482/R3482 should do this when they destroy all other caches.	D2_CACHE_NAME: "D2" (ID used to form Work Day Calendar Cache Name) MAX_NUM_D2_CACHE_KEYS = 3 (szBranch, nType, jdDate) This function follows unique cache action code (refer this)
B3401530 #ref10	CacheProcessMRPBillofMaterial (Cache, Process MRP Bill of Material)	N/A	This function performs Get, Add, Update, Delete, Delete All, Get Next, Add/Update, and Terminate functions on the MRP Bill of Materials Cache used in R3482/R3483.	MRP_BOM_CACHE_ID: "MBM" (MRP Bill of Materials Cache name) MAX_NUM_BOM_CACHE_KEYS = 7 (szTypeBill, mnItemNumberShortKit, szCostCenterAlt, mnUnitsBatchQuantity, mnIdentifierShortItem, szBranchComponent, mnComponentNumber)
B3401540 #ref11	CacheProcessMRPBatchBills (Cache, Process MRP Batch Bills)	N/A	This function handle all cache operations for the BBM Cache.	MRP_BOM_CACHE_ID : "BBM" (Batch Bill of Materials Cache) MAX_NUM_BOM_CACHE_KEYS = 5 (szTypeBill, mnItemNumberShortKit, szCostCenterAlt, cCoproductsByproducts, mnUnitsBatchQuantity)
B3401720 #ref12	CacheProcessMRPLots (Cache, Process MRP Lots)	N/A	This function handle all cache operations for the LOT Cache.	MRP_LOT_CACHE_ID : "LOT" (ID used to form Lot Cache name) MAX_NUM_LOT_CACHE_KEYS = 3 cCacheActionCode = '5' delete based on (szBranch, dLotExpirationDate) CACHE_ADD (2) or CACHE_UPDATE (3) or CACHE_DELETE (4) Set the number of keys to 3 and index to 1 then get cache records based on (szBranch, szLotNumber, szLocation) IF action code is CACHE_GET (1) or CACHE_GETNEXT (6) Determine if using Index 1 or 2 and load fields correspondingly. (Index = 1) based on (szBranch, szLotNumber, szLocation) (Index = 2) based on (szBranch)
B3401300 #ref6	CacheProcessMRPInclusionRules (Cache, Process MRP Inclusion Rules)		Refer above	cCacheActionCode Multiple calling - refer event rule
B3400490 #ref13	MRPGetMRPParameters (MRP, Get MRP Parameters)	F4101, F4102, F3403, F3404, F0005, F3111, F3405, F3412, F3462, F4801	This function checks the existence of the MRP parameters and returns the value to the Planning program. This is executed once at the beginning of the MRP program to get the common values to be used for all the items in the run.	Determine to caching Caching F4101,F4102 and F4801 File by reading UDC 34/PC (or PO szPlanningControlUDCType) where Code Type is 'DC' to get Special Handling Code. For detail, refer to <Document 657053.1> E1: 34: R3482/R3483 MRP Cached Tables Can Improve MRP Performance Refer additional section below for detail mapping.
N3401830 #ref14	MRPUKIDGeneratorDeletionByBranch (MRP, UKID Generator & Deletion By Branch)	F3411, F3412	This NER performs the initial clearing of planning tables and also generates the starting Unique Key ID for tables F3411 and F3412. It is called from either R3482 or R3483 when they are running in the normal or the subsystem (parallel) mode	Multiple call - check event rule Ref#1
N3401620 #ref15	MRPParallelRetrieveHighestLow (MRP, Parallel Retrieve Highest Low Level Code	F4101	This business function will return Highest Low Level Code Available in the system which will be used in Parallel Processing of R3482 and R3483	Returns F4101.LLX where F4101.LLX > 0
B3401580 #ref16	MRPParallelDelSubsystmTriggerRec (MRP, Parallel Delete SubsystmTrigger Records)	F3420, F4102, F986113	This Business function interacts with Subsystem Job Master File (F986113)	cActionCode = 'D' (Delete existing records) Deleting from F3420-Semphore Table based on (szProgramId, szVersion) cActionCode = 'E' (End Subsystem Processing) 1. check that 0 are left in a R W state before inserting End records 2. Fetch by ReportName, VersionName, and Operation equal to 'R' (F986113.PID, VERS, OPCR ) 3. Insert records JOBSTS="R" OPCR="E" to End or Kill record (Trigger against F986113 will terminate equivalent job based on Insert)
B3401580 #ref17	MRPParallelChkSubsytmTriggerRec (MRP, Parallel Check SubsystmTrigger Records)	F986113	Check whether Subsystem Job Master Table has data based on szProgramID, szVersion and cOp	based on (F986113.PID, VERS, OPCR )
B3401580 #ref18	MRPParallelAddSubsystmTriggerRec (MRP, Parallel Add Subsystem Trigger Records)	F3420, F4102, F986113	This function adds records to Subsystem Master file for Discrete Manufacturing	Refer below detail routine: (#create a new section for I_B3401580_Load_SubsystemMaster_R3483) because this is pretty much complicate routin
B3500140 #ref5	CacheProcessMultiplantSequence (Cache, Process Multiplant Sequence)		Refer above	this is to Reset Job Number for Subsequent Jobs

Note:

List above may only show BSFN but in this event lots of parameters are initialized/set. For further detail, refer to <Document 1344759.1> E1: 34: R3482 & R3483 Understanding MRP Parameters
If you set PO cNetChaneFlag = '1' then which calls R3484|XJDE0001 to set Net Change Flag (F4102.MRPC) for all the Item Branch Records requiring processing for Net Change Mode
Deletion of F34UI005 can take place
The parameters for cache functions above are,
- szJobNum - JobNumber as string
- hUser - environment handle
- lphCache - cache handle

Cache Information:
This report uses cache heavily so information on cache is important which can be describe as below,

The length of cache name (MAX_CACHE_NAME_LEN) = 10 (10 characters which is 20 bytes in Unicode environment)

Cache Action Code

Value	Cache Action	Others
1	CACHE_GET	Return the first element in the cache matching the input key. If NumberOfKeys = 0, return the first element in the cache. 1. Open cursor, Reset cursor. 2. Retrieve the first element on the cache matching the key values passed as input. If the input Number of Keys is zero, fetch the first element in the cache. 3. Load the values from the retrieved element into the data structure to be passed back to the calling program. 4. If Sequential Fetch is '1' then return the cursor pointer to the calling application. Otherwise close the cursor. 5. If get fails set Cache Error Code = '6'.
2	CACHE_ADD	Add a new element to the cache with the input data values. 1. Insert a new cache element with values from data structure. 2. If add fails set error "032E", set Cache Error Code = '4', and return failure.
3	CACHE_UPDATE	Update the existing cache element matching the key values with the input data. If NumberOfKeys = 0, update the first cache element. 1. Update existing cache element with values from data structure. 2. If update fails set error "032E", set Cache Error Code = '4', and return failure.
4	CACHE_DELETE	Delete all cache elements matching the key values. If NumberOfKeys = 0, delete the first cache element. 1. If the Number of Keys is not 0, delete all elements in the cache matching the key values passed as input. 2. If the number of keys is 0, delete the first cache element. 3. If delete fails, set Cache Error Code = '5'.
5	CACHE_DELETE_ALL	Delete all elements from the cache. 1. Delete all elements in the cache. 2. If delete fails, set Cache Error Code = '5'.
6	CACHE_GET_NEXT	Get the next cache element matching the input key values using the input Cursor Pointer. 1. Retrieve the next element in the cache matching the key values passed as input (the cursor should have been set through a previous "Get" action, i.e. action code '1'. If the Number of Keys is zero then fetch the next record without using any key). 2. Load the values from the retrieved element into the data structure to be passed back to the calling program. 3. If there are no more elements, close the cursor, remove the cursor pointer and set Cache Error Code = '1'.
7	CACHE_ADD_UPDATE	If an element already exists in the cache with the key values, update the element with the input data. Otherwise, add a new element to the cache with the input data values. 1. Delete Record , if one exists, that matches the full key from Input. 2. Insert a new cache element with values from data structure. 3. If add fails set error "032E", set Cache Error Code = '4', and return failure.
8	CACHE_TERMINATE	Destroy the cache. If the input cursor pointer is not zero, close the cursor. 1. Perform cleanup functions (Terminate cache).
9	CACHE_CLOSE_CURSOR	Close the input Cache Cursor and free the data pointer. 1. If Cache Cursor Ptr <> 0 2. Remove Data Ptr 3. Close Cursor 4. Cache Cursor Ptr = 0
C	SYSTEM_CACHE_CLEAR	(Not all Cache operations call this) Clear System Cache This is to Clear Database Cache by calling API JDB_ClearTableDBCache for F4101, F4102 and F4801
L	CACHE_LOAD	(Not all Cache functions use this action code.) Load the cache with all inclusion rule data for the input Resource Inclusion Version
N	CACHE_GET_NEAREST	(Not all Cache functions use this action code.) Retrieve the cache element matching the input Item, Branch and Date. If the matching Date isn't found, retrieve the element with the date just before or after the input date based on the input ComparisonFlag
I	CACHE_INIT	Cache has been initialized
E	CACHE_GET_ELEMENTS	(Not all Cache function makes use this cache action code.) Used in B3500060 to get the number of elements matching the keys specified, Record Type and/or Branch.
D	CACHE_DEBUG	Dump the contents of the cache to a disk file for debugging analysis. 1. Dump contents of entire cache into text file.

Note that cCacheActionCode L, N, E are depends on cache functions (Not all business functions listed above will call this action code)

Returns

Value	Cache Action
0	CACHE_SUCCESS
1	CACHE_END_OF_DATA
2	CACHE_INVALID_INPUT
3	CACHE_CREATE_FAILED
4	CACHE_ADD_FAILED
4	CACHE_UPDATE_FAILED
4	CACHE_ADD_UPDATE_FAILED
5	CACHE_DELETE_FAILED
6	CACHE_FETCH_FAILED

Cache Acton Code in B3401340 - MRPReturnWorkDays (MRP, Return Work Days)

Value	Cache Action	Others
G	CACHE_GET	Return the first element in the cache matching the input key. If NumberOfKeys = 0, return the first element in the cache.
I	CACHE_INSERT	Add a new element to the cache with the input data values
R	CACHE_RETURN	Get the next cache element matching the input key values using the input Cursor Pointer
T	CACHE_DESTROY	Delete all cache elements matching the key values. If NumberOfKeys = 0, delete the first cache element.
X	CACHE_DELETEALL	Delete all elements from the cache.
Z	CACHE_INITCACHE	Cache has been initialized

Returns for B3401340 - MRPReturnWorkDays (MRP, Return Work Days)

Value	Cache Action
0	CACHE_SUCCESS
1	CACHE_RETURNFAILED
2	CACHE_GETFAILED
3	CACHE_CREATEFAILED
4	CACHE_SFC_CALENDAR_ERROR

Business Functions implemented in Report Level Events:
End Report: This event gets fired after R3483 handled all the routines to terminate/clear cache based on mnJobNumber and szComputerID which was set by ProcessMessagesBeginDoc in 'Initialize Report' section which is Report Level event.

Below routine repeats, destroy a specific cache created in Report Initialize and Do Section event. If the input cursor pointer is not zero, close the cursor.

Source	BSFN	Table Reference	Purpose	Others
B3500140 #ref5	CacheProcessMultiplantSequence (Cache, Process Multiplant Sequence)	N/A	Refer Initialize section above. Delete all cache elements matching the input key values (partial or full key). If NumberOfKeys = 0, delete the first cache element.	cCacheActionCode = '4' (To Delete 'PM' Cache) based on mnJobNumber and szComputerID nNumberOfKeys = '2' nIndexNumber = '1'
B3500060 #ref4	CacheProcessMultiPlants (Cache, Process Multi Plants)	N/A	Destroy the cache "MP". If the input cursor pointer is not zero, close the cursor.	cCacheActionCode = '8' Destroy the cache. If the input cursor pointer is not zero, close the cursor Parameters: hCache - cache handle lpDS - pointer to BsFn data structure hUser - environment handle
B3401290 #ref19	CacheProcessMRPItemQuantities (Cache, Process MRP Item Quantities)	N/A	Destroy the cache "IQ". If the input cursor pointer is not zero, close the cursor.	cCacheActionCode = '8' This function is calling I3401290_ClearSystemCache which calls JDB_ClearTableDBCache for table F4101, F4102, F4801.
B3401300 #ref6	CacheProcessMRPInclusionRules (Cache, Process MRP Inclusion Rules)	N/A	Destroy the cache "IR".	cCacheActionCode = '8'
B3401310 #ref7	CacheProcessMRPWorkOrders (Cache, Process MRP Work Orders)	N/A	Destroy the cache "WO". If the input cursor pointer is not zero, close the cursor.	cCacheActionCode = '8' Example of code: I3401310_CacheCloseCursor(lpHcache, lpDS, hUser); jdeCacheTerminateAll(hUser, lpHcache); *lpHcache = (HCACHE) NULL;
B3401320 #ref8	CacheProcessMRPPurchaseOrders (Cache, Process MRP Purchase Orders)	N/A	Destroy the cache "PO". If the input cursor pointer is not zero, close the cursor.	cCacheActionCode = '8'
B3401270 #ref20	CacheProcessMRPBucketlessDates (Cache, Process MRP Bucketless Dates)	N/A	Destroy the cache "DT". If the input cursor pointer is not zero, close the cursor.	cCacheActionCode = '8'
B3401340 #ref9	MRPReturnWorkDays (MRP, Return Work Days)	N/A	Terminate Cache "D2".	cCacheActionCode = 'T' - Terminate Cache
B3500140 #ref5	CacheProcessMultiplantSequence (Cache, Process Multiplant Sequence)	N/A	Destroy the cache "PM". If the input cursor pointer is not zero, close the cursor.	cCachActionCode = '8'
B3401720 #ref12	CacheProcessMRPLots (Cache, Process MRP Lots)	N/A	Destroy the cache "LOT". If the input cursor pointer is not zero, close the cursor.	cCachActionCode = '8'
B3401530 #ref10	CacheProcessMRPBillofMaterial (Cache, Process MRP Bill of Material)	N/A	Destroy the cache "MBM". If the input cursor pointer is not zero, close the cursor	cCachActionCode = '8'
B3401540 #ref11	CacheProcessMRPBatchBills (Cache, Process MRP Batch Bills)	N/A	Destroy the cache "BBM". If the input cursor pointer is not zero, close the cursor.	cCachActionCode = '8'
B3401580 #ref16	MRPParallelDelSubsystmTriggerRec (MRP, Parallel Delete Subsystm Trigger Records)	F986113	When report was running in Subsystem Mode. Refer Initialize Report Section.	cActionCode = 'E' - End Subsystem Job Note that Insert a new records triggers Terminate Job in Job Master and End Subsystem.

Note:

Manual Deletion takes place in this event (F34UI005, F34UI006)

Business Functions implemented in Report Level Events

Initialize Section:
sql> SELECT IBITM, IBLITM, IBAITM, IBMCU, IBPRP4, IBVEND, IBANPL, IBBUYR, IBROQI, IBRQMX, IBRQMN, IBSAFE, IBLOTS, IBOT1Y, IBSTDP, IBFRMP, IBTHRP, IBFRGD, IBTHGD, IBSTKT, IBMPST, IBMRPD, IBMRPC, IBLTLV, IBOPC, IBOPV, IBLTPU, IBMPSP, IBMRPP, IBMTF1, IBMTF2, IBMTF3, IBMOVD, IBQUED, IBSETL, IBSRNK, IBSRKF, IBTIMB, IBMULT, IBLLX, IBUSER, IBPID, IBJOBN, IBUPMJ, IBTDAY, IBLEDD, IBPEFD FROM PRODDTA.F4102 WHERE ( ( IBMPST = '1' AND IBMCU IN ( ' M10',' M20',' M30' ) AND IBPRP4 IN ( '200','240' ) ) ) ORDER BY IBMCU ASC,IBLLX ASC,IBITM ASC
Note: This data selection is important because this determines how to fetch data from F4102 and what are the columns to be handled in the routine.

(Main Section) Read Item Branch Records (and write UI)

Initialize Section: Make data selection against F4102 (Item Branch File)
: This section is mainly to handle how to handle data selection and data sequence. This routine gets called only once when R3483 gets submitted.

Do Section: Edit, Validate, Create Cache for message

Create controlling values in cache
Read Demand and Supply information and save it into cache

        1. Keep trace of current Low Level Code (F4102.LLX)
        2. If running Net Change, skip non-net changed records (F4102.MRPC =1)
        3. Bypass non-planned item (F4102.MPST = 0)
        4. Find out whether a certain item is Project specific (F0005.SPHD (special handling code) ='P' for STKT (stocking type you are working on) and PO cCustomerAddressRelationship = 1)
        5. Check PMPN Enhancement by reading F4102.PNYN (Production Number Controlled)
                    #describe further on consolidation method (PO cEverestEventPoint13)
                    # consolidation method 1 - the date branch is the Consolidation Branch. User the potency from the consolidation branch. Otherwise, use the potency (F4102.STDP, OT1Y) from the current branch. No Category Code (F4102.PRPX) needed for Consolidation Method 1.
                    # consolidation method 2 - the date branch is the current branch unless there is a date branch specified in the processing option. Determine Category Code for Consolidation Method '2'. This would be the code we are using to define branch relationships. The default is Mater Planning Family (F4102.PRP4 - UDC 41/P4).

        6. Determine Saftty Stocks Value and Date Branch for the first occurence of the current item. Safety Stock (F4102.SAFE) is the accumulation of all branches for the current item. In consolidation method 1, the date branch is the Consolidation Branch
                # Clarify Date Branch here!!!

Business Functions in Main Section
Below functions can be called when MCU (branch/plant is changed. That is, below information is Branch/Plant Specific)

Source	BSFN	Table Reference	Purpose	Others
B3500090 #ref22	MRPMultiPlantSequenceBranchInUI (MRP, Multi-Plant Sequence Branches in UI)	F3403	This function can be called when you handle more than 2 branch/plant. This function will read the available plants to adjust and sequence the order of plants to be process This function will read the available plants in F35UI001 and sequence the order of plants to planned for. This function will read the available plants in multi plant cache and sequence the order of plants to planned for.	Table Reference: F3403 (MMCU, ITM, CMCU, PRPX, BRLV, BRSQ, EXIN, AVLC, EFFF, EFFT) Calling, B3500060 B3500140
B3401580 #ref16	MRPParallelDelSubsystmTriggerRec (MRP, Parallel Delete Subsytm Trigger Records)	F3420, F4102, F986113	This function can be called when B3500090 ends in error to terminate subsystem job when job is running in Parallel mode. This Business function interacts with Subsystem Job Master File (F986113)	cActionCode = E (End) to delete records for status R (running) and set Job master (F986110) status to 'D - Done' or 'E - Error' to exit from subsystem routine cActionCode (specific to this BSFN): D - Deleting Existing Records E - End Subsystem Processing This function can call B3401590 which has cActionCode I (Insert) and U (Update) R3482_MAINLINE_VIEW V4102H R3483_ITEMBRANCH_VIEW V4102V Calling, B3400430 B3401590 B3401670 Key for F4102 in writing F986113: MRPC (=1 only for Net Change Mode) LLX MCU (only for R3482) #describe detail again
N3500110 #ref23	MRPMultiplePlantLoadAndPlan (MRP, Multiple Plant Load and Plan)	all Demand and Supply Tables	This NER module is designed to read the sequence cache and retrieve the branches to be planned for a particular item. The order of records read fro cache is the Branch Sequence (MABRSQ). This assures that MRP is planning the Demand branches first, then the supply branches.	Refer below section on N3500110: In R3282, the business functions which are called by NER N3500110 is called directly from report. So this NER is specific to R3483
B3500140 #ref5	CacheProcessMultiplantSequence (Cache, Process Multiplant Sequence)	N/A	This Cache Function replaces the user index table F35UI001. This function performs Get, Add, Update, Delete, Delete All, Get Next, Add/Update, and Terminate functions on the Multiplant Quantity Cache used in the MRP/MPS planning program, R3483. This Cache functions uses multiple indices.	CacheName: PM cCacheActionCode = 4 (to delete) MULTIPLANT_CACHE_ID: "PM" (ID used to form Item Quantity Cache Name) MAX_NUM_CACHE_KEYS: 3 - (Index 1) mnJobNumber, szComputerID, szBranch - (Index 2) OR, mnJobNumber, szComputerID, mnBranchSequence
B3401290 #ref19	CacheProcessMRPItemQuantities (Cache, Process MRP Item Quantities)	F4101, F4102, F4801	This function is to clear cache when LLX has changed when there is more than 2 items	cCacheActionCode = C (to Clear Cache) JDB_ClearTableDBCache for tables F4101, F4102, F4801 Cache Name: IQ
B3500060 #ref4	CacheProcessMultiPlants (Cache, Process Multi Plants)	N/A	This cache function can be called for various purpose. Whenever there is any change in data (item) this function can be called to retrieve the date information for this (currently working) branch from cache	cRecordType = 'D' (Date) cCacheActionCode = 1 (to Get/Fetch) based on ITM and MCU combination
B3400360 #ref24*	MRPWriteDateBuckets (MRP, Write Date Buckets)	F3405, F0007, F33133	This business function loads the MRP Bucketless Date Cache used in MRP planning program from the work day calendar table F0007 depending on the No of days, weeks and months sent in. It will also flag the bucket dates, and load the number of days in week/month. It will calculate the Start date, End Date, No of Bucket loaded. It will load the past due periods depending on the input.	MAX_CAPACITY_DATES = 56. If you set horizon which is bigger than this value, which shall issue Memory Error. If date information was not found for this branch, call B3400360 to build the date information for the first time. Calling, B3401290.h which references B3401270.h B3401340 Refer detail in below section:
B3500060 #ref4	CacheProcessMultiPlants (Cache, Process Multi Plants)	N/A	Add date information loaded above (B3400360) to multi-plant cache for future retrieval	cRecordType = 'D' (Date) cCacheActionCode = 2 (to Add) based on ITM and MCU combination
B3400360 #ref24	MRPWriteDateBuckets (MRP, Write Date Buckets)	F3405, F0007, F33133	To copy date information from (B3500060 and B3400360) from the date branch to item branch if date branch is being used.	Reference:
B3500140 #ref5	CacheProcessMultiplantSequence (Cache, Process Multiplant Sequence)	N/A	To insert Multiplant Sequence Cache based on information retrieve above	cCacheActionCode = 2 (Add) nIndexNumber = 1
B3400370 #ref25	MRPWriteOnHandLotQtyToCacheA (MRP, Write On Hand/Lot Qty to Cache)	F41021, F4108, F410211, F41021T	Load on-hand quantities and expiry quantities into cache. This function will return the total On Hand Quantity from Location Master (F41021) and, optionally, load the Lot Quantity by Expiration Date into the Lot Array. This is used in the Planning Programs (P3482 and P3483.)	F41021T (PMPN On Hand Table). Calls B3401290, B3500140, B3401710, B3401720, B3401700

Note:

This routine shall be different from R3482 to handle multiple branch/plant
Date Branch is base branch plant to make controlling cache
Detail information on demand and supply will be handled by N3500110 - MRPMultiplePlantLoadAndPlan (MRP, Multiple Plant Load and Plan)

End Section
: This section is to be called only once. So this section will deal with the last item and its set of branches (or any data which was not handled by Do Section above). If you set to write Co/By product time series the conditional section (Write Time Series for CoBy Products) get called from this routine. Business functions listed here repeat business functions called during Do Section event. So you may skip this section of information (except B3401590).
Business Function

Source	BSFN	Table Reference	Purpose	Others
B3500090 #ref22	MRPMultiPlantSequenceBranchInUI (MRP, Multi-Plant Sequence Branches in UI)	F3403	This function will read the available plants in F35UI001 and sequence the order of plants to planned for. This function will read the available plants in multi plant cache and sequence the order of plants to planned for.	MMCU, ITM, CMCU, PRPX, BRLV, BRSQ, EXIN, AVLC, EFFF, EFFT For detail, refer below section on B3500090
N3500110 #ref23	MRPMultiplePlantLoadAndPlan (MRP, Multiple Plant Load and Plan)	All Demand and Dupply Tables	This NER module is designed to read the sequence cache and retrieve the branches to be planned for a particular item. The order of the records read from cache is the Branch Sequence (MABRSQ). This assures that MRP is planning the Demand branches first, then the Supply branches	This is for the last record which was not handled by Do Section.
B3500140 #ref5	CacheProcessMultiplantSequence (Cache, Process Multiplant Sequence)	N/A	Refer above Do Section event	cCacheActionCode = 4 with key MCU and ITM
B3401290 #ref19	CacheProcessMRPItemQuantities (Cache, Process MRP Item Quantities)	F4101, F4102, F4801	Delete item quantity cache records	cCacheActionCode = 5 (to Delete)
B3401590 #ref26	MRPParallelManagingSemaphoreLoc (MRP,Parallel-Managing Semaphore Lock)	F3420	This business function will manage(Add/Update) Semphore Table	cActionCode = D (Done) Refer Do Section Event above
B3401290 #ref19	CacheProcessMRPItemQuantities (Cache, Process MRP Item Quantities)	F4101, F4102, F4801	To handle multiple cache, BL_BA: /* BucketLess Lits / BL_BAU: BL_LXU: BK_LXU: BK_BA:/ Bucket List */ BAU:	cCacheActionCode = C (to clear cache) Refer below section for cache name
B3401580 #ref18	MRPParallelAddSubsystemTriggerRec (MRP, Parallel Add Subsystem Trigger Records)	F3420, F4102, F986113	This Business function will load records onto Subsystem Job Master File ( F986113) for a given Low Level Code. When LLX has changed to indicate it. Additinally returns cEndSubsystemProcess parameter to determine whether to delete subsystem records or not.	Refer Do Section Events
B3401580 #ref16	MRPParallelDelSubsystmTriggerRec (MRP, Parallel Delete Subsytm Trigger Records)	F986113	If above B3401580 returns Y for cEndSubsystemProcess	cActionCode = E (to End)

Note:

In this section same business functions gets called which are called in Do Section event
As we can view above, Parallel Processing is handled based F3420, F4102 (for LLX) and F986113 to handle a single job into multiple process

Quantity Array

Refer B3401290.h which contains a new cache to hold quantity information in Array.

QTY_ARRAYS: To universalize the names, size of date cache arrays. pDTArrays stores all the pointers in an array instead of structure for the sake of array processing. Below values determines how to write F34UI005 (MRP Orders/Requirements User Index - Process Item) and F34UI006 (MRP Co/By Product Net Quantity User Index)#Check B3500050 and B3500080 to describe quantity array and other UI tables (below definition is written in B3400590.c) FCSU (Forecast Unadjusted Array), FWOU (Work Order Parts List Unadjusted Array), FWO (Firm Parts List Array), PWO (Plan Parts List Array), EAU (Ending Avail Unadjusted Array), EAA (Ending Available Array), ATPU (ATP Unadjusted Array), ATP (ATP Adjusted Array), CATPU (Cum ATP Unadjusted Array), IRP (Project Receipt Routing Array), FWOUP (Project Work Order Parts List Unadjusted Array), PWOP (Project Plan Parts List Array), PLOP (Project Plan Order Array)

BL_*: Bucketless (BL_BA: BUCKETLESS_OFFSET)

BK_*: Bucket (BK_BA: BUCKET_OFFSET)

Index	Name (for both Array/Cache)	Others
0	BL_BA	Begin Available Array
1	BL_BAU	Begin Avail Unadjusted Array
2	BL_EPL
3	BL_FPQ
4	BL_FQ
5	BL_FQU
6	BL_ID	Transfer Order Array
7	BL_IR	Receipt Routing Array
8	BL_LEX	Lot Expiration Array (mnLotExpQtyArray)
9	BL_LXU
10	BL_LTAV	Lot Available Adjusted
11	BL_LTAVU
12	BL_CFD
13	BL_CFDU
14	BL_PLQ	mnPlanOrderQtyArray
15	BL_PLU
16	BL_PO	Purchase Order Array (mnPOQtyArray)
17	BL_POU	Purchase Order Unadjusted Array
18	BL_PPQ
19	BL_PQU
20	BL_RS	Rate Schedule Array (mnAdjRateArray)
21	BL_RSU	Rate Schedule Unadjusted Array
22	BL_SHP
23	BL_SO	Sales Order Array
24	BL_SOU	Sales Order Unadjusted Array, refer to B3400390
25	BL_WO	Work Order Array (mnWOQtyArray)
26	BL_WOU	Work Order Unadjusted Array
27	BL_SOT
28	BL_RST
29	BL_CPS
30	BL_REQ
31	BL_ORD
32	BL_FIDU	Unadjusted firm transfer orders. Refer B3400390
33	BL_FID	Firm transfer orders adjusted with messages. Refer B3400390 and B3400400
34	BL_TIU	Total independent demand unadjusted. Refer B3400400
35	BL_TI	Total independent demand. Refer B3400400
36	BL_BAUP	(Project) Project Begin Avail Unadjusted Array
37	BL_BAP	(Project) Project Begin Available Array
38	BL_POUP	(Project) Project Purchase Order Unadjusted Array
39	BL_POP	(Project) Project Purchase Order Array
40	BL_PDMD	(Project) Project Demand Array
41	BL_WOUP	(Project) Project Work Order Unadjusted Array
42	BL_WOP	(Project) Project Purchase Order Array
43	BL_PQUP
44	BL_FPQP
45	BL_PPQP
46	BL_PLUP
47	BL_FPLP
48	BL_PLO	Planned Order Array
49	BL_MLT
50	BL_SOP	(Project) Project Sales Order Array
51	BL_PLN
52	BL_IRP
52	BK_BA	Bucket starts here:
53	BK_BAU	repeat same description
54	BK_FPL
55	BK_FPQ
56	BK_FQ
57	BK_FQU
58	BK_IR
59	BK_LEX
60	BK_LXU
61	BK_LTAV
62	BK_LTAVU
63	BK_CFD
64	BK_CFDU
65	BK_PLQ
66	BK_PLU
67	BK_PO
68	BK_POU
69	BK_PPQ
70	BK_PQU
71	BK_RS
72	BK_RSU
73	BK_SHP
74	BK_SO
75	BK_SOU
76	BK_WO
77	BK_WOU
78	BK_SOT
79	BK_RST
80	BK_CPS
81	BK_REQ
82	BK_ORD
83	BK_FIDU
84	BK_FID
85	BK_TIU
86	BK_TI
87	BK_BAUP
88	BK_BAP
89	BK_POUP
90	BK_POP
91	BK_PDMD
92	BK_WOUP
93	BK_WOP
94	BK_PQUP
95	BK_FPQP
96	BK_PPQP
97	BK_PLUP
98	BK_FPLP
99	BK_PLO
100	BK_MLT
101	BK_SOP
102	BK_PLN
103	BK_IRP

Additional Information on Quantity Array:
Detail prototype can be found at B3401290.h file

API	Parameters
MRP_CREATE_QTY_ARRAY	hCache: A pointer to a cache handle. This will be assigned in this API. szName: The unique character string for creating the cache. iSize: The integer size of the array to be created. lpData: A void * that will be assigned to the beginning of the array. This will be NULL if this API fails.
MRP_GET_QTY_ARRAY	phCache: A pointer to a cache handle. This will be assigned in this API. szName: The unique character string for creating the cache. ppData: A void ** that will be assigned to the beginning of the array. This will be NULL if this API fails. dsCacheIndex : A Cache index structure used for initializing the cache. hUser: A User handle.
MRP_CLEAR_QTY_ARRAY	phCache: A pointer to a cache handle. This will be assigned in this API. szName: The unique character string for creating the cache. iSize: The integer size of the array to be created. dsCacheIndex: A Cache index structure used for initializing the cache. hUser: A User handle. bSuccessful: A BOOL value that will be set by the macro. This will be set to TRUE if successful and FALSE if it is not.
MRP_DESTROY_QTY_ARRAY	phCache: A pointer to a cache handle. This will be assigned in this API. szName: The unique character string for creating the cache. dsCacheIndex: A Cache index structure used for initializing the cache. hUser: A User handle. bSuccessful: A BOOL value that will be set by the macro. This will be set to TRUE if successful and FALSE if it is not.

(Conditional) SECTION: Write Time Series for CoBy Products
: This section can be called only for CoBy Process which gets called by End Doc routine for main section based on the business view MRP/MPS User Index - Multiple Plant (V34UI005A)
Data Selection is based on F34UI005.JOBS (Job Number), F34UI005.CTID (Computer ID) and F34UI005.TP (Type Code) = 'MPS'.

Do Section: Write Time Series for CoBy Products
        Purpose: Write Time Series for CoBy Products
                1. Retrieve Date Information for This CoBy Item
                2. Depends on on consolidation method (PO cEverestEventPoint13) assign valid Date Branch (PO value or F34UI005.MCU)

Business Functions:

Source	BSFN	Table Reference	Purpose	Others
B3500060 #ref4	CacheProcessMultiPlants (Cache, Process Multi Plants)	N/A	This function will perform Get, Add, Update, Delete, Delete All, Get Next, Add/Update, and Terminate functions on the MRP Multi-Plants Cache used in the Multi-Plant MRP/MPS planning programs (R3483). This function creates a unique cache for each Multi-plant MRP/MPS planning process. The function appends the input Job Number string to the two character ID 'MP' to build the cache name used for the calling application.	cRecordType = D (Date) cCacheActionCode = 1 (to get)
B3400590 #ref29	MRPWriteTimeSeriesData (MRP, Write Time Series Data)	F4102, F3413, F34UI005	To write time series data only when PO cSuppressTimeSeries is not '1' (do not suppress)	Calling B3500060 B3401270 B3401290 F34UI005 (MRP Date User Index) #Create a new section for this BSFN
N3402030 #ref30	F3413WriteGenerationDate	F3413	When time series is suppress to write then this function gets called. To write Generation Date record for Process item in time series into F3413 using the passed in Item, Branch and Date. Quantity Type = "GD" and Quantity = zero	Insert

Note:
Back To Top

N3500110 - MRPMultiplePlantLoadAndPlan (MRP, Multiple Plant Load and Plan)
: This routine will replace event rule in R3482 (Do Section of Read F4102 and Write UI Tables) however general rule to get Demand and Supply is more or less same. #refer document for R3482 - technical trouble shooting
This NER gets called whenever it reads a new record from F4102 in Do Section.

To minimize the usage of global variables, most of parameters in processing option is to be repeated here. Refer <Document 1344759.1> E1: 34: R3482 & R3483 Understanding MRP Parameters.

Simplified Routines and related Business Functions:

1. Determine Forecast in PO flag
2. Retrieve Audit information by calling B9800100 - GetAuditInfo (Get Audit Informatio). This gets called for all the business function called below
3. Get the first branch from the cache to plan by calling B3500140
4. Set supply/demand flag if there is on-hand quantity for this working branch (if CacheProcessMultiplantSequence.mnQtyOnHand < 0) then set cSupplyDemandExist = 'Y'
5. While loop to plan every branch for this working item (exit routine by setting cErrorCode_ERRC)
6. Initialize Forecast included flag for this working branch based on processing option parameter
7. Fetch data from F4102 depends on Consolidation Method MCU can be different as below,

In simple consolidation (method 1), only fetch the item branch data one time (for the consolidation branch). In simple consolidation (method 1), the date branch is always the consolidation branch.
In branch relationships (method 2), the date branch is the current branch unless the default branch processing option was used.

9. Retrieve Date Information for this branch (= Date Branch) by calling B3500060 - CacheProcessMultiPlants (Cache, Process Multi Plants)
10. Calculate Work Hours Per Day through F3009 (Job Ship Manufacturing Constants) = F3009.WRHR + WRH2 + WRH3
11. New Branch information is in, then

- Default Planning Flags (VA evt_cPlanFenceRule_SFOG = VA evt_cF4102TimeFenceRule_MPSP and set VA evt_cProcessItemFlag_PROC = " ")
- Default Purchase Item (VA evt_c2ndStockType = "P")
- Get 2nd description (=evt_c2ndStockType) and special handling code for the stocking type. Use 2nd description to tell if the item is Manufactured or Purchased. Check special handling code to determine if the item is a Process.

12. Finding out MWDH ( MonthWeekDayHour) for the Rate Item when F4102.OPC is '5' by calling N3101750 - F3109GetLineItemRelationship (F3109 Get Line Item Relationship)
13. Get time basis rate from time basis code by calling B3000330 - ConvertTimeBasisCodetoQuantity (F0005 Convert Time Basis Quantity). Based on F4102.TIMB it returns value. In case F4102.TIMB is zero then set 1 (to make conversion result is not affected between Rate and Unit)
14. Calculate Planning Time Fence by calling B3400540 - MRPCalculateScheduleDatesforMRP (MRP, Calculate Schedule Dates for Planning)
15. Calculate Freeze Time Fence by calling B3400540 - MRPCalculateScheduleDatesforMRP (MRP, Calculate Schedule Dates for Planning) after setting variables as below,
            VA evt_jdFreezeTimeFence_FRDT = "00/00/00"
            If VA evt_c2ndStockType is equal to "P"
                     VA evt_cScheduleType_EV02 = "O"
            Else
                     VA evt_cScheduleType_EV02 = "F"
End If
            (if return date is null date) then set VA evt_jdFreezeTimeFence_FRDT = add_days([VA evt_jdFirstBeginDate_FBEG],-1)
16. Calculate Message Display Fence: VA evt_jdMsgTimeFence_MSGD = VA evt_jdEndDate_ENDD] +1
17. Default Time Fence Code 'G' if none exists (F4102.MPSP = Blank): VA evt_cPlanFenceRule_SFOG = "G", VA evt_jdPlanningTimeFence_PLDT = VA evt_jdEndDate_ENDD] + 1
18. Reset Plan Date if it is outside the End of Planning Horizon (i.e., VA evt_jdPlanningTimeFence_PLDT is greater than VA evt_jdEndDate_ENDD): VA evt_jdPlanningTimeFence_PLDT = VA evt_jdEndDate_ENDD #then why need to implement step 21????
19. If this is a forecast consumption item (= (F4102.MPSP='H')), but not using forecast consumption mode (cUseForecastConsumptionLogic NOT IN ('1', '2')), override the time fence rule to 'G': VA evt_cPlanFenceRule_SFOG = "G"
20. Calculate Level Leadtime (=VA evt_mnCalculatedLeadtime_LTLV)

evt_cF4102SVSTKT = 0 (F4102.STKT = '0' for Phantom Item) and cPO_PhantomDataFlag is '1': VA evt_mnCalculatedLeadtime_LTLV = [VA evt_mnCalculatedLeadtime_LTLV]+[BF nPO_WorkOrderLeadTime]
evt_cF4102SVSTKT <> '0' evt_c2ndStockType = 'P': VA evt_mnCalculatedLeadtime_LTLV = [VA evt_mnF4102LeadtimeLvl_LTLV]+[BF nPO_PurchOrderLeadTime]
evt_cF4102SVSTKT <> '0' evt_c2ndStockType <> 'P': VA evt_mnCalculatedLeadtime_LTLV = [VA evt_mnF4102LeadtimeLvl_LTLV]+[BF nPO_WorkOrderLeadTime]

21. Determine MRPP (VA evt_cF4102FixedVar_SVMRPP) when F4102.MRPP NOT IN ('F', 'V'): If the items leadtime per unit (F4102.LTPU) is not zero, assume the leadtime is variable (=V). Otherwise the leadtime is fixed (=F).
22. Period of supply (=VA evt_mnF4102_SVOPV) when F4102.OPV (Order policy code =4) must be expressed in a whole number by ceiling it through system function ceil().
23. Determine if potency is being used (F4102.OT1Y = 1). The way it determines is that based on (input) szPrimaryUnitOfMeasure read 2nd character of special handling code against UDC 00/UM. If 2nd character of special handling code is 'P', then set VA evt_cPotencyUnitFlag_PUFG = "1"

Source	BSFN	Table Reference	Purpose	Others
B3500140 #ref5	CacheProcessMultiplantSequence (Cache, Process Multiplant Sequence)	N/A	Get the first branch from the cache to plan	cCacheActionCode = 1 (to get) Returns szPlanningFamily (VA evt_szCategoryCode_PRPX) mnQtyOnHand (VA evt_mnBeginingAvailable)
B3500060 #ref4	CacheProcessMultiPlants (Cache, Process Multi Plants)	N/A	Retrieve Date Information based on Date Branch Determined	cRecordType = D (for Date) cCacheActionCode 1 ( to get cache)
N3101750 #ref27	F3109GetLineItemRelationship (F3109 Get Line Item Relationship)	F3109	This function gets called to get F3109.MWDH based on passed in Item and Branch/Plant	This function gets called only when F4102.OPC is '5'
B3400540 #ref28	MRPCalculateScheduleDatesforMRP (MRP, Calculate Schedule Dates for Planning)	F3411	To calculate Planning Time Fence. This function will Forward or Backward Schedule from the Input Date based on the Stocking Type 'M' for Manufactured Item and 'P' for Purchased Item and Calculate the Output Date. If the Item is Purchased it will use the Calendar Days, otherwise, it will schedule based on Work days in the Calendar table (F0007).	This gets called only when F4102.MTF1 > 0 Calculate the output date. If the StockingType = 'P', add/subtract the input LeadTime to/from the InputDate and search for the new date in the User Index table (F34UI001). If found, return the date from DateArray just before the search date. If the input StockingType = 'M', call B3100300 to retrieve an OutputDate from the Work Day Calendar table (F0007) Calling, B3100300 B3401270
B3400540 #ref28	MRPCalculateScheduleDatesforMRP (MRP, Calculate Schedule Dates for Planning)	F3411, F0007	To calculate Freeze Time Fence. This function will Forward or Backward Schedule from the Input Date based on the Stocking Type 'M' for Manufactured Item and 'P' for Purchased Item and Calculate the Output Date. If the Item is Purchased it will use the Calendar Days, otherwise, it will schedule based on Work days in the Calendar table (F0007).	When F4102.MTF2 > 0 Note that depends on input parameters the output date can be used for different purpose. So for this example, this function gets called in getting Planning Time Fence

(Continued ...) below separates table is to describe process specific routine
When cPO_ProcessPlanning = '1' (= in process planning mode):

24. For branch relationships mode (method 2), initialize the CoBy product flag
(cPO_ConsolidationMethod ='2') then VA evt_cCoByitemFlag_COBY = " "
(cPO_ConsolidationMethod ='1') then keep previous value
25. If not a process item , check if the item is a Co-Product. If this item is Co product then load the feature percent array. Only call the function once in consolidation mode (method 1). Refer Step 11 above.
26. If the item is not a Co-Product, check if it is a By-Product through B3401210 #Check Condition again!!!!!
27. If this is a process item, load all associated Co-Products to the workfile F34UI005 using Bill of Material through B3401260
28. Forecast consumption is not allowed for Process, Co, or By-Products. Though F4102.MPSP='H' set VA evt_cPlanFenceRule_SFOG = "G" when this item is not Process, Co, By-Product

B3401220 #ref31	F3002CalculateFeaturePercent (F3002 Calculate Feature Percent)	F3111, F3002, F3404, F3411, F4102	To load feature percent for Co Product. Read Bill and Load Processes. Read Bill for Effective Dates. Calculate Feature Percent.	B3401220_MAXPROCESSITEMS 99 F3002 (TBM, MMCU, KIT, ITM, COBY) F3404 (MMCU, KIT, CMCU, ITM, EFFF, EFFT, FTRP) F3111 (COBY, CPIT, CMCU, DRQJ) F4102 (MCU, ITM, MRPC, USER,PID, JOBN, UPMJ, TDAY) Referencing, B3401270.h
B3401210 #ref32	F3002CheckIfItemIsByProduct (F3002 Check If Item Is Byproduct)	F3002, F3111	To check whether current item is By Product. Read the Bill of Material table (F3002) and check if the input item is a byproduct. If the item is not found in the BOM table, it will look in the Parts List table (F3111) and check if it is defined as a byproduct. It will return a '1' in the Byproduct output parameter if it is a byproduct.	F3002 (TBM, MMCU, KIT, COBY) F3111 (COBY, CPIT, CMCU, DRQJ)
B3401230 #ref33	F3002LoadCoProductsFromBill (F3002 Load CoProducts From Bill)	F3002, F4101, F4102	To load all asociated Co-Products to work file. Read Bill of Materials using input Item. If the Item is a Process, load all Co and By Products for the process into the MRP CoByProduct Cache.	F3002 (COBY, ITM, CMCU, TBM, QNTY, UM, OPSQ, KIT,MMCU, BQTY, UOM, FORQ) F4101 (ITM, UOM1, TFLA) F4102 (MCU, ITM, OT1Y, STDP) Calling, B3401280 B4000520
B3401280 #ref3	CacheProcessMRPCoByProducts (Cache, Process MRP Co/By Products)	N/A	This function manages access to the MRP Co/By Products Cache. The function will perform Get, Add, Update, Delete, Delete All, Get Next, Add/Update, and Terminate accesses on the cache for the MRP/MPS planning programs R3482 and R3483.	Only when (input) cDumpDebugInfo = '1' MRP_COBY_PROD_CACHE_ID "CB" (ID used to form Co/By Product Cache name) MAX_NUM_COBY_PROD_CACHE_KEYS 2

(Continued ...)

29. Adjust the Planning Date to a Forecast Consumption Bucket if the rule (VA evt_cPlanFenceRule_SFOG) is 'H'. Need to do this after the Process, Co, By-Product check.
30. Reset Item Display Code and Net Change Flag (VA evt_cMRPDFlag = "1")
31. Delete Messages, Time Series, & pegging for this item branch combination if table was not cleared upfront ((input) cClearFilesFlag <> '1) by calling B3400430
32. Locate the BOM for a given item and branch and if no BOM is found it writes warning message through B3400560
33. Write GD (Generate Date) record for Process item in time series. At this point all the dates calculations are complete and also process item has been identified

B3400550 #ref34	MRPGetBucketDateFromCache (MRP, Get Bucket Date from Cache)	N/A	To find Forecast Consumption bucket from cache. This function will get the nearest Bucket Date for a given date based on the data in the F34UI001 MRP User Index. This is used in the MRP Program to get the bucket date nearest to the given date.	Adjust the Planning Date to a Forecast Consumption Bucket if the rule is 'H'. Need to do this after the Process, Co, By-Product check. Referencing, B3401270.h
B3400430 #ref35	MRPClearTimeSeriesMessagesOrPegg (MRP, Clear TimeSeries, Messages Or Pegging Qtys)	F3411, F3412, F3413	To delete data from F3411. Depends on the parameter value szTableName this function clear data from it. The purpose of this function is to delete records from variousManufacturing tables including F3411 (Messages), F3412 (Pegging), and F3413 (Time Series). The user passes the name of the table to delete records from and a flag indicating which records to delete. If Delete Flag = '1', all records are removed from the specified table. If Delete Flag = '0', the function deletes records. matching the input Item Number and Branch key values. If Delete Flag = '2', the function deletes records matching the input Branch key values. Note: For F3411, all records matching Item Number & Branch (when cDeleteFlag = 1) or Branch (when cDeleteFlag = 2), MMHCLD <> 'Z' And MMMSGT <> 'M' will be deleted. For other tables, deletion will be performed based upon Item Number and Branch only. This rule does not apply when Delete Flag is '1'.	Delete Messages, Time Series, & pegging for this item branch combination if we have not cleared the tables upfront. cDeleteFlag = '0' Key/Index used: KEY2_F3411 KEY9_F3411
B3400430 #ref35	MRPClearTimeSeriesMessagesOrPegg (MRP, Clear TimeSeries, Messages Or Pegging Qtys)	F3413	To delete data from F3413 Refer above note	cDeleteFlag = '0' KEY1_F3413 KEY2_F3413
B3400430 #ref35	MRPClearTimeSeriesMessagesOrPegg (MRP, Clear TimeSeries, Messages Or Pegging Qtys)	F3412	To delete data from F3412 Refer above note	(input) c_MultiLevelFlag = 'Y' AND VA evt_c2ndStockType is IN ('P', 'M') KEY3_F3412 KEY7_F3412
B3400560 #ref36	MRPUpdateNetChangefromBOM (MRP, Update Net Change from BOM)	F3002, F3411	This business function tries to locate the BOM for a given item and branch. If no BOM is found it writes warning message.The function looks at F3002 again to see if BOM exist as a co product or by product. If BOM does not exist it writes message No BOM Co/By Product item. This function does not update net change flag it only writes warning messages.	F4102.MRPC Refer to <Note 1050946.1> E1: 34: F4102.IBMRPC - NetChangeFlag (Flag - Net Change) FAQ
N3402030 #ref30	F3413WriteGenerationDate (F3413 WriteGeneration Date)	F3413	To write Generation Date record for Process item in time series into F3413 using the passed in Item, Branch and Date. Quantity Type = "GD" and Quantity = zero	Insert data into F3413

(Continued ...) Below routines are not for Process (evt_cProcessItemFlag_PROC <> '1')

34. Call B3400390 in mode 1 to load sales order records into cache for forecast consumption by customer (i.e., (input) cUseForecastConsumptionLogic = '2')
34'. (Optional) Debugging Mode call B3401770
35. Load Forecast Qty into cache and set VA evt_AdjustForecastAndSale_EV01 = "Y" through B3400380
35'. Call B3401290 if (input) cDumpDebugInfo = '1' (by default this value is 0)
36. Call B3400380 in mode 2, to load new forecast type quantities into forecast adjusted array and to terminate the sales order cache used for forecast consumption by customer.
37. For forecast consumption by customer, B3400390, B3500020 and B3400400 are called inside B3400380 so these are not called directly from N3500110.

(When (input) cUseForecastConsumptionLogic = '2')

B3400390 #ref37	MRPWriteSalesOrderQtyToCache (MRP, Write Sales Order Qty To Cache)	F3411, F4108, F4211, F3406	This function reads sales order table (F4211). In mode 1 this function loads sales order quantities into a temporary cache. In mode 2 it loads sales order quantities into MRP Item Quantity Cache. Quantities are always loaded in primary unit of measure. Quantities are loaded into MRP Item Quantity Cache as quantity type 'SOU' (Sales Order Unadjusted). When called from R3483, and consolidation method is '2', additional parameters are required. This will facilitate writing of "FIDU" (Transfer Order Qty Unadjusted) and 'FID' (Transfer Order Qty Unadjusted with Messages) records into cache. Mode 1 is used only for 'forecast consumption by customer'.	Only when(input) cUseForecastConsumptionLogic = '2' Calling B3401710 B3401270 B4000520 B3401290 B3401300 B3401770
B3400380 #ref38	MRPWriteForecastQtyToCache (MRP, Write Forecast Quantity To Cache)	F3460	This function reads the Forecast table (F3460) and writes the Forecast Quantity to the MRP Item Quantity Cache. Mode: Mode 1: it writes the quantity into FQU array Mode 2: it is used only for forecast consumption by customer	When ((input) cTS_Q45DSFCSU ='1' OR (input) cTS_Q50DSFCST = '1') AND VA evt_cForecastIncluded_EV01 = 'Y' (Processing Option for forecast type is not blank). Calling, B3401290 B3400390 B3400400 B3401770 B3500020 B3101710
B3400380 #ref38	MRPWriteForecastQtyToCache (MRP, Write Forecast Quantity To Cache)	F3460	To load new forecast type quantities into forecast adjusted array and to terminate the sales order cache used for forecast consumption by customer cMode = 2	Refer above mode 1 for same business function. Columns reference: ITM MCU DRQJ AN8 FQT TYPF PNS Index: ID_F3460_ITEM_NUMBER__BRANCH;

(Continued ...) below routine is specific to (input) cUseForecastConsumptionLogic <> '2'

38. Load Sales Orders into cache

(When (input) cUseForecastConsumptionLogic <> '2')

B3400390
#ref39
#ref37

MRPWriteSalesOrderQtyToCache (MRP, Write Sales Order Qty To Cache)

F3411, F4108, F4211, F3406

To load Sales Order information into cache
cMode = 2

This function reads sales order table (F4211).

In mode 1 this function loads sales order quantities into a temporary cache.
In mode 2 it loads sales order quantities into MRP Item Quantity Cache.

Quantities are always loaded in primary unit of measure. Quantities are loaded into MRP Item Quantity Cache as quantity type 'SOU'
(Sales Order Unadjusted).
When called from R3483, and consolidation method is '2', additional parameters are required.
This will facilitate writing of "FIDU" (Transfer Order Qty Unadjusted) and 'FID' (Transfer Order Qty Unadjusted with Messages) records into cache. Mode 1 is used only for 'forecast consumption by customer'.

Refer above with Mode 1 for same business function.

When (Input) cTS_Q55DSSOU = '1' OR (Input) cTS_Q60DSSO = '1'

(Continued ...)

39. Load Other Branch Demand into cache and set VA evt_cSupplyDemandExists = "Y" it there is demand
40. Update the Supply Demand Flag when (Input) cPO_MultiplantProjectPlanning = '2' (PMPN Enhancement)
41. Adjust Sales and Forecast Quanties when (Input) cPO_ConsolidationMethod = '2' by calling B3400400
42. Load Purchase Order Quantity into cache through B3400420

B3500020 #ref40	MRPWriteOtherBranchDemandtoCache (MRP,Write Other Branch Demand to Cache)	F3411	Load Other Branch Demand into cache. This function will read the Message table F3411 and retrieve transfer order requests from the input branch. The messages it retrieves have met the following properties : ITM(=Input Item Number) MCU(=Input Branch) MSGT(In('B','O')) MSGA(<>'Y') HCLD(<>'Z') And TRQT(>0). Transfer Quantities will then be written to the Item Qty cache as "ID" quantity types.	When (Input) cPO_ConsolidationMethod = '2' AND cTS_Q65DSID = '1' * PMPN Enhancement - Added ProjectPlanning Processing Option Calling, B3401290 B3401710
B3400400 #ref41	MRPUpdateAdjustedSalesAndForecas (MRP, Update Adjusted Sales and Forecast Qty)	F3462, F3460	This function calculates the Adjusted Sales Order and Forecast Quantities based on the time fence rule and time fence days. The function updates the MRP Item Quantity Cache (thru B3401290) with the calculated quantities. The time fence rules that are handled are 'G', 'C', 'F', 'S', '1', '3' and 'H'. Added new time series types for multiplant: "FID" = Firm Interplant Demand "TIU" = Total Independent Demand Unadjusted "TI" = Total Independent Demand Adjusted	Refer to F4102.MPSP. Calling, X4101 B3401270 B3401290 B3500140
B3400420 #ref42	MRPWritePurchaseOrderQtyToCache (MRP, Write Purchase Order Qty To Cache)	F3411, F4211, F43092, F4311	This function reads the Purchase Order table (F4311) and writes the open quantity to the MRP Item Quantity Cache in the primary unit of measure. Calculated quantities are written to the cache with Quantity Type 'POU'. The function also stores Purchase Order data in the MRP Purchase Order Cache for use in the planning business function B3400500.	1. Open tables F3411 and F4311. If the ReceiptRoutingFlag is on, open F43092. 2. Set a selection over the Purchase Order table using the input Item, Branch, and dates. Read the selected POs and store the Open Quantities in the MRP Item Quantity Cache. 3. Verify the Purchase Order is included in Inclusion Rules 4. Convert the PO Open Quantity to primary UOM. 5. If the ReceiptRoutingFlag is set, retrieve routing information for the PO and accumulate a receipt routing quantity. 6. Write the Purchase Order to the PO Cache. Write 'POU' qty (Open Qty) to Item Qty Cache. Write 'IR' qty (In-Receipt Qty) to Item Qty Cache. Get true work date for PDPDDJ using B3401270. 7. Find out the related order info on a transfer order. 8. If in Multi-Plant Mode, Get Related SO 9. Get Related Sales Order and Assign Supply Branch 10. Determine if the Purchase Order is from a Descriptive task on a project 11. Updating corresponding Purchase order array for Projects. PLN array is also marked to tell B3400500 that either Supply or Demand exists on that day to be planned. Column Reference: F431 (KCOO, DOCO, DCTO, SFXO, LNID, MCU, RKCO, RORN, RCTO, RLLN, AN8, TRDJ, PDDJ, ITM, LNTY, NXTR,UOM, UORG, UCHG, UOPN, UOM3, UNCD, RTGC, PRJM, PMPN, PNS) F43092 (KCOO, DOCO, DCTO, SFXO, LNID, UPIB, ACTO, UOM, QTYO) F4211 (DOCO, DCTO, KCOO, LNID, MCU, ITM) Calling, B31P0460 B3401270.h B3401290.h B3401300 B3401320 B3401710 B4000520 N4003010

Now Non-Process reading is done. So below routines are applied to both Process and Non-Process parts
(Continued ...)

43. Load Work Order Qty into cache
44. Load Lower Level Pegging Qty into cache
45. Load Parts List Qty into cache
46. Load Configured Component Qty into cache
47. Load Rate Schedule Qty into Cache
48. Set supply/demand flag for consolidation mode (method 1)
49. Plan the item for branch relationships mode (method 2)

B3400440 #ref43	MRPWriteWorkOrderQtyIntoCache (MRP, Write Work Order Qty Into Cache)	F3111, F3411, F3412, F34UI005, F4102, F43092, F4801, F4801T, BV4801JC	This function is used to obtain data from the F4801 table for the MRP Planning Program R3482 and R3483. The function will return error codes necessary. The Unadjusted WO Qtys will be written to the MRP Regular Item Qty cache. For Process, this function will also perform the functions of S0054P if the Process Item Flag is '1'. These qtys will be written to the F34UI005 table instead of cache. This business function will read the Work Order table (F4801) and Load the Open Quantity Calculated into Regular Item Qty Cache. Load the WO Record and store needed data in Primary UOM in the WO Cache. The Bucketless Dates Cacge must be loaded with the Planning Dates using the business function B3400460. The JOBS and CTID must be obtained using B3100710 and B9800180 before calling this function.	Table Reference: V4801JC (Join between F4801 and F3111) V4801JH (Join between F4801 and F4801T) F4801 (DCTO, DOCO, RORN, LNID, MMCU, SRST, AN8, DPL, STRT, DRQJ, ITM, UORG, SOCN, SOQS, UOM, TBM, RTG, UNCD) F43092 (KCOO, DOCO, DCTO, SFXO, LNID, UPIB, ACTO, UOM, QTYO) F3111 (DOCO, DCTO, COBY, OPSQ, BSEQ, CPIT, CMCU, UORG, TRQT, SOCN, UM, RTG) F4102 (ITM, MCU, OT1Y, STDP, MRPC, USER, PID, JOBN, UPMJ, TDAY, PNYN) Calling, B3400460 B3400540 B3401270.h B3401280.h B3401290.h B3401300 B3401310 B3401550 B3401710 B4000520 B4000920 B4001040 X4801T
B3400470 #ref44	MRPWritePeggingQtyIntoCache (MRP, Write Pegging Qty Into Cache)	F3411, F3412, F4101, F4102, F4801	This function will read the Pegging table (F3412) and load the Pegging Quantity adjusted by Planning Message data from the Message table (F3411) into the Regular Item Qty Cache.	Taqble Reference: F4101 (ITM, UOM1, TFLA) F4801 (DCTO, DOCO, MMCU, SRST, ITM, UORG, UOM) F3411 (MSGT, KCOO, DOCO, DCTO, TRQT, NID_STRT, RSTJ, UKID) F3412 (ITM, MCU, DRQJ, UORG, DOCO, DCTO, RCTO, PRJM, SRDM, PNS) F4102 (ITM, MCU, OT1Y, STDP) Keys: KEY1_F4801 KEY1_F4101 KEY1_F4102 KEY3_F3411 Calling, B3401290.h B3401710 B4000520
B3400480 #ref45	MRPWritePartsListQtyIntoCache (MRP, Write Parts List Qty Into Cache)	F3111, F3411, F4101, F4102, F4801, F4801T, F4108	This function is used to obtain data from the F3111 table for the MRP Planning Program R3482 and R3483. The function will return error codes necessary. This business function will read the Parts List Table (F3111) and Load the Parts List Quantity adjusted by Planning Message Data from the Message Table (F3411) into the Regular Item Qty Cache in the Primary UOM. The Bucketless Dates Cache must be loaded with the Planning Dates using the Business Function B3400360.	Table Reference: F4801 (DCTO, DOCO, LNID, CO, MMCU, SRST, AN8, ITM, UORG, UOM) F3111 (DOCO, DCTO, FORQ, COBY, CPIT, CMCU, DSC1, DRQJ, UORG, TRQT, QNTA, UM, COMM, USER, PID, JOBN, UPMJ, TDAY, UKID, LOTN) F4101 (ITM, UOM1, TFLA) F4102 (ITM, MCU, OT1Y, STDP) F4801T (PRJM, DOCO, PMPN, PNS) F4108 (LOTN, MCU, ITM, LOTP, MMEJ) Calling, B3401270.h B3401290.h B3401300 B3401710 B4000520 N4003010 B4100210 B3102240
B3500010 #ref46	MRPWriteSupplyQuantitiesFromPL (MRP, Write Supply Quantities from Parts List)	F3111, F43092, F4801	This function should only be used by R3483. It will read co-products specified from the Parts List and save the open quantities found in the Regular Item Cache as 'CPS' quantities if the Consolidation Method is '2'. Otherwise it will add these quantities into the 'WOU' records.	Table Reference: F4801 (DOCO, ITM, MMCU, DRQJ, DCTO, SRST, UORG, SOQS, SOCN, UOM, RTG, STRT, TBM, UNCD) F43092 (ACTO, UPIB, DOCO, DCTO, QTYO, UOM, KCOO, SFXO, LNID) F3111 (COBY, CPIT, CMCU, DRQJ, DOCO, OPSQ, UORG, TRQT, SOCN, UM, RTG, DCTO, BSEQ) Calling, B3401310 B3401290.h B3401300 B4000520
B3401730 #ref47	MRPProcessCofiguredComponent (MRP, Process Configured Component)	F3215, F3412, F4211	Retrieves the arrays from cache. First base arrays are retrieved and then using branch index, date arrays are retrieved. I3401730_IsSalesOrderLineForConfiguredParentIncluded: This function is called to check if configured components having WADL =0 are part of a Sales Order Included as per the inclusion Rules.Since the components with WADL =0 are not on the Sales Order directly,we need to check the SO line for Configured Parent. I3400420_IncludeOrder: This function verifies the Sales Order Line for the parent configured item is not excluded by the Resource Inclusion Rules. #Describe it again	This routine is different from Xe and ERP8. 1. Fetch the record from F3215 2. Get the F4211 record for the parent configured item based on F3201 info 3. Update the Configurator Demand Array and requirement array (BL_CFDU, BL_CFD) Table Reference: F3215 (CFGID, CFGCID, CFGPID, ITM, MCU, QNTY, SY, WADL, PDDJ) F4211 (KCOO, DOCO, DCTO, LNID, LNTY, NXTR) Calling, B3401730 B3401290.h N3201410 B3401300
B3401400 #ref48	MRPWriteRateQtyIntoCache (MRP, Write Rate Qty Into Cache)	F3111, F3411, F3412, F34UI005, F4801	#describe this again	#possibly another section #specify detail routine #describe _writeMessage() JCHAR szStartingDate[] = _J("01/01/1900\n"); JCHAR szFormatMask[] = _J("OSASE"); 1. Load the Rate in the Arrays 2. Find the True Work Date for Request Date. Load Rates on non-work days to the previous period rather than the next period. This matches the functionality for WOs and POs. 3. Since the start date is adjusted forward and the request date is adjusted backward, re-adjust the start date if it is greater than the request date. 4. Load Rate information into work order cache 5. Only need to load this order to the WO cache if the open qty is not zero. Orders with zero qty are ignored downstream by planning anyway. 6. Write Frozen Rate Message 7. Count the number of work days between start and end indices 8. Spread the rate across all work days from the start to requested date indices and update the RSU quantity array. 9. Write Past Order Message 10. Load BOM 11. Load Co/By Products if this item is a Process If Process WO has zero open, then co-product open quantity should be ignored for planning Table Reference: F4801 (DCTO, DOCO, MMCU, SRST, STRT, DRQJ, ITM, UORG, SOBK, SOCN, SOQS, UOM, TBM, UNCD) F3111 (DOCO, DCTO, COBY, CPIT, CMCU, DRQJ, UORG, TRQT, SOCN, SOBK, UM) Calling, B3400460 B4000520 B3400540 B3401270.h B3401280.h B3401290.h B3401300 B3401310 B3401550 B4000920 B4001040 X4801T

Now Non-Process reading is done. So below routines are applied to both Process and Non-Process parts
(Continued ...)

50. Set supply/demand flag for consolidation mode (method 1).

Below is the routine for consolidation method 2 (Plan the item for branch relationships mode (method 2))
- When the item is not a Process but a Co-Product:-

B3500010 #ref46	MRPWriteSupplyQuantitiesFromPL (MRP, Write Supply Quantities from Parts List)	F3111, F43092, F4801	This function should only be used by R3483. It will read co-products specified from the Parts List and save the open quantities found in the Regular Item Cache as 'CPS' quantities if the Consolidation Method is '2'. Otherwise it will add these quantities into the 'WOU' records.	Calculate Supply Qtys due to Co or By Products. This function will read F3411 records by Item and Supply Branch, calculate the Other Branch Demand quantity and write the quantity to the Quantities Cache. Refer above B3500010
B3500080 #ref51	MRPWriteCoByProductTranferQty (MRP, Write CoBy Product Transfer Qty)		This Business function will write Planned Orders due to transfers for co or by products prior to calling B3400500. This function can only be called if the item is a co or by product and the consolidation method used is '2'.
B3401550 #ref52	MRPLoadBOMCache (MRP, Load BOM Cache)			Load Bill of Material into cache if we haven't yet
B3400500 #ref49	MRPCalculatePlanAndScheduleOrder (MRP, Calculate, Plan and Schedule Orders)	F4102, F3002, F3411, F3412, F3413, F34UI005, F34UI006, F4211, F0006, F41021, F4108, bv41021tp	This function is the main function of R3482 MRP Planning Program and R3483. Based on the Requirements and Orders in the caches, the function will generate and schedule orders for a given Item/Branch combination. The Manufacturing Data from the Item Balance table must be obtained nd all other data must be loaded in the cache.
B3500050 #ref53	MRPMultiPlantCopyCacheDataToUI (MRP, Multi-Plant Copy Cache Data to F34UI005)

Below is the routine for consolidation method 2 (Plan the item for branch relationships mode (method 2))
- When the item is neither a Process nor Co-Product (that is, Item is By-Product)

51. Get F4108.MMEJ (VA evt_LotExpDate_MMEJ) and compare it with VA evt_jdEndDate_ENDD. If F4108.MMEJ is less than or equal to VA evt_jdEndDate_ENDD then set VA evt_cSupplyDemandExists = "Y"

B3401550 #ref52	MRPLoadBOMCache (MRP, Load BOM Cache)	#refer above
B3400500 #ref49	MRPCalculatePlanAndScheduleOrder (MRP, Calculate, Plan and Schedule Orders)	#refer above
B3500050 #ref53	MRPMultiPlantCopyCacheDataToUI (MRP, Multi-Plant Copy Cache Data to F34UI005)	#refer above	When cPO_ProcessPlanning is equal to "1"
B3400590 #ref29	MRPWriteTimeSeriesData (MRP, Write Time Series Data)	#refer above	Write complete time series or just generation date depending on processing option.

- Process Item

(When (input) cUseForecastConsumptionLogic <> '2')

B3401550 #ref52	MRPLoadBOMCache (MRP, Load BOM Cache)		#refer above
B3400500 #ref49	MRPCalculatePlanAndScheduleOrder (MRP, Calculate, Plan and Schedule Orders)		#refer above

52. Clear F34UI005 of TIR, TWU and TRU records
53. Update Item Display Code (MRPD) and Net Change Flag (MRPC)
54. Clear the Caches

Note:

If FC is 1, Process Item PO is 1, change planning rule from H to G only for process or Co/By
Plan configured component when no supply demand exist. The demand for configured component is coming from configured parent Sales Order
Planning Time Fence can be set either '-1' or '-999' internally to resolve issue for today's demand as below (when F4102.MTF1 <0),

-1: To solve issue where today's demand is not picked up because MRP start date is one day greater than generation date. The logic behind this is that it might be too late in the date (today) re-plan any of today's order.
-999: To solve issue where you want to use the "after time fence" half of the planning code for the entire horizon.

Columns reference in F4102
Values for return for cPO_ConsolidationMethod 1 (based on ITM and PO Consolidation Branch)

Alias	DD Item/Description	Explanation	Others/Editing
VEND	PrimaryLastVendorNo (Primary / Last Supplier Number)	The address book number of the preferred provider of this item.
ROQI	ReorderQuantityInput (Reorder Quantity - Input)	The estimated reorder quantity for an item. You can enter this quantity if there is not enough sales history available for the system to accurately calculate a reorder quantity.
RQMX	ReorderQuantityMaximum (Reorder Quantity - Maximum)	The maximum order quantity for an item. You can base the quantity on factors other than usage, such as perishability, storage capacity, and so forth.
RQMN	ReorderQuantityMinimum (Reorder Quantity - Minimum)	The minimum order quantity for an item. You can base the quantity on factors other than usage, such as perishability, storage capacity, and so forth.
SAFE	SafetyStockDaysSupply (Safety Stock)	The quantity of stock kept on hand to cover high-side variations in demand.
OT1Y	ConstantFutureUse1 (Potency Control)	A code that indicates whether you control the item by potency.
STDP	StandardPotency (Standard Potency)	The percentage of active ingredients normally found in an item.	Value (0 through 100.000)
FRMP	FromPotency (From Potency)	A number that indicates the minimum potency or percentage of active ingredients acceptable for an item. The system displays a warning message if you try to purchase or issue items that do not meet the minimum acceptable potency. The system does not allow you to sell items that do not meet the minimum acceptable potency.	Value (0 through 100.000)
THRP	ThruPotency (Thru Potency)	A number that indicates the maximum potency or percentage of active ingredients that is acceptable for an item. The system displays a warning message if you try to purchase or issue items that have a potency that exceeds the maximum potency acceptable. The system does not allow you to sell items that have a potency that exceeds the maximum potency acceptable.	Value (0 through 100.000)
FRGD	FromGrade (From Grade)	A user defined code (40/LG) that indicates the minimum grade that is acceptable for an item. The system displays a warning message if you try to purchase or issue items with grades that do not meet the minimum grade acceptable. The system does not allow you to sell items with grades that do not meet the minimum acceptable level.	UDC 40/LG
THGD	ThruGrade (Thru Grade)	A user defined code (40/LG) that indicates the maximum grade that is acceptable for an item. The system displays a warning message if you try to purchase or issue items with grades that exceed the maximum grade acceptable. The system does not allow you to sell items with grades that exceed the maximum grade acceptable.	UDC 40/LG
STKT	StockingType (Stocking Type)	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 types are hard-coded and you should not change them: 0 Phantom item B Bulk floor stock C Configured item E Emergency/corrective maintenance F Feature K Kit parent item N Nonstock The first character of Description 2 in the user defined code table indicates if the item is purchased (P) or manufactured (M).	<Document 791175.1> E1: 40: Overview of Stocking Types in EnterpriseOne <Document 650015.1> E1: 30: Stocking Types (UDC 41/I) for Manufacturing Applications (ETO, PDM, SFC, Costing, Configurator, MRP) <Document 1127134.1> E1: 41: Special Handling Code 'O' in UDC (41/I) - Stocking Type Code
MPST	PlanningCode (Planning Code)	A code that indicates how Master Production Schedule (MPS), Material Requirements Planning (MRP), or Distribution Requirements Planning (DRP) processes this item. Valid codes are: 0 Not Planned by MPS, MRP, or DRP 1 Planned by MPS or DRP 2 Planned by MRP 3 Planned by MRP with additional independent forecast 4 Planned by MPS, Parent in Planning Bill 5 Planned by MPS, Component in Planning Bill These codes are hard coded.	Default value = 2 UDC H41/MP - Planning Code
MRPD	ItemDisplayCode (Item Display Code)	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 DREAM Writer may be set up to select these values. Valid values are: blank Items NOT processed by the generation. 1 Items processed by the generation WITHOUT outstanding messages. 2 Items processed by the generation WITH outstanding messages.	Default value = 2 UDC H41/MR - Item Display Code
MRPC	NetChangeFlag (Flag - Net Change)	This flag is turned on when this item has had some kind of activity that would affect one of the different planning parameters that would impact the Requirements Plan.	UDC 41/MQ - Net Change Code <Document 1050946.1> E1: 34: F4102.IBMRPC - NetChangeFlag (Flag - Net Change) FAQ
LTLV	LeadtimeLevel (Leadtime Level)	A value that represents the leadtime for an item at its assigned level in the production process, as defined on Plant Manufacturing Data. The system uses this value to calculate the start dates for work orders using fixed leadtimes. Level leadtime is different for purchased and manufactured items: Purchased - The number of calendar days required for the item to arrive at your branch/plant after the supplier receives your purchase order. Manufactured - The number of workdays required to complete the fabrication or assembly of an item after all the components are available. You can enter level leadtime manually on Manufacturing Values Entry, or you can use the Leadtime Rollup program to calculate it. To calculate level leadtime using the Leadtime Rollup program, you must first enter a quantity in the Manufacturing Leadtime Quantity field in the Item Branch table (F4102).
OPC	OrderPolicyCode (Order Policy Code)	A code that specifies the rules for inventory reordering in the Requirements Planning and Procurement systems. Valid values are: 0 - Reorder point (Not planned by MPS/MRP/DRP) 1 - Lot-for-lot or as required 2 - Fixed order quantity 3 - Economic order quantity (EOQ) 4 - Periods of supply 5 - Rate scheduled item Note: These values are hard-coded.	Default Value = 1 UDC H41/OP - Order Policy Code
OPV	OrderPolicyValue (Value - Order Policy)	A value that the system uses in conjunction with the order policy code to represent one of the following: When you select order policy code 2 (fixed order quantity), this value represents the fixed order quantity. When you select order policy 4 (periods of supply), this value represents the number of days of net requirements that the system uses to determine order size. When you select order policy code 5 (rate scheduled item), this value represents the desired inventory level. When the ending available quantity is less than the desired inventory level, then the system issues an "increase rate to" message. When the ending available quantity is greater than the desired inventory level, then the system issues a "decrease rate to" message.
LTPU	LeadtimePerUnit (Leadtime Per Unit)	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 this value manually or you can have the system calculate it when you run the Leadtime Rollup program. The system overwrites this value when you run the Leadtime Rollup program. The system uses this field to calculate start dates for work orders when you use variable leadtimes.
MPSP	PlanTimeFenceRule (Planning Time Fence Rule)	A code (system 34, table TF) that the system uses in conjunction with the Planning Time Fence Days field to determine how forecast demand or actual customer demand is used. For example: S tells the system to plan using customer demand before the time fence and forecast after the time fence F tells the system to plan using forecast before the time fence and forecast plus customer demand after the time fence If you enter 5 in the Planning Time Fence Days field and S in this field, then the system uses only customer demand for the regeneration for the first 5 days. After 5 days, the system uses the forecast for the regeneration. Valid codes are: C Customer demand before, greater of forecast or customer demand after F Forecast before, forecast plus customer demand after G Greater of forecast or customer demand before, forecast after S Customer demand before, forecast after 1 Zero before, forecast after 3 Zero before, forecast plus customer demand after	UDC 34/TF - Time Fence Rule. Default Time Fence Code 'G' if value is not specified.
MRPP	FixedVariableLeadtime (Fixed or Variable Leadtime)	A code that determines whether the system uses fixed or variable leadtimes. This code works in conjunction with the value from either the Level Leadtime field or the Leadtime Per Unit field. Valid codes are: F Fixed leadtime - The system calculates work order start dates using the value from the Leadtime Level field. V Variable leadtime - The system calculates work order start dates using the value from the Leadtime Per Unit field.	Default Value = F UDC H41/MS - Fixed or Variable Lead Time
MTF1	PlanningTimeFenceDays (Planning Time Fence Days)	The number of days that the system uses in conjunction with the time fence rule to determine how the forecast is used. Enter the number of days after the start date when the time fence rule changes from the first rule to the second rule. For example, if the time fence rule is S (customer demand before the time fence, forecast after the time fence), the generation start date is 01/03/05,and the planning time fence is 3 days, the system plans using customer demand through 01/06/05. Beginning on 01/07/05, the system plans using the forecast. Note that: o The system does not count the generation start date; that is, the day after the generation start date is day 1. o For manufactured items, the system counts working days, as defined in the Shop Floor Calendar. o For purchased items, the system counts calendar days.
MTF2	FreezeTimeFenceDays (Freeze Time Fence Days)	The number of days from the generation start date within which the system does not generate action messages. For example, if the generation start date is 01/03/05, and the freeze time fence is 3 days, the planning system does not generate messages with required dates that are less than or equal to 01/06/05. Note: o The system does not count the generation start date; that is, the day after the generation start date is day 1. o For manufactured items, the system counts working days, as defined in the shop floor calendar. o For purchased items, the system counts calendar days.
MTF3	MsgTimeFenceDays (Message Time Fence Days)	The number of days after the generation start date within which the system should display order messages. For example, if the generation start date is 01/01/05, and the message time fence is 30 days, the system displays messages with dates less than or equal to 01/31/05. The system does not display messages with dates of 02/01/05 or later. However, the planning horizon for orders continues past this date and is reflected in available to promise totals. Note that: o The system does not count the generation start date; that is, the day after the generation start date is day 1. o For manufactured items, the system counts working days, as defined in the Shop Floor Calendar. o For purchased items, the system counts calendar days.
QUED	QueueHours (Queue Hours - Standard)	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 the Item Branch table (F4102). You can calculate this value using the Leadtime Rollup program or you can enter it manually. When you run the Leadtime Rollup program, the system overrides manual entries and populates the table with calculated values.
SETL	SetupLaborHrsStdr (Setup Labor - Standard)	The standard setup hours that you expect to incur in the normal completion of this item. This value is not affected by crew size.
SRNK	ShrinkFactor (Shrink Factor)	A fixed quantity or percentage that the system uses to determine inventory shrinkage for an item. The system increases the planned order quantity by this amount in MPS/MRP/DRP generation. The shrink factor method you specify for the item determines whether the shrink factor is a percentage or a fixed quantity. If you are entering a percentage, enter 5% as 5.00 and 50% as 50.00.
SRKF	ShrinkFactorMethod (Shrink Factor Method)	A value that determines whether the shrink factor you enter for this item is a percentage or a fixed quantity. Valid values are: % Percentage of order or requested quantity F Fixed amount to be added to quantity	Default Value = % UDC H40/SR - Shrink Factor Method
TIMB	TimeBasisCode (Time Basis Code)	A user defined code (30/TB) that indicates how machine or labor hours are expressed for a product. Time basis codes identify the time basis or rate to be used for machine or labor hours entered for every routing step. For example, 25 hours per 1,000 pieces or 15 hours per 10,000 pieces. You can maintain the time basis codes in Time Basis Codes. The system uses the values in the Description-2 field on the User Defined Codes form for costing and scheduling calculations. The description is what the code represents, but is not used in calculations.	Default Value = 4 (hours per 10000 units) UDC 30/TB - Time Basis
MULT	QtyOrderMultiples (Quantity - Order Multiples (MRP))	A multiple for rounding up planned order quantities in MPS/MRP. The system rounds up the planned order quantity to the nearest multiple you enter in this field.
LLX	LowLevelCode (Low Level Code)	This identifies the lowest level in any bill of material at which a particular component may appear..
PNYN	ProductionNumberControlled (Production Number Controlled)	An option that indicates whether an item is production number controlled. You can enable production number control by item using the Item Master (P4101) or Item Branch Plant (P41026) programs. If you clear this option, the item is not production number controlled. If you select this option, the item is production number controlled.	* (E1 9.1 and above) Default Value = N (Not Controlled) Value IN ('Y', 'N')
LEDD*	LotEffectiveDefaultDays (Lot Effective Default Days)	The number of days that an item must remain in inventory before the system considers the item to be available for sales and manufacturing commitments. To calculate the lot effective date, the system adds the number that you enter in this field to the based on date that appears in the Lot Master table (F4108).	0 or positive integer value (Greater than or equal to 0)
PEFD*	PurchasingEffectiveDays (Purchasing Effective Days)	The number of days after a purchased item is received that a lot becomes available. The system uses this number when calculating and displaying the effective date field in the Purchase Orders program (P4310) and the PO Receipts program (P4312).	0 or positive integer value
PRPX*	GenericReportCode (Master Planning Family)	A user defined code (system 41, type P4) under which you can organize logically related items. You can simplify the master planning process by concentrating on only the top 10% of the inventory value. This is similar to using the ABC Analysis, except that you can use this code to allow exceptions to ABC rules. Generally, you should only include items with high inventory investment in Master Planning. Excess stock can be carried for inventory items with little financial impact.	UDC 41/P4 - Master Planning Family

Note:

Columns reference in F4101 (based on F4102.ITM)

Alias	DD Item/Description	Explanation	Others/Editing
UOM1	UnitOfMeasurePrimary (Unit of Measure - Primary)	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 (each) or KG (kilogram).	UDC 00/UM - Unit of Measure
CLEV	CostLevel (Level - Inventory Cost)	A code that indicates whether the system maintains one overall inventory cost for the item, a different cost for each branch/plant, or a different cost for each location and lot within a branch/plant. The system maintains inventory costs in the Inventory Cost table (F4105). Valid codes are: 1 Item level 2 Item/Branch level 3 Item/Branch/Location level	Default Value = 2 UDC H40/CL - Inventory Cost Level
TFLA	TemporaryItemFlashMessag (Standard Unit of Measure Conversion)	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 unit of measure 1 Bypass the item-specific unit of measure and use the standard unit of measure	UDC H40/ST - Standard Units of Measure
SNS	StockNonstock (Round to Whole Number)	A code that determines whether the system performs rounding for planning purposes. Valid values are: R Round either up or down to the nearest whole number. U Round up to the nearest whole number. Blank Do not round. Example of value R: If the calculated requirements for an item are 4.6, the system rounds the quantity required to 5.0. If the calculated requirements are 4.4, the system rounds the quantity required to 4.0. Example of value U: If the calculated requirements for an item are greater than 4.0 and less than or equal to 5.0, the system rounds the quantity required to 5.0.	UDC H41/SN - Whole Number Round

Note:
Back To Top

Processing Option of R3483

T	Description	Structure Member Name	Glossary	Alias	Processing Option Help Glossary
Horizon
	1. Generation Start Date	jdGenStartDate	S348301	DATE01	Use this processing option to specify the date the program uses to start the planning process. This date is also the beginning of the planning horizon.
	2. Past Due Period 0 (default) 1 2	nPastDuePeriods	S348302	INT01	The program includes supply and demand from this number of periods prior to the Generation Start Date. Valid values are: 0 0 periods (default) 1 1 period 2 2 periods
	3. Planning Horizon Periods Number of planning days	nPlanningDays	S348303	INT02	Use this processing option to specify the number of days to be included in the plan. For example, when you view the time series, you see daily data for the number of planning days, then weekly data for the number of planning weeks, then monthly data for the number of planning months.
	Number of planning weeks	nPlanningWeeks	S348304	INT03	Use this processing option to specify the number of weeks to be included in the plan. For example, when you view the time series, you see daily data for the number of planning days, then weekly data for the number of planning weeks, then monthly data for the number of planning months.
	Number of planning months	nPlanningMonths	S348305	INT04	Use this processing option to specify the number of months to be included in the plan. For example, when you view the time series, you see daily data for the number of planning days, then weekly data for the number of planning weeks, then monthly data for the number of planning months.
Parameters
	1. Generation Mode 1 = net change 2 = gross regeneration	cNetChangeFlag	S348306	EV01	A gross regeneration includes every item specified in the data selection. A net change includes only those items in the data selection that have changed since the last time you ran the program. Valid values are: 1 net change 2 gross regeneration
	2. Generation Type 1 =single level MPS/DRP 3 = multi-level MPS 4 = MRP with or without MPS 5 = MRP with frozen MPS	cGenerationType	S348307	EV02	Please see the help for the Parameters tab for detailed information. Valid values are: 1 single-level MPS/DRP 3 multi-level MPS 4 MRP with or without MPS 5 MRP with frozen MPS
	3. UDC Type	szUserDefinedCodes[3]	S348308	RT	Use this processing option to specify the UDC table (system 34) that contains the list of quantity types to be calculated and written to the Time Series table (F3413). Default = QT.
	4. Version of Supply/Demand Inclusion Rules	szResourceVersion[4]	S348309	MVER	Use this processing option to define which version of supply/demand inclusion rules the program reads. These rules define the criteria used to select orders for processing.
On-Hand
	1. Include Lot Expiration Dates blank = do not include 1 = include	cEverestEventPoint18	S348310	EV18	Use this processing option to specify whether the system considers lot expiration dates when calculating on-hand inventory. For example, if you have 200 on-hand with an expiration date of August 31, 2005, and you need 200 on September 1, 2005, the program does not recognize the expired lot and creates a message to order or manufacture more of the item to satisfy demand. Valid values are: blank do not consider lot expiration dates when calculating on-hand inventory 1 consider lot expiration dates when calculating on-hand inventory
	2. Safety Stock Decrease blank = do not decrease 1 = decrease	cEverestEventPoint04	S348311	EV04	Use this processing option to specify whether to plan based on a beginning available quantity from which the safety stock quantity has been subtracted. Valid values are: blank do not decrease 1 decrease
	3. Receipt Routing Quantities Quantity in Transit blank = do not include in on-hand inventory 1 = include in on-hand inventory	cEverestEventPoint05	S348312	EV05	In a manufacturing environment, sometimes it is necessary to establish where stock is, in order to determine whether or not it is available for immediate use. Enter 1 if you want quantities in transit to be included in the Beginning Available calculation on the time series. Otherwise, the program includes these quantities in the In Receipt (+IR) line of the time series. The quantities are still considered available by this program. The difference is only in how you view the quantities in the time series. Valid values are: blank do not include in on-hand inventory 1 include in on-hand inventory
	Quantity in Inspection blank = do not include in on-hand inventory 1 = include in on-hand inventory	cEverestEventPoint06	S348313	EV06	Use this processing option to specify whether to include quantities in inspection when the system calculates the Beginning Available amount. Otherwise, the system includes these quantities in the In Receipt (+IR) line of the time series. The system still considers the quantities available, but the way you view the quantities in the time series differs. Valid values are: Blank Do not include quantities in on-hand inventory. 1 Include quantities in on-hand inventory.
	User Defined Quantity 1 blank = do not include in on-hand inventory 1 = include in on-hand inventory	cEverestEventPoint07	S348314	EV07	In a manufacturing environment, sometimes it is necessary to establish where stock is, in order to determine whether or not it is available for immediate use. Enter 1 if you want these user defined quantities (defined on Receipt Routings Revisions in the Update Operation 1 field) to be included in the Beginning Available calculation. Otherwise, the program includes these quantities in the In Receipt (+IR) line of the time series. The quantities are still considered available by this program. The difference is only in how you view the quantities in the time series. Valid values are: blank do not include in on-hand inventory 1 include in on-hand inventory
	User Defined Quantity 2 blank = do not include in on-hand inventory 1 = include in on-hand inventory	cEverestEventPoint08	S348315	EV08	In a manufacturing environment, sometimes it is necessary to establish where stock is, in order to determine whether or not it is available for immediate use. Enter 1 if you want these user defined quantities (defined on Receipt Routings Revisions in the Update Operation 2 field) to be included in the Beginning Available calculation. Otherwise, the program includes these quantities in the In Receipt (+IR) line of the time series. The quantities are still considered available by this program. The difference is only in how you view the quantities in the time series. Valid values are: blank do not include in on-hand inventory 1 include in on-hand inventory
	4. Lot Hold Codes (up to 5) blank = include no held lots in calculation of on-hand inventory * = include all held lots in calculation of on-hand inventory	szVideoConstant05A[6]	S348316	VC05A	Use this processing option to specify the lots to be included in the calculation of on-hand inventory. You can enter a maximum of 5 lot hold codes (41/L). blank include no held lots in calculation of on-hand inventory * include all held lots in calculation of on-hand inventory
	5. Include Past Due Rates as a supply blank = do not include 1 = include	cPastDueRatesFlag	S348346	EV20	Use this processing option to specify whether the system considers open quantity from past due rate orders as supply. If you enter 1, open quantities from past due rate orders are included in the rate schedule unadjusted (+RSU) line as well as the rate schedule adjusted (+RS) line of the Master Planning Schedule - Multiple Plant program (R3483). Valid values are: Blank Do not consider past due orders as supply. 1 Consider past due orders as supply.
Forecasting
	1. Forecast Types Used ( up to 5)	szForecastTypes[11]	S348317	VC10A	Forecasts are a source of demand. You can create forecasts using 12 different forecast types (34/DF) within the Forecasting system. One is considered the Best Fit (BF) type compared to an item's history of demand. Use this processing option to define which forecast quantities created by which forecast type are included in the planning process. Enter multiple values with no spaces, for example: 0102BF.
	2. Forecast Consumption Logic blank = do not use forecast consumption 1 = use forecast consumption 2 = use forecast consumption by customer	cUseForecastConsumption	S348318	EV19	Use this processing option to specify whether the system uses forecast consumption. If you use forecast consumption, any sales order due in the same period as the forecast is included as part of the forecast for that period. The sales order is not considered an additional source of demand. For forecast consumption to be used, the planning fence rule for the item must be H and the planning fence must be 999. You enter these values on the Plant Manufacturing Data form. Note: When you use forecast consumption, the system applies forecast consumption logic to the aggregate sales order and forecast quantities. Blank Do not use forecast consumption. 1 Use forecast consumption.
	3. Interplant Demand Consumes Forecast blank = do not use 1 = use	cInterplantConsumesForecast	S348343	EV01	When using forecast consumption, use this processing option to specify whether to use interplant demand to consume forecast. When using any other planning rule, you can use this option to specify whether to consider interplant demand as customer demand. When the option is set, the system considers interplant demand for firm and planned transfer orders. When the option is blank, the system ignores interplant demand by forecast consumption or planning rules and considers interplant demand as a separate source of demand. Valid values are: Blank Do not consider interplant demand as customer demand. 1 Consider interplant demand as customer demand.
	4. Forecast type for forcast consumption by customer	szFcstTypeForFcst CsmptnByCust[3]	S348349	TYPF	Use this processing option to specify the forecast type (34/DF) used by the system to create a forecast for the actual daily demand by customer. This processing option applies when you set the Forecast Consumption Logic processing option to 2 (Forecast Consumption by Customer). This value cannot equal the value in the Forecast Types Used processing option.
	5. Default Customer Address Relationship for Forecast Consumption by Customer 1 = Ship to (default) 2 = Sold to	cCustomerAddressRelationship	S348246	FCCR	Use this processing option when you use forecast consumption by customer logic to specify which address book number on the sales order that the system should use for calculation. Valid values are: 1 Use the ship to address book number. 2 Use the sold to address book number.
Document Types
	1. Purchase Orders	szOrderType[3]	S348319	DCTO	When you receive messages related to purchase order creation, this document type will appear as the default. The default value is OP.
	2. Work Orders	szRelatedOrderType[3]	S348320	RCTO	When you receive messages related to work order creation, this document type will appear as the default. The default value is WO.
	3. Rate Schedule	szScheduleType[3]	S348321	DCTO	When you receive messages related to rate schedule creation, this document type will appear as the default. The default value is AC.
Leadtimes
	1. Purchased Item Safety Leadtime	mnPurchaseLeadtime	S348322	MTF1	For items with stocking type P, the program adds the value you enter here to the item's level leadtime to calculate the total leadtime.
	2. Manufactured Item Safety Leadtime	mnWorkOrderLeadtime	S348323	MTF2	For items with stocking type M, the program adds the value you enter here to the item's level leadtime to calculate the total leadtime.
	3. Expedite Damper Days	mnExpediteDamperDays	S348324	EXPD	Expedite messages are suppressed, starting on the generation start date and continuing for the number of days you enter here.
	4. Defer Damper Days	mnDeferDamperDays	S348325	DEFD	Defer messages are suppressed, starting on the generation start date and continuing for the number of days you enter here.
Performance
	1. Clear F3411/F3412/F3412 Tables blank = do not clear tables 1 = clear tables	cClearFilesFlag	S348326	EV11	Use this processing option with extreme caution! If you enter 1, all records in the MPS/MRP/DRP Message table (F3411), MPS/MRP/DRP Lower Level Requirements (Pegging) table (F3412), and MPS/MRP/DRP Summary (Time Series) (F3413) table are purged. Access to this program should be limited. If multiple users run this program concurrently with this processing option set to 1, a record lock error results and prevents complete processing. Valid values are: blank do not clear tables 1 clear tables
	2. Input the Branch/Plant Where Planning Tables Will Be Cleared blank = all planning tables will be cleared	szDeleteBranchPlant[13]	S348344	MCU	Use this processing option to specify which Branch/Plant records in the MPS/MRP/DRP Message File table, MPS/MRP/DRP Lower Level Requirements File table, and the MPS/MRP/DRP Summary (Time Series) table (F3411, F3412 and, F3413, respectively), are purged. Note: This option is only valid when Clear F3411/F3412/F3413 Tables processing option on the Performance tab is set to 1 and the Delete Branch/Plant processing option contains a valid branch/plant. This processing option enables a preprocess purge of these tables. If this processing option is not enabled or is set to blank, the system purges records for a given branch/plant and item as you plan the item. Depending on processing option combinations, the following scenarios can occur. Example 1: Clear F3411/F3412/F3413 Tables is set to '1.' (a) Delete Branch/Plant is set to blank. All records from the three tables will be prepurged. (b) Delete Branch/Plant contains a valid branch/plant. Records for all the items that belong to the valid branch/plant will be prepurged from the three tables. (c) Delete Branch/Plant contains an invalid branch/plant. No records will be prepurged from the three tables. Example 2: Clear F3411/F3412/F3413 Tables set to Blank Delete Branch/Plant is not active. No records from the three tables will be prepurged.
	3. Initialize MPS/MRP Print Code blank = do not initialize Item Branch file 1 = initialize the Item Branch file	cEverestEventPoint10	S348327	EV10	If you enter 1 in this processing option, the program initializes every record in the Item Branch table (F4102) by setting the Item Display Code (MRPD) to blank. If you leave this field blank, processing time is decreased. The system will not clear the records in the Item Branch table (F4102). Regardless of how you set this processing option, for each item in the data selection the MRPD field is updated as follow: o 1 if messages were not created o 2 if messages were created The Print Master Production Schedule program (R3450) allows you to enter data selection based on the MRPD field. Valid values are: blank Do not initialize the Item Branch file. 1 Initialize the Item Branch file.
	4. Messages And Item Series For Phantom Items blank = do not generate 1 = generate	cEverestEventPoint03	S348328	EV03	Use this processing option to specify whether the program generates messages and time series for phantom items. Valid values are: blank do not generate 1 generate
	5. Ending Firm Order Status blank = all messages exploded	szStatusCodeWo[3]	S348329	SRST	Use this processing option to specify the work order status at which messages are no longer exploded to components. If you leave this field blank, all messages are exploded to components.
	6. Extended Rate Based Adjustments blank = do not extend 1 = extend	cEverestEventPoint09	S348330	EV09	Use this processing option to specify whether adjustments for rate based items are exploded to components, thereby creating messages for the components. Valid values are: blank do not extend 1 extend
	7. Close Rate Status	szStatusCodeWo[3]	S348331	SRST	Use this processing option to specify the status of closed rates. When you plan for a rate-based item, the system does not process rate orders that are at a closed-rate status or a higher status.
	8. Set Key Definition For Table F3411	mnF3411BlockSize	S348345	INT01	Use this processing option to support concurrent MRP/MPS runs. The value that you enter determines the range for the number of records in the F3411/F3412 tables for a given run. The number must be large enough to include the number of records that will be generated for the table. For example, if you enter a value of 8 for the first run and 10 for the second run, the range of records that the system reserves for two simultaneous MRP/MPS runs will include: First run: The system reserves records in the range of 1 to [110^8], or 1 through 1,000,000,000. Second run: The system reserves records in the range of [110^8 + 1] to [2*10^10], or 100,000,001 through 20,000,000,000. Notice that the values that you enter serve as the exponent in the equations above. Valid values are: Default value: 10 Minimum value: 7 Maximum value: 14 Note: This process runs only when a subsequent MRP/MPS job is submitted while an existing job is currently running. The MRP/MPS Requirements Planning program (R3482) and Master Planning Schedule - Multiple Plant program (R3483) enforce these values. You determine the optimal value for the key definition. All values for this table should be the same for all versions. If version settings are not the same, the results are unpredictable.
	9. Set Key Definition For Table F3412	mnF3412BlockSize	S348345	INT01	Same with above
	10. Set Maximum Number of Branches	nMaxnumberofBranches	S348347	INT01	Use this processing option to specify the maximum number of branches that the system processes when you run the Master Planning Schedule - Multiple Plant program (R3483). Since this processing option controls the allocation of memory for arrays, you should use the minimum number of branches necessary. Caution: J.D. Edwards supports up to ninety-nine locations. If you specify more locations that ninety-nine, the program might generate unpredictable results. J.D. Edwards strongly recommends that you make incremental adjustments to this value. √ If you do not specify value here 100 is to be defaulted. In case the number of branch/plant for planning exceeds 100 then you may hit memory error against B3400360 - MRPWriteDateBuckets (MRP, Write Date Buckets) because memory is not allocated for it.
	11. Suppress Time Series blank = generate time series 1 = do not generate time series	cSuppressTimeSeries	S348348	EV01	Use this processing option to specify whether the system generates the time series. Valid values are: Blank Generate the time series. 1 Do not generate the time series. Note: Performance improves when the time series is not generated.
	12. Planning Control UDC Type	szPlanningControlUDCType[3]	S348350	RT	Use this processing option to specify the UDC table in system 34 that contains the list of planning control flags. The default value is PC. This value determined whether to caching tables F4101, F4102 and F4801
Mfg Mode
	1. Process Planning blank = discrete 1 = process	cProcessPlanning	S348332	EV17	If you use process manufacturing, enter 1 to generate the plan based on the forecasts of the co-/by-products for the process. The program then creates messages for the process. Valid values are: blank discrete 1 process
	2. Configurator Functionality blank = do not include configured components 1 = include configured components	cConfigaratorPlanning	S348237	EV01	Use this processing option to specify whether the system processes configurator components from the Configurator Component Table (F3215) and adds them to the Sales Order Detail File table (F4211) and the Work Order Parts List table (F3111). If you enter a 1 in this processing option, the system processes the items on the Configurator Components table as demand items. Blank Do not process items from the Configurator Component Table. 1 Process items from the Configurator Components table.
	3. Project Planning blank = do not include 1 = include	cMultiplantProjectPlanning	S348243	EV01	Use this processing option to specify whether the system includes supply and demand from items that are associated with a project. Project-specific items have a stocking type of P. Valid values are: Blank Do not include items associated with projects. 1 Include items associated with projects.
Multi-Facility
	1. Date Branch	szDefaultDateBranch[13]	S348334	MCU	Enter the default branch/plant from which to retrieve the shop floor calendar. If you leave this field blank, the calendar for each branch/plant is used and processing time increases.
	2. Consolidation Method 1 = simple consolidation 2 = branch relationships ( default)	cEverestEventPoint13	S348335	EV13	The simple consolidation method (1) adds the supply and demand for each branch, calculates a new time series, and places the result in the consolidated branch specified in the Consolidation Branch processing option. The branch relationships method (2) uses the Branch Relationships table. This is the default. Valid values are: 1 simple consolidation 2 branch relationships (default)
	3. Consolidation Branch	szCostCenterAlt[13]	S348337	MMCU	If your consolidation method is 1 (simple consolidation), enter the branch/plant to contain the consolidated results. If the consolidated branch/plant also contains its own time series data, that data is included in the totals.
	4. Category Code 1 = 41/P1 2 = 41/P2 3 = 41/P3 4 = 41/P4 5 = 41/P5	cEverestEventPoint15	S348338	EV15	If your consolidation method is 2 (branch relationships), enter the category code of the part that is supplied by one branch/plant to another. There are five user defined category code tables. Valid values are: 1 41/P1 2 41/P2 3 41/P3 4 41/P4 5 41/P5
	5. Manufacturing At Origin blank = create transfer orders for manufactured and purchased items 1 = create transfer orders only for purchased items	cEverestEventPoint16	S348339	EV16	Enter 1 if there are manufactured and purchased items in the same category code, but you only want to obtain the purchased items from another branch/plant. Transfer order messages are created for purchased items, and work order messages are created for manufactured items. Valid values are: blank create transfer orders for manufactured and purchased items 1 create transfer orders only for purchased items
	6. Transfer Order Document Type blank = OT	szDocumentType[3]	S348340	DCT	When you receive messages related to transfer order creation, this document type will appear as the default. The default value is OT.
Parallel
	1. Number of Subsystem Jobs 0 = Default	mnMathNumeric06	S348341	MATH06	Use this processing option to specify the number of subsystems in a server. The default is 0 (zero).
	2. Pre Processing blank = Do not perform processing 1 = Perform pre processing	cPreProcessing	S348342	EV01	Use this processing option to specify whether the system runs preprocessing during parallel processing. During preprocessing, the system checks supply and demand and plans only the items within supply and demand. Preprocessing improves performance when you run MRP and is valid only when the number of items actually planned is less than the total number of items in the data selection. Valid values are: Blank The system does not run preprocessing. 1 The system runs preprocessing.

Note:

ref1
B3401360 - ProcessMessagesBeginDoc (Process Messages Begin Doc)

Purpose: Initialize MRP process by getting Job Number and Machine ID. Though this is a part of Master Business Function (Process Message MBF) which is comprised 'ProcessMessageBeginDoc', 'ProcessMessagesEditLine' and 'ProcessMessagesEndDoc' but for MRP only Begin Doc routine gets called.
Parameter:

Data Structure: D3401360A - Data Structure for Process Messages Begin Doc

Parameter Name	Data Item	Data Type	I/O	Others
mnJobnumberA*	JOBS	MATH_NUMERIC	O	RV JOBS-Job Number-GV. Job Number range 1 through 1000
szComputerID*	CTID	char	O	RV CTID-ComputerID-GV. Machine Name where R3483 is running.
szVersion	VERS	char		Not In Use

Detail Routine:

1. Retrieve Computer ID through BSFN B9800181 - GetLocalComputerId (Get Local Computer ID) : this will be used basic key for cache to be created along the process
2. Get Job Number: lJobNumber is returned through JDE API JDB_GetInternalNextNumber(). The value is to be 1 to 1000. JobNumber set here will be used till end of routine by storing it as Global Variable

Error: N/A

ref2
B3400520 - UpdateF4102PrintCode (F4102 Update Print Code)

Purpose: The purpose of this function is to blank out the Item Display Code (MRPD) in each record in the Item Branch table (F4102). This function duplicates the functionality of the RPG program P34815, Update MPS/MRP Print Code. The function sets the Item Display Code (MRPD) column of all records in the Item Branch table (F4102) to blank (' ') only when R3483 is not called from the subsystem in parallel processing mode.
Parameter:

Data Structure: D3400520 - Data Structure for Update F4102 Print Code

Parameter Name	Data Item	Data Type	I/O	Others
szErrorMessageID	DTAI	char	O	Not In Use
cErrorCode	ERRC	char	O	Not In Use
cSuppressErrorMessages	EV01	char	I	Hard Coded value '1' not to stop process

Detail Routine: This function simply update F4102.MRPD for all MCU, ITM only when the processing option parameter item #Initialize the Item Branch file (in Performance Tab) is 1 (=Initialize the Item Branch file.)
Error Code: N/A
Business Function Documentation: Refer to attachment b3400520.rtf

Ref3
B3401280 - CacheProcessMRPCoByProducts (Cache, Process MRP Co/By Products)

Purpose: This function will perform Get, Add, Update, Delete, Delete All, Get Next, Add/Update, and Terminate functions on the MRP Co/By Products Cache used in the MRP/MPS planning programs (P3482 and P3483). The calling application is responsible for loading all appropriate key values to the data structure and identifying the number of keys to use in retrieval/update processes. This function creates a unique cache for each MRP/MPS planning process. The function appends the input Job Number string to the two character ID 'CB' to build the cache name used for the calling application.
Parameter:

Data Structure: D3401280 - Cache, Process MRP Co/By Products

Parameter Name	Data Item	Data Type	I/O	Others
szJobNumber	JOB	char	I	RV JOB-Job Number String-GV
szBranch*	MCU	char		Cache Key
mnShortItemNumber*	ITM	MATH_NUMERIC		Cache Key
mnBillRatio	MN29D9	MATH_NUMERIC		Cache Member
cCacheErrorCode	EV01	char
nNumberOfKeys	INT01	integer
cSuppressErrorMessage	SUPPS	char
szErrorMessageID	DTAI	char	I	1 to Suppress Error
cCacheActionCode	EV02	char	I	Refer Cache Action Code above
idCacheCursorPtr	GENLNG	ID
cSequentialFetch	EV02	char

Detail Routine: Called only once in Report Level Event (Initialize Report) to initialize Co/By Cache 'CB' to initialize cache. Other cache actions are to be called in other business functions which deals with BOM (e.g., B3401230 and so on.)

Business Functions which call B3401280

B3400440 - MRPWriteWorkOrderQtyIntoCache (MRP, Write Work Order Qty Into Cache): This function will Co/By product demands into the F34UI005 table which add/update the Unadjusted Qtys into the Item Qty Cache.
B3401230 - F3002LoadCoProductsFromBill (F3002 Load CoProducts From Bill): In reading F3002, look for ixkit in the MRP CoByProduct Cache. If not found or if the BillRatio value in the Cache is zero, then Get Conversion Factor for ITM if the UoMs are different. Retrieve the Item Master info for KIT. Retrieve the Item Branch record for KIT. Get Conversion Factor for KIT if the UoMs are different. Store IXKIT and IXBQTY in the user index table.
B3401240 - (In R3482) PlanAndScheduleProcessOrders (MRP, Update Plan And Schedule Process Orders): Call the functions to load date, co/by product numbers, and quantity data into the arrays from the User Index table F34UI005, the MRP Bucketless Date Cache, and the MRP Item Quantity Cache. Fetches all Co/By Product data from the MRP Co/By Product Cache and stores it in the arrays.
B3401400 - MRPWriteRateQtyIntoCache (MRP, Write Rate Qty Into Cache): This function will Co/By product demands into the F34UI005 table. This function will add/update the Unadjusted Qtys into the Item Qty Cache.
N3500110 - MRPMultiplePlantLoadAndPlan (MRP, Multiple Plant Load and Plan): To terminate Co/By Quantity Cache if any.

Error Codes: N/A
Related Functions

B3401270 - Cache, Process MRP Bucketless Dates

Business Function Documenation: b3401280.rtf

Ref4
B3500060 - CacheProcessMultiPlants (Cache, Process Multi Plants)

Purpose: This function will perform Get, Add, Update, Delete, Delete All, Get Next, Add/Update, and Terminate functions on the MRP Multi-Plants Cache used in the Multi-Plant MRP/MPS planning programs (R3483). The calling application is responsible for loading all appropriate key values to the data structure and identifying the number of keys to use in retrieval/update processes. This function creates a unique cache for each Multi-plant MRP/MPS planning process. The function appends the input Job Number string to the two character ID 'MP' to build the cache name used for the calling application.
Parameter

Data Structure: D3500060 - Cache, Process Multi Plants

Parameter Name	Data Item	Data Type	I/O	Others
szJobNumber	JOB	char	I	RV JOB-Job Number String-GV
szBranch *	MCU	char	I	(write) Cache Key, RV MCU-DateBranch-GV (read) VA evt_szDateBranch
cRecordType *	EV01	char	I	Cache Key, 'D' - Hard Coded. Across system only cRecordType 'D' is used
nNumberOfBucketlessDates	INT01	integer	I O	(write) Cache Value, VA sec_iNumBucketlessDates (= B3400360.nNoOfBucketlessElements) (read) VA evt_iNumBucketlessDates
nNumberOfBucketDates	INT01	integer	I O	(write) Cache Value, VA sec_iNumBucketDates (= B3400360.nNoOfBucketElements) (read) VA evt_iNumBucketDates
jdStartDate	DATE01	JDEDATE	I O	(write) Cache Value, VA sec_jdFirstDateFIRST (= B3400360.jdStartDate) (read) VA evt_jdFirstDate_FIRST
jdEndDate	DATE01	JDEDATE	I O	(write) Cache Value, VA sec_jdEndDateENDD (= B3400360.jdEndDate) (read) VA evt_jdEndDate_ENDD <- BF jdEndDate
jdFirstDate	DATE01	JDEDATE	I O	Cache Vaue, VA sec_jdFirstDateFIRST (= B3400360.jdStartDate) (read) VA evt_jdFirstBeginDate_FBEG
jdBeginDate	DATE01	JDEDATE	I O	(write) Cache Value, VA sec_jdFirstBegDateFBEG (= B3400360.jdFirstBeginningDate) VA evt_jdBeginDate_BEG
jdForecastConsumptionBeginDate	DATE01	JDEDATE	I O	(write) Cache Value, VA sec_jdForecastBeginDateFBDT (=B3400360.jdForecastConsumptionBeginDate) (read) VA evt_jdForecastBeginDate_FBDT
nNumberOfElements	INT01	integer		Not In Use
cCacheActionCode	EV01	char	I	Before adding any cache with 2 (Add Cache) check whether there is existing cache with 1 (To Get Cache) (read) 1 - First Read
cCacheErrorCode	EV01	char	O	If there is any error
nNumberOfKeys	INT01	integer	I	(write) <zero> hard coded (read) 2 (based on szDateBranch and 'D')
cSuppressErrorMessage	SUPPS	char	I	1 (hard coded) to suppress error.
szErrorMessageID	DTAI	char		Not In Use
idCacheCursorPointer	GENLNG	ID		Not In Use
cSequentialFetch	EV02	char	I	<Blank>
jdFirstDateInCache	DATE01	JDEDATE	I	VA sec_jdFirstDateInCache (= B3400360.jdFirstDateInCache)

Detail Routines:

When action code GET is used, the function saves the cache cursor pointer if the fetch is successful and SequentialFetch = '1'. This allows the calling application to use GET NEXT to fetch elements from the cache sequentially. If GET NEXT is called until the end of the keyed cache dataset is found, the function automatically closes the open cursor. Otherwise, the calling application is responsible for closing the cursor.
This function creates a unique cache for each Multi-plant MRP/MPS planning process. The function appends the input Job Number string to the two character ID 'MP' to build the cache name used for the calling application.
If date information was not found for this branch, call B3400360 ( MRPWriteDateBuckets (MRP, Write Date Buckets)) to build the date information for the first time. This business function loads the MRP Bucketless Date Cache used in MRP planning program from the work day calendar table F0007 depending on the No of days, Weeks and Months sent in. It will also flag the bucket dates, and Load the No of days in week/month. It will calculate the Start date, End Date, No of Buckets loaded. It will load the past due periods depending on the input.
This business function can be called from R3483 from Initialize Section, Do Section and End Section and can be updated by business functions listed below,

Business functions calling B3500060

B3400370 - MRPWriteOnHandLotQtyToCacheA (MRP, Write On Hand/Lot Qty to Cache)
B3400400 - MRPUpdateAdjustedSalesAndForecas (MRP, Update Adjusted Sales and Forecast Qty)
B3400500 - (Called by N3500110, B3400500) - MRPCalculatePlanAndScheduleOrder (MRP, Calculate, Plan and Schedule Orders)
B3500040 - (Called by B3400500, B3500080) - MRPCalculateAvailableTransferQty (MRP, Calculate Available Transfer Qty from Cache)
B3500070 - (Called by N3500110) - MRPMultiPlantConsolidateOnHand (MRP, Multi-Plant Consolidate OnHand Qty)
B3500080
B3500090
B3500130
B3500140

Error Code:
Business Function Documentation: b3500060.rtf

Ref5
B3500140 CacheProcessMultiplantSequence (Cache, Process Multiplant Sequence)

Purpose: This Cache Function replaces the user index table F35UI001. This function performs Get, Add, Update, Delete, Delete All, Get Next, Add/Update, and Terminate functions on the Multiplant Quantity Cache used in the MRP/MPS planning program, R3483. This Cache functions uses multiple indices.
Parameters:

Data Structure: D3500140 - Cache, Process Multiplant Sequence

Parameter Name	Data Item	Data Type	I/O	Others
mnJobNumber	JOBS	MATH_NUMERIC	I	BF mnJobNumber
szComputerID	CTID	char	I	BF szComputerID
szBranch	MCU	char	O	VA evt_szF35UI001BusinessUnit
mnBranchSequence	BRSQ	MATH_NUMERIC
mnQtyOnHand	PQOH	MATH_NUMERIC	O	VA evt_mnBeginingAvailable
mnQuantityTransaction	TRQT	MATH_NUMERIC
cProcessedFlag	EV01	char
szPlanningFamily	PRPX	char	O	VA evt_szCategoryCode_PRPX
cCacheActionCode	EV02	char		1 (CACHE_GET) then 6 (CACHE_GET_NEXT)
cCacheErrorCode	EV03	char	O	VA evt_cErrorCode_ERRC
nNumberOfKeys	INT01	integer		2
cSuppressErrorMessage	SUPPS	char		1
szErrorMessageID	DTAI	char
idCacheCursorPointer	GENLNG	ID	I/O	VA evt_idCursorPointer_GENLNG
cSequentialFetch	EV04	char	1
nIndexNumber	INT02	integer	2

Detail Routine: MULTIPLANT_CACHE_ID _J("PM")
Error:
Back To Top

Ref6
B3401300 - CacheProcessMRPInclusionRules (Cache, Process MRP Inclusion Rules)

Purpose: This function will perform Get, Add, Update, Delete, Delete All, Get Next, Add/Update, and Terminate functions on the MRP Inclusion Rule Cache used in the MRP/MPS planning programs (P3482 and P3483). This function creates a unique cache for each MRP/MPS planning process. The function appends the input Job Number string to the two character ID 'IR' to build the cache name used for the calling application. NOTE: Before using this function to verify existence of a inclusion status, you must pre-load the cache with all the included status for the given Resource Version Rule by calling this function in mode '9' and passing in the Resource Inclusion Version to use. You may only call this function in mode '9' ONCE.
Parameter:

Data Structure: D3401300 - Cache, Process MRP Inclusion Rules

Parameter Name	Data Item	Data Type	Others
szJobNumber	JOB	char
szOrderType *	DCTO	char	Cache Key
szLineType *	LNTY	char	Cache Key
szStatus *	TRTY	char	Cache Key
cCacheActionCode	EV01	char
cCacheErrorCode	EV02	char
nNumberOfKeys	INT01	integer
cSuppressErrorMessage	SUPPS	char
szErrorMessageID	DTAI	char
szResourceInclusionVersion	MVER	char

Related Functions
B3401270 Cache, Process MRP Bucketless Dates

Related Tables
F34004 Demand/Supply Inclusion Rules

Detail Routine:
Error:
Business function documentation: b3401300.rtf
Back To Top

Ref7
B3401310 CacheProcessMRPWorkOrders (Cache, Process MRP Work Orders)

Purpose: This function will perform Get, Add, Update, Delete, Delete All, Get Next, Add/Update, and Terminate functions on the MRP Work Order Cache used in the MRP/MPS planning programs (P3482 and P3483). The calling application is responsible for loading all appropriate key values to the data structure and identifying the number of keys to use in retrieval/update processes. This function creates a unique cache for each MRP/MPS planning process. The function appends the input Job Number string to the two character ID 'WO' to build the cache name used for the calling application.
Parameters:

Data Structure: D3401310 - Cache, Process MRP Work Orders

Parameter Name	Data Item	Data Type	Others
szJobNumber	JOB	char
mnShortItemNumber *	ITM	MATH_NUMERIC	Cache Key
szBranch *	MCU	char	Cache Key
jdDate *	DRQJ	JDEDATE	Cache Key
mnOrderNumber	DOCO	MATH_NUMERIC	Cache member
szOrderType	DCTO	char	Cache member
szStatus	SRST	char	Cache member
jdStartDate	STRT	JDEDATE	Cache member
mnOpenQuantity	UORG	MATH_NUMERIC	Cache member
mnWorkOrderQuantity	UORG	MATH_NUMERIC	Cache member
szTypeOfBill	TBM	char	Cache member
cExpediteFlag	EV01	char	Cache member
idCacheCursorPtr	GENLNG	ID
cSequentialFetch	EV02	char
cCacheActionCode	EV02	char
cCacheErrorCode	EV01	char
nNumberOfKeys	INT01	integer
cSuppressErrorMessage	SUPPS	char
szErrorMessageID	DTAI	char
cComparisonFlag	EV01	char
jdDateSave	DRQJ	JDEDATE
cDeferFlag	EV01	char
nIndexNumber	INT02	integer
jdDateRecommendedStart	RSTJ	JDEDATE
jdRecommendedDeliveryDate	REDJ	JDEDATE
jdDateRequestedSave	DRQJ	JDEDATE
jdOriginalEffectiveDateSaved	OEDJ	JDEDATE
mnProductionNumberShort	PNS	MATH_NUMERIC
cProjectPlanning	EV01	char

Detail Routine:
Error:
Business Function Documentation: b3401310.rtf
Back To Top

Ref8
B3401320 CacheProcessMRPPurchaseOrders (Cache, Process MRP Purchase Orders)

Purpose: This function will perform Get, Add, Update, Delete, Delete All, Get Next, Add/Update, and Terminate functions on the MRP Purchase Order Cache used in the MRP/MPS planning programs (P3482 and P3483). The calling application is responsible for loading all appropriate key values to the data structure and identifying the number of keys to use in retrieval/update processes. This function creates a unique cache for each MRP/MPS planning process. The function appends the input Job Number string to the two character ID 'PO' to build the cache name used for the calling application.
Parameter:

Data Structure: D3401320 Cache, Process MRP Purchase Order

Parameter Name	Data Item	Data Type	Others
szJobNumber	JOB	char
mnShortItemNumber *	ITM	MATH_NUMERIC	Cache key
szBranch *	MCU	char	Cache key
jdPromisedDeliveryDate *	PDDJ	JDEDATE	Cache Key
mnOrderNumber	DOCO	MATH_NUMERIC	Cache element
szOrderType	DCTO	char	Cache element
szCompany	KCOO	char	Cache element
mnLineNumber	LNID	MATH_NUMERIC	Cache element
szOrderSuffix	SFXO	char	Cache element
mnAddressNumber	AN8	MATH_NUMERIC	Cache element
jdOrderDate	TRDJ	JDEDATE	Cache element
mnOpenQuantity	UOPN	MATH_NUMERIC	Cache element
szRelatedOrderNumber	RORN	char	Cache element
szRelatedOrderType	RCTO	char	Cache element
szRelatedCompany	RKCO	char	Cache element
mnRelatedOrderLineNo	RLLN	MATH_NUMERIC	Cache element
cExpediteFlag	EV01	char	Cache element
cCacheActionCode	EV02	char
cCacheErrorCode	EV03	char
nNumberOfKeys	INT01	integer
cSequentialFetch	EV04	char
cSuppressErrorMessage	SUPPS	char
szErrorMessageID	DTAI	char
idCacheCursorPtr	GENLNG	ID
cComparisonFlag	EV01	char
mnOrderQuantity	UORG	MATH_NUMERIC
jdDateSave	PDDJ	JDEDATE
cDeferFlag	EV01	char
nIndexNumber	INT02	integer
jdDateRecommendedStart	RSTJ	JDEDATE
szSupplyBranch	MMCU	char
jdRecommendedDeliveryDate	REDJ	JDEDATE
jdDateRequestedSave	DRQJ	JDEDATE
jdOriginalEffectiveDateSaved	OEDJ	JDEDATE
cProjectPlanning	EV01	char
mnProductionNumberShort	PNS	MATH_NUMERIC

Detail Routine:
Error Code:
Business Function Documentation: b3401320.rtf
Back To Top

Ref9
B3401340 MRPReturnWorkDays (MRP, Return Work Days)

Purpose: This function will use a secondary date cache to determine work days between two dates - the Input DATE01 and the Type 2 date in the D2 cache. This function is used only in the MRP/MPS planning programs (P3482 and P3483). The calling application is responsible for loading all appropriate key values to the data structure and identifying the number of keys to use in retrieval/update processes. This function creates a unique cache for each MRP/MPS planning process. The function appends the input Job Number string to the two character ID 'D2' to build the cache name used for the calling application.
Parameter:

Data Structure: D3401340 MRP, Return Work Days

Parameter Name	Data Item	Data Type	Others
szJobNumber	JOB	char
szBranch *	MCU	char	Cache key
nType *	INT01	integer	Cache Key. Type '1' - Normal Work Date '2' - First Work Day '3' - Smallest Work Day in Cache
jdDate *	DRQJ	JDEDATE	Cache Key
jdStartDate	DATE01	JDEDATE
nWorkDays	INT02	integer
cActionCode	EV01	char
cErrorCode	EV01	char
nNumberOfKeys	INT03	integer
cSuppressErrorMessage	SUPPS	char
szErrorMessageID	DTAI	char

Detail Routine:
Error:
Related Tables
F0007 Workday Calendar
Business Function Documentation: b3401340.rtf
Back To Top

Ref10
B3401530 CacheProcessMRPBillofMaterial (Cache, Process MRP Bill of Material)

Purpose:
Parameter:

Data Structure: D3401530 - Data Structure for Cache,Process BOM with out location

Parameter Name	Data Item	Data Type
szJobNumber	JOB	char
szTypeBill	TBM	char
mnItemNumberShortKit	KIT	MATH_NUMERIC
szCostCenterAlt	MMCU	char
mnUnitsBatchQuantity	BQTY	MATH_NUMERIC
szUnitOfMeasureAsInput	UOM	char
mnIdentifierShortItem	ITM	MATH_NUMERIC
szBranchComponent	CMCU	char
mnQtyRequiredStandard	QNTY	MATH_NUMERIC
szUnitOfMeasure	UM	char
mnQuantityPrimary	MATH01	MATH_NUMERIC
jdEffectiveFromDate	EFFF	JDEDATE
jdEffectiveThruDate	EFFT	JDEDATE
cFixedOrVariableQty	FORQ	char
mnFeaturePlannedPercent	FTRP	MATH_NUMERIC
mnStepScrapPercent	STPP	MATH_NUMERIC
mnPercentOfScrap	SCRP	MATH_NUMERIC
mnLeadtimeOffsetDays	LOVD	MATH_NUMERIC
mnSequenceNoOperations	OPSQ	MATH_NUMERIC
mnSubstituteItemSequenceNu	SBNT	MATH_NUMERIC
cCoproductsByproducts	COBY	char
cStockingType	STKT	char
cCacheActionCode	EV01	char
cCacheErrorCode	EV02	char
nNumberOfKeys	INT01	integer
cSuppressErrorMessage	SUPPS	char
szErrorMessageID	DTAI	char
idCacheCursorPtr	GENLNG	ID
cSequentialFetch	EV03	char
szComponentPrimaryUM	UOM1	char
szComponentTFLA	TFLA	char
mnComponentStandardPotency	STDP	MATH_NUMERIC
cComponentPotencyControl	OT1Y	char
cCoponentRoundToWhole	SNS	char
mnComponentNumber	CPNB	MATH_NUMERIC

Detail Routine:
Error:
Back To Top

Ref11
B3401540 CacheProcessMRPBatchBills (Cache, Process MRP Batch Bills)

Pupose:
Parameter:

Data Structure: D3401540 - Cache, Process MRP Batch Bills Data Structure

Parameter Name	Data Item	Data Type
szTypeBill	TBM	char
mnItemNumberShortKit	KIT	MATH_NUMERIC
szCostCenterAlt	MMCU	char
mnUnitsBatchQuantity	BQTY	MATH_NUMERIC
cCacheActionCode	EV01	char
cCacheErrorCode	EV02	char
nNumberOfKeys	INT01	integer
cSuppressErrorMessage	SUPPS	char
szErrorMessageID	DTAI	char
idCacheCursorPtr	GENLNG	ID
cSequentialFetch	EV03	char
szJobNumber	JOB	char
cCoproductsByproducts	COBY	char
nTotalCacheRecords	INT01	integer

Detail Routine:
Error:
Back To Top

Ref12
B3401720 CacheProcessMRPLots (Cache, Process MRP Lots)

Purpose:
Parameter:

Data Structure: D3401720 - Cache, Process MRP Lots

Parameter Name	Data Item	Data Type
szJobNumber	JOB	char
mnShortItemNumber	ITM	MATH_NUMERIC
szBranch	MCU	char
szLotNumber	LOTN	char
szLocation	LOCN	char
jdLotEffectivityDate	DLEJ	JDEDATE
jdLotExpirationDate	MMEJ	JDEDATE
mnLotOnHandQty	PQOH	MATH_NUMERIC
mnRemainingLotQty	UORG	MATH_NUMERIC
idCacheCursorPtr	GENLNG	ID
cSequentialFetch	EV02	char
cCacheActionCode	EV02	char
cCacheErrorCode	EV01	char
nNumberOfKeys	INT01	integer
cSuppressErrorMessage	SUPPS	char
szErrorMessageID	DTAI	char
nIndexNumber	INT02	integer
cEndOfDayProcessingFlag	EV01	char

Detail Routine:
Error:
Back To Top

Ref13
B3400490 MRPGetMRPParameters (MRP, Get MRP Parameters)

Purpose: The purpose of this function is to check the existence of the MRP parameters and return the values to the program. This is executed once in the beginning of the MRP program to get the common values to be used for all the items in the run.
Parameter:

Data Structure:

Structure Member Name	Type	Alias	Dir	Representation in Event Rule	Values From
szReportingCode[3]	JCHAR	RT	I	PO szUserDefinedCodes	Tab - Parameters 3. UDC Type This value is to be used to get Quantity t'ype UDC Value based on this input value. That is, the quantity type will be UDC 34/szReportingCodes. If you set this value 'QT' for example, it gets value from UDC 34/QT - Quantity Type to get Key Value (F0005.KY)
cGenerationType	JCHAR	EV01	I	PO cGenerationType	Tab - Parameters 2. Generation Type 1 =single level MPS/DRP 3 = multi-level MPS 4 = MRP with or without MPS 5 = MRP with frozen MPS
cBegAvailUnadjusted	JCHAR	EV01		VA rpt_cQ05_DSBAU	Return 1 when Key Value is '05' does exist for UDC 34/QT 05 \| +BAU \| + Beginning Avail (Unadjusted)
cBeginningAvailable	JCHAR	EV02		VA rpt_cQ10_DSBA	Return 1 when Key Value is '10' does exist for UDC 34/QT 10 \| +BA \| + Beginning Avail.......
cReceiptRouting	JCHAR	EV03		VA rpt_cQ13_DSIR	Return 1 when Key Value is '13' does exist for UDC 34/QT 13 \| +IR \| + In Receipt Routing .....
cPurchOrderUnadjusted	JCHAR	EV04		VA rpt_cQ15_DSPOU	Return 1 when Key Value is '15' does exist for UDC 34/QT 15 \| +POU \| + Purchase Orders (Unadjusted)
cPurchOrderAdjusted	JCHAR	EV05		VA rpt_cQ20_DSPO	Return 1 when Key Value is '20' does exist for UDC 34/QT 20 \| +PO \| + Purchase Orders .....
cWorkOrderUnadjusted	JCHAR	EV06		VA rpt_cQ25_DSWOU	Return 1 when Key Value is '25' does exist for UDC 34/QT 25 \| +WOU \| + Work Orders (Unadjusted)
cWorkOrderAdjusted	JCHAR	EV07		VA rpt_cQ30_DSWO	Return 1 when Key Value is '30' does exist for UDC 34/QT 30 \| +WO \| + Work Orders .........
cRateScheduleUnadjusted	JCHAR	EV08		VA rpt_cQ35_DSRSU	Return 1 when Key Value is '35' does exist for UDC 34/QT 35 \| +RSU \| + Rate Schedule (Unadjusted)
cRateScheduleAdjusted	JCHAR	EV09		VA rpt_cQ40_DSRS	Return 1 when Key Value is '40' does exist for UDC 34/QT 40 \| +RS \| + Rate Schedule..............
cLotExpiration	JCHAR	EV10		VA rpt_cQ42_DSLEX	Return 1 when Key Value is '42' does exist for UDC 34/QT 42 \| -LEXP \| - Lot Expired...........
cForecastUnadjusted	JCHAR	EV01		VA rpt_cQ45_DSFCSU	Return 1 when Key Value is '45' does exist for UDC 34/QT 45 \| -FSCU \| - MPS/Forecast (Unadjusted)
cForecastAdjusted	JCHAR	EV02		VA rpt_cQ50_DSFCST	Return 1 when Key Value is '50' does exist for UDC 34/QT 50 \| -FSST \| - MPS/Forecast............
cSalesOrderUnadjusted	JCHAR	EV03		VA rpt_cQ55_DSSOU	Return 1 when Key Value is '55' does exist for UDC 34/QT 55 \| -SOU \| - Sales Orders (Unadjusted)
cSalesOrderAdjusted	JCHAR	EV04		VA rpt_cQ60_DSSO	Return 1 when Key Value is '60' does exist for UDC 34/QT 60 \| -SO \| - Sales Orders...............
cInterPlantDemand	JCHAR	EV05		VA rpt_cQ65_DSID	Return 1 when Key Value is '65' does exist for UDC 34/QT 65 \| -ID \| - Inter-Plant Demand........
cPartsListUnadjusted	JCHAR	EV06		VA rpt_cQ70_DSFWOU	Return 1 when Key Value is '70' does exist for UDC 34/QT 70 \| -FWOU \| - Firm Work Orders(Unadjusted)
cFirmPartsList	JCHAR	EV07		VA rpt_cQ75_DSFWO	Return 1 when Key Value is '75' does exist for UDC 34/QT 75 \| -FWO \| - Firm Work Orders........
cPlanPartsList	JCHAR	EV08		VA rpt_cQ80_DSPWO	Return 1 when Key Value is '80' does exist for UDC 34/QT 80 \| -PWO \| - Plan Work Orders.........
cEndingAvailUnadjusted	JCHAR	EV09		VA rpt_cQ85_DSEAU	Return 1 when Key Value is '85' does exist for UDC 34/QT 85 \| =EAU \| = Ending Avail (Unadjusted)
cEndingAvailable	JCHAR	EV10		VA rpt_cQ90_DSEA	Return 1 when Key Value is '90' does exist for UDC 34/QT 90 \| =EA \| = Ending Avail.........
cPlannedOrders	JCHAR	EV01		VA rpt_cQ95_DSPLO	Return 1 when Key Value is '95' does exist for UDC 34/QT 95 \| +PLO \| + Planned Orders..........
cATPUnadjusted	JCHAR	EV02		VA rpt_cQ96_DSATPU	Return 1 when Key Value is '96' does exist for UDC 34/QT 96 \| ATPU \| Available to Promise (Unadj)
cATPAdjusted	JCHAR	EV03		VA rpt_cQ97_DSATP	Return 1 when Key Value is '97' does exist for UDC 34/QT 97 \| ATP \| Available to Promise ...
cCATPUnadjusted	JCHAR	EV04		VA rpt_cQ98_DSCATPU	Return 1 when Key Value is '98' does exist for UDC 34/QT 98 \| CATPU \| Cumulative Avail to (Unadj)
cCATPAdjusted	JCHAR	EV05		VA rpt_cQ99_DSCATP	Return 1 when Key Value is '99' does exist for UDC 34/QT 99 \| CATP \| Cumulative Avail to Promise
cActionMessage	JCHAR	EV06		VA rpt_cMsgType_A	Return 1 when UDC 34/MT - Message Type contains Key 'A' A\|Warning Messages\|User Controlled
cFrozenOrderMessage	JCHAR	EV07		VA rpt_cMsgType_F	Return 1 when UDC 34/MT - Message Type contains Key 'F' F\|Frozen Order\|User Controlled
cIncreaseOrderMessage	JCHAR	EV08		VA rpt_cMsgType_G	Return 1 when UDC 34/MT - Message Type contains Key 'G' G\|Increase Order Quantity to\|User Controlled * G (= Greater Than)
cDecreaseOrderMessage	JCHAR	EV09		VA rpt_cMsgType_L	Return 1 when UDC 34/MT - Message Type contains Key 'L' L\|Decrease Order Quantity to\|User Controlled * L (= Less Than)
cPastDueOrderMessage	JCHAR	EV10		VA rpt_cMsgType_T	Return 1 when UDC 34/MT - Message Type contains Key 'T' T\|Past Due Order
cWOFileExists	JCHAR	EV01		VA rpt_cMfgWOFlag	(File existence Flag) 5. Return '1' when cWorkOrderUnadjusted = '1' OR cWorkOrderAdjusted = '1' OR cPartsListUnadjusted = '1' OR cFirmPartsList = '1' AND fails to open table F4801 So at this level the table F4801 (Work Order Master File) is requested to pen to check existence of table. Note that return value '1' means open table F4801 has failed
cPartsListExists	JCHAR	EV02		VA rpt_cMfgPartsListFlag	(File existence Flag) 4. Return '1' when cGenerationType IN ('3', '4', '5') AND (cWorkOrderUnadjusted = '1' OR 'cWorkOrderAdjusted = '1') Fails to open F3412 Fails to open F3111 Open tables F3412 (MPS/MRP/DRP Lower Level Requirements File) and F3111 (Work Order Parts List) are called to check existence of tables
cMultiLevelFlag	JCHAR	EV03		VA rpt_cMultiLevelFlag	3. Return 'Y' when Input cGenerationType is 3 = multi-level MPS OR 4 = MRP with or without MPS OR 5 = MRP with frozen MPS
cSuppressErrorMessage	JCHAR	EV01	I	1	Set '1' to suppress error during this routine. By setting this, though internal routine hits error jdedebug may contain szErrorMessage but external routine is to be processed
szErrorMessageID[11]	JCHAR	DTAI		VA evt_szErrorMessageID_DTAI
cErrorCode	JCHAR	ERRC		N/A	N/A
cShippedAdjusted	JCHAR	EV02		VA rpt_cQ52_DSSHIP	Return 1 when Key Value is '52' does exist for UDC 34/QT 52 \| -SHIP \| - Shipped Quantity 7. Override returned value into ' ' when, cForecastConsumptionFlag '1' OR ForecastConsumptionFlag = '2' AND cShippedAdjusted = '1' AND failed to open table F3462 Note that table F3462 (Forecast Shipment Summary) gets opened to check existence of table
cForecastConsumptionFlag	JCHAR	EV04	I/O	VA rpt_cForecastConsumptionFlag	6. Return a space ' ' when, cForecastConsumptionFlag = '1' OR cForecastConsumptionFlag = '2' AND failed to open table F3405 Note that the table F3405 (Forecast Consumption Periods) is to be opened to check the existence of table
cF3404TableExistenceCode	JCHAR	EV01		VA rpt_cF3404Exists	8. Return 1 or 2 as below, 1 - when Open Table F3404 is SUCCESS 2 - when Open Table F3404 is FAILED F3404 (Co-Products Planning/Costing Table) is to be opened to check existence of table
cConsolidationMethod	JCHAR	EV02	I/O	PO cEverestEventPoint13	If input value for this parameter is '2' validate it again. 9. Override this value to '1' when, Input cConsolidationMethod = '2' AND Open Table F3403 Failed So F3403 (Branch Relationships Master File) has to be opened to check existence of table
cFirmInterplantDemand	JCHAR	EV01		VA rpt_cQ67_DSFID	Return 1 when Key Value is '67' does exist for UDC 34/QT 67 \| -FID \| - Firm Inter-plant Demand
cTotalIndependentDemandUnadj	JCHAR	EV01		VA rpt_cQ68_DSTIU	Return 1 when Key Value is '68' does exist for UDC 34/QT 68 \| -TIU \| - Total Indep Demand (Unadj)
cTotalIndependentDemandAdj	JCHAR	EV01		VA rpt_cQ69_DSTI	Return 1 when Key Value is '69' does exist for UDC 34/QT 69 \| -TI \| - Total Independent Demand
cFirmInterplantDemandUnadj	JCHAR	EV01		VA rpt_cQ66_DSFIDU	Return 1 when Key Value is '66' does exist for UDC 34/QT 66 \| -FIDU \| - Firm Inter-plant(Unadj)
szPlanningControlUDCType[3]	JCHAR	RT	I	PO szPlanningControlUDCType	Tab - Performance 12. Planning Control UDC Type UDC 34/PC - Planning Control UDC Note: as this routine reads you can define your own User Define Codes to control whether to add tables F4101, F4102 and F4801 into Database Caching or not. Valid Special Handling Code value for Key 'DC - Disable Cache Flag' 0 - Do not add into database caching 1 - Add to database caching

Detail Routine:
Error

Related Tables

F0005 User Defined Code Values
F3111 Work Order Parts List
F3403 Branch Relationships Master File
F3404 Co-Products Planning/Costing Table
F3405 Forecast Consumption Periods
F3412 MPS/MRP/DRP Lower Level Requirements File
F3462 Forecast Shipment Summary
F4101 Item Master
F4102 Item Branch File
F4801 Work Order Master File

Business Function Documentation: b3400490.rtf
Back To Top

Ref14
N3401830 MRPUKIDGeneratorDeletionByBranch (MRP, UKID Generator & Deletion By Branch)

Purpose:
Parameter:

Data Structure: D3401830 - MRP, UKID Generator & Deletion By Branch

Parameter Name	Data Item	Data Type	I/O
cNetChangeFlag	EV01	char	I
cClearFilesFlag	EV05	char	IO
szDeleteBranchPlant	MCU	char	IO
mnF3411BlockSize	INT01	integer	IO
mnF3412BlockSize	INT01	integer	IO
cSubsystemMode	EV01	char	I
mnF3411UKID	MATH01	MATH_NUMERIC	O
mnF3412UKID	MATH01	MATH_NUMERIC	O

Detail Routine:
Error:
Back To Top

Ref15
N3401620 MRPParallelRetrieveHighestLow (MRP, Parallel Retrieve Highest Low Level Code

Purpose:
Parameter:

Data Structure: D3401620 - Retrieve Highest Low Level Code

Parameter Name	Data Item	Data Type	Req	I/O	Others
mnLowLevelCode	LLX	MATH_NUMERIC		O

Detail Routine:
Error:
Back To Top

Ref16
B3401580 MRPParallelDelSubsystmTriggerRec (MRP, Parallel Delete SubsystmTrigger Records)

Purpose:
Parameter:

Data Structure: D3401580B - MRP, Parallel Delete Subsystem Trigger Records

Parameter Name	Data Item	Data Type
cActionCode	EV01	char
szProgramId	PID	char
szVersion	VERS	char

Detail Routine:
Error:
Related Tables
F4102 Item Branch File
F986113 Subsystem Job Master
Back To Top

ref17
B3401580 MRPParallelChkSubsytmTriggerRec (MRP, Parallel Check SubsystmTrigger Records)

Purpose:
Parameter:

Data Structure: D3401580C MRP, Parallel Check Subsystem Trigger Records

Parameter Name	Data Item	Data Type
mnNoOfSubsystems	MATH06	MATH_NUMERIC
szProgramId	PID	char
szVersion	VERS	char

Detail Routine:
Error:
Related Tables
F4102 Item Branch File
F986113 Subsystem Job Master
Back To Top

ref18
B3401580 MRPParallelAddSubsystmTriggerRec (MRP, Parallel Add Subsystem Trigger Records)

Purpose:
Parameter:

Data Structure: D3401580A MRP, Parallel Add Subsystem Trigger Records

Parameter Name	Data Item	Data Type
mnLowLevelCode	LLX	MATH_NUMERIC
cLastProcessPlanned	EV01	char
mnHighestLowLevelCode	MATH01	MATH_NUMERIC
szProgramId	PID	char
szVersion	VERS	char
cEndSubsystemProcess	EV01	char
szCurrentBranchPlant	MCU	char
jdFromDate	DATE01	JDEDATE
jdThruDate	DATE02	JDEDATE
cForecastFlag	EV02	char
cNetChangeMode	EV03	char
cPreProcessing	EV04	char
cClearFilesFlag	EV05	char
cMultiLevelFlag	EV06	char
cProcessFlag	EV07	char
cGenerationType	EV08	char

Detail Routine:
Error:

Report Interconnection Data Structure for R3483
    MATH_NUMERIC         mnItemNumberShort
    JCHAR                            szBranchPlant[13]
    MATH_NUMERIC         mnInitialUKIDF3411
    MATH_NUMERIC         mnInitialUKIDF3412
    MATH_NUMERIC         mnHighestLowLevelCd

ref19
B3401290 - CacheProcessMRPItemQuantities (Cache, Process MRP Item Quantities)

Purpose: This function performs Get, Add, Update, Delete, Delete All, Get Next, Add/Update, and Terminate functions on the MRP Item Quantity Cache used in the MRP/MPS planning programs, R3482 and R3483. This function creates a unique cache for each MRP/MPS planning process. The function appends the input Job Number string to the two character ID 'IQ' to build the cache name used for the calling application.
Parameter

Data Structure: D3401290 - Cache, Process MRP Item Quantities

Parameter Name	Data Item	Data Type
szJobNumber	JOB	char
szBranch	MCU	char
szQuantityType	TP	char
jdDate	DRQJ	JDEDATE
mnQuantity	NQ01	MATH_NUMERIC
cCacheActionCode	EV01	char
cCacheErrorCode	EV02	char
nNumberOfKeys	INT01	integer
cSuppressErrorMessage	SUPPS	char
szErrorMessageID	DTAI	char
idCacheCursorPtr	GENLNG	ID
cSequentialFetch	EV03	char

Detail Routine
Errors
Business Function Documentation: b3401290.rtf

Ref20
B3401270 CacheProcessMRPBucketlessDates (Cache, Process MRP Bucketless Dates)

Purpose: This function will perform Get, Add, Update, Delete, Delete All, Get Next, Add/Update, and Terminate functions on the MRP Bucketless Date Cache used in the MRP/MPS planning programs (P3482 and P3483). The calling functions are responsible for loading all appropriate key values to the data structure and identifying the number of keys to use in retrieval/update processes. This function creates a unique cache for each Parts List process. The function appends the input Job Number string to the function name 'B3100650-' to build the cache name used for the calling application.
Parameter:

Data Structure: D3401270 Cache, Process MRP Buckless Dates

Parameter Name	Data Item	Data Type
szJobNumber	JOB	char
szBranch	MCU	char
jdDate	DRQJ	JDEDATE
cBucketFlag	EV01	char
cWeekMonthEndFlag	EV02	char
cForecastConsumptionFlag	EV03	char
mnWorkDaysInWeek	MTF1	MATH_NUMERIC
mnWorkDaysInMonth	MTF2	MATH_NUMERIC
mnFeaturePercent	FTRP	MATH_NUMERIC
cComparisonFlag	EV04	char
cCacheActionCode	EV05	char
cCacheErrorCode	EV06	char
cSuppressErrorMessage	SUPPS	char
szErrorMessageID	DTAI	char
nNumberOfKeys	INT01	integer
idCacheCursorPtr	GENLNG	ID
cSequentialFetch	EV07	char

Detail Routine:
Error:
Business Function Documentation: b3401270.rtf
Back To Top

Ref22
B3500090 MRPMultiPlantSequenceBranchInUI (MRP, Multi-Plant Sequence Branches in UI)

Purpose: This function will read the available plants to adjust and sequence the order of plants to be processed in the User Index F35UI001. This function should not be modified for other programs. It should be used only for R3483.
Parameter:

Data Structure: D3500090 - MRP, Multi-Plant Sequence Branches in UI

Parameter Name	Data Item	Data Type
mnJobNumber	JOBS	MATH_NUMERIC
szComputerID	CTID	char
mnIdentifierShortItem	ITM	MATH_NUMERIC
szErrorMessageID	DTAI	char
cSuppressErrors	EV01	char
cErrorCode	ERRC	char
nNumberOfBranches	INT01	integer
szJobNumberAsString	JOB	char

Detail Routine:
Error:
Related Functions
B3500060 Cache, Process Multi Plants

Related Tables
F3403 Branch Relationships Master File
F35UI001 MPS/MRP Planning - Multiple Plant User Index

Business Function Documentation: b3500090.rtf
Back To Top

Ref23
N3500110 - MRPMultiplePlantLoadAndPlan (MRP, Multiple Plant Load and Plan)

Purpose: This NER module is designed to read the F35UI001 user index and retrieve the branches to be planned for a particular item. The order of the records read from F35UI001 is the Branch Sequence(MABRSQ). This assures that MRP is planning the Demand branches first, then the Supply branches. The user index must be sequenced in the correct order.
Input values are determined as below,

Processing Option parameters
Text Variable: To make transaction more descriptive
ProcessMessageBeginDoc: Job Number and Computer ID
MRPGetMRPParameters: Parameter to control the process along with Processing Option parameters
CacheProcessMultiPlants
MRPWriteOnHandLotQtyToCacheA
Date from F4101 and F4102

Parameters:

Data Structure: D3500110 - MRP, Multiple Plant Load and Plan

Structure Member Name	Data Type	I/O	Alias	Otheres
nPO_WorkOrderLeadTime	int		INT01	RV INT01-PO WOLeadtime(gv) = PO mnPurchaseLeadtime). *Use expression assignments to convert from math numeric to integer
nPO_PurchOrderLeadTime	int		INT01	RV INT01-PO POLeadtime(gv) =PO mnWorkOrderLeadtime) *Use expression assignments to convert from math numeric to integer
szPO_ConsolidationBranch[13]	JCHAR		MCU	PO szCostCenterAlt
szPO_DefaultDateBranch[13]	JCHAR		MCU	PO szDefaultDateBranch
cPO_ConsolidationMethod	JCHAR		EV01	PO cEverestEventPoint13
cPO_ProcessPlanning	JCHAR		EV01	PO cProcessPlanning
cPO_NetChangeFlag	JCHAR		EV01	PO cNetChangeFlag
cPO_RunRegularMRP	JCHAR		EV01	N/A
cPO_GenerationType	JCHAR		EV01	PO cGenerationType
cPO_IncludeTransitFlag	JCHAR		EV01	PO cEverestEventPoint05
cPO_IncludeInspectionFlag	JCHAR		EV01	PO cEverestEventPoint06
cPO_IncludeOther1Flag	JCHAR		EV01	PO cEverestEventPoint07
cPO_IncludeOther2Flag	JCHAR		EV01	PO cEverestEventPoint08
cPO_MakeMfgItemsInOrigin	JCHAR		EV01	PO cEverestEventPoint16
cPO_LotExpirationFlag	JCHAR		EV01	PO cEverestEventPoint18
cPO_ProcessEachBranch	JCHAR		EV01	N/A
cPO_PhantomDataFlag	JCHAR		EV01	PO cEverestEventPoint03
cPO_IncludeSafetyStocks	JCHAR		EV01	PO cEverestEventPoint04
cPO_PastDuePeriods	int		INT01	PO nPastDuePeriods
szPO_WorkOrderStatus[3]	JCHAR		SRST	PO szStatusCodeWo
szPO_PurchOrderType[3]	JCHAR		DCTO	PO szOrderType
szPO_WorkOrderType[3]	JCHAR		DCTO	PO szRelatedOrderType
szPO_TransferOrderType[3]	JCHAR		DCTO	PO szDocumentType
mnPO_DeferDamperDays	MATH_NUMERIC		MATH01	PO mnDeferDamperDays
mnPO_ExpediteDamperDays	MATH_NUMERIC		MATH01	PO mnExpediteDamperDays
szPO_QuantityTypeForTS[3]	JCHAR		QT	PO szUserDefinedCodes
mnPreviousItemNumber	MATH_NUMERIC		ITM	RV ITM-PreviousItem-GV. = Current Item to plan in Do Section event
szPrimaryUnitOfMeasure[3]	JCHAR		UOM1	RV UOM-Primary UOM-GV = F4101.UOM via F4101.FetchSingle). Get Item Master Data for the first occurrence of the current item. F4101.CLEV (RV CLEV-Inventory Cost Level-GV), F4101.TFLA (RV TFLA-StdUOMConv-GV) and F4101.SNS (RV SNS-RoundFlag-GV) are returned at this level
szStdUOMConversion[3]	JCHAR		TFLA	RV TFLA-StdUOMConv-GV (=F4101.TFLA)
cInvCostLevel	JCHAR		CLEV	RV CLEV-Inventory Cost (=F4101.CLEV)
cRoundToWholeFlag	JCHAR		SNS	RV SNS-RoundFlag-GV (=F4101.SNS)
szForecastType_1[3]	JCHAR		TYPF	VA rpt_szForecastType1_TYPF (=1st two digits from PO szForecastTypes)
szForecastType_2[3]	JCHAR		TYPF	VA rpt_szForecastType2_TYPF (= following two digits from PO szForecastTypes)
szForecastType_3[3]	JCHAR		TYPF	VA rpt_szForecastType3_TYPF (= following two digits from PO szForecastTypes)
szForecastType_4[3]	JCHAR		TYPF	VA rpt_szForecastType4_TYPF (= following two digits from PO szForecastTypes)
szForecastType_5[3]	JCHAR		TYPF	VA rpt_szForecastType5_TYPF (= following two digits from PO szForecastTypes)
jdRegenerationDateRGNJ	JDEDATE		DATE01	RV DATE-$$RGNJ Date-GV (= = date_today()). If PO jdGenStartDate is not specified then PO jdGenStartDate = RV DATE-$$RGNJ Date-GV
nFirstATPPeriod	int		INT01	RV INT-FirstATP FATP-GV = To Calculate first ATP element index RV INT-FirstATP FATP-GV = [PO nPastDuePeriods]+1 If PO nPastDuePeriods is equal to <Zero> RV INT-FirstATP FATP-GV = [RV INT-FirstATP FATP-GV]+1 End If
cUseForecastConsumptionLogic	JCHAR		EV01	VA rpt_cForecastConsumptionFlag = MRPGetMRPParameters.cForecastConsumptionFlag 6. Return a space ' ' when, cForecastConsumptionFlag = '1' OR cForecastConsumptionFlag = '2' AND failed to open table F3405 Note that the table F3405 (Forecast Consumption Periods) is to be opened to check the existence of table
szJobNumber[9]	JCHAR		JOB	RV JOB-Job Number String-GV = String format Job Number which was retrieved/set in EVENT Initialize Report (future) of REPORT LEVEL EVENTS Cache name is business function ID + String format Job Number so this value is to be used in setting unique Cache Name across R3483. So there is only 1 Job Number
mnJobNumber	MATH_NUMERIC		JOBS	RV JOBS-Job Number-GV = ProcessMessageBeginDoc.mnJobnumberA in EVENT Initialize Report (future) of REPORT LEVEL EVENTS
szComputerID[16]	JCHAR		CTID	RV CTID-ComputerID-GV = ProcessMessageBeginDoc.szComputerID in EVENT Initialize Report (future) of REPORT LEVEL EVENTS
mnF3411_UniqueID	MATH_NUMERIC	I/O	UKID	RV UKID-F3411 UKID-GV = MRPUKIDGeneratorDeletionByBranch.mnF3411UKID
mnF3412_UniqueID	MATH_NUMERIC	I/O	UKID	RV UKID-F3412 UKID-GV = MRPUKIDGeneratorDeletionByBranch.mnF3412UKID
szCO_LeadtimeZero[31]	JCHAR		DSC1	VA rpt_szLeadTimeIsZero_DSC1 = TV Lead Time is Zero * Note: TV = Text Variable (so if needed, value can be overridden through Vocabulary Override)
szCO_IncreasePartsList[31]	JCHAR		DSC1	VA rpt_szIncreasePartsList_DSC1 = TV Increase Parts List
szCO_DecreaseSOQty[31]	JCHAR		DSC1	VA rpt_szDecreaseSOQty_DSC1 = TV Decrease SO Quantity
szCO_CancelSO[31]	JCHAR		DSC1	VA rpt_szCancelSO_DSC1 = TV Cancel SO
szCO_DeferSO[31]	JCHAR		DSC1	VA rpt_szDeferSO_DSC1 = TV Defer SO
szCO_ExpediteSO[31]	JCHAR		DSC1	VA rpt_szExpediteSO_DSC1 = TV Expedite SO
szCO_IncreaseSOQty[31]	JCHAR		DSC1	VA rpt_szIncreaseSOQty_DSC1 = TV Increase SO Quantity
szCO_LotQuantityExpired[31]	JCHAR		DSC1	VA rpt_szLotQtyExpired_DSC1 = TV Lot Quantity expired
szCO_ItemFlaggedAsObsolete[31]	JCHAR		DSC1	VA rpt_szItemFlaggedObsolete_DSC1 = TV Item Flagged as obsolete
szCO_NoBOMCoByProduct[31]	JCHAR		DSC1	VA rpt_szNoBOMCobyItem_DSC1 = TV No BOM, Co/By Product Item
szCO_PlanningPercentNot100[31]	JCHAR		DSC1	VA rpt_szPlanningNot100_DSC1 = TV Planning % is not 100 %
szCO_CancelFPO[31]	JCHAR		DSC1	VA rpt_szCancelFPO_DSC1 = TV Cancel FPO
szCO_DeferWithinDamper[31]	JCHAR		DSC1	VA rpt_szDeferWithinDamper_DSC1 = TV Defer is within Damper Days
szCO_ExpediteWithinDamper[31]	JCHAR		DSC1	VA rpt_szExpWithinDamper_DSC1 = TV Expedite is within Damper Days
szCO_DeferFPO[31]	JCHAR		DSC1	VA rpt_szDeferFPO_DSC1 = TV Defer FPO
szCO_DecreaseFPO[31]	JCHAR		DSC1	VA rpt_szDecreaseFPO_DSC1 = TV Decrease FPO
szCO_ExpediteFPO[31]	JCHAR		DSC1	VA rpt_szExpediteFPO_DSC1 = TV Expedite FPO
szCO_IncreaseFPO[31]	JCHAR		DSC1	VA rpt_szIncreaseFPO_DSC1 = TV Increase FPO
szCO_CancelPartsList[31]	JCHAR		DSC1	VA rpt_szCancelPartsList_DSC1 = TV Cancel Parts List
szCO_RequiredStartBefore[31]	JCHAR		DSC1	VA rpt_szReqStartBeforeBegin_DSC1 = TV Required Start before Beginning Date
szCO_ExpeditePartsList[31]	JCHAR		DSC1	VA rpt_szExpeditePartsList_DSC1 = TV Expedite Parts List
szCO_DecreasePartsList[31]	JCHAR		DSC1	VA rpt_szDecreasePartsList_DSC1 = TV Decrease Parts List
szCO_RecordLockInF4102[31]	JCHAR		DSC1	VA rpt_szRecordLockInF4102_DSC1 = TV Record Lock in F4102
szCO_ManualAdjustment[31]	JCHAR		DSC1	N/A
szCO_ShopCalendarNotSetup[31]	JCHAR		DSC1	VA rpt_szShopCalendrNotSetup_DSC1 = TV Shop Calendar not set up
szCO_DeferPartsList[31]	JCHAR		DSC1	VA rpt_szDeferPartsList_DSC1 = TV Defer Parts List
szCO_PlanOrderExceedsFOQ[31]	JCHAR		DSC1	VA rpt_szPlanOrderExceedsFOQ_DSC1 = TV Planned Order exceeds FOQ
szCO_BOMDoesNotExist[31]	JCHAR		DSC1	VA rpt_szBOMDoesNotExist_DSC1= TV BOM does not exist for item
szCO_FrozenOrder[31]	JCHAR		DSC1	VA rpt_szFrozenOrder_DSC1 = TV Frozen Order
szCO_PlanOrderExceedsMOQ[31]	JCHAR		DSC1	VA rpt_szPlanOrderExceedsMOQ_DSC1 = TV Planned Order exceeds MOQ
szCO_PlanningBOMDoesNotExist[31]	JCHAR		DSC1	VA rpt_szPlanBOMDoesNotExist_DSC1 = TV Planning BOM does not exist for item
szCO_WOMissingPartsList[31]	JCHAR		DSC1	VA rpt_szWOMissingPartsList_DSC1 = TV W.O. is missing Parts List
cTS_Q20DSPO	JCHAR		EV01	VA rpt_cQ20_DSPO = MRPGetMRPParameters.cPurchOrderAdjusted
cTS_Q15DSPOU	JCHAR		EV01	VA rpt_cQ15_DSPOU = MRPGetMRPParameters.cPurchOrderUnadjusted
cTS_Q10DSBA	JCHAR		EV01	VA rpt_cQ10_DSBA = MRPGetMRPParameters.cBeginningAvailable
cTS_Q13DSIR	JCHAR		EV01	VA rpt_cQ13_DSIR = MRPGetMRPParameters.cReceiptRouting
cTS_Q05DSBAU	JCHAR		EV01	VA rpt_cQ05_DSBAU = MRPGetMRPParameters.cBegAvailUnadjusted
cTS_Q40DSRS	JCHAR		EV01	VA rpt_cQ40_DSRS = MRPGetMRPParameters.cRateScheduleAdjusted
cTS_Q42DSLEX	JCHAR		EV01	VA rpt_cQ42_DSLEX = MRPGetMRPParameters.cLotExpiration
cTS_Q35DSRSU	JCHAR		EV01	VA rpt_cQ35_DSRSU = MRPGetMRPParameters.cRateScheduleUnadjusted
cTS_Q30DSWO	JCHAR		EV01	VA rpt_cQ30_DSWO = MRPGetMRPParameters.cWorkOrderAdjusted
cTS_Q25DSWOU	JCHAR		EV01	VA rpt_cQ25_DSWOU = MRPGetMRPParameters.cWorkOrderUnadjusted
cTS_Q50DSFCST	JCHAR		EV01	VA rpt_cQ50_DSFCST = MRPGetMRPParameters.cForecastAdjusted
cTS_Q65DSID	JCHAR		EV01	VA rpt_cQ65_DSID = MRPGetMRPParameters.cInterPlantDemand
cTS_Q60DSSO	JCHAR		EV01	VA rpt_cQ60_DSSO = MRPGetMRPParameters.cSalesOrderAdjusted
cTS_Q55DSSOU	JCHAR		EV01	VA rpt_cQ55_DSSOU = MRPGetMRPParameters.cSalesOrderUnadjusted
cTS_Q52DSSHIP	JCHAR		EV01	VA rpt_cQ52_DSSHIP = MRPGetMRPParameters.cShippedAdjusted
cTS_Q45DSFCSU	JCHAR		EV01	VA rpt_cQ45_DSFCSU = MRPGetMRPParameters.cForecastUnadjusted
cTS_Q75DSFWO	JCHAR		EV01	VA rpt_cQ75_DSFWO = MRPGetMRPParameters.cFirmPartsList
cTS_Q90DSEA	JCHAR		EV01	VA rpt_cQ90_DSEA = MRPGetMRPParameters.cEndingAvailable
cTS_Q85DSEAU	JCHAR		EV01	VA rpt_cQ85_DSEAU = MRPGetMRPParameters.cEndingAvailUnadjusted
cTS_Q80DSPWO	JCHAR		EV01	VA rpt_cQ80_DSPWO = MRPGetMRPParameters.cPlanPartsList
cTS_Q70DSFWOU	JCHAR		EV01	VA rpt_cQ70_DSFWOU = MRPGetMRPParameters.cPartsListUnadjusted
cTS_Q95DSPLO	JCHAR		EV01	VA rpt_cQ95_DSPLO = MRPGetMRPParameters.cPlannedOrders
cTS_Q96DSATPU	JCHAR		EV01	VA rpt_cQ96_DSATPU = MRPGetMRPParameters.cATPUnadjusted
cTS_Q98DSCATPU	JCHAR		EV01	VA rpt_cQ98_DSCATPU = MRPGetMRPParameters.cCATPUnadjusted
cTS_Q97DSATP	JCHAR		EV01	VA rpt_cQ97_DSATP = MRPGetMRPParameters.cATPAdjusted
c_MsgType_A	JCHAR		EV01	VA rpt_cMsgType_A = MRPGetMRPParameters.cActionMessage
cTS_Q99DSCATP	JCHAR		EV01	VA rpt_cQ99_DSCATP = MRPGetMRPParameters.cCATPAdjusted
c_MsgType_F	JCHAR		EV01	VA rpt_cMsgType_F = MRPGetMRPParameters.cFrozenOrderMessage
c_MfgWOFlag	JCHAR		EV01	VA rpt_cMfgWOFlag = MRPGetMRPParameters.cWOFileExists
c_MfgPartsListFlag	JCHAR		EV01	VA rpt_cMfgPartsListFlag = MRPGetMRPParameters.cPartsListExists
c_MsgType_T	JCHAR		EV01	VA rpt_cMsgType_T = MRPGetMRPParameters.cPastDueOrderMessage
c_MsgType_L	JCHAR		EV01	VA rpt_cMsgType_L = MRPGetMRPParameters.cDecreaseOrderMessage
c_MsgType_G	JCHAR		EV01	VA rpt_cMsgType_G = MRPGetMRPParameters.cIncreaseOrderMessage
c_MultiLevelFlag	JCHAR		EV01	VA rpt_cMultiLevelFlag = MRPGetMRPParameters.cMultiLevelFlag
c_F3404Exists	JCHAR		EV01	VA rpt_cF3404Exists = MRPGetMRPParameters.cF3404TableExistenceCode
cErrorCode	JCHAR	O	ERRC	VA sec_cErrorCode_ERRC * Note that this error code is shared through multiple business function gets called in the routine
cDumpDebugInfo	JCHAR		EV01	VA rpt_cDEBUGMODE DEFAULT = 0. This flag is for Oracle Internal Use. In case you modify assignment into '1', it shall take/write additional information. Do not modify it, unless it is requested by Oracle
nNumberOfBranches	int		INT01	RV INT-NumberOfBranches-GV = Total Number of Branch Plant you set. This value is increased through event rule in Do Section Event
cWriteTSForCoByProducts	JCHAR	I/O	EV01	VA rpt_cWriteTSForCoByProducts = If N3500110 determines to write Time Series this value is to be returned 1
mnTotalSafetyStocks	MATH_NUMERIC		SAFE	RV SAFE-Total SS-GV = Safety Stock is the accumulation of all branches for the current item. SUM (F4102.SAFE)
szPO_RateOrderType[3]	JCHAR		DCTO	PO szScheduleType
szPO_StatusCodeRate[3]	JCHAR		SRST	PO szStatusCodeWo
cPOExtendRate	JCHAR		EV13	PO cEverestEventPoint09
mnUniqueKeyIDOffset	MATH_NUMERIC		MATH01	VA rpt_mnUniqueKeyIDOffset_Math01 Case (Non Parallel Processing) this value is 1 Case (Parallel Processing) Offset is equivalent to number of processors = PO mnMathNumeric06
cClearFilesFlag	JCHAR		EV01	PO cClearFilesFlag
jdFirstDate	JDEDATE		DATE01	VA sec_jdFirstDateFIRST = CacheProcessMultiPlants.jdStartDate (Attempt to retrieve the date information for this branch from cache)
jdGenerationDate	JDEDATE		DATE01	PO jdGenStartDate
cTS_Q67DSFID	JCHAR		EV01	VA rpt_cQ67_DSFID = MRPGetMRPParameters.cFirmInterplantDemand
cTS_Q68DSTIU	JCHAR		EV01	VA rpt_cQ68_DSTIU = MRPGetMRPParameters.cTotalIndependentDemandUnadj
cTS_Q69DSTI	JCHAR		EV01	VA rpt_cQ69_DSTI = MRPGetMRPParameters.cTotalIndependentDemandAdj
cPO_InterplantConsumesForecast	JCHAR		EV01	PO cInterplantConsumesForecast
cTS_Q66DSFIDU	JCHAR		EV01	VA rpt_cQ66_DSFIDU = MRPGetMRPParameters.cFirmInterplantDemandUnadj
cPastDueRatesFlag	JCHAR		EV01	PO cPastDueRatesFlag
cPO_ConfCompPlanning	JCHAR		EV01	PO cConfigaratorPlanning
szDeletionBranchPlant[13]	JCHAR		MCU	PO szDeleteBranchPlant
szPO_FcstTypeFcstCsptnByCust[3]	JCHAR		TYPF	PO szFcstTypeForFcstCsmptnByCust
cSuppressTimeSeries	JCHAR		EV01	PO cSuppressTimeSeries
cPO_MultiplantProjectPlanning	JCHAR		EV01	PO cMultiplantProjectPlanning
mnSequenceNumber	MATH_NUMERIC	I/O	SEQN	VA rpt_mnSequenceNumber_SEQN = This value is to maintain relationship between N3500110 and B3400370 - MRPWriteOnHandLotQtyToCacheA (MRP, Write On Hand/Lot Qty to Cache)
cCustomerAddressRelationsh	JCHAR		FCCR	PO cCustomerAddressRelationship
szCO_ManualOPExist[31]	JCHAR		DSC1	VA rpt_szManualPOExist = TV Manual OP For Project Exists

Detail Routine:
Error:
Business Function Documenation: n3500110.rtf

#describe again based on NER because this is unique feature of R3483
Back To Top

Ref24
B3400360 MRPWriteDateBuckets (MRP, Write Date Buckets)

Purpose: This business function loads the MRP Bucketless Date Cache used in MRP planning program from the work day calendar table F0007 depending on the No of days, Weeks and Months sent in. It will also flag the bucket dates, and Load the No of days in week/month. It will calculate the Start date, End Date, No of Buckets loaded. It will load the past due periods depending on the input. This function is used to load dates into MRP Bucketless Date Cache used to calculate the requirements for a particular item. If there are any errors, the program will return an error code of '1' and an Error Message '3143'.
Parameter:

Data Structure: D3400360 - MRP, Write Date Buckets

√ In this routine Array is heavily used. So in case you are getting memory error (which is presented as MEMORY VIOLATION in PDF) verify that whether the memory allocated is enough to hold your transaction.
√ B3400360.c includes B3401360.h, B3401360.h include B3401290.h, and B3401290.h includes B3401270.h
√ Date Array is defined at B3401270.h (check how it initialize/allocate memory)

Data Structure: D3400360 (MRP, Write Date Buckets)

Structure Member Name	Data Type	I/O	Alias	Otheres
szBranch[13]	JCHAR	I	MCU	F4102.MCU
jdGenerationStartDate	JDEDATE	I	STRT	PO jdGenStartDate
nNumberOfDays	int	I	INT01	PO nPlanningDays
nNumberOfWeeks	int	I	INT01	PO nPlanningWeeks
nNumberOfMonths	int	I	INT01	PO nPlanningMonths
nNoOfPastDuePeriods	int	I	INT01	PO nPastDuePeriods
nNoOfBucketlessElements	int		INT01
nNoOfBucketElements	int		INT01
jdStartDate	JDEDATE		DATE01
jdEndDate	JDEDATE		DATE02
jdFirstBeginningDate	JDEDATE		DATE03
cSuppressErrorMessages	JCHAR	I	EV01	1 (Suppress Error)
cErrorCode	JCHAR	O	ERRC	VA sec_cErrorCode_ERRC
szErrorMessageID[11]	JCHAR		DTAI
jdBeginningDate	JDEDATE		DATE04
szJobNumberAsString[9]	JCHAR	I	JOB	RV JOB-Job Number String-GV
cForecastConsumptionFlag	JCHAR		EV03
jdForecastConsumptionBeginDate	JDEDATE		DATE05
jdFirstDateInCache	JDEDATE		DATE01
cGenerationMode	JCHAR	I	EV01	PO cNetChangeFlag
nUseDateBranch	int	I	INT01	VA evt_nUseDateBranch
szDateBranch[13]	JCHAR	I	MCU	RV MCU-DateBranch-GV
nInitialBranchCount	int	I	INT01	VA rpt_nInitialBranchCount_INT01

Detail Routine

IMPORTANT:

nNumberOfDays + nNumberOfWeeks + nNumberOfMonths + nNoOfPastDuePeriods has to be smaller than MAX_CAPACITY_DATES 56 (defined in B3400360.c)
nInitialBranchCount has to be bigger than actual branches for planning
If any of above condition does not meet, this function issues memory error (which is represented as Memory Violation in PDF)

Unlike other business functions, this function B3400360 is unique in handling memory,

typedef struct    /* Data structure to hold pointers to allocated arrays */
{
   LPJDEDATE      lpjdDateArray;          /* Date Array */
   JCHAR           *lpcDateFlagArray;      /* 'M'onth end, 'W'eekend, or 'B'oth (MonthWeekendFlag) */
   int            *lpiDaysInWeekArray;    /* WorkDaysInWeek */
   int            *lpiDaysInMonthArray;   /* WorkDaysInMonth */
   JCHAR           *lpcBucketFlagArray;    /* Bucket Date (#BD array) (Bucket Flag) */
   JCHAR           *lpcFCPBucketFlagArray; /* Forecast Consumption Bucket Flag */
   LPMATH_NUMERIC lpmnFeaturePercent;      /* Feature Percent */
   JCHAR           *lpcComparisonFlag;     /* Comparison Flag */

} DS3400360ARRAYS, *LPDS3400360ARRAYS;

Error:

Related Functions
B3401270 Cache, Process MRP Bucketless Dates
B3401340 MRP, Return Work Days
B9800210 Convert From and To Julian Date from JDEDATE

Related Tables
F0007 Workday Calendar
F33133 Capacity Dates File
F3405 Forecast Consumption Periods

#check below routine again and re-write it for normal users

Business Function Documentation: b3400360.rtf
Back To Top

Ref25
B3400370 MRPWriteOnHandLotQtyToCacheA (MRP, Write On Hand/Lot Qty to Cache)

Purpose: This business function will write the total On Hand Qty from Location Master F41021 and, optionally, the Lot Quantity by Expiration Date into the MRP Item Quantity Cache. The quantity information is written to the cache with Quantity Type "BAU" (Beginning Available Unadjusted) and "LXU" (Lot Expired Unadjusted). This function is used to obtain data from the F41021 and F4108 table for MRP Planning Program P3482. The function will return error codes necessary.
Parameter:

Data Structure: D3400370A - MRP, Write On Hand And Lot Qty To Cache

Parameter Name	Data Item	Data Type
mnShortItemNumber	ITM	MATH_NUMERIC
szBranch	MCU	char
cPotencyControlFlag	OT1Y	char
mnStandardPotencyValue	STDP	MATH_NUMERIC
mnSafetyStocks	SAFE	MATH_NUMERIC
cPotentUnitFlag	EV01	char
cTransitFlag	EV02	char
cInspectFlag	EV03	char
cOther1Flag	EV04	char
cOther2Flag	EV05	char
cLotExpirationFlag	EV06	char
cLotStatusCode1	LOTS	char
cLotStatusCode2	LOTS	char
cLotStatusCode3	LOTS	char
cLotStatusCode4	LOTS	char
cLotStatusCode5	LOTS	char
cSafetyStockFlag	EV07	char
cSuppressErrorMessage	EV09	char
cErrorCode	ERRC	char
szErrorMessageID	DTAI	char
szJobNumber	JOB	char
jdFirstDate	DATE01	JDEDATE
jdLastDate	DATE01	JDEDATE
cConsolidationMethod	EV01	char
szConsolidationBranch	MCU	char
mnJobNumber	JOBS	MATH_NUMERIC
szComputerID	CTID	char
cSupplyDemandExists	EV01	char
cProjectPlanning	EV01	char
cProjectSpecificItem	EV01	char
mnSequenceNumber	SEQN	MATH_NUMERIC

Detail Routine:
Error:

Related Functions
B3401290 Cache, Process MRP Item Quantities

Related Tables
F41021 Item Location File
F410211 Project Commitment Detail Table
F4108 Lot Master

Business Function Documenation: b3400370.rtf
Back To Top

Ref26
B3401590 MRPParallelManagingSemaphoreLoc (MRP,Parallel-Managing Semaphore Lock)

Purpose:
Parameter:

Data Structure: D3401590 - Data Structure for MRP,Parallel-Managing Semaphore Lock

Parameter Name	Data Item	Data Type
cActionCode	EV01	char
mnSemphoreValue	MATH01	MATH_NUMERIC
szProgramId	PID	char
szVersion	VERS	char

Detail Routine:
Error:

Related Tables
F3420 Semphore Value Table
Back To Top

Ref27
N3101750 F3109GetLineItemRelationship (F3109 Get Line Item Relationship)

Purpose: This business function gets the Line/Item Relationship (F3109) data using a selected index. Data can be retrieved using four different indexes. To perform all retrievals for the F3109 using the selected index.
Parameter:

Data Structure: D3101750 - F3109 Get LineItem Relationship

Parameter Name	Data Item	Data Type
mnIdentifierShortItem	ITM	MATH_NUMERIC
szCostCenterAlt	MMCU	char
szLineIdentifier	LINE	char
cFlagDefaultValue9	DFVL	char
cIndexNumber	EV01	char
cSuppressErrorMessages	EV02	char
szErrorMessageID	DTAI	char
cErrorCode	ERRC	char
szIdentifier2ndItem	LITM	char
szIdentifier3rdItem	AITM	char
szUnitOfMeasureAsInput	UOM	char
szSchedulePriority	SCPR	char
mnScheduleSpread	SCSP	MATH_NUMERIC
jdEffectiveFromDate	EFFF	JDEDATE
jdEffectiveThruDate	EFFT	JDEDATE
cMonthWeekDayHour	MWDH	char
cShiftCode	SHFT	char
mnResourceunitsconsumed	RUC	MATH_NUMERIC
szUMCapacityUOM	CAPU	char

Detail Routine:
Error:
Business Function Documenation: n3101750.rtf
Back To Top

Ref28
B3400540 MRPCalculateScheduleDatesforMRP (MRP, Calculate Schedule Dates for Planning)

Purpose: This business function will Forward or Backward Schedule from the Input Date based on the Stocking Type 'M' for Mfg Item and 'P' for Purchased Item and Calculate the Output Date. If the Item is Purchased it will use the Calendar Days Otherwise it will Schedule based on Work days in the Calendar table (F0007). This function is used to calculate based on the Stocking Type, Lead time and Input date, the Output date after Back/Forward Scheduling.
Parameter:

Data Structure: D3400540 MRP, Calculate Schedule Dates for Planning

Parameter Name	Data Item	Data Type	I/O	Others
cStockingType	STKT	char	I	VA evt_c2ndStockType
jdInputDate	DATE01	JDEDATE	I	VA evt_jdFirstBeginDate_FBEG
cScheduleType	EV01	char	I	(Case 1) F OR, (Case 2) VA evt_cScheduleType_EV02
mnLeadTimeInDays	LTLV	MATH_NUMERIC	I	(Case 1) VA evt_mnF4102PlanTimeFence_MTF1 OR, (Case 2) VA evt_mnF4102FreezeTF_MTF2
cSuppressErrorMessage	EV01	char	I	1
jdOutputDate	DATE02	JDEDATE	O	(Case 1) VA evt_jdPlanningTimeFence_PLDT OR, (Case 2) VA evt_jdFreezeTimeFence_FRDT
cErrorCode	ERRC	char	O	Not In Use
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI
szBranch	MCU	char	I	VA evt_szDateBranch
mnShortItemNumber	ITM	MATH_NUMERIC	I	BF mnPreviousItemNumber
szProgramID	PID	char	I	VA evt_szProgramID
mnF3411UniqueID	UKID	MATH_NUMERIC	I/O	BF mnF3411_UniqueID
szDateErrorMsgDesc	DSC1	char	I	BF szCO_ShopCalendarNotSetup
cDateErrorFlag	EV02	char	I/O	VA evt_cDateErrorFlag
szJobNumber	JOB	char	I	BF szJobNumber
mnUniqueKeyIDOffset	MATH01	MATH_NUMERIC	I	BF mnUniqueKeyIDOffset
nNumberofDates	INT01	integer	I	VA evt_iNumBucketlessDates

Detail Routine:
Error:
Related Functions
B3100300 Forward Backward Schedule Dates
B3401270 Cache, Process MRP Bucketless Dates
B9800100 Get Audit Information

Related Tables
F3411 MPS/MRP/DRP Message File
Business Function Documentation: b3400540.rtf
Back To Top

Ref29
B3400590 MRPWriteTimeSeriesData (MRP, Write Time Series Data)

Purpose: This business function will get read the MRP Regular Item Cache (using B34001290) and Write Time Series Records to the Time Series Table (F3413). It will also calculate the ATP/CATP data and optionally write those records to F3413 table. This function is used to wirte the Time Series Data for an Item after Planning the Item for the MRP Planning program P3482. The function will return error codes necessary. This function is also shared by R3483 for Multi-Plant MRP Processing. The Manufacturing Data from the Item Balance table must be obtained and all other data must be loaded in the Regular Item Cache and Bucketless Date Cache. The JOBS and CTID must be obtained using B3100710 and B9800180 before calling this function. Please note that this is the output after planning and care must be taken while making changes in the code.
Parameter:

Data Structure: D3400590 - MRP, Write Time Series Data

Parameter Name	Data Item	Data Type	I/O	Others
mnJobnumber	JOBS	MATH_NUMERIC		BF mnJobNumber
szComputerId	CTID	char		BF szComputerID
szBranch	MCU	char		VA evt_szF35UI001BusinessUnit
mnShortItemNumber	ITM	MATH_NUMERIC		BF mnPreviousItemNumber
mnSafetyStocks	SAFE	MATH_NUMERIC		VA evt_mnF4102SAFE
szReportingCode	RT	char		BF szPO_QuantityTypeForTS
cSafetyStockFlag	EV01	char		BF cPO_IncludeSafetyStocks
nNumBucketDates	INT01	integer		VA evt_iNumBucketDates
nFirstATPPeriod	INT02	integer		BF nFirstATPPeriod
nNoofPastDuePeriods	INT03	integer		BF cPO_PastDuePeriods
jdBeginningDate	DATE01	JDEDATE		VA evt_jdBeginDate_BEG
jdPlanningDate	DATE02	JDEDATE		VA evt_jdPlanningTimeFence_PLDT
cBegAvailUnadjusted	EV01	char		BF cTS_Q05DSBAU
cBeginningAvailable	EV02	char		BF cTS_Q10DSBA
cReceiptRouting	EV03	char		BF cTS_Q13DSIR
cPurchOrderUnadjusted	EV04	char		BF cTS_Q15DSPOU
cPurchOrderAdjusted	EV05	char		BF cTS_Q20DSPO
cWorkOrderUnadjusted	EV06	char		BF cTS_Q25DSWOU
cWorkOrderAdjusted	EV07	char		BF cTS_Q30DSWO
cRateScheduleUnadjusted	EV08	char		BF cTS_Q35DSRSU
cRateScheduleAdjusted	EV09	char		BF cTS_Q40DSRS
cLotExpiration	EV10	char		BF cTS_Q42DSLEX
cForecastUnadjusted	EV01	char		BF cTS_Q45DSFCSU
cForecastAdjusted	EV02	char		BF cTS_Q50DSFCST
cSalesOrderUnadjusted	EV03	char		BF cTS_Q55DSSOU
cSalesOrderAdjusted	EV04	char		BF cTS_Q60DSSO
cInterPlantDemand	EV05	char		BF cTS_Q65DSID
cPartsListUnadjusted	EV06	char		BF cTS_Q70DSFWOU
cFirmPartsList	EV07	char		BF cTS_Q75DSFWO
cPlanPartsList	EV08	char		BF cTS_Q80DSPWO
cEndingAvailUnadjusted	EV09	char		BF cTS_Q85DSEAU
cEndingAvailAdjusted	EV10	char		BF cTS_Q90DSEA
cPlannedOrders	EV01	char		BF cTS_Q95DSPLO
cATPUnadjusted	EV02	char		BF cTS_Q96DSATPU
cATPAdjusted	EV02	char		BF cTS_Q97DSATP
cCATPUnadjusted	EV03	char		BF cTS_Q98DSCATPU
cCATPAdjusted	EV04	char		BF cTS_Q99DSCATP
cSuppressErrorMessage	EV05	char		1
cErrorCode	ERRC	char		Not In Use
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI
jdFirstBeginningDate	DATE01	JDEDATE		VA evt_jdFirstBeginDate_FBEG
cForecastConsumptionFlag	EV02	char		BF cUseForecastConsumptionLogic
cWriteTSForCoBy	EV01	char		<Blank>
szDateBranch	MCU	char		VA evt_szDateBranch
szJobNumberAsString	JOB	char		BF szJobNumber
cConsolidationMethod	EV01	char		BF cPO_ConsolidationMethod
cShippedQtys	EV01	char		BF cTS_Q52DSSHIP
cProcessPlanningFlag	EV01	char		BF cPO_ProcessPlanning
cFirmInterplantDemand	EV01	char		BF cTS_Q67DSFID
cTotalIndependentDemandUnadj	EV01	char		BF cTS_Q68DSTIU
cTotalIndependentDemandAdj	EV01	char		BF cTS_Q69DSTI
cInterplantConsumesForecast	EV01	char		BF cPO_InterplantConsumesForecast
szProgramId	PID	char		VA evt_szProgramID
cFirmInterplantDemandUnadj	EV01	char		BF cTS_Q66DSFIDU
cProjectPlanning	EV01	char		BF cPO_MultiplantProjectPlanning
cProjectSpecificItem	EV01	char		VA evt_cProjectSpecificItem_EV01

Detail Routine:
Error:
Related Functions
B3401270 Cache, Process MRP Bucketless Dates
B3401290 Cache, Process MRP Item Quantities
B3500060 Cache, Process Multi Plants

Related Tables
F3413 MPS/MRP/DRP Summary File
F34UI005 MRP Orders/Requirements User Index-Process Item
F4102 Item Branch File
Business Function Documentation: b3400590.rtf

#truncated so re-write it or simplify it
Back To Top

Ref30
N3402030 F3413WriteGenerationDate (F3413 Write Generation Date)

Purpose: Write Generation Date record for Process item in time series after all the dates calculations are complete and also process item has been identified
Parameter:

Data Structure: D3402030 - F3413 Write Generation Date

Parameter Name	Data Item	Data Type	I/O	Others
mnShortItemNumber	ITM	MATH_NUMERIC	I	BF mnPreviousItemNumber
szBranch	MCU	char	I	VA evt_szF35UI001BusinessUnit
jdFirstBeginningDate	STRT	JDEDATE	I	VA evt_jdFirstBeginDate_FBEG
cErrorCode	EV01	char		Not In Use

Detail Routine:
Error:

Ref31
B3401220 F3002CalculateFeaturePercent (F3002 Calculate Feature Percent)

Purpose: Read Bill and Load all Processes, Read Bill for Effective dates and Calculate Feature Percent. This function is equivalent to Subroutine S005AC - Calculate Feature Percentage in P3482 (AS/400)
Parameter:

Data Structure: D3401220 - F3002 Calculate Feature Percent

Parameter Name	Data Item	Data Type
mnShortItemNumber	ITM	MATH_NUMERIC
szBranchPlant	MCU	char
nElementsInDateArray	INT01	integer
cWarningMessageFlag	EV01	char
mnF3411UniqueID	UKID	MATH_NUMERIC
cNetChangeFlag	EV01	char
szPlanningPctNot100MsgDesc	DSC1	char
cATPFlag	EV01	char
cCoByProductFlag	COBY	char
szComputerID	CTID	char
cMRPMessageFlag	EV01	char
szProgramID	PID	char
nNumPastDueDates	INT01	integer
szJobNumber	JOB	char
mnUniqueKeyIDOffset	MATH01	MATH_NUMERIC

Detail Routine:
Error:

Related Functions
B3401270 Cache, Process MRP Bucketless Dates
B9800100 Get Audit Information
N3101200 F3112 Verify Operation Sequence

Related Tables
F3002 Bill of Material Master File
F3111 Work Order Parts List
F3404 Co-Products Planning/Costing Table
F3411 MPS/MRP/DRP Message File
F4102 Item Branch File

Business Function Documenation: b3401220.rtf
Back To Top

REf32
B3401210 F3002CheckIfItemIsByProduct (F3002 Check If Item Is Byproduct)

Purpose: Read Bill and Check for By-Product and Check in WO Detail file. Equivalent to Subroutine S005AB - Check if Item is a By-Product. If the item is not a Co-Product, check if it is a By-Product.
Parameter:

Data Structure: D3401210 - F3002 Check If Item Is By Product

Parameter Name	Data Item	Data Type	I/O	Others
mnShortItemNumber	ITM	MATH_NUMERIC	I	BF mnPreviousItemNumber
szBranchPlant	MCU	char	I	VA evt_szF4102Branch
cByProduct	EV01	char	I/O	VA evt_cByProductFlag
mnJobNumber	JOBS	MATH_NUMERIC	I	BF mnJobNumber
szComputerID	CTID	char	I	BF szComputerID
nNumberBucketlessDates	INT01	integer	I	VA evt_iNumBucketlessDates
cErrorCode	ERRC	char	O	VA evt_cErrorCode_ERRC

Detail Routine:
Error:

Related Tables
F3002 Bill of Material Master File
F3111 Work Order Parts List

Business Function Documentation: b3401210.rtf
Back To Top

REf33
B3401230 F3002LoadCoProductsFromBill (F3002 Load CoProducts From Bill)

Purpose: This function reads the Bill of Material to determine is the input Item Number is a Process. If it is, the User Index table F34UI005 is loaded with all Co and By Products for the process. This function is equivalent to Subroutine S005AP - Load Co-Products from Bill in P3482 ( AS/400)
Parameter:

Data Structure: D3401230 - F3002 Load CoProducts from Bill

Parameter Name	Data Item	Data Type	I/O	Others
mnShortItemNumber	ITM	MATH_NUMERIC	I	BF mnPreviousItemNumber
szBranchPlant	MCU	char	I	VA evt_szF4102Branch
cPotencyControl	OT1Y	char	I	VA evt_cF4102SVOT1Y
mnStandardPotency	STDP	MATH_NUMERIC	I	VA evt_mnF4102SVSTDP
szPrimaryUOM	UOM1	char	I	BF szPrimaryUnitOfMeasure
cProcessFlag	EV01	char	I/O	VA evt_cProcessItemFlag_PROC
szStdUOMConversion	TFLA	char	I	BF szStdUOMConversion
szComputerID	CTID	char	I	BF szComputerID
nNumCoByProducts	INT01	integer	I/O	VA evt_iNumCoByProducts
szJobNumber	JOB	char	I	BF szJobNumber

Detail Routine:
Error:
Related Functions
B3401280 Cache, Process MRP Co/By Products
B4000520 Get Item UoM Conversion Factor

Related Tables
F3002 Bill of Material Master File
F34UI005 MRP Orders/Requirements User Index-Process Item
F4101 Item Master
F4102 Item Branch File

Business Function Documenation: b3401230.rtf
Back To Top

REf34
B3400550 MRPGetBucketDateFromCache (MRP, Get Bucket Date from Cache)

Purpose: This business function will get the nearest Bucket Date for a given date based on the data in the MRP Bucketless Date Cache. This is used in the MRP Program to get the bucket date nearest to the given date. As of 1/2/97, it can also look for a nearest Forecast Consumption Bucket Date from the Bucketless Date Cache. This function is used to get the bucket date nearest to the Input date or the nearest Forecast Consumption Bucket Date. The MRP Bucketless Date Cache must be have been loaded using B3400360 before calling this function.
Parameter:

Data Structure: D3400550 - MRP, Get Bucket Date from Cache

Parameter Name	Data Item	Data Type	I/O	Others
szBranch	MCU	char	I	VA evt_szDateBranch
jdInputDate	DATE01	JDEDATE	I	VA evt_jdPlanningTimeFence_PLDT
cSuppressErrorMessage	EV01	char	I	1
jdOutputDate	DATE02	JDEDATE	O	VA evt_jdPlanningTimeFenceFC_PLDT
cErrorCode	ERRC	char		Not In Use
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI
szJobNumber	JOB	char	I	BF szJobNumber
cFindForecastConsumptionBucket	EV01	char		Not In Use

Detail Routine:
Error:
Related Functions
B3401270 Cache, Process MRP Bucketless Dates
Business Function Documentation: b3400550.rtf
Back To Top

REf35
B3400430 MRPClearTimeSeriesMessagesOrPegg (MRP, Clear TimeSeries, Messages Or Pegging Qtys)

Purpose: The purpose of this function is to delete records from various Manufacturing tables including F3411 (Messages), F3412 (Pegging), and F3413 (Time Series). The user passes the name of the file to delete records from and a flag indicating which records to delete. If Delete Flag = '1', all records are removed from the specified table. If Delete Flag = '0', the function deletes records matching the input Item Number and Branch key values. If Delete Flag = '2', the function deletes records matching the Branch key value.
Parameter:

Data Structure: D3400430 - MRP, Clear TimeSeries, Messages Or Pegging Qtys

Parameter Name	Data Item	Data Type	I/O	Others
mnShortItemNumber	ITM	MATH_NUMERIC	I	BF mnPreviousItemNumber
szBranch	MCU	char	I	VA evt_szF4102Branch OR, VA evt_szF35UI001BusinessUnit
szTableName	OBJP	char	I	F3411 F3412 F3412 (BF c_MultiLevelFlag = 'Y')
cDeleteFlag	EV01	char	I	<Zero>
cSuppressErrorMessage	EV02	char	I	1
cErrorCode	ERRC	char		Not In Use
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI
cNumberOfKeys	EV03	char		Not In Use

Detail Routine:
Error:
Related Tables
F3411 MPS/MRP/DRP Message File
F3412 MPS/MRP/DRP Lower Level Requirements File
F3413 MPS/MRP/DRP Summary File

Business Function Documentation: b3400430.rtf
Back To Top

ref36
B3400560 MRPUpdateNetChangefromBOM (MRP, Update Net Change from BOM)

Purpose: This business function will check if Bill of Materials (F3002) exists for an Item/Branch. If it does not exist, it will write a message to F3411 Message table. Optionally, if the BOM is found, it will update the Net Change flag in the F4102 Item Balance table for all the components in the Bill of Materials. This function is used to set on the Net Change flag in the Item Balance for all components in the BOM in the Planning Program P3482 in Net Change Mode. This function should NOT be called only under these conditions: 1)

If calling from R3482 - If $$CONS = '1' And $$CON2 = '1' And $CMCU <> " " And SVSTK2 <> 'M'. 2)
If calling from R3483 - If $$CONS = '1' And SVSTK2 <> 'M' Or $$CONS = '1' And $CMCU<>" " And $CMCU<> SVMCU.

Parameter:

Data Structure: D3400560 - MRP, Update Net Change from BOM

Parameter Name	Data Item	Data Type	I/O	Others
mnShortItemNumber	ITM	MATH_NUMERIC	I	BF mnPreviousItemNumber
szBranch	MCU	char	I	VA evt_szF35UI001BusinessUnit
cWarningMsgFlag	EV01	char	I	BF c_MsgType_A
szWarningMsgDescription	DSC1	char	I	BF szCO_BOMDoesNotExist
mnUniqueKeyID	UKID	MATH_NUMERIC	I/O	BF mnF3411_UniqueID
szProgramID	PID	char	I	VA evt_szProgramID
cSuppressErrorMessage	EV02	char	I	1
cErrorCode	ERRC	char	O	Not In Use
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI
cMessageCode	MRPD	char	I/O	VA evt_cMRPDFlag
szCoByWarningDesc	DSC1	char	I	BF szCO_NoBOMCoByProduct
cNetChangeFlag	EV02	char	I	BF cPO_NetChangeFlag
mnUniqueKeyIDOffset	MATH01	MATH_NUMERIC	I	BF mnUniqueKeyIDOffset

Detail Routine:
Error:
Related Functions
B9800100 Get Audit Information
Related Tables
F3002 Bill of Material Master File
F3411 MPS/MRP/DRP Message File
F4102 Item Branch File
Business Function Documentation: b3400560.rtf
Back To Top

ref37
B3400390 MRPWriteSalesOrderQtyToCache (MRP, Write Sales Order Qty To Cache)

Purpose: This business function will read the Sales Order table (F4211) and write Open Quantities to the MRP Item Quantity Cache in the primary unit of measure. Calculate quantities are written to the cache with Quantity Type 'SOU' (Sales Order Unadjusted). This function is used to obtain data from the F4211 table for the MRP Planning Program P3482. The function will return error codes necessary. Adjustments to order quantities according to time fence rules will be performed in the B3400400 BsFn.
Parameter:

Data Structure: D3400390 - MRP, Write Sales Order Qty To Cache

Parameter Name	Data Item	Data Type	I/O	Others
mnShortItemNumber	ITM	MATH_NUMERIC	I	BF mnPreviousItemNumber
szBranch	MCU	char	I	VA evt_szF35UI001BusinessUnit
jdBeginDate	EFFF	JDEDATE	I	VA evt_jdBeginDate_BEG
cPotencyControlFlag	OT1Y	char	I	VA evt_cF4102SVOT1Y
mnStandardPotencyValue	STDP	MATH_NUMERIC	I	VA evt_mnF4102SVSTDP
cPotencyUnitFlag	EV01	char	I	VA evt_cPotencyUnitFlag_PUFG
szPrimaryUom1	UOM1	char	I	BF szPrimaryUnitOfMeasure
cSuppressErrorMessage	EV01	char	I	1
cErrorCode	ERRC	char		Not In Use
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI
szStandardUOMConversion	TFLA	char	I	BF szStdUOMConversion
szJobNumber	JOB	char	I	BF szJobNumber
jdThruDate	EFFT	JDEDATE	I	VA evt_jdEndDate_ENDD
jdForecastBeginningDate	DATE04	JDEDATE	I	VA evt_jdForecastBeginDate_FBDT
nNumberPastDuePeriods	INT01	integer	I	BF cPO_PastDuePeriods
cForecastConsumptionFlag	EV03	char	I	BF cUseForecastConsumptionLogic
cConsolidationMethod	EV02	char	I	BF cPO_ConsolidationMethod
szDecreaseSOQtyDesc	DSC1	char	I	BF szCO_DecreaseSOQty
szIncreaseSOQtyDesc	DSC1	char	I	BF szCO_IncreaseSOQty
szDeferSODesc	DSC1	char	I	BF szCO_DeferSO
szCancelSODesc	DSC1	char	I	BF szCO_CancelSO
szExpediteSODesc	DSC1	char	I	BF szCO_ExpediteSO
cWarningMsgFlag	EV01	char	I	BF c_MsgType_A
mnF3411UniqueID	UKID	MATH_NUMERIC	I/O	BF mnF3411_UniqueID
cMRPDisplayCode	MRPD	char	I	VA evt_cMRPDFlag
szDateBranch	MCU	char	I	VA evt_szDateBranch
szProgramId	PID	char	I	VA evt_szProgramID
szConsolidationBranch	MCU	char	I	BF szPO_ConsolidationBranch
mnUniqueKeyIDOffset	MATH01	MATH_NUMERIC	I	BF mnUniqueKeyIDOffset
cSalesOrderIncluded	EV01	char	O	VA evt_cSalesOrderIncluded_EV01
cProjectPlanning	EV01	char	I	BF cPO_MultiplantProjectPlanning
mnSequenceNumber	SEQN	MATH_NUMERIC	I/O	BF mnSequenceNumber
mnCustomerNumber	AN8	MATH_NUMERIC		Not In Use
cMode	EV01	char	I	1 OR, cMode2 #describe again (this gets called after Forecast consumption logic)
cCustomerAddressRltnship	FCCR	char	I	BF cCustomerAddressRelationsh

Detail Routine:
Error:

Related Functions
B3401270 Cache, Process MRP Bucketless Dates
B3401290 Cache, Process MRP Item Quantities
B3401300 Cache, Process MRP Inclusion Rules
B4000520 Get Item UoM Conversion Factor

Related Tables
F3411 MPS/MRP/DRP Message File
F4108 Lot Master
F4211 Sales Order Detail File

Business Function Documentation: b3400390.rtf
Back To Top

ref38
B3400380 MRPWriteForecastQtyToCache (MRP, Write Forecast Quantity To Cache)

Purpose: This business function will read the Forecast table (F3460) and write the Forecast Quantity to the MRP Item Quantity Cache. Quantities are written to the cache with Quantity Type 'FQU' (Forecast Qty Unadjusted). This function is used to obtain data from the F3460 table for the MRP Planning Program P3482. The function will return error codes necessary. The adjustments to the forecast quantities based on time fence rules will not be done in this function. Instead, B3400400 will do this.
Parameter:

Data Structure: D3400380 - MRP, Write Forecast Qty To Cache

Parameter Name	Data Item	Data Type	I/O	Others
mnShortItemNumber	ITM	MATH_NUMERIC		BF mnPreviousItemNumber
szBranch	MCU	char		VA evt_szF35UI001BusinessUnit
jdFromDate	EFFF	JDEDATE		VA evt_jdFirstBeginDate_FBEG
cMasterPlanningCode	MPST	char		VA evt_cF4102SVMPST
cGenerationType	EV01	char		BF cPO_GenerationType
szForecastType1	TYPF	char		BF szForecastType_1 OR, (cMode=2) BF szPO_FcstTypeFcstCsptnByCust
szForecastType2	TYPF	char		BF szForecastType_2 OR, (cMode=2) Not In Use
szForecastType3	TYPF	char		BF szForecastType_3 OR, (cMode=2) Not In Use
szForecastType4	TYPF	char		BF szForecastType_4 OR, (cMode=2) Not In Use
szForecastType5	TYPF	char		BF szForecastType_5 OR, (cMode=2) Not In Use
szMPSForecastType	TYPF	char		BF szPO_FcstTypeFcstCsptnByCust
cSuppressErrorMessage	EV01	char		1
cErrorCode	ERRC	char		Not In Use
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI
szJobNumber	JOB	char		BF szJobNumber
jdThruDate	EFFT	JDEDATE		VA evt_jdEndDate_ENDD
jdForecastBeginningDate	DATE04	JDEDATE		VA evt_jdForecastBeginDate_FBDT
cForecastConsumptionFlag	EV03	char		BF cUseForecastConsumptionLogic
cTimeFenceRule	MPSP	char		VA evt_cPlanFenceRule_SFOG
szConsolidationBranch	MCU	char		BF szPO_ConsolidationBranch
cForecastIncluded	EV01	char	O	VA evt_cForecastIncluded_EV01
jdGenerationDate	DATE01	JDEDATE		BF jdGenerationDate
cMode	EV01	char		1 OR, cMode = 2
jdPlanDate	PLDT	JDEDATE		VA evt_jdPlanningTimeFence_PLDT
jdStartDate	DTE	JDEDATE		VA evt_jdFirstDate_FIRST
nNoOfBucketlessDates	INT01	integer		VA evt_iNumBucketlessDates
cIncludeShippedQuantities	EV01	char		BF cTS_Q52DSSHIP
cNumberOfBranches	INT01	integer		BF nNumberOfBranches OR, (cMode=2) Not In Use
szComputerID	CTID	char		BF szComputerID
cSupplyDemandExists	EV01	char	I/O	VA evt_cSupplyDemandExists
cInterplantConsumesForecast	EV01	char		BF cPO_InterplantConsumesForecast
jdBeginDate	DTE	JDEDATE		VA evt_jdBeginDate_BEG
cPotencyControlFlag	EV01	char		VA evt_cF4102SVOT1Y OR, (cMode=2) Not In Use
mnStandardPotency	STDP	MATH_NUMERIC		VA evt_mnF4102SVSTDP OR, (cMode=2) Not In Use
cPotencyUnitFlag	EV01	char		VA evt_cPotencyUnitFlag_PUFG OR, (cMode=2) Not In Use
szUnitOfMeasurePrimary	UOM1	char		BF szPrimaryUnitOfMeasure OR, (cMode=2) Not In Use
nNumberOfPastDuePeriods	INT01	integer		BF cPO_PastDuePeriods
cConsolidationMethod	EV01	char		BF cPO_ConsolidationMethod
szStandardUOMConversion	TFLA	char		BF szStdUOMConversion
szDecreaseSOQtyDesc	DSC1	char		BF szCO_DecreaseSOQty OR, (cMode=2) Not In Use
szIncreaseSOQtyDesc	DSC1	char		BF szCO_IncreaseSOQty OR, (cMode=2) Not In Use
szDeferSODesc	DSC1	char		BF szCO_DeferSO OR, (cMode=2) Not In Use
szCancelSODesc	DSC1	char		BF szCO_CancelSO OR, (cMode=2) Not In Use
szExpediteSODesc	DSC1	char		BF szCO_ExpediteSO OR, (cMode=2) Not In Use
cWarningMessageFlag	EV01	char		BF c_MsgType_A
mnF3411UniqueKeyID	UKID	MATH_NUMERIC		BF mnF3411_UniqueID
cMRPItemDisplayCode	MRPD	char	I/O	VA evt_cMRPDFlag
szDateBranch	MCU	char		VA evt_szDateBranch
szProgramId	PID	char		VA evt_szProgramID OR, (cMode=2) Not In Use
mnUniqueKeyIDOffset	MATH01	MATH_NUMERIC		BF mnUniqueKeyIDOffset OR, (cMode=2) Not In Use
cSalesOrderIncluded	EV01	char	O	VA evt_cSalesOrderIncluded_EV01 OR, (cMode=2) Not In Use
cProjectPlanning	EV01	char		BF cPO_MultiplantProjectPlanning
mnSequenceNumber	SEQN	MATH_NUMERIC	I/O	BF mnSequenceNumber
szUserId	USER	char		VA evt_szUserID_USER OR, (cMode=2) Not In Use
jdMessageTimeFenceDate	DATE01	JDEDATE		VA evt_jdMsgTimeFence_MSGD OR, (cMode=2) Not In Use
cCustomerAddressRltnship	FCCR	char		BF cCustomerAddressRelationsh

Detail Routine:
Error:

Related Functions
B3401290 Cache, Process MRP Item Quantities

Related Tables
F3460 Forecast File
Business Function Documenation: b3400380.rtf
#ref39 is ommitted owing to duplication of B3400390 MRPWriteSalesOrderQtyToCache
Back To Top

ref40
B3500020 MRPWriteOtherBranchDemandtoCache (MRP,Write Other Branch Demand to Cache)

Purpose: This function should ONLY be used by R3483. It will read F3411 records by Item and Supply Branch(MMMMCU), calculate the Other Branch Demand quantity and write the quantity to the Quantities Cache. So to Adjust Sales and Forecast qianties.
Parameter:

Data Structure: D3500020 - MRP, Write Other Branch Demand to Cache-DS

Parameter Name	Data Item	I/O	Others
mnIdentifierShortItem	ITM		BF mnPreviousItemNumber
szCostCenter	MCU		VA evt_szF35UI001BusinessUnit
jdDate01	DATE01		VA evt_jdEndDate_ENDD
cErrorCode	ERRC	O	VA evt_cErrorCode_ERRC
szJobNumber	JOB		BF szJobNumber
jdMessageTimeFenceDate	DATE01		VA evt_jdMsgTimeFence_MSGD
cSupplyDemandExists	EV01	O	VA evt_c_B3500020SupplyDemand
cProjectPlanning	EV01		BF cPO_MultiplantProjectPlanning * PMPN Enhancement - Added ProjectPlanning Processing Option

Detail Routine:
Error:

Related Functions
B3401290 Cache, Process MRP Item Quantities

Related Tables
F3411 MPS/MRP/DRP Message File
Business Function Documentation: b3500020.rtf
Back To Top

ref41
B3400400 MRPUpdateAdjustedSalesAndForecas (MRP, Update Adjusted Sales and Forecast Qty)

Purpose: This business function reads the MRP Item Quantity Cache and calculates the Adjusted Forecast and Sales Order Quantities based on the Time Fence Rule and Time Fence Days. It then updates the cache with the calculated quantities. The time fence rules handled are 'G', 'C', 'F' ,'S', '1', '3' and 'H' with forecast consumption logic turned on.. These are described in the UDC tables and are hard coded. This function is used to net the requirements of an Item based on how the sales and forecasts are handled based on the Time fence rules for the MRP Planning Program. Forecast Consumption logic using Shipped quantities is also taken into account before adjusting the sales orders with the forecast quantities.
Parameter:

Data Structure: D3400400 - MRP, Update Adjusted Sales and Forecast Qty

Parameter Name	Data Item	Data Type	I/O	Others
cTimeFenceRule	MPSP	char		VA evt_cPlanFenceRule_SFOG
jdPlanDate	DATE01	JDEDATE		VA evt_jdPlanningTimeFence_PLDT
cSuppressErrorMessage	EV01	char		1
cErrorCode	ERRC	char		Not In Use
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI
szBranch	MCU	char		VA evt_szF35UI001BusinessUnit
szJobNumber	JOB	char		BF szJobNumber
jdFirstDate	DATE01	JDEDATE		VA evt_jdBeginDate_BEG
cForecastConsumptionFlag	EV03	char		BF cUseForecastConsumptionLogic
jdForecastBeginningDate	DATE04	JDEDATE		VA evt_jdForecastBeginDate_FBDT
nNumberBucketlessDates	INT01	integer		VA evt_iNumBucketlessDates
mnShortItemNumber	ITM	MATH_NUMERIC		BF mnPreviousItemNumber
nNumberPastDueDates	INT02	integer		BF cPO_PastDuePeriods
cIncludeShippedQuantities	EV04	char		BF cTS_Q52DSSHIP
szDateBranch	MCU	char		VA evt_szDateBranch
cConsolidationMethod	EV01	char		BF cPO_ConsolidationMethod
nNumberOfBranches	INT01	integer		<Zero>
szComputerID	CTID	char		BF szComputerID
cForecastIncluded	EV01	char		VA evt_cForecastIncluded_EV01
cSalesOrderIncluded	EV02	char		VA evt_cSalesOrderIncluded_EV01
cSupplyDemandExists	EV01	char	I/O	VA evt_cSupplyDemandExists
cInterplantConsumesForecast	EV01	char		BF cPO_InterplantConsumesForecast
szProgramId	PID	char		VA evt_szProgramID
szNewForecastType	TYPF	char		Not In Use
szUserId	USER	char		Not In Use
mnCustomerNumber	AN8	MATH_NUMERIC		Not In Use

Detail Routine:
Error:

Related Functions
B3401270 Cache, Process MRP Bucketless Dates
B3401290 Cache, Process MRP Item Quantities

Related Tables
F3462 Forecast Shipment Summary
F35UI001 MPS/MRP Planning - Multiple Plant User Index

Business Function Documenation: b3400400.rtf
Back To Top

ref42

B3400420 MRPWritePurchaseOrderQtyToCache (MRP, Write Purchase Order Qty To Cache)

Purpose: This business function will get read the Purchase Order table (F4311) and Load the Open Quantity Calculated in the Item Qty Cache in the Primary Unit of Measure. It will also cache the Purchase Order records that were selected for use and store the PO quantities in the Primary UOM. This function is used to obtain data from the F4311 table for the MRP Planning Program P3482. The function will return error codes necessary.
Parameter:

Data Structure: D3400420 - MRP, Write Purchase Order Qty To Cache

Parameter Name	Data Item	Data Type	I/O	Others
mnShortItemNumber	ITM	MATH_NUMERIC		BF mnPreviousItemNumber
szBranch	MCU	char		VA evt_szF35UI001BusinessUnit
jdBeginDate	EFFF	JDEDATE		VA evt_jdBeginDate_BEG
szDisplayUnitOfMeasure	UOM1	char		BF szPrimaryUnitOfMeasure
cTransitFlag	EV01	char		BF cPO_IncludeTransitFlag
cInspectFlag	EV02	char		BF cPO_IncludeInspectionFlag
cOther1Flag	EV03	char		BF cPO_IncludeOther1Flag
cOther2Flag	EV04	char		BF cPO_IncludeOther2Flag
jdMessageDate	DATE01	JDEDATE		VA evt_jdMsgTimeFence_MSGD
jdRegenerationDate	DATE02	JDEDATE		VA evt_jdFirstBeginDate_FBEG
cFrozenOrderMsgFlag	EV09	char		BF c_MsgType_F
cPastDueOrderMsgFlag	EV10	char		BF c_MsgType_T
mnF3411UniqueKeyID	UKID	MATH_NUMERIC	I/O	BF mnF3411_UniqueID
cSuppressErrorMessages	EV07	char		1
cReceiptRoutingFlag	EV08	char		BF cTS_Q13DSIR
cErrorCode	ERRC	char		Not In Use
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI
cPurchaseOrderFlag	EV09	char	O	VA evt_cTempExistence
cMRPMessageFlag	MRPD	char	I/O	VA evt_cMRPDFlag
szFrozenOrderDesc	DSC1	char		BF szCO_FrozenOrder
szPastDueOrderDesc	DSC2	char		<Blank>
szProgramid	PID	char		VA evt_szProgramID
szStandardUOMConversion	TFLA	char		BF szStdUOMConversion
mnStandardPotency	STDP	MATH_NUMERIC		VA evt_mnF4102SVSTDP
cPotencyControl	OT1Y	char		VA evt_cF4102SVOT1Y
szJobNumber	JOB	char		BF szJobNumber
jdLastDate	EFFT	JDEDATE		VA evt_jdEndDate_ENDD
jdForecastBeginningDate	DATE04	JDEDATE		VA evt_jdForecastBeginDate_FBDT
cForecastConsumptionFlag	EV03	char		BF cUseForecastConsumptionLogic
nNumberPastDuePeriods	INT01	integer		BF cPO_PastDuePeriods
szDateBranch	MCU	char		VA evt_szDateBranch
cConsolidationMethod	EV01	char		BF cPO_ConsolidationMethod
mnUniqueKeyIDOffset	MATH01	MATH_NUMERIC		BF mnUniqueKeyIDOffset
cSupplyDemandExists	EV01	char	I/O	VA evt_cSupplyDemandExists
mnPurchasingEffectiveDays	PEFD	MATH_NUMERIC		VA evt_mnF4102PEFD
cProjectPlanning	EV01	char		BF cPO_MultiplantProjectPlanning
cProjectSpecificItem	EV01	char		VA evt_cProjectSpecificItem_EV01
mnSequenceNumber	SEQN	MATH_NUMERIC	I/O	BF mnSequenceNumber

Detail Routine:
Error:

Related Functions
B3401270 Cache, Process MRP Bucketless Dates
B3401290 Cache, Process MRP Item Quantities
B3401300 Cache, Process MRP Inclusion Rules
B4000520 Get Item UoM Conversion Factor
B9800100 Get Audit Information

Related Tables
F3411 MPS/MRP/DRP Message File
F43092 Purchase Order Receipt Routing File
F4311 Purchase Order Detail File

Business Function Documenation: b3400420.rtf
Back To Top

ref43
B3400440 MRPWriteWorkOrderQtyIntoCache (MRP, Write Work ORder Qty Into Cache)

Purpose: This business function will get read the Work Order table (F4801) and Load the Open Quantity Calculated in the Item Quantity Cache in the Primary unit of measure. It will also cache the selected Work Order records in the in the Work Order Cache in the Primary UOM. This function is used to obtain data from the F4801 table for the MRP Planning Program R3482 and R3483. The function will return error codes necessary.
Parameter:

Data Structure: D3400440 - MRP, Write Work Order Qty Into Cache

Parameter Name	Data Item	Data Type	I/O	Others
mnJobNumber	JOBS	MATH_NUMERIC	I	BF mnJobNumber
szComputerId	CTID	char	I	BF szComputerID
mnShortItemNumber	ITM	MATH_NUMERIC	I	BF mnPreviousItemNumber
szBranch	MCU	char	I	VA evt_szF35UI001BusinessUnit
szDisplayUnitOfMeasure	UOM1	char	I	BF szPrimaryUnitOfMeasure
cLeadtimeType	MRPP	char	I	VA evt_cF4102FixedVar_SVMRPP
mnLeadtimeLevel	LTLV	MATH_NUMERIC	I	VA evt_mnCalculatedLeadtime_LTLV
mnLeadtimePerUnit	LTPU	MATH_NUMERIC	I	VA evt_mnF4102LeadtimePU_LTPU
cParentStockingType	STKT	char	I	VA evt_c2ndStockType
mnParentSetupLabor	SETL	MATH_NUMERIC	I	VA evt_mnF4102SetupLabor_SETL
mnParentQueueTime	QUED	MATH_NUMERIC	I	VA evt_mnF4102QueueHrs_QUED
mnParentTimeBasisRate	RATE	MATH_NUMERIC	I	VA evt_mnTimeBasisRATE
cShrinkFactor	SRKF	char	I	VA evt_cF4102ShrinkFactor_SRKF
mnShrinkage	SRNK	MATH_NUMERIC	I	VA evt_cF4102Shrink_SRNK
nMfgSafetyLeadTime	INT02	integer	I	BF nPO_WorkOrderLeadTime
nPurSafetyLeadTime	INT03	integer	I	BF nPO_WorkOrderLeadTime
cProcessFlag	EV02	char	I	VA evt_cProcessItemFlag_PROC
cStockingType	STKT	char	I	VA evt_cF4102SVSTKT
cTransitFlag	EV01	char	I	BF cPO_IncludeTransitFlag
cInspectFlag	EV02	char	I	BF cPO_IncludeInspectionFlag
cOther1Flag	EV03	char	I	BF cPO_IncludeOther1Flag
cOther2Flag	EV04	char	I	BF cPO_IncludeOther2Flag
jdMessageDate	DATE01	JDEDATE	I	VA evt_jdMsgTimeFence_MSGD
jdRegenerationDate	DATE02	JDEDATE	I	VA evt_jdFirstBeginDate_FBEG
cFrozenOrderMsgFlag	EV09	char	I	BF c_MsgType_F
cPastDueOrderMsgFlag	EV10	char	I	BF c_MsgType_T
cWarningMessagesFlag	EV01	char	I	BF c_MsgType_A
cMultiLevelFlag	EV01	char	I	BF c_MultiLevelFlag
mnF3411UniqueID	UKID	MATH_NUMERIC	I/O	BF mnF3411_UniqueID
mnF3412UniqueID	UKID	MATH_NUMERIC	I/O	BF mnF3412_UniqueID
cSuppressErrorMessage	EV07	char	I	1
cReceiptRoutingFlag	EV08	char	I	BF cTS_Q13DSIR
cErrorCode	ERRC	char	O	Not In Use
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI
cWorkOrderFlag	EV09	char	O	VA evt_cTempExistence
cMRPMessageFlag	MRPD	char	I/O	VA evt_cMRPDFlag
cMfgPartsListFlag	EV02	char	I	BF c_MfgPartsListFlag
cNetChangeFlag	EV01	char	I	BF cPO_NetChangeFlag
szProgramID	PID	char	I	VA evt_szProgramID
szFrozenOrderDesc	DSC1	char	I	BF szCO_FrozenOrder
szPastDueOrderDesc	DSC2	char	I	<Blank>
szPartsListDesc	DSC3	char	I	BF szCO_WOMissingPartsList
cDateErrorFlag	EV01	char	I/O	VA evt_cDateErrorFlag
szDateErrorMsgDesc	DSC1	char	I	BF szCO_ShopCalendarNotSetup
mnWorkHours	WRHR	MATH_NUMERIC	I	VA evt_mnWorkHoursPerDay
szStandardUOMConversion	TFLA	char	I	BF szStdUOMConversion
mnStandardPotency	STDP	MATH_NUMERIC	I	VA evt_mnF4102SVSTDP
cPotencyControl	OT1Y	char	I	VA evt_cF4102SVOT1Y
jdBeginDate	EFFF	JDEDATE	I	VA evt_jdBeginDate_BEG
jdLastDate	EFFT	JDEDATE	I	VA evt_jdEndDate_ENDD
jdForecastBeginningDate	DATE04	JDEDATE	I	VA evt_jdForecastBeginDate_FBDT
cForecastConsumptionFlag	EV03	char	I	BF cUseForecastConsumptionLogic
nNumberOfPastDuePeriods	INT01	integer	I	BF cPO_PastDuePeriods
nNumberElementsInCOBYArray	INT02	integer	I/O	VA evt_iNumCoByProducts
szDateBranch	MCU	char	I	VA evt_szDateBranch
cConsolidationMethod	EV01	char	I	BF cPO_ConsolidationMethod
szJobNumberAsString	JOB	char	I	BF szJobNumber
cRoundToWholeFlag	SNS	char	I	BF cRoundToWholeFlag
cActualStockingType	STKT	char	I	VA evt_cF4102SVSTKT
mnUniqueKeyIDOffset	MATH01	MATH_NUMERIC	I	BF mnUniqueKeyIDOffset
cSupplyDemandExist	EV01	char	I/O	VA evt_cSupplyDemandExists
cBOMLoadedFlag	EV01	char	O	VA evt_cBOMLoadedFlag_EV01
mnLotEffectiveDefaultDays	LEDD	MATH_NUMERIC	I	VA evt_mnF4102LEDD
cProjectSpecificItem	EV01	char	I	VA evt_cProjectSpecificItem_EV01
cProjectPlanning	EV01	char	I	BF cPO_MultiplantProjectPlanning
mnSequenceNumber	SEQN	MATH_NUMERIC	I/O	BF mnSequenceNumber

Detail Routine:
Error:

Related Functions
B3400450 MRP, Write Lower Level Pegging Records from BOM
B3400460 MRP, Write Pegging from Parts List
B3401270 Cache, Process MRP Bucketless Dates
B3401280 Cache, Process MRP Co/By Products
B3401290 Cache, Process MRP Item Quantities
B3401300 Cache, Process MRP Inclusion Rules
B3401310 Cache, Process MRP Work Orders
B4000520 Get Item UoM Conversion Factor
B4000920 Get Item Branch Mfg Data
B4001040 Get Item Master Description UOM
B9800100 Get Audit Information

Related Tables
F3111 Work Order Parts List
F3411 MPS/MRP/DRP Message File
F3412 MPS/MRP/DRP Lower Level Requirements File
F34UI005 MRP Orders/Requirements User Index-Process Item
F43092 Purchase Order Receipt Routing File
F4801 Work Order Master File

Business Function Documentation: b3400440.rtf
Back To Top

ref44
B3400470 MRPWritePeggingQtyIntoCache (MRP, Write Pegging Qty Into Cache)

Purpose: This business function will read the Pegging Table (F3412) and Load the Pegging Quantity adjusted by Planning Message data from Message Table (F3411) in the Item Quantity Cache. This function is used to obtain data from the F3412 table for the MRP Planning Program P3482. The function will return error codes necessary.
Parameter:

Data Structure: D3400470 - MRP, Write Pegging Qty Into Cache

Parameter Name	Data Item	Data Type	I/O	Others
mnShortItemNumber	ITM	MATH_NUMERIC	I	BF mnPreviousItemNumber
szBranch	MCU	char	I	VA evt_szF35UI001BusinessUnit
szPrimaryUnitOfMeasure	UOM1	char	I	BF szPrimaryUnitOfMeasure
szWorkOrderStatus	SRST	char	I	BF szPO_WorkOrderStatus
cSuppressErrorMessage	EV01	char	I	1 (Hard Coded)
cErrorCode	ERRC	char		Not In Use
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI
szJobNumberAsString	JOB	char	I	BF szJobNumber
jdLastDate	EFFT	JDEDATE	I	VA evt_jdEndDate_ENDD
szConsolidationBranch	MCU	char	I	BF szPO_ConsolidationBranch
cSupplyDemandExists	EV01	char	I/O	VA evt_cSupplyDemandExists
cExtendRate	EV01	char	I	BF cPOExtendRate
cProjectPlanning	EV01	char	I	BF cPO_MultiplantProjectPlanning
mnSequenceNumber	SEQN	MATH_NUMERIC	I/O	BF mnSequenceNumber
cProjectSpecificItem	EV01	char	I	VA evt_cProjectSpecificItem_EV01

Detail Routine:
Error:

Related Functions
B3401290 Cache, Process MRP Item Quantities
B4000520 Get Item UoM Conversion Factor

Related Tables
F3411 MPS/MRP/DRP Message File
F3412 MPS/MRP/DRP Lower Level Requirements File
F4101 Item Master
F4102 Item Branch File
F4801 Work Order Master File

Business Function Documenation: b3400470.rtf
Back To Top

ref45
B3400480 MRPWritePartsListQtyIntoCache (MRP, Write Parts List Qty Into Cache)

Purpose: This business function will read the Parts List table (F3111) and Load the Parts List Quantity adjusted by Planning Message data from Message Table (F3411) into the Regular Item Qty Cache in the Primary UOM. This function is used to obtain data from the F3111 table for the MRP Planning Program R3482 and R3483. The function will return error codes necessary.
Parameter:

Data Structure: D3400480 - MRP, Write Parts List Qty Into Cache

Parameter Name	Data Item	Data Type	I/O	Others
mnShortItemNumber	ITM	MATH_NUMERIC	I	BF mnPreviousItemNumber
szBranch	MCU	char	I	VA evt_szF35UI001BusinessUnit
jdFromDate	EFFF	JDEDATE	I	VA evt_jdBeginDate_BEG
szDisplayUnitOfMeasure	UOM1	char	I	BF szPrimaryUnitOfMeasure
szWOStatus	SRST	char	I	BF szPO_WorkOrderStatus
nPastDueElements	INT01	integer	I	BF cPO_PastDuePeriods
cWarningMessagesFlag	EV01	char	I	BF c_MsgType_A
mnF3411UniqueID	UKID	MATH_NUMERIC	I/O	BF mnF3411_UniqueID
cMessageFlag	MRPD	char	I/O	VA evt_cMRPDFlag
cSuppressErrorMessage	EV01	char	I/O	"" which is same with '1'
cErrorCode	ERRC	char		Not In Use
szProgramID	PID	char	I	VA evt_szProgramID
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI
szCancelPartsListDesc	DSC1	char	I	BF szCO_CancelPartsList
szDecreasePartsListDesc	DSC2	char	I	BF szCO_DecreasePartsList
szIncreasePartsListDesc	DSC3	char	I	BF szCO_IncreasePartsList
szDeferPartsListQtyDesc	DSC1	char	I	BF szCO_DeferPartsList
szExpeditePartsListQtyDesc	DSC2	char	I	BF szCO_ExpeditePartsList
szStandardUOMConversion	TFLA	char	I	BF szStdUOMConversion
mnStandardPotency	STDP	MATH_NUMERIC	I	VA evt_mnF4102SVSTDP
cPotencyControl	OT1Y	char	I	VA evt_cF4102SVOT1Y
szJobNumberAsString	JOB	char	I	BF szJobNumber
jdLastDate	EFFT	JDEDATE	I	VA evt_jdEndDate_ENDD
jdForecastBeginningDate	DATE04	JDEDATE	I	VA evt_jdForecastBeginDate_FBDT
cForecastConsumptionFlag	EV03	char	I	BF cUseForecastConsumptionLogic
szDateBranch	MCU	char	I	VA evt_szDateBranch
cConsolidationMethod	EV02	char	I	BF cPO_ConsolidationMethod
mnUniqueKeyIDOffset	MATH01	MATH_NUMERIC	I	BF mnUniqueKeyIDOffset
cSupplyDemandExists	EV01	char	I	VA evt_cSupplyDemandExists
cProjectPlanning	EV01	char	I	BF cPO_MultiplantProjectPlanning
mnSequenceNumber	SEQN	MATH_NUMERIC	I/O	BF mnSequenceNumber
cProjectSpecificItem	EV01	char	I	VA evt_cProjectSpecificItem_EV01

Detail Routine:
Error:

Related Functions
B3401270 Cache, Process MRP Bucketless Dates
B3401290 Cache, Process MRP Item Quantities
B3401300 Cache, Process MRP Inclusion Rules
B4000520 Get Item UoM Conversion Factor
B9800100 Get Audit Information
B9800420 Get Data Dictionary Definition

Related Tables
F3111 Work Order Parts List
F3411 MPS/MRP/DRP Message File
F4101 Item Master
F4102 Item Branch File
F4801 Work Order Master File

Business Function Documenation: b3400480.rtf
Back To Top

ref46

B3500010 MRPWriteSupplyQuantitiesFromPL (MRP, Write Supply Quantities from Parts List)

Purpose: This function should ONLY be used by R3483. It will read F3411 records by Item and Supply Branch(MMMMCU), calculate the Other Branch Demand quantity and write the quantity to the Quantities Cache. If Consolidation methods,

'1' then Write Supply Qtys.
'2' then, Calculate Supply Qtys due to Co or By Products. This function will read F3411 records by Item and Supply Branch, calculate the Other Branch Demand quantity and write the quantity to the Quantities Cache.

Parameter:

Data Structure: D3500010 - MRP, Write Supply Quantities from Parts List

Parameter Name	Data Item	Data Type	I/O	Others
mnItemNumber	ITM	MATH_NUMERIC	I	BF mnPreviousItemNumber
szBranch	MCU	char	I	VA evt_szF35UI001BusinessUnit
jdBeginningDate	DATE01	JDEDATE	I	VA evt_jdBeginDate_BEG
jdEndingDate	DATE02	JDEDATE	I	VA evt_jdEndDate_ENDD
nNumberOfPastDueDates	INT01	integer	I	BF cPO_PastDuePeriods
szPrimaryUOM	UOM	char	I	BF szPrimaryUnitOfMeasure
cPotencyControl	OT1Y	char	I	VA evt_cF4102SVOT1Y
cInReceiptRoutingFlag	EV01	char	I	BF cTS_Q13DSIR
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI
cSuppressErrors	EV01	char	I	1
szJobNumber	JOB	char	I	BF szJobNumber
cErrorCode	ERRC	char		Not In Use
cProcessWOFlag	EV01	char	O	(Method 1) Not In Use (Method 2) VA evt_cProcessOrder_WDFLG
cTransitFlag	EV01	char	I	BF cPO_IncludeTransitFlag
cInspectFlag	EV01	char	I	BF cPO_IncludeInspectionFlag
cOther1Flag	EV01	char	I	BF cPO_IncludeOther1Flag
cOther2Flag	EV01	char	I	BF cPO_IncludeOther2Flag
cConsolidationMethod	EV01	char	I	BF cPO_ConsolidationMethod * 1 or 2 (Refer Processing Option - Consolidation Method)
szConsolidationBranch	MCU	char	I	BF szPO_ConsolidationBranch
szStdUOMConversion	TFLA	char	I	BF szStdUOMConversion
mnStandardPotency	STDP	MATH_NUMERIC	I	VA evt_mnF4102SVSTDP

Detail Routine:
Error:

Related Functions
B3401290 Cache, Process MRP Item Quantities
B3401300 Cache, Process MRP Inclusion Rules
B3401310 Cache, Process MRP Work Orders
B4000520 Get Item UoM Conversion Factor

Related Tables
F3111 Work Order Parts List
F43092 Purchase Order Receipt Routing File
F4801 Work Order Master File

Business Function Documentation: b3500010.rtf
Back To Top

ref47
B3401730 MRPProcessConfiguredComponent (MRP, Process Configured Component)

Purpose: Load Configured Component Qty into cache.
Parameter:

Data Structure: D3401730 - MRP, Process Configured Component

Parameter Name	Data Item	Data Type	I/O	Others
mnShortItemNumber	ITM	MATH_NUMERIC	I	BF mnPreviousItemNumber
szBranch	MCU	char	I	VA evt_szF35UI001BusinessUnit
szDisplayUnitOfMeasure	UOM1	char		Not In Use
cErrorCode	ERRC	char		Not In Use
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI
szJobNumberAsString	JOB	char	I	BF szJobNumber
szDateBranch	MCU	char	I	VA evt_szDateBranch
cSupplyDemandExists	EV01	char	I/O	VA evt_cSupplyDemandExists
cSuppressErrorMessage	EV01	char	I	1
szProgramId	PID	char		Not In Use
mnF3411UniqueID	UKID	MATH_NUMERIC		Not In Use
mnUniqueKeyIDOffset	MATH01	MATH_NUMERIC		Not In Use
cConsolidationMethod	EV02	char	I	BF cPO_ConsolidationMethod
jdFirstDate	DATE01	JDEDATE		Not In Use
jdLastDate	DATE01	JDEDATE	I	VA evt_jdEndDate_ENDD

Detail Routine:
Error:

Related Functions
B3401730 MRP, Process Configured Component

ref48
B3401400 MRPWriteRateQtyIntoCache (MRP, Write Rate Qty Into Cache)

Purpose: Load Rate Schedule Qty into Cache.
Parameter:

Data Structure: D3401400 - MRP, Write Rate Qty Into Cache

Parameter Name	Data Item	Data Type	I/O	Others
mnJobnumberA	JOBS	MATH_NUMERIC	I	BF mnJobNumber
szComputerID	CTID	char	I	BF szComputerID
mnShortItemNumber	ITM	MATH_NUMERIC	I	BF mnPreviousItemNumber
szBranch	MCU	char	I	VA evt_szF35UI001BusinessUnit
szDisplayUnitOfMeasure	UOM1	char	I	BF szPrimaryUnitOfMeasure
jdMessageDate	DATE01	JDEDATE	I	VA evt_jdMsgTimeFence_MSGD
jdRegenerationDate	DATE02	JDEDATE	I	BF jdRegenerationDateRGNJ
cPastDueOrderMsgFlag	EV10	char	I	BF c_MsgType_T
cMultiLevelFlag	EV01	char	I	BF c_MultiLevelFlag
mnF3411UniqueID	UKID	MATH_NUMERIC	I/O	BF mnF3411_UniqueID
mnF3412UniqueID	UKID	MATH_NUMERIC	I/O	BF mnF3412_UniqueID
cSuppressErrorMsg	EV07	char	I	1
cErrorCode	ERRC	char		Not In Use
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI
cMRPMessageFlag	MRPD	char	I	VA evt_cMRPDFlag
cNetChangeFlag	EV01	char	I	BF cPO_NetChangeFlag
szProgramId	PID	char	I	VA evt_szProgramID
szPastDueOrderDesc	DSC2	char	I	<Blank>
szStandardUOMConversion	TFLA	char	I	BF szStdUOMConversion
mnStandardPotency	STDP	MATH_NUMERIC	I	VA evt_mnF4102SVSTDP
cPotencyControl	OT1Y	char	I	VA evt_cF4102SVOT1Y
jdBeginDate	EFFF	JDEDATE	I	VA evt_jdBeginDate_BEG
jdLastDate	EFFT	JDEDATE	I	VA evt_jdEndDate_ENDD
nNumberOfPastDuePeriods	INT01	integer	I	BF cPO_PastDuePeriods
nNumberElementsinCOBYArray	INT02	integer	I	VA evt_iNumCoByProducts
szDateBranch	MCU	char	I	VA evt_szDateBranch
cConsolidationMethod	EV01	char	I	BF cPO_ConsolidationMethod
szJobNumberAsString	JOB	char	I	BF szJobNumber
cRoundToWholeFlag	SNS	char	I	BF cRoundToWholeFlag
szRateOrderType	DCTO	char	I	BF szPO_RateOrderType
cProcessItem	EV01	char	I	VA evt_cProcessItemFlag_PROC
nNumBucketlessDates	INT01	integer	I	VA evt_iNumBucketlessDates
szRateStatusCode	SRST	char	I	BF szPO_StatusCodeRate
mnUniqueKeyIDOffset	MATH01	MATH_NUMERIC	I	BF mnUniqueKeyIDOffset
cSupplyDemandExists	EV01	char	I/O	VA evt_cSupplyDemandExists
cDateErrorFlag	EV01	char	I/O	VA evt_cDateErrorFlag
szDateErrorMsgDesc	DSC1	char	I	BF szCO_ShopCalendarNotSetup
cShrinkFactor	SRKF	char	I	VA evt_cF4102ShrinkFactor_SRKF
mnShrinkage	SRNK	MATH_NUMERIC	I	VA evt_cF4102Shrink_SRNK
cBOMLoadedFlag	EV01	char	I/O	VA evt_cBOMLoadedFlag_EV01
cLeadTimeType	MRPP	char	I	VA evt_cF4102FixedVar_SVMRPP
mnLeadtimeLevel	LTLV	MATH_NUMERIC	I	VA evt_mnCalculatedLeadtime_LTLV
mnLeadtimePerUnit	LTPU	MATH_NUMERIC	I	VA evt_mnF4102LeadtimePU_LTPU
mnParentSetupLabor	SETL	MATH_NUMERIC	I	VA evt_mnF4102SetupLabor_SETL
mnParentQueueTime	QUED	MATH_NUMERIC	I	VA evt_mnF4102QueueHrs_QUED
mnParentTimeBasisRate	RATE	MATH_NUMERIC	I	VA evt_mnTimeBasisRATE
nMfgSafetyLeadTime	INT02	integer	I	BF nPO_WorkOrderLeadTime
mnWorkHours	WRHR	MATH_NUMERIC	I	VA evt_mnWorkHoursPerDay
cPastDueRatesFlag	EV01	char	I	BF cPastDueRatesFlag

Detail Routine:
Error:

Related Functions
B3401270 Cache, Process MRP Bucketless Dates
B3401280 Cache, Process MRP Co/By Products
B3401290 Cache, Process MRP Item Quantities
B4000520 Get Item UoM Conversion Factor
B4000920 Get Item Branch Mfg Data
B4001040 Get Item Master Description UOM
B9800100 Get Audit Information
X4801T F4801T Get Work Order Master Tag Record

Related Tables
F3111 Work Order Parts List
F3411 MPS/MRP/DRP Message File
F34UI005 MRP Orders/Requirements User Index-Process Item
F4801 Work Order Master File

Below business functions are not called by R3483 directly but are to be utilized from multiple business functions listed above.
Additional Business Functions:

Source	BSFN	Table Reference	Purpose	Others
B3500040 #ref50	MRPCalculateAvailableTransferQty (MRP, Calculate Available Transfer Qty from Cache)

Ref49 (additional)
B3400500 - MRPCalculatePlanAndScheduleOrder (MRP, Calculate, Plan and Schedule Orders)

Purpose:
Parameter:

Data Structure: D3400500 - MRP, Calculate, Plan and Schedule Orders

Parameter Name	Data Item	Data Type	I/O	Others
mnJobNumber	JOBS	MATH_NUMERIC		BF mnJobNumber
szComputerID	CTID	char		BF szComputerID
szBranch	MCU	char		VA evt_szF35UI001BusinessUnit
mnShortItemNumber	ITM	MATH_NUMERIC		BF mnPreviousItemNumber
cLeadTimeType	MRPP	char		VA evt_cF4102FixedVar_SVMRPP
mnLeadTimeLevel	LTLV	MATH_NUMERIC		VA evt_mnCalculatedLeadtime_LTLV
mnLeadTimePerUnit	LTPU	MATH_NUMERIC		VA evt_mnF4102LeadtimePU_LTPU
cStockingType	STKT	char		VA evt_cF4102SVSTKT
mnSetupLaborHours	SETL	MATH_NUMERIC		VA evt_mnF4102SetupLabor_SETL
mnQueueHours	QUED	MATH_NUMERIC		VA evt_mnF4102QueueHrs_QUED
c2ndStockingType	STKT	char		VA evt_c2ndStockType
cPlanningCode	MPST	char		VA evt_cF4102SVMPST
cOrderPolicyCode	OPC	char		VA evt_cF4102_SVOPC
mnOrderPolicyValue	OPV	MATH_NUMERIC		VA evt_mnF4102_SVOPV
mnMinOrderQuantity	RQMN	MATH_NUMERIC		VA evt_mnF4102RQMN
mnTimeBasisRate	RATE	MATH_NUMERIC		VA evt_mnTimeBasisRATE
cShrinkFactor	SRKF	char		VA evt_cF4102ShrinkFactor_SRKF
mnShrinkage	SRNK	MATH_NUMERIC		VA evt_cF4102Shrink_SRNK
mnQtyOrderMultiples	MULT	MATH_NUMERIC		VA evt_mnF4102_MULT
mnWorkHoursPerDay	WRHR	MATH_NUMERIC		VA evt_mnWorkHoursPerDay
szPrimaryUOM	UOM1	char		BF szPrimaryUnitOfMeasure
cPhantomFlag	EV01	char		BF cPO_PhantomDataFlag
cWarningMsgFlag	EV02	char		BF c_MsgType_A
cDecreaseMsgFlag	EV03	char		BF c_MsgType_L
cIncreaseMsgFlag	EV04	char		BF c_MsgType_G
szLeadTimeZeroMsgDesc	DSC1	char		BF szCO_LeadtimeZero
szDecreaseFPOMsgDesc	DSC1	char		BF szCO_DecreaseFPO
szCancelFPOMsgDesc	DSC1	char		BF szCO_CancelFPO
szDeferInDamperMsgDesc	DSC1	char		BF szCO_DeferWithinDamper
szDeferFPOMsgDesc	DSC1	char		BF szCO_DeferFPO
cLotExpirationFlag	EV03	char		BF cPO_LotExpirationFlag
cWorkOrderFlag	EV04	char		VA evt_cWOExists
cPurchOrderFlag	EV05	char		VA evt_cPOExists
cGenerationType	EV06	char		BF cPO_GenerationType
jdFrozenDate	DATE01	JDEDATE		VA evt_jdFreezeTimeFence_FRDT
jdMessageDate	DATE02	JDEDATE		VA evt_jdMsgTimeFence_MSGD
szWorkOrderStatus	SRST	char		BF szPO_WorkOrderStatus
mnDeferDamperDays	DEFD	MATH_NUMERIC		BF mnPO_DeferDamperDays
mnExpediteDamperDays	EXPD	MATH_NUMERIC		BF mnPO_ExpediteDamperDays
iMfgSafetyLeadTime	INT02	integer		BF nPO_WorkOrderLeadTime
iPurchSafetyLeadTime	INT03	integer		BF nPO_PurchOrderLeadTime
iNumBucketlessDates	INT01	integer		VA evt_iNumBucketlessDates
iNumBucketDates	INT02	integer		VA evt_iNumBucketDates
cSuppressErrorMessage	EV01	char		1
cErrorCode	ERRC	char		Not In Use
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI
mnF3411UniqueID	UKID	MATH_NUMERIC	I/O	BF mnF3411_UniqueID
cMRPMessageFlag	MRPD	char	I/O	VA evt_cMRPDFlag
szProgramID	PID	char		VA evt_szProgramID
jdStartDate	DATE01	JDEDATE		VA evt_jdFirstDate_FIRST
jdBeginningDate	DATE02	JDEDATE		VA evt_jdBeginDate_BEG
jdEndDate	DATE03	JDEDATE		VA evt_jdEndDate_ENDD
szExpediteInDamperMsgDesc	DSC1	char		BF szCO_ExpediteWithinDamper
szExpediteFPOMsgDesc	DSC1	char		BF szCO_ExpediteFPO
szIncreaseFPOMsgDesc	DSC1	char		BF szCO_IncreaseFPO
mnFromPotency	FRMP	MATH_NUMERIC		VA evt_mnF4102FRMP
mnThruPotency	THRP	MATH_NUMERIC		VA evt_mnF4102THRP
szFromGrade	FRGD	char		VA evt_szF4102FRGD
szThruGrade	THGD	char		VA evt_szF4102THGD
mnVendorNumber	VEND	MATH_NUMERIC		VA evt_mnF4102VEND
szPlanQtyExceedsMOQMsgDesc	DSC1	char		BF szCO_PlanOrderExceedsMOQ
szPlanQtyExceedsFOQMsgDesc	DSC1	char		BF szCO_PlanOrderExceedsFOQ
szLotExpiredMsgDesc	DSC1	char		BF szCO_LotQuantityExpired
szPurchOrderDocType	DCTO	char		BF szPO_PurchOrderType
szWorkOrderDocType	DCTO	char		BF szPO_WorkOrderType
mnMaxOrderQuantity	RQMX	MATH_NUMERIC		VA evt_mnF4102RQMX
cProcessFlag	EV05	char		VA evt_cProcessItemFlag_PROC
cStockNonStockFlag*	SNS	char		BF cRoundToWholeFlag
cCostLevel	CLEV	char		BF cInvCostLevel
mnF3412UniqueID	UKID	MATH_NUMERIC	I/O	BF mnF3412_UniqueID
mnSafetyStocks	SAFE	MATH_NUMERIC		VA evt_mnF4102SAFE
cMultiLevelFlag	EV02	char		BF c_MultiLevelFlag
szReqStartBeforeStartMsgDesc	DSC1	char		BF szCO_RequiredStartBefore
szManualAdjustNecessaryMsgDesc	DSC1	char		BF szCO_ManualAdjustment
cDateErrorFlag	EV01	char	I/O	VA evt_cDateErrorFlag
szDateErrorMsgDesc	DSC1	char		BF szCO_ShopCalendarNotSetup
szStandardUOMConversion	TFLA	char		BF szStdUOMConversion
mnStandardPotency	STDP	MATH_NUMERIC		VA evt_mnF4102SVSTDP
cPotencyControl	OT1Y	char		VA evt_cF4102SVOT1Y
szJobNumberAsString	JOB	char		BF szJobNumber
cCoByProductFlag	EV01	char		VA evt_cCoByitemFlag_COBY
cConsolidationMethod	EV01	char		BF cPO_ConsolidationMethod
cMakeMfgItemsInOrigin	EV01	char		BF cPO_MakeMfgItemsInOrigin
cProcessEachBranch	EV02	char		BF cPO_ProcessEachBranch
szTransferDocType	DCTO	char		BF szPO_TransferOrderType
szDateBranch	MCU	char		VA evt_szDateBranch
cForecastConsumptionFlag	EV02	char		BF cUseForecastConsumptionLogic
cReplanFlag	EV01	char		<Blank>
szCategoryCode	PRPX	char		VA evt_szCategoryCode_PRPX
mnReorderQuantity	ROQI	MATH_NUMERIC		VA evt_mnF4102ReorderQty_ROQI
szRateOrderType	DCTO	char		BF szPO_RateOrderType
cMnWkDyHr	MWDH	char		VA evt_cMonthWeekDay_MWDH
cExtendRate	EV01	char		BF cPOExtendRate
mnUniqueKeyIDOffset	MATH01	MATH_NUMERIC		BF mnUniqueKeyIDOffset
mnLotEffectiveDefaultDays	LEDD	MATH_NUMERIC		VA evt_mnLotEffectiveDefaultDays
mnPurchasingEffectiveDays	PEFD	MATH_NUMERIC		VA evt_mnPurchasingEffectiveDays
cProjectPlanning	EV01	char		BF cPO_MultiplantProjectPlanning
cProjectSpecificItem	EV01	char		VA evt_cProjectSpecificItem_EV01
szProjectManualPurchaseOrd	DSC1	char		BF szCO_ManualOPExist

Detail Routine:
Error:
Business Function Documenation: b3400500.rtf
Back To Top

ref50
B3500040 - MRPCalculateAvailableTransferQty (MRP, Calculate Available Transfer Qty from Cache)

Purpose:
Parameter:

Data Structure: D3500040 - MRP, Calculate Available Transfer Qty from Cache

Parameter Name	Data Item	Data Type
jdSupplyDate	DRQJ	JDEDATE
cIncludeLotExpiredQtys	EV01	char
szSupplyBranch	MMCU	char
mnQtyAvailBeforeLotExpired	MATH01	MATH_NUMERIC
mnQtyAvailAfterLotExpired	MATH02	MATH_NUMERIC
cErrorCode	ERRC	char
cSuppressErrorMessage	SUPPS	char
szErrorMessageID	DTAI	char
szJobNumber	JOB	char
mnJobNumber	JOBS	MATH_NUMERIC
szComputerID	CTID	char

Detail Routine:
Error:
Business Function Documenation: b3500040.rtf

ref51
B3500080 - MRPWriteCoByProductTranferQty (MRP, Write CoBy Product Transfer Qty)

Purpose: Calculate Transfer Qtys. This Business function will write Planned Orders due to transfers for co or by products prior to calling B3400500. This function can only be called if the item is a co or by product and the consolidation method used is '2'.
Parameter:

Data Structure: D3500080 - MRP, Write CoBy Product Transfer Quantity

Parameter Name	Data Item	Data Type	I/O	Others
szJobNumber	JOB	char		BF szJobNumber
szBranch	MCU	char		VA evt_szF35UI001BusinessUnit
mnShortItemNumber	ITM	MATH_NUMERIC		BF mnPreviousItemNumber
cLeadtimeType	MRPP	char		VA evt_cF4102FixedVar_SVMRPP
mnLeadtimeLevel	LTLV	MATH_NUMERIC		VA evt_mnCalculatedLeadtime_LTLV
mnLeadtimePerUnit	LTPU	MATH_NUMERIC		VA evt_mnF4102LeadtimePU_LTPU
c2ndStockType	STKT	char		VA evt_c2ndStockType
cPlanningCode	MPST	char		VA evt_cF4102SVMPST
mnFromPotency	FRMP	MATH_NUMERIC		VA evt_mnF4102FRMP
mnThruPotency	THRP	MATH_NUMERIC		VA evt_mnF4102THRP
szFromGrade	FRGD	char		VA evt_szF4102FRGD
szThruGrade	THGD	char		VA evt_szF4102THGD
mnVendorNumber	VEND	MATH_NUMERIC		VA evt_mnF4102VEND
mnWorkHourPerDay	WRHR	MATH_NUMERIC		VA evt_mnWorkHoursPerDay
szUnitOfMeasurePrimary	UOM1	char		BF szPrimaryUnitOfMeasure
cRoundingFlag	SNS	char		BF cRoundToWholeFlag
cCostLevel	CLEV	char		BF cInvCostLevel
szDateErrorMsg	DSC1	char		BF szCO_ShopCalendarNotSetup
cWorkOrderFlag	EV04	char		VA evt_cWOExists
cPurchOrderFlag	EV04	char		VA evt_cPOExists
cProcessOrderExistFlag	EV04	char		VA evt_cProcessOrder_WDFLG
jdFrozenDate	DATE01	JDEDATE		VA evt_jdFreezeTimeFence_FRDT
jdMessageDate	DATE01	JDEDATE		VA evt_jdMsgTimeFence_MSGD
jdBeginningDate	DATE01	JDEDATE		VA evt_jdBeginDate_BEG
jdStartDate	DATE01	JDEDATE		VA evt_jdFirstDate_FIRST
jdEndDate	DATE01	JDEDATE		VA evt_jdEndDate_ENDD
cDateErrorFlag	EV01	char		VA evt_cDateErrorFlag
cLotExpirationFlag	EV01	char		BF cPO_LotExpirationFlag
cGenerationType	EV01	char		BF cPO_GenerationType
nMfgSafetyLeadtime	INT01	integer		BF nPO_WorkOrderLeadTime
nPurcSafetyLeadtime	INT01	integer		BF nPO_PurchOrderLeadTime
szPurchOrderDocType	DCTO	char		BF szPO_PurchOrderType
szWorkOrderDocType	DCTO	char		BF szPO_WorkOrderType
nNumberOfBuckelessDates	INT01	integer		VA evt_iNumBucketlessDates
cSuppressErrorMessages	EV01	char		1
cErrorCode	ERRC	char		Not In Use
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI
mnF3411UniqueID	UKID	MATH_NUMERIC	I/O	BF mnF3411_UniqueID
mnF3412UniqueID	UKID	MATH_NUMERIC	I/O	BF mnF3412_UniqueID
szProgramID	PID	char		VA evt_szProgramID
cMakeMfgItemsInOrigin	EV01	char		BF cPO_MakeMfgItemsInOrigin
cProcessEachBranch	EV01	char		BF cPO_ProcessEachBranch
szTransferOrderDocType	DCTO	char		BF szPO_TransferOrderType
szStdUOMConversion	TFLA	char		BF szStdUOMConversion
mnStandardPotency	STDP	MATH_NUMERIC		VA evt_mnF4102SVSTDP
cPotencyControl	OT1Y	char		VA evt_cF4102SVOT1
szDateBranch	MCU	char		VA evt_szDateBranch
szCategoryCode	PRPX	char		VA evt_szCategoryCode_PRPX
mnJobNumber	JOBS	MATH_NUMERIC		BF mnJobNumber
szComputerID	CTID	char		BF szComputerID
cUseForecastConsumption	EV01	char		BF cUseForecastConsumptionLogic
mnUniqueKeyIDOffset	MATH01	MATH_NUMERIC		BF mnUniqueKeyIDOffset
cSupplyDemandExists	EV01	char	I/O	VA evt_cSupplyDemandExists

Detail Routine:
Error:
Related Functions
B3400540 MRP, Calculate Schedule Dates for Planning
B3401270 Cache, Process MRP Bucketless Dates
B3401280 Cache, Process MRP Co/By Products
B3401290 Cache, Process MRP Item Quantities
B3401300 Cache, Process MRP Inclusion Rules
B3401310 Cache, Process MRP Work Orders
B3401320 Cache, Process MRP Purchase Orders
B3500030 MRP, Get Supply Branch
B3500040 MRP, Calculate Available Transfer Qty from Cache
B4000520 Get Item UoM Conversion Factor
B9800100 Get Audit Information
B9800420 Get Data Dictionary Definition

Related Tables
F3002 Bill of Material Master File
F3111 Work Order Parts List
F3411 MPS/MRP/DRP Message File
F35UI001 MPS/MRP Planning - Multiple Plant User Index
Business Function Documentation: b3500080.rtf

Purpose: Load Bill of Material into cache.
Parameter:

Data Structure: D3401550 - MRP,Load BOM Cache

Parameter Name	Data Item	Data Type	Others
mnIdentifierShortItem	ITM	MATH_NUMERIC	BF mnPreviousItemNumber
szCostCenter	MCU	char	VA evt_szF4102Branch
szTypeBill	TBM	char	M
szJobNumber	JOB	char	BF szJobNumber
cSuppressErrorMessage	EV01	char	1
cErrorCode	ERRC	char	Not In Use
szErrorMessageID	DTAI	char	Not In Use

Detail Routine:
Error:
Related Functions
B3401530 Cache, Process MRP Bill of Material
B3401540 Cache, Process MRP Batch Bills

Related Tables
F3002 Bill of Material Master File
Business Function Documentation: N/A

ref53

B3500050 - MRPMultiPlantCopyCacheDataToUI (MRP, Multi-Plant Copy Cache Data to F34UI005)

Purpose: This function will read all records in the regular item qty cache and copy the data into F34UI005. This is done so that B3400590 will be able to read data from F34UI005 and write time series records for co or by products.
Parameter:

Data Structure: D3500050 - MRP, Multi-Plant Copy Cache Data to F34UI005

Parameter Name	Data Item	Data Type	I/O	Others
mnJobNumber	JOBS	MATH_NUMERIC		BF mnJobNumber
szComputerID	CTID	char		BF szComputerID
mnItemNumber	ITM	MATH_NUMERIC		BF mnPreviousItemNumber
cErrorCode	ERRC	char		Not In Use
cSuppressErrors	EV01	char		1
szJobNumberAsString	JOB	char		BF szJobNumber
szBranch	MCU	char		VA evt_szF35UI001BusinessUnit
jdPlanningDate	DATE01	JDEDATE		VA evt_jdPlanningTimeFence_PLDT
mnSafetyStock	SAFE	MATH_NUMERIC		VA evt_mnF4102SAFE
szErrorMessageID	DTAI	char	O	VA evt_szErrorMsgID_DTAI

Detail Routine:
Error:
Related Functions
B3401290 Cache, Process MRP Item Quantities

Related Tables
F34UI005 MRP Orders/Requirements User Index-Process Item
Business Function Documentation: b3500050.rtf

#ref51 *** No reference?
B3401350 - VerifySupplierPercentages (Verify Supplier Percentges)

Purpose: This function will use cache to Verify that the sum of the Percentages of the suppliers at any given date is equal to 100, otherwise it will return an error. This function creates two caches Percent cache and total cache. The function appends the input Job Number string to the two character ID 'JD' and 'AN8' to build the two cache names used for the calling application.
Parameter:

Data Structure: D3401350 - Verify Supplier Percentages

Parameter Name	Data Item	Data Type	Others
mnAddressNumber *	AN8	MATH_NUMERIC	Percent Cache Key
mnSplitpercentage	VSPC	MATH_NUMERIC	Percent Cache elemement
jdEffectiveFromDate *	EFFF	JDEDATE	Percent Cache Key
jdEffectiveThruDate	EFFT	JDEDATE	Percent Cache Elemement
cErrorSuccessMessage	EV01	char
nNumberOfKeys	INT01	integer
cActionCode	EV01	char
szJobNumber	JOB	char
mnTotalPercentage	TOTOW	MATH_NUMERIC

Detail Routine:
Error:
Business Function Documenation: b3401350.rtf
Back To Top

Cache Acton Code in B3401350 - VerifySupplierPercentages (Verify Supplier Percentages)

Value	Cache Action	Others
D	CACHE_DELETE
A	CACHE_ADD	Add a new element to the cache with the input data values
T	CACHE_TERMINATE
t	CACHE_TERMINATE2
V	CACHE_VERIFY_PERCENT

Returns for B3401350 - VerifySupplierPercentages (Verify Supplier Percentages)

Value	Cache Action
0	PERCENT_SUCCESS
1	PERCENT_ERROR
2	CACHE_ERROR

updated on Mar-12-2013 but need remaining as internal:

MPS Set Net Change Flag MPS Set Net Change Flag R3484 - MPS Set Net Change Flag Net Change Flag MPS Set Net Change Flag MPS Set Net Change Flag