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 | 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 |