oracle erp po 发运行,ORACLE ERP接口表结构(个人整理精品)

Oracle Erp表接口表结构

2009-03-05 20:47:19 阅读749 评论0 订阅

下面是我在写erp接口时的积累：

1.请购单：

po_requisition_headers_all --请购单头

po_requisition_headers_all --请购单行

2.订单和一揽子协议：

--erp标准接口表

select * from Po_Headers_Interface where attribute8=327

select * from Po_Lines_Interface

--erp最终业务表

select * from Po_Headers_All where segment1='2007074733'

select * from Po_Lines_All where po_header_id=235600

po.PO_DISTRIBUTIONS_ALL 分配行,就是订单头和订单行的唯一

po.po_line_locations_all 发运行

3.接收：

erp接口表:Rcv_Headers_Interface/Rcv_Transactions_Interface

erp业务表:po.rcv_shipment_headers/lines,po.rcv_transactions,

接收会计分录表：

Po.Rcv_Receiving_Sub_Ledger

4.交货：

erp接口表:Rcv_Transactions_Interface

erp业务表:po.rcv_transactions

交货后会写入库存：Mtl_Onhand_Quantities,apps.Mtl_Onhand_Sub_v,mtl_onhand_items_v

5.发料：

erp接口表:Mtl_Transactions_Interface

erp业务表:WIP_REQUIREMENT_OPERATIONS,apps.Mtl_Onhand_Sub_v

错误表：Mtl_Transactions_Interface[error_code,error_explanation]

6.发票：

发票标准接口表头体

select * from ap.ap_invoices_interface where invoice_num like

'01685085~5095%' --01685131~5138' --06279214/06279328' --GM0009'

select * from ap.ap_invoice_lines_interface where invoice_id=26085

最终发票头体

ap.ap_invoices_all发票头

ap.ap_invoice_distributions_all发票体

发票拒绝错误信息表：select * from AP_INTERFACE_REJECTIONS