|
WORDER FILE
Work Order Header
The Work Order Header file contains the primary information associated with
producing a finished good.
REFERENCED BY
IC01.1 WHD2.1 IC02.1
UPDATED BY
BL120 BL122 BL130 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
WH20.7 WHD3.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WOR-COMPANY Numeric 4
Element: Company This field contains the company number,
as defined in the Inventory Control
system.
WOR-LOCATION Alpha 5
Element: Location 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
Element: 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
Element: Work Order SufThis 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
Element: Item 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)
Element: Start Date This is the production start date for
the work order.
WOR-END-DATE Numeric 8 (yyyymmdd)
Element: End Date This is the production end date for the
work order.
WOR-EXP-DELIV-DT Numeric 8 (yyyymmdd)
Element: Date This is the date needed for the
finished good.
WOR-STATUS Numeric 1
Element: 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
Element: Pick Fdbk StatEach 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
Element: Prod Fdbk StatEach 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
Element: Req Comments 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
Element: 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
Element: Printed Fl 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
Element: 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)
Element: Opr 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 BL120 BL122
Element: System Cd This field indicates on what system the BL130 BL20.1
transaction originated. BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
WOR-DOC-NBR-NUM Numeric 10 BL120 BL122
Element: Doc Nbr Num This is the order or requisition number BL130 BL20.1
when the work order is for a specific BL20.3 BL21.2
order or requisition. BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
WH20.7
WOR-LINE-NBR Numeric 6 BL120 BL122
Element: Line Nbr This field contains the line number of BL130 BL20.1
the order or requisition when the work BL20.3 BL21.2
order is for a specific order or BL21.5 BL29.1
requisition. BL29.2 BL520
BL820 BL92.1
WH20.7
WOR-ORIG-WORK-ORDR Numeric 8
Element: Work Order 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
Element: Work Order SufThis 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
Element: Quantity This field contains the planned
quantity for the finished good being
produced by this work order.
WOR-ACTUAL-QTY Signed 13.4
Element: Quantity This field contains the actual quantity
of the finished good produced by this
work order.
WOR-DETAIL-QTY Signed 13.4
Element: Quantity 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
Element: Quantity 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 18.5
Element: Intl 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 18.5
Element: Intl 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 18.5
Element: Intl 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 18.5
Element: Intl Cost This is the total of the actual costs
for packaging components that were used
for the finished goods.
WOR-EST-BRDN-COST Signed 18.2
Element: Intl Amt This is the total estimated burden cost
related to producing the finished goods.
WOR-ACT-BRDN-COST Signed 18.2
Element: Intl Amt This is the total actual burden cost
related to producing the finished goods.
WOR-FGV-AMOUNT Signed 18.5
Element: Intl Cost 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)
Element: Vendor 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)
Element: 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)
Element: 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
Element: Work Order This is the number of the work order
that reverses this work order.
WOR-WF-PROD-FL Alpha 1
Element: All Flag 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
Element: All Flag 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
Element: 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
Element: Seq This is the last sequence used for
burdens added to this work order.
WOR-LAST-BYPRO-SEQ Numeric 3
Element: Seq This is the last sequence number used
for byproducts added to this work order.
WOR-WO-ALPHA Derived
Element: 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
Element: 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
Element: 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
Element: 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)
Element: User 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)
Element: User Fld3 This field contains user-defined
information.
WOR-WO-USER-DATE-1 Numeric 8 (yyyymmdd)
Element: Date This field contains user-defined dates.
WOR-BA-ACCT-UNIT Alpha 15
Element: 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
Element: Ba Account This field identifies the burden
absorption account to record burden
expenses associated with a production
facility.
WOR-BA-SUB-ACCT Numeric 4
Element: 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
Element: 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
Element: 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
Element: 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 BL120 BL122
LOCATION BL130 BL20.1
WORK-ORDER BL20.3 BL21.2
WORK-ORDER-SUF BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC01.1 WH20.7
WHD2.1 WHD3.1
WORSET2 COMPANY KeyChange IC02.1
LOCATION
STATUS
WORK-ORDER
WORK-ORDER-SUF
WORSET3 COMPANY KeyChange
LOCATION
STATUS
START-DATE
WORK-ORDER
WORK-ORDER-SUF
WORSET4 COMPANY KeyChange
LOCATION
ITEM
WORK-ORDER*
WORK-ORDER-SUF
WORSET5 COMPANY KeyChange
LOCATION
END-DATE
WORK-ORDER
WORK-ORDER-SUF
WORSET7 COMPANY KeyChange, Subset
LOCATION Where WO-USER-FLD-1 != Spaces
WO-USER-FLD-1
WORK-ORDER
WORK-ORDER-SUF
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 -> -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
Bin Details WODETAIL
Valid When ITE-LOT-TRACK-FL = "N"
And ITE-SER-TRACK-FL = "N"
And ITL-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
|