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.

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
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
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
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.5PO16.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 14PO16.1, PO16.2, PO550, PO560

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PBTSET1PROCURE-GROUP, BID, VENDOR, PURCH-FR-LOC, ITEM, VEN-ITEMPrimaryPO00.1, PO150, PO16.1, PO216, PO550, PO560
PBTSET2PROCURE-GROUP, BID, VENDOR, PURCH-FR-LOC, MANUF-CODE, MANUF-DIVISION, MANUF-NBR, ITEMKeyChange, SubsetWhere ITEM != SpacesPO16.2
PBTSET3VENDOR, PURCH-FR-LOC, BID, VEN-ITEM, ITEM, PROCURE-GROUPKeyChange

Programs

Updated by (5)

Referenced by (2)