Multicurrency Tables
====================
----------------------------------------------------------------------
stmcntrc - Multicurrency Control Table

mcurr_ar char(1)
Use multicurrency in Accounts Receivable? Y/N

mcurr_ap char(1)
Use multicurrency in Accounts Payable? Y/N

mcurr_oe char(1)
Use multicurrency in Order Entry? Y/N

mcurr_po char(1)
Use multicurrency in Purchasing? Y/N

home_currency char(3)
home currency or functional currency

ar_rate_type char(6)
rate type for Accounts Receivable

oe_rate_type char(6)
rate type for Order Entry

ap_rate_type char(6)
rate type for Accounts Payable

pu_rate_type char(6)
rate type for Purchasing
---------------------------------------------------------------------
stxcurrr - Multicurrency Reference Table

currency_code char(3)
currency code used to refer to this currency

description char(30)
description of this currency

curr_ex_rate decimal(16)
current exchange rate

per_ex_rate decimal(16)
period exchange rate

ex_diff_acct_no integer
gl account number used for exchange differences
--------------------------------------------------------------------
stxcrtpr - Multicurrency Rate Type Reference

rate_type char(6)
rate type "DAILY" or "STAND"

rate_desc char(30)
rate description

rate_frequency char(1)
rate frequency
--------------------------------------------------------------------
stxdcrtr - Daily Currency Exchange Rate

from_currency_code char(3)
from currency code

to_currency_code char(3)
to currency code

rate_type char(6)
rate type "DAILY"

currency_date date
date of currency rate

rate decimal(16)
exchange rate
--------------------------------------------------------------------
stxpcrtr - Period Currency Exchange Rate

from_currency_code char(3)
from currency code

to_currency_code char(3)
to currency code

rate_type char(6)
rate type "STAND"

period char(3)
period this rate is effective

period_year char(4)
period year this rate is effective

rate
currency exchange rate
--------------------------------------------------------------------