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 / column | Type | Description & values | Updated by |
|---|---|---|---|
PBD-PROCURE-GROUP PKPROCURE_GROUP | Alpha 4 | This 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 PKBID | Alpha 10 | A 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-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | This field displays the description. | PO16.1, PO16.2, PO550, PO560 |
PBD-VENDOR PKVENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | PO16.1, PO16.2, PO550, PO560 |
PBD-PURCH-FR-LOC PKPURCH_FR_LOC | Alpha 4 | The vendor's purchase from location. | PO16.1, PO16.2, PO550, PO560 |
PBD-CREATE-DATECREATE_DATE | Numeric 8 (yyyymmdd) | The creation date. | PO16.1, PO16.2, PO550, PO560 |
PBD-EFFECTIVE-DATEEFFECTIVE_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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
PBDSET1 | PROCURE-GROUP, BID, VENDOR, PURCH-FR-LOC | Primary | PO00.1, PO150, PO16.1, PO16.2, PO216, PO550, PO560 | |
PBDSET2 | PROCURE-GROUP, BID | Subset | Where VENDOR = Spaces And PURCH-FR-LOC = Spaces | — |
Relations
One to one (3) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| 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 |