WebSphere Commerce database table: BUYERPOTYP

The Buyer Purchase Order Type table. This table defines the different types of Buyer Purchase Order for the Site.

Column Descriptions
Column Name Column Type Description
BUYERPOTYP_ID INTEGER NOT NULL Types of Buyer Purchase Order (PO):
  1. Blanket PO
  2. Limited PO
  3. Single-use Individual PO
  4. Multiple-use Individual PO (PO Number can be used by more than one order).
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235132880 BUYERPOTYP_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_135 BUYERPOTYP_ID BUYERPO BUYERPOTYP_ID Cascade