Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

POBID


                               POBID FILE

                                  Bid

REFERENCED BY

PO00.1    PO150     PO216

UPDATED BY

PO16.1    PO16.2    PO550     PO560

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PBD-PROCURE-GROUP      Alpha 4                                   PO16.1  PO16.2
Element: 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.

PBD-BID                Alpha 10                                  PO16.1  PO16.2
Element: Bid           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.

PBD-DESCRIPTION        Alpha 30  (Lower Case)                    PO16.1  PO16.2
Element: Description   This field displays the description.      PO550   PO560

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



PBD-PURCH-FR-LOC       Alpha 4                                   PO16.1  PO16.2
Element: Purch Fr Loc  The vendor's purchase from location.      PO550   PO560

PBD-CREATE-DATE        Numeric 8  (yyyymmdd)                     PO16.1  PO16.2
Element: Create Date   The creation date.                        PO550   PO560

PBD-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     PO16.1  PO16.2
Element: Effective DateThe date a vendor's prices will be in     PO550   PO560
                       effect.

                         POBID FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PBDSET1   PROCURE-GROUP                                          PO00.1  PO150
          BID                                                    PO16.1  PO16.2
          VENDOR                                                 PO216   PO550
          PURCH-FR-LOC                                           PO560

PBDSET2   PROCURE-GROUP Subset
          BID           Where VENDOR       = Spaces
                        And   PURCH-FR-LOC = Spaces

PBDSET3   PROCURE-GROUP Subset
          BID           Where VENDOR != Spaces
          VENDOR
          PURCH-FR-LOC

                         POBID FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Apvenloc       APVENLOC     Required

                            PCG-VENDOR-GROUP     -> VLO-VENDOR-GROUP  (VLOSET1)
                            PBD-VENDOR           -> VLO-VENDOR
                            PBD-PURCH-FR-LOC     -> VLO-LOCATION-CODE

Apvenmast      APVENMAST    Required

                            PCG-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            PBD-VENDOR           -> VEN-VENDOR

Procuregrp     PROCUREGRP   Required

                            PBD-PROCURE-GROUP    -> PCG-PROCURE-GROUP

                         POBID FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pobiditem      POBIDITEM

                            PBD-PROCURE-GROUP    -> PBT-PROCURE-GROUP
                            PBD-BID              -> PBT-BID
                            PBD-VENDOR           -> PBT-VENDOR
                            PBD-PURCH-FR-LOC     -> PBT-PURCH-FR-LOC
                                                    PBT-ITEM
                                                    PBT-VEN-ITEM