ComponentVarianceCache

Component Variance Cache Business Function

Minor Business Rule

Object Name: B3104090

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

Functional Description

Purpose
The purpose of this function is to perform all caching functionality for the Component Variance Cache.  The Component Variance Cache is used by the
WIP Revaluation program to store the frozen costs used to revalue configured work orders during UBE processing.

Setup Notes and Prerequisites
The ComponentVarianceCache function must be called with cMode = 0 in order to create an instance of the cache before any other caching
functionality can be performed.  In addition, the cache must be called with cMode = 4 after all desired caching functionality has been performed in order to terminate
the cache.

Business Function Paramenters:
1.  cMode - Indicates the desired processing.
     Valid modes include:
0 = Create an instance of the cache
1 = Add a record to cache
2 = Read a record from cache
3 = Delete a record from cache
5 = Terminate the cache
2.  szCacheJobNumber - A unique job number that can be combined with business function object name to create a unique cache name.
3.  cSuppressErrorMessage - A value of '1' indicates that errors encountered during processing should not be set in the message center.
4.  szErrorMessage - The error messge ID returned from the business function when an error occurs.  This message is returned regardless of the
value of the      cSuppressErrorMessage parameter.
5.   idhCursor - A cursor pointing to a particular record in the cache.  The cursor is passed back from the function when the cReturnPointer
parameter is set to '1' and should            be passed into the function for a sequential read of the cache.
6.  mnShortItemNumber - A member of the cache and part of the cache key.
7.  szBranch - A member of the cache and part of the cache key.
8.  szLocation - A member of the cache.
9.  szLot - A member of the cache.
10.  mnNumberKeys - Indicates the number of keys to be used when fetching from the cache.
11.  cReturnPointer - A value of '1' indicates that a pointer to the cache should be returned when a successful cache read has occured.
12.  szLedgerType - A member of the cache.
13.  mnCurrentVariance - A member of the cache.
14.  mnPlannedVariance - A member of the cache.
15.  mnActualVariance - A member of the cache.
16.  mnScrappedVariance - A member of the cache.

Technical Specifications
Cache Structure:
mnShortItemNumber
szBranch
  szLocation
  szLot
  szLedgType
  mnCurrentVariance
  mnPlannedVariance
  mnActualVariance
  mnScrappedVariance
Cache Key:
mnShortItemNumber
szBranch
  szLocation
  szLot
  szLedgType

Data Structure

D3104090 - Component Variance Cache - Data Structure

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

cMode EV01 char OPT INPUT

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

szCacheJobNumber JOBN char OPT INPUT

The code that identifies the work station ID that executed a particular job.

cSuppressErrorMessage EV01 char OPT INPUT

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

szErrorMessage DTAI char OPT OUTPUT

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.

idhCursor GENLNG ID OPT BOTH

General purpose ID variable.

mnShortItemNumber 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

szBranch MMCU char OPT 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 OPT NONE

The storage location from which goods will be moved.

szLot LOTN char OPT NONE

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

mnNumberKeys NKEYS MATH_NUMERIC OPT INPUT

The number of keys in an index that will be used to retrieve, delete, or update a record.

cReturnPointer EV01 char OPT INPUT

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

szLedgType LEDG char OPT 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.

mnCurrentVariance MN29D9 MATH_NUMERIC OPT NONE

This is a generic field used as a work field in Everest.

mnPlannedVariance MN29D9 MATH_NUMERIC OPT NONE

This is a generic field used as a work field in Everest.

mnActualVariance MN29D9 MATH_NUMERIC OPT NONE

This is a generic field used as a work field in Everest.

mnScrappedVariance MN29D9 MATH_NUMERIC OPT NONE

This is a generic field used as a work field in Everest.

Related Functions

None

Related Tables

None

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
cMode	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
szCacheJobNumber	JOBN	char	OPT	INPUT
The code that identifies the work station ID that executed a particular job.
cSuppressErrorMessage	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
szErrorMessage	DTAI	char	OPT	OUTPUT
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.
idhCursor	GENLNG	ID	OPT	BOTH
General purpose ID variable.
mnShortItemNumber	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
szBranch	MMCU	char	OPT	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	OPT	NONE
The storage location from which goods will be moved.
szLot	LOTN	char	OPT	NONE
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.
mnNumberKeys	NKEYS	MATH_NUMERIC	OPT	INPUT
The number of keys in an index that will be used to retrieve, delete, or update a record.
cReturnPointer	EV01	char	OPT	INPUT
An option that specifies the type of processing for an event.
szLedgType	LEDG	char	OPT	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.
mnCurrentVariance	MN29D9	MATH_NUMERIC	OPT	NONE
This is a generic field used as a work field in Everest.
mnPlannedVariance	MN29D9	MATH_NUMERIC	OPT	NONE
This is a generic field used as a work field in Everest.
mnActualVariance	MN29D9	MATH_NUMERIC	OPT	NONE
This is a generic field used as a work field in Everest.
mnScrappedVariance	MN29D9	MATH_NUMERIC	OPT	NONE
This is a generic field used as a work field in Everest.