Search This Blog

Monday, 23 May 2011

EDI Database Tables...


Trading Partner Tables
============================
1) ECE_TP_GROUP 
2) ECE_TP_HEADERS 
3) ECE_TP_DETAILS 


Code Conversion Category = ECE_XREF_CATEGORIES
Assign Category >>Column = ECE_INTERFACE_COLUMNS
Code Conversion Values =  ECE_XREF_DATA
Interface file Definition >> Header column = ECE_EXTERNAL_LEVELS 
Interface file Definition >> Interface column = ECE_INTERFACE_COLUMNS
Interface file Definition >> Process Rules = ECE_PROCESS_RULES 
Interface file Definition >> Column Rules = ECE_COLUMN_RULES 


Other Important tables
========================
1) ECE_ERROR 
2) ECE_MAPPINGS 
3) ECE_OUTPUT
4) ECE_STAGE 
5) ECE_RULE_LIST 
6) ECE_RULE_LIST_DETAILS 
7) ece_po_interface_headers


810-INI tables
================
1) ap_invoices_interface
2) ap_invoice_lines_interface
3) ap_invoices_all


810-INO tables
================
1) ra_customer_trx_all
2) ra_customer_trx_lines_all


820- Electronic Fund Transfer
=============================
1) ap_checks_all
2) ce_bank_accounts


850- POI
=========
1) OE_HEADERS_INTERFACE_ALL
2) OE_LINES_INTERFACE_ALL
3) SO_HEADERS_INTERFACE_ALL
3) SO_LINES_INTERFACE_ALL 



855-POAO
==============
1) oe_header_acks
2) oe_line_acks

1 comment: