This table stores information on stipulations or
limitations on how much a customer can purchase based on a
Contract.
Column Descriptions:
Name | 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 NOT NULL DEFAULT 0 | The optimistic concurrency control counter for
the table. Every time there is an update to the table, the counter
is incremented. |
Indexes:
Name | Column Names | Type |
<SYSTEM-GENERATED> | PURCHASELT_ID | Primary Key |
I0000194 | TERMCOND_ID+TRADEPOSCN_ID+CATENTRY_ID | Unique Index |
I0000704 | TRADEPOSCN_ID | Non-Unique Index |
I0000705 | CATENTRY_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | 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 |