1.Functional Description
This business function will get all the Routing Master Records from the F3003 table for a given
Parent Item, Branch, Routing Type and Batch Quantity. It will also calculate labor/machine hours for the WO
quantity and check for Co/By products , Intermediates and Ingredients and then return data back to
the program.
1.1Purpose
This is to be used in the copy routine in routing program (P3112).
1.2Setup Notes and Prerequisites
The first time the function is called, pass a '1' in the Type parameter so the Request is not
released. To get the next value in the table, pass a '2' in the Type parameter. To release the request, pass
a '3' in the Type parameter.
1.3Special Logic
This is an exclusive function to be used by P3112
D3000620 - Calculate Intermediate Quantity
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
mnParentItem | KIT | MATH_NUMERIC | NONE | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
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
| ||||
szTypeRouting | TRT | char | NONE | NONE |
A user defined code (40/TR) that indicates the type of routing. You can define different types of routing instructions for different uses.
For
| ||||
mnBatchQuantity | BQTY | MATH_NUMERIC | NONE | NONE |
The quantity of finished units that you expect this bill of material or routing to produce. You can specify varying quantities of components
| ||||
mnOperationSequence | OPSQ | MATH_NUMERIC | NONE | NONE |
A number used to indicate an order of succession.
In routing instructions, a number that sequences the fabrication or assembly steps in the
| ||||
mnRunLaborHours | RUNL | MATH_NUMERIC | NONE | NONE |
The standard hours of labor that you expect to incur in the normal production of this item.
The run labor hours in the Routing Master table
| ||||
mnRunMachineHours | RUNM | MATH_NUMERIC | NONE | NONE |
The standard machine hours that you expect to incur in the normal production of this item. | ||||
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
| ||||
mnWorkOrderNumber | 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,
| ||||
jdAsOfDate | ASDE1 | JDEDATE | NONE | NONE |
The date used for effectivity checking. Enter a specific date to display documents (orders, bills of material, routings, as applicable) that are
| ||||
mnOrderQuantity | UORG | MATH_NUMERIC | NONE | NONE |
The quantity of units affected by this transaction. | ||||
mnOrderQtyWithShrinkage | TRQT | MATH_NUMERIC | NONE | NONE |
A value that represents the available quantity, which might consist of the on-hand balance minus commitments, reservations, and
| ||||
mnCostRunMachineHours | RUNM | MATH_NUMERIC | NONE | NONE |
The standard machine hours that you expect to incur in the normal production of this item. | ||||
mnCostRunLaborHours | RUNL | MATH_NUMERIC | NONE | NONE |
The standard hours of labor that you expect to incur in the normal production of this item.
The run labor hours in the Routing Master table
| ||||
szIntermediateUOM | 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,
| ||||
mnWorkIntermedQty | QNTY | MATH_NUMERIC | NONE | NONE |
The number of units that the system applies to the transaction. | ||||
mnIntermediateQty | IQTY | MATH_NUMERIC | NONE | NONE |
The quantity that will be invoiced for this Order Line. | ||||
cIntermediateFlag | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
szStandardUOMConversion | TFLA | char | NONE | NONE |
Allows you to bypass the item-specific unit of measure and use the standard unit of measure. Valid values are:
blank Use the item-specific
| ||||
cCheckPartsList | EV07 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
mnSetupCrewSize | SETC | MATH_NUMERIC | OPT | NONE |
The number of people who work in the specified work center or routing operation.
The system multiplies the Run Labor value in the Routing
| ||||
cTimeBasisCode | TIMB | char | OPT | NONE |
A user defined code (30/TB) that indicates how machine or labor hours are expressed for a product. Time basis codes identify the time
| ||||
mnCumYieldPct | CPYP | MATH_NUMERIC | OPT | NONE |
The cumulative planned output yield percent for a step. The system uses this value to adjust the operation step scrap percent for the
| ||||
mnNextCumYieldPct | CPYP | MATH_NUMERIC | OPT | NONE |
The cumulative planned output yield percent for a step. The system uses this value to adjust the operation step scrap percent for the
| ||||
szParentItemUOM | UOM1 | char | OPT | 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
| ||||
szRoutingUOM | 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). | ||||
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
| ||||
cSuppressErrorMessages | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. | ||||
szLineType | LNTY | char | OPT | NONE |
A code that controls how the system processes lines on a transaction. It controls the systems with which the transaction interfaces, such as
| ||||
cInventoryFlag | IVI | char | OPT | NONE |
A code that identifies the type of interface to the Inventory Management system. Valid values are:
Y The dollar or unit value of any activity
| ||||
cPotencyControl | OT1Y | char | OPT | NONE |
A code that indicates whether you control the item by potency. | ||||
mnStandardPotency | STDP | MATH_NUMERIC | OPT | NONE |
The percentage of active ingredients normally found in an item. |
B3000220 Calculate Machine Or Labor Hours | ||||
B3000330 Convert Time Basis Code to Quantity | ||||
B4000260 Line Type - Activity Rules | ||||
B4000520 Get Item UoM Conversion Factor |
F3002 Bill of Material Master File | ||||
F3111 Work Order Parts List | ||||
F4101 Item Master | ||||
F4102 Item Branch File |