UpdateCumYieldAndScrapPercent

Update Cumulative Yield and Scrap Percent

Major Business Rule

Object Name: B3000360

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
Update the Cumulative Yield Percent in the Routing Master Table (F3003) and Update the Scrap Percent
in the Bill  of Material Table (F3002).

2.Technical Specifications
2.4Processing
Edits:

1.0.  Initialize work fields
WF Cumulative Yield Percent = 100.
WF Scrap Percent = 0

2.0.  If As of Date is equal to 0, NULL or blank or *, use todays date instead of the As of Date.

3.0. Process all Routing Master (F3003) records where the MMCU, KIT, TRT, and BQTY are equal to the
values entered in the data structure.

3.1. Retrieve the from the Routing Master Table (F3003) where MMCU, KIT, TRT, and BQTY are equal
to the values passed in the data structure. Read by descending Operation Sequence Number. Index:
P Branch, P Item, +A.

Retrieve the following columns:
OPYP -  Operation Yield Percent
EFFF     -  Effective From
EFFT     -  Effective Thru

3.2. If the As of Date is not within the Effective From and Effective Thru Date, process the next
F3003 record. (return to step 3.1).

3.3. Update the cumulative yield percent and scrap percent on the Routing Master Record.

3.3.1. Calculate the Cumulative Yield Percent.

WF Cumulative Yield Percent = WF Cumulative Yield Percent * TB Operation Yield Percent
WF Cumulative Yield Percent = WF Cumulative Yield Percent / 100.

3.3.2. Update the Cumulative Yield Percent in the Routing Master Row that was retrieved.

3.4 Calculate the Scrap Percent.

3.4.1. If WF Cumulative Yield Percent is equal to 0, then WF Scrap Percent = 0.
3.4.2. If WF Cumulative Yield Percent is not equal to 0, calculate Scrap Percent as:

WF Scrap Percent = 100 / WF Cumulative Yield Percent.
WF Scrap Percent = WF Scrap Percent - 1
WF Scrap Percent = WF Scrap Percent * 100

3.5.  Update Scrap Percent in the Bill of Material Table until all Bill of Material Component
Items with the same operation sequence are updated.  (where COBY=blank, KIT=DS Parent Item, MMCU=DS
Parent Branch, TBM=DS Routing Type, BQTY=DS Batch Quantity, and OPSQ= DS Operation Sequence).

3.5.1. Retrieve the Bill of Material Table (F3002) using index: CoByProduct, Parent Item, +A
where COBY = blank, KIT= DS Parent Item, MMCU = DS Parent Branch, TBM = DS Routing Type, BQTY
= DS Batch Quantity, and OPSQ = DS Operation Sequence.

3.5.2. Update both the Cumulative Yield Percent and the Scrap Percent in the BOM Table.

CPYP = WF Cumulative Yield Percent
STPP = WF Scrap Percent

3.6. Update Scrap Percent in the Bill of Material Table until all Bill of Material Intermediate
Items with the same operation sequence are updated. (where COBY='I', KIT=DS Parent Item, MMCU=DS
Parent Branch, TBM=DS Routing Type, BQTY=DS Batch Quantity, and OPSQ= DS Operation Sequence).

3.6.1. Retrieve the Bill of Material Table (F3002) using index: CoByProduct, Parent Item, +A
where COBY = 'I', KIT= DS Parent Item, MMCU = DS Parent Branch, TBM = DS Routing Type, BQTY =
DS Batch Quantity, and OPSQ = DS Operation Sequence.

3.6.2. Update both the Cumulative Yield Percent and the Scrap Percent in the BOM Table.

CPYP = WF Cumulative Yield Percent
STPP = WF Scrap Percent

^

Data Structure

D3000360 - Update Cumulative Yield and Scrap Percent

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szParentBranch	MMCU	char	NONE	NONE
A code that represents a high-level business unit. Use this code to refer to a branch or plant that might have departments or jobs, which represent lower-level business units, subordinate to it. For example: o Branch/Plant (MMCU) o Dept A (MCU) o Dept B (MCU) o Job 123 (MCU) Business unit security is based on the higher-level business unit.
mnParentItem	KIT	MATH_NUMERIC	NONE	NONE
The system provides for three separate item numbers. 1. Item Number (short) - An eight-digit, computer assigned, completely non-significant item number. 2. 2nd Item Number - The 25-digit, free form, user defined alphanumeric item number. 3. 3rd Item Number - Another 25-digit, free form, user defined alphanumeric item number.
szRoutingType	TRT	char	NONE	NONE
A user defined code (40/TR) that indicates the type of routing. You can define different types of routing instructions for different uses. For example: M Standard Manufacturing Routing RWK Rework Routing RSH Rush Routing You define the routing type on the work order header. The system then uses the specific type of routing that you define in the work order routing. Product Costing and Capacity Planning systems use only M type routings.
mnBatchQuantity	BQTY	MATH_NUMERIC	NONE	NONE
The quantity of finished units that you expect this bill of material or routing to produce. You can specify varying quantities of components based on the amount of finished goods produced. For example, 1 ounce of solvent is required per unit up to 100 units of finished product. However, if 200 units of finished product is produced, 2 ounces of solvent are required per finished unit. In this example, you would set up batch quantities for 100 and 200 units of finished product, specifying the proper amount of solvent per unit.
jdAsOfDate	ASDE1	JDEDATE	NONE	NONE
The date used for effectivity checking. Enter a specific date to display documents (orders, bills of material, routings, as applicable) that are effective on or after that date. The current system date is the default, but you can enter any future or past date.

Related Functions

B9800420 Get Data Dictionary Definition

Related Tables

F3002 Bill of Material Master File
F3003 Routing Master File
F3009 Job Shop Manufacturing Constants
F4104 Item Cross Reference File