Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEWKPRICE


                             OEWKPRICE FILE

                        Pricing Worksheet Price

This file stores the individual item price bases for a specific pricing
worksheet.  See the Billing Procedures Manual for a description of the
worksheet process.

REFERENCED BY

BL141     BL240     BL41.1

UPDATED BY

BL140     BL42.1    BL42.2    BL340

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

OWP-WORK-NAME          Alpha 10                                  BL140   BL42.1
Element: Base Name     This field identifies the name of the     BL42.2
                       worksheet.

OWP-ITEM               Alpha 32                                  BL140   BL42.1
Element: Item          This field contains the item identifier   BL42.2
                       that will have the price updated by the
                       worksheet.

OWP-NXT-EFF-DATE       Numeric 8  (yyyymmdd)                     BL140   BL42.1
Element: Date          This will become the effective date for   BL42.2
                       the next price on the updated base.

OWP-NXT-MULT-SPR       Numeric 1                                 BL140
Element: Cur Mult Spr  Next multiple sell price unit of
                       measure flag. If this is set, this item
                       has pricing based on unit of measure.
                       0 = Single price UOM
                       1 = Multiple price UOM

OWP-NXT-SPR-UOM        Alpha 4 Occurs 10 Times                   BL140   BL42.1
Element: Uom           This field contains the valid stock       BL42.2
                       unit of measure for this item.


OWP-NXT-SPR-MULT       Signed 13.7 Occurs 10 Times               BL140   BL42.1
Element: Uom Mult      If the item for which the price           BL42.2
                       worksheet has been created is priced
                       using multiple sell price units of
                       measure, these fields indicate the
                       beginning date of the next price base.

OWP-NXT-PRICE          Signed 18.5 Occurs 10 Times               BL140   BL42.1
Element: Intl Cost     This is the price base that will be       BL42.2
                       updated beginning with the effective
                       date specified.

OWP-NXT-SPR-CD         Alpha 1 Occurs 10 Times                   BL140   BL42.1
Element: Cur Spr Cd    This field identifies the sell pricing    BL42.2
                       unit of measure that will be used to
                       establish the next price base of the
                       item.
                       1 = Default sell price UOM
                       2 = Valid sell price UOM
                       " "

                         OEWKPRICE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OWPSET1   COMPANY                                                BL140   BL141
          WORK-NAME                                              BL240   BL340
          ITEM                                                   BL41.1  BL42.1
                                                                 BL42.2

                         OEWKPRICE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            OWP-COMPANY         -> ICC-COMPANY

Itemmast       ITEMMAST     Required

                            ICC-ITEM-GROUP      -> ITE-ITEM-GROUP
                            OWP-ITEM            -> ITE-ITEM

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

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

Oebasews       OEWKSHEET    Required

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

Oecompany      OECOMPANY    Required

                            OWP-COMPANY         -> OEC-COMPANY

Oewksheet      OEWKSHEET    Required

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