ProductionCostsCache

Production Costs Cache

Minor Business Rule

Object Name: B3104400

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

Production Cost Cache

Purpose

This business function was created for the WIP Revaluation enhancement and is called by the WIP
Revaluation UBE (R30837), the Revalue Component business function (B3104350), the Revalue Parent or Process
business function (B3104360), and the Revalue CoBy Product business function (B3104370). It's purpose is to
perform all cache processing for F3102 production cost records.

Parameter Details

Required Parameters:

1. cMode
0 = Create Cache
1 = Load Cache
2 = Add To Cache
3 = Read Cache (sequential or single fetch)
4 = Update Cache
5 = Update F3102 table with cache values
6 = Terminate Cache

2. szCacheJobNumber - this job number is used for all cache processing.

Functionality Overview

Before any cache processing takes place this business function should be called with cMode = '0' in order
to initiate the cache.  Once the cache has been created, it can be loaded with the F3102 records for work
orders.  After all cache processing is complete, this function should be called with cMode = '6' in order to terminate
the cache instance.

Data Structure

D3104400A - Production Costs Cache

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

szCacheJobNumber JOBN char OPT NONE

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

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.

cMode EV01 char OPT NONE

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

cSuppressErrorMessage EV01 char OPT NONE

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

mnWorkOrderNumber DOCO MATH_NUMERIC OPT NONE

A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
and so on.

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

cParentOrChild PART char OPT NONE

An option that specifies whether the system displays parent records or child records. If you turn on this option, the system displays parent
records for the address book number entered. Also a field that indicates whether a record is a parent or child. For the field, valid values
are: P Parent   C Child

szCostType COST char OPT 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.

szWorkCenter MCU char OPT 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.

jdDate UPMJ JDEDATE OPT NONE

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

szProgramId PID char OPT 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.

cUpdateStandard EV01 char OPT NONE

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

cUpdateCurrent EV01 char OPT NONE

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

cUpdatePlanned EV01 char OPT NONE

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

cUpdateActual EV01 char OPT NONE

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

cUpdateCompleted EV01 char OPT NONE

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

cUpdateScrapped EV01 char OPT NONE

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

cUpdateUnaccounted EV01 char OPT NONE

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

cUpdateUnpostable EV01 char OPT NONE

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

mnStandardAmount OPAT MATH_NUMERIC OPT NONE

The standard amount to produce a given amount of product.

mnCurrentAmount CCCA MATH_NUMERIC OPT NONE

The current amount to produce a given amount of product.

mnPlannedAmount PLAT MATH_NUMERIC OPT NONE

The planned amount to produce a given amount of product.

mnActualAmount CLAT MATH_NUMERIC OPT NONE

The actual amount to produce a given amount of product.

mnCompletedAmount CPAT MATH_NUMERIC OPT NONE

The amount completed for the work order.

mnScrappedAmount SLAT MATH_NUMERIC OPT NONE

The amount scrapped for the work order.

mnUnaccountedAmount CCUA MATH_NUMERIC OPT NONE

The current amount reported but not yet posted to the general ledger.

mnUnpostableAmount UNPA MATH_NUMERIC OPT NONE

A number that specifies the amount of scrap that is unaccounted for and is not reported to the general ledger through the Manufacturing
Accounting system. The system populates the Unpostable Amount field in the Production Cost table (F3102) with this amount when you complete
a work order for an actual costed item. When the system writes journal entries, it clears the Unpostable Amount field in the F3102 table.

mnStandardUnits OPUN MATH_NUMERIC OPT NONE

The standard units to produce a given amount of product.

mnCurrentUnits CCCU MATH_NUMERIC OPT NONE

The current units to produce a given amount of product.

mnPlannedUnits PLUN MATH_NUMERIC OPT NONE

Future Use.

mnActualUnits CLUN MATH_NUMERIC OPT NONE

The actual units to produce a given amount of product.

mnCompletedUnits CPUN MATH_NUMERIC OPT NONE

The units completed for the work order.

mnScrappedUnits SLUN MATH_NUMERIC OPT NONE

The units scrapped for the work order.

mnUnaccountedUnits CCUU MATH_NUMERIC OPT NONE

The current units reported but not yet posted to the general ledger.

mnUnpostableUnits UNPU MATH_NUMERIC OPT NONE

The current units reported but not yet posted to the general ledger.

szUnitOfMeasure 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).

idhCursor GENLNG ID OPT NONE

General purpose ID variable.

szOrderType DCTO char OPT NONE

A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has
reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post
program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and
should not be changed: P Accounts Payable documents   R Accounts Receivable documents   T Payroll documents   I Inventory documents
O Purchase Order Processing documents   J General Accounting/Joint Interest Billing documents   S Sales Order Processing documents

cReturnPointer EV01 char OPT NONE

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

mnNumberKeys MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnOrigStandardAmt MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnOrigStandardUnits MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnOrigCurrentAmt MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnOrigCurrentUnits MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnOrigPlannedAmt MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnOrigPlannedUnits MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnOrigActualAmt MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnOrigActualUnits MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnOrigCompletedAmt MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnOrigCompletedUnits MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnOrigScrappedAmt MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnOrigScrappedUnits MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnOrigUnaccountedAmt MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnOrigUnaccountedUnits MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnOrigUnpostableAmt MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

