Database Table: PURCHASELT

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

Column Name Column Type Column Description
CATENTRY_ID BIGINT
NOT NULL
The CatalogEntry offered for sale.
CURRENCY CHARACTER (3)
NULL
The Currency of the minimum or maximum amount. This is a currency code as per ISO 4217 standards.
CURRENTAMOUNT DECIMAL (20,5)
NULL
Current purchase amount.
CURRENTQUANTITY DOUBLE
NULL
Current purchase quantity.
LIMITTYPE CHARACTER (1)
NOT NULL
Indicates the type of limit:
0 = by quantity
1 = by amount
MAXAMOUNT DECIMAL (20,5)
NULL
Maximum purchase amount.
MAXQUANTITY DOUBLE
NULL
Maximum purchase quantity.
MINAMOUNT DECIMAL (20,5)
NULL
Minimum purchase amount.
MINQUANTITY DOUBLE
NULL
Minimum purchase quantity.
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.
Indexes:
Index Name Indexed Column Names Index Type
I0000194 TERMCOND_ID, TRADEPOSCN_ID, CATENTRY_ID Unique Index
SQL030416035041900 PURCHASELT_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable