Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEMASSCHNG


                            OEMASSCHNG FILE

UPDATED BY

OE116     OE16.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OMC-COMPANY            Numeric 4                                 OE16.1
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

OMC-REQUEST            Numeric 6                                 OE16.1
Element: Request NumberThe identifier representing the mass
                       change record. This request number is
                       processed by OE116 (Order Line Mass
                       Change Update).

OMC-STATUS             Numeric 1                                 OE16.1
Element: Status        This field contains the status of the
                       mass change request record. Valid values
                       are Unreleased or Released.
                       1 = Unreleased
                       2 = Released

OMC-OPR-CODE           Alpha 10  (Lower Case)                    OE16.1
Element: Operator Code This field contains the operator code.
                       This is the user ID of the person who
                       last maintained this record.

OMC-FROM-ORDER         Numeric 8                                 OE16.1
Element: From Order    This is the beginning order number of
                       the records to be changed.

OMC-TO-ORDER           Numeric 8                                 OE16.1
Element: To Order      This is the ending order number of the
                       records to be changed.

OMC-ORIG-LOCATION      Alpha 5                                   OE16.1
Element: Orig Location This is the original order line
                       location to be changed.

OMC-NEW-LOCATION       Alpha 5                                   OE16.1
Element: New Location  This is the location that the order
                       line is to be changed to.

OMC-CUSTOMER           Alpha 9  (Right Justified)                OE16.1
Element: Customer NumbeThis field contains the number that
                       represents a customer.

OMC-ORIG-SHIP-TO       Numeric 4                                 OE16.1
Element: Orig Ship To  This is the original order line
                       customer ship to record to be changed.

OMC-NEW-SHIP-TO        Numeric 4                                 OE16.1
Element: New Ship To   This is the customer ship to that the
                       order line is to be changed to.

OMC-ORIG-CARRIER       Alpha 9  (Right Justified)                OE16.1
Element: Vendor ID     This is the original order line carrier
                       to be changed.

OMC-NEW-CARRIER        Alpha 9  (Right Justified)                OE16.1
Element: Vendor ID     This is the carrier that the order line
                       is to be changed to.

OMC-ORIG-EXP-SH-DT     Numeric 8  (yyyymmdd)                     OE16.1
Element: Orig Exp Sh DtThis is the original order line
                       expected ship date to be changed.

OMC-NEW-EXP-SH-DT      Numeric 8  (yyyymmdd)                     OE16.1
Element: New Exp Sh Dt This is the expected ship date that the
                       order line is to be changed to.

OMC-ORIG-REQ-DATE      Numeric 8  (yyyymmdd)                     OE16.1
Element: Orig Req Date This is the original order line
                       requested date to be changed.

OMC-NEW-REQ-DATE       Numeric 8  (yyyymmdd)                     OE16.1
Element: New Req Date  This is the requested date that the
                       order line is to be changed to.

OMC-ORIG-SALESMAN      Numeric 4                                 OE16.1
Element: Orig Salesman This is the original order line Sales
                       Rep1 to be changed.

OMC-NEW-SALESMAN       Numeric 4                                 OE16.1
Element: New Salesman  This is the Sales Rep1 that the order
                       line is to be changed to.

OMC-ORIG-SALESMAN2     Numeric 4                                 OE16.1
Element: Orig Salesman2This is the original order line Sales
                       Rep2 to be changed.

OMC-NEW-SALESMAN2      Numeric 4                                 OE16.1
Element: New Salesman2 This is the Sales Rep2 that the order
                       line is to be changed to.

OMC-ORIG-COMM1         Percent 7.5  (Percent)                    OE16.1
Element: Orig Comm1    This is the original order line Sales
                       Rep1 commission to be changed.

OMC-NEW-COMM1          Percent 7.5  (Percent)                    OE16.1
Element: New Comm1     This is the Sales Rep1 commission that
                       the order line is to be changed to.

OMC-ORIG-COMM2         Percent 7.5  (Percent)                    OE16.1
Element: Orig Comm2    This is the original order line Sales
                       Rep2 commission to be changed.

OMC-NEW-COMM2          Percent 7.5  (Percent)                    OE16.1
Element: New Comm2     This is the Sales Rep2 commission that
                       the order line is to be changed to.

OMC-ORIG-CMM-SPLIT     Percent 5.3  (Percent)                    OE16.1
Element: Orig Cmm SplitThis is the original order line
                       commission split percentage to be
                       changed.

OMC-NEW-CMM-SPLIT      Percent 5.3  (Percent)                    OE16.1
Element: New Cmm Split This is the commission split percentage
                       that the order line is to be changed to.

OMC-ORIG-ITEM          Alpha 32                                  OE16.1
Element: Item Number   This is the original order line item to
                       be changed.

OMC-NEW-ITEM           Alpha 32                                  OE16.1
Element: New Item      This is the item that the order line is
                       to be changed to.

OMC-ORIG-ENT-DISC      Signed 18.2                               OE16.1
Element: Intl Amt      This is the original order line entered
                       discount (additional discount) to be
                       changed.

OMC-NEW-ENT-DISC       Signed 18.2                               OE16.1
Element: Intl Amt      This is the entered discount
                       (additional discount) that the order
                       line is to be changed to.

OMC-ORIG-USR-FLD1      Alpha 2                                   OE16.1
Element: Orig Usr Fld1 This is the original order line user
                       field 1 to be changed.

OMC-NEW-USR-FLD1       Alpha 2                                   OE16.1
Element: New Usr Fld1  This is the user field 1 that the order
                       line is to be changed to.

OMC-ORIG-USR-FLD2      Alpha 30  (Lower Case)                    OE16.1
Element: Orig Usr Fld2 This is the original order line user
                       field 2 to be changed.

OMC-NEW-USR-FLD2       Alpha 30  (Lower Case)                    OE16.1
Element: New Usr Fld2  This is the user field 2 that the order
                       line is to be changed to.

OMC-ORIG-USR-FLD3      Alpha 15  (Lower Case)                    OE16.1
Element: Orig Usr Fld3 This is the original order line user
                       field 3 to be changed.

OMC-NEW-USR-FLD3       Alpha 15  (Lower Case)                    OE16.1
Element: New Usr Fld3  This is the user field 3 that the order
                       line is to be changed to.

OMC-ORIG-USR-DATE3     Numeric 8  (yyyymmdd)                     OE16.1
Element: Orig Usr Date3This is the original order line user
                       date 3 to be changed.

OMC-NEW-USR-DATE3      Numeric 8  (yyyymmdd)                     OE16.1
Element: New Usr Date3 This is the user date 3 that the order
                       line is to be changed to.

OMC-ORIG-USR-DATE4     Numeric 8  (yyyymmdd)                     OE16.1
Element: Orig Usr Date4This is the original order line user
                       date 4 to be changed.

OMC-NEW-USR-DATE4      Numeric 8  (yyyymmdd)                     OE16.1
Element: New Usr Date4 This is the user date 4 that the order
                       line is to be changed to.

                         OEMASSCHNG FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OMCSET1   COMPANY                                                OE116   OE16.1
          REQUEST

OMCSET2   COMPANY       KeyChange                                OE116
          STATUS
          REQUEST