RevalueParentOrProcess

Revalue Parent Or Process

Minor Business Rule

Object Name: B3104360

Parent DLL: CMFGBASE

Location: Client/Server

Language: C

Purpose
This function was created for the WIP Revaluation enhancement.  It is called by the WIP Revaluation UBE (R30837).  Its purpose
is to revalue the production costs of a parent item and to update the Production Costs Cache with the new production costs.

Technical Overview
The Frozen Cost Cache is loaded with the F30026 records for the work order and the Work Order Variance Cache record is
retrieved for the work order.  For each parent production cost record in the Production Costs Cache, the new unit cost is retrieved and
the production costs are recalculated.  Note:  For Actual Costing, only material costs are revalued.  The Production Costs Cache
record is updated with the newly calculated production costs and if journal entries are requested and there is a change in the WIP
amount (Actual Amount - (Completed Amount + Scrapped Amount)), the journal entries are created.  Once the production cost
amounts have been calculated, the corresponding Frozen Cost Cache record is updated to indicate that it has been processed.  After
all of the Production Cost Cache records have been processed, the Frozen Cost Cache is checked to make sure that there aren't
any records in it that have not yet been processed.  If there are unprocessed records in the Frozen Cost Cache, production costs
are calculated for the records and a record is added to the Production Cost Cache.

