Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             POBIDITEM FILE

                                Bid Item

REFERENCED BY

PO00.1    PO216

UPDATED BY

PO16.1    PO16.2    PO550     PO560

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PBT-PROCURE-GROUP    Alpha 4                                     PO16.1  PO16.2
Procure Group        This field contains the identifier for a    PO550   PO560
                     group of companies that share a common
                     procurement effort. They buy items and
                     services together.

PBT-BID              Alpha 10                                    PO16.1  PO16.2
Bid Name             A user assigned name for a group of         PO550   PO560
                     items that have been sent to vendors for
                     price quotes, or catalog pricing that
                     has been received from a vendor.

PBT-ITEM             Alpha 32                                    PO16.1  PO16.2
Item Number          This field contains the item                PO550   PO560
                     identifier.

PBT-VENDOR           Alpha 9  (Right Justified)                  PO16.1  PO16.2
Vendor ID            The vendor's identification code.           PO550   PO560



PBT-PURCH-FR-LOC     Alpha 4                                     PO16.1  PO16.2
Purchase From        The vendor's purchase from location.        PO550   PO560
Location Code

PBT-VEN-ITEM         Alpha 32                                    PO16.1  PO550
Vendor Item          The vendor's item identifier.               PO560

PBT-DESCRIPTION      Alpha 30  (Lower Case)                      PO16.1  PO550
Description          This field displays the description.        PO560

PBT-MANUF-CODE       Alpha 4                                     PO16.1  PO16.2
Manufacturer's Code  This field contains a user defined code     PO550   PO560
                     that indicates the  manufacturer of an
                     item.

PBT-MANUF-DIVISION   Alpha 4                                     PO16.1  PO16.2
Manufacturer's       This is a user defined code that            PO550   PO560
Division             indicates which division of a
                     manufacturer is tied to an item.

PBT-MANUF-NBR        Alpha 15                                    PO16.1  PO16.2
Manufacturer's Item  This is the identifier that the             PO550   PO560
Number               manufacturer has assigned to an item.

PBT-UNIT-PRICE       Signed 13.5                                 PO16.1  PO16.2
Unit Price           This field contains the unit price.         PO550   PO560

PBT-BUY-UOM          Alpha 4                                     PO16.1  PO16.2
Buying Unit of       Buying unit of measure.                     PO550   PO560
Measure

PBT-VPRI-UOM         Alpha 4                                     PO16.1  PO16.2
Vendor Price Unit    This is the vendor pricing unit of          PO550   PO560
of Measure           measure.

PBT-USAGE            Numeric 8                                   PO16.1  PO16.2
Purchase Quantity    The total purchase quantity within the      PO550   PO560
                     user defined time period. For manually
                     entered bid items the time period will
                     always be one year prior to entered
                     date.

PBT-EXPORT-FL        Alpha 1                                     PO16.1  PO16.2
Load Flag            Flag to control whether or not an item      PO550   PO560
                     will be loaded to contracts or quotes.
                     Y = Yes
                     N = No

                         POBIDITEM FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PBTSET1   PROCURE-GROUP                                          PO00.1  PO16.1
          BID                                                    PO216   PO550
          VENDOR
          PURCH-FR-LOC
          ITEM
          VEN-ITEM

PBTSET2   PROCURE-GROUP KeyChange, Subset                        PO16.2  PO560
          BID           Where ITEM != Spaces
          VENDOR
          PURCH-FR-LOC
          MANUF-CODE
          MANUF-DIVISION
          MANUF-NBR
          ITEM

PBTSET3   VENDOR        KeyChange
          PURCH-FR-LOC
          BID
          VEN-ITEM
          ITEM
          PROCURE-GROUP