B3003770GenericInterface

Cache Process Cost Item Information

Minor Business Rule

Object Name: B3003770

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

Data Structure

D30UCB - Universal Cache Browser - Small

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cMode	ACTN	char	OPT	NONE
A code that specifies the action that is performed. Valid values are: A Add C Change
szCacheName	A0	char	OPT	NONE
Category Codes Argentina
cReturnCode	GFL1	char	OPT	NONE
Reserved by J.D. Edwards.
mnColumns	MN15D0	MATH_NUMERIC	OPT	NONE
This is a generic field used as a work field in Everest.
idCacheCursor	GENLNG	ID	OPT	NONE
General purpose ID variable.
idStringArray	GENLNG	ID	OPT	NONE
General purpose ID variable.

Related Functions

None

Related Tables

None

CostItemInformationCache

Cache Process Cost Item Information

Minor Business Rule

Object Name: B3003770

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

1. Functional Description

1.1 Purpose
The purpose of this business function is to manipulate item information CACHE for cost simulation and
frozen cost update. This cache holds all items selected by the user and all of their children.

2. Technical Specifications

2.4. Processing
If reverse Lowel Level code flag = '1'
• reverse LLX input before use. It means that this business function will convert the low level code
to be negative so we can roll the cost from the lowest level to the highest level.
• Reverse LLX before copy to output.
'b7'b7'b7'b7
Perform setup functions
• Initialize cache to get handle.
• Retrieve cursor(either from data pointer or new CACHE cursor)
• Return Cache cursor upon request.
• Set Data structure cache Error code = '0'.
• If not successful, set error "032E" - Error Processing Cache.
'b7'b7'b7'b7
Processing Based on Mode.
1. If Process Mode is '1' - GET:
• Open Cursor, reset cursor.
• Retrieve the first element on the cache matching the key values passed as input. The number of keys
to be used in passed in the input parameters. If '0' fetch first element in the list.
• Load the values from the retrieved element into the data structure to be passed back to the calling
program.
• If get fails DS Cache Error Code = '6'.
'b7'b7'b7'b7
2. If Process Mode is '2' - ADD:
• Add new record to CACHE.
• If add fails, set error "032E" and set Data Structure Cache Error Code = '4'.
'b7'b7'b7'b7
3. If Process Mode is '3' - UPDATE:
• Update record in CACHE with new value.
• If add fails, set error "032E" and set Data Structure Cache Error Code ='7'.
'b7'b7'b7'b7
4.If Process Mode is '4' - DELETE:
• Delete all elements on the cache matching the key values passed as input.
• If delete fails, DS Cache Error Code = '5'.
'b7'b7'b7'b7
5. If Process Mode is '5' - DELETE ALL:
• Delete all elements in the cache.
• If delete fails, DS Cache Error Code = '5'.
'b7'b7'b7'b7
6. If Process Mode is '6' - GET NEXT:.
• Retrieve the next element on the cache matching the key values passed as input(the cursor should
have been set throught a previous "GET" action, i.e. process mode '1', if number of keys is '0' then
fetch next record without using any key).
• Load the values from the retrieved element into the data structure to be passed back to the calling
program.
• If there are no more elements, close cursor and set DS Cache Error Code = '1'.
'b7'b7'b7'b7
7. If Process Mode is '7' - ADD/UPDATE:
• Fetch record with full key.
• If record in CACHE is found, update record with the new values.
• Otherwise, add new record into CACHE.
• If add fails, set error "032E" and set DS Cache Error code = '7'.
'b7'b7'b7'b7
8. If Process Mode is '8' - END
• Perform clean-up functions (Terminate Cache)
'b7'b7'b7'b7
9. If Process Mode is '9' - CLOSE CURSOR
• Perform close cursor

Data Structure

D3003770 - Cache Process Cost Item Information

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

cCacheActionCode EV01 char OPT NONE

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

nNumberOfKeys INT01 integer OPT NONE

Number of Days in Future to Query for Responses Due.

cReturnCursor EV01 char OPT NONE

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

idCursor GENLNG ID OPT NONE

General purpose ID variable.

cCacheCodeError EV01 char OPT NONE

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

cSuppressErrorMessage SUPPS char OPT NONE

A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.        0 = allow
runtime error message handling.        1 = suppress runtime error message handling.

szErrorMessageID DTAI char OPT 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.

nIndexNumber INT01 integer OPT NONE

Number of Days in Future to Query for Responses Due.

cReverseLowerLevelCodeYN EV01 char OPT NONE

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

mnJobNumber JOBS MATH_NUMERIC OPT NONE

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

mnLowLevelCode LLX MATH_NUMERIC OPT NONE

This identifies the lowest level in any bill of material at which a particular component may appear..

szBranchComponent CMCU char OPT 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)

mnItemNumber ITM MATH_NUMERIC OPT 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

mnAcctingCostQty ACQ MATH_NUMERIC OPT NONE

An amount that the system uses in the Cost Rollup program to determine the allocation of setup costs. The system totals the setup costs
and divides the sum by this quantity to determine a unit setup cost. The default is 1.

mnUnitsBatchQuantity BQTY MATH_NUMERIC OPT 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.

