Suppliers
New R12 tables -> Old 11i TablesAP_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_ALLAllocations - ap_chrg_allocations_all is obsolete in R12
Taxes
Functionality provided by E-Business TaxNew 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
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
Trial Balance
New R12 TableXLA_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
No comments:
Post a Comment