|
|
WORDER FILE
Work Order Header
The Work Order Header file contains the primary information associated with
producing a finished good.
REFERENCED BY
IC02.1 WO256 WO80.1 WO81.1 WO81.2 WOA3.1
WO130 WO232 WO235 WO255 IC62.1 WO250
WO251 WO252
UPDATED BY
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
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
Location 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
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
Work Order Suffix This 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
Item 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
Start Date This is the production start date for WO30.1
the work order.
WOR-END-DATE Numeric 8 (yyyymmdd) WO120 WO20.1
End Date This is the production end date for the WO30.1
work order.
WOR-EXP-DELIV-DT Numeric 8 (yyyymmdd) WO120 WO20.1
Expected Delivery This is the date needed for the WO30.1
Date finished good.
WOR-STATUS Numeric 1 WO120 WO140
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
Picking Feedback Each picking feedback status indicates WO40.1 WO40.2
Status a stage within the picking feedback WO40.3 WO40.4
process. WO40.5 WO41.1
0 = No Picking Feedback Started WO41.2 WO41.3
1 = Picking Feedback in Process WO41.4 WO42.1
2 = Picking Feedback Finished WO42.2 WO42.3
3 = Picking Feedback Complete WO42.4 WO42.5
WOSP.1
WOR-PROD-FDBK-STAT Numeric 1 WO140 WO40.1
Production Feedback Each production feedback status WO40.2 WO40.3
Status indicates a stage within the production WO40.4 WO40.5
feedback process for the work order. WO41.1 WO41.2
0 = No Production Feedback Started WO41.3 WO41.4
1 = Production Feedback In Process WO42.1 WO42.2
2 = Production Feedback Finished WO42.3 WO42.4
3 = Production Feedback Complete WO42.5 WO45.1
WOSP.1
WOR-WALK-THRU-REQ Alpha 1 WO120 WO20.1
Walkthrough Required 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
N = No WO41.2 WO41.3
Y = Yes WO41.4 WO42.1
WO42.2 WO42.3
WO42.4 WO42.5
WOR-HOLD-CODE Alpha 4 WO120 WO20.1
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
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
Printed Picklist This flag indicates if this work order
Flag has been printed by the work order pick
list program.
Y = Yes
" " = No
WOR-OPR-CODE Alpha 10 (Lower Case) WO120 WO20.1
Operator Code This field contains the operator code. WO30.1
This is the user ID of the person who
last maintained this record.
WOR-SYSTEM-CD Alpha 2 WO120 WO20.1
System Code This field indicates on what system the WO30.1
transaction originated.
WOR-DOC-NBR-NUM Numeric 10 WO120 WO20.1
Document Number This is the order or requisition number WO30.1
Numeric Value when the work order is for a specific
order or requisition.
WOR-ORIG-WORK-ORDR Numeric 8 WO45.1 WOSP.1
Original 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
Original Work Order This is the suffix of original work
Suffix 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
Planned 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
Actual 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
Detail 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
Shrink 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
Estimated Component This is the total of the estimated WOSP.1
Cost costs for 'C' type components that will
used to produce the finished goods.
WOR-ACT-COMP-COST Signed 13.5 WO140 WO40.1
Actual Component This is the total of actual component WO40.2 WO40.3
Cost 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
Estimated Packing This is the total of the estimated cost WOSP.1
Cost for packaging components that will be
used for the finished goods.
WOR-ACT-PACK-COST Signed 13.5 WO140 WO40.1
Actual Packing 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
Estimated Burden This is the total estimated burden cost WOSP.1
Cost related to producing the finished goods.
WOR-ACT-BRDN-COST Signed 13.2 WO140 WO35.1
Actual Burden Cost 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
Finished Good The finished good variance amount is
Variance Amount 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 WO35.1
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) WO35.1
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) WO35.1
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 WO45.1
Reversed by Work This is the number of the work order
Order that reverses this work order.
WOR-WF-PROD-FL Alpha 1 WO120 WO20.1
Workflow Production The Workflow Management system WO30.1
Flag 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 WO35.1
Workflow Offsite The Workflow Management system offsite
Flag 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
Last Component This is the last sequence number used
Sequence for components added to the work order
item file for this work order.
WOR-LAST-BRDN-SEQ Numeric 3 WO30.1 WO35.1
Last Burden Sequence This 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
Last Byproduct This is the last sequence number used WOEX.1
Sequence for byproducts added to this work order.
WOR-WO-ALPHA Derived
Work Order Alpha The system displays a group field that
contains work order (WORK-ORDER) and
work order suffix (WORK-ORDER-SUF).
WOR-DISP-DOC Derived
Display Document 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
Estimated Finished The system displays the result of
Goods Cost 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
Actual Finished The system displays the result of
Goods Cost 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
User Field 1 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
User Field 2 This field contains user-defined WO40.1
information.
WOR-WO-USER-DATE-1 Numeric 8 (yyyymmdd) WO30.1 WO35.1
User Date 1 This field contains user-defined dates. WO40.1
WOR-PC-ACCT-UNIT Alpha 15 WO120 WO20.1
Account Unit The production credit account is used WO30.1
to record credit given to a production
facility for a finished good.
WOR-PC-ACCOUNT Numeric 6 WO120 WO20.1
Account This field is used to record credit to WO30.1
a production facility for a finished
good.
WOR-PC-SUB-ACCT Numeric 4 WO120 WO20.1
Subaccount This field is used to record credit to WO30.1
a production facility for a finished
good.
WOR-BA-ACCT-UNIT Alpha 15 WO120 WO20.1
Account Unit This field is used to record burden WO30.1
expenses associated with a production
facility.
WOR-BA-ACCOUNT Numeric 6 WO120 WO20.1
Account This field is used to record burden WO30.1
expenses for a production facility.
WOR-BA-SUB-ACCT Numeric 4 WO120 WO20.1
Subaccount This field is used to record burden WO30.1
expenses for a production facility.
WORDER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WORSET1 COMPANY This index is used to access Work Order IC02.1 WO120
LOCATION header records for a specific work order WO131 WO132
WORK-ORDER at a production location. WO133 WO140
WORK-ORDER-SUF WO20.1 WO20.2
WO256 WO30.1
WO30.2 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
WO42.2 WO42.3
...
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 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 IC02.1
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
WORDER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bin Details WODETAIL
Valid When WOR-LOT-TRACK-FL = "N"
And WOR-SER-TRACK-FL = "N"
And WOR-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 WOR-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 WOR-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
|