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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034846360 | BUYERPO_ID | Primary Key |
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 |
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 |