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 Descriptions
| 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.
|