mnOrigUnpostableUnits MATH01 MATH_NUMERIC OPT NONE

- - - Good Performance Low Value.

Related Functions

B4001040 Get Item Master Description UOM

B9800100 Get Audit Information

Related Tables

F3102 Production Cost

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
szCacheJobNumber	JOBN	char	OPT	NONE
The code that identifies the work station ID that executed a particular job.
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.
cMode	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cSuppressErrorMessage	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnWorkOrderNumber	DOCO	MATH_NUMERIC	OPT	NONE
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry, and so on.
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
cParentOrChild	PART	char	OPT	NONE
An option that specifies whether the system displays parent records or child records. If you turn on this option, the system displays parent records for the address book number entered. Also a field that indicates whether a record is a parent or child. For the field, valid values are: P Parent C Child
szCostType	COST	char	OPT	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.
szWorkCenter	MCU	char	OPT	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.
jdDate	UPMJ	JDEDATE	OPT	NONE
The date that specifies the last update to the file record.
szProgramId	PID	char	OPT	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.
cUpdateStandard	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cUpdateCurrent	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cUpdatePlanned	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cUpdateActual	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cUpdateCompleted	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cUpdateScrapped	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cUpdateUnaccounted	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cUpdateUnpostable	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnStandardAmount	OPAT	MATH_NUMERIC	OPT	NONE
The standard amount to produce a given amount of product.
mnCurrentAmount	CCCA	MATH_NUMERIC	OPT	NONE
The current amount to produce a given amount of product.
mnPlannedAmount	PLAT	MATH_NUMERIC	OPT	NONE
The planned amount to produce a given amount of product.
mnActualAmount	CLAT	MATH_NUMERIC	OPT	NONE
The actual amount to produce a given amount of product.
mnCompletedAmount	CPAT	MATH_NUMERIC	OPT	NONE
The amount completed for the work order.
mnScrappedAmount	SLAT	MATH_NUMERIC	OPT	NONE
The amount scrapped for the work order.
mnUnaccountedAmount	CCUA	MATH_NUMERIC	OPT	NONE
The current amount reported but not yet posted to the general ledger.
mnUnpostableAmount	UNPA	MATH_NUMERIC	OPT	NONE
A number that specifies the amount of scrap that is unaccounted for and is not reported to the general ledger through the Manufacturing Accounting system. The system populates the Unpostable Amount field in the Production Cost table (F3102) with this amount when you complete a work order for an actual costed item. When the system writes journal entries, it clears the Unpostable Amount field in the F3102 table.
mnStandardUnits	OPUN	MATH_NUMERIC	OPT	NONE
The standard units to produce a given amount of product.
mnCurrentUnits	CCCU	MATH_NUMERIC	OPT	NONE
The current units to produce a given amount of product.
mnPlannedUnits	PLUN	MATH_NUMERIC	OPT	NONE
Future Use.
mnActualUnits	CLUN	MATH_NUMERIC	OPT	NONE
The actual units to produce a given amount of product.
mnCompletedUnits	CPUN	MATH_NUMERIC	OPT	NONE
The units completed for the work order.
mnScrappedUnits	SLUN	MATH_NUMERIC	OPT	NONE
The units scrapped for the work order.
mnUnaccountedUnits	CCUU	MATH_NUMERIC	OPT	NONE
The current units reported but not yet posted to the general ledger.
mnUnpostableUnits	UNPU	MATH_NUMERIC	OPT	NONE
The current units reported but not yet posted to the general ledger.
szUnitOfMeasure	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).
idhCursor	GENLNG	ID	OPT	NONE
General purpose ID variable.
szOrderType	DCTO	char	OPT	NONE
A user defined code (00/DT) that identifies the type of document. This code also indicates the origin of the transaction. J.D. Edwards has reserved document type codes for vouchers, invoices, receipts, and time sheets, which create automatic offset entries during the post program. (These entries are not self-balancing when you originally enter them.) The following document types are defined by J.D. Edwards and should not be changed: P Accounts Payable documents R Accounts Receivable documents T Payroll documents I Inventory documents O Purchase Order Processing documents J General Accounting/Joint Interest Billing documents S Sales Order Processing documents
cReturnPointer	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnNumberKeys	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnOrigStandardAmt	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnOrigStandardUnits	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnOrigCurrentAmt	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnOrigCurrentUnits	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnOrigPlannedAmt	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnOrigPlannedUnits	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnOrigActualAmt	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnOrigActualUnits	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnOrigCompletedAmt	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnOrigCompletedUnits	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnOrigScrappedAmt	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnOrigScrappedUnits	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnOrigUnaccountedAmt	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnOrigUnaccountedUnits	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnOrigUnpostableAmt	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnOrigUnpostableUnits	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.

B4001040 Get Item Master Description UOM
B9800100 Get Audit Information