2014-06-04 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