All Account Receivables Tables in R12

AR Tables

Table Names	Table Descriptions
AR_BATCH_SOURCES_ALL	Accounting, bank account, and numbering information for a batch.
AR_CASH_RECEIPTS_ALL	Detailed receipt information.
AR_CASH_RECEIPT_HISTORY_ALL	History of actions and status changes in the life cycle of a receipt.
AR_DISTRIBUTIONS_ALL	Accounting records for receipts.
AR_INTERIM_CASH_RECEIPTS_ALL	Quick Cash payments processed by the Post Batch program.
AR_JOURNAL_INTERIM_ALL	The AR_JOURNAL_INTERIM_ALL table is a temporary table that stores accounting information for the General Ledger Journal report. Use this report to review the details of the transaction records that were transferred to Oracle General Ledger. General Ledger uses these records to prepare and generate the General Ledger reconciliation reports.
AR_LOCATION_ACCOUNTS_ALL	The AR_LOCATION_ACCOUNTS_ALL table stores tax accounting information for all records in the AR_LOCATION_VALUES table with a Tax Account location segment qualifier defined in the Key Flex field Segments window.
AR_LOCKBOXES_ALL	The AR_LOCKBOXES_ALL table stores information about your Lockboxes. Auto Lockbox (or Lockbox) is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing. An Auto Lockbox operation can process millions of transactions a month. Auto Lockbox eliminates manual data entry by automatically processing receipts that are sent directly to your bank. You specify how you want this information transmitted and Receivables ensures that the data is valid before creating Quick Cash receipt batches. Auto Lockbox uses your Lockbox definitions when transferring receipts from your bank file into Oracle Receivables.
AR_MISC_CASH_DISTRIBUTIONS_ALL	The AR_MISC_CASH_DISTRIBUTIONS_ALL table stores distributions miscellaneous cash receipts. Miscellaneous cash is non-revenue income such as dividends, interest income, etc.
AR_PAYMENTS_INTERFACE_ALL	The AR_PAYMENTS_INTERFACE_ALL table stores imported Lockbox information that was not validated. Auto Lockbox (or Lockbox) is a service that commercial banks offer corporate customers to enable them to outsource their accounts receivable payment processing.
AR_PAYMENT_SCHEDULES_ALL	All transactions except adjustments and miscellaneous cash receipts. Oracle Receivables groups different transactions by entering one of the below values in the CLASS column: INV :Invoice DM  :Debit Memo GUAR : Guarantee CM  :Credit Memo DEP :Deposit CB :Chargeback PMT :Receipt BR  :Bills Receivable
AR_PERIODS	Information about accounting periods.
RA_CUSTOMER_TRX_ALL	Header-level information about invoices, debit memos, chargeback’s, commitments and credit memos
RA_CUSTOMER_TRX_LINES_ALL	Invoice, debit memo, chargeback, credit memo and commitment lines.
RA_TERMS_B	The RA_TERMS_B table stores standard payment term information. Oracle Receivables creates one row for each payment term that you define.
AR_PERIOD_TYPES	Information about accounting period types.
AR_RECEIPT_CLASSES	The AR_RECEIPT_CLASSES table stores user-defined receipt classes.
AR_RECEIPT_METHODS	The AR_RECEIPT_METHODS table stores information about payment methods, which are receipt attributes that you define and assign to receipt classes to account for receipts and their applications.
AR_RECEIVABLES_TRX_ALL	The AR_RECEIVABLES_TRX_ALL table links accounting information with your receivables activities. Use your receivables activities to speed receipt entry and generate finance charges. Possible types of activities include Adjustment, Miscellaneous Cash, and Finance Charge.
AR_RECEIVABLE_APPLICATIONS_ALL	The AR_RECEIVABLE_APPLICATIONS_ALL table stores records for cash and credit memo applications. When a cash receipt is initially created, Receivables creates a row in this table for the cash receipt amount with a status ofUNAPP. For each subsequent application, Receivables creates two rows: one row with a status of APP for the amount that is applied to the invoice, and one row with status of UNAPP for the negative of the amount that is applied. Credit memo applications do not have rows with a status of UNAPP, and use only rows with a status of APP.
HZ_CONTACT_POINTS	The HZ_CONTACT_POINTS table stores information about how to communicate to parties or party sites using electronic media or methods such as Electronic Data Interchange (EDI), e-mail, telephone, telex, and the Internet.
HZ_CUSTOMER_PROFILES	Credit information for customer accounts and customer account sites
HZ_CUST_ACCOUNTS	The HZ_CUST_ACCOUNTS table stores information about customer accounts
HZ_CUST_ACCT_SITES_ALL	The HZ_CUST_ACCT_SITES_ALL table stores all customer account sites across all operating units.
HZ_CUST_SITE_USES_ALL	The HZ_CUST_SITE_USES_ALL table stores business purposes assigned to customer account sites, for example Bill-To, Ship-To, and Statements. Each customer account site can have one or more purposes.
HZ_LOCATIONS	The HZ_LOCATIONS table stores information about a delivery or postal address such as building number, street address, postal code, and directions to a location. This table provides physical location information about parties (organizations and people) and customer accounts.
HZ_PARTIES	Information about parties such as organizations, people, and groups.
HZ_PARTY_SITES	The HZ_PARTY_SITES table links a party (see HZ_PARTIES) and a location (see HZ_LOCATIONS) and stores location-specific party information such as MAILSTOP and ADDRESSEE.