WebSphere Commerce database table: PURCHASELT

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


Column Description(s):
Column NameColumn TypeDescription
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 Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000194 TERMCOND_ID+TRADEPOSCN_ID+CATENTRY_ID Unique Index
SQL050212031259640 PURCHASELT_ID Primary Key
I0000704 TRADEPOSCN_ID Non-Unique Index
I0000705 CATENTRY_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_630 CATENTRY_ID CATENTRY CATENTRY_ID Cascade
F_632 TERMCOND_ID TERMCOND TERMCOND_ID Cascade
F_631 TRADEPOSCN_ID TRADEPOSCN TRADEPOSCN_ID Cascade

Feedback