CURLIST

Each row of this table represents an explicitly supported currency for a StoreEntity. A Store implicitly supports all its default currencies (see the STOREENT and STORELANG tables), and all currencies supported by its StoreGroup.

Column Descriptions:

NameTypeDescription
STOREENT_IDINTEGER NOT NULLThe StoreEntity.
CURRSTRCHAR (3) NOT NULLThe supported currency. A store must be able to accept payment in all its supported currencies. This is a currency code as per ISO 4217 standards.
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>CURRSTR+STOREENT_IDPrimary Key
I0000553STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_295CURRSTRSETCURRSETCCURRCascade
F_296STOREENT_IDSTOREENTSTOREENT_IDCascade