1.Functional Description
1.1Purpose
This business function will add a new row to the Shop Floor Control Routing Instructions table
(F3112) based on the input parameters.
1.2Setup Notes and Prerequisites
None.
1.3Special Logic
None
2.Technical Specifications
2.4Processing
Call business function B9800100, Get Audit Information, to retrieve the User ID, Work Station ID,
Date, and Time.
Using the input parameters and the audit information, write a new row to the Shop Floor Control
Routing Instructions table (F3112).
If an error occurs, return '1' as the error code; else, return '0'.
^
D3101000 - Write Routing Instruction Row
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
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,
| ||||
szOrderType | DCTO | char | NONE | 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
| ||||
szSuffixNumber | SFXO | char | NONE | 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
| ||||
szRoutingType | 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
| ||||
mnParentItemNumber | KIT | MATH_NUMERIC | NONE | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
szParent2ndItemNumber | KITL | char | NONE | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
szParent3rdItemNumber | KITA | char | NONE | NONE |
The system provides three separate item numbers:
1. Item Number (short) - An eight-digit, computer assigned, completely non-significant
| ||||
szWorkCenter | 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
| ||||
szLineIdentifier | LINE | char | NONE | NONE |
A number that defines a production line or cell. Detailed work center operations can be defined inside the line or cell. | ||||
szBusinessUnit | MCU | char | NONE | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
szAutoLoadDescription | ALD | char | NONE | NONE |
This field is used to pull in a standard description from a user defined for the specified operation. | ||||
szDescriptionLine1 | DSC1 | char | NONE | NONE |
Brief information about an item; a remark or an explanation. | ||||
mnOperationSequenceNo | 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
| ||||
szOperationCodeType | OPSC | char | NONE | NONE |
A user defined code (30/OT) that indicates the type of operation. Valid values include: A Alternate routing TT Travel time IT Idle time T Text | ||||
szOperationStatusCodeWO | OPST | char | NONE | NONE |
User defined code system 31, type OS. The operation status code that identifies the current status of a work order or engineering change
| ||||
szInspectionCode | INPE | char | NONE | NONE |
Future use. This is a user defined code specifying the type of normal inspection practice for this particular item. Examples that could be
| ||||
cTimeBasisCode | TIMB | char | NONE | 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
| ||||
cLaborOrMachine | LAMC | char | NONE | NONE |
A code to designate whether the operation is labor or machine. | ||||
cPayPointCode | BFPF | char | NONE | NONE |
A code that indicates whether a work center has labor, material, or both,backflushed through it when quantities are reported against
| ||||
cPayPointStatus | PPRF | char | NONE | NONE |
A code that indicates whether the operation should be taken to a status of complete or partially complete. Valid values are:
Blank Not
| ||||
szJobCode | JBCD | char | NONE | NONE |
A user defined code (07/G) that defines the jobs within your organization. You can associate pay and benefit information with a job type and
| ||||
mnAddressNumber | AN8 | MATH_NUMERIC | NONE | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
mnCriticalRatio | CRTR | MATH_NUMERIC | NONE | NONE |
Reserved by J.D. Edwards. | ||||
mnSlackTimeRatio | SLTR | MATH_NUMERIC | NONE | NONE |
Reserved by J.D. Edwards. | ||||
jdOrderDate | TRDJ | JDEDATE | NONE | NONE |
The date that an order was entered into the system. This date determines which effective level the system uses for inventory pricing. | ||||
jdRequestedDate | DRQJ | JDEDATE | NONE | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
jdStartDate | STRT | JDEDATE | NONE | NONE |
The start date for the order. You can enter this date manually, or have the system calculate it using a backscheduling routine. The routine
| ||||
jdCompletionDate | STRX | JDEDATE | NONE | NONE |
The date that the work order or engineering change order is completed or canceled. | ||||
mnBeginningTime | PBTM | MATH_NUMERIC | NONE | NONE |
A field that is used to enter the beginning time of the operation sequence for the work center operation on the routing. | ||||
mnEndingTime | PETM | MATH_NUMERIC | NONE | NONE |
A field that is used to enter the ending time of the operation sequence for the work center operation on the routing. | ||||
cRequestedShift | RSFT | char | NONE | NONE |
cStartShift | SSFT | char | NONE | NONE |
cCompletionShift | CSFT | char | NONE | NONE |
mnLeadtimeOverlapPercent | LTPC | MATH_NUMERIC | NONE | NONE |
Future use This field is used to modify the normal logic in the backscheduling routine. If operation number 010 starts on day one and is
| ||||
mnPercentOverlap | POVR | MATH_NUMERIC | NONE | NONE |
A number that indicates the percentage that successive operations can overlap.
The actual overlap percentage entered for the operation
| ||||
mnOpPlannedYieldPercent | OPYP | MATH_NUMERIC | NONE | NONE |
The planned output yield percent for a step. The Planned Yield Update program uses this value to update the cumulative percent in the
| ||||
mnCumPlannedYieldPercent | CPYP | MATH_NUMERIC | NONE | NONE |
The cumulative planned output yield percent for a step. The system uses this value to adjust the operation step scrap percent for the
| ||||
mnNextOperationSequenceNo | NXOP | MATH_NUMERIC | NONE | NONE |
The operation number with which the current operation can be simultaneously processed. | ||||
mnCrewSize | SETC | MATH_NUMERIC | NONE | 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
| ||||
mnMoveHours | MOVD | MATH_NUMERIC | NONE | NONE |
The planned hours that are required to move the order from this operation to the next operation in the same work center.
If the Routing
| ||||
mnQueueHours | QUED | MATH_NUMERIC | NONE | NONE |
The total hours that an order is expected to be in queue at work centers and moving between work centers.
The system stores this value in
| ||||
mnStandardRunMachine | RUNM | MATH_NUMERIC | NONE | NONE |
The standard machine hours that you expect to incur in the normal production of this item. | ||||
mnStandardRunLabor | 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
| ||||
mnStandardSetupHours | SETL | MATH_NUMERIC | NONE | NONE |
The standard setup hours that you expect to incur in the normal completion of this item. This value is not affected by crew size. | ||||
mnActualRunMachine | MACA | MATH_NUMERIC | NONE | NONE |
This is the actual machine time in hours recorded against the work order. | ||||
mnActualRunLabor | LABA | MATH_NUMERIC | NONE | NONE |
This is the actual labor time in hours recorded for the work order. | ||||
mnActualSetupHours | SETA | MATH_NUMERIC | NONE | NONE |
The actual time in hours of setup labor recorded against the work order operation. | ||||
mnShrinkageFactor | OPSR | MATH_NUMERIC | NONE | NONE |
Future use. This field indicates the percentage of scrap that is typically encountered for this operation for this part. If the quantity ordered is
| ||||
mnOrderQuantity | UORG | MATH_NUMERIC | NONE | NONE |
The quantity of units affected by this transaction. | ||||
mnQuantityCancelel | SOCN | MATH_NUMERIC | NONE | NONE |
The number of units canceled in Sales Order or Work Order Processing, using either the entered or the primary unit of measure defined for
| ||||
mnQuantityShipped | SOQS | MATH_NUMERIC | NONE | 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
| ||||
mnQuantityAtOperation | QMTO | MATH_NUMERIC | NONE | NONE |
The quantity that is physically at the step at the work center. | ||||
mnPieceworkRate | PWRT | MATH_NUMERIC | NONE | NONE |
The rate to be paid for the type of component (piece) being produced. | ||||
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). | ||||
mnUnaccountedDirLaborHrs | CTS1 | MATH_NUMERIC | NONE | NONE |
The number of unaccounted direct labor hours associated with a specific operation for a work order. | ||||
mnUnaccountedDirSetupLaborHrs | CTS2 | MATH_NUMERIC | NONE | NONE |
The number of unaccounted setup labor hours associated with a specific operation for a work order. | ||||
mnUnaccountedMachineHours | CTS3 | MATH_NUMERIC | NONE | NONE |
The number of unaccounted machine hours associated with a specific operation for a work order. | ||||
mnUnaccountedDirectLaborAmt | CTS4 | MATH_NUMERIC | NONE | NONE |
The amount of unaccounted direct labor associated with a specific operation for a work order. | ||||
mnUnaccountedDirSetupLaborAmt | CTS5 | MATH_NUMERIC | NONE | NONE |
The amount of unaccounted setup labor associated with a specific operation for a work order. | ||||
mnUnaccountedMachineAmt | CTS6 | MATH_NUMERIC | NONE | NONE |
The amount of unaccounted machine dollars associated with a specific operation for a work order. | ||||
szUnitNumber | APID | char | NONE | NONE |
A 12-character alphanumeric code used as an alternate identification number for an asset. This number is not required, nor does the
| ||||
szMessageNumber | SHNO | char | NONE | NONE |
A generic rates and message code (48/SN) that is assigned to a standard note, message, or general narrative explanation. You can use
| ||||
szProjectCostCenter | OMCU | char | NONE | NONE |
The business unit from an account number. The account number business unit is usually found in the data item MCU, however, Distribution
| ||||
szObject | OBJ | char | NONE | NONE |
The portion of a general ledger account that refers to the division of the Cost Code (for example, labor, materials, and equipment) into
| ||||
szSubsidiary | SUB | char | NONE | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
mnPrimarySupplier | VEND | MATH_NUMERIC | NONE | NONE |
The address book number of the preferred provider of this item. | ||||
szRelatedKeyCompany | RKCO | char | NONE | NONE |
The key company that is associated with the document number of the related order. | ||||
szRelatedOrderNumber | 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
| ||||
szRelatedOrderType | RCTO | char | NONE | NONE |
A user defined code (system 00, type DT) that indicates the document type of the secondary or related order. For example, a purchase
| ||||
mnRelatedLineNo | RLLN | MATH_NUMERIC | NONE | NONE |
A number of the detail line on the related order for which the current order was created. For example, on a purchase order created to fill
| ||||
szDocumentType | DCT | char | NONE | NONE |
A user defined code (00/DT) that identifies the origin and purpose of the transaction. PeopleSoft reserves several prefixes for document
| ||||
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
|
B9800100 Get Audit Information |
F3112 Work Order Routing |