WOSCHEDHDR FILE
Work Order Schedule Header
The Work Order Schedule Header file is used to hold scheduling information
during the Work Order production scheduling process. It will contain one
record for each finished good item that is in the process of being scheduled.
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WOH-COMPANY Numeric 4
Company This field contains the company number,
as defined in the Inventory Control
system.
WOH-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.
WOH-ITEM Alpha 32
Item Number This field contains the item identifier
for the finished good to be scheduled
for production. The item number is
defined in the Inventory Control system.
WOH-OBJ-ID-HDR Numeric 12
Obj Id Hdr The header object ID is used to
associate a group of work order schedule
records to a record in this file.
WOH-OBJ-ID-DTL Numeric 12
Obj Id Dtl The detail object ID field in this file
is used to hold a value to relate work
order schedule records to work order
schedule detail records.
WOH-DOC-DMND-VIEW Alpha 1
Doc Dmnd View Document demand view indicates if
document demand records are to be viewed
in summary or detail during the work
order scheduling process.
D = Detail
S = Summary
WOH-DATE-USED Alpha 1
Date Used This is the date used for the work
order scheduling process. The date
needed or production start date is used
to determine what scheduling period
includes specific demand.
N = Date Needed
P = Production Start Date
WOH-PREV-DATE Numeric 8 (yyyymmdd)
When This is the end date of demand to
include in the previous period.
WOH-PER-1-DATE Numeric 8 (yyyymmdd)
Per 1 Date This is the end date of demand to
include in period 1.
WOH-PER-2-DATE Numeric 8 (yyyymmdd)
Per 2 Date This is the end date of demand to
include in period 2.
WOH-PER-3-DATE Numeric 8 (yyyymmdd)
Per 3 Date This is the end date of demand to
include in period 3.
WOH-FUTURE-DATE Numeric 8 (yyyymmdd)
Future Date This is the end date of demand to
include in the future period.
WOH-CALENDAR Alpha 15
Calendar This field contains the name of the
calendar to check when determining the
production start date if it is the date
used. The calendar is also used to
check for contiguous days if the
finished good requires contiguous days
for production.
WOH-WORK-ORDER Numeric 8
Work Order This identifies the work order number
that will be assigned to the first work
order created from a selection or
release process of production
scheduling. This field is required if
work order numbers are manually assigned
for the production facility. No value
may be entered in this field if work
order numbers are automatically assigned
for the production facility.
WOH-STATUS Numeric 1
Status The four statuses of work orders
created from the production scheduling
process are as follows.
1 = Unreleased
2 = Released
3 = Exploded
4 = In Production
WOH-START-DATE Numeric 8 (yyyymmdd)
Start Date This is the production start date to
default to the first work order created
from the selection or release process of
production scheduling.
WOH-END-DATE Numeric 8 (yyyymmdd)
Ending Date This is the production end date to
default to the first work order created
from the selection or release process of
production scheduling.
WOH-CAPACITY Numeric 8
Capacity This is the maximum quantity of a
finished good that may be scheduled to a
single work order. If no value is
typed, no capacity checking occurs when
the schedule is being released.
WOH-FIRM-FL Alpha 1
Firm Fl This indicates if the finished good
gets allocated to the originating source
document demand when one work order is
being created from one order or
requisition using the production
scheduling process.
WOH-USER-ID Alpha 10 (Lower Case)
User ID Name This contains the user ID of the person
who is doing the production scheduling
process.
WOH-CREATE-DATE Numeric 8 (yyyymmdd)
Creation Date This is the date that the production
scheduling process was started.
WOH-UPDATE-DATE Numeric 8 (yyyymmdd)
Update Date This is the date of the last activity
done for the production scheduling
process on a finished good.
WOH-UPDATE-TIME Numeric 6
Update Time This is the time of the last activity
done for the production scheduling
process.
WOSCHEDHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WOHSET1 COMPANY This index is used to access Work Order
LOCATION schedule header records for a finished
ITEM good for a production location.
WOHSET2 OBJ-ID-HDR This index is used to access Work Order
schedule header records for a specific
header object ID.
WOSCHEDHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
WOH-COMPANY -> ICC-COMPANY (ICCSET1)
Iclocation ICLOCATION Required
WOH-COMPANY -> ICL-COMPANY
WOH-LOCATION -> ICL-LOCATION
Itemgroup ITEMGROUP Not Required
ICC-ITEM-GROUP -> ITG-ITEM-GROUP
Itemloc ITEMLOC Required
WOH-COMPANY -> ITL-COMPANY
WOH-LOCATION -> ITL-LOCATION
WOH-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
WOH-ITEM -> ITE-ITEM
WOSCHEDHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Woschedule WOSCHEDULE
WOH-OBJ-ID-HDR -> WOS-OBJ-ID-HDR
WOS-DEMAND-TYPE
WOS-DATE
WOS-SYSTEM-CD
WOS-DOC-NBR
WOS-LINE-NBR
WOS-OBJ-ID-DMND
|
