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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000194 | TERMCOND_ID, TRADEPOSCN_ID, CATENTRY_ID | Unique Index |
SQL030416035041900 | PURCHASELT_ID | Primary Key |
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 |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|