一、事务处理
–事务处理批表
select * from ar.ra_batches_all;
–事务处理主表
select * from ar.ra_customer_trx_all;
–事务处理行表
select * from ar.ra_customer_trx_lines_all;
–事务处理分配行表
select * from ar.ra_cust_trx_line_gl_dist_all;
–收款计划/事物处理调整
select * from ar.ar_payment_schedules_all;
二、收款
–收款表
select * from ar.ar_cash_receipts_all;
–收款历史表
select * from ar.ar_cash_receipt_history_all;
–收款分配表
select * from ar.ar_distributions_all;
–杂项历史记录分配表
select * from ar.ar_misc_cash_distributions_all;
–收款核销表(status:UNAPP 未核销,APP 已核销,REV 已冲销)
select * from ar.ar_receivable_applications_all;
注意:红冲收款报表时间跨月的问题,必须联查 AR_CASH_RECEIPTS_ALL 和 AR_CASH_RECEIPT_HISTORY_ALL
三、客户
–客户组织表
select * from ar.hz_parties;
–客户地点
select * from ar.hz_party_sites;
–客户帐户表
select * from ar.hz_cust_accounts;
–客户地点帐户表
select * from ar.hz_cust_acct_sites_all;
–客户地点业务目的
select * from ar.hz_cust_site_uses_all;
–客户地点地址
select * from ar.hz_locations;
四、接口相关表
–应收接口行表
select * from ar.ra_interface_lines_all;
–应收接口分配行表
select * from ar.ra_interface_distributions_all;
–收款标准接口
select * from ar.ar_interim_cash_receipts_all;