ConfiguratorCostRouting

Configurator Cost Routing

Major Business Rule

Object Name: B3200490

Parent DLL: CMFG

Location: Client/Server

Language: C

1.Functional Description

1.1Purpose
This function will save detail record , item summary and top item summary records in B3200400, also accumulate the cost for a configured routing
(optional for B9).

1.2Setup Notes and Prerequisites
No special setup for this function.

1.3Special Logic
There is no special logic within this function.

2.Technical Specifications

2.1Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes KITParent Item NumberIY MCUBranch/PlantIY ITMComponent Item
NumberIY CMCUComponent Branch/PlantIY UORGQuantityIY OPSQOperation SequenceIN STRTStart
DateIY MATH01MultiplierIY ECSTCostOY JOBSJobNumberIY CFGIDConfigurationIDIY CFGCIDComponentIDIY
2.2Related Tables
Table Table Description F3003Routing Master file

2.3Related Business Functions
Source NameFunction Name B3000230Calculate Quantity with Shrink X0005Get UDC B3100460CalculateWOHoursAndCost

2.4Processing

ECST = 0
CQTY = UORG

Use BF Get Next Routing to retrieve record(s) (*)

If OPSQ GT Zero,
•

Read one Routing (F3112) record using ITM, CMCU, TRT = 'M', BQTY = Zero, and OPSQ
•

•

•
• else
• •
Read all Routing (F3112) records using ITM, CMCU, TRT = 'M', and BQTY = Zero
•
•

•
• Process each record  if  STRT falls between EFFF and EFFT, and If OPSC = blank or = 'T'
•
•
•
Call B3000230 Calculate Quantity with Shrink passing  KIT, MCU, and UORG (*)
•
•
to calculate  Quantity with Shrink in CQTY
•
•
• •
Apply multiplier: CQTY = CQYT x MATH01
•
•

•
•
Use X0005 GetUDC  for item TIMB to determine the TBF by getting the System (SY) and UDC Code
(RT). With the SY, RT and TIMB, use BF Get UDC to  retrieve the UDC record. Take second
description (DL02) and convert it to numeric. If the UDC is not found, default the Time Basis to 1.
•
•

•
•
Calculate Hours:
•
•
MRH = (RUNM / TBF) x CQTY
• LRH = ((RUNL / TBF) x CQTY) x SETC
• LSH = SETL
•

•
Use B3100460 CalculateWOHoursAndCost.
• Call Subrutine to Save detail record, Item Summary and Top Summary
•
•
Using B3200400 Cost/Price Cache
•
•
Accumulate all the cost to output Cost.
•

Data Structure

D3200490 - Configurator Cost Routing

Parameter Name Data Item Data Type Req/Opt I/O/Both

mnParentItemNumber 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.

szBranchPlant MCU char NONE NONE

An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for
purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by
business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units
for which you have no authority.

mnComponentItemNumber ITM MATH_NUMERIC NONE NONE

An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and
so forth. The item numbers are as follows:   o Item Number (short) - An eight-digit, computer-assigned item number     o 2nd Item Number - The
25-digit, free-form, user defined alphanumeric item number     o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item
number

szComponentBranch CMCU char NONE NONE

A secondary or lower-level business unit. The system uses the value that you enter to indicate that a branch or plant contains several
subordinate departments or jobs. For example, assume that the component branch is named MMCU. The structure of MMCU might be as follows:
Branch/Plant - (MMCU)       Dept A - (MCU)       Dept B - (MCU)       Job 123 - (MCU)

mnQuantity UORG MATH_NUMERIC NONE NONE

The quantity of units affected by this transaction.

mnOperationSequence OPSQ MATH_NUMERIC NONE NONE

A number used to indicate an order of succession. In routing instructions, a number that sequences the fabrication or assembly steps in the
manufacture of an item. You can track costs and charge time by operation. In bills of material, a number that designates the routing step in the
fabrication or assembly process that requires a specified component part. You define the operation sequence after you create the routing
instructions for the item. The Shop Floor Management system uses this number in the backflush/preflush by operation process. In engineering
change orders, a number that sequences the assembly steps for the engineering change. For repetitive manufacturing, a number that
identifies the sequence in which an item is scheduled to be produced. Skip To fields allow you to enter an operation sequence that you want to begin
the display of information. You can use decimals to add steps between existing steps. For example, use 12.5 to add a step between steps
12 and 13.

jdStartDate STRT JDEDATE NONE NONE

The start date for the order. You can enter this date manually, or have the system calculate it using a backscheduling routine. The routine
starts with the required date and offsets the total leadtime to calculate the appropriate start date.

mnMultiplier MATH01 MATH_NUMERIC NONE NONE

- - - Good Performance Low Value.

mnCost ECST MATH_NUMERIC NONE NONE

For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
number of units.

