|
|
WORDER FILE
Work Order Header
The Work Order Header file contains the primary information associated with
producing a finished good.
REFERENCED BY
IC01.1 WO256 WO80.1 WO81.1 WO81.2 WOD0.1
WOD1.1 WODL.1 IC02.1 WO130 WO232 WO235
WO255 WO280 IC62.1 WO250 WO251 WO252
UPDATED BY
WH20.7 WO120 WO131 WO132 WO133 WO140
WO20.1 WO30.1 WO30.2 WO300 WO32.1 WO32.2
WO32.3 WO32.4 WO32.5 WO35.1 WO40.1 WO40.2
WO40.3 WO40.4 WO40.5 WO41.1 WO41.2 WO41.3
WO41.4 WO42.1 WO42.2 WO42.3 WO42.4 WO42.5
WO45.1 WOEX.1 WOSP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WOR-COMPANY Numeric 4 WO120 WO20.1
Element: Company This field contains the company number, WO30.1 WO35.1
as defined in the Inventory Control WO40.1 WO45.1
system.
WOR-LOCATION Alpha 5 WO120 WO20.1
Element: Location Code This field contains a valid stock WO30.1 WO35.1
location within the company inventory. WO40.1 WO45.1
It is also the production facility
where finished goods are produced.
WOR-WORK-ORDER Numeric 8 WO120 WO20.1
Element: Work Order This identifies the work order and may WO30.1 WO35.1
be automatically assigned or manually WO40.1 WO45.1
assigned, depending on the option
defined for each production (inventory)
location.
WOR-WORK-ORDER-SUF Numeric 2 WO120 WO20.1
Element: Work Order SufThis will normally be zero for a work WO30.1 WO35.1
order. If you chose to split a work WO40.1 WO45.1
order so the completed part of the WOSP.1
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 WO120 WO20.1
Element: Item Number This field contains the item identifier WO30.1
of the finished good produced for the
work order, as defined in the Inventory
Control system.
WOR-START-DATE Numeric 8 (yyyymmdd) WO120 WO20.1
Element: Date This is the production start date for WO30.1
the work order.
WOR-END-DATE Numeric 8 (yyyymmdd) WO120 WO20.1
Element: Date This is the production end date for the WO30.1
work order.
WOR-EXP-DELIV-DT Numeric 8 (yyyymmdd) WO120 WO20.1
Element: Date This is the date needed for the WO30.1
finished good.
WOR-STATUS Numeric 1 WO120 WO140
Element: Status The work order statuses indicate the WO20.1 WO30.1
progression of the work order through WO45.1 WOEX.1
pre and post production stages. WOSP.1
1 = Unreleased
2 = Released
3 = Exploded
4 = In Production
8 = Canceled
9 = Completed
WOR-PICK-FDBK-STAT Numeric 1 WO132 WO32.1
Element: Pick Fdbk StatEach picking feedback status indicates WO40.1 WO40.2
a stage within the picking feedback WO40.3 WO40.4
process. WO40.5 WO41.1
WO41.2 WO41.3
0 = Picking Fdbk Not Started WO41.4 WO42.1
1 = Picking Fdbk In Process WO42.2 WO42.3
2 = Picking Fdbk Finished WO42.4 WO42.5
3 = Picking Fdbk Complete WOSP.1
WOR-PROD-FDBK-STAT Numeric 1 WO140 WO40.1
Element: Prod Fdbk StatEach production feedback status WO40.2 WO40.3
indicates a stage within the production WO40.4 WO40.5
feedback process for the work order. WO41.1 WO41.2
WO41.3 WO41.4
0 = Production Fdbk Not Started WO42.1 WO42.2
1 = Production Fdbk In Process WO42.3 WO42.4
2 = Production Fdbk Finished WO42.5 WO45.1
3 = Production Fdbk Completed WOSP.1
WOR-WALK-THRU-REQ Alpha 1 WO120 WO20.1
Element: Req Comments This field indicates that a transaction WO30.1 WO32.1
line is out of balance. For example, if WO32.2 WO32.3
lot, bin, or serial number quantities do WO32.4 WO32.5
not equal the transaction quantity, WO40.1 WO40.2
select the WalkThru form action to WO40.3 WO40.4
balance the transaction quantities. WO40.5 WO41.1
WO41.2 WO41.3
WO41.4 WO42.1
WO42.2 WO42.3
WO42.4 WO42.5
WOR-HOLD-CODE Alpha 4 WO120 WO20.1
Element: Hold Code This is the offsite hold code which WO35.1
indicates if the work order is currently
sent offsite during the production
process to be performed by a vendor.
WOR-PRINTED-FL Alpha 1 WO133 WO30.1
Element: 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 WO131
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) WO120 WO20.1
Element: Requester WO30.1
WOR-SYSTEM-CD Alpha 2 WH20.7 WO120
Element: System Code This field indicates on what system the WO20.1 WO30.1
transaction originated.
WOR-DOC-NBR-NUM Numeric 10 WH20.7 WO120
Element: Doc Nbr Num This is the order or requisition number WO20.1 WO30.1
when the work order is for a specific
order or requisition.
WOR-LINE-NBR Numeric 6 WH20.7 WO20.1
Element: 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 WO45.1 WOSP.1
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 WO45.1 WOSP.1
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 WO120 WO20.1
Element: Quantity This field contains the planned WO30.1 WOSP.1
quantity for the finished good being
produced by this work order.
WOR-ACTUAL-QTY Signed 13.4 WO40.1 WO40.2
Element: Quantity This field contains the actual quantity WO40.3 WO40.4
of the finished good produced by this WO40.5 WO41.1
work order. WO41.2 WO41.3
WO41.4 WO42.1
WO42.2 WO42.3
WO42.4 WO42.5
WOSP.1
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 WO40.1 WO40.2
Element: Quantity Shrinkage quantity is the difference WO40.3 WO40.4
between the total of the components and WO40.5 WO41.1
the total of the finished good when all WO41.2 WO41.3
components are in the same unit of WO41.4 WO42.1
measure as the finished good. This is a WO42.2 WO42.3
quantity that may be entered at WO42.4 WO42.5
production feedback and is for WOSP.1
information only.
WOR-EST-COMP-COST Signed 13.5 WO30.1 WOEX.1
Element: Base Cost This is the total of the estimated WOSP.1
costs for 'C' type components that will
used to produce the finished goods.
WOR-ACT-COMP-COST Signed 13.5 WO140 WO40.1
Element: Base Cost This is the total of actual component WO40.2 WO40.3
inventory costs for 'C' type components WO40.4 WO40.5
that were used (not wasted) to produce WO41.1 WO41.2
the finished goods. WO41.3 WO41.4
WO42.1 WO42.2
WO42.3 WO42.4
WO42.5 WOSP.1
WOR-EST-PACK-COST Signed 13.5 WO30.1 WOEX.1
Element: Base Cost This is the total of the estimated cost WOSP.1
for packaging components that will be
used for the finished goods.
WOR-ACT-PACK-COST Signed 13.5 WO140 WO40.1
Element: Base Cost This is the total of the actual costs WO40.2 WO40.3
for packaging components that were used WO40.4 WO40.5
for the finished goods. WO41.1 WO41.2
WO41.3 WO41.4
WO42.1 WO42.2
WO42.3 WO42.4
WO42.5 WOSP.1
WOR-EST-BRDN-COST Signed 13.2 WO30.1 WOEX.1
Element: Act Amt This is the total estimated burden cost WOSP.1
related to producing the finished goods.
WOR-ACT-BRDN-COST Signed 13.2 WO140 WO35.1
Element: Act Amt This is the total actual burden cost WO40.1 WO40.2
related to producing the finished goods. WO40.3 WO40.4
WO40.5 WO41.1
WO41.2 WO41.3
WO41.4 WO42.1
WO42.2 WO42.3
WO42.4 WO42.5
WOSP.1
WOR-FGV-AMOUNT Signed 13.5
Element: Base 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) WO35.1
Element: 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) WO35.1
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) WO35.1
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 WO45.1
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 WO30.1 WOEX.1
Element: Sequence NumbeThis 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 WO30.1 WO35.1
Element: Sequence NumbeThis is the last sequence used for WO40.1 WOEX.1
burdens added to this work order.
WOR-LAST-BYPRO-SEQ Numeric 3 WO30.2 WO42.1
Element: Sequence NumbeThis is the last sequence number used WOEX.1
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) WO30.1 WO35.1
Element: User This field contains user-defined data WO40.1
and can be used to cross reference work
order numbers.
WOR-WO-USER-FLD-2 Alpha 15 (Lower Case) WO30.1 WO35.1
Element: User Defined FThis field contains user-defined WO40.1
information.
WOR-WO-USER-DATE-1 Numeric 8 (yyyymmdd) WO30.1 WO35.1
Element: Date This field contains user-defined dates. WO40.1
WOR-BA-ACCT-UNIT Alpha 15 WO120 WO20.1
Element: Ba Acct Unit This field identifies the burden WO30.1
absorption account unit to record
burden expenses associated with a
production facility.
WOR-BA-ACCOUNT Numeric 6 WO120 WO20.1
Element: Ba Account This field identifies the burden WO30.1
absorption account to record burden
expenses associated with a production
facility.
WOR-BA-SUB-ACCT Numeric 4 WO120 WO20.1
Element: Ba Sub Acct This field identifies the burden WO30.1
absorption subaccount to record burden
expenses associated with a production
facility.
WOR-PC-ACCT-UNIT Alpha 15 WO120 WO20.1
Element: Pc Acct Unit This field identifies the production WO30.1
credit account unit to record credit to
a production facility for finished goods
produced.
WOR-PC-ACCOUNT Numeric 6 WO120 WO20.1
Element: Pc Account This field identifies the production WO30.1
credit account to record credit to a
production facility for finished goods
produced.
WOR-PC-SUB-ACCT Numeric 4 WO120 WO20.1
Element: Pc Sub Acct This field identifies the production WO30.1
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 WH20.7
LOCATION header records for a specific work order WO120 WO131
WORK-ORDER at a production location. WO132 WO133
WORK-ORDER-SUF WO140 WO20.1
WO20.2 WO256
WO30.1 WO30.2
WO300 WO32.1
WO32.2 WO32.3
WO32.4 WO32.5
WO35.1 WO40.1
WO40.2 WO40.3
WO40.4 WO40.5
WO40.6 WO41.1
WO41.2 WO41.3
WO41.4 WO42.1
...
WORSET2 COMPANY This index is used to access Work Order IC02.1 WO130
LOCATION header records for a specific status and WO131 WO132
STATUS work order at a production location. WO133 WO140
WORK-ORDER KeyChange WO232 WO235
WORK-ORDER-SUF WO255 WO280
WO300 WO80.1
WORSET3 COMPANY This index is used to access Work Order WO130 WO131
LOCATION header records for a specific status, WO133 WO255
STATUS start date, and work order for a WO80.1
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 WO250 WO251
LOCATION header records for a specific production WO252
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
Wosgblk WOSGBLK Not Required
WOR-COMPANY -> WSB-COMPANY
WOR-LOCATION -> WSB-LOCATION
WOR-WORK-ORDER -> WSB-WORK-ORDER
WOR-WORK-ORDER-SUF -> WSB-WORK-ORDER-SUF
Zeroes -> WSB-COMPONENT-SEQ
Zeroes -> WSB-SEQ
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
Woburden WOBRDN Delete Restricted
WOR-COMPANY -> WBN-COMPANY
WOR-LOCATION -> WBN-LOCATION
WOR-WORK-ORDER -> WBN-WORK-ORDER
WOR-WORK-ORDER-SUF -> WBN-WORK-ORDER-SUF
WBN-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
|
