PURCHASELT

This table stores information on stipulations or limitations on how much a customer can purchase based on a Contract.

Column Descriptions:

Name	Type	Description
PURCHASELT_ID	BIGINT NOT NULL	The internal reference number. This is a primary key.
TERMCOND_ID	BIGINT NOT NULL	The TermAndCondition ID.
TRADEPOSCN_ID	BIGINT NOT NULL	The purchase limit is part of this TradingPositionContainer.
CATENTRY_ID	BIGINT NOT NULL	The CatalogEntry offered for sale.
LIMITTYPE	CHAR (1) NOT NULL	Indicates the type of limit. Valid values are as follows: 0=by quantity 1=by amount
CURRENCY	CHAR (3)	The Currency of the minimum or maximum amount. This is a currency code as per ISO 4217 standards.
MINAMOUNT	DECIMAL (20,5)	Minimum purchase amount.
MAXAMOUNT	DECIMAL (20,5)	Maximum purchase amount.
CURRENTAMOUNT	DECIMAL (20,5)	Current purchase amount.
MINQUANTITY	DOUBLE	Minimum purchase quantity.
MAXQUANTITY	DOUBLE	Maximum purchase quantity.
CURRENTQUANTITY	DOUBLE	Current purchase quantity.
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
<SYSTEM-GENERATED>	PURCHASELT_ID	Primary Key
I0000194	TERMCOND_ID+TRADEPOSCN_ID+CATENTRY_ID	Unique Index
I0000704	TRADEPOSCN_ID	Non-Unique Index
I0000705	CATENTRY_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_630	CATENTRY_ID	CATENTRY	CATENTRY_ID	Cascade
F_631	TRADEPOSCN_ID	TRADEPOSCN	TRADEPOSCN_ID	Cascade
F_632	TERMCOND_ID	TERMCOND	TERMCOND_ID	Cascade