Adding New Currency
To add a
new currency (not supported by default) to WebSphere Commerce as a site
supported currency:
Procedure
- Add your national currency as a site-supported currency:
insert into setcurr (setccurr, setccode, setcexp) values (<Alphabetic currency code as per ISO 4217>,
<Numeric currency code as per ISO 4217>,<The exponential value by which a subunit of the currency (such as cents)is multiplied to get the main currency unit>)
For example:
insert into setcurr (setccurr, setccode, setcexp) values ('THB',818, -2);
insert into setcurr (setccurr, setccode, setcexp) values ('THB',818, -2);
- Add a description to your national currency at the site level for
your language_id. You can
add a description to your national currency in as many languages as your
system supports.
insert into setcurrdsc (setccurr, language_id, description) values(<Alphabetic currency code>, <language_id>,<description>)
Ex:
insert
into setcurrdsc (setccurr, language_id, description) values('THB',-1015,'Thailand Baht');
- Add a currency formatting rule
insert into curformat (storeent_id, setccurr, roundingmultiple,numbrusg_id,roundingmethod, decimalplaces) values (<storeentity> ,
<Alphabetic currency code>, <Rounding multiple according to national law or practice. For example, specify 5 to round dollars to the nearest five cent piece.
The default value is 1>, <How to round to a multiple of ROUNDINGMULTIPLE: R = round normally - up or down - to the nearest multiple T = truncate
- round down for positive amounts, round up for negative amounts>,
<The number of decimal places in a rounded or truncated monetary
amount>);
For example:
insert into curformat (storeent_id, setccurr, roundingmultiple,numbrusg_id, roundingmethod, decimalplaces, minapproveamount) values(-1,'THB',1,-1,'R',0,NULL)
insert into curformat (storeent_id, setccurr, roundingmultiple,numbrusg_id, roundingmethod, decimalplaces, minapproveamount) values(-1,'THB',1,-4,'R',0,NULL)
insert into curformat (storeent_id, setccurr, roundingmultiple,numbrusg_id,roundingmethod, decimalplaces, minapproveamount) values(-1,'THB',1,-5,'R',0,NULL)
insert into curformat (storeent_id, setccurr, roundingmultiple,numbrusg_id, roundingmethod, decimalplaces, minapproveamount) values(-1,'THB',1,-1,'R',0,NULL)
insert into curformat (storeent_id, setccurr, roundingmultiple,numbrusg_id, roundingmethod, decimalplaces, minapproveamount) values(-1,'THB',1,-4,'R',0,NULL)
insert into curformat (storeent_id, setccurr, roundingmultiple,numbrusg_id,roundingmethod, decimalplaces, minapproveamount) values(-1,'THB',1,-5,'R',0,NULL)
Like USD:
insert into
curformat (storeent_id, setccurr, roundingmultiple,numbrusg_id,roundingmethod,
decimalplaces, minapproveamount) values(-1,'THB',1,-1,'R',2,NULL);
- Add a currency formatting description.
insert into curfmtdesc (storeent_id, numbrusg_id, setccurr, language_id,currencysymbol,customizedcurrstr, currencyprefixpos, currencysuffixpos,displaylocale,
currencyprefixneg, currencysuffixneg, radixpoint, groupingchar,numberpattern, description) values (-1,-1, 'THB', -1015, 'B', null, 'B', null,null, 'B-', null, null, null, '#,##0.00', 'Thailand Baht');
For more information refer to the CURFMTDESC table.
- Add a conversion rule between the default currency of the store and
the created currency:
insert into curconvert (storeent_id, fromccurr, tocurr, factor,multiplyordivide, bidirectional, updatable, curconvert_id)values(-1,'USD','THB','44.62','M','Y','Y',-12);
For Example: Adding THB for language -1015 (custom) and -1 (en_US)
---Thailand Baht
-THB---
insert into setcurr
(setccurr, setccode, setcexp) values ('THB',764, -2);
insert into
setcurrdsc (setccurr, language_id, description) values('THB',-1015,'Thailand
Baht');
insert into
setcurrdsc (setccurr, language_id, description) values('THB',-1,'Thailand
Baht');
insert into
curformat (storeent_id, setccurr, roundingmultiple,numbrusg_id,roundingmethod,
decimalplaces, minapproveamount) values(-1,'THB',1,-1,'R',2,NULL);
insert into
curfmtdesc (storeent_id, numbrusg_id, setccurr,
language_id,currencysymbol,customizedcurrstr, currencyprefixpos,
currencysuffixpos,displaylocale,currencyprefixneg, currencysuffixneg,
radixpoint, groupingchar,numberpattern, description) values (-1,-1, 'THB',
-1015, 'THB', null, 'THB', null,null, 'THB-', null, null, null, '#,##0.00',
'Thailand Baht');
insert into
curfmtdesc (storeent_id, numbrusg_id, setccurr,
language_id,currencysymbol,customizedcurrstr, currencyprefixpos,
currencysuffixpos,displaylocale,currencyprefixneg, currencysuffixneg,
radixpoint, groupingchar,numberpattern, description) values (-1,-1, 'THB', -1,
'THB', null, 'THB', null,null, 'THB-', null, null, null, '#,##0.00', 'Thailand
Baht');
insert into
curconvert (storeent_id, fromcurr, tocurr, factor,multiplyordivide,
bidirectional, updatable,
curconvert_id)values(-1,'USD','THB','44.62','M','Y','Y',-12);
