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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PBDSET1PROCURE-GROUP, BID, VENDOR, PURCH-FR-LOCPrimaryPO00.1, PO150, PO16.1, PO16.2, PO216, PO550, PO560
PBDSET2PROCURE-GROUP, BIDSubsetWhere VENDOR = Spaces And PURCH-FR-LOC = Spaces

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
ApvenlocAPVENLOCRequiredPCG-VENDOR-GROUPVLO-VENDOR-GROUP (VLOSET1), PBD-VENDORVLO-VENDOR, PBD-PURCH-FR-LOCVLO-LOCATION-CODE
ApvenmastAPVENMASTRequiredPCG-VENDOR-GROUPVEN-VENDOR-GROUP, PBD-VENDORVEN-VENDOR
ProcuregrpPROCUREGRPRequiredPBD-PROCURE-GROUPPCG-PROCURE-GROUP

One to many (1) — child tables

RelationTableRulesConditionField map
PobiditemPOBIDITEMPBD-PROCURE-GROUPPBT-PROCURE-GROUP, PBD-BIDPBT-BID, PBD-VENDORPBT-VENDOR, PBD-PURCH-FR-LOCPBT-PURCH-FR-LOC, PBT-ITEM, PBT-VEN-ITEM

Programs

Updated by (4)

Referenced by (3)