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

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

No comments:

Post a Comment

Please review my topic and update your comments

Note: only a member of this blog may post a comment.