AP Invoice R12버전

AP시작부터 GL까지 주요 테이블 

 

 

모듈명	제목	내용
AP	AP Invoice Interface	select * from ap.ap_invoices_interface t
	AP Invoice Line Interface	select * from ap.AP_INVOICE_LINES_INTERFACE t
AP	AP Invoice Header	select * from ap_invoices_all order by creation_date desc; select * from ap_invoices_all where invoice_num = '송장번호';
	AP Invoice Line	select * from ap_invoice_lines_all order by creation_date desc; select * from ap_invoice_lines_all where invoice_id = INVOICE_ID;
	AP Invoice Distribution	select * from ap_invoice_distributions_all order by creation_date desc; select * from ap_invoice_distributions_all where invoice_id = INVOICE_ID;
SLA	SLA	select * from xla.xla_transaction_entities order by creation_date desc;
	SLA Event	select * from xla_events order by creation_date desc;
	SLA Header	select * from xla_ae_headers order by creation_date desc;
	SLA Line	select * from xla_ae_lines order by creation_date desc;
GL	GL Batche	select * from GL_JE_BATCHES order by creation_date desc;
	GL Header	select * from GL_JE_HEADERS order by creation_date desc;
	GL Line	select * from GL_JE_LINES order by creation_date desc;
AP	AP Payment Header	select * from ap_checks_all order by creation_date desc;
	AP Payment LIne	select * from ap_invoice_payments_all order by creation_date desc;
	AP Payment History	select * from ap_payment_history_all order by creation_date desc;