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

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	BUYERPO_ID	Primary Key
I0000488	ACCOUNT_ID	Non-Unique Index
I0000489	BUYERPOTYP_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_135	BUYERPOTYP_ID	BUYERPOTYP	BUYERPOTYP_ID	Cascade
F_136	SETCCURR	SETCURR	SETCCURR	Cascade
F_137	ACCOUNT_ID	ACCOUNT	ACCOUNT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_424	BUYERPO_ID	LPOPURAMT	BUYERPO_ID	Cascade
F_538	BUYERPO_ID	ORDPAYMTHD	BUYERPO_ID	Cascade
F_9004	BUYERPO_ID	ORDERS	BUYERPO_ID	Cascade