This table is used to keep track of Purchase Amounts by Purchase Order number and by Orders. Entries are created only for Orders against Limited Purchase Order (PO) numbers.
Column Description(s):
Column Name | Column Type | Description |
ORDERS_ID |
BIGINT NOT NULL |
Order ID. Foreign key to the ORDERS table. |
SETCCURR |
CHAR(3) |
Currency of the Amount field. Alphabetic currency code as per ISO 4217. |
BUYERPO_ID |
BIGINT NOT NULL |
ID of the Buyer Purchase Order Number of the Limited PO. |
AMOUNT |
DECIMAL (20,5) NOT NULL |
Expected purchase amounts for this Order against this Limited PO. The amount is in the same currency as the Purchase Limit Amount specified in the Limited PO. |
OPTCOUNTER |
SMALLINT |
Reserved for IBM internal use. |
Index(es):
Index Name | Indexed Column Names | Index Type |
I0000607 |
BUYERPO_ID |
Non-Unique Index |
I0000608 |
ORDERS_ID |
Non-Unique Index |
Constraint(s):
Constraint Name | Column Name(s) | Foreign Table Name | Foreign Column Name(s) | Constraint Type |
F_424 |
BUYERPO_ID |
BUYERPO |
BUYERPO_ID |
Cascade |
F_423 |
ORDERS_ID |
ORDERS |
ORDERS_ID |
Cascade |
F_422 |
SETCCURR |
SETCURR |
SETCCURR |
Cascade |
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.