PURCHASELT

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

Column Descriptions:

NameTypeDescription
PURCHASELT_IDBIGINT NOT NULLThe internal reference number. This is a primary key.
TERMCOND_IDBIGINT NOT NULLThe TermAndCondition ID.
TRADEPOSCN_IDBIGINT NOT NULLThe purchase limit is part of this TradingPositionContainer.
CATENTRY_IDBIGINT NOT NULLThe CatalogEntry offered for sale.
LIMITTYPECHAR (1) NOT NULLIndicates the type of limit. Valid values are as follows:
  • 0=by quantity
  • 1=by amount
CURRENCYCHAR (3)The Currency of the minimum or maximum amount. This is a currency code as per ISO 4217 standards.
MINAMOUNTDECIMAL (20,5)Minimum purchase amount.
MAXAMOUNTDECIMAL (20,5)Maximum purchase amount.
CURRENTAMOUNTDECIMAL (20,5)Current purchase amount.
MINQUANTITYDOUBLEMinimum purchase quantity.
MAXQUANTITYDOUBLEMaximum purchase quantity.
CURRENTQUANTITYDOUBLECurrent purchase quantity.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>PURCHASELT_IDPrimary Key
I0000194TERMCOND_ID+TRADEPOSCN_ID+CATENTRY_IDUnique Index
I0000704TRADEPOSCN_IDNon-Unique Index
I0000705CATENTRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_630CATENTRY_IDCATENTRYCATENTRY_IDCascade
F_631TRADEPOSCN_IDTRADEPOSCNTRADEPOSCN_IDCascade
F_632TERMCOND_IDTERMCONDTERMCOND_IDCascade