|
TABLE NAME
|
TABLE DESCRIPTION
|
|
AR120GIR_PERIODS
|
AR120GIR Periods
|
|
AR_ACTION_NOTIFICATIONS
|
Employees to be
notified about a particular customer call
|
|
AR_ACTIVITY_DETAILS
|
Receivable Activities
Details
|
|
AR_ADJUSTMENTS_ALL
|
Pending and approved
invoice adjustments
|
|
AR_ADJUSTMENTS_REP_ITF
|
RXi interface table
for the Adjustments Register report
|
|
AR_AE_ALLOC_REC_GT
|
|
|
AR_AGING_BUCKETS
|
Aging bucket lines
used in Receivables aging reports
|
|
AR_AGING_BUCKET_LINES_B
|
An individual aging
bucket period that is part of an aging bucket set
|
|
AR_AGING_BUCKET_LINES_TL
|
Provides multi-lingual
support (MLS) for aging bucket periods. MLS enables you to store and print
data that you define in multiple languages.
|
|
AR_AGING_EXTRACT
|
Temporary table used
in the Aging Report process
|
|
AR_AGING_MFAR_EXTRACT
|
Temporary table used
in the MFAR Aging Report process
|
|
AR_AGING_PAYMENT_SCHEDULES
|
Temporary table used
in the Aging Report process
|
|
AR_APPROVAL_ACTION_HISTORY
|
Approval and change
history for invoice adjustments
|
|
AR_APPROVAL_USER_LIMITS
|
User adjustment
approval limits
|
|
AR_APP_RULES
|
Application Rules
|
|
AR_APP_RULE_DETAILS
|
Detailed information
about individual application rules
|
|
AR_APP_RULE_SETS
|
Application Rule Sets
|
|
AR_ARCHIVE_CONTROL
|
Historical archive and
purge information
|
|
AR_ARCHIVE_CONTROL_DETAIL
|
Detailed archive and
purge information
|
|
AR_ARCHIVE_DETAIL
|
Line and
distribution-level archive information
|
|
AR_ARCHIVE_HEADER
|
Header-level archive
information
|
|
AR_ARCHIVE_PURGE_INTERIM
|
Interim table used by
the Archive and Purge program
|
|
AR_ARCHIVE_PURGE_LOG
|
Log information
generated during the Archive and Purge process
|
|
AR_AUDIT_DATA
|
Temporary table used
in the rollforward process
|
|
AR_AUTOCASH_HIERARCHIES
|
AutoCash Rule Sets
information
|
|
AR_AUTOCASH_RULES
|
Application method for
each rule in an AutoCash Rule Set
|
|
AR_AUTOCLEAR_INTERIM
|
Intermediate table to
store the receipts selected for clearance when 'Automatic Clearing for
Receipts' program is run in parallel.
|
|
AR_AUTOREC_EXCEPTIONS
|
Temporary table used
to store exceptions found by Automatic Receipts and its related programs
|
|
AR_AUTOREC_INTERIM
|
Temporary table used
in the autoreceipts parallel process
|
|
AR_AUTOREM_INTERIM
|
|
|
AR_BANK_DIRECTORY
|
This table stores bank
information.
|
|
AR_BASE_DIST_AMTS_GT
|
|
|
AR_BASE_GL_ACCT_BALANCES
|
Used as a processing
table for Cumulative Activity Balance Report.
|
|
AR_BATCHES_ALL
|
Receipt batch
information
|
|
AR_BATCH_SOURCES_ALL
|
Accounting, bank
account, and numbering information for a batch
|
|
AR_BPA_AREA_ITEMS
|
The AR_BPA_AREA_ITEMS
table stores the selected content items for each template defined in Bill
Presentment Architecture.
|
|
AR_BPA_CONTENT_AREAS_B
|
Release 11i: Used by
Bill Presentment Architecture
|
|
AR_BPA_CONTENT_AREAS_TL
|
Release 11i: Used by
Bill Presentment Architecture
|
|
AR_BPA_DATASRC_APPS_B
|
Release 11i: Used by
Bill Presentment Architecture
|
|
AR_BPA_DATASRC_APPS_TL
|
Release 11i: Used by
Bill Presentment Architecture
|
|
AR_BPA_DATA_SOURCES
|
Release 11i: Used by
Bill Presentment Architecture
|
|
AR_BPA_DATA_SOURCES_B
|
The
AR_BPA_DATA_SOURCES_B table stores all the data sources that Bill Presentment
Architecture can access.
|
|
AR_BPA_DATA_SOURCES_TL
|
The AR_BPA_DATA_SOURCES_TL
table stores all the data sources that Bill Presentment Architecture can
access.
|
|
AR_BPA_DATA_SRC_PARAMS
|
The
AR_BPA_DATA_SRC_PARAMS table stores the parameters that are used to present
transaction data from the AR_BPA_DATA_SOURCES table on a Bill Presentment
Architecture bill.
|
|
AR_BPA_ITEMS_B
|
The AR_BPA_ITEMS_B
table stores all the content items that can be added to a bill template using
the Bill Presentment Architecture.
|
|
AR_BPA_ITEMS_TL
|
The AR_BPA_ITEMS_TL
table provides multilingual support (MLS) for content items defined in Bill
Presentment Architecture.
|
|
AR_BPA_PAGE_SETUPS_B
|
Release 11i: Used by
Bill Presentment Architecture
|
|
AR_BPA_PAGE_SETUPS_TL
|
Release 11i: Used by
Bill Presentment Architecture
|
|
AR_BPA_PRINT_REQUESTS
|
Release 11i: Used by
Bill Presentment Architecture
|
|
AR_BPA_RULES_B
|
The AR_BPA_RULES_B
table stores the template assignment rules defined in Bill Presentment
Architecture.
|
|
AR_BPA_RULES_TL
|
The AR_BPA_RULES_TL
table provides multilingual support (MLS) for assignment rules defined in
Bill Presentment Architecture. Data in this table is maintained in the
Assignment Rules page. Each row includes the rule name and description. MLS
|
|
AR_BPA_RULE_ATTRIBUTES_B
|
The
AR_BPA_RULE_ATTRIBUTES_B table stores all assignment attributes of assignment
rules defined in Bill Presentment Architecture.
|
|
AR_BPA_RULE_ATTRIBUTES_TL
|
The
AR_BPA_RULE_ATTRIBUTES_TL table provides multilingual support (MLS) for assignment
attributes of assignment rules defined in Bill Presentment Architecture.
|
|
AR_BPA_RULE_TEMPLATES
|
The
AR_BPA_RULE_TEMPLATES table stores all assignment templates for assignment
rules defined in Bill Presentment Architecture.
|
|
AR_BPA_TEMPLATES_B
|
Release 11i: Used by
Bill Presentment Architecture
|
|
AR_BPA_TEMPLATES_TL
|
Release 11i: Used by
Bill Presentment Architecture
|
|
AR_BPA_TEMPLATE_FIELDS
|
Release 11i: Used by
Bill Presentment Architecture
|
|
AR_BPA_TEMPLATE_FILES
|
Release 11i: Used by
Bill Presentment Architecture
|
|
AR_BPA_URLS_B
|
The AR_BPA_URLS_B
table stores all URLs defined in Bill Presentment Architecture.
|
|
AR_BPA_URLS_TL
|
The AR_BPA_URLS_TL
table provides multilingual support (MLS) for URLs defined in Bill
Presentment Architecture.
|
|
AR_BPA_URL_PARAMS
|
The AR_BPA_URL_PARAMS
table stores all parameters for the URLs defined in Bill Presentment
Architecture.
|
|
AR_BR_FMT_TMP
|
Temporary table used
to format and build Bills Receivable reports.
|
|
AR_BR_STAMP_VALUES_ALL
|
Bills
Receivable-specific table that contain stamp information
|
|
AR_BR_STATUS_REP_ITF
|
RXi report interface
table for the Bills Receivable by Status report
|
|
AR_BR_STATUS_SUM_ITF
|
RXi report interface
table for the Bills Receivable by Status report
|
|
AR_BR_TRX_BATCH_RPT
|
Report table for the
Automatic Transaction Batch report
|
|
AR_CALL_ACTIONS
|
Customer call actions
|
|
AR_CASH_AUTOMATCHES
|
This table stores
Automatch Cash Rule Details (BETA)
|
|
AR_CASH_AUTOMATCHES_TL
|
This table stores
language specific details of Automatch Cash Rules (BETA)
|
|
AR_CASH_AUTOMATCH_DTLS
|
This table stores
string transformation details of an Automatch Rule (BETA)
|
|
AR_CASH_AUTOMATCH_RULE_MAP
|
This table stores
Automatch rules associated to a Rule Set (BETA)
|
|
AR_CASH_AUTO_RULE_SETS
|
This table stores
Automatch Rule Set details (BETA)
|
|
AR_CASH_AUTO_RULE_SETS_TL
|
This table stores
language specific details of Automatch Rule Sets (BETA)
|
|
AR_CASH_BASIS_DISTS_ALL
|
Distribution of
payments over revenue accounts, used in Cash Basis Accounting
|
|
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_CASH_RECOS_ALL
|
This table stores
Recommendation details generated for the document number references provided
(BETA)
|
|
AR_CASH_RECOS_PS_GT
|
GT Table for
Recommendations UI (BETA)
|
|
AR_CASH_RECO_LINES_ALL
|
This table stores
Application Details for the Recommendations generated in AR_CASH_RECOS_ALL
(BETA)
|
|
AR_CASH_RECPT_RULE_PARAM_GT
|
|
|
AR_CASH_REMIT_REFS_ALL
|
This table stores Cash
Remittance Reference details (BETA)
|
|
AR_CASH_REMIT_REFS_INTERIM
|
An Interim Table used
to store the subset of data from AR_CASH_REMIT_REFS_ALL for a particular run
of Auto Cash Application Program (BETA)
|
|
AR_CCID_BY_GL_ACCOUNTS
|
Used as a processing
table for Cumulative Activity Balance Report.
|
|
AR_CCID_CORRECTIONS_ALL
|
Individual GL
distribution lines that contain invalid code combinations (GL accounts)
|
|
AR_CC_ERROR_HISTORY
|
This table stores the
execution report information for AutoReceipt or Remittance batches.
|
|
AR_CC_ERROR_MAPPINGS
|
This table stores
credit card errors and the corresponding corrective actions for automation.
|
|
AR_CHANGE_MATRIX
|
This table is no
longer used.
|
|
AR_CHARGE_SCHEDULES
|
Charge Schedules
|
|
AR_CHARGE_SCHEDULE_HDRS
|
Charge Schedule
Headers
|
|
AR_CHARGE_SCHEDULE_LINES
|
Charge Schedule lines
|
|
AR_CLOSED_GL_PERIODS
|
Used as a processing
table for Cumulative Activity Balance Report.
|
|
AR_CMGT_AUTO_RECOMMENDS
|
The
AR_CMGT_AUTO_RECOMMENDS table stores the credit recommendations that result
from automated credit reviews.
|
|
AR_CMGT_AUTO_RULES
|
The AR_CMGT_AUTO_RULES
table stores rules about whether a credit review and credit decision may be
accomplished without user intervention.
|
|
AR_CMGT_AUTO_RULE_DTLS
|
The
AR_CMGT_AUTO_RULE_DTLS table stores rules about whether a credit review and
credit decision may be processed without user intervention.
|
|
AR_CMGT_BANK_REF_ACCTS
|
The AR_CMGT_BANK_REF_ACCTS
table stores detailed bank account balance information for the company under
credit review.
|
|
AR_CMGT_BANK_REF_DATA
|
The
AR_CMGT_BANK_REF_DATA table stores information about the banks where a
company under credit review has active accounts.
|
|
AR_CMGT_CASE_FOLDERS
|
The
AR_CMGT_CASE_FOLDERS table stores information for each case folder.
|
|
AR_CMGT_CF_AGING_DTLS
|
The
AR_CMGT_CF_AGING_DTLS table stores the calculated aging bucket values for the
customer under credit review when the case folder is created.
|
|
AR_CMGT_CF_ANL_NOTES
|
The
AR_CMGT_CF_ANL_NOTES table stores topical notes created by the credit analyst
and stored in the case folder during a credit review.
|
|
AR_CMGT_CF_DNB_DTLS
|
The AR_CMGT_CF_DNB_DTLS
table identifies to Oracle Credit Management where Dun & Bradstreet
Global Data Product report data is stored, when purchased and imported for
use in a credit review.
|
|
AR_CMGT_CF_DTLS
|
The AR_CMGT_CF_DTLS
table stores each data point and its value that you selected for display in a
case folder.
|
|
AR_CMGT_CF_RECOMMENDS
|
The
AR_CMGT_CF_RECOMMENDS table stores the credit recommendations submitted for
each case folder.
|
|
AR_CMGT_CHECK_LISTS
|
The AR_CMGT_CHECK_LISTS
table stores information about your organizations credit policies. Each
checklist defines what data points and requirements exist for different types
of credit reviews.
|
|
AR_CMGT_CHECK_LIST_DTLS
|
The
AR_CMGT_CHECK_LIST_DTLS table stores detail level information for a checklist
in Oracle Credit Management.
|
|
AR_CMGT_COLLATERAL_DATA
|
The
AR_CMGT_COLLATERAL_DATA table stores detailed information about assets that
can be pledged to secure credit available by the company under credit review
pledged to secure credit.
|
|
AR_CMGT_CREDIT_REQUESTS
|
The
AR_CMGT_CREDIT_REQUESTS table stores information for each credit request.
|
|
AR_CMGT_DATA_POINTS_B
|
The
AR_CMGT_DATA_POINTS_B table stores information about the details of each data
point in Oracle Credit Management.
|
|
AR_CMGT_DATA_POINTS_TL
|
The
AR_CMGT_DATA_POINTS_TL table provides multilingual support (MLS) for all case
folder data points that are available for display in Oracle Credit
Management.
|
|
AR_CMGT_DNB_ELEMENTS_B
|
The AR_CMGT_DNB_ELEMENTS_B
table identifies the intersection between where Dun & Bradstreet Global
Data Product report data is stored and how it is retrieved for display in
Oracle Credit Management. Each report has a number of data points t
|
|
AR_CMGT_DNB_ELEMENTS_TL
|
The
AR_CMGT_DNB_ELEMENTS_TL table provides multilingual support (MLS) for all Dun
& Bradstreet data points displayed in a case folder in Oracle Credit
Management. MLS lets you store and print information that you define in
multiple language
|
|
AR_CMGT_DNB_MAPPINGS
|
The
AR_CMGT_DNB_MAPPINGS table identifies each data point contained within the
Dun & Bradstreet Global Data Product reports and maps them to Oracle
Credit Management.
|
|
AR_CMGT_FINANCIAL_DATA
|
The
AR_CMGT_FINANCIAL_DATA table stores financial statements information about
the company under credit review.
|
|
AR_CMGT_GUARANTOR_DATA
|
The
AR_CMGT_GUARANTOR_DATA table stores information about an entity who is legally
responsible for fulfilling a credit obligation if the primary party, the
company under credit review, fails to pay its debt.
|
|
AR_CMGT_HOLD_DETAILS
|
This table stores hold
details of a credit request
|
|
AR_CMGT_OTHER_DATA
|
The AR_CMGT_OTHER_DATA
table stores detailed information about Venture Capital funding in use by the
company under credit review.
|
|
AR_CMGT_SCORES
|
The AR_CMGT_SCORES
table stores header level information for a credit scoring model.
|
|
AR_CMGT_SCORE_DTLS
|
The AR_CMGT_SCORE_DTLS
table stores detail level information for a credit scoring model used in
Oracle Credit Management.
|
|
AR_CMGT_SCORE_WEIGHTS
|
The
AR_CMGT_SCORE_WEIGHTS table stores weights for each data point in a scoring
model.
|
|
AR_CMGT_SETUP_OPTIONS
|
The
AR_CMGT_SETUP_OPTIONS table stores information that you supply to customize
Oracle Credit Management.
|
|
AR_CMGT_TRADE_REF_DATA
|
The
AR_CMGT_TRADE_REF_DATA table stores information about the a companys credit and
trade relationships of a company under credit review with other creditors.
|
|
AR_COGS_REV_ITF
|
The AR_COGS_REV_ITF
table holds temporary data for the COGS RXi reports.
|
|
AR_COLIND
|
Temporary table used
by the Oracle Business Intelligence System (OBIS)
|
|
AR_COLLECTION_INDICATORS_ALL
|
Collection Indicators
for a closed period, used by the Collection Indicators report
|
|
AR_COLLECTORS
|
Information about
collectors
|
|
AR_CONC_PROCESS_REQUESTS
|
Currently running or
terminated concurrent requests
|
|
AR_CONC_REQUEST_MESSAGES
|
Untranslated messages
for server PL/SQL error and log reporting
|
|
AR_CONFIRMATION_ACTIONS
|
This table stores
information about which action to take based on the information that is
included in trading partner's confirmation message.
|
|
AR_CONS_BILL_CYCLES_B
|
The
AR_CONS_BILL_CYCLES_B table stores information on defined cycles. Receivables
creates one row for each billing cycle that you define. This information iis
used to distinguish which activity to include on a bill.
|
|
AR_CONS_BILL_CYCLES_TL
|
The
AR_CONS_BILL_CYCLES_TL table provides multilingual support (MLS) for each
billing cycle that you define in Receivables. MLS lets you store and print
data that you define in multiple languages.
|
|
AR_CONS_BILL_CYCLE_DATES
|
This table stores
billing dates for given billing cycle.
|
|
AR_CONS_INV_ALL
|
Information about a
consolidated billing invoice
|
|
AR_CONS_INV_TRX_ALL
|
Transactions included
on a consolidated billing invoice
|
|
AR_CONS_INV_TRX_LINES_ALL
|
Transaction lines
included on a consolidated billing invoice
|
|
AR_CONT_ACTIONS_ALL
|
Maps contingencies and
revenue recognition events
|
|
AR_CORRESPONDENCES_ALL
|
Dunning letters sent
to a customer
|
|
AR_CORR_PAY_SCHED_ALL
|
Intersection table to
show invoices referenced in a dunning letter
|
|
AR_CREATE_RECEIPTS_ERROR
|
|
|
AR_CREATE_RECEIPTS_GT
|
|
|
AR_CREDIT_HISTORIES
|
History of changes to
a customer's credit profile
|
|
AR_CREDIT_MEMO_AMOUNTS
|
GL dates for credit
memos that use invoicing rules to back out revenue
|
|
AR_CRH_APP_GT
|
|
|
AR_CRH_GT
|
|
|
AR_CUSTOMER_ALT_NAMES
|
Alternate customer
names for AutoLockbox name matching
|
|
AR_CUSTOMER_BALANCE_ITF
|
Customers selected for
the Customer Open Balance Letter report
|
|
AR_CUSTOMER_CALLS_ALL
|
Customer call
information
|
|
AR_CUSTOMER_CALL_TOPICS_ALL
|
Topic of a customer
call
|
|
AR_CUSTOMER_PROFILES
|
Customer credit
information
|
|
AR_CUSTOMER_PROFILE_AMOUNTS
|
Customer profile
amount limits for each currency
|
|
AR_CUSTOMER_PROFILE_CLASSES
|
Customer profile class
information
|
|
AR_CUST_PROF_CLASS_AMOUNTS
|
Customer profile class
amount limits for each currency
|
|
AR_DEBUG
|
|
|
AR_DEFERRAL_REASONS
|
Revenue Contingency
Definitions
|
|
AR_DEFERRED_LINES_ALL
|
Stores revenue status
information at the line level
|
|
AR_DETECT_GT
|
|
|
AR_DISPUTE_HISTORY
|
A history of invoice
disputes for each payment schedule
|
|
AR_DISTRIBUTIONS_ALL
|
Accounting records for
receipts
|
|
AR_DISTRIBUTION_SETS_ALL
|
Groups together a set
of distribution lines
|
|
AR_DISTRIBUTION_SET_LINES_ALL
|
The percentage and
account for each line in a distribution set
|
|
AR_DOCUMENT_TRANSFERS
|
This table stores
information about document transfer to your trading partners.
|
|
AR_DOC_SEQUENCE_AUDIT
|
A record for every
document number generated
|
|
AR_DUNNING_LETTERS_B
|
Information about
dunning letters
|
|
AR_DUNNING_LETTERS_CUSTOM_TL
|
Provides multi-lingual
support (MLS) for custom dunning letters
|
|
AR_DUNNING_LETTERS_TL
|
Provides multi-lingual
support (MLS) for standard dunning letters
|
|
AR_DUNNING_LETTER_SETS
|
Sequence in which
dunning letters are sent
|
|
AR_DUNNING_LETTER_SET_LINES
|
Individual lines
within a dunning letter set
|
|
AR_GL_ACCT_BALANCES
|
Used as a processing
table for Cumulative Activity Balance Report.
|
|
AR_GL_RECON_GT
|
|
|
AR_GTA_AR_DIFFERENCE_TEMP
|
|
|
AR_GTA_BATCH_NUMBERING
|
|
|
AR_GTA_CONSOL_INVS_TEMP
|
|
|
AR_GTA_CONSOL_TEMP
|
|
|
AR_GTA_DIFFERENCE_TEMP
|
|
|
AR_GTA_IMPORT_REP_TEMP
|
|
|
AR_GTA_MISSING_ARTRX_TEMP
|
|
|
AR_GTA_RULE_DFFS_ALL
|
|
|
AR_GTA_RULE_HEADERS_ALL
|
|
|
AR_GTA_RULE_TRX_TYPES_ALL
|
|
|
AR_GTA_SYSTEM_PARAMETERS_ALL
|
|
|
AR_GTA_TAX_LIMITS_ALL
|
|
|
AR_GTA_TRANSFER_TEMP
|
|
|
AR_GTA_TRXIMP_TMP
|
|
|
AR_GTA_TRX_HEADERS_ALL
|
|
|
AR_GTA_TRX_LINES_ALL
|
|
|
AR_GTA_TYPE_MAPPINGS
|
|
|
AR_GTA_UNMATCHED_TEMP
|
|
|
AR_INTEREST_BATCHES_ALL
|
Late Charge batches
|
|
AR_INTEREST_HEADERS_ALL
|
Late Charge headers
|
|
AR_INTEREST_LINES_ALL
|
Late Charge lines
|
|
AR_INTERFACE_CONTS_ALL
|
Contingency
information for transactions imported using AutoInvoice
|
|
AR_INTERIM_CASH_LINE_DETAILS
|
Temporary table used
to store QuickCash payment applications - line level details
|
|
AR_INTERIM_CASH_RCPT_LINES_ALL
|
Temporary table used
to store QuickCash payment applications
|
|
AR_INTERIM_CASH_RECEIPTS_ALL
|
QuickCash payments
processed by the PostBatch program
|
|
AR_INTERIM_POSTING
|
Used for posting when
Cash Basis accounting is used
|
|
AR_INV_API_DIST_GT
|
|
|
AR_INV_API_HEADERS_GT
|
|
|
AR_INV_API_LINES_GT
|
|
|
AR_IREC_PRINT_REQUESTS
|
Stores iReceivables
transaction print requests and BPA immediate print output.
|
|
AR_IREC_SELFREG_CUST_QS
|
Contains the self
registration customer verification questions.
|
|
AR_IREC_SELFREG_SITE_QS
|
Contains the self
registration site verification questions.
|
|
AR_JOURNAL_INTERIM_ALL
|
Temporary table used
by the Journal Entries report
|
|
AR_LATE_CHARGE_CREDITS_GT
|
|
|
AR_LATE_CHARGE_CUST_BALANCE_GT
|
|
|
AR_LATE_CHARGE_DOC_GT
|
|
|
AR_LATE_CHARGE_TRX_T
|
Late Charge processing
table
|
|
AR_LC_CUST_SITES_T
|
Late Charge processing
table
|
|
AR_LINE_APP_DETAIL_GT
|
|
|
AR_LINE_CONTS_ALL
|
Stores contingencies
for a billing line
|
|
AR_LLCA_ADJ_TRX_ERRORS_GT
|
|
|
AR_LLCA_ADJ_TRX_LINES_GT
|
|
|
AR_LLCA_TRX_ERRORS_GT
|
|
|
AR_LLCA_TRX_LINES_GT
|
|
|
AR_LOCATION_ACCOUNTS_ALL
|
Stores the tax
accounting information
|
|
AR_LOCATION_COMBINATIONS
|
Defines each distinct
tax authority
|
|
AR_LOCATION_RATES
|
Sales tax rates for
each tax authority
|
|
AR_LOCATION_RATES_OLD
|
Sales tax rates for
each tax authority
|
|
AR_LOCATION_VALUES
|
Defines the location
and description for each of the value sets used in the Sales Tax Location
flexfield
|
|
AR_LOCATION_VALUES_OLD
|
Defines the location
and description for each of the value sets used in the Sales Tax Location
flexfield
|
|
AR_LOCKBOXES_ALL
|
Lockbox details used
by the AutoLockbox program
|
|
AR_LOC_COMBINATIONS_OLD
|
Defines each distinct
tax authority
|
|
AR_MC_ADJUSTMENTS
|
Currency-related
information about invoice adjustments for each reporting set of books
|
|
AR_MC_BATCHES
|
Currency-related
information about receipt batches for each reporting set of books
|
|
AR_MC_CASH_BASIS_DISTS_ALL
|
Distribution of
payments over revenue accounts, used in Cash Basis Accounting for MRC
|
|
AR_MC_CASH_RECEIPTS
|
Currency-related
information about receipts for each reporting set of books
|
|
AR_MC_CASH_RECEIPT_HIST
|
Currency-related information
about each step in the life cycle of a receipt for each reporting set of
books
|
|
AR_MC_DISTRIBUTIONS_ALL
|
Currency-related
information about distributions generated by the different steps in the life
cycle of a cash receipt
|
|
AR_MC_MISC_CASH_DISTS
|
Currency and
accounting information about miscellaneous cash applications for each
reporting set of books
|
|
AR_MC_PAYMENT_SCHEDULES
|
Currency-related
information about all transactions except adjustments and miscellaneous cash
receipts
|
|
AR_MC_RATE_ADJUSTMENTS
|
Currency-related
information about exchange rate adjustments for each reporting set of books
|
|
AR_MC_RECEIVABLE_APPS
|
Cash and credit memo
applications for each reporting set of books
|
|
AR_MC_TRANSACTION_HISTORY
|
Stores posting-related
information about transaction history lines for each reporting set of books
associated with the parent record.
|
|
AR_MEMO_LINES_ALL_B
|
Standard memo lines
for debit memos, on-account credits, debit memo reversals, and chargebacks
|
|
AR_MEMO_LINES_ALL_TL
|
Provides multilingual
support (MLS) for standard memo lines
|
|
AR_MISC_CASH_DISTRIBUTIONS_ALL
|
All accounting entries
for miscellaneous cash applications
|
|
AR_NOTES
|
Memopad information
for customer calls
|
|
AR_PAYMENTS_INTERFACE_ALL
|
Imported Lockbox
information that was not validated
|
|
AR_PAYMENT_SCHEDULES_ALL
|
All transactions
except adjustments and miscellaneous cash receipts
|
|
AR_PERIODS
|
Information about
accounting periods
|
|
AR_PERIOD_TYPES
|
Information about
accounting period types
|
|
AR_PMTS_INTERFACE_HEADER_GT
|
|
|
AR_PMTS_INTERFACE_LINES_GT
|
|
|
AR_PMTS_INTERFACE_LINE_DETAILS
|
Table used to store
Imported Lockbox line level application information that was not validated.
|
|
AR_POSTING_CONTROL
|
Details of each
General Ledger Interface submission
|
|
AR_POSTING_REPORT_INTERIM
|
Temporary table used
by the Posting Execution report
|
|
AR_PROCESS_SETTLE_ERRORS_GT
|
|
|
AR_PURGE_OE_EXCEPTIONS
|
Interim table used by
the Archive and Purge process to store identifiers for transactions that
cannot be purged
|
|
AR_PURGE_REC_AUX
|
Interim table used by
the Archive and Purge process to store identifiers for selected receipts
|
|
AR_PURGE_TRX_AUX
|
Interim table used by
the Archive and Purge program to store identifiers for selected transactions
|
|
AR_RAMC_AUDIT_TRAIL
|
This maintains revenue
related status changes for invoices.
|
|
AR_RATE_ADJUSTMENTS_ALL
|
Information about
adjustments made to the exchange rates of foreign currency receipts
|
|
AR_RDR_PARAMETERS_GT
|
|
|
AR_RECEIPTS_GT
|
|
|
AR_RECEIPTS_REP_ITF
|
Report Exchange
interface table for the Receivables Receipts reports
|
|
AR_RECEIPT_CLASSES
|
Information about
receipt classes
|
|
AR_RECEIPT_METHODS
|
Information about
payment methods
|
|
AR_RECEIPT_METHOD_ACCOUNTS_ALL
|
Account information
for accounts used by payment methods
|
|
AR_RECEIVABLES_TRX_ALL
|
Accounting information
for Receivables activities
|
|
AR_RECEIVABLE_APPLICATIONS_ALL
|
Accounting information
for cash and credit memo applications
|
|
AR_RECEIVABLE_APPS_GT
|
|
|
AR_REC_TRX_LE_DETAILS_ALL
|
Stores the
tax_rate_codes by legal entity for each receivable activity.
|
|
AR_REVENUE_ADJUSTMENTS_ALL
|
Stores information
about specific revenue adjustments
|
|
AR_REVENUE_ASSIGNMENTS_GT
|
|
|
AR_REVIEWED_LINES_GT
|
|
|
AR_RR_CRH_GT
|
|
|
AR_SALES_TAX
|
Sales tax information
for each tax authority defined in Oracle Receivables
|
|
AR_SALES_TAX_REP_ITF
|
Report Exchange
interface table for the US Sales Tax report
|
|
AR_SELECTION_CRITERIA
|
Stores the selection
criteria on a entity.
|
|
AR_SETTLEMENT_ERRORS_GT
|
|
|
AR_STANDARD_TEXT_B
|
Standard statement
messages
|
|
AR_STANDARD_TEXT_TL
|
Multilingual support
(MLS) for standard text messages that you define for statements
|
|
AR_STATEMENTS_HISTORY_ALL
|
The history of every
customer statement that you generate
|
|
AR_STATEMENT_CYCLES
|
Information about
statement cycles
|
|
AR_STATEMENT_CYCLE_DATES_ALL
|
Dates within a cycle
for sending customer statements
|
|
AR_STATEMENT_CYCLE_INTERVALS
|
Statement cycle
intervals
|
|
AR_STATEMENT_HEADERS
|
Interim table of
statement header information
|
|
AR_STATEMENT_LINE_CLUSTERS
|
Interim table of
transaction lines that appear on a statement
|
|
AR_SUM_REF_EVENT_HIST
|
The
AR_SUM_REF_EVENT_HIST table temporarily stores the history of all AR business
events that different transactional activities raise while the Refresh AR Transactions
Summary Tables concurrent program is running.
|
|
AR_SYSTEM_PARAMETERS_ALL
|
Oracle Receivables
system options
|
|
AR_TAX_CONDITIONS_ALL
|
Tax Condition Sets
|
|
AR_TAX_CONDITION_ACTIONS_ALL
|
Actions performed by
Tax Condition Sets
|
|
AR_TAX_CONDITION_LINES_ALL
|
Tax Condition Lines
|
|
AR_TAX_EXTRACT_DCL_ITF
|
Reporting and legal
entities selected by the Tax Reporting Ledger Tax Extract program
|
|
AR_TAX_EXTRACT_MATRIX_ITF
|
Stores the details of
matrix columns for the interface table of the Tax Reporting Ledger
|
|
AR_TAX_EXTRACT_SUB_ITF
|
Tax Extract interface
table
|
|
AR_TAX_EXTR_SUB_AP_EXT
|
This table is an
extension to AR_TAX_EXTRACT_SUB_ITF to store transaction tax information specific
to Oracle Payables.
|
|
AR_TAX_EXTR_SUB_AR_EXT
|
This table is an
extension to AR_TAX_EXTRACT_SUB_ITF to store transaction tax information
specific to Oracle Receivables.
|
|
AR_TAX_EXTR_SUB_COM_EXT
|
This table is an
extension to AR_TAX_EXTRACT_SUB_ITF to store the transaction tax information
from Oracle Receivables, Oracle Payables and Oracle General Ledger.
|
|
AR_TAX_GROUP_CODES_ALL
|
Tax codes within a tax
group
|
|
AR_TAX_INTERFACE
|
Sales tax rates import
table
|
|
AR_TA_ASGN_TO_INT_ALL
|
Interface table that
stores details about all salespersons and collectors. Can be used by external
deduction management systems
|
|
AR_TA_CASHAPP_OB
|
|
|
AR_TA_CASHAPP_OB_ALL
|
Stores the current
open balance of all transactions processed by the Cash Engine for a
transmission
|
|
AR_TA_CR_AGEN_INF
|
|
|
AR_TA_CR_AGEN_INF_ALL
|
Stores credit
information coming from a credit agency for customer-location combination
|
|
AR_TA_CUST_HIER_CHILD
|
Stores information
about child customers and the mapping to parent customers. Part of a
parent-child hierarchy definition between customers
|
|
AR_TA_CUST_HIER_PARNT
|
Stores information
about parent customers that belong to parent-child hierarchies between
customers
|
|
AR_TA_CUST_INT_ALL
|
Interface table that
stores details about all customers; can be used by external Deduction
Management Systems.
|
|
AR_TA_CUST_TRXSTR_ALL
|
Stores the link
between original deductions and split or merged deductions
|
|
AR_TA_DEDN_ASSGNS_ALL
|
Stores assignment
history information for deduction transactions
|
|
AR_TA_DEDN_INT_ALL
|
Interface table that
stores deductions being moved between Trade Accounting and external Deduction
Management System
|
|
AR_TA_DEDN_INT_ALL_ALL
|
|
|
AR_TA_DEDN_RELATE_ALL
|
Stores the
relationships between deductions moved from an external Deduction Management
System and new transaction created in Trade Accounting
|
|
AR_TA_LEGACY_CUST_INT
|
Contains details of
customers, including Retailed Market Areas, defined in legacy systems
|
|
AR_TA_LEGACY_STAT_INT
|
Contains promotion
statuses defined in the legacy system
|
|
AR_TA_PAYMNT_HIST_ALL
|
Stores payment history
information for customer-location combination for each period
|
|
AR_TA_PROF_ASSGNT_ALL
|
Stores the mapping of
receipt profiles with the key flexfield
|
|
AR_TA_PROMOTIONS_ALL
|
Stores data about
promotions
|
|
AR_TA_PROMOTIONS_INT
|
Interface table that
contains imported promotion data that was not validated or transferred to
destination tables
|
|
AR_TA_PROM_CUST_ALL
|
Stores legacy
customers, for imported promotion data along with corresponding Oracle
customers
|
|
AR_TA_PROM_CUST_MAP
|
Contains mapping of
the customers defined in the legacy system with those defined in Oracle
Financials
|
|
AR_TA_PROM_LINES_INT
|
Interface table that
contains imported promotion details about products, payments (allowances), or
customers, that were not validated or transferred to destination tables
|
|
AR_TA_PROM_PAYMNT_ALL
|
Stores payment
allowance details for promotions
|
|
AR_TA_PROM_PAYMNT_TYP
|
Defines the type of
allowance for promotions
|
|
AR_TA_PROM_PRODS_ALL
|
Stores product details
for promotions
|
|
AR_TA_PROM_STATUS_MAP
|
Contains mapping of
promotion statuses defined in the legacy system with those defined in Oracle
Financials
|
|
AR_TA_RECON_INFO_ALL
|
Temporary table used
by the AutoReconciliation report
|
|
AR_TA_RECV_TRXSET_ALL
|
Stores association of
Transaction Sets with Receivable accounts
|
|
AR_TA_REMIT_HIST_ALL
|
Contains the
application details of all Receipts and Receipt lines processed by the Cash
Engine
|
|
AR_TA_REMIT_PROF_ALL
|
Stores setup
information about customer remittance processing
|
|
AR_TA_RISK_COMENT_ALL
|
Comments associated
with customer-location combination
|
|
AR_TA_RULES_ALL
|
Details of all rules
that are used by the Cash Engine to match receipt lines to transactions in
the database
|
|
AR_TA_RULE_OUTPUT
|
Trade Accounting rule
output
|
|
AR_TA_RULE_SETS_ALL
|
Details of the rule
sets defined in Trade Accounting
|
|
AR_TA_RULE_SET_LN_ALL
|
Details of the
transaction types and event types contained in a transaction set
|
|
AR_TA_TRX_SETS_ALL
|
Details of the
transaction sets defined in Trade Accounting
|
|
AR_TA_TRX_SET_LN_ALL
|
Details of the
transaction types and event types contained in a transaction set
|
|
AR_TA_TRX_TO_CREATE
|
Information about the
transactions that the Cash Engine needs to create
|
|
AR_TA_TRX_TYP_INT_ALL
|
Interface table that
stores details about all transaction types; can be used by external Deduction
Management Systems.
|
|
AR_TA_VERSIONS
|
Trade Accounting
versions
|
|
AR_TRANSACTIONS_REP_ITF
|
Report Exchange
interface table for the Receivables Transactions reports
|