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