Each row of this table represents a rule that can be used to convert a price (stored in the database in a particular currency) to an amount the customer will be charged in a supported shopping currency (a currency in which payment is accepted).
Column Name | Column Type | Column Description |
---|---|---|
BIDIRECTIONAL | CHARACTER (1) NOT NULL, DEFAULT 'N' |
Indicates whether the rule is bidirectional or unidirectional: Y = bidirectional. N = unidirectional. |
CURCONVERT_ID | INTEGER NOT NULL |
Generated unique key. |
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. |
FROMCURR | CHARACTER (3) NOT NULL |
An amount in the FROMCURR currency is normally part of a rule or other information used to determine a price, discount, shipping charge, or similar amount associated with a product offered for sale. |
MULTIPLYORDIVIDE | CHARACTER (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. |
STOREENT_ID | INTEGER NOT NULL |
The StoreEntity this conversion rule is part of. |
TOCURR | CHARACTER (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. |
UPDATABLE | CHARACTER (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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000083 | FROMCURR, TOCURR, STOREENT_ID | Unique Index |
SQL030416034919420 | CURCONVERT_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_284 | TOCURR | SETCURR | SETCCURR | Cascade |
F_285 | FROMCURR | SETCURR | SETCCURR | Cascade |
F_286 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|