AR_ADJUSTMENTS_REP_ITF
|
RXi interface table for the
Adjustments Register report
|
AR_ACTIVITY_DETAILS
|
Receivable Activities Details
|
AR_ADJUSTMENTS_ALL
|
Pending and approved invoice
adjustments
|
AR_AGING_BUCKETS
|
Aging bucket lines used in
Receivables aging reports
|
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 MFAR aging
report process
|
AR_AGING_PAYMENT_SCHEDULES
|
Temporary table used in MFAR aging
report process
|
AR_AGING_MFAR_EXTRACT
|
Temporary table used in MFAR aging
report process
|
AR_AGING_BUCKET_LINES_B
|
An individual aging bucket period
that is part of an aging bucket set
|
AR_APPROVAL_ACTION_HISTORY
|
Approval and change history for
invoice adjustments
|
AR_APP_RULES
|
Application Rules
|
AR_ACTION_NOTIFICATIONS
|
Employees to be notified about a
particular customer call
|
AR120GIR_PERIODS
|
AR120GIR Periods
|
AR_ARCHIVE_CONTROL_DETAIL
|
Detailed archive and purge
information
|
AR_ARCHIVE_DETAIL
|
Line and distribution-level
archive information
|
AR_APPROVAL_USER_LIMITS
|
User adjustment approval limits
|
AR_APP_RULE_SETS
|
Application Rule Sets
|
AR_ARCHIVE_PURGE_INTERIM
|
Interim table used by the Archive
and Purge program
|
AR_ARCHIVE_CONTROL
|
Historical archive and purge
information
|
AR_ARCHIVE_PURGE_LOG
|
Log information generated during
the Archive and Purge process
|
AR_AUTOCASH_HIERARCHIES
|
AutoCash Rule Sets information
|
AR_AUDIT_DATA
|
Temporary table used in the
rollforward process
|
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_ARCHIVE_HEADER
|
Header-level archive information
|
AR_AUTOCLEAR_INTERIM
|
Temporary table used in the
autoclearance parallel process
|
AR_BANK_DIRECTORY
|
This table stores bank
information.
|
AR_BPA_CONTENT_AREAS_B
|
Release 11i: Used by Bill
Presentment Architecture
|
AR_BATCHES_ALL
|
Receipt batch information
|
AR_BPA_AREA_ITEMS
|
The AR_BPA_AREA_ITEMS table stores
the selected content items for each template defined in Bill Presentment
Architecture.
|
AR_BASE_GL_ACCT_BALANCES
|
Used as a processing table for
Cumulative Activity Balance Report.
|
AR_BATCH_SOURCES_ALL
|
Accounting, bank account, and
numbering information for a batch
|
AR_BPA_CONTENT_AREAS_TL
|
Release 11i: Used by Bill
Presentment Architecture
|
AR_BPA_DATASRC_APPS_TL
|
Release 11i: Used by Bill
Presentment Architecture
|
AR_BPA_DATASRC_APPS_B
|
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_AUTOCASH_RULES
|
Application method for each rule
in an AutoCash Rule Set
|
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_TL
|
The AR_BPA_ITEMS_TL table provides
multilingual support (MLS) for content items defined in Bill Presentment
Architecture.
|
AR_BPA_PRINT_REQUESTS
|
Release 11i: Used by Bill
Presentment Architecture
|
AR_BPA_PAGE_SETUPS_B
|
Release 11i: Used by Bill
Presentment Architecture
|
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_PAGE_SETUPS_TL
|
Release 11i: Used by Bill
Presentment Architecture
|
AR_BPA_DATA_SOURCES
|
Release 11i: Used by 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_TEMPLATES_TL
|
Release 11i: Used by Bill
Presentment Architecture
|
AR_BPA_TEMPLATES_B
|
Release 11i: Used by 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_TEMPLATE_FIELDS
|
Release 11i: Used by Bill
Presentment Architecture
|
AR_BPA_TEMPLATE_FILES
|
Release 11i: Used by 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_BPA_URLS_TL
|
The AR_BPA_URLS_TL table provides
multilingual support (MLS) for URLs defined in Bill Presentment Architecture.
|
AR_BPA_URLS_B
|
The AR_BPA_URLS_B table stores all
URLs defined in Bill Presentment Architecture.
|
AR_BR_STATUS_REP_ITF
|
RXi report interface table for the
Bills Receivable by Status report
|
AR_BPA_RULES_B
|
The AR_BPA_RULES_B table stores
the template assignment rules defined in Bill Presentment Architecture.
|
AR_CALL_ACTIONS
|
Customer call actions
|
AR_BR_STAMP_VALUES_ALL
|
Bills Receivable-specific table
that contain stamp information
|
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_BR_STATUS_SUM_ITF
|
RXi report interface table for the
Bills Receivable by Status report
|
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_RECOS_ALL
|
This table stores Recommendation
details generated for the document number references provided (BETA)
|
AR_CASH_AUTO_RULE_SETS_TL
|
This table stores language
specific details of Automatch Rule Sets (BETA)
|
AR_CASH_RECEIPT_HISTORY_ALL
|
History of actions and status
changes in the life cycle of a receipt
|
AR_CASH_RECOS_PS_GT
|
GT Table for Recommendations UI
(BETA)
|
AR_BR_TRX_BATCH_RPT
|
Report table for the Automatic
Transaction Batch report
|
AR_CASH_RECO_LINES_ALL
|
This table stores Application
Details for the Recommendations generated in AR_CASH_RECOS_ALL (BETA)
|
AR_CASH_REMIT_REFS_ALL
|
This table stores Cash Remittance
Reference details (BETA)
|
AR_CASH_RECEIPTS_ALL
|
Detailed receipt information
|
AR_CCID_CORRECTIONS_ALL
|
Individual GL distribution lines
that contain invalid code combinations (GL accounts)
|
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_CASH_BASIS_DISTS_ALL
|
Distribution of payments over
revenue accounts, used in Cash Basis Accounting
|
AR_CC_ERROR_MAPPINGS
|
This table stores credit card
errors and the corresponding corrective actions for automation.
|
AR_CC_ERROR_HISTORY
|
This table stores the execution
report information for AutoReceipt or Remittance batches.
|
AR_CHANGE_MATRIX
|
This table is no longer used.
|
AR_CCID_BY_GL_ACCOUNTS
|
Used as a processing table for
Cumulative Activity Balance Report.
|
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_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_RECOMMENDS
|
The AR_CMGT_AUTO_RECOMMENDS table
stores the credit recommendations that result from automated credit reviews.
|
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_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_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_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_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_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_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_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_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_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_CREDIT_REQUESTS
|
The AR_CMGT_CREDIT_REQUESTS table
stores information for each credit request.
|
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_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_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_HOLD_DETAILS
|
This table stores hold details of
a credit request
|
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_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_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_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_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_COLLECTION_INDICATORS_ALL
|
Collection Indicators for a closed
period, used by the Collection Indicators report
|
AR_CONC_PROCESS_REQUESTS
|
Currently running or terminated
concurrent requests
|
AR_COGS_REV_ITF
|
The AR_COGS_REV_ITF table holds
temporary data for the COGS RXi reports.
|
AR_COLLECTORS
|
Information about collectors
|
AR_COLIND
|
Temporary table used by the Oracle
Business Intelligence System (OBIS)
|
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_CONC_REQUEST_MESSAGES
|
Untranslated messages for server
PL/SQL error and log reporting
|
AR_CONS_BILL_CYCLE_DATES
|
This table stores billing dates
for given billing cycle.
|
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_INV_TRX_LINES_ALL
|
Transaction lines included on a
consolidated billing invoice
|
AR_CONS_INV_TRX_ALL
|
Transactions included on a
consolidated billing invoice
|
AR_CONS_INV_ALL
|
Information about a consolidated
billing invoice
|
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_CONT_ACTIONS_ALL
|
Maps contingencies and revenue
recognition events
|
AR_CREATE_RECEIPTS_ERROR
|
Used to store error details during
receipt creation
|
AR_CORRESPONDENCES_ALL
|
Dunning letters sent to a customer
|
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_CORR_PAY_SCHED_ALL
|
Intersection table to show
invoices referenced in a dunning letter
|
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_PROFILE_CLASSES
|
Customer profile class information
|
AR_CUSTOMER_PROFILE_AMOUNTS
|
Customer profile amount limits for
each currency
|
AR_CUSTOMER_CALLS_ALL
|
Customer call information
|
AR_CUST_PROF_CLASS_AMOUNTS
|
Customer profile class amount
limits for each currency
|
AR_CUSTOMER_CALL_TOPICS_ALL
|
Topic of a customer call
|
AR_CUSTOMER_PROFILES
|
Customer credit information
|
AR_DEFERRAL_REASONS
|
Revenue Contingency Definitions
|
AR_DEFERRED_LINES_ALL
|
Stores revenue status information
at the line level
|
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_DOCUMENT_TRANSFERS
|
This table stores information
about document transfer to your trading partners.
|
AR_DISTRIBUTION_SET_LINES_ALL
|
The percentage and account for
each line in a distribution set
|
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_DOC_SEQUENCE_AUDIT
|
A record for every document number
generated
|
AR_DUNNING_LETTERS_B
|
Information about 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_GTA_RULE_DFFS_ALL
|
transfer rule defined on DFF on AR
transaction
|
AR_GTA_SYSTEM_PARAMETERS_ALL
|
System parameters for GTA
|
AR_GTA_BATCH_NUMBERING
|
GTA invoice batch number
|
AR_GTA_TRX_HEADERS_ALL
|
Header-level information for GTA
Invoice
|
AR_GTA_TAX_LIMITS_ALL
|
Limted information for GTA invoice
|
AR_GTA_RULE_HEADERS_ALL
|
Header-level information for
transfer rule
|
AR_GTA_TRXIMP_TMP
|
Temporary interface table for VAT
invoice
|
AR_GTA_RULE_TRX_TYPES_ALL
|
Transfer rule defined on
transaction type
|
AR_INTEREST_BATCHES_ALL
|
Late Charge batches
|
AR_GTA_TYPE_MAPPINGS
|
Transaction type mapping to Tax
Registration Number and Invoice Type
|
AR_INTERFACE_CONTS_ALL
|
Contingency information for transactions
imported using AutoInvoice
|
AR_INTEREST_LINES_ALL
|
Late Charge lines
|
AR_GTA_TRX_LINES_ALL
|
Detail information for GTA invoice
and VAT invoice
|
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_INTERIM_CASH_LINE_DETAILS
|
Temporary table used to store
QuickCash payment applications - line level details
|
AR_IREC_PRINT_REQUESTS
|
Stores iReceivables transaction
print requests and BPA immediate print output.
|
AR_IREC_SELFREG_SITE_QS
|
Contains the self registration
site verification questions.
|
AR_IREC_SELFREG_CUST_QS
|
Contains the self registration
customer verification questions.
|
AR_LATE_CHARGE_TRX_T
|
Late Charge processing table
|
AR_LC_CUST_SITES_T
|
Late Charge processing table
|
AR_LINE_CONTS_ALL
|
Stores contingencies for a billing
line
|
AR_JOURNAL_INTERIM_ALL
|
Temporary table used by the
Journal Entries report
|
AR_IREC_USER_ACCT_SITES_ALL
|
Contains the list of customer site
IDs accessible by the current user.
|
AR_LOCATION_ACCOUNTS_ALL
|
Stores the tax accounting
information
|
AR_LOCATION_RATES
|
Sales tax rates for each tax
authority
|
AR_LOCATION_VALUES_OLD
|
Defines the location and
description for each of the value sets used in the Sales Tax Location
flexfield
|
AR_LOCATION_RATES_OLD
|
Sales tax rates for each tax
authority
|
AR_LOCKBOXES_ALL
|
Lockbox details used by the
AutoLockbox program
|
AR_LOCATION_COMBINATIONS
|
Defines each distinct tax
authority
|
AR_LOCATION_VALUES
|
Defines the location and
description for each of the value sets used in the Sales Tax Location
flexfield
|
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_RECEIPTS
|
Currency-related information about
receipts 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_CASH_BASIS_DISTS_ALL
|
Distribution of payments over
revenue accounts, used in Cash Basis Accounting for MRC
|
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_RATE_ADJUSTMENTS
|
Currency-related information about
exchange rate adjustments for each reporting set of books
|
AR_MC_PAYMENT_SCHEDULES
|
Currency-related information about
all transactions except adjustments and miscellaneous cash receipts
|
AR_MC_RECEIVABLE_APPS
|
Cash and credit memo applications
for each reporting set of books
|
AR_MISC_CASH_DISTRIBUTIONS_ALL
|
All accounting entries for
miscellaneous cash applications
|
AR_MC_MISC_CASH_DISTS
|
Currency and accounting
information about miscellaneous cash applications for each reporting set of
books
|
AR_MEMO_LINES_ALL_TL
|
Provides multilingual support
(MLS) for standard memo lines
|
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_NOTES
|
Memopad information for customer
calls
|
AR_PAYMENTS_INTERFACE_ALL
|
Imported Lockbox information that
was not validated
|
AR_PERIODS
|
Information about accounting
periods
|
AR_PERIOD_TYPES
|
Information about accounting
period types
|
AR_POSTING_REPORT_INTERIM
|
Temporary table used by the
Posting Execution report
|
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_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_PAYMENT_SCHEDULES_ALL
|
All transactions except
adjustments and miscellaneous cash receipts
|
AR_RATE_ADJUSTMENTS_ALL
|
Information about adjustments made
to the exchange rates of foreign currency receipts
|
AR_RECEIPTS_REP_ITF
|
Report Exchange interface table
for the Receivables Receipts reports
|
AR_RECEIPT_METHOD_ACCOUNTS_ALL
|
Account information for accounts
used by payment methods
|
AR_RECEIPT_METHODS
|
Information about payment methods
|
AR_RAMC_AUDIT_TRAIL
|
This maintains revenue related
status changes for invoices.
|
AR_REC_TRX_LE_DETAILS_ALL
|
Stores the tax_rate_codes by legal
entity for each receivable activity.
|
AR_RECEIPT_CLASSES
|
Information about receipt classes
|
AR_RECEIVABLES_TRX_ALL
|
Accounting information for
Receivables activities
|
AR_REVENUE_ADJUSTMENTS_ALL
|
Stores information about specific
revenue adjustments
|
AR_RECEIVABLE_APPLICATIONS_ALL
|
Accounting information for cash and
credit memo applications
|
AR_SELECTION_CRITERIA
|
Stores the selection criteria on a
entity.
|
AR_SALES_TAX_REP_ITF
|
Report Exchange interface table
for the US Sales Tax report
|
AR_SALES_TAX
|
Sales tax information for each tax
authority defined in Oracle Receivables
|
AR_STATEMENT_CYCLES
|
Information about statement cycles
|
AR_STATEMENT_HEADERS
|
Interim table of statement header
information
|
AR_STATEMENT_CYCLE_INTERVALS
|
Statement cycle intervals
|
AR_STANDARD_TEXT_TL
|
Multilingual support (MLS) for
standard text messages that you define for statements
|
AR_STATEMENT_CYCLE_DATES_ALL
|
Dates within a cycle for sending
customer statements
|
AR_STANDARD_TEXT_B
|
Standard statement messages
|
AR_STATEMENT_LINE_CLUSTERS
|
Interim table of transaction lines
that appear on a statement
|
AR_STATEMENTS_HISTORY_ALL
|
The history of every customer
statement that you generate
|
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_TAX_CONDITION_LINES_ALL
|
Tax Condition Lines
|
AR_TAX_CONDITION_ACTIONS_ALL
|
Actions performed by Tax Condition
Sets
|
AR_TAX_CONDITIONS_ALL
|
Tax Condition Sets
|
AR_SYSTEM_PARAMETERS_ALL
|
Oracle Receivables system options
|
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_EXTRACT_DCL_ITF
|
Reporting and legal entities
selected by the Tax Reporting Ledger Tax Extract program
|
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_EXTRACT_SUB_ITF
|
Tax Extract interface table
|
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_ALL
|
Stores the current open balance of
all transactions processed by the Cash Engine for a transmission
|
AR_TA_CUST_INT_ALL
|
Interface table that stores
details about all customers; can be used by external Deduction Management
Systems.
|
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_TAX_EXTRACT_MATRIX_ITF
|
Stores the details of matrix
columns for the interface table of the Tax Reporting Ledger
|
AR_TA_DEDN_ASSGNS_ALL
|
Stores assignment history
information for deduction transactions
|
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_DEDN_INT_ALL
|
Interface table that stores
deductions being moved between Trade Accounting and external Deduction
Management System
|
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_PROF_ASSGNT_ALL
|
Stores the mapping of receipt
profiles with the key flexfield
|
AR_TA_CUST_TRXSTR_ALL
|
Stores the link between original
deductions and split or merged deductions
|
AR_TA_PROMOTIONS_INT
|
Interface table that contains
imported promotion data that was not validated or transferred to destination
tables
|
AR_TA_PAYMNT_HIST_ALL
|
Stores payment history information
for customer-location combination for each period
|
AR_TA_PROMOTIONS_ALL
|
Stores data about promotions
|
AR_TA_PROM_CUST_MAP
|
Contains mapping of the customers
defined in the legacy system with those defined in Oracle Financials
|
AR_TA_PROM_CUST_ALL
|
Stores legacy customers, for
imported promotion data along with corresponding Oracle customers
|
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_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_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_RISK_COMENT_ALL
|
Comments associated with
customer-location combination
|
AR_TA_REMIT_PROF_ALL
|
Stores setup information about
customer remittance processing
|
AR_TA_RECV_TRXSET_ALL
|
Stores association of Transaction
Sets with Receivable accounts
|
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_SETS_ALL
|
Details of the rule sets defined
in Trade Accounting
|
AR_TA_REMIT_HIST_ALL
|
Contains the application details
of all Receipts and Receipt lines processed by the Cash Engine
|
AR_TA_RULE_OUTPUT
|
Trade Accounting rule output
|
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_TYP_INT_ALL
|
Interface table that stores
details about all transaction types; can be used by external Deduction
Management Systems.
|
AR_TA_TRX_TO_CREATE
|
Information about the transactions
that the Cash Engine needs to create
|
AR_TA_VERSIONS
|
Trade Accounting versions
|
AR_TRANSACTION_HISTORY_ALL
|
Life cycle of a transaction
|
AR_TRANSMISSIONS_ALL
|
Lockbox transmission information
|
AR_TRANS_FIELD_FORMATS
|
Format of each field in a Lockbox
transmission format
|
AR_TRX_BAL_SUMMARY
|
This table stores the fields, such
as 'Total Invoices Value
|
AR_TRANSACTIONS_REP_ITF
|
Report Exchange interface table
for the Receivables Transactions reports
|
AR_TRANS_RECORD_FORMATS
|
Format of a record within a
Lockbox transmission format
|
AR_UPG_120_CONTROL
|
This table is used to control ar
12.0 upgrade scripts
|
AR_TRX_SUMMARY
|
This table stores the fields, such
as 'Total Invoices Value
|
AR_VAT_TAX_ALL_TL
|
Multi-lingual support (MLS) for
each tax code that you define
|
AR_VAT_TAX_ALL_B
|
Tax codes defined in the Tax Codes
and Rates window
|
AR_TRX_SUMMARY_HIST
|
This table stores the history of
all the modifications, performed on different transactions, which would
affect the data in the summary tables.
|
HZ_ADAPTER_LOGS
|
The HZ_ADAPTER_LOGS table tracks
requests for service from data integration services providers
|
HZ_ADAPTERS
|
The HZ_ADAPTERS table stores
information about the adapters that are configured to provide data
integration services
|
HZ_ADAPTER_USERS
|
Stores user information for
adapters
|
HZ_ADDRESS_USAGES
|
Contains the address usages per
country
|
HZ_ADAPTER_TERRITORIES
|
The HZ_ADAPTER_TERRITORIES table
stores information about the countries or territories that are supported for
a particular data integration service adapter
|
HZ_ADDRESS_USAGE_DTLS
|
Contains the required geography
|
HZ_BUS_OBJ_DEFINITIONS
|
Stores definitions of TCA business
objects
|
HZ_BUS_OBJ_TRACKING
|
Tracks granular (V2) entities for
raising Business Object events
|
HZ_CERTIFICATIONS
|
Certifications given to parties
|
HZ_BILLING_PREFERENCES
|
Invoicing format
|
HZ_CITIZENSHIP
|
Person's claimed nationality
|
HZ_CLASS_CODE_RELATIONS
|
Relationships between
classification codes
|
HZ_CLASS_CATEGORIES
|
Classification categories for
classifying parties and related entities
|
HZ_CLASS_CODE_DENORM
|
Denormalization of the
classification code hierarchy
|
HZ_CLASS_CATEGORY_USES
|
Usage of class categories by owner
tables
|
HZ_CONTACT_PREFERENCES
|
Stores contact preference
information for parties or their addresses and contact points
|
HZ_CONTACT_POINTS
|
Electronic methods of
communicating with parties
|
HZ_CONTACT_RESTRICTIONS
|
Restrictions on contacting parties
|
HZ_CREDIT_RATINGS
|
Credit ratings of parties
|
HZ_CREDIT_PROFILES
|
Profiles about a party's credit
policy
|
HZ_CREDIT_PROFILE_AMTS
|
Credit limits in specified
currency
|
HZ_CREDIT_RATINGS_EXT_B
|
Stores extensible attributes for
credit ratings.
|
HZ_CREDIT_RATINGS_EXT_TL
|
Provides multilingual support for
extensible credit rating attributes.
|
HZ_CREDIT_USAGES
|
Association between credit limit
and credit usage rule set
|
HZ_CREDIT_USAGE_RULES
|
Usage rules assigned to each
credit limit
|
HZ_CREDIT_USAGE_RULE_SETS_TL
|
Sets of credit usage rules
translated into multiple languages
|
HZ_CREDIT_USAGE_RULE_SETS_B
|
Sets of credit usage rules in the
base language
|
HZ_CUST_ACCOUNTS_M
|
This table is used to store the
deleted records for HZ_CUST_ACCOUNTS during account merge
|
HZ_CUST_ACCOUNT_ROLES_M
|
This table stores the information
of a customer account role from HZ_CUST_ACCOUNT_ROLES table before the
account merge happens. The primary key for this table is
CUST_ACCOUNT_ROLE_ID, CUSTOMER_MERGE_HEADER_ID.
|
HZ_CUST_ACCOUNTS
|
Stores information about customer
accounts.
|
HZ_CUSTOMER_MERGE_LOG
|
This table is used to record
account merge audit history
|
HZ_CUSTOMER_PROFILES
|
Credit information for customer
accounts and customer account sites
|
HZ_CUST_ACCT_RELATE_ALL_M
|
This table is used to store the
deleted records for HZ_CUST_ACCT_RELATE_ALL during account merge
|
HZ_CUST_ACCT_RELATE_ALL
|
Relationships between customer
accounts
|
HZ_CUST_ACCT_SITES_ALL_M
|
The HZ_CUST_ACCT_SITES_ALL_M table
stores the information of customer profile amounts from HZ_CUST_ACCT_SITES_ALL
table before the account merge happens. The primary key for this table is
CUST_ACCT_SITE_ID , CUSTOMER_MERGE_HEADER_ID.
|
HZ_CUST_ACCOUNT_ROLES
|
Roles that parties perform in
customer accounts
|
HZ_CUST_ACCT_SITES_ALL
|
Stores all customer account sites
across all operating units
|
HZ_CUST_MERGE_LOG_DICT
|
This table is used to define the
data in hz_customer_merge_log
|
HZ_CUST_CONTACT_POINTS
|
This table is no longer used
|
HZ_CUST_PROFILE_AMTS_M
|
The HZ_CUST_PROFILE_AMTS_M table
stores the information of customer profile amounts from HZ_CUST_PROFILE_AMTS
table before the account merge happens.The primary key for this table is
CUST_ACCT_PROFILE_AMT_ID, CUSTOMER_MERGE_HEADER_ID.
|
HZ_CUSTOMER_PROFILES_M
|
This table is used to store the
deleted records for hz_customer_profiles during account merge
|
HZ_CODE_ASSIGNMENTS
|
Intersection table linking
industrial classification codes to parties or related entities
|
HZ_CUST_PROFILE_AMTS
|
Stores information about the
credit limits specified for a customer's profile.
|
HZ_CUST_PROFILE_CLASSES
|
Standard credit profile classes
|
HZ_CUST_PROF_CLASS_AMTS
|
Customer profile class amount
limits for each currency
|
HZ_CUST_SITE_USES_ALL_M
|
The HZ_CUST_SITE_USES_ALL_M table
stores the information of customer site uses from HZ_CUST_SITE_USES_ALL table
before the account merge happens. The primary key for this table is
CUST_SITE_USE_ID , CUSTOMER_MERGE_HEADER_ID.
|
HZ_DL_SELECTED_CRITERIA
|
Stores criteria for selecting
parties to include in batches
|
HZ_DQM_SH_SYNC_INTERFACE
|
Stores the list of entities that
have been created or updated by the DQM API since the DQM Shadow Staging
Program concurrent program was last run.
|
HZ_DQM_SYNC_INTERFACE
|
Stores the list of entities that
have been updated by the DQM API.
|
HZ_DSS_ASSIGNMENTS
|
Data sharing group assignments
|
HZ_DQM_SETUP_DIAGNOSTICS
|
Table for storing the Diagnostic
Data for reports
|
HZ_DNB_REQUEST_LOG
|
Requests for information from Dun
& Bradstreet
|
HZ_DQM_STAGE_LOG
|
This table logs the phases that
the DQM Staging Program is at
|
HZ_DSS_CRITERIA
|
Data sharing group criteria
|
HZ_DSS_ENTITIES
|
Entities that can be secured
|
HZ_DSS_GROUPS_B
|
Data Sharing Groups
|
HZ_CUST_SITE_USES_ALL
|
Stores business purposes assigned
to customer account sites.
|
HZ_DSS_GROUPS_TL
|
Translation table for
HZ_DSS_GROUPS_TL
|
HZ_DSS_SECURED_ENTITIES
|
Entities that are secured by a
particular data sharing group
|
HZ_DUP_BATCH
|
Duplicate Identification Batch
|
HZ_DUP_EXCLUSIONS
|
Duplicate Exclusions
|
HZ_DUP_MATCH_DETAILS
|
Match Details
|
HZ_DSS_SCHEME_FUNCTIONS
|
Functions that are used by a
particular data security scheme
|
HZ_DUP_MERGE_PARTIES
|
Parties to be Merged
|
HZ_DUP_RESULTS
|
The HZ_DUP_RESULTS table
temporarily stores duplicate identification data during the duplicate
identification of interface tables. The table includes information about the
potential from and to parties. Data in this table is only used for t
|
HZ_DUP_SET_PARTIES
|
Parties belonging to a Duplicate
Party Set
|
HZ_EDUCATION
|
Person's education information
|
HZ_EMAIL_DOMAINS
|
Entity that holds email domains of
organization parties.
|
HZ_ENTITY_ATTRIBUTES
|
Entities and Attribute information
used by Third Party Data Integration.
|
HZ_DUP_SETS
|
Duplicate Party Sets
|
HZ_EXT_DATA_RULES_TL
|
Rule Name translation table for
Third Party Data Integration.
|
HZ_FINANCIAL_PROFILE
|
Financial accounts of parties
|
HZ_FINANCIAL_NUMBERS
|
Details of financial reports
|
HZ_FINANCIAL_REPORTS
|
Financial reports of parties
|
HZ_FIN_NUMBERS_EXT_TL
|
Provides multilingual support for
extensible financial number attributes.
|
HZ_FIN_REPORTS_EXT_B
|
Stores extensible attributes for
financial reports.
|
HZ_GEOGRAPHIES
|
The HZ_GEOGRPHIES table stores
data representing physical geographies.
|
HZ_FIN_REPORTS_EXT_TL
|
Provides multilingual support for
extensible financial report attributes.
|
HZ_GEOGRAPHY_IDENTIFIERS
|
HZ_GEOGRPHY_IDENTIFIERS stores
multiple identifiers used to describe the same geography.
|
HZ_GEOGRAPHY_TYPES_TL
|
HZ_GEOGRPHY_TYPES_TL stores
Geography Types in MLS languages.
|
HZ_GEOGRAPHY_RANGES
|
Stores ranges associated with a
given geography.
|
HZ_GEO_NAME_REFERENCE_LOG
|
Stores the mapping log between
location elements and Master Reference geography elements based on Geography
Name Matching.
|
HZ_FIN_NUMBERS_EXT_B
|
Stores extensible attributes for
financial numbers.
|
HZ_GEO_STRUCT_MAP_DTL
|
The HZ_GEO_STRUCT_MAP_DTL table
stores the actual mapping of location component and geography type for the
details defined in the HZ_GEO_STRUCT_MAP table.
|
HZ_GEO_STRUCTURE_LEVELS
|
Stores the geographical
hierarchical structures.
|
HZ_GEO_STRUCT_MAP
|
The HZ_GEO_STRUCT_MAP table stores
the map attributes for which a mapping of location components and geography
types are defined.
|
HZ_GEO_NAME_REFERENCES
|
Stores the mapping between
location elements and Master Reference geography elements based on Geography
Name Matching.
|
HZ_IMP_ADAPTERS
|
The HZ_IMP_ADAPTERS table stores
information about using location services adapters to validate addresses in
the interface tables before importing to the TCA Registry. The table includes
the countries that the user chooses to validate, the
|
HZ_HIERARCHY_NODES
|
Contains denormalized data for
hierarchical relationships.
|
HZ_IMP_ADDRESSES_SG
|
TCA internal table for processing
information loaded into the HZ_IMP_ADDRESSES_INT
|
HZ_GEOGRAPHY_TYPES_B
|
HZ_GEOGRPHY_TYPES_B stores
Geography Type classification for geographies: both Master Reference
Geography Types and non-Master Reference Geography Types.
|
HZ_IMP_ADDRESSUSES_INT
|
TCA import table for
HZ_PARTY_SITE_USES
|
HZ_IMP_ADDRESSES_INT
|
TCA import table for HZ_LOCATIONS
and HZ_PARTY_SITES
|
HZ_IMP_ADDRESSUSES_SG
|
TCA internal table for processing
information loaded into the HZ_IMP_ADDRESSUSES_INT
|
HZ_IMP_BATCH_DETAILS
|
The HZ_IMP_BATCH_DETAILS table
stores detail information about imports of records from the interface tables
to the TCA Registry. The table includes the number of times that the batch
has run, the import status, and the request identifier of
|
HZ_IMP_CLASSIFICS_SG
|
TCA internal table for processing
information loaded into the HZ_IMP_CLASSIFICS_INT
|
HZ_IMP_BATCH_SUMMARY
|
The HZ_IMP_BATCH_SUMMARY table
stores information about import batches
|
HZ_IMP_CONTACTPTS_SG
|
TCA internal table for processing
information loaded into the HZ_IMP_CONTACTPTS_INT
|
HZ_IMP_CONTACTPTS_INT
|
TCA import table for
HZ_CONTACT_POINTS
|
HZ_EMPLOYMENT_HISTORY
|
Person's employment information
|
HZ_IMP_CLASSIFICS_INT
|
TCA import table for
HZ_CODE_ASSIGNMENTS
|
HZ_IMP_CREDITRTNGS_INT
|
TCA import table for
HZ_CREDIT_RATINGS
|
HZ_IMP_CONTACTROLES_INT
|
TCA import table for
HZ_ORG_CONTACT_ROLES
|
HZ_IMP_CONTACTROLES_SG
|
TCA internal table for processing
information loaded into the HZ_IMP_CONTACTROLES_INT
|
HZ_IMP_CONTACTS_SG
|
TCA internal table for processing
information loaded into the HZ_IMP_CONTACTS_INT
|
HZ_IMP_CREDITRTNGS_SG
|
TCA internal table for processing
information loaded into the HZ_IMP_CREDITRTNGS_INT
|
HZ_IMP_DUP_PARTIES
|
This table holds the ID's of the
parties that matched the given match rule criteria, along with their scores,
and if any party crossed the auto merge threshold and should be auto merged
|
HZ_IMP_DUP_DETAILS
|
No Comments
|
HZ_IMP_ERRORS
|
TCA import table used to record
error found during the import process
|
HZ_IMP_FINREPORTS_SG
|
TCA internal table for processing
information loaded into the HZ_IMP_FINREPORTS_INT
|
HZ_IMP_FINNUMBERS_SG
|
TCA internal table for processing
information loaded into the HZ_IMP_FINNUMBERS_INT
|
HZ_IMP_FINREPORTS_INT
|
TCA import table for
HZ_FINANCIAL_REPORTS
|
HZ_IMP_FINNUMBERS_INT
|
TCA import table for
HZ_FINANCIAL_NUMBERS
|
HZ_IMP_OSR_CHANGE
|
TCA internal table for processing
information loaded into the
|
HZ_IMP_PARTIES_INT
|
TCA import table for HZ_PARTIES,
HZ_PERSON_PROFILES and HZ_ORG_PROFILES
|
HZ_IMP_INT_DEDUP_RESULTS
|
The HZ_IMP_INT_DEDEUP_RESULTS
table stores the set of duplicates identified as part of the duplicate
identification of interface tables. Each set is identified by a unique
"winner" record that should remain if the other duplicates in the
se
|
HZ_IMP_TMP_ERRORS
|
TCA import table used during
runtime to record errors found during import process
|
HZ_IMP_RELSHIPS_INT
|
TCA import table for HZ_PARTIES,
HZ_PERSON_PROFILES and HZ_ORG_PROFILES
|
HZ_IMP_PARTIES_SG
|
TCA internal table for processing
information loaded into the HZ_IMP_PARTIES_INT
|
HZ_IMP_TMP_REL_END_DATE
|
TCA internal table for storing
relationships to be end dated during bulk import
|
HZ_IMP_WORK_UNITS
|
TCA import table used to manage
work units during the import process
|
HZ_IMP_RELSHIPS_SG
|
TCA internal table for processing
information loaded into the HZ_IMP_RELSHIPS_INT
|
HZ_INDUSTRIAL_REFERENCE
|
Industrial references for
organizations
|
HZ_INT_DUP_RESULTS
|
The HZ_INT_DUP_RESULTS table
temporarily stores duplicate identification data during the duplicate
identification of interface tables. The table includes information about the
source identifiers and source systems of the party records in th
|
HZ_IMP_CONTACTS_INT
|
TCA import table for HZ_PARTIES,
HZ_RELATIONSHIPS and HZ_ORG_CONTACTS
|
HZ_LOCATIONS_EXT_B
|
Stores extensible attributes for
locations.
|
HZ_LOCATIONS_EXT_TL
|
Provides multilingual support for
extensible location attributes.
|
HZ_LOCATIONS
|
Physical addresses
|
HZ_LOCATION_PROFILES
|
The HZ_LOCATION_PROFILES table
stores information, including a history of any changes and address
validations for a subset of attributes from the HZ_LOCATIONS table
|
HZ_LOC_ASSIGNMENTS
|
Relationship between a location
and a tax authority defined in AR_LOCATION_COMBINATIONS
|
HZ_MATCH_RULES_B
|
Stores information about match
rules.
|
HZ_LOG2
|
No longer used.
|
HZ_LOC_ASSIGNMENTS_OBS
|
No longer used in R12.
|
HZ_MATCH_RULE_CONDITIONS
|
Stores information conditions and
match rules in match rule sets
|
HZ_MATCH_RULE_PRIMARY
|
Stores information about primary
attributes in a match rule.
|
HZ_MATCH_RULE_SECONDARY
|
Stores information about secondary
attributes in a match rule.
|
HZ_MERGE_DICTIONARY
|
Tables affected by party merge
concurrent program
|
HZ_MERGE_BATCH
|
Party Merge batch header
information
|
HZ_MATCH_RULES_TL
|
Stores translated information
about match rules.
|
HZ_MERGE_ENTITY_ATTRIBUTES
|
Attribute level merge information
for Party Merge
|
HZ_MERGE_PARTYDTLS_SUGG
|
Suggested default details for
operations performed on the records for merge
|
HZ_MERGE_PARTIES_SUGG
|
Suggested default information of
party merge batch details
|
HZ_MERGE_PARTY_DETAILS
|
Details regarding operations
performed on the records
|
HZ_MERGE_PARTY_HISTORY
|
History of records affected by
Party Merge operation
|
HZ_MERGE_PARTIES
|
Party Merge batch detail
information
|
HZ_ORG_CONTACT_ROLES
|
Roles played by organization
contacts
|
HZ_ORG_CONTACTS
|
People as contacts for parties
|
HZ_NON_PURGE_CANDIDATES
|
Stores the parties that have not
been identified for purge along with denormalized information about the
parties.
|
HZ_ORGANIZATION_PROFILES
|
Detailed information about
organizations
|
HZ_MERGE_PARTY_LOG
|
Information about the Party Merge
operation
|
HZ_ORGANIZATION_INDICATORS
|
Indicators related to finance,
legal, and business standing for business sites
|
HZ_ORG_PROFILES_EXT_SG
|
Staging table for copying
extensions data for organization profile versioning.
|
HZ_ORG_PROFILES_EXT_TL
|
Provides multilingual support for
extensible organization attributes.
|
HZ_ORIG_SYSTEMS_B
|
Stores basic source system
information
|
HZ_MOBILE_PREFIXES
|
Mobile telephone number prefixes
based on country
|
HZ_ORIG_SYSTEMS_TL
|
Provides multilingual support for
source system information
|
HZ_PARAM_TAB
|
No longer used
|
HZ_ORIG_SYS_MAPPING
|
The HZ_ORIG_SYS_MAPPING table
stores the mapping among source systems and owner table names.
|
HZ_ORIG_SYS_REFERENCES
|
The HZ_ORIG_SYSTEM_REFERENCES
table stores the mapping between source system references and the owner
tables.
|
HZ_ORG_PROFILES_EXT_B
|
Stores extensible attributes for
organizations.
|
HZ_PARTY_RELATIONSHIPS
|
Relationships between parties
|
HZ_PARTIES
|
Information about parties such as
organizations, people, and groups
|
HZ_PARTY_PREFERENCES
|
Party Preferences
|
HZ_PARTY_INTERFACE
|
Information about party retrieved
from external source
|
HZ_PARTY_INTERFACE_ERRORS
|
Information about API errors
|
HZ_PARTY_SITES_EXT_B
|
Stores extensible attributes for
party sites.
|
HZ_PARTY_SITES_EXT_TL
|
Provides multilingual support for
extensible party site attributes.
|
HZ_PARTY_SITE_USES
|
The way that a party uses a
particular site or address
|
HZ_PARTY_USAGES_TL
|
Provides multilingual support for
party usage definitions.
|
HZ_PARTY_SITES
|
Links party to physical locations
|
HZ_PERSON_INTEREST
|
Information about a person's
personal interests
|
HZ_PARTY_USAGE_RULES
|
Stores party usage rules.
|
HZ_PERSON_LANGUAGE
|
Languages that a person speaks,
reads, or writes
|
HZ_PARTY_USAGES_B
|
Stores party usage definition.
|
HZ_PER_PROFILES_EXT_SG
|
Staging table for copying
extensions data for person profile versioning.
|
HZ_PER_PROFILES_EXT_TL
|
Provides multilingual support for
extensible person attributes.
|
HZ_PARTY_USG_ASSIGNMENTS
|
Stores information about party
usage assignments.
|
HZ_PRIMARY_TRANS
|
Stores information about
transformation for the primary attributes.
|
HZ_PER_PROFILES_EXT_B
|
Stores extensible attributes for
persons.
|
HZ_PHONE_AREA_CODES
|
Telephone number area codes based
on country
|
HZ_PHONE_COUNTRY_CODES
|
Country-specific phone number
information
|
HZ_PHONE_FORMATS
|
Country-specific phone number
formats
|
HZ_PURGE_BATCHES
|
Stores the Batches that have been
created for purge.
|
HZ_PURGE_CANDIDATES
|
Stores the parties that have been
identified for purge along with denormalized information about the parties.
|
HZ_REFERENCES
|
References given for parties
|
HZ_REG_VERIFICATIONS
|
HZ_REG_VERIFICATIONS serves as an
audit table for each access verification question generated during the
registration process.
|
HZ_RELATIONSHIPS
|
Relationships between entities
|
HZ_REGISTRATIONS
|
Stores registration attempts for
each unique user and access domain combination.
|
HZ_ROLE_RESPONSIBILITY
|
Responsibilities for parties
related to their roles in the accounts
|
HZ_RELATIONSHIP_TYPES
|
Relationship types
|
HZ_SECURITY_ISSUED
|
Financial instruments issued by an
organization
|
HZ_SECONDARY_TRANS
|
Stores information about
transformation for the secondary attributes.
|
HZ_SRCH_CONTACTS
|
This table stores the transformed
data for the contacts in the interface tables.
|
HZ_SRCH_PARTIES
|
This table stores the transformed
data for the parties in the interface tables.
|
HZ_SRCH_PSITES
|
This table stores the transformed
data for the addresses in the interface tables.
|
HZ_SRCH_CPTS
|
This table stores the transformed
data for the contact points in the interface tables.
|
HZ_STAGED_CONTACTS
|
Contact information that is staged
for DQM.
|
HZ_STAGED_CONTACT_POINTS
|
Contact point information that is
staged for DQM.
|
HZ_STAGED_PARTY_SITES
|
Party Site information that is
staged for DQM.
|
HZ_STOCK_MARKETS
|
Exchanges for buying and selling
financial instruments
|
HZ_STAGED_PARTIES
|
Party information that is staged
for DQM.
|
HZ_STYLES_B
|
Styles to classify formats.
|
HZ_STYLES_TL
|
Translation table for HZ_STYLES_B
|
HZ_STYLE_FMT_LAYOUTS_B
|
Layout of particular style format
Variation components.
|
HZ_STYLE_FMT_LOCALES
|
Specific locations for style
formats.
|
HZ_STYLE_FMT_LAYOUTS_TL
|
Translation table for
HZ_STYLE_FMT_LAYOUTS_B
|
HZ_SELECT_DATA_SOURCES
|
Selected data sources for Third
Party Data Integration.
|
HZ_STYLE_FORMATS_B
|
Specific formats valid for one or
more locations.
|
HZ_STYLE_FMT_VARIATIONS
|
Variations in layout for style
formats.
|
HZ_STYLE_FORMATS_TL
|
Translation table for
HZ_STYLE_FORMATS_B.
|
HZ_SUSPENSION_ACTIVITY
|
The point in time that a service
is no longer provided
|
HZ_THIRDPARTY_RULE
|
Overwrite rules for specific
attributes for Third Party Data Integration.
|
HZ_THIRDPARTY_EXCEPS
|
Exceptions to overwrite rules for
specific attributes of specific parties for Third Party Data Integration.
|
HZ_TIMEZONES_TL
|
Time zone translations
|
HZ_TIMEZONE_MAPPING
|
Mapping of address elements to
time zones
|
HZ_TRANS_ATTRIBUTES_B
|
Stores information about the
transformations on attributes.
|
HZ_TIMEZONES
|
Time zone information
|
HZ_TRANS_ATTRIBUTES_TL
|
Stores translated information
about the transformations on attributes.
|
HZ_TRANS_FUNCTIONS_B
|
Stores transformation functions.
|
HZ_TRANS_FUNCTIONS_TL
|
Stores translated transformation
functions.
|
HZ_USER_CREATE_RULES
|
User data creation rules for Third
Party Data Integration.
|
HZ_USER_OVERWRITE_RULES
|
User overwrite rules for Third
Party Data Integration.
|
HZ_WIN_SOURCE_EXCEPS
|
Stores attribute exception
information if data are overwritten contrary to the Third Party Data
Integration data source ranking.
|
HZ_WORD_REPLACEMENTS
|
Word replacement rules for Fuzzy
Find functionality
|
HZ_WORD_RPL_COND_ATTRIBS
|
Stores attributes associated with
word replacement conditions.
|
HZ_WORD_RPL_CONDS_B
|
Stores information about
conditions in word replacement lists
|
HZ_WORD_LISTS
|
Word Replacement Lists for Data
Quality Management.
|
HZ_WORD_RPL_CONDS_TL
|
Provides multilingual support for
word replacement conditions.
|
HZ_WORK_CLASS
|
Classifications or groupings of
work activities
|
RA_ACCOUNT_COMBINATIONS
|
Account information for internal
Oracle users
|
RA_ACCOUNT_DEFAULT_SEGMENTS
|
AutoAccounting segment information
|
RA_ADDRESSES_ALL
|
Customer address information
|
RA_BATCH_SOURCES_ALL
|
Sources of invoice, credit memo
and commitments
|
RA_BATCHES_ALL
|
Invoice batch information
|
RA_ACCOUNT_DEFAULTS_ALL
|
AutoAccounting information
|
RA_CM_REQUEST_LINES_ALL
|
Pending and approved credit memo
request lines
|
RA_CM_REQUESTS_ALL
|
Pending and approved credit memo
requests
|
RA_CONTACT_ROLES
|
Contact roles
|
RA_CUSTOMERS
|
Customer information
|
RA_CUSTOMER_BANKS_INT_ALL
|
Customer Interface table for
customer banks
|
RA_CUSTOMERS_INTERFACE_ALL
|
Customer Interface table
|
RA_CUSTOMER_MERGES
|
Information about customers,
addresses, and site uses that are being merged or moved
|
RA_CUSTOMER_PROFILES_INT_ALL
|
Customer Interface table for
customer profile information
|
RA_CUSTOMER_MERGE_HEADERS
|
This table is used to store the
high level information about an account merge request.
|
RA_CUSTOMER_RELATIONSHIPS_ALL
|
Information about customer
relationships
|
RA_CUSTOMER_TRX_LINES_ALL
|
Invoice, debit memo, chargeback,
credit memo and commitment lines
|
RA_CUSTOMER_TRX_ALL
|
Header-level information about
invoices, debit memos, chargebacks, commitments and credit memos
|
RA_CUST_TRX_LINE_GL_DIST_ALL
|
Accounting records for revenue,
unearned revenue and unbilled receivables
|
RA_CUST_PAY_METHOD_INT_ALL
|
Customer Interface table for
Payment Methods
|
RA_CUST_RECEIPT_METHODS
|
Payment Methods assigned to a
customer and/or customer site
|
RA_CUST_TRX_LINE_SALESREPS_ALL
|
Sales credit assignments for
transactions
|
RA_GROUPING_TRX_TYPES
|
Transaction types associated with
AutoInvoice grouping rules
|
RA_CUST_TRX_TYPES_ALL
|
Transaction type for invoices,
commitments and credit memos
|
RA_GROUPING_RULES
|
AutoInvoice grouping rules
|
RA_GROUP_BY_COLUMNS
|
Table of columns to group by for
AutoInvoice grouping rules
|
RA_INTERFACE_ERRORS_ALL
|
Interface data that failed
AutoInvoice validation
|
RA_INTERFACE_SALESCREDITS_ALL
|
Sales credit information for
transactions imported using AutoInvoice
|
RA_GROUP_BYS
|
Columns to group by for each
grouping rule and transaction type
|
RA_ITEM_EXCEPTION_RATES
|
Product tax rate exceptions
|
RA_LINE_ORDERING_RULES
|
AutoInvoice line ordering rules
|
RA_LINE_ORDER_BYS
|
Columns to order by for each
AutoInvoice line ordering rule
|
RA_INTERFACE_DISTRIBUTIONS_ALL
|
Accounting distributions for
transactions imported using AutoInvoice
|
RA_LINE_ORDER_BY_COLUMNS
|
Table of columns to order by for
AutoInvoice line ordering rules
|
RA_MC_BATCHES
|
Currency-related information about
invoice batches for each reporting set of books
|
RA_MC_CUSTOMER_TRX
|
Currency-related information about
invoice, debit memo, commitment, and credit memo header information
|
RA_MC_CUSTOMER_TRX_LINES
|
Stores currency-related information
about transaction lines for each reporting set of books that is associated
with the parent record
|
RA_MC_TRX_LINE_GL_DIST
|
Currency and accounting records
for revenue, unearned revenue and unbilled receivables
|
RA_RECUR_INTERIM
|
Temporary table that holds
invoices to be copied
|
RA_PHONES
|
Telephone and communications
information
|
RA_REMIT_TOS_ALL
|
Links remit-to addresses with
state and country
|
RA_RULES
|
Invoicing and accounting rules
|
RA_RULE_SCHEDULES
|
Accounting schedules for invoices
with rules
|
RA_SALESREP_TERRITORIES
|
Territory information for
salespeople
|
RA_SALESREPS_ALL
|
Information about salespeople
|
RA_TAX_EXEMPTIONS_ALL
|
Percentage that a customer, site,
or item is exempt from a tax code
|
RA_SITE_USES_ALL
|
Business purpose of a customer
address
|
RA_CONTACT_PHONES_INT_ALL
|
Used by Customer Interface to
import contact and telephone information
|
RA_TERMS_LINES_DISCOUNTS
|
Discount information for Payment
Terms
|
RA_TERMS_TL
|
Multi-lingual support (MLS) for
Payment Terms
|
RA_TERRITORIES
|
Territory information
|
RA_TERMS_LINES
|
Line information for Payment Terms
|
RA_TERMS_B
|
Payment Term information
|
Learning oracle technology to improve business and profession skills Sharing Skills like Enterprise Resource Planning (ERP) and Integrations
Featured post
General Ledger Revaluation
General Ledger Revaluation Account balances denominated in foreign currencies are adjusted through the revaluation procedure. Revaluat...
Sunday, 12 November 2017
Table ALl R12
Subscribe to:
Post Comments (Atom)
-
4 Important Tables of Oracle fusion user roles query 1. per_users 2. per_user_roles 3. per_roles_dn 4. per_roles_dn_tl Detail SQL Query to...
-
A quick summary of accounting entries in Order to Cash cycle Sales order creation – No entries Pick release: Inventory St...
-
Book mark this page...to find more and more useful join conditions in upcoming days!!!!!!!! Module Table Column GL and AP...
No comments:
Post a Comment
Please review my topic and update your comments
Note: only a member of this blog may post a comment.