Parameter Name	Data Item	Data Type	Req/Opt	I/O/Both
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.
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
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.
szCostMethod	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.
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).
cParentChild	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
cProcessOrDiscrete	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
szProductionUOM	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).
szPrimaryUOM	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).
cActualCostedItem	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnWorkOrderUnits	UORG	MATH_NUMERIC	OPT	NONE
The quantity of units affected by this transaction.
mnWOCompletedUnits	SOCN	MATH_NUMERIC	OPT	NONE
The number of units canceled in Sales Order or Work Order Processing, using either the entered or the primary unit of measure defined for this item. In manufacturing, this can also be the number of units scrapped to date.
mnWOScrappedUnits	SOCN	MATH_NUMERIC	OPT	NONE
The number of units canceled in Sales Order or Work Order Processing, using either the entered or the primary unit of measure defined for this item. In manufacturing, this can also be the number of units scrapped to date.
cNewItem	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cNewBranch	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cNewUOM	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
szCacheJobNumber	JOBN	char	OPT	NONE
The code that identifies the work station ID that executed a particular job.
szWorkStationId	JOBN	char	OPT	NONE
The code that identifies the work station ID that executed a particular job.
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.
szUserId	USER	char	OPT	NONE
The code that identifies a user profile.
jdDate	DTE	JDEDATE	OPT	NONE
You can enter a date with or without slashes (/) or dashes (-) as separators. If you leave a date entry field blank, the system supplies the current date.
mnTime	TME0	MATH_NUMERIC	OPT	NONE
Everest Parent Data Item
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.
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.
szGLCategoryCode	GLPT	char	OPT	NONE
A user defined code (41/9) that identifies the G/L offset that system uses when it searches for the account to which it posts the transaction. If you do not want to specify a class code, you can enter **** (four asterisks) in this field. You can use automatic accounting instructions (AAIs) to predefine classes of automatic offset accounts for the Inventory Management, Procurement, and Sales Order Management systems. You might assign G/L class codes as follows: IN20 Direct Ship Orders IN60 Transfer Orders IN80 Stock Sales The system can generate accounting entries based upon a single transaction. For example, a single sale of a stock item can trigger the generation of accounting entries similar to the following: Sales-Stock (Debit) xxxxx.xx A/R Stock Sales (Credit) xxxxx.xx Posting Category: IN80 Stock Inventory (Debit) xxxxx.xx Stock COGS (Credit) xxxxx.xx The system uses the class code and the document type to find the AAI.
szCompany	CO	char	OPT	NONE
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company Constants table (F0010) and must identify a reporting entity that has a complete balance sheet. At this level, you can have intercompany transactions. Note: You can use company 00000 for default values such as dates and automatic accounting instructions. You cannot use company 00000 for transaction entries.
mnTotalNewWIP	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnTotalOldWIP	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
cGLInterfaceFlag	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cGLTransaction	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
mnSummaryGLDocumentNo	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
cBatchStatus	IST	char	OPT	NONE
A user defined code (98/IC) that indicates the posting status of a batch. Valid values are: Blank Unposted batches that are pending approval or have a status of approved. A Approved for posting. The batch has no errors, and is in balance, but has not yet been posted. D Posted. The batch posted successfully. E Error. The batch is in error. You must correct the batch before it can post. P Posting. The system is in the process of posting the batch to the general ledger. The batch is unavailable until the posting process is complete. If errors occur during the post, the batch status changes to E (error). U In use. The batch is temporarily unavailable because someone is working with it, or the batch appears to be in use because a power failure occurred while the batch was open.
cPrevBatchStatus	IST	char	OPT	NONE
A user defined code (98/IC) that indicates the posting status of a batch. Valid values are: Blank Unposted batches that are pending approval or have a status of approved. A Approved for posting. The batch has no errors, and is in balance, but has not yet been posted. D Posted. The batch posted successfully. E Error. The batch is in error. You must correct the batch before it can post. P Posting. The system is in the process of posting the batch to the general ledger. The batch is unavailable until the posting process is complete. If errors occur during the post, the batch status changes to E (error). U In use. The batch is temporarily unavailable because someone is working with it, or the batch appears to be in use because a power failure occurred while the batch was open.
cCurrencyConvFlag	CRYR	char	OPT	NONE
A code that specifies whether to use multi-currency accounting, and the method of multi-currency accounting to use: Codes are: N Do not use multi-currency accounting. Use if you enter transactions in only one currency for all companies. The multi-currency fields will not appear on forms. The system supplies a value of N if you do not enter a value. Y Activate multi-currency accounting and use multipliers to convert currency. The system multiplies the foreign amount by the exchange rate to calculate the domestic amount. Z Activate multi-currency accounting and use divisors to convert currency. The system divides the foreign amount by the exchange rate to calculate the domestic amount.
szDocumentType	DCT	char	OPT	NONE
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document types, such as, vouchers, invoices, receipts, and timesheets. The reserved document type prefixes for codes are: P Accounts payable documents R Accounts receivable documents T Time and Pay documents I Inventory documents O Purchase order documents S Sales order documents
szBatchType	ICUT	char	OPT	NONE
A code that specifies the system and type of transactions entered in a batch. The system assigns the value when you enter a transaction. Valid values are set up in user defined code table 98/IT. You cannot assign new values. All batch types are hard coded.
jdBatchDate	DICJ	JDEDATE	OPT	NONE
The date of the batch. If you leave this field blank, the system date is used.
szExplanation	EXR	char	OPT	NONE
A name or remark that describes the purpose for using an account or conveys any other information that the user wants about the transaction.
idPPATPtr	GENLNG	ID	OPT	NONE
General purpose ID variable.
cCurrencyDecimals	CDEC	char	OPT	NONE
A value that designates the number of decimals in the currency, amount, or quantity fields the system displays. For example, U.S. Dollars would be 2 decimals, Japanese Yen would be no decimals, and Cameroon Francs would be 3 decimals.
jdDateToday	DRQJ	JDEDATE	OPT	NONE
The date that an item is scheduled to arrive or that an action is scheduled for completion.
mnDocumentNumber	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.
mnF0911JobNumber	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
cSubledgerType	SBLT	char	OPT	NONE
A user defined code (00/ST) that is used with the Subledger field to identify the subledger type and how the system performs subledger editing. On the User Defined Codes form, the second line of the description controls how the system performs editing. This is either hard-coded or user defined. Valid values include: A Alphanumeric field, do not edit N Numeric field, right justify and zero fill C Alphanumeric field, right justify and blank fill
mnLastLineNumber	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
mnBatchNumber	MATH01	MATH_NUMERIC	OPT	NONE
- - - Good Performance Low Value.
szSubledger	SBL	char	OPT	NONE
A code that identifies a detailed, auxiliary account within a general ledger account. A subledger can be an equipment item number or an address book number. If you enter a subledger, you must also specify the subledger type.
szCurrencyCode	CCD0	char	OPT	NONE
Everest Parent Data Item.
cProofOrFinal	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
cEditLineError	EV01	char	OPT	NONE
An option that specifies the type of processing for an event.
szCompletionLocation	LOCN	char	OPT	NONE
The storage location from which goods will be moved.
szCompletionLot	LOTN	char	OPT	NONE
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics.
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.

RevalueParentOrProcess