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
--------------------------------------------------------------------