B3003130

F30026 Cost Components Cache

Minor Business Rule

Object Name: B3003130

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

1.Functional Description
This Business Function loads F30026 records into cache so that
calling applications, UBE and BF can use the cached records to decrease database
I/O. It also calculate the new A1 cost and the Old A1 cost.

1.1Purpose
This Business Function loads F30026 records into cache so that
calling applications, UBE and BF can use the cached records to decrease database
I/O. Mode '1' loads F30026 records to cache and returns cost rollups for Frozen Net Added, Total
Frozen and Total Simulated. Mode '1' also calculate the percent of frozen total and percent of simulated
total for each component.It also calculate the new A1 cost and the old A1 cost. Mode '2' reads through
the cache and mode '3' clears the cache.

2.Technical Specifications

2.4Processing
Note: Mode, Cache Handle(lphCache), Cursor Handle, and Job Number as string are required field for
all mode.
1.If mode 1,

a)Retrieve all F30026 records for the key passed by calling program, if selection was NOT
successful

Set IDReturn = ER_ERROR (Record not found)

b)If no match is found try with a blank location and lot fields location. If  selection was
successful, Set IDReturn = ER_WARNING  (WARNING: Exact Lot/Location not found)
c)If selection is successful, create cache index and initialize cache or clear it depending on
whether it already exists or not. Return handle
d) Populate cache with records found and calculate total costs and percentages (if requested)
e) If cost type is 'A1', Calculate the New A1 cost =
   (Total of Simulated Total - Total of Simulated Net Added) + A1 Simulated Net  Added.
Calculate the Old A1 Cost = (Total of Frozen Total - Total of Frozen Net Added) + A1 Frozen Net
Added.

2.If mode 2, retrieve cache entry. If successful, return records. If not successful, Set IDReturn =
ER_ERROR
3.If mode 3, terminate cache and free cursor and cache pointers

Data Structure

D3003130 - DS for B3003130 - Retrieve Cost Components

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

cMode EV01 char NONE NONE

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

mnIdentifierShortItem 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

szItemNumber2nd LITM char NONE NONE

A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
alternative item numbers. The three types of item numbers are: Item Number (short) An 8-digit, computer-assigned item number. 2nd Item Number A
25-digit, user defined, alphanumeric item number. 3rd Item Number Another 25-digit, user defined, alphanumeric item number. In addition to
these three basic item numbers, the system provides an extensive cross-reference search capability. You can define numerous
cross-references to alternative part numbers. For example, you can define substitute item numbers, replacements, bar codes, customer numbers, or
supplier numbers.

szItemNumber3rd AITM char NONE NONE

The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
numbers are as follows: 1.  Item Number (short) - An 8-digit, computer-assigned 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. In addition to
these three basic item numbers, an extensive cross-reference search capability has been provided (see XRT). Numerous cross references to
alternate part numbers can be user defined, such as substitute item numbers, replacements, bar codes, customer numbers, or supplier
numbers.

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

szLocation LOCN char NONE NONE

The storage location from which goods will be moved.

szLot LOTN char NONE NONE

A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.

szLedgType LEDG char NONE NONE

A user defined code (40/CM) that specifies the basis for calculating item costs. Cost methods 01 through 19 are reserved for J.D. Edwards
use.

szCostType COST char NONE NONE

A code that designates each element of cost for an item. Examples of the cost object types are:   o  A1  Purchased raw material   o  B1
Direct labor routing rollup   o  B2  Setup labor routing rollup   o  C1  Variable burden routing rollup   o  C2  Fixed burden routing rollup   o  Dx  Outside
operation routing rollup   o  Xx  Extra add-ons, such as electricity and water The optional add-on computations usually operate with the type
Xx extra add-ons. This cost structure allows you to use an unlimited number of cost components to calculate alternative cost rollups. The
system then associates these cost components with one of six user defined summary cost buckets.

szLotGrade LOTG char NONE NONE

