Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WOSCHEDULE

                            WOSCHEDULE FILE

                          Work Order Schedule

The Work Order Schedule file is used to hold demand scheduling information
during the Work Order production scheduling process. It will contain records
for detail document demand, summary document demand and/or forecast demand,
depending on the options selected regarding demand source and whether to get
detail document demand.

UPDATED BY

WO20.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WOS-OBJ-ID-DMND        Numeric 12                                WO20.1
Object                 The demand object ID is the identifier
Identification         used to associate records of this file
                       to demand records based on a unique
                       value for the records to be associated
                       with each other.

WOS-OBJ-ID-HDR         Numeric 12                                WO20.1
Object                 The header object ID is used to
Identification         associate records in this file to a
                       schedule header record.

WOS-OBJ-ID-DTL         Numeric 12                                WO20.1
Object                 The detail object ID is used to
Identification         associate one or more schedule detail
                       records to one or more records in this
                       file by using a common value in the
                       records to be linked that is unique to
                       these records.

WOS-DATE               Numeric 8  (yyyymmdd)                     WO20.1
Element: Date          This is the date needed for the demand.

WOS-DEMAND-TYPE        Numeric 1                                 WO20.1
Element: Demand Type   The three types of demand schedule
                       records are as follows.
                       1 = Document Detail
                       2 = Document Summary
                       3 = Forecast

WOS-SYSTEM-CD          Alpha 2                                   WO20.1
Element: System Code   This field indicates on which Lawson
                       system the transaction originated
                       whenever the demand type is for document
                       detail.
                       OE = Order Entry
                       RQ = Requisitions

WOS-DOC-NBR            Alpha 10  (Right Justified)               WO20.1
Element: Doc Nbr       This is the document number from the
                       demand when the demand type of this
                       record is document detail.

WOS-LINE-NBR           Numeric 6                                 WO20.1
Element: Line Number   This field contains the line number for
                       document detail demand records.

WOS-RUSH-FL            Alpha 1                                   WO20.1
Element: All Flag      The rush flag will come from the
                       document demand record (when document
                       detail is the record type).
                       Y = Yes
                       N = No

WOS-QUANTITY           Signed 13.4                               WO20.1
Element: Quantity      This field contains the requested
                       quantity of the finished good from the
                       demand record(s) that a schedule record
                       entails.

WOS-ACTION-CD          Alpha 1                                   WO20.1
Element: Action Cd     The action code is used to hold the
                       action requested during the selection
                       process of production scheduling. This
                       value is used to determine what records
                       to use during the release of the
                       schedule.
                       G = Group
                       S = Separate

                         WOSCHEDULE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WOSSET1   OBJ-ID-DMND   This index is used to access Work Order
                        schedule records for a specific demand
                        object ID.

WOSSET2   OBJ-ID-HDR    This index is used to access Work Order  WO20.1
          DEMAND-TYPE   schedule records for a specific header
          DATE          object ID, demand type, date needed,
          SYSTEM-CD     system code, document number, and line
          DOC-NBR       number.
          LINE-NBR      KeyChange
          OBJ-ID-DMND

WOSSET3   OBJ-ID-DTL    This index is used to access Work Order
          OBJ-ID-DMND   schedule records for a specific detail
                        object ID.
                        KeyChange, Subset
                        Where (OBJ-ID-DTL != Zeroes )

WOSSET4   OBJ-ID-HDR    This index is used to access Work Order  WO20.1
          OBJ-ID-DTL    schedule records for a specific header
          DATE          object ID, detail object ID, and date
          OBJ-ID-DMND   needed.
                        KeyChange, Subset
                        Where (OBJ-ID-DTL != Zeroes )

WOSSET5   OBJ-ID-HDR    This index is used to access Work Order  WO20.1
          DEMAND-TYPE   schedule records for a specific header
          SYSTEM-CD     object ID, demand type, system code,
          DOC-NBR       document number, line number, and date
          LINE-NBR      needed.
          DATE          KeyChange
          OBJ-ID-DMND

                         WOSCHEDULE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Whdemand Doc   WHDEMAND     Not Required

                            WOH-COMPANY        -> WDM-COMPANY
                            WOS-SYSTEM-CD      -> WDM-SYSTEM-CD
                            WOS-DOC-NBR        -> WDM-DOC-NBR
                            WOS-LINE-NBR       -> WDM-LINE-NBR
                            Zeroes             -> WDM-COMPONENT-SEQ
                            WOH-LOCATION       -> WDM-LOCATION

Woschedhdr     WOSCHEDHDR   Required

                            WOS-OBJ-ID-HDR     -> WOH-OBJ-ID-HDR

                         WOSCHEDULE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Whdemand       WHDEMAND

                            WOS-OBJ-ID-DMND    -> WDM-OBJ-ID-DMND
                                                  WDM-SEQ

Wodmndfcst     WODMNDFCST

                            WOS-OBJ-ID-DMND    -> WDF-OBJ-ID-DMND
                                                  WDF-SEQ

Woscheddtl     WOSCHEDDTL

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