2014-06-04 Created By BaoXinjian
1. 创建Invoice，并查看所创建的科目
因为其Primary Ledger<US_USD_P>， 其对应一个Second Ledger<US_USD>，所以其会创建两套科目
2. Invoice 科目分析
(1).对应的DR<Item Expense>来源于Invoice Disturbutions Accounting
(2). 对应的CR<Liability>来源于Supplier Site的设定
3. 常用的SQL
select * from ap_invoices_all
where org_id=89
and invoice_num = 'BXJ Test'
and invoice_id = 475109
select * from ap_invoice_lines_all
where invoice_id = 475109
select accounting_event_id from ap_invoice_distributions_all
where invoice_id = 475109
select * from xla_events
where event_id = 2881445
select * from xla_ae_headers
where event_id = 2881445
select * from xla_ae_lines
where ae_header_id in (33140902,33140903)
select * from xla_distribution_links
where ae_header_id in (33140902,33140903)
select * from xla_transaction_entities
where entity_id = 2839246
Thanks and Regards