A code that indicates the grade of a lot. The grade is used to indicate the quality of the lot. Examples include the following:    A1   Premium
grade    A2   Secondary grade The grade for a lot is stored in the Lot Master table (F4108).

mnFrozenCost STDC MATH_NUMERIC NONE NONE

The cost of the item as calculated by the Simulate Cost Rollup program (P30820) and updated by the Frozen Cost Update program
(P30835). You can also manually maintain this cost.

mnSimulatedCost XSMC MATH_NUMERIC NONE NONE

Used to calculate cost during the simulation process.

mnFrozenCostRollup CSL MATH_NUMERIC NONE NONE

The accumulated standard cost rolled up from lower levels.

mnSimulatedCostRollup XSCR MATH_NUMERIC NONE NONE

For the designated cost method, used to calculate the cost of all the lower levels during the simulation process.

szFrozenFactorCode SCTC char NONE NONE

A code used to retrieve factor information from the Generic Rate File (F00191).    System Code 30    Record Type CF

szSimulatedFactorCode XSFC char NONE NONE

A user defined code (system 30, type CF) used to retrieve factor information from the Generic Rate table (F00191). This value is used in
conjunction with the Rate Code and Rate Amount fields to calculate extra costs (electricity,taxes, tooling changes, and so on).

mnFrozenFactor STFC MATH_NUMERIC NONE NONE

A generic factor number used to calculate data.

mnSimulatedFactor XSF MATH_NUMERIC NONE NONE

A generic factor used to calculate data for standard cost component extras.

szFrozenRateCode RATS char NONE NONE

A code used to retrieve rate information from the Generic Rate File (F00191).        System Code 30                 Record Type CR

szSimulatedRateCode XSRC char NONE NONE

A user defined code (system 30, type CR) used to retrieve rate information from the Generic Rate table (F00191). This value is used in
conjunction with the Factor Code and Factor Amount fields to calculate extra costs (electricity, taxes, tooling changes, and so on).

mnFrozenRate RTSD MATH_NUMERIC NONE NONE

A code used to define rate information in the Generic Rate File (F00191).

mnSimulatedRate XSR MATH_NUMERIC NONE NONE

A generic rate used to calculate extra costs, such as electricity and taxes.

cStandardProcessingFlag PFLG char NONE NONE

A processing code to indicate the item is currently acitve in the simulation process.    Blank Inactive    1     Active

szUserId USER char NONE NONE

The code that identifies a user profile.

szProgramId PID char NONE NONE

The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value.
It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the
type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a
program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210
indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are
numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry
program.

jdDateUpdated UPMJ JDEDATE NONE NONE

The date that specifies the last update to the file record.

mnTimeOfDay TDAY MATH_NUMERIC NONE NONE

The computer clock in hours:minutes:seconds.

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

cSuppressErrMsg ERR char NONE NONE

The Data Field Error Code field is simply a generic data field to pass an error condition flag.  This field is one of the fields that make up the
external parameter data structure of the Data Dictionary Server.

idhCache GENLNG ID NONE NONE

General purpose ID variable.

idhCursor GENLNG ID NONE NONE

General purpose ID variable.

szJobNumber JOB char NONE NONE

Job Number

mnFrozenNetAddedTTL AA MATH_NUMERIC NONE NONE

A number that identifies the amount that the system will add to the account balance of the associated account number.  Enter credits with a
minus sign (-) either before or after the amount.

mnFrozenCostTTL AA MATH_NUMERIC NONE NONE

A number that identifies the amount that the system will add to the account balance of the associated account number.  Enter credits with a
minus sign (-) either before or after the amount.

mnPctofFrozenTTL PE01 MATH_NUMERIC NONE NONE

The abbreviation for percentage.

mnPctofSimulatedTTL PCT1 MATH_NUMERIC NONE NONE

An abbreviation for percentage.

cCalculatePercents EV01 char NONE NONE

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

mnSimulatedNetAddedTTL AA MATH_NUMERIC OPT NONE

