/*发票*/
SELECT *
FROM ap_batches_all apa; --发票批次表
SELECT *
FROM ap_invoices_all aia; --发票表
SELECT *
FROM gl_sets_of_books;
SELECT *
FROM ap_invoice_distributions_all aid; --发票分配表 发票行明细表
SELECT *
FROM ap_invoices_interface; --发票接口表
--表之间的关联
AP_BATCHES_ALL. BATCH_ID = AP_INVOICES_ALL. BATCH_ID
AP_INVOICES_ALL. INVOICE_ID = AP_INVOICE_DISTRIBUTIONS_ALL. INVOICE_ID
/*付款 */
SELECT * FROM AP_CHECKS_ALL ; --付款表
SELECT * FROM AP_INVOICE_PAYMENTS_ALL ; --发票付款表
--表之间的关联
AP_CHECKS_ALL. CHECK_ID = AP_INVOICE_PAYMENTS_ALL. CHECK_ID
AP_INVOICE_PAYMENTS_ALL. INVOICE_ID = AP_INVOICES_ALL. INVOICE_ID
/*其他*/
SELECT * FROM AP_ACCOUNTING_EVENTS_ALL;--应付事件表
SELECT * FROM AP_AE_HEADERS_ALL;--应付会计分录头信息表
SELECT * FROM AP_AE_LINES_ALL ;--应付会计分录行信息表
SELECT *
FROM ap_batches_all apa; --发票批次表
SELECT *
FROM ap_invoices_all aia; --发票表
SELECT *
FROM gl_sets_of_books;
SELECT *
FROM ap_invoice_distributions_all aid; --发票分配表 发票行明细表
SELECT *
FROM ap_invoices_interface; --发票接口表
--表之间的关联
AP_BATCHES_ALL. BATCH_ID = AP_INVOICES_ALL. BATCH_ID
AP_INVOICES_ALL. INVOICE_ID = AP_INVOICE_DISTRIBUTIONS_ALL. INVOICE_ID
/*付款 */
SELECT * FROM AP_CHECKS_ALL ; --付款表
SELECT * FROM AP_INVOICE_PAYMENTS_ALL ; --发票付款表
--表之间的关联
AP_CHECKS_ALL. CHECK_ID = AP_INVOICE_PAYMENTS_ALL. CHECK_ID
AP_INVOICE_PAYMENTS_ALL. INVOICE_ID = AP_INVOICES_ALL. INVOICE_ID
/*其他*/
SELECT * FROM AP_ACCOUNTING_EVENTS_ALL;--应付事件表
SELECT * FROM AP_AE_HEADERS_ALL;--应付会计分录头信息表
SELECT * FROM AP_AE_LINES_ALL ;--应付会计分录行信息表