OFFERPRICE

Each row of this table represents a price in a currency for an Offer.

Column Descriptions:

NameTypeDescription
OFFER_IDBIGINT NOT NULLThe Offer.
CURRENCYCHAR (3) NOT NULLThe currency of the price. This is a currency code as per ISO 4217 standards.
PRICEDECIMAL (20,5) NOT NULLThe price for the nominal quantity (see CATENTSHIP.NOMINALQUANTITY) of the product referred to by the Offer.
COMPAREPRICEDECIMAL (20,5)Reserved for IBM internal use.
OPTCOUNTERSMALLINTThe 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>OFFER_ID+CURRENCYPrimary Key
I0000168PRICE+CURRENCY+OFFER_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_472OFFER_IDOFFEROFFER_IDCascade
F_473CURRENCYSETCURRSETCCURRCascade