Reference > Database > WebSphere Commerce database tables > B
WebSphere Commerce database table: BUYERPO
Each row of this table represents a Purchase Order Number. It is 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 Name Column Type Description BUYERPO_ID BIGINT NOT NULL Generated unique key for this row. SETCCURR CHAR(3) Currency of the Amount field. Alphabetic currency codes 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030305320 BUYERPO_ID Primary Key I0000488 ACCOUNT_ID Non-Unique Index I0000489 BUYERPOTYP_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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 Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_424 BUYERPO_ID LPOPURAMT BUYERPO_ID Cascade F_9004 BUYERPO_ID ORDERS BUYERPO_ID Cascade F_538 BUYERPO_ID ORDPAYMTHD BUYERPO_ID Cascade
Related reference
_vcc_freeselect_bottom_