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 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 NOT NULL DEFAULT 0	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