1.Functional Description
1.1Purpose
This business function will create/update the current cost variances for components in the WO
Variance table (F3102) for a given work order.
1.2Setup Notes and Prerequisites
None.
1.3Special Logic
None.
2.Technical Specifications
2.4Processing
The following actions will be performed by the business function:
Wk-TSCL = 0.
If EV01 (input) = ' '
Load the following fields for the Cost Component table: ITM = Input CPIT, MMCU - Input
CMCU,LOCN = blanks, LOTN = blanks, LEDG = '07'.
Do until there are no more records,
Read a row from the F30026 table using the above keys.
If row found,
Wk-TCSL = Wk-TCSL + IECSL
End If.
End Do.
Else
Load the following fields for the Variance table:DOCO = Input RORN,PART ='P'.
Do until there are no more records,
Read a row from the F3102 table using the above keys.
If row found and IGOPAT <> 0 and IGOPUN <> 0,
Wk-OPAT = IGOPAT/IGOPUN
Wk-TCSL = Wk-TCSL + Wk-OPAT
End If.
End Do.
End If.
If PBIN (input) = 'P',
Wk-LOTN = LOTN (input)
Else
Wk-LOTN = blanks
End If.
Call B4000520, Get Item UoM Conversion Factor, passing the following: IVI = 'Y', UOM = Input UM,
UOM1 = Input UOM1, Qty = 0, MCU = CMCU (input), LOTN = Wk-LOTN, OT1Y = Input IBOT1Y, STDP - Input STDP).
Return the conversion factor (Wk-MN29D9). Set the conversion factor to one if an error occurs.
Wk-CCCA = UORG (input) x Wk-TCSL
Wk-QNTY = UORG / MN29D9
Load the following fields: IGDOCO = Input DOCO and IGITM = Input CPIT
Read an F3102 row by the above keys.
If Found
Set IGOPAT, IGOPUN, IGCCCA, IGCCCU to zero.
End If
If RORN (input) <> ' ' and RORN <> 0 and STKT (input) = 'K' or if RORN (input) <> ' '
and RORN <> 0 and STKT (input) = 'C',
IGOPAT = IGOPAT + Wk-CCCA
IGOPUN = IGOPUN + Wk-QNTY
Else
IGCCCA = IGCCCA + Wk-CCCA
IGCCCU = IGCCCU + Wk=QNTY
End If.
CCCA (Output) = CCCA (Output) + Wk-CCCA
Wk-SCRP = Component Scrap SCRP (Input) x Wk-CSL
Scrap Percent SCRP (Output) = Scrap Percent SCRP (Output) + Wk-SCRP
Load audit information.
If found,
Update the row
Else
IGUOM = Input UM
IGPART = 'C'
IGDOCO = Input DOCO
IGITM = Input CPIT
IGLITM = Input CPIL
IGAITM = Input CPIA
Write a new row
End If.
If any errors occur, the function will return '1' in the Error Code field, and '0' if there are no
errors.
^
D3100980 - F3102 Write Curr Variance For Component
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cConfiguredWOFlag | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
mnComponentShortItem | CPIT | MATH_NUMERIC | NONE | NONE |
The short identifier for the component item number. | ||||
szComponent2ndItem | CPIL | char | NONE | NONE |
The system provides three separate item numbers.
They are:
1. Item Number (short) - An eight digit, computer assigned, completely
| ||||
szComponent3rdItem | CPIA | char | NONE | NONE |
The system provides three separate item numbers plus an extensive cross reference capability to alternate item numbers.
These item
| ||||
szComponentBranch | CMCU | char | NONE | NONE |
A secondary or lower-level business unit. The system uses the value that you enter to indicate that a branch or plant contains several
| ||||
szF4801RelatedOrderNumber | RORN | char | NONE | NONE |
A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order. This number is for
| ||||
cPrimaryBin | PBIN | char | NONE | NONE |
A code that indicates whether this is the primary or secondary location for this item within this stocking location. Valid values are:
P Primary
| ||||
szLotNumber | LOTN | char | NONE | NONE |
A number that identifies a lot or a serial number. A lot is a group of items with similar characteristics. | ||||
cStockingType | STKT | char | NONE | 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
| ||||
mnOrderNumber | 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,
| ||||
szUnitOfMeasure | UM | char | NONE | NONE |
A user defined code (00/UM) that identifies the unit of measurement for an amount or quantity. For example, it can represent a barrel, box,
| ||||
mnOperationOrderQty | UORG | MATH_NUMERIC | NONE | NONE |
The quantity of units affected by this transaction. | ||||
mnComponentScrapPercent | SCRP | MATH_NUMERIC | NONE | NONE |
The percentage of unusable component material that is created during the manufacture of a particular parent item.
During DRP/MPS/MRP
| ||||
mnCurrentAmount | CCCA | MATH_NUMERIC | NONE | NONE |
The current amount to produce a given amount of product. | ||||
mnScrapPercent | SCRP | MATH_NUMERIC | NONE | NONE |
The percentage of unusable component material that is created during the manufacture of a particular parent item.
During DRP/MPS/MRP
| ||||
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
| ||||
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
| ||||
szPrimaryUnitOfMeasure | UOM1 | char | NONE | NONE |
A user defined code (00/UM) that identifies the unit of measure that the system uses to express the quantity of an item, for example, EA
| ||||
cPotencyControl | OT1Y | char | NONE | NONE |
A code that indicates whether you control the item by potency. | ||||
mnStandardPotency | STDP | MATH_NUMERIC | NONE | NONE |
The percentage of active ingredients normally found in an item. | ||||
szF4211RelatedOrderNumber | RORN | char | NONE | NONE |
A number that identifies a secondary purchase order, sales order, or work order that is associated with the original order. This number is for
| ||||
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
| ||||
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
| ||||
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
|
B4000520 Get Item UoM Conversion Factor | ||||
B9800100 Get Audit Information |
F30026 Item Cost Component Add-Ons | ||||
F3102 Production Cost |