WORDER FILE
Work Order Header
The Work Order Header file contains the primary information associated with
producing a finished good.
REFERENCED BY
IC01.1 IC02.1 IC62.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WOR-COMPANY Numeric 4
Company This field contains the company number,
as defined in the Inventory Control
system.
WOR-LOCATION Alpha 5
Location Code 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 Numeric 8
Work Order 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 Numeric 2
Work Order Suf 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 Alpha 32
Item Number 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 Numeric 8 (yyyymmdd)
Start Date This is the production start date for
the work order.
WOR-END-DATE Numeric 8 (yyyymmdd)
Ending Date This is the production end date for the
work order.
WOR-EXP-DELIV-DT Numeric 8 (yyyymmdd)
Exp Deliv Dt This is the date needed for the
finished good.
WOR-STATUS Numeric 1
Status 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 Numeric 1
Pick Fdbk Stat 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 Numeric 1
Prod Fdbk Stat 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 Alpha 1
Walk Thru Req 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 Alpha 4
Hold Code 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 Alpha 1
Printed Flag This flag indicates if this work order
has been printed by the work order print
program.
Y = Yes
" " = No
WOR-PRTED-PL-FL Alpha 1
Prted Pl Fl This flag indicates if this work order
has been printed by the work order pick
list program.
Y = Yes
" " = No
WOR-OPR-CODE Alpha 10 (Lower Case)
Operator Code This field contains the operator code.
This is the user ID of the person who
last maintained this record.
WOR-SYSTEM-CD Alpha 2
System Code This field indicates on what system the
transaction originated.
WOR-DOC-NBR-NUM Numeric 10
Doc Nbr Num This is the order or requisition number
when the work order is for a specific
order or requisition.
WOR-LINE-NBR Numeric 6
Line Number 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 Numeric 8
Orig Work Ordr 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 Numeric 2
Orig Wo Suf 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 Signed 13.4
Plan Qty This field contains the planned
quantity for the finished good being
produced by this work order.
WOR-ACTUAL-QTY Signed 13.4
Actual Qty This field contains the actual quantity
of the finished good produced by this
work order.
WOR-DETAIL-QTY Signed 13.4
Detail Qty 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 Signed 13.4
Shrink Qty 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 Signed 13.5
Est Comp Cost This is the total of the estimated
costs for 'C' type components that will
used to produce the finished goods.
WOR-ACT-COMP-COST Signed 13.5
Act Comp Cost 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 Signed 13.5
Est Pack Cost This is the total of the estimated cost
for packaging components that will be
used for the finished goods.
WOR-ACT-PACK-COST Signed 13.5
Act Pack Cost This is the total of the actual costs
for packaging components that were used
for the finished goods.
WOR-EST-BRDN-COST Signed 13.2
Est Brdn Cost This is the total estimated burden cost
related to producing the finished goods.
WOR-ACT-BRDN-COST Signed 13.2
Act Brdn Cost This is the total actual burden cost
related to producing the finished goods.
WOR-FGV-AMOUNT Signed 13.5
Fgv Amount 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 Alpha 9 (Right Justified)
Vendor ID 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 Numeric 8 (yyyymmdd)
Offsite Date This is the date that the work order
was sent offsite if it is currently on
offsite hold.
WOR-RETURNED-DATE Numeric 8 (yyyymmdd)
Returned Date 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 Numeric 8
Reversed By Wo This is the number of the work order
that reverses this work order.
WOR-WF-PROD-FL Alpha 1
Wf Prod Fl 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 Alpha 1
Wf Offsite Fl 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 Numeric 3
Last Comp Seq This is the last sequence number used
for components added to the work order
item file for this work order.
WOR-LAST-BRDN-SEQ Numeric 3
Last Brdn Seq This is the last sequence used for
burdens added to this work order.
WOR-LAST-BYPRO-SEQ Numeric 3
Last Bypro Seq This is the last sequence number used
for byproducts added to this work order.
WOR-WO-ALPHA Derived
Wo Alpha The system displays a group field that
contains work order (WORK-ORDER) and
work order suffix (WORK-ORDER-SUF).
WOR-DISP-DOC Derived
Disp Doc 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 Derived
Est Fg Cost 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 Derived
Act Fg Cost 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 Alpha 10 (Lower Case)
Wo User Fld 1 This field contains user-defined data
and can be used to cross reference work
order numbers.
WOR-WO-USER-FLD-2 Alpha 15 (Lower Case)
Wo User Fld 2 This field contains user-defined
information.
WOR-WO-USER-DATE-1 Numeric 8 (yyyymmdd)
Wo User Date 1 This field contains user-defined dates.
WOR-BA-ACCT-UNIT Alpha 15
Ba Acct Unit This field identifies the burden
absorption account unit to record
burden expenses associated with a
production facility.
WOR-BA-ACCOUNT Numeric 6
Ba Account This field identifies the burden
absorption account to record burden
expenses associated with a production
facility.
WOR-BA-SUB-ACCT Numeric 4
Ba Sub Acct This field identifies the burden
absorption subaccount to record burden
expenses associated with a production
facility.
WOR-PC-ACCT-UNIT Alpha 15
Pc Acct Unit This field identifies the production
credit account unit to record credit to
a production facility for finished goods
produced.
WOR-PC-ACCOUNT Numeric 6
Pc Account This field identifies the production
credit account to record credit to a
production facility for finished goods
produced.
WOR-PC-SUB-ACCT Numeric 4
Pc Sub Acct 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 This index is used to access Work Order IC01.1
LOCATION header records for a specific work order
WORK-ORDER at a production location.
WORK-ORDER-SUF
WORSET2 COMPANY This index is used to access Work Order IC02.1
LOCATION header records for a specific status and
STATUS work order at a production location.
WORK-ORDER KeyChange
WORK-ORDER-SUF
WORSET3 COMPANY This index is used to access Work Order
LOCATION header records for a specific status,
STATUS start date, and work order for a
START-DATE production location.
WORK-ORDER KeyChange
WORK-ORDER-SUF
WORSET4 COMPANY This index is used to access Work Order IC62.1
LOCATION header records for a specific finished
ITEM good and work order for a production
WORK-ORDER* location.
WORK-ORDER-SUFKeyChange
WORSET5 COMPANY This index is used to access Work Order
LOCATION header records for a specific production
END-DATE end date and work order for a production
WORK-ORDER location.
WORK-ORDER-SUFKeyChange
WORSET6 COMPANY This index is used to access Work Order
WORK-ORDER header records for a specific work order
LOCATION for a company by work order number and
WORK-ORDER-SUFproduction facility.
KeyChange
WORSET7 COMPANY This index is used to access Work Order
LOCATION header records for User Field 1 and work
WO-USER-FLD-1 order for a production location, when
WORK-ORDER User Field 1 is used.
WORK-ORDER-SUFKeyChange, Subset
Where WO-USER-FLD-1 != Spaces
WORDER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Not Required
Valid When WOR-VENDOR != Spaces
WOR-COMPANY -> CPY-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"
And WOR-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"
And WOR-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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
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
|
