RollupCosts

Rollup Costs - Business Function

Minor Business Rule

Object Name: B31P0110

Parent DLL: CEPM

Location: Client/Server

Language: C

Functional Description
This business function accumulates Production (F3102) and Non-Production (F0911) costs associated with a Manufacturing Project
into cost buckets identified in the 31P/CC UDC and updates the Work Order (F4801) and Work Order Tag (F4801) files with the
calculated values.

Setup Notes and Prerequisites
The business function can be called in three modes:
1 = Calculation Mode Calculates costs and stores them in the Cost Cache
2 = Update Mode Reads the Cost Cache and updates the Work Order Master File and Work Order Tag File
3 = Calculate and ReturnCalculates costs and returns Planned and Estimates, without storing values in the Cost
Cache

Error and Warning messages are written to the B31P0200 Cache unless the cSuppressErrorMessages = '1'  is passed in.  If the
error messages are not suppressed, the cache should be terminated with a call to B31P0200.

Technical Specifications
1.0   If cMode = 1
1.1 Rollup Costs
1.2Add record to Cost Cache
1.3Rollup Additional Costs
1.4Add record to Cost Cache

2.0   If cMode = 2
2.1Read each record in the Cost Cache and update F4801 and F4801T

3.0   If cMode = 3
3.1Rollup Costs
3.2Return Planned and Estimated Costs

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.
mnWorkOrderDocumentNumber	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.
cRollupStandardToEstimate	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cRollupPlannedToPlanned	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cRollupActualToActual	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
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
mnProjectNumber	PRJM	MATH_NUMERIC	OPT	NONE
A number that identifies an EPM project in the system. The project must be set up in the Add/Revise Project program (P31P011).
szWorkOrderBranch	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.
cErrorLevel	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnPlannedSpecialUnits	U	MATH_NUMERIC	OPT	NONE
The quantity of something that is identified by a unit of measure. For example, it can be the number of barrels, boxes, cubic yards, gallons, hours, and so on.
mnPlannedSpecialAmt	MN29D9	MATH_NUMERIC	OPT	NONE
This is a generic field used as a work field in Everest.
mnPlannedOther	MN29D9	MATH_NUMERIC	OPT	NONE
This is a generic field used as a work field in Everest.
mnPlannedMaterial	MN29D9	MATH_NUMERIC	OPT	NONE
This is a generic field used as a work field in Everest.
mnPlannedLabor	MN29D9	MATH_NUMERIC	OPT	NONE
This is a generic field used as a work field in Everest.
mnEstimatedSpecialAmt	MN29D9	MATH_NUMERIC	OPT	NONE
This is a generic field used as a work field in Everest.
mnEstimatedOther	MN29D9	MATH_NUMERIC	OPT	NONE
This is a generic field used as a work field in Everest.
mnEstimatedMaterial	MN29D9	MATH_NUMERIC	OPT	NONE
This is a generic field used as a work field in Everest.
mnEstimatedLabor	MN29D9	MATH_NUMERIC	OPT	NONE
This is a generic field used as a work field in Everest.
mnEstimatedSpecialUnits	U	MATH_NUMERIC	OPT	NONE
The quantity of something that is identified by a unit of measure. For example, it can be the number of barrels, boxes, cubic yards, gallons, hours, and so on.
mnParentItemNumber	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
mnErrorLineNumber	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.

F0911 Account Ledger
F31P21 Cost Classification Table
F4801 Work Order Master File
F4801T Work Order Master Tag File