Interface Tables of GL, AP, AR,FA,INV,PO,BOMS,WIP,OMGL INTERFACE TABLES

GL_BUDGET_INTERFACE GL_DAILY_RATES_INTERFACE GL_IEA_INTERFACE GL_INTERFACE GL_INTERFACE_CONTROL GL_INTERFACE_HISTORY 

AP INTERFACE TABLESAP_INTERFACE_CONTROLSAP_INTERFACE_REJECTIONSAP_INVOICES_INTERFACEAP_INVOICE_LINES_INTERFACE

AR INTERFACE TABLESAR_PAYMENTS_INTERFACE_ALLAR_TAX_INTERFACEHZ_DQM_SYNC_INTERFACEHZ_PARTY_INTERFACEHZ_PARTY_INTERFACE_ERRORSRA_CUSTOMERS_INTERFACE_ALLRA_INTERFACE_DISTRIBUTIONS_ALLRA_INTERFACE_ERRORS_ALLRA_INTERFACE_LINES_ALLRA_INTERFACE_SALESCREDITS_ALL

FA INTERFACE TABLESFA_BUDGET_INTERFACE FA_INV_INTERFACE FA_PRODUCTION_INTERFACE FA_TAX_INTERFACE 

INVENTORY INTERFACE TABLESMTL_CC_ENTRIES_INTERFACEMTL_CC_INTERFACE_ERRORSMTL_CI_INTERFACEMTL_CI_XREFS_INTERFACEMTL_COPY_ORG_INTERFACEMTL_CROSS_REFERENCES_INTERFACEMTL_DEMAND_INTERFACEMTL_DESC_ELEM_VAL_INTERFACEMTL_EAM_ASSET_NUM_INTERFACEMTL_EAM_ATTR_VAL_INTERFACEMTL_INTERFACE_ERRORSMTL_INTERFACE_PROC_CONTROLSMTL_ITEM_CATEGORIES_INTERFACEMTL_ITEM_CHILD_INFO_INTERFACEMTL_ITEM_REVISIONS_INTERFACEMTL_ITEM_SUB_INVS_INTERFACEMTL_OBJECT_GENEALOGY_INTERFACE

MTL_RELATED_ITEMS_INTERFACEMTL_RESERVATIONS_INTERFACEMTL_RTG_ITEM_REVS_INTERFACEMTL_SECONDARY_LOCS_INTERFACEMTL_SERIAL_NUMBERS_INTERFACEMTL_SO_RMA_INTERFACEMTL_SYSTEM_ITEMS_INTERFACEMTL_TRANSACTIONS_INTERFACEMTL_TRANSACTION_LOTS_INTERFACEMTL_TXN_COST_DET_INTERFACE

PO INTERFACE TABLESPO_DISTRIBUTIONS_INTERFACEPO_HEADERS_INTERFACEPO_INTERFACE_ERRORSPO_LINES_INTERFACEPO_REQUISITIONS_INTERFACE_ALLPO_REQ_DIST_INTERFACE_ALLPO_RESCHEDULE_INTERFACERCV_HEADERS_INTERFACERCV_LOTS_INTERFACERCV_SERIALS_INTERFACERCV_TRANSACTIONS_INTERFACE

BOM INTERFACE TABLESBOM_BILL_OF_MTLS_INTERFACEBOM_INTERFACE_DELETE_GROUPSBOM_INVENTORY_COMPS_INTERFACEBOM_OP_RESOURCES_INTERFACEBOM_OP_ROUTINGS_INTERFACEBOM_OP_SEQUENCES_INTERFACEBOM_REF_DESGS_INTERFACEBOM_SUB_COMPS_INTERFACECST_COMP_SNAP_INTERFACECST_INTERFACE_ERRORSCST_ITEM_COSTS_INTERFACECST_ITEM_CST_DTLS_INTERFACECST_PC_COST_DET_INTERFACECST_PC_ITEM_COST_INTERFACE

