Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OEPBITEM


                             OEPBITEM FILE

                            Price Book Item

This file stores the comments that have been specified to print for an item
that is to print on the price book.

REFERENCED BY

BL243

UPDATED BY

BL48.1    BL48.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PBI-COMPANY            Numeric 4                                 BL48.3
Element: Company       Enter the company number for which the
                       price book will be established.

PBI-BOOK-NAME          Alpha 10                                  BL48.3
Element: Base Name     Enter the price book name. This is a
                       user-defined name.

PBI-ITEM               Alpha 32                                  BL48.3
Element: Item          Enter the item that will have the price
                       lists itemized on the price book.

PBI-COMMENTS           Alpha 50  (Lower Case)                    BL243   BL48.3
Element: Comments      Occurs 10 Times
                       This field contains the text you enter
                       for the comment to be associated with an
                       asset. You can have multiple lines of
                       comments for each comment type.


                         OEPBITEM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PBISET1   COMPANY                                                BL243   BL48.1
          BOOK-NAME                                              BL48.3
          ITEM

                         OEPBITEM FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            PBI-COMPANY         -> ICC-COMPANY

Itemmast       ITEMMAST     Required

                            ICC-ITEM-GROUP      -> ITE-ITEM-GROUP
                            PBI-ITEM            -> ITE-ITEM

Oecompany      OECOMPANY    Required

                            PBI-COMPANY         -> OEC-COMPANY

Oeprcbook      OEPRCBOOK    Required

                            PBI-COMPANY         -> OPB-COMPANY
                            PBI-BOOK-NAME       -> OPB-BOOK-NAME

Oeprclist1     OEPRCLIST    Not Required

                            PBI-COMPANY         -> OPL-COMPANY
                            "000000000"         -> OPL-CUSTOMER
                            OPB-PRICE-LIST-1    -> OPL-LIST-NAME
                            Spaces              -> OPL-PROMOTION

Oeprclist2     OEPRCLIST    Not Required

                            PBI-COMPANY         -> OPL-COMPANY
                            "000000000"         -> OPL-CUSTOMER
                            OPB-PRICE-LIST-2    -> OPL-LIST-NAME
                            Spaces              -> OPL-PROMOTION

Oeprclist3     OEPRCLIST    Not Required

                            PBI-COMPANY         -> OPL-COMPANY
                            "000000000"         -> OPL-CUSTOMER
                            OPB-PRICE-LIST-3    -> OPL-LIST-NAME
                            Spaces              -> OPL-PROMOTION

                         OEPBITEM FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oebase         OEBASE

                            PBI-COMPANY         -> OEB-COMPANY
                            OPB-BASE-LOC        -> OEB-LOCATION
                            OPB-BASE-NAME       -> OEB-BASE-NAME
                                                   OEB-CURRENCY-CODE
                                                   OEB-ITEM