D3100310 - Get Work Order Data I
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,
| ||||
idF4801Pointer | GENLNG | ID | NONE | NONE |
General purpose ID variable. | ||||
cSuppressErrorMessages | 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
| ||||
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
| ||||
szParentOrderNumber | PARS | char | NONE | NONE |
A number that identifies the parent work order. You can use this number to do the following:
o Enter default values for new work orders,
| ||||
cType | TYPS | char | NONE | NONE |
A user defined code (00/TY) that indicates the classification of a work order or engineering change order.
You can use work order type as a
| ||||
cPriority | PRTS | char | NONE | NONE |
A user defined code (00/PR) that indicates the relative priority of a work order or engineering change order in relation to other orders.
A
| ||||
szDescription1 | DL01 | char | NONE | NONE |
A user defined name or remark. | ||||
szCompany | CO | char | NONE | NONE |
A code that identifies a specific organization, fund, or other reporting entity. The company code must already exist in the Company
| ||||
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
| ||||
szBranch | MMCU | char | NONE | NONE |
| ||||
szStatus | SRST | char | NONE | NONE |
A user defined code (00/SS) that describes the status of a work order, rate schedule, or engineering change order. Any status change from
| ||||
szSubsidiary | SUB | char | NONE | NONE |
A subset of an object account. Subsidiary accounts include detailed records of the accounting activity for an object account. | ||||
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. | ||||
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
| ||||
jdRequestedDate | DRQJ | JDEDATE | NONE | NONE |
The date that an item is scheduled to arrive or that an action is scheduled for completion. | ||||
jdPlannedCompletionDate | DPL | JDEDATE | NONE | NONE |
The date that the work order or engineering change order is planned to be completed. | ||||
jdCompletionDate | STRX | JDEDATE | NONE | NONE |
The date that the work order or engineering change order is completed or canceled. | ||||
szPhase | WR01 | char | NONE | NONE |
A user defined code (00/W1) that indicates the current stage or phase of development for a work order. You can assign a work order to only
| ||||
szCategory02 | WR02 | char | NONE | NONE |
A user defined code (00/W2) that indicates the type or category of a work order.
Note: A processing option for some forms lets you enter a
| ||||
szCategory03 | WR03 | char | NONE | NONE |
A user defined code (00/W3) that indicates the type or category of the work order.
Note: A processing option for some forms allows you to
| ||||
szReference | VR01 | char | NONE | NONE |
An alphanumeric value used as a cross-reference or secondary reference number. Typically, this is the customer number, supplier
| ||||
mnItemNumberShort | ITM | MATH_NUMERIC | NONE | NONE |
An inventory item number. The system provides three separate item numbers plus an extensive cross-reference capability to other item
| ||||
cWOPickListPrinted | SHTY | char | NONE | NONE |
A code to designate whether or not the Work Order Pick List has been printed for a Work Order. If a 1 is in this code, the Work Order Pick
| ||||
mnQuantity | UORG | MATH_NUMERIC | NONE | NONE |
The quantity of units affected by this transaction. | ||||
mnQuantityCancelled | 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
| ||||
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). | ||||
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
| ||||
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. | ||||
szTypeBill | TBM | char | NONE | NONE |
A user defined code (40/TB) that designates the type of bill of material. You can define different types of bills of material for different uses.
| ||||
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
| ||||
szOrderSuffix | 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
| ||||
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
| ||||
cVarianceFlag | PPFG | char | NONE | NONE |
A 1 in this field indicates that this work order has had work order activity run against it in update mode. A 2 in this field indicates that this work
| ||||
mnOriginatorAddressNo | ANO | MATH_NUMERIC | NONE | NONE |
The address book number of the person who originated the change request. The system verifies this number against the Address Book. | ||||
mnSupervisorAddressNumber | ANPA | MATH_NUMERIC | NONE | NONE |
The address book number of the supervisor. | ||||
mnInspectorAddressNumber | ANT | MATH_NUMERIC | NONE | NONE |
The address book number of the inspector. | ||||
mnManagerAddressNumber | ANSA | MATH_NUMERIC | NONE | NONE |
The address book number of a manager or planner.
Note: A processing option for some forms allows you to enter a default value for this
| ||||
mnAssignedToAddressNumber | ANP | MATH_NUMERIC | NONE | NONE |
The address book number of the person assigned to do the work. | ||||
mnDistributionBillingRate | BRT | MATH_NUMERIC | NONE | NONE |
A rate that the system uses to mark up the revenue amount reflected in the billing of professional services such as draftsmen, engineers, or
| ||||
szCategory04 | WR04 | char | NONE | NONE |
A user defined code (00/W4) that indicates the type or category of the work order. | ||||
szCategory05 | WR05 | char | NONE | NONE |
A user defined code (00/W5) that indicates the type or category of the work order. | ||||
szPayType | PAYT | char | NONE | NONE |
A code to define the type of pay, deduction, benefit or accrual.
Pay types are numbered from 1 to 999 Deductions and benefits from 1000 to
| ||||
szWOStatusComment | STCM | char | NONE | NONE |
A brief description to explain the status of the work order. | ||||
szLocation | LOCN | char | OPT | NONE |
The storage location from which goods will be moved. | ||||
mnLineNumber | LNID | MATH_NUMERIC | OPT | NONE |
A number that identifies multiple occurrences, such as line numbers on a purchase order or other document. Generally, the system assigns
|
None |
F4801 Work Order Master File |