WebSphere Commerce database table: LPOPURAMT

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 NameColumn TypeDescription
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 NameIndexed Column NamesIndex Type
I0000607 BUYERPO_ID Non-Unique Index
I0000608 ORDERS_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign 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

Feedback