Work Order Header
The Work Order Header file contains the primary information associated with producing a finished good.
REFERENCED BY
WHD2.1 | IC01.1 |
IC02.1 | IC62.1 | IC62.4 | WH20.7 | WHD3.1 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
WOR-COMPANY Element: Company | Numeric 4 This field contains the company number, as defined in the Inventory Control system. |
|
||
WOR-LOCATION Element: Location | Alpha 5 This field contains a valid stock location within the company inventory. It is also the production facility where finished goods are produced. |
|
||
WOR-WORK-ORDER Element: Work Order | Numeric 8 This identifies the work order and may be automatically assigned or manually assigned, depending on the option defined for each production (inventory) location. |
|
||
WOR-WORK-ORDER-SUF Element: Work Order Suf | Numeric 2 This will normally be zero for a work order. If you chose to split a work order so the completed part of the finished goods can be available for allocation, the work order created for the remaining quantity will have a non-zero value in this field. |
|
||
WOR-ITEM Element: Item | Alpha 32 This field contains the item identifier of the finished good produced for the work order, as defined in the Inventory Control system. |
|
||
WOR-START-DATE Element: Start Date | Numeric 8 (yyyymmdd) This is the production start date for the work order. |
|
||
WOR-END-DATE Element: End Date | Numeric 8 (yyyymmdd) This is the production end date for the work order. |
|
||
WOR-EXP-DELIV-DT Element: Date | Numeric 8 (yyyymmdd) This is the date needed for the finished good. |
|
||
WOR-STATUS Element: Status | Numeric 1 The work order statuses indicate the progression of the work order through pre and post production stages. 1 = Unreleased 2 = Released 3 = Exploded 4 = In Production 8 = Canceled 9 = Completed |
|
||
WOR-PICK-FDBK-STAT Element: Pick Fdbk Stat | Numeric 1 Each picking feedback status indicates a stage within the picking feedback process. 0 = Picking Fdbk Not Started 1 = Picking Fdbk In Process 2 = Picking Fdbk Finished 3 = Picking Fdbk Complete |
|
||
WOR-PROD-FDBK-STAT Element: Prod Fdbk Stat | Numeric 1 Each production feedback status indicates a stage within the production feedback process for the work order. 0 = Production Fdbk Not Started 1 = Production Fdbk In Process 2 = Production Fdbk Finished 3 = Production Fdbk Completed |
|
||
WOR-WALK-THRU-REQ Element: Req Comments | Alpha 1 This field indicates that a transaction line is out of balance. For example, if lot, bin, or serial number quantities do not equal the transaction quantity, select the WalkThru form action to balance the transaction quantities. |
|
||
WOR-HOLD-CODE Element: Hold Code | Alpha 4 This is the offsite hold code which indicates if the work order is currently sent offsite during the production process to be performed by a vendor. |
|
||
WOR-PRINTED-FL Element: Printed Fl | Alpha 1 This flag indicates if this work order has been printed by the work order print program. Y = Yes " " = No |
|
||
WOR-PRTED-PL-FL Element: Prted Pl Fl | Alpha 1 This flag indicates if this work order has been printed by the work order pick list program. Y = Yes " " = No |
|
||
WOR-OPR-CODE Element: Opr Code | Alpha 10 (Lower Case) This field contains the operator code. This is the user ID of the person who last maintained this record. |
|
||
WOR-SYSTEM-CD Element: System Cd | Alpha 2 This field indicates on what system the transaction originated. OE = Order Entry RQ = Requisitions WO = Work Order |
|
||
WOR-DOC-NBR-NUM Element: Doc Nbr Num | Numeric 10 This is the order or requisition number when the work order is for a specific order or requisition. |
|
||
WOR-LINE-NBR Element: Line Nbr | Numeric 6 This field contains the line number of the order or requisition when the work order is for a specific order or requisition. |
|
||
WOR-ORIG-WORK-ORDR Element: Work Order | Numeric 8 This is the original work order that is being reversed by this work order. This field will only have a value on reverse work orders. |
|
||
WOR-ORIG-WO-SUF Element: Work Order Suf | Numeric 2 This is the suffix of original work order that is being reversed by this work order. This field will only have a value on reverse work orders. |
|
||
WOR-PLAN-QTY Element: Quantity | Signed 13.4 This field contains the planned quantity for the finished good being produced by this work order. |
|
||
WOR-ACTUAL-QTY Element: Quantity | Signed 13.4 This field contains the actual quantity of the finished good produced by this work order. |
|
||
WOR-DETAIL-QTY Element: Quantity | Signed 13.4 This field shows the total quantity of details defined for a detail tracked item. It is matched against the line quantity field to determine if details are in balance. |
|
||
WOR-SHRINK-QTY Element: Quantity | Signed 13.4 Shrinkage quantity is the difference between the total of the components and the total of the finished good when all components are in the same unit of measure as the finished good. This is a quantity that may be entered at production feedback and is for information only. |
|
||
WOR-EST-COMP-COST Element: Intl Cost | Signed 18.5 This is the total of the estimated costs for 'C' type components that will used to produce the finished goods. |
|
||
WOR-ACT-COMP-COST Element: Intl Cost | Signed 18.5 This is the total of actual component inventory costs for 'C' type components that were used (not wasted) to produce the finished goods. |
|
||
WOR-EST-PACK-COST Element: Intl Cost | Signed 18.5 This is the total of the estimated cost for packaging components that will be used for the finished goods. |
|
||
WOR-ACT-PACK-COST Element: Intl Cost | Signed 18.5 This is the total of the actual costs for packaging components that were used for the finished goods. |
|
||
WOR-EST-BRDN-COST Element: Intl Amt | Signed 18.2 This is the total estimated burden cost related to producing the finished goods. |
|
||
WOR-ACT-BRDN-COST Element: Intl Amt | Signed 18.2 This is the total actual burden cost related to producing the finished goods. |
|
||
WOR-FGV-AMOUNT Element: Intl Cost | Signed 18.5 The finished good variance amount is used only on reverse work orders. It is used when the cost of the finished good returned from inventory is not the same as the cost of producing the finished good on the original work order. This field will contain the difference, which will post to the variance account set up for the finished good. |
|
||
WOR-VENDOR Element: Vendor | Alpha 9 (Right Justified) This is the identification code of the vendor that is currently doing all or part of the production process while the work order is on offsite hold. |
|
||
WOR-OFFSITE-DATE Element: Date | Numeric 8 (yyyymmdd) This is the date that the work order was sent offsite if it is currently on offsite hold. |
|
||
WOR-RETURNED-DATE Element: Date | Numeric 8 (yyyymmdd) This is the date the work order was returned from a vendor performing a process that had placed the work order on offsite hold. |
|
||
WOR-REVERSED-BY-WO Element: Work Order | Numeric 8 This is the number of the work order that reverses this work order. |
|
||
WOR-WF-PROD-FL Element: All Flag | Alpha 1 The Workflow Management system production flag is set to Yes when the work order is in the production process. Y = Yes N = No |
|
||
WOR-WF-OFFSITE-FL Element: All Flag | Alpha 1 The Workflow Management system offsite flag is set to Yes when the work order is in the offsite production process. Y = Yes N = No |
|
||
WOR-LAST-COMP-SEQ Element: Seq | Numeric 3 This is the last sequence number used for components added to the work order item file for this work order. |
|
||
WOR-LAST-BRDN-SEQ Element: Seq | Numeric 3 This is the last sequence used for burdens added to this work order. |
|
||
WOR-LAST-BYPRO-SEQ Element: Seq | Numeric 3 This is the last sequence number used for byproducts added to this work order. |
|
||
WOR-WO-ALPHA Element: Wo Alpha | Derived The system displays a group field that contains work order (WORK-ORDER) and work order suffix (WORK-ORDER-SUF). |
|
||
WOR-DISP-DOC Element: Disp Doc | Derived The system displays a conditional field that contains a label stating that it is a customer order or requisition if the system code (SYSTEM-CD) is Order Entry or Requisition. |
|
||
WOR-EST-FG-COST Element: Est Fg Cost | Derived The system displays the result of estimated component cost + estimated packaging cost + estimated burden cost (computed as EST-COMP-COST + EST-PACK-COST + EST-BRDN-COST). |
|
||
WOR-ACT-FG-COST Element: Act Fg Cost | Derived The system displays the result of actual component cost + actual packaging cost + actual burden cost (computed as ACT-COMP-COST + ACT-PACK-COST + ACT-BRDN-COST). |
|
||
WOR-WO-USER-FLD-1 Element: User | Alpha 10 (Lower Case) This field contains user-defined data and can be used to cross reference work order numbers. |
|
||
WOR-WO-USER-FLD-2 Element: User Fld3 | Alpha 15 (Lower Case) This field contains user-defined information. |
|
||
WOR-WO-USER-DATE-1 Element: Date | Numeric 8 (yyyymmdd) This field contains user-defined dates. |
|
||
WOR-BA-ACCT-UNIT Element: Ba Acct Unit | Alpha 15 This field identifies the burden absorption account unit to record burden expenses associated with a production facility. |
|
||
WOR-BA-ACCOUNT Element: Ba Account | Numeric 6 This field identifies the burden absorption account to record burden expenses associated with a production facility. |
|
||
WOR-BA-SUB-ACCT Element: Ba Sub Acct | Numeric 4 This field identifies the burden absorption subaccount to record burden expenses associated with a production facility. |
|
||
WOR-PC-ACCT-UNIT Element: Pc Acct Unit | Alpha 15 This field identifies the production credit account unit to record credit to a production facility for finished goods produced. |
|
||
WOR-PC-ACCOUNT Element: Pc Account | Numeric 6 This field identifies the production credit account to record credit to a production facility for finished goods produced. |
|
||
WOR-PC-SUB-ACCT Element: Pc Sub Acct | Numeric 4 This field identifies the production credit subaccount to record credit to a production facility for finished goods produced. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
WORSET1 |
COMPANY LOCATION WORK-ORDER WORK-ORDER-SUF |
|
| |||||||||||||
WORSET2 |
COMPANY LOCATION STATUS WORK-ORDER WORK-ORDER-SUF |
|
| |||||||||||||
WORSET3 |
COMPANY LOCATION STATUS START-DATE WORK-ORDER WORK-ORDER-SUF |
|
||||||||||||||
WORSET4 |
COMPANY LOCATION ITEM WORK-ORDER* WORK-ORDER-SUF |
|
| |||||||||||||
WORSET5 |
COMPANY LOCATION END-DATE WORK-ORDER WORK-ORDER-SUF |
|
||||||||||||||
WORSET7 |
COMPANY LOCATION WO-USER-FLD-1 WORK-ORDER WORK-ORDER-SUF |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Apcompany | APCOMPANY |
Not Required
| ||||||||||||||||||
Apvenmast | APVENMAST |
Not Required
| ||||||||||||||||||
Arcomp | ARCOMP |
Required
| ||||||||||||||||||
Custorder | CUSTORDER |
Required
| ||||||||||||||||||
Holdcodes | HOLDCODES |
Required
| ||||||||||||||||||
Iccompany | ICCOMPANY |
Required
| ||||||||||||||||||
Iclocation | ICLOCATION |
Required
| ||||||||||||||||||
Itemloc | ITEMLOC |
Required
| ||||||||||||||||||
Itemmast | ITEMMAST |
Not Required
| ||||||||||||||||||
Reqheader | REQHEADER |
Required
| ||||||||||||||||||
Woworuf | WOWORUF |
Not Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Bin Details | WODETAIL |
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Items By Loc | WOITEM |
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Lot Details | WODETAIL |
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Serial Details | WODETAIL |
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Uom Details | WODETAIL |
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Whdemand | WHDEMAND |
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Whsupply | WHDEMAND |
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Wobyprod | WOBYPROD |
Delete Restricted
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Wocomp | WOITEM |
Delete Restricted
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Wodetail | WODETAIL |
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Woitem | WOITEM |
|
All trademarks and registered trademarks are the property of their
respective owners.