Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEWKSHEET


                             OEWKSHEET FILE

                           Pricing Worksheet

The Pricing Worksheet file controls the formal planning process of updating
price bases.  The worksheet file indicates which item's bases to pull into
this worksheet.  See the Billing Procedures Manual for a description of the
worksheet planning process.

REFERENCED BY

BL00.1    BL240

UPDATED BY

BL140     BL141     BL340     BL41.1    BL42.1    BL42.2
BL43.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OWK-COMPANY            Numeric 4                                 BL41.1  BL42.1
Element: Company       The company number represents an          BL43.1
                       established company and must be entered
                       on all form actions. This is the company
                       for which the worksheet will be
                       established.

OWK-WORK-NAME          Alpha 10                                  BL41.1  BL42.1
Element: Base Name     User-defined name of the worksheet that   BL43.1
                       has been or is being created.

OWK-SEL-BASE-LOC       Alpha 5                                   BL140   BL141
Element: Location      If the "Base Location Required" option    BL240   BL340
                       has been selected for the company in the  BL41.1
                       Billing system, the base list must be
                       further identified by location to
                       establish an acceptable worksheet that
                       will update the selected base. Selection
                       of this company level option indicates
                       that base list pricing can differ for
                       the same item, depending on the
                       inventory location of the item.

OWK-SEL-BASE           Alpha 10                                  BL140   BL141
Element: Sel Base      If a base name is entered in this         BL240   BL340
                       field, the current base price tied to     BL41.1
                       this base will be multiplied by the
                       multiplier criteria established on Item
                       Selection (BL41.2) to arrive at the new
                       base prices for all items specified. In
                       order for the bases to finally be
                       updated, Base List Worksheet Update
                       (BL141) must be run.

                       Note:  If vendor selection criteria has
                       been entered on Item Selection (BL41.2),
                       a base name (in this field) can only be
                       entered as the price source to be
                       modified if company prices vary by
                       location. If so, the location field will
                       also be required when defining the
                       worksheet. The reason for this is that
                       the vendor is found on the Item Location
                       record but not the Item Master record. A
                       base that is not tied to a location will
                       not be able to be selected by vendor.

OWK-SEL-CURR           Alpha 5                                   BL140   BL141
Element: To Base Curr  The worksheet feature allows users to     BL240   BL340
                       select a price base that is defined       BL41.1
                       using one currency and update or create
                       another price base in another currency.
                       This field identifies the currency of
                       the price base of the base selected to
                       be modified.

OWK-UPD-LOC            Alpha 5                                   BL41.1  BL42.1
Element: Location      If the "Base Location Required" option
                       has been selected for the company in the
                       Billing system, the base name must be
                       further identified by location to
                       establish base price. Selection of this
                       company level option indicates that base
                       pricing can differ for the same item,
                       depending on the inventory location of
                       the item.


OWK-UPD-BASE           Alpha 10                                  BL41.1  BL42.1
Element: Upd Base      This field contains the base price name
                       that will either be updated by the
                       worksheet or created by the worksheet
                       when Base List Worksheet Update (BL141)
                       is run.

OWK-UPD-CURR           Alpha 5                                   BL41.1  BL42.1
Element: To Base Curr  The worksheet feature allows users to
                       select a price base that is defined
                       using one currency and update or create
                       another price base in another currency.
                       This field identifies the currency of
                       the price base that will be created or
                       updated.

OWK-PLAN-EFF-DATE      Numeric 8  (yyyymmdd)                     BL41.1
Element: Date          This is the date the prices for the
                       updated base will take effect - provided
                       of course that this base has been
                       updated by BL141 (Base List Worksheet
                       Update). This date must be a future date
                       at the time it is entered.

OWK-SEL-LOCATION       Alpha 5                                   BL41.1
Element: Location      The price source to be modified by the
                       percentage indicated (on BL41.2) can be
                       specified as one of the two item costs
                       currently on file for the items at the
                       location entered in this field.

