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 of UNAPP. 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.
|