szUnitOfMeasurePrimary UOM1 char OPT NONE

A user defined code (00/UM) that identifies the unit of measure that the system uses to express the quantity of an item, for example, EA
(each) or KG (kilogram).

szStandardConverionUOM TFLA char OPT NONE

Allows you to bypass the item-specific unit of measure and use the standard unit of measure. Valid values are:    blank Use the item-specific
unit of measure    1       Bypass the item-specific unit of measure and use the standard unit of measure

cStockingType STKT char OPT NONE

A user defined code (41/I) that indicates how you stock an item, for example, as finished goods or as raw materials. The following stocking
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).

cStockingInfo EV01 char OPT NONE

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

cPotencyControl OT1Y char OPT NONE

A code that indicates whether you control the item by potency.

mnStandardPotency STDP MATH_NUMERIC OPT NONE

The percentage of active ingredients normally found in an item.

cCostLevel CLEV char OPT NONE

A code that indicates whether the system maintains one overall inventory cost for the item, a different cost for each branch/plant, or a
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

szSecondItemNumber LITM char OPT 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.

szThirdItemNumber AITM char OPT 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.

cBillofMaterialExploded BEXP char OPT NONE

A flag used in the Bill of Material Explosion process to indicate that the item has been exploded.

cRoutingLevelInfo EV01 char OPT NONE

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

cItemTypeInfo EV01 char OPT NONE

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

mnXrefRoutingItem ITM MATH_NUMERIC OPT 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

cCostByWorkCenter CWC char OPT NONE

A code, maintained in the Manufacturing Constants program (P3009), that indicates whether the system tracks cost variances for discrete
and process items on a summarized level in the Item Cost Component Add-Ons table (F30026) or on a detailed level in the Item Cost
Component Detail table (F300261). Valid values are: Y Yes. Maintain costs on a detailed level by cost component and work center. N No. Maintain costs
on a summarized level by cost component only.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cCacheActionCode	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
nNumberOfKeys	INT01	integer	OPT	NONE
Number of Days in Future to Query for Responses Due.
cReturnCursor	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
idCursor	GENLNG	ID	OPT	NONE
General purpose ID variable.
cCacheCodeError	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cSuppressErrorMessage	SUPPS	char	OPT	NONE
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function. 0 = allow runtime error message handling. 1 = suppress runtime error message handling.
szErrorMessageID	DTAI	char	OPT	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.
nIndexNumber	INT01	integer	OPT	NONE
Number of Days in Future to Query for Responses Due.
cReverseLowerLevelCodeYN	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnJobNumber	JOBS	MATH_NUMERIC	OPT	NONE
The job number (work station ID) which executed the particular job.
mnLowLevelCode	LLX	MATH_NUMERIC	OPT	NONE
This identifies the lowest level in any bill of material at which a particular component may appear..
szBranchComponent	CMCU	char	OPT	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)
mnItemNumber	ITM	MATH_NUMERIC	OPT	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
mnAcctingCostQty	ACQ	MATH_NUMERIC	OPT	NONE
An amount that the system uses in the Cost Rollup program to determine the allocation of setup costs. The system totals the setup costs and divides the sum by this quantity to determine a unit setup cost. The default is 1.
mnUnitsBatchQuantity	BQTY	MATH_NUMERIC	OPT	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.
szUnitOfMeasurePrimary	UOM1	char	OPT	NONE
A user defined code (00/UM) that identifies the unit of measure that the system uses to express the quantity of an item, for example, EA (each) or KG (kilogram).
szStandardConverionUOM	TFLA	char	OPT	NONE
Allows you to bypass the item-specific unit of measure and use the standard unit of measure. Valid values are: blank Use the item-specific unit of measure 1 Bypass the item-specific unit of measure and use the standard unit of measure
cStockingType	STKT	char	OPT	NONE
A user defined code (41/I) that indicates how you stock an item, for example, as finished goods or as raw materials. The following stocking 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).
cStockingInfo	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cPotencyControl	OT1Y	char	OPT	NONE
A code that indicates whether you control the item by potency.
mnStandardPotency	STDP	MATH_NUMERIC	OPT	NONE
The percentage of active ingredients normally found in an item.
cCostLevel	CLEV	char	OPT	NONE
A code that indicates whether the system maintains one overall inventory cost for the item, a different cost for each branch/plant, or a 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
szSecondItemNumber	LITM	char	OPT	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.
szThirdItemNumber	AITM	char	OPT	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.
cBillofMaterialExploded	BEXP	char	OPT	NONE
A flag used in the Bill of Material Explosion process to indicate that the item has been exploded.
cRoutingLevelInfo	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cItemTypeInfo	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnXrefRoutingItem	ITM	MATH_NUMERIC	OPT	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
cCostByWorkCenter	CWC	char	OPT	NONE
A code, maintained in the Manufacturing Constants program (P3009), that indicates whether the system tracks cost variances for discrete and process items on a summarized level in the Item Cost Component Add-Ons table (F30026) or on a detailed level in the Item Cost Component Detail table (F300261). Valid values are: Y Yes. Maintain costs on a detailed level by cost component and work center. N No. Maintain costs on a summarized level by cost component only.