Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WOSCHEDDTL


                            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                 The detail object ID is used to
Identification         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
Element: Sequence NumbeThis 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
Element: 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
Element: 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
Element: 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
Element: 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 )

WOTSET3   SEQ           This index was created as a solution to  WO20.1
          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
                                                 WOS-OBJ-ID-DMND