POBIDITEM – Bid Item

System
Purchase Order (PO)
Prefix
PBT
Primary key
PROCURE-GROUP, BID, VENDOR, PURCH-FR-LOC, ITEM, VEN-ITEM
Fields
16
Updated by
5 programs
Referenced by
2 programs

POBIDITEM is the Bid Item table in Lawson Purchase Order (prefix PBT). It is indexed by PROCURE-GROUP, BID, VENDOR, PURCH-FR-LOC, ITEM, VEN-ITEM (PBTSET1); alternate indexes: PBTSET2 and PBTSET3. It is updated by PO150, PO16.1, PO16.2, PO550 and PO560 and referenced by PO00.1 and PO216. The table has 16 fields, 3 indexes and 0 documented relations.

About POBIDITEM

No description in the Lawson data dictionary.

Fields (16)

Column = COBOL field name without the PBT- 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
#PBT-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
#PBT-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
#PBT-ITEM PK
ITEM		Alpha 32This field contains the item identifier.PO16.1, PO16.2, PO550, PO560
#PBT-VENDOR PK
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.PO16.1, PO16.2, PO550, PO560
#PBT-PURCH-FR-LOC PK
PURCH_FR_LOC		Alpha 4The vendor's purchase from location.PO16.1, PO16.2, PO550, PO560
#PBT-VEN-ITEM PK
VEN_ITEM		Alpha 32The vendor's item identifier.PO16.1, PO550, PO560
#PBT-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.PO16.1, PO550, PO560
#PBT-MANUF-CODE SET2
MANUF_CODE		Alpha 4This field contains a user defined code that indicates the manufacturer of an item.PO16.1, PO16.2, PO550, PO560
#PBT-MANUF-DIVISION SET2
MANUF_DIVISION		Alpha 4This is a user defined code that indicates which division of a manufacturer is tied to an item.PO16.1, PO16.2, PO550, PO560
#PBT-MANUF-NBR SET2
MANUF_NBR		Alpha 35This is the identifier that the manufacturer has assigned to an item.PO16.1, PO16.2, PO550, PO560
#PBT-UNIT-PRICE
UNIT_PRICE		Signed 18.5—PO16.1, PO16.2, PO550, PO560
#PBT-BUY-UOM
BUY_UOM		Alpha 4Buying unit of measure.PO16.1, PO16.2, PO550, PO560
#PBT-VPRI-UOM
VPRI_UOM		Alpha 4This field contains the valid stock unit of measure for this item.PO16.1, PO16.2, PO550, PO560
#PBT-USAGE
USAGE		Numeric 8The total purchase quantity within the user defined time period. For manually entered bid items the time period will always be one year prior to entered date.PO16.1, PO16.2, PO550, PO560
#PBT-EXPORT-FL
EXPORT_FL		Alpha 1—
  • Y Yes
  • N No
PO150, PO16.1, PO16.2, PO550, PO560
#PBT-GTIN
GTIN		Numeric 14—PO16.1, PO16.2, PO550, PO560

Indexes (3)

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
PBTSET1
  1. PROCURE-GROUP
  2. BID
  3. VENDOR
  4. PURCH-FR-LOC
  5. ITEM
  6. VEN-ITEM
PrimaryPO00.1, PO150, PO16.1, PO216, PO550, PO560
PBTSET2
  1. PROCURE-GROUP
  2. BID
  3. VENDOR
  4. PURCH-FR-LOC
  5. MANUF-CODE
  6. MANUF-DIVISION
  7. MANUF-NBR
  8. ITEM
KeyChange, SubsetWhere ITEM != SpacesPO16.2
PBTSET3
  1. VENDOR
  2. PURCH-FR-LOC
  3. BID
  4. VEN-ITEM
  5. ITEM
  6. PROCURE-GROUP
KeyChange—

Programs

Updated by (5)

Referenced by (2)