This document tries to consolidate information on new tables in
R12 related to payables and what new tables in R12 do old obsoleted 11i tables
map to.
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.
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
Allocations - ap_chrg_allocations_all is obsolete in R12
Taxes
Functionality
provided by E-Business Tax
New 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)
New 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)
Payments
Functionality
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 information
IBY_DOC_PAYABLES_ALL - Invoice information stored by IBY for generating payment
IBY_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_ALL
AP_SELECTED_INVOICES_ALL
The 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
New IBY tables in R12:
IBY_PAY_SERVICE_REQUESTS - Payment Process Request information
(11i Terminology is 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
The 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
The 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
Accounting
Functionality
moved to SubLedger Accounting (SLA)
New 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 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
Trial Balance
New R12
Table
XLA_TRIAL_BALANCES
AP_LIABILITY_BALANCE-> not used in new R12 transactions
AP_TRIAL_BALANCE -> not used in new R12 transactions
XLA_TRIAL_BALANCES
AP_LIABILITY_BALANCE-> not used in new R12 transactions
AP_TRIAL_BALANCE -> not used in new R12 transactions
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
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
0 comments:
Post a Comment