Customers and Account Receivables tables in Oracle

Customer tables in Oracle Applications R12 are as follows:-

• HZ_CUST_ACCOUNTS
• HZ_CUST_ACCT_SITES_ALL
• HZ_CUST_SITE_USES_ALL
• HZ_PARTIES
• HZ_PARTY_SITES
• HZ_LOCATIONS

Account Receivables tables in Oracle Applications R12 are as follows:-

• RA_CUSTOMER_TRX_ALL
• RA_CUSTOMER_TRX_LINES_ALL
• RA_CUST_TRX_LINE_GL_DIST_ALL
• RA_CUST_TRX_LINE_SALESREPS_ALL
• AR_CASH_RECEIPTS_ALL
• AR_RECEIVABLE_APPLICATIONS_ALL
• AR_PAYMENT_SCHEDULES_ALL
• AR_CASH_RECEIPT_HISTORY_ALL

Account Payables tables in Oracle Application R12

Account Payables tables in Oracle Applications R12 are as follows:-

• AP_SUPPLIERS
• AP_SUPPLIER_SITES_ALL
• AP_INVOICES_ALL
• AP_INVOICE_LINES_ALL
• AP_INVOICE_DISTRIBUTIONS_ALL
• AP_HOLDS_ALL
• AP_BATCHES_ALL
• AP_CHECKS_ALL
• AP_INVOICE_PAYMENTS_ALL
• AP_PAYMENT_SCHEDULES_ALL
• AP_PAYMENT_HISTORY_ALL
• CE_BANK_ACCOUNTS
• CE_BANK_ACCT_USES_ALL
• CE_PAYMENT_DOCUMENTS