POBID – Bid

System
Purchase Order (PO)
Prefix
PBD
Primary key
PROCURE-GROUP, BID, VENDOR, PURCH-FR-LOC
Fields
7
Updated by
4 programs
Referenced by
3 programs

POBID is the Bid table in Lawson Purchase Order (prefix PBD). It is indexed by PROCURE-GROUP, BID, VENDOR, PURCH-FR-LOC (PBDSET1); alternate indexes: PBDSET2. It is related 1:1 to APVENLOC, APVENMAST and PROCUREGRP and 1:M to POBIDITEM. It is updated by PO16.1, PO16.2, PO550 and PO560 and referenced by PO00.1, PO150 and PO216. The table has 7 fields, 2 indexes and 4 documented relations.

About POBID

No description in the Lawson data dictionary.

Fields (7)

Column = COBOL field name without the PBD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PBD-PROCURE-GROUP PK
PROCURE_GROUP		Alpha 4This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.PO16.1, PO16.2, PO550, PO560
#PBD-BID PK
BID		Alpha 10A user assigned name for a group of items that have been sent to vendors for price quotes, or catalog pricing that has been received from a vendor.PO16.1, PO16.2, PO550, PO560
#PBD-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.PO16.1, PO16.2, PO550, PO560
#PBD-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.PO16.1, PO16.2, PO550, PO560
#PBD-PURCH-FR-LOC PK
PURCH_FR_LOC		Alpha 4The vendor's purchase from location.PO16.1, PO16.2, PO550, PO560
#PBD-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)The creation date.PO16.1, PO16.2, PO550, PO560
#PBD-EFFECTIVE-DATE
EFFECTIVE_DATE		Numeric 8 (yyyymmdd)The date a vendor's prices will be in effect.PO16.1, PO16.2, PO550, PO560

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PBDSET1
  1. PROCURE-GROUP
  2. BID
  3. VENDOR
  4. PURCH-FR-LOC
PrimaryPO00.1, PO150, PO16.1, PO16.2, PO216, PO550, PO560
PBDSET2
  1. PROCURE-GROUP
  2. BID
SubsetWhere VENDOR = Spaces And PURCH-FR-LOC = Spaces—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APVENLOCAPVENMASTPROCUREGRPPOBIDITEMPOBID

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ApvenlocAPVENLOCRequired
PCG-VENDOR-GROUP→VLO-VENDOR-GROUP (VLOSET1)
PBD-VENDOR→VLO-VENDOR
PBD-PURCH-FR-LOC→VLO-LOCATION-CODE
ApvenmastAPVENMASTRequired
PCG-VENDOR-GROUP→VEN-VENDOR-GROUP
PBD-VENDOR→VEN-VENDOR
ProcuregrpPROCUREGRPRequired
PBD-PROCURE-GROUP→PCG-PROCURE-GROUP

One to many (1) — child tables

RelationTableRulesConditionField map
PobiditemPOBIDITEM
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

Programs

Updated by (4)

Referenced by (3)