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.
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>CURRSTR+STOREENT_IDPrimary Key
I0000553STOREENT_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_295CURRSTRSETCURRSETCCURRCascade
F_296STOREENT_IDSTOREENTSTOREENT_IDCascade