cSuppressErrorMessage EV01 char NONE NONE

An option that specifies the type of processing for an event.

szErrorMessageID DTAI char NONE NONE

A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or
special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.

szTransactionQntyUOM UOM char OPT NONE

A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box).

mnJobNumber JOBS MATH_NUMERIC OPT NONE

The job number (work station ID) which executed the particular job.

mnConfigurationIDNumber CFGID MATH_NUMERIC OPT NONE

An identifier that represents a unique configuration. It is generated by a next number value and is the key to the configuration tables.

mnComponentIDNumber CFGCID MATH_NUMERIC OPT NONE

A number that represents a component in a configuration. This number, which is generated by next numbers, always restarts at 1 and
increments, based on the number of components in the configuration.

Related Functions

N3003220 Calculate Quantity With Shrink

X0005 Get User Defined Codes

Related Tables

F30006 Work Center Master File

F30008 Work Center Rates File

F3003 Routing Master File

F3009 Job Shop Manufacturing Constants

F4101 Item Master

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
mnParentItemNumber	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.
szBranchPlant	MCU	char	NONE	NONE
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit might be a warehouse location, job, project, work center, branch, or plant. You can assign a business unit to a document, entity, or person for purposes of responsibility reporting. For example, the system provides reports of open accounts payable and accounts receivable by business unit to track equipment by responsible department. Business unit security might prevent you from viewing information about business units for which you have no authority.
mnComponentItemNumber	ITM	MATH_NUMERIC	NONE	NONE
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item numbers (see data item XRT) to accommodate substitute item numbers, replacements, bar codes, customer numbers, supplier numbers, and so forth. The item numbers are as follows: o Item Number (short) - An eight-digit, computer-assigned item number o 2nd Item Number - The 25-digit, free-form, user defined alphanumeric item number o 3rd Item Number - Another 25-digit, free-form, user defined alphanumeric item number
szComponentBranch	CMCU	char	NONE	NONE
A secondary or lower-level business unit. The system uses the value that you enter to indicate that a branch or plant contains several subordinate departments or jobs. For example, assume that the component branch is named MMCU. The structure of MMCU might be as follows: Branch/Plant - (MMCU) Dept A - (MCU) Dept B - (MCU) Job 123 - (MCU)
mnQuantity	UORG	MATH_NUMERIC	NONE	NONE
The quantity of units affected by this transaction.
mnOperationSequence	OPSQ	MATH_NUMERIC	NONE	NONE
A number used to indicate an order of succession. In routing instructions, a number that sequences the fabrication or assembly steps in the manufacture of an item. You can track costs and charge time by operation. In bills of material, a number that designates the routing step in the fabrication or assembly process that requires a specified component part. You define the operation sequence after you create the routing instructions for the item. The Shop Floor Management system uses this number in the backflush/preflush by operation process. In engineering change orders, a number that sequences the assembly steps for the engineering change. For repetitive manufacturing, a number that identifies the sequence in which an item is scheduled to be produced. Skip To fields allow you to enter an operation sequence that you want to begin the display of information. You can use decimals to add steps between existing steps. For example, use 12.5 to add a step between steps 12 and 13.
jdStartDate	STRT	JDEDATE	NONE	NONE
The start date for the order. You can enter this date manually, or have the system calculate it using a backscheduling routine. The routine starts with the required date and offsets the total leadtime to calculate the appropriate start date.
mnMultiplier	MATH01	MATH_NUMERIC	NONE	NONE
- - - Good Performance Low Value.
mnCost	ECST	MATH_NUMERIC	NONE	NONE
For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the number of units.
cSuppressErrorMessage	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
szErrorMessageID	DTAI	char	NONE	NONE
A code that identifies and defines a unit of information. It is an alphanumeric code up to 8 characters long that does not allow blanks or special characters such as %, &, or +. You create new data items using system codes 55-59. You cannot change the alias.
szTransactionQntyUOM	UOM	char	OPT	NONE
A user defined code (00/UM) that indicates the quantity in which to express an inventory item, for example, CS (case) or BX (box).
mnJobNumber	JOBS	MATH_NUMERIC	OPT	NONE
The job number (work station ID) which executed the particular job.
mnConfigurationIDNumber	CFGID	MATH_NUMERIC	OPT	NONE
An identifier that represents a unique configuration. It is generated by a next number value and is the key to the configuration tables.
mnComponentIDNumber	CFGCID	MATH_NUMERIC	OPT	NONE
A number that represents a component in a configuration. This number, which is generated by next numbers, always restarts at 1 and increments, based on the number of components in the configuration.

N3003220 Calculate Quantity With Shrink
X0005 Get User Defined Codes

F30006 Work Center Master File
F30008 Work Center Rates File
F3003 Routing Master File
F3009 Job Shop Manufacturing Constants
F4101 Item Master