WIP INTERFACE TABLESWIP_COST_TXN_INTERFACEWIP_INTERFACE_ERRORSWIP_JOB_DTLS_INTERFACEWIP_JOB_SCHEDULE_INTERFACEWIP_MOVE_TXN_INTERFACEWIP_SCHEDULING_INTERFACEWIP_TXN_INTERFACE_ERRORS TABLE

ORDER MANAGEMENT INTERFACE TABLESSO_CONFIGURATIONS_INTERFACESO_HEADERS_INTERFACE_ALLSO_HEADER_ATTRIBUTES_INTERFACESO_LINES_INTERFACE_ALL

SO_LINE_ATTRIBUTES_INTERFACESO_LINE_DETAILS_INTERFACESO_PRICE_ADJUSTMENTS_INTERFACESO_SALES_CREDITS_INTERFACESO_SERVICE_DETAILS_INTERFACEWSH_DELIVERIES_INTERFACEWSH_FREIGHT_CHARGES_INTERFACEWSH_PACKED_CONTAINER_INTERFACE 

New tables in R12 for Payables and to what R12 objects are obsoleted 11i tables mappedSuppliersNew R12 tables  -> Old 11i TablesAP_SUPPLIERS - replaces PO_VENDORSAP_SUPPLIER_SITES_ALL- replaces PO_VENDOR_SITES_ALL

Additional supplier related tables in IBY(Payments) and HZ(TCA): IBY_EXTERNAL_PAYEES_ALL - stores Payee(supplier) information.HZ_PARTIES - Party data for the suppliers.HZ_PARTY_SITES - Party site data for the supplier sites.

InvoicesAdditional table in R12: AP_INVOICE_LINES_ALLAllocations - ap_chrg_allocations_all is obsolete in R12

TaxesFunctionality provided by E-Business TaxNew tables in R12ZX_LINES - Detailed Tax lines for the invoice (trx_id = invoice_id)ZX_LINES_SUMMARY - Summary tax lines for the invoice (trx_id = invoice_id)ZX_REC_NREC_DIST  - Tax distributions for the invoice (trx_id = invoice_id)ZX_LINES_DET_FACTORS - Tax determination factors for the invoice (trx_id = invoice_id)

PaymentsFunctionality moved to central Payments (IBY)

New IBY tables in R12:IBY_PAY_SERVICE_REQUESTS  - Payment Process Request information                                                                (11i Terminology is  Payment Batch)IBY_PAY_INSTRUCTIONS_ALL - Payment Instruction informationIBY_DOC_PAYABLES_ALL - Invoice information stored by IBY for generating paymentIBY_PAYMENTS_ALL - Payment Information

The following tables are used in PPR in R12 . These were used in 11i for payment batches also.AP_INV_SELECTION_CRITERIA_ALLAP_SELECTED_INVOICES_ALL

The following AP tables are still in use in R12 to store payment related information.AP_INVOICE_PAYMENTS_ALLAP_CHECKS_ALL AP_PAYMENT_HISTORY_ALL 

AccountingFunctionality moved to SubLedger Accounting (SLA)

New R12 tables:XLA_EVENTS -> replaces AP_ACOCUNTING_EVENTS_ALL  XLA_AE_HEADERS -> replaces AP_AE_HEADERS_ALLXLA_AE_LINES-> replaces AP_AE_LINES_ALLXLA_DISTRIBUTION_LINKS

Trial BalanceNew R12 Table XLA_TRIAL_BALANCES

AP_LIABILITY_BALANCE-> not used in new R12 transactionsAP_TRIAL_BALANCE -> not used in new R12 transactions

Bank AccountsFunctionality moved to Cash Management.

CE_BANK_ACCOUNTS -> replaces AP_BANK_ACCOUNTS_ALLCE_BANK_ACCT_USES_ALL  -> replaces AP_BANK_ACCOUNT_USES_ALL CE_PAYMENT_DOCUMENTS -> AP_CHECK_STOCKS_ALL