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 Descriptions:
Name | 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
codes 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 | 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 |
I0000607 | BUYERPO_ID | Non-Unique Index |
I0000608 | ORDERS_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_422 | SETCCURR | SETCURR | SETCCURR | Cascade |
F_423 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |
F_424 | BUYERPO_ID | BUYERPO | BUYERPO_ID | Cascade |