WebSphere Commerce database table: BUYERPO

Each row of this table represents a Purchase Order Number that the Buyer organization of the Account has defined or used for Trading with the Seller organization. The number is only unique within the Account.


Column Description(s):
Column NameColumn TypeDescription
BUYERPO_ID BIGINT NOT NULL Generated unique key for this row.
SETCCURR CHAR(3) Currency of the Amount field. Alphabetic currency code as per ISO 4217.
ACCOUNT_ID BIGINT The ID of the business account to which the Buyer Purchase Order Number belongs. Foreign key to the ACCOUNT table.
PONUMBER VARCHAR(128) NOT NULL The Buyer Purchase Order Number.
BUYERPOTYP_ID INTEGER NOT NULL Type of the Buyer Purchase Order Number. The types are defined in the BUYERPOTYP table.
STATE INTEGER DEFAULT 0 State of the Purchase Order Number: 0=Undefined, 1=Active, available for Order, 2=Closed, cannot be used for Order.
AMOUNT DECIMAL (20,5) Amount for Limited Purchase Order.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031203900 BUYERPO_ID Primary Key
I0000488 ACCOUNT_ID Non-Unique Index
I0000489 BUYERPOTYP_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_137 ACCOUNT_ID ACCOUNT ACCOUNT_ID Cascade
F_135 BUYERPOTYP_ID BUYERPOTYP BUYERPOTYP_ID Cascade
F_136 SETCCURR SETCURR SETCCURR Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_424 BUYERPO_ID LPOPURAMT BUYERPO_ID Cascade
F_538 BUYERPO_ID ORDPAYMTHD BUYERPO_ID Cascade

Feedback