This table stores information on stipulations or limitations on how much a customer can purchase based on a Contract.
Column Description(s):
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 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 Name | Indexed Column Names | Index 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 Name | Column Name(s) | Foreign Table Name | Foreign 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 |
Related reference
(C) Copyright IBM Corporation 1996, 2005. All Rights Reserved.