WOSCHEDDTL FILE
Work Order Schedule Detail
The Work Order Schedule Detail file is used to hold work order dates and
quantities during the Work Order production scheduling process. It will
contain a record for each work order that is to be created from the
scheduling process from the selected demand schedule information.
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WOT-OBJ-ID-DTL Numeric 12
Obj Id Dtl The detail object ID is used to
associate one or more records in this
file to one or more records in the
schedule file. A common value, unique
to these records, is used in the records
to be linked.
WOT-SEQ Numeric 3
Sequence Number This sequence number is used to
maintain the order that schedule detail
records were added for schedule
record(s) during the selection process.
This field is used to determine the
order to process these records during
the release process for the creation of
work orders.
WOT-WORK-ORDER Numeric 8
Work Order This identifies the work order number
that will be assigned to the work order
created from this schedule detail record
when the schedule is released. The work
order numbers must be manually assigned.
WOT-START-DATE Numeric 8 (yyyymmdd)
Start Date This is the production start date that
will be loaded to the work order created
during the release process.
WOT-END-DATE Numeric 8 (yyyymmdd)
Ending Date This is the production end date that
will be loaded to the work order during
the release process.
WOT-QUANTITY Signed 13.4
Quantity This field contains the quantity of the
finished good to be produced by the work
order that will be created during the
release process.
WOSCHEDDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WOTSET1 OBJ-ID-DTL This index is used to access Work Order
SEQ schedule detail records for a specific
detail object ID and a sequencing for
that object ID.
WOTSET2 WORK-ORDER This index is used to access Work Order
schedule detail records for a specific
work order.
KeyChange, Subset
Where (WORK-ORDER != Zeroes )
WOTSET3 SEQ This index was created as a solution to
OBJ-ID-DTL the Find Next/Prev Flag error. It is
only used where a modify must be done
within a 850-FIND-NLT or 850-FIND-BEGRNG
loop.
WOSCHEDDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Woschedule WOSCHEDULE
WOT-OBJ-ID-DTL -> WOS-OBJ-ID-DTL (WOSSET3)
WOS-OBJ-ID-DMND
|
