AR/AP/GL中当前帐套本位币金额
在总账模块中总账行表GL_JE_LINES中ENTERED_DR和ENTERED_CR字段表示总账日记账凭证收入的金额，如果当前输入的金额不是当前帐套的本位币，则在输入时，需要选择汇率折算，折算后数据记录在ACCOUNTED_DR和ACCOUNTED_CR字段中，因此，日记账ACCOUNTED_DR和ACCOUNTED_CR字段金额的币别和当前帐套本位币是一致的。
在应收模块中，RA_CUST_TRX_LINE_GL_DIST_ALL为行分配表，AMOUNT字段为收入金额，ACCTD_AMOUNT字段为折算后本位币金额。
在应付模块中，AP_INVOICES_ALL为发票头表，INVOICE_AMOUNT为发票输入金额，BASE_AMOUNT为本位币金额，AP_INVOICE_DISTRIBUTIONS_ALL发票分配表AMOUNT为行输入金额，BASE_AMOUNT为本位币金额
AR中收入和税的抓取
在表RA_CUST_TRX_LINE_GL_DIST_ALL中，ACCOUNT_CLASS字段标识收入、应收账款或税，收入为REV，税为TAX，应收账款为REC，如果需要同时显示收入和税，并用事务处理编号关联，可以用下面方式取得：
select rev.trx_number as ar_invoice_no,
(rev.rev_amount + tax.tax_amount) as rev_amount,
tax.tax_amount
from ( select arh.customer_trx_id,
arh.trx_number,
sum (arldis.amount) as rev_amount
from ra_customer_trx_all arh, ra_cust_trx_line_gl_dist_all arldis
where arh.customer_trx_id = arldis.customer_trx_id
and arh.set_of_books_id = :p_set_of_books_id --key
and arh.trx_date between to_date (:p_trx_df, 'YYYY-MM-DD') --key
and to_date (:p_trx_dt, 'YYYY-MM-DD') --key
and arldis.account_class = 'REV'
group by arh.customer_trx_id, arh.trx_number) rev,
( select arh.customer_trx_id, sum (arldis.amount) as tax_amount
from ra_customer_trx_all arh, ra_cust_trx_line_gl_dist_all arldis
where arh.customer_trx_id = arldis.customer_trx_id
and arh.set_of_books_id = :p_set_of_books_id --key
and arh.trx_date between to_date (:p_trx_df, 'YYYY-MM-DD') --key
and to_date (:p_trx_dt, 'YYYY-MM-DD') --key
and arldis.account_class = 'TAX'
group by arh.customer_trx_id) tax
where rev.customer_trx_id = tax.customer_trx_id(+)
