1.Functional Description
1.1Purpose
The purpose of this function is to roll up Price, Cost, Weight and Volume for top parent configured item, based on information from
CacheProcessAllComponents (B3200370) and CacheProcessPriceCost (B3200400) .
1.2Setup Notes and Prerequisites
CacheProcessAllComponents and CacheProcessPriceCost to be loaded prior to calling this function.
1.3Special Logic
None
2.Technical Specifications
2.1Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
SUPPS
cSuppressErrorMessageIN
DTAszErrorMessageON
CFGIDmnConfigurationIDNumberIY
JOBSmnJobNumberIY
DOCOmnDocumentOrderIY
DCTOszOrderTypeIY
KCOOszCompanyKeyIY
ITMmnParentShortItemIY
MCUszParentBranchPlantIY
UOMszOrderUnitOfMeasureIY
WTUMszWeightUnitOfMeasureIN
VLUMszVolumeUnitOfMeasureIN
PMTHcMethodOfPriceCalcIN
PEFJjdDatePriceEffectiveIY
ASNcPriceAdjustmentScheduleIN
CRYRszCurrencyConversionMethodIY
CRCDszCurrencyCodeFromIN
CRDCszCurrencyCodeToIN
COszCompanyOY
LEDGszCostMethodOY
AEXPmnExtendedPriceOY
FEAmntForeignExtendedPriceOY
ECSTmnAmtExtendedCostOY
FECmtForeignExtendedCostOY
GRWTmnTotalWeightOY
ITVLmnTotalVolumeOY
AEXPmnAmtExtPriceRolledUpOY
FEAmnAmtForeignExtPriceRolledUpOY
AEXPmnAmtExtPriceNotRolledUpOY
FEAmnAmtForeignExtPriceNotRolledUpOY
2.2Related Tables
Table Table Description
2.3Related Business Functions
Source NameFunction Name
2.4Processing
CacheActionCode = 1
Call B3200370 (CacheProcessAllComponents)
If (CacheCodeError == 0)
Call B4001040 (GetItemMasterDescUOM) to get StandardUOMeasure
End If
CacheActionCode = 6
While (CacheCodeError == 0)
If (RuleType != Q)
Call internal subrutine CalculateWeight
Call internal subrutine CalculateVolume
End If
If (Stocking Type != C)
Roll Up Cost into lpDS->ExtendedCost
Roll Up Cost into lpDS->ForeignExtendedCost
End If
Call B3200370 (CacheProcessAllComponents)
End While
CacheActionCode = 1
ComponentID = 1
Call B3200370 (CacheProcessAllComponents
Load dsB3200370 (Extended Cost and Foreing Extended Cost)
From lpDS->ExtendedCost and lpDS->ForeignExtendedCost
Save record to B3200370
CacheActionCode = 1
Call B3200400 (CacheProcessPriceCost)
CacheActionCode = 6
While (CacheCodeError == 0)
If (RuleType != Q)
Call internal subrutine CalculateWeight
Call internal subrutine CalculateVolume
End If
If (Price RollUp == Y or 1)
Roll Up Cost into lpDS->ExtendedCost
Roll Up Cost into lpDS->ForeignExtendedCost
End If
Call B3200400 (CacheProcessPriceCost)
End While
Close Cursor
CacheActionCode = 9
Call B3200400 (CacheProcessPriceCost
3.2 Where Used: APPs/UBEs/NERs/BSFNs
Application/Business FunctionApplication/BF Name
P32942
D3201650 - RollupPriceCostWeightVolume
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
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
| ||||
szErrorMessage | 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
| ||||
mnConfigurationIDNumber | CFGID | MATH_NUMERIC | OPT | NONE |
An identifier that represents a unique configuration. It is generated by a next number value and is the key to the configuration tables. | ||||
mnJobNumber | JOBS | MATH_NUMERIC | OPT | NONE |
The job number (work station ID) which executed the particular job. | ||||
mnDocumentOrder | 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,
| ||||
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
| ||||
szCompanyKey | KCOO | char | OPT | NONE |
A number that, along with order number and order type, uniquely identifies an order document (such as a purchase order, a contract, a
| ||||
mnParentShortItem | 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
| ||||
mnAddressNumber | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
mnParentQuantityOrdered | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
szParentBranchPlant | 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
| ||||
szOrderUnitOfMeasure | 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). | ||||
szWeightUnitOfMeasure | WTUM | char | OPT | NONE |
The unit of measure that indicates the weight of an individual item. Typical weight units of measure are:
GM Gram
OZ Ounce
LB Pound
| ||||
szVolumeUnitOfMeasure | VLUM | char | OPT | NONE |
The unit of measure for the cubic space occupied by an inventory item. Typical volume unit of measures are:
ML Milliliter
OZ Fluid Ounce
| ||||
cMethodOfPriceCalc | PMTH | char | OPT | NONE |
A code that determines how the system calculates the price for kit items or configured items. Valid values are:
Blank
Use for items that are
| ||||
jdDatePriceEffective | PEFJ | JDEDATE | OPT | NONE |
The system uses the Price Effective Date to determine the base price and all advanced price adjustments. The value loaded in this date
| ||||
szPriceAdjustmentSchedule | ASN | char | OPT | NONE |
A user defined code (40/AS) that identifies a price and adjustment schedule. A price and adjustment schedule contains one or more
| ||||
cCurrencyConversionMethod | 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
| ||||
szCurrencyCodeFrom | CRCD | char | OPT | NONE |
A code that identifies the currency of a transaction. | ||||
szCurrencyCodeTo | CRDC | char | OPT | NONE |
A code that identifies the domestic (base) currency of the company on a transaction. | ||||
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
| ||||
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
| ||||
mnAmtExtendedCost | ECST | MATH_NUMERIC | OPT | NONE |
For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
| ||||
mnAmtForeignExtendedCost | FEC | MATH_NUMERIC | OPT | NONE |
The product of the cost of an item, expressed in foreign currency according to the orders exchange rate, times the number of units. | ||||
mnTotalWeight | GRWT | MATH_NUMERIC | OPT | NONE |
Essentially a memo field at present, this value is intended to reflect the fact that many inventory items are always packaged in the same
| ||||
mnTotalVolume | ITVL | MATH_NUMERIC | OPT | NONE |
The cubic units occupied by one inventory item. The definition of the unit itself (cubic feet, yards, meters, and so on) is defined in the volume
| ||||
mnAmtExtPriceRolledUp | AEXP | MATH_NUMERIC | OPT | NONE |
The number of units multiplied by the unit price. | ||||
mnAmtForExtPriceRolledUp | FEA | MATH_NUMERIC | OPT | NONE |
The product of the foreign price times the number of units. | ||||
mnAmtExtPriceNotRolledUp | AEXP | MATH_NUMERIC | OPT | NONE |
The number of units multiplied by the unit price. | ||||
mnAmtForExtPriceNotRolledUp | FEA | MATH_NUMERIC | OPT | NONE |
The product of the foreign price times the number of units. | ||||
szSystemCode | SY | char | OPT | NONE |
A user defined code (98/SY) that identifies a system. Valid values include:
01
Address Book
03B
Accounts Receivable
04
Accounts
| ||||
cMethodOfCostCalcula | CMETH | char | OPT | NONE |
A code that indicates how the system calculates the cost for a configured item. Valid values are:
1
The system accumulates the base costs
| ||||
mnAmtPOCost | ECST | MATH_NUMERIC | OPT | NONE |
For accounts receivable and accounts payable, the invoice (gross) amount. For sales orders and purchase orders, the unit cost times the
| ||||
mnAmtForeignPOCost | FEC | MATH_NUMERIC | OPT | NONE |
The product of the cost of an item, expressed in foreign currency according to the orders exchange rate, times the number of units. | ||||
mnParentSOLineNumber | LNID | MATH_NUMERIC | OPT | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
| ||||
mnParentSOWFLineIndex | LNIX | MATH_NUMERIC | OPT | NONE |
szOrderSuffix | SFXO | char | OPT | NONE |
In the A/R and A/P systems, a code that corresponds to the pay item. In the Sales Order and Procurement systems, this code identifies
| ||||
szComputerID | CTID | char | OPT | NONE |
szCustomerGroup | CSTP | char | OPT | NONE |
Customer types that a customer can be grouped into for each of the different preference types. | ||||
szItemGroup | ITTP | char | OPT | NONE |
Item types that a item can be grouped into for each of the different preference types. | ||||
mnProcessID | DEID | MATH_NUMERIC | OPT | NONE |
A system-generated number that identifies a demand record. | ||||
mnTransactionID | TCID | MATH_NUMERIC | OPT | NONE |
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
| ||||
mnAdjustmentRevisionLevel | AREV | MATH_NUMERIC | OPT | NONE |
This field maintains the current revision level of Advanced Pricing adjustments awarded within a sales order. Adjustments associated with
| ||||
mnSupplierNo | VEND | MATH_NUMERIC | OPT | NONE |
The address book number of the preferred provider of this item. | ||||
jdDateRequestedJulian | DRQJ | JDEDATE | OPT | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
mnSupplierExchangeRate | CERA | MATH_NUMERIC | OPT | NONE |
cDSConfiguredComponent | CIDN | char | OPT | NONE |
A user defined code (32/DE) that specifies the type of transaction that the component of a configured item should generate. If the conditions
|
None |
None |