R12 Vs 11i table difference

New IBY tables in R12:

IBY_PAY_SERVICE_REQUESTS - Payment Process Request information (11i is known as Payment Batch)

IBY_PAY_INSTRUCTIONS_ALL - Payment Instruction information

IBY_DOC_PAYABLES_ALL - Invoice information stored by IBY for generating payment

IBY_PAYMENTS_ALL Payment Information

Following tables are used in PPR in R12.These were used in 11i for payment batches also.

AP_INV_SELECTION_CRITERIA_ALL

AP_SELECTED_INVOICES_ALL

Following AP tables are still in use in R12 to store payment related information.

AP_INVOICE_PAYMENTS_ALL

AP_CHECKS_ALL

AP_PAYMENT_HISTORY_ALL

Bank Accounts

Functionality moved to Cash Management.

CE_BANK_ACCOUNTS replaces AP_BANK_ACCOUNTS_ALL

CE_BANK_ACCT_USES_ALL replaces AP_BANK_ACCOUNT_USES_ALL

CE_PAYMENT_DOCUMENTS AP_CHECK_STOCKS_ALL

Suppliers

New R12 tables -> Old 11i Tables

AP_SUPPLIERS - replaces PO_VENDORS

AP_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.

Invoices

Additional table in R12: AP_INVOICE_LINES_ALL

Allocations - ap_chrg_allocations_all is obsolete in R12

Taxes

Functionality provided by E-Business Tax

New Tax tables in R12

ZX_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)

Accounting

Functionality moved to Sub Ledger Accounting (SLA)

New XLA R12 tables:

XLA_EVENTS -> replaces AP_ACOCUNTING_EVENTS_ALL

XLA_AE_HEADERS -> replaces AP_AE_HEADERS_ALL

XLA_AE_LINES-> replaces AP_AE_LINES_ALL

XLA_DISTRIBUTION_LINKS

New Trial Balance tables in R12

XLA_TRIAL_BALANCES

AP_LIABILITY_BALANCE-> not used in new R12 transactions

AP_TRIAL_BALANCE -> not used in new R12 transactions