1.Functional Description
1.1Purpose
This function is used to obtain data from the F3112 table for its calling
program. The function will return error codes necessary.
1.2Setup Notes and Prerequisites
In order to shorten the processing time, the table will be kept open until
the request is released. The Mode must as follows.
1. The first time the function is called, the Mode must be set to '1' in
Order to Open the Table.
2. To read and select records in the table, the Mode must be '2'.
3. To get the next row in the table, the Mode must be '3'
4. To kill the Request, the Mode must be set to '4'.
Note: The user must supply GENLNG type variables to hold the hRequest in
all Modes and F3112 Pointer during all Modes '2', '3' and '4'.
1.3Special Logic
If the Input Mode is '1', Open the table and Store the Request in
parameters.
If Mode is '2', the rows will be selected and read sequentially and if a
record is found, the F3112 Pointer will be stored.
If the Mode is '3', the next row will be read. If a record is not found,
the F3112 Pointer is released.
If the Mode is '4', Kill and Release the request.
If the DoNotReturnOutputPtr is '1' then DO NOT Allocate memory and return
the Output Pointer(GENLN3)
2.Technical Specifications
2.4Processing
The following actions have to be performed by the Business Function.
1. If Mode = '1'
Open the F3111 table and Store the RequestID & User in Global
Variables
If Unable to Open the Request
Kill Request, Set Error Code to '1'
Endif
Endif
2. If Mode = '2' or '3'
If Mode = '2'
Read Routing Instructions Table (F3112) Sequentially in
either ascending or descending order, depending upon the
input parameter, using the appropriate key(s).
If record is found, return F3112 Pointer.
Else if Mode = '3'
Read Next Routing Instructions Table (F3112) Sequentially
using the appropriate key(s).
If record is found then
Return F3112 Pointer.
Else
Free Memory allocated for F3112 Pointer
Endif
Endif
If Record is found, assign values to output parameters, and
allocate memory and return the Output Pointer if the DoNotReturnOutputPtr is not
'1'.
If not found
Error Code = 2
Clear all Output fields
Break and Exit the Subroutine
Endif
Endif
3. If Mode = 4
If Memory for F3112 Pointer has not been freed, Free it now.
Release and Kill the Request
Endif
D3100870 - Retrieve Routing Instructions for an Order Number
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,
| ||||
mnParentItemNumber | KIT | MATH_NUMERIC | NONE | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
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
| ||||
szRelatedKeyCompany | RKCO | char | NONE | NONE |
The key company that is associated with the document number of the related order. | ||||
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
| ||||
jdRequested | DRQJ | JDEDATE | NONE | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
mnRunLaborActual | LABA | MATH_NUMERIC | NONE | NONE |
This is the actual labor time in hours recorded for the work order. | ||||
mnSetupLaborActual | SETA | MATH_NUMERIC | NONE | NONE |
The actual time in hours of setup labor recorded against the work order operation. | ||||
mnMachineLaborActual | MACA | MATH_NUMERIC | NONE | NONE |
This is the actual machine time in hours recorded against the work order. | ||||
idF3112Ptr | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
cMode | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
cSuppressErrorMessage | EV02 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
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
| ||||
szErrorMessageID | DTAI | char | NONE | 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
| ||||
idhRequestF3112 | GENLN2 | ID | NONE | NONE |
General purpose ID variable. | ||||
cSortOperationSequence | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. | ||||
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
| ||||
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 | ||||
szCostCenter | 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
| ||||
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
| ||||
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
| ||||
mnRunMachineHours | RUNM | MATH_NUMERIC | NONE | NONE |
The standard machine hours that you expect to incur in the normal production of this item. | ||||
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
| ||||
mnSetupLaborHours | 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. | ||||
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
| ||||
idF3112PointerForOutput | GENLN3 | ID | NONE | NONE |
General purpose ID variable. | ||||
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
| ||||
cDoNotReturnOutputPtr | EV01 | char | NONE | NONE |
An option that specifies the type of processing for an event. |
None |
F3112 Work Order Routing |