Saturday, 23 August 2014

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