1.1Purpose
Read record(s) from F3112 and F31172 (Join on DOCO). Records can be fetched by keys from F3112 and can be read sequentially.
1.2Setup Notes and Prerequisites
If Action Code = 2 has been used, a call with Action Code = 3 needs to be done to close all tables and free memory.
1.3Special Logic
If Action Code = 1 Then Fetch F3112 and F31172 using keys. If Sequential Fetch = 1 save Table Ptr.
If Action Code = 2 Then Fetch F3112 and F31172 using keys, and do not close tables.
If Action Code = 3 Then Retrieve Table Ptr ,Close Tables and Free Memory.
D1701450 - F3112 Get S/WM Routing Data Extended
Parameter Name | Data Item | Data Type | Req/Opt | I/O/Both |
---|---|---|---|---|
cActionCode | ACTN | char | OPT | NONE |
A code that specifies the action that is performed. Valid values are: A Add C Change | ||||
cSuppressErrorMessage | SUPPS | char | OPT | NONE |
A flag indicating whether or not runtime error messaging will occur when an error message is issued from a business function.
0 = allow
| ||||
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
| ||||
idTablePtr | GENLNG | ID | OPT | NONE |
General purpose ID variable. | ||||
mnF3112Index | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. | ||||
mnF3112NumberOfKeys | MATH01 | MATH_NUMERIC | OPT | NONE |
- - - Good Performance Low Value. | ||||
mnF3112OrderNumber | DOCO | MATH_NUMERIC | OPT | NONE |
A number that identifies an original document. This document can be a voucher, a sales order, an invoice, unapplied cash, a journal entry,
| ||||
mnF3112OperationSequence | 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
| ||||
szF3112OperationType | OPSC | char | OPT | 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 | ||||
szF3112WorkCenter | MCU | char | OPT | NONE |
An alphanumeric code that identifies a separate entity within a business for which you want to track costs. For example, a business unit
| ||||
jdF3112DateRequested | DRQJ | JDEDATE | OPT | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
szF3112BranchPlant | MMCU | char | OPT | 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
| ||||
mnF3112AddressNumber | AN8 | MATH_NUMERIC | OPT | NONE |
A number that identifies an entry in the Address Book system, such as employee, applicant, participant, customer, supplier, tenant, or
| ||||
jdF3112StartDate | STRT | JDEDATE | OPT | 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
| ||||
mnF3112ParentItemNumber | KIT | MATH_NUMERIC | OPT | NONE |
The system provides for three separate item numbers.
1. Item Number (short) - An eight-digit, computer assigned, completely
| ||||
szF3112DescriptionLine1 | DSC1 | char | OPT | NONE |
Brief information about an item; a remark or an explanation. | ||||
mnF3112RunLaborStd | RUNL | MATH_NUMERIC | OPT | 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
| ||||
cF31172BillableYN | BILL | char | OPT | NONE |
Specifies whether a general ledger account should be billed. Valid codes are:
Y Yes, the account should be billed.
N No, it should not be
| ||||
mnF31172EstimatedAmount | EBILL | MATH_NUMERIC | OPT | NONE |
mnF31172EstimatedBillableRate | ESRTB | MATH_NUMERIC | OPT | NONE |
The estimated billable rate associated with a service. | ||||
mnF31172PercentCovered | PCOVR | MATH_NUMERIC | OPT | NONE |
The percentage covered under warranty or contract. This is used to calculate the amount to bill or the amount to cost for the line item being
| ||||
cSequentialFetch | EV01 | char | OPT | NONE |
An option that specifies the type of processing for an event. |
None |
F3112 Work Order Routing | ||||
F31172 Routing Instructions - Extension |