Home > Technical > Table Definitions > CURRENCYRATE

CURRENCYRATE

Stores details about the currency rates used to convert one currency to another.

Column Type Description
STRCURRENCYCODE VARCHAR(5) Code of the currency to convert from
CURRENCYCODE.strCurrencyCode
STRCURRENCYCODETO VARCHAR(5) Code of the currency to convert to
CURRENCYCODE.strCurrencyCode
DTMEFFECTIVE DATETIME The date the currency rate starts.
DBLRATE NUMERIC The conversion rate required to convert strCurrencyCode to strCurrencyCodeTo for POS purposes.

DBLACCOUNTRATE

DECIMAL(10,6)

The conversion rate required to convert strCurrencyCode to strCurrencyCodeTo for inventory/accounting purposes.

STRGUID

VARCHAR(38)

A unique code assigned by the system.

 

Primary Key: STRCURRENCYCODE + STRCURRENCYCODETO + DTMEFFECTIVE

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)