WebSphere Commerce database table: CURCONVERT

CURCONVERT

Each row of this table represents a rule. The rule can be used to convert a price (stored in the database in a particular currency) to an amount. The amount is what the customer will be charged in a supported shopping currency (a currency in which payment is accepted).

Column Descriptions:

Name Type Description
STOREENT_ID INTEGER NOT NULL The StoreEntity this conversion rule is part of.
FROMCURR CHAR (3) NOT NULL An amount in the FROMCURR currency is normally part of a rule. Or is part of other information used to determine a price, discount, shipping charge. Or is part of similar amount associated with a product offered for sale.
TOCURR CHAR (3) NOT NULL TOCURR is normally the currency in which the customer intends to pay. Amounts in this currency are normally part of an OrderItem, such as a unit price, shipping charge, or tax amount.
FACTOR DECIMAL (31,20) NOT NULL DEFAULT 1 The conversion factor. Implicit conversion rules may be derived from explicit rules by combining conversion factors. But no more than one unidirectional rule can be used to derive any particular implicit rule.
MULTIPLYORDIVIDE CHAR (1) NOT NULL DEFAULT 'M' To convert from FROMCURR to TOCURR:
M = Multiply by FACTOR
D = Divide by FACTOR
For bidirectional rules, conversion from TOCURR to FROMCURR is allowed using the inverse operation.
BIDIRECTIONAL CHAR (1) NOT NULL DEFAULT 'N' Indicates whether the rule is bidirectional or unidirectional:
Y = bidirectional.
N = unidirectional.

UPDATABLE CHAR (1) NOT NULL DEFAULT 'Y' A flag intended to be used by a user interface that manages currency conversion rules. Valid values:
N = conversion rate is irrevocable - should never be changed
Y = conversion rate can be changed.
CURCONVERT_ID INTEGER NOT NULL Generated unique key.
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> CURCONVERT_ID Primary Key
I0000083 FROMCURR+TOCURR+STOREENT_ID Unique Index
I0000551 STOREENT_ID Non-Unique Index

Constrained By Parent Tables:

Constraint Columns Parent Table Parent Columns Type
F_284 TOCURR SETCURR SETCCURR Cascade
F_285 FROMCURR SETCURR SETCCURR Cascade
F_286 STOREENT_ID STOREENT STOREENT_ID Cascade

Related reference
Currency data model

Name	Type	Description
STOREENT_ID	INTEGER NOT NULL	The StoreEntity this conversion rule is part of.
FROMCURR	CHAR (3) NOT NULL	An amount in the FROMCURR currency is normally part of a rule. Or is part of other information used to determine a price, discount, shipping charge. Or is part of similar amount associated with a product offered for sale.
TOCURR	CHAR (3) NOT NULL	TOCURR is normally the currency in which the customer intends to pay. Amounts in this currency are normally part of an OrderItem, such as a unit price, shipping charge, or tax amount.
FACTOR	DECIMAL (31,20) NOT NULL DEFAULT 1	The conversion factor. Implicit conversion rules may be derived from explicit rules by combining conversion factors. But no more than one unidirectional rule can be used to derive any particular implicit rule.
MULTIPLYORDIVIDE	CHAR (1) NOT NULL DEFAULT 'M'	To convert from FROMCURR to TOCURR: M = Multiply by FACTOR D = Divide by FACTOR For bidirectional rules, conversion from TOCURR to FROMCURR is allowed using the inverse operation.
BIDIRECTIONAL	CHAR (1) NOT NULL DEFAULT 'N'	Indicates whether the rule is bidirectional or unidirectional: Y = bidirectional. N = unidirectional.
UPDATABLE	CHAR (1) NOT NULL DEFAULT 'Y'	A flag intended to be used by a user interface that manages currency conversion rules. Valid values: N = conversion rate is irrevocable - should never be changed Y = conversion rate can be changed.
CURCONVERT_ID	INTEGER NOT NULL	Generated unique key.
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.

Name	Column Names	Type
<SYSTEM-GENERATED>	CURCONVERT_ID	Primary Key
I0000083	FROMCURR+TOCURR+STOREENT_ID	Unique Index
I0000551	STOREENT_ID	Non-Unique Index

Constraint	Columns	Parent Table	Parent Columns	Type
F_284	TOCURR	SETCURR	SETCCURR	Cascade
F_285	FROMCURR	SETCURR	SETCCURR	Cascade
F_286	STOREENT_ID	STOREENT	STOREENT_ID	Cascade