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 Name Column Type Column Description
ACCOUNT_ID BIGINT
NULL
The ID of the business account to which the Buyer Purchase Order Number belongs. Foreign key to the ACCOUNT table.
AMOUNT DECIMAL (20,5)
NULL
Amount for Limited Purchase Order.
BUYERPOTYP_ID INTEGER
NOT NULL
Type of the Buyer Purchase Order Number. The types are defined in the BUYERPOTYP table.
BUYERPO_ID BIGINT
NOT NULL
Generated unique key for this row.
PONUMBER VARCHAR (128)
NOT NULL
The Buyer Purchase Order Number.
SETCCURR CHARACTER (3)
NULL
Currency of the Amount field. Alphabetic currency code as per ISO 4217.
STATE INTEGER
NULL, DEFAULT 0
State of the Purchase Order Number: 0=Undefined, 1=Active, available for Order, 2=Closed, cannot be used for Order.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034846360 BUYERPO_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_424 BUYERPO_ID LPOPURAMT BUYERPO_ID Cascade
F_538 BUYERPO_ID ORDPAYMTHD BUYERPO_ID Cascade