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.

REFERENCED BY

WO120     WO30.1    WO45.1

UPDATED BY

WO20.1    WO20.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WOT-OBJ-ID-DTL       Numeric 12                                  WO20.1  WO20.2
Object ID Detail     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                                   WO20.1  WO20.2
Sequence             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                                   WO20.1  WO20.2
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)                       WO20.1  WO20.2
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)                       WO20.1  WO20.2
End Date             This is the production end date that
                     will be loaded to the work order during
                     the release process.

WOT-QUANTITY         Signed 13.4                                 WO20.1  WO20.2
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  WO20.1  WO20.2
          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  WO120   WO20.1
                        schedule detail records for a specific   WO20.2  WO30.1
                        work order.                              WO45.1
                        KeyChange, Subset
                        Where (WORK-ORDER != Zeroes )

                         WOSCHEDDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Woschedule     WOSCHEDULE   Required

                            WOT-OBJ-ID-DTL    -> WOS-OBJ-ID-DTL