1.Functional Description
1.1Purpose
This business function will create/update the Current Cost Variances (B1-XX) in the WO Variance table
(F3102) for a given Work Order and Cost Type.
1.2Setup Notes and Prerequisites
None.
1.3Special Logic
None.
2.Technical Specifications
2.4Processing
The following actions have to be performed by the Business Function.
1. Load ITM, MMCU, LOCN(=Blanks), LOTN(=Blanks), LEDG(='07') and COST into the keys for reading the
Cost Component table (F30026).
2. Read the row from the F30026 table using the above keys.
If row found,
Work CCCU = Input CCCU
Work CCCA = Input CCCA.
If IECOST = 'C1'/'C3'/'C4' and If Input CCCA = 0
Work CCCU = 0
Work CCCA = 0.
Endif
If Substr(IECOST,0,1) <> 'B'/'A'
Work CCCA = Input TRQT* IESTDC
Work CCCU = Input UORG.
Endif
Read F3102 table using Input DOCO,ITM and COST (=IECOST) as the key
If row found
IGCCCU = Work CCCU
IGCCCA = Work CCCA
Update F3102 row
Else
IGPART = 'P'
IGDOCO = Input DOCO
IGITM = Input ITM
IGLITM = Input LITM
IGAITM = Input AITM
IGUOM = Input UOM
IGCOST = IECOST
IGCCCU = Work CCCU
IGCCCA = Work CCCA
Load Audit information
Write F3102 row.
Endif
Returns:
If any errors occur, the function will return '1' in the Error Code field, and '0' if there are no
errors.
^
D3100440 - Update WO Current Cost Variance
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnDocumentNumber | DOCO | MATH_NUMERIC | NONE | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
mnShortItemNumber | ITM | MATH_NUMERIC | NONE | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
sz2ndItemNumber | LITM | char | NONE | NONE |
A number that identifies the item. The system provides three separate item numbers plus an extensive cross-reference capability to
| ||||
sz3rdItemNumber | AITM | char | NONE | NONE |
The system provides three separate item numbers plus an extensive cross-reference capability to alternate item numbers. These item
| ||||
szBranch | MMCU | char | NONE | 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
| ||||
szUnitOfMeasure | UOM | char | NONE | 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). | ||||
mnPrimaryOrderQty | TRQT | MATH_NUMERIC | NONE | NONE |
A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and
| ||||
mnOrderQuantity | UORG | MATH_NUMERIC | OPT | NONE |
The quantity of units affected by this transaction. | ||||
cErrorCode | ERRC | char | NONE | NONE |
This error code indicates if any errors occurred during the creation of the Trip Document Detail (F4914) records by the Delivery Document
| ||||
mnDirectLaborHours | CTS1 | MATH_NUMERIC | NONE | NONE |
The number of unaccounted direct labor hours associated with a specific operation for a work order. | ||||
mnDirectLaborCost | CTS4 | MATH_NUMERIC | NONE | NONE |
The amount of unaccounted direct labor associated with a specific operation for a work order. | ||||
mnSetupHours | CTS2 | MATH_NUMERIC | NONE | NONE |
The number of unaccounted setup labor hours associated with a specific operation for a work order. | ||||
mnSetupCost | CTS5 | MATH_NUMERIC | NONE | NONE |
The amount of unaccounted setup labor associated with a specific operation for a work order. | ||||
mnDirectMachineHours | CTS3 | MATH_NUMERIC | NONE | NONE |
The number of unaccounted machine hours associated with a specific operation for a work order. | ||||
mnDirectMachineCost | CTS6 | MATH_NUMERIC | NONE | NONE |
The amount of unaccounted machine dollars associated with a specific operation for a work order. | ||||
mnLaborEfficiencyCost | CTS4 | MATH_NUMERIC | NONE | NONE |
The amount of unaccounted direct labor associated with a specific operation for a work order. | ||||
mnFixedMachineOHCost | CTS5 | MATH_NUMERIC | NONE | NONE |
The amount of unaccounted setup labor associated with a specific operation for a work order. | ||||
mnVarMachineOHCost | CTS6 | MATH_NUMERIC | NONE | NONE |
The amount of unaccounted machine dollars associated with a specific operation for a work order. | ||||
mnFixedLaborOHHours | CTS1 | MATH_NUMERIC | NONE | NONE |
The number of unaccounted direct labor hours associated with a specific operation for a work order. | ||||
mnFixedLaborOHCost | CTS4 | MATH_NUMERIC | NONE | NONE |
The amount of unaccounted direct labor associated with a specific operation for a work order. | ||||
mnVarLaborOHHours | CTS1 | MATH_NUMERIC | NONE | NONE |
The number of unaccounted direct labor hours associated with a specific operation for a work order. | ||||
mnVarLaborOHCost | CTS4 | MATH_NUMERIC | NONE | NONE |
The amount of unaccounted direct labor associated with a specific operation for a work order. | ||||
szProgramID | PID | char | NONE | NONE |
The number that identifies the batch or interactive program (batch or interactive object). For example, the number of the Sales Order Entry
| ||||
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
| ||||
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
| ||||
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
|
B9800100 Get Audit Information |
F30026 Item Cost Component Add-Ons | ||||
F3102 Production Cost |