1.Functional Description
1.1Purpose
The purpose of this business function is to store/maintain F3102 and F30026 values in a cache. The
cache is accessed/updated by R31802 (Manufacturing Accounting Journal Entries). When R31802 finishes,
B3101630 is called in mode '4'. The necessary units and amounts in F3102 are updated with the cache
amounts and the cache is destroyed.
1.2Setup Notes and Prerequisites
Call B3101630 in Mode '1' to initial the cache with existing F3102 records
2.4Processing
1.0If the mode of processing MODE is equal to '1' - Initialize the cache with existing F3102
values
While Read F3102 is successful
If it is a "Parent" item
Fetch the F30026 record to get the Frozen Cost
If the Fetch is successful and them item is not configured
Accumulate the Frozen Cost Values
Add the record to the Cache
Else
Add the record to cache
End If
Else
Add the Record to Cache
End if
If Frozen Costs do no exist
Calculate them and add to cache
End If
End While
End if Mode = '1'
2.0.If the mode of processing MODE is equal to '2' - Read the Cache
If the lpDS->Cost Type is " "
Use two keys to fetch the cache (DOCO, ITM)
End if
End If Mode = '2'
3.0.If the mode of processing MODE is equal to '3' - Update the Cache
Read the cache
If the read is successful
Update the Cache
Else
Add to the Cache
End if
End if Mode = '3'
4.0 If the mode of processing MODE is equal to '4' - Update the table and Delete the cache
While successful cache read
Read the cache
If successful
Read F3102 with key values from cache
If successful
Update the F3102
Else
Add to the F3102
End If
End Successful Cache Read
End While
Terminate the cache
End^
D3101630 - F3102 Variance Cache Data Stucture
2.Technical Specifications
2.1Parameters:
Data Item Data Structure DescriptionI/ORequiredNotes
EV01 Mode IY Processing Mode
1= Initial Cache
2= Read Cache
3= Update Cache
4= Update F3102/Delete
Cache
DOCO Work Order Number I/OY Used in cache key
DCTO Order Type I/ON
OPSQ Sequence No Operations I/ON
ITM Short Item Number I/OY Used in cache key
LITM Second Item Number I/ON
AITM Third Item Number I/ON
COST Cost Type I/ON Used in cache key
PART Parent/Child RelationshipI/OY Used in cache key
XTCR Variance Code I/ON
OPUN Standard Units I/ON
OPAT Standard Amount I/ON
CLUN Actual Units I/ON
CLAT Actual Amount I/ON
CCCU Current Units I/ON
CCCA Current Amounts I/ON
PLUN Planned Units I/ON
PLAT Planned Amount I/ON
CPUN Completed Units I/ON
CPAT Completed Amount I/ON
SLUN Scrapped Units I/ON
SLAT Scrapped Amount I/ON
CCUU Current Unaccounted UnitsI/ON
CCUA Current Unaccounted AmountI/ON
UNPA Unpostable Units I/ON
UNPU Unpostable Amount I/ON
UOM Unit of Measure I/ON
ENGV Engineering Variance I/ON
PLNV Planned Variance I/ON
VACT Actual Variance I/ON
OTHV Other Variance I/ON
NETV Net Variance I/ON
USER User ID I/ON
PID Program ID I/ON
UPMJ Data Updated I/ON
TDAY Time of Day I/ON
JOBN Job Number I/ON
UORG Order Quantity I/ON
MMCU Branch I/ON
CONV Conversion Factor I/ON
EV01 Manufactured or PurchasedI/ON
ACQ Accounting Cost QuantityI/ON
GENLNGGeneric Long I/ON
EV01 Suppress Error Message I/ON 1 = Suppress
" " = Do Not
Suppress
SOQS Quantity Shipped I/ONF4801 Amount
STDC Standard Cost I/ONF30026 Amount
STKT Stocking Type I/ONF4102 Amount
^
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cMode | 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,
| ||||
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
| ||||
mnSequenceNoOperations | OPSQ | MATH_NUMERIC | OPT | NONE |
A number used to indicate an order of succession.
In routing instructions, a number that sequences the fabrication or assembly steps in the
| ||||
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
| ||||
szSecondItemNumber | LITM | char | OPT | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
szThirdItemNumber | AITM | char | OPT | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
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
| ||||
cParentOrChild | PART | char | OPT | NONE |
| ||||
cVarianceCode | XTCR | char | OPT | NONE |
Future use | ||||
mnStandardUnits | OPUN | MATH_NUMERIC | OPT | NONE |
The standard units to produce a given amount of product. | ||||
mnStandardAmount | OPAT | MATH_NUMERIC | OPT | NONE |
The standard amount to produce a given amount of product. | ||||
mnActualUnits | CLUN | MATH_NUMERIC | OPT | NONE |
The actual units to produce a given amount of product. | ||||
mnActualAmount | CLAT | MATH_NUMERIC | OPT | NONE |
The actual amount to produce a given amount of product. | ||||
mnCurrentUnits | CCCU | MATH_NUMERIC | OPT | NONE |
The current units to produce a given amount of product. | ||||
mnCurrentAmount | CCCA | MATH_NUMERIC | OPT | NONE |
The current amount to produce a given amount of product. | ||||
mnPlannedUnits | PLUN | MATH_NUMERIC | OPT | NONE |
Future Use. | ||||
mnPlannedAmount | PLAT | MATH_NUMERIC | OPT | NONE |
The planned amount to produce a given amount of product. | ||||
mnCompletedUnits | CPUN | MATH_NUMERIC | OPT | NONE |
The units completed for the work order. | ||||
mnCompletedAmount | CPAT | MATH_NUMERIC | OPT | NONE |
The amount completed for the work order. | ||||
mnScrappedUnits | SLUN | MATH_NUMERIC | OPT | NONE |
The units scrapped for the work order. | ||||
mnScrappedAmount | SLAT | MATH_NUMERIC | OPT | NONE |
The amount scrapped for the work order. | ||||
mnCurrentUnaccountedUnits | CCUU | MATH_NUMERIC | OPT | NONE |
The current units reported but not yet posted to the general ledger. | ||||
mnCurrentUnaccountedAmount | CCUA | MATH_NUMERIC | OPT | NONE |
The current amount 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. | ||||
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
| ||||
szUnitOfMeasureAsInput | 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). | ||||
mnEngineeringVariance | ENGV | MATH_NUMERIC | OPT | NONE |
This field contains the posted engineering variance amount that is calculated by Variance Journal Entries (P31804) when run in Final mode.
| ||||
mnPlannedVariance | PLNV | MATH_NUMERIC | OPT | NONE |
This field contains the posted planned variance amount, calculated in the last run of P31804 (Final mode). It is equal to Planned amount -
| ||||
mnActualVariance | VACT | MATH_NUMERIC | OPT | NONE |
This field contains the posted actual variance amount that is calculated by Variance Journal Entries (P31804) when run in Final mode. The
| ||||
mnOtherVariance | OTHV | MATH_NUMERIC | OPT | NONE |
This field contains the posted other variance amount, which is calculated in the last run of Variance Journal Entries (P31804) when run in
| ||||
mnNetVariance | NETV | MATH_NUMERIC | OPT | NONE |
This field contains the posted Net variance amount, calculated in the last run of P31804 (Final mode). It is equal to Actual amount -
| ||||
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
| ||||
szErrorMsgID | 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
| ||||
szCacheJobNumber | JOBN | char | OPT | NONE |
The code that identifies the work station ID that executed a particular job. | ||||
mnWorkOrderQty | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
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
| ||||
mnWOConversionFactor | CONV | MATH_NUMERIC | OPT | NONE |
The factor that the system uses to convert one unit of measure to another unit of measure. | ||||
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
| ||||
idhCursor | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
cSuppressErrMsg | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnUnitsQuantityShipped | SOQS | MATH_NUMERIC | OPT | NONE |
The number of units committed for shipment in Sales Order Entry, using either the entered or the primary unit of measure defined for this
| ||||
mnStandardCost | STDC | MATH_NUMERIC | OPT | NONE |
The cost of the item as calculated by the Simulate Cost Rollup program (P30820) and updated by the Frozen Cost Update program
| ||||
cStandardCostingFlag | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
cUpdateStandard | 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. | ||||
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. | ||||
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. | ||||
cStoreDataPtr | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
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
| ||||
szWorkCenterBranch | WMCU | char | OPT | NONE |
This is the branch/plant to which the work center belongs and must exist in the business unit master (F0006) and branch plant constants file
| ||||
cFixedOrVariableQty | FORQ | char | OPT | NONE |
A code that indicates if the quantity per assembly for an item on the bill of material varies according to the quantity of the parent item
| ||||
mnPercentOfScrap | SCRP | MATH_NUMERIC | OPT | NONE |
The percentage of unusable component material that is created during the manufacture of a particular parent item.
During DRP/MPS/MRP
| ||||
cCostByWorkCenter | CWC | char | OPT | NONE |
A code, maintained in the Manufacturing Constants program (P3009), that indicates whether the system tracks cost variances for discrete
|
None |
None |