Changing the currency prefix

Complete the following steps to change the prefix of the currency amount:

Procedure

  1. To change a positive currency prefix, use the following XML code in the XML file that you are loading into your target database: 
    
<curfmtdesc 
  storeent_id="-1"
  setccurr="USD"
  language_id="&en_US;"
  numbrusg_id="-3"
  currencyprefixpos="F"
/>

    where:

    storeent_id
    The store or store group ID.
    setccurr
    The three-character ISO 4217 currency code representing the currency that you want to format. This code must appear in the SETCCURR column of the SETCURR table.
    language_id
    The language ID of the format record.
    numbrusg_id
    The ID of the number usage.
    currencyprefixpos
    The string that you want to display to the left of the amount.

    To change a negative currency prefix, use the following line in the XML file that you are loading into your target database:

    
<curfmtdesc 
  storeent_id="-1" 
  setccurr="USD"
  language_id="&en_US;"
  numbrusg_id="-3" 
  currencyprefixneg="-"
/>

    Where:

    storeent_id
    The store or store group ID.
    setccurr
    The three-character ISO 4217 currency code representing the currency that you want to format. This code must appear in the SETCCURR column of the SETCURR table.
    language_id
    The language ID of the format record.
    numbrusg_id
    The ID of the number usage.
    currencyprefixneg
    The string that you want to display to the left of the amount.
  2. Load the data to the WebSphere Commerce database. For instructions on how to load the data to the database, see Loading the data to the WebSphere Commerce database.

Results

Note: If the currency data for the Korean currency (KRW) uses an image for the currency symbol, the image is specified using a relative URL. The URL (<IMG src=images/won.gif align=bottom>) is relative to the page that contains the formatted currency. The image might not resolve to the directory that contains the image that is supplied by WebSphere Commerce, in the web/images directory of the installation directory. You can change the currency data in the CURFMTDESC table to use an absolute URL (that resolves to a directory that contains the won.gif) or ensure that the won.gif is copied to a subdirectory called images in all directories that contain JSP files that might reference the Korean currency.