Reference > Database > WebSphere Commerce database tables > B


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 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
SQL100520030305470 BUYERPOTYP_ID Primary Key

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

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search