Reference > Database > WebSphere Commerce database tables > P
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 Name Column 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...
- 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.
Indexes Index Name Indexed Column Names Index Type I0000194 TERMCOND_ID+TRADEPOSCN_ID+CATENTRY_ID Unique Index SQL100520030415170 PURCHASELT_ID Primary Key I0000704 TRADEPOSCN_ID Non-Unique Index I0000705 CATENTRY_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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 _vcc_freeselect_bottom_