OWK-ISS-COST-PRI       Numeric 1                                 BL41.1
Element: Def Dec Cost  Entering a (1) or (2) in this field
                       will specify whether the item's cost
                       (updated when item was last issued)
                       should be used as the first or second
                       choice for the price source.

OWK-LAST-COST-PRI      Numeric 1                                 BL41.1
Element: Def Dec Cost  Entering a (1) or (2) in this field
                       will indicate whether the item's last
                       received cost should be used as the
                       first or second choice for the price
                       source.
                       1
                       3

OWK-BEG-ITEM           Alpha 32 Occurs 7 Times                   BL41.1
Element: Item          This field represents the first item in
                       the range of items that are to have
                       their price bases updated by the
                       multiplier identified to the right of
                       the range specified.

OWK-END-ITEM           Alpha 32 Occurs 7 Times                   BL41.1
Element: Item          This field represents the last item in
                       the range of items that are to have
                       their price bases updated by the
                       multiplier identified to the right of
                       the range specified.

OWK-ITEM-MULT          Signed 5.4 Occurs 7 Times                 BL41.1
Element: Sclass Mult   This is the number that will be
                       multiplied by the price base for items
                       within the range identified to arrive at
                       the new price base for these items.

OWK-BEG-MAJ-SCLS       Alpha 4 Occurs 14 Times                   BL41.1
Element: Major Class   This field represents the first major
                       sales class in the range of sales
                       classes that are to have their items
                       base prices updated by the multiplier
                       identified to the right of the range
                       specified.

OWK-END-MAJ-SCLS       Alpha 4 Occurs 14 Times                   BL41.1
Element: Major Class   This field represents the ending major
                       sales class in the range of sales
                       classes that are to have their items
                       updated by the multiplier identified to
                       right of the range specified.

OWK-SCLASS-MULT        Signed 5.4 Occurs 14 Times                BL41.1
Element: Sclass Mult   This is the number that will be
                       multiplied by the price base for items
                       belonging to the major sales class range
                       identified to the left to arrive at the
                       new price base for these items.

OWK-SEL-VENDOR         Alpha 9  (Right Justified)                BL41.1
Element: Vendor        If a vendor number is entered in this
                       field, the worksheet will update items
                       on a price base that are supplied only
                       by this vendor. This option can only be
                       selected if the company establishes
                       price bases for each location. If this
                       option is selected, then a location must
                       be selected on BL41.1 (Worksheet)
                       indicating what location the worksheet
                       should use when picking items to update.


OWK-VENDOR-MULT        Signed 5.4                                BL41.1
Element: Sclass Mult   If a multiplier is entered on this
                       field, it will be used in calculating
                       the updated price base for all items
                       supplied by the vendor entered above.

OWK-STATUS             Numeric 1                                 BL140   BL141
Element: Status        This is the status of a given             BL42.1  BL42.2
                       worksheet.                                BL43.1
                       0 = Edit
                       1 = Created
                       2 = Released
                       3 = Processed

OWK-SPRDSHEET-FL       Alpha 1
Element: Write History If this flag is set to Yes, it
                       indicates that this worksheet cannot be
                       changed once it has been created. The
                       idea is that the worksheet will be
                       unloaded to a personal computer
                       spreadsheet format and be maintained
                       there instead of being maintained in the
                       Order Entry system.
                       Y = Yes
                       N = No

OWK-BEG-ITEM-1         Derived
Element: Beg Item 1    Array value of beginning item in range
                       of items to be updated.

OWK-BEG-ITEM-2         Derived
Element: Beg Item 2    Array value of beginning item in second
                       range of items to be updated.

OWK-BEG-ITEM-3         Derived
Element: Beg Item 3    Array value of beginning item in third
                       range of items to be updated.

OWK-BEG-ITEM-4         Derived
Element: Beg Item 4    Array value of beginning item in fourth
                       range of items to be updated.

OWK-BEG-ITEM-5         Derived
Element: Beg Item 5    Array value of beginning item in fifth
                       range of items to be updated.

OWK-BEG-ITEM-6         Derived
Element: Beg Item 6    Array value of beginning item in sixth
                       range of items to be updated.

OWK-BEG-ITEM-7         Derived
Element: Beg Item 7    Array value of beginning item in
                       seventh range of items to be updated.

OWK-END-ITEM-1         Derived
Element: End Item 1    Array value of ending item in first
                       range of items to be updated.

OWK-END-ITEM-2         Derived
Element: End Item 2    Array value of ending item in range of
                       items to be updated.

OWK-END-ITEM-3         Derived
Element: End Item 3    Array value of ending item in third
                       range of items to be updated.

OWK-END-ITEM-4         Derived
Element: End Item 4    Array value of ending item in fourth
                       range of items to be updated.

OWK-END-ITEM-5         Derived
Element: End Item 5    Array value of ending item in fifth
                       range of items to be updated.

OWK-END-ITEM-6         Derived
Element: End Item 6    Array value of ending item in sixth
                       range of items to be updated.

OWK-END-ITEM-7         Derived
Element: End Item 7    Array value of ending item in seventh
                       range of items to be updated.

                         OEWKSHEET FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OWKSET1   COMPANY                                                BL00.1  BL140
          WORK-NAME                                              BL141   BL240
                                                                 BL340   BL41.1
                                                                 BL42.1  BL42.2
                                                                 BL43.1

OWKSET2   WORK-NAME                                              BL140   BL141
          COMPANY

                         OEWKSHEET FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apcompany      APCOMPANY    Required
                            When OWK-SEL-VENDOR != Spaces

                            OWK-COMPANY         -> CPY-COMPANY

Apvenmast      APVENMAST    Required
                            When OWK-SEL-VENDOR != Spaces

                            CPY-VENDOR-GROUP    -> VEN-VENDOR-GROUP
                            OWK-SEL-VENDOR      -> VEN-VENDOR

Iclocation     ICLOCATION   Required
                            When OWK-SEL-LOCATION != Spaces

                            OWK-COMPANY         -> ICL-COMPANY
                            OWK-SEL-LOCATION    -> ICL-LOCATION

Oecompany      OECOMPANY    Required

                            OWK-COMPANY         -> OEC-COMPANY

Sel Curr       CUCODES      Required
                            When OWK-SEL-CURR != Spaces

                            OWK-SEL-CURR        -> CUC-CURRENCY-CODE

Sel Location   ICLOCATION   Required
                            When OWK-SEL-BASE-LOC != Spaces

                            OWK-COMPANY         -> ICL-COMPANY
                            OWK-SEL-BASE-LOC    -> ICL-LOCATION

Upd Curr       CUCODES      Required
                            When OWK-UPD-CURR != Spaces

                            OWK-UPD-CURR        -> CUC-CURRENCY-CODE

Upd Location   ICLOCATION   Required
                            When OWK-UPD-LOC != Spaces

                            OWK-COMPANY         -> ICL-COMPANY
                            OWK-UPD-LOC         -> ICL-LOCATION

                         OEWKSHEET FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Itemloc        ITEMLOC      Required
                            When OWK-SEL-BASE-LOC != Spaces

                            OWK-COMPANY         -> ITL-COMPANY
                            OWK-SEL-LOCATION    -> ITL-LOCATION
                                                   ITL-ITEM

Oeselbase      OEBASE       Required
                            When OWK-SEL-BASE != Spaces

                            OWK-COMPANY         -> OEB-COMPANY
                            OWK-SEL-BASE-LOC    -> OEB-LOCATION
                            OWK-SEL-BASE        -> OEB-BASE-NAME
                                                   OEB-CURRENCY-CODE
                                                   OEB-ITEM

Oeupdbase      OEBASE

                            OWK-COMPANY         -> OEB-COMPANY
                            OWK-UPD-LOC         -> OEB-LOCATION
                            OWK-UPD-BASE        -> OEB-BASE-NAME
                                                   OEB-CURRENCY-CODE
                                                   OEB-ITEM

Oewkprice      OEWKPRICE

                            OWK-COMPANY         -> OWP-COMPANY
                            OWK-WORK-NAME       -> OWP-WORK-NAME
                                                   OWP-ITEM