A number that identifies the amount that the system will add to the account balance of the associated account number.  Enter credits with a
minus sign (-) either before or after the amount.

mnSimulatedTTL AA MATH_NUMERIC OPT NONE

A number that identifies the amount that the system will add to the account balance of the associated account number.  Enter credits with a
minus sign (-) either before or after the amount.

mnNewA1Cost AA MATH_NUMERIC OPT NONE

A number that identifies the amount that the system will add to the account balance of the associated account number.  Enter credits with a
minus sign (-) either before or after the amount.

mnOldA1Cost AA MATH_NUMERIC OPT NONE

A number that identifies the amount that the system will add to the account balance of the associated account number.  Enter credits with a
minus sign (-) either before or after the amount.

cDetailFlag EV01 char OPT NONE

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

Related Functions

None

Related Tables

F30026 Item Cost Component Add-Ons

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cMode	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
mnIdentifierShortItem	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
szItemNumber2nd	LITM	char	NONE	NONE
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to alternative item numbers. The three types of item numbers are: Item Number (short) An 8-digit, computer-assigned item number. 2nd Item Number A 25-digit, user defined, alphanumeric item number. 3rd Item Number Another 25-digit, user defined, alphanumeric item number. In addition to these three basic item numbers, the system provides an extensive cross-reference search capability. You can define numerous cross-references to alternative part numbers. For example, you can define substitute item numbers, replacements, bar codes, customer numbers, or supplier numbers.
szItemNumber3rd	AITM	char	NONE	NONE
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item numbers are as follows: 1. Item Number (short) - An 8-digit, computer-assigned 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. In addition to these three basic item numbers, an extensive cross-reference search capability has been provided (see XRT). Numerous cross references to alternate part numbers can be user defined, such as substitute item numbers, replacements, bar codes, customer numbers, or supplier numbers.
szCostCenterAlt	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.
szLocation	LOCN	char	NONE	NONE
The storage location from which goods will be moved.
szLot	LOTN	char	NONE	NONE
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.
szLedgType	LEDG	char	NONE	NONE
A user defined code (40/CM) that specifies the basis for calculating item costs. Cost methods 01 through 19 are reserved for J.D. Edwards use.
szCostType	COST	char	NONE	NONE
A code that designates each element of cost for an item. Examples of the cost object types are: o A1 Purchased raw material o B1 Direct labor routing rollup o B2 Setup labor routing rollup o C1 Variable burden routing rollup o C2 Fixed burden routing rollup o Dx Outside operation routing rollup o Xx Extra add-ons, such as electricity and water The optional add-on computations usually operate with the type Xx extra add-ons. This cost structure allows you to use an unlimited number of cost components to calculate alternative cost rollups. The system then associates these cost components with one of six user defined summary cost buckets.
szLotGrade	LOTG	char	NONE	NONE
A code that indicates the grade of a lot. The grade is used to indicate the quality of the lot. Examples include the following: A1 Premium grade A2 Secondary grade The grade for a lot is stored in the Lot Master table (F4108).
mnFrozenCost	STDC	MATH_NUMERIC	NONE	NONE
The cost of the item as calculated by the Simulate Cost Rollup program (P30820) and updated by the Frozen Cost Update program (P30835). You can also manually maintain this cost.
mnSimulatedCost	XSMC	MATH_NUMERIC	NONE	NONE
Used to calculate cost during the simulation process.
mnFrozenCostRollup	CSL	MATH_NUMERIC	NONE	NONE
The accumulated standard cost rolled up from lower levels.
mnSimulatedCostRollup	XSCR	MATH_NUMERIC	NONE	NONE
For the designated cost method, used to calculate the cost of all the lower levels during the simulation process.
szFrozenFactorCode	SCTC	char	NONE	NONE
A code used to retrieve factor information from the Generic Rate File (F00191). System Code 30 Record Type CF
szSimulatedFactorCode	XSFC	char	NONE	NONE
A user defined code (system 30, type CF) used to retrieve factor information from the Generic Rate table (F00191). This value is used in conjunction with the Rate Code and Rate Amount fields to calculate extra costs (electricity,taxes, tooling changes, and so on).
mnFrozenFactor	STFC	MATH_NUMERIC	NONE	NONE
A generic factor number used to calculate data.
mnSimulatedFactor	XSF	MATH_NUMERIC	NONE	NONE
A generic factor used to calculate data for standard cost component extras.
szFrozenRateCode	RATS	char	NONE	NONE
A code used to retrieve rate information from the Generic Rate File (F00191). System Code 30 Record Type CR
szSimulatedRateCode	XSRC	char	NONE	NONE
A user defined code (system 30, type CR) used to retrieve rate information from the Generic Rate table (F00191). This value is used in conjunction with the Factor Code and Factor Amount fields to calculate extra costs (electricity, taxes, tooling changes, and so on).
mnFrozenRate	RTSD	MATH_NUMERIC	NONE	NONE
A code used to define rate information in the Generic Rate File (F00191).
mnSimulatedRate	XSR	MATH_NUMERIC	NONE	NONE
A generic rate used to calculate extra costs, such as electricity and taxes.
cStandardProcessingFlag	PFLG	char	NONE	NONE
A processing code to indicate the item is currently acitve in the simulation process. Blank Inactive 1 Active
szUserId	USER	char	NONE	NONE
The code that identifies a user profile.
szProgramId	PID	char	NONE	NONE
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry interactive program is P4210, and the number of the Print Invoices batch process report is R42565. The program ID is a variable length value. It is assigned according to a structured syntax in the form TSSXXX, where: T The first character of the number is alphabetic and identifies the type, such as P for Program, R for Report, and so on. For example, the value P in the number P4210 indicates that the object is a program. SS The second and third characters of the number are numeric and identify the system code. For example, the value 42 in the number P4210 indicates that this program belongs to system 42, which is the Sales Order Processing system. XXX The remaining characters of the numer are numeric and identify a unique program or report. For example, the value 10 in the number P4210 indicates that this is the Sales Order Entry program.
jdDateUpdated	UPMJ	JDEDATE	NONE	NONE
The date that specifies the last update to the file record.
mnTimeOfDay	TDAY	MATH_NUMERIC	NONE	NONE
The computer clock in hours:minutes:seconds.
szErrorMessage	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.
cSuppressErrMsg	ERR	char	NONE	NONE
The Data Field Error Code field is simply a generic data field to pass an error condition flag. This field is one of the fields that make up the external parameter data structure of the Data Dictionary Server.
idhCache	GENLNG	ID	NONE	NONE
General purpose ID variable.
idhCursor	GENLNG	ID	NONE	NONE
General purpose ID variable.
szJobNumber	JOB	char	NONE	NONE
Job Number
mnFrozenNetAddedTTL	AA	MATH_NUMERIC	NONE	NONE
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (-) either before or after the amount.
mnFrozenCostTTL	AA	MATH_NUMERIC	NONE	NONE
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (-) either before or after the amount.
mnPctofFrozenTTL	PE01	MATH_NUMERIC	NONE	NONE
The abbreviation for percentage.
mnPctofSimulatedTTL	PCT1	MATH_NUMERIC	NONE	NONE
An abbreviation for percentage.
cCalculatePercents	EV01	char	NONE	NONE
An option that specifies the type of processing for an event.
mnSimulatedNetAddedTTL	AA	MATH_NUMERIC	OPT	NONE
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (-) either before or after the amount.
mnSimulatedTTL	AA	MATH_NUMERIC	OPT	NONE
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (-) either before or after the amount.
mnNewA1Cost	AA	MATH_NUMERIC	OPT	NONE
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (-) either before or after the amount.
mnOldA1Cost	AA	MATH_NUMERIC	OPT	NONE
A number that identifies the amount that the system will add to the account balance of the associated account number. Enter credits with a minus sign (-) either before or after the amount.
cDetailFlag	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.