oracle-EBS-AP应付采购单匹配付款经历主要表(多图)

oracle-EBS-AP应付采购单匹配付款经历主要表(多图)

本章接着之前的一篇采购订单:

 

一、创建AP发票

oracle-ap-EBS 发票

oracle-ap-EBS 发票

AP_BATCHES_ALL
--批名表 select * from AP_BATCHES_ALL where batch_id=160183
ap_invoices_all
--发票主表  select * from ap_invoices_all where INVOICE_NUM ='28-12-2020'
--batch_id = AP_BATCHES_ALL .batch_id

二、匹配采购订单

oracle-ap

oracle-ap

ap_invoice_lines_all 
--发票明细行
--select * from ap_invoice_lines_all where invoice_id in (5361405)
--invoice_id  = ap_invoices_all .invoice_id  
ap_invoice_distributions_all     
--发票分配
--select * from ap_invoice_distributions_all AID where AID.invoice_id in ( 5361405)
--MATCH_STATUS_FLAG:A  Validated (it used to be called Approved)   N or NULL - Never validated  T - Tested but not validated

三、付款

oracle-ap ebs

oracle-ap ebs 发票付款

AP_PAYMENT_SCHEDULES_ALL  
---付款排程主档
-- select * from AP_PAYMENT_SCHEDULES_ALL where INVOICE_ID in (5361405) 
--invoice_id=ap_invoices_all .invoice_id
----该表一张AP 应付发票对应一条或多条记录(根据付款条件而定,一次到期对应一条记录),记录了剩余金额amount_remaining、发票原始金额gross_amount、付款状态payment_status_flag(N从未付款、Y全部付款、P部分付款)
AP_INVOICE_PAYMENTS_ALL
--付款冲发票明细,对应多个invoice,
--select * from AP_INVOICE_PAYMENTS_ALL where INVOICE_ID in (5361405)
--CHECK_ID =AP_CHECKS_ALL.CHECK_ID 
--INVOICE_ID=AP_INVOICES_ALL.INVOICE_ID
AP_CHECKS_ALL
--付款文件头
--CHECK_ID =AP_INVOICE_PAYMENTS_ALL .CHECK_ID 
--select * from AP_CHECKS_ALL where CHECK_ID =2993939

----欢迎转载----
THE END
分享
二维码
< <上一篇
下一篇>>