WORDER

Work Order Header

The Work Order Header file contains the primary information associated with producing a finished good.

REFERENCED BY
WHD2.1 IC01.1


UPDATED BY
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
WH20.7
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.
WH20.7
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.
WH20.7
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.


WORDER FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WORSET1 COMPANY
LOCATION
WORK-ORDER
WORK-ORDER-SUF
IC01.1 WH20.7
WHD2.1 WHD3.1
WORSET2 COMPANY
LOCATION
STATUS
WORK-ORDER
WORK-ORDER-SUF
KeyChange
IC02.1
WORSET3 COMPANY
LOCATION
STATUS
START-DATE
WORK-ORDER
WORK-ORDER-SUF
KeyChange
WORSET4 COMPANY
LOCATION
ITEM
WORK-ORDER*
WORK-ORDER-SUF
KeyChange
IC62.1 IC62.4
WORSET5 COMPANY
LOCATION
END-DATE
WORK-ORDER
WORK-ORDER-SUF
KeyChange
WORSET7 COMPANY
LOCATION
WO-USER-FLD-1
WORK-ORDER
WORK-ORDER-SUF
KeyChange, Subset
WhereWO-USER-FLD-1 !=Spaces


WORDER FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Not Required
Valid When WOR-VENDOR !=Spaces
WOR-COMPANY->-COMPANY
Apvenmast APVENMAST Not Required
Valid When WOR-VENDOR !=Spaces
CPY-VENDOR-GROUP->VEN-VENDOR-GROUP
WOR-VENDOR->VEN-VENDOR
Arcomp ARCOMP Required
WOR-COMPANY->ACO-COMPANY
Custorder CUSTORDER Required
When WOR-SYSTEM-CD ="OE"
AndWOR-DOC-NBR-NUM !=Zeroes
WOR-COMPANY->COR-COMPANY
WOR-DOC-NBR-NUM->COR-ORDER-NBR
Holdcodes HOLDCODES Required
When WOR-HOLD-CODE !=Spaces
ACO-CUST-GROUP->HDD-CUST-GROUP
WOR-HOLD-CODE->HDD-HOLD-CODE
Iccompany ICCOMPANY Required
WOR-COMPANY->ICC-COMPANY
Iclocation ICLOCATION Required
WOR-COMPANY->ICL-COMPANY
WOR-LOCATION->ICL-LOCATION
Itemloc ITEMLOC Required
WOR-COMPANY->ITL-COMPANY
WOR-LOCATION->ITL-LOCATION
WOR-ITEM->ITL-ITEM
Itemmast ITEMMAST Not Required
ICC-ITEM-GROUP->ITE-ITEM-GROUP
WOR-ITEM->ITE-ITEM
Reqheader REQHEADER Required
When WOR-SYSTEM-CD ="RQ"
AndWOR-DOC-NBR-NUM !=Zeroes
WOR-COMPANY->RQH-COMPANY
WOR-DOC-NBR-NUM->RQH-REQ-NUMBER
Woworuf WOWORUF Not Required
WOR-COMPANY->WRU-COMPANY
WOR-LOCATION->WRU-LOCATION
WOR-WORK-ORDER->WRU-WORK-ORDER
WOR-WORK-ORDER-SUF->WRU-WORK-ORDER-SUF


WORDER FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Bin Details WODETAIL
Valid When ITE-LOT-TRACK-FL ="N"
AndITE-SER-TRACK-FL ="N"
AndITL-BIN-TRACK-FL ="Y"
WOR-COMPANY->WOD-COMPANY
WOR-LOCATION->WOD-LOCATION
WOR-WORK-ORDER->WOD-WORK-ORDER
WOR-WORK-ORDER-SUF->WOD-WORK-ORDER-SUF
"F"->WOD-DETAIL-TYPE
Zeroes->WOD-COMPONENT-SEQ
  WOD-BIN
  WOD-LOT
  WOD-SUBLOT
  WOD-SERIAL
  WOD-UOM
Items By Loc WOITEM
WOR-COMPANY->WOI-COMPANY
WOR-LOCATION->WOI-LOCATION
WOR-WORK-ORDER->WOI-WORK-ORDER
WOR-WORK-ORDER-SUF->WOI-WORK-ORDER-SUF
  WOI-INV-LOCATION
  WOI-COMPONENT-SEQ
Lot Details WODETAIL
Valid When ITE-LOT-TRACK-FL ="Y"
WOR-COMPANY->WOD-COMPANY
WOR-LOCATION->WOD-LOCATION
WOR-WORK-ORDER->WOD-WORK-ORDER
WOR-WORK-ORDER-SUF->WOD-WORK-ORDER-SUF
"F"->WOD-DETAIL-TYPE
Zeroes->WOD-COMPONENT-SEQ
  WOD-BIN
  WOD-LOT
  WOD-SUBLOT
  WOD-SERIAL
  WOD-UOM
Serial Details WODETAIL
Valid When ITE-SER-TRACK-FL !="N"
WOR-COMPANY->WOD-COMPANY
WOR-LOCATION->WOD-LOCATION
WOR-WORK-ORDER->WOD-WORK-ORDER
WOR-WORK-ORDER-SUF->WOD-WORK-ORDER-SUF
"F"->WOD-DETAIL-TYPE
Zeroes->WOD-COMPONENT-SEQ
  WOD-BIN
  WOD-LOT
  WOD-SUBLOT
  WOD-SERIAL
  WOD-UOM
Uom Details WODETAIL
WOR-COMPANY->WOD-COMPANY
WOR-LOCATION->WOD-LOCATION
WOR-WORK-ORDER->WOD-WORK-ORDER
WOR-WORK-ORDER-SUF->WOD-WORK-ORDER-SUF
"F"->WOD-DETAIL-TYPE
Zeroes->WOD-COMPONENT-SEQ
  WOD-BIN
  WOD-LOT
  WOD-SUBLOT
  WOD-SERIAL
  WOD-UOM
Whdemand WHDEMAND
WOR-COMPANY->WDM-COMPANY
WOR-LOCATION->WDM-LOCATION
  WDM-ITEM
  WDM-EST-TRAN-DT
  WDM-SYSTEM-CD
  WDM-DOC-NBR
  WDM-LINE-NBR
  WDM-COMPONENT-SEQ
Whsupply WHDEMAND
WOR-COMPANY->WDM-COMPANY
WOR-LOCATION->WDM-LOCATION
"WO"->WDM-SYSTEM-CD
WOR-WO-ALPHA->WDM-DOC-NBR
  WDM-LINE-NBR
  WDM-COMPONENT-SEQ
Wobyprod WOBYPROD Delete Restricted
WOR-COMPANY->WOB-COMPANY
WOR-LOCATION->WOB-LOCATION
WOR-WORK-ORDER->WOB-WORK-ORDER
WOR-WORK-ORDER-SUF->WOB-WORK-ORDER-SUF
  WOB-SEQ
Wocomp WOITEM Delete Restricted
WOR-COMPANY->WOI-COMPANY
WOR-LOCATION->WOI-LOCATION
WOR-WORK-ORDER->WOI-WORK-ORDER
WOR-WORK-ORDER-SUF->WOI-WORK-ORDER-SUF
  WOI-COMPONENT-SEQ
Wodetail WODETAIL
WOR-COMPANY->WOD-COMPANY
WOR-LOCATION->WOD-LOCATION
WOR-WORK-ORDER->WOD-WORK-ORDER
WOR-WORK-ORDER-SUF->WOD-WORK-ORDER-SUF
"F"->WOD-DETAIL-TYPE
Zeroes->WOD-COMPONENT-SEQ
  WOD-BIN
  WOD-LOT
  WOD-SUBLOT
  WOD-SERIAL
  WOD-UOM
Woitem WOITEM
WOR-COMPANY->WOI-COMPANY
WOR-LOCATION->WOI-LOCATION
WOR-WORK-ORDER->WOI-WORK-ORDER
WOR-WORK-ORDER-SUF->WOI-WORK-ORDER-SUF
  WOI-COMPONENT-SEQ


File created: Thu Jun 09 11:30:48 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.