AR Tables (610)

AR - Receivables — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
AR120GIR_PERIODS 1 AR120GIR Periods
AR_ACTION_NOTIFICATIONS 8 Employees to be notified about a particular customer call
AR_ACTIVITY_DETAILS 48 Receivable Activities Details
AR_ADJUSTMENTS_ALL 95 Pending and approved invoice adjustments
AR_ADJUSTMENTS_REP_ITF 37 RXi interface table for the Adjustments Register report
AR_AE_ALLOC_REC_GT 107
AR_AGING_BUCKETS 27 Aging bucket lines used in Receivables aging reports
AR_AGING_BUCKET_LINES_B 28 An individual aging bucket period that is part of an aging bucket set
AR_AGING_BUCKET_LINES_TL 11 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 37 Temporary table used in MFAR aging report process
AR_AGING_MFAR_EXTRACT 9 Temporary table used in MFAR aging report process
AR_AGING_PAYMENT_SCHEDULES 4 Temporary table used in MFAR aging report process
AR_APPROVAL_ACTION_HISTORY 26 Approval and change history for invoice adjustments
AR_APPROVAL_USER_LIMITS 28 User adjustment approval limits
AR_APP_RULES 27 Application Rules
AR_APP_RULE_DETAILS 27 Detailed information about individual application rules
AR_APP_RULE_SETS 27 Application Rule Sets
AR_ARCHIVE_CONTROL 14 Historical archive and purge information
AR_ARCHIVE_CONTROL_DETAIL 33 Detailed archive and purge information
AR_ARCHIVE_DETAIL 118 Line and distribution-level archive information
AR_ARCHIVE_HEADER 120 Header-level archive information
AR_ARCHIVE_PURGE_INTERIM 2 Interim table used by the Archive and Purge program
AR_ARCHIVE_PURGE_LOG 2 Log information generated during the Archive and Purge process
AR_AUDIT_DATA 7 Temporary table used in the rollforward process
AR_AUTOCASH_HIERARCHIES 30 AutoCash Rule Sets information
AR_AUTOCASH_RULES 25 Application method for each rule in an AutoCash Rule Set
AR_AUTOCLEAR_INTERIM 19 Temporary table used in the autoclearance parallel process
AR_AUTOREC_EXCEPTIONS 22 Temporary table used to store exceptions found by Automatic Receipts and its related programs
AR_AUTOREC_INTERIM 14 Temporary table used in the autoreceipts parallel process
AR_AUTOREM_INTERIM 30
AR_BANK_DIRECTORY 18 This table stores bank information.
AR_BASE_DIST_AMTS_GT 33
AR_BASE_GL_ACCT_BALANCES 22 Used as a processing table for Cumulative Activity Balance Report.
AR_BATCHES_ALL 62 Receipt batch information
AR_BATCH_SOURCES_ALL 34 Accounting, bank account, and numbering information for a batch
AR_BPA_AREA_ITEMS 15 The AR_BPA_AREA_ITEMS table stores the selected content items for each template defined in Bill Presentment Architecture.
AR_BPA_CONTENT_AREAS_B 29 Release 11i: Used by Bill Presentment Architecture
AR_BPA_CONTENT_AREAS_TL 11 Release 11i: Used by Bill Presentment Architecture
AR_BPA_DATASRC_APPS_B 11 Release 11i: Used by Bill Presentment Architecture
AR_BPA_DATASRC_APPS_TL 11 Release 11i: Used by Bill Presentment Architecture
AR_BPA_DATA_SOURCES_B 20 The AR_BPA_DATA_SOURCES_B table stores all the data sources that Bill Presentment Architecture can access.
AR_BPA_DATA_SOURCES_TL 11 The AR_BPA_DATA_SOURCES_TL table stores all the data sources that Bill Presentment Architecture can access.
AR_BPA_DATA_SRC_PARAMS 13 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 Bil
AR_BPA_ITEMS_B 27 The AR_BPA_ITEMS_B table stores all the content items that can be added to a bill template using the Bill Presentment Architecture.
AR_BPA_ITEMS_TL 13 The AR_BPA_ITEMS_TL table provides multilingual support (MLS) for content items defined in Bill Presentment Architecture.
AR_BPA_PAGE_SETUPS_B 18 Release 11i: Used by Bill Presentment Architecture
AR_BPA_PAGE_SETUPS_TL 11 Release 11i: Used by Bill Presentment Architecture
AR_BPA_PRINT_REQUESTS 10 Release 11i: Used by Bill Presentment Architecture
AR_BPA_RULES_B 19 The AR_BPA_RULES_B table stores the template assignment rules defined in Bill Presentment Architecture.
AR_BPA_RULES_TL 11 The AR_BPA_RULES_TL table provides multilingual support (MLS) for assignment rules defined in Bill Presentment Architecture. Data in this ta
AR_BPA_RULE_ATTRIBUTES_B 10 The AR_BPA_RULE_ATTRIBUTES_B table stores all assignment attributes of assignment rules defined in Bill Presentment Architecture.
AR_BPA_RULE_ATTRIBUTES_TL 10 The AR_BPA_RULE_ATTRIBUTES_TL table provides multilingual support (MLS) for assignment attributes of assignment rules defined in Bill Presen
AR_BPA_RULE_TEMPLATES 12 The AR_BPA_RULE_TEMPLATES table stores all assignment templates for assignment rules defined in Bill Presentment Architecture.
AR_BPA_TEMPLATES_B 39 Release 11i: Used by Bill Presentment Architecture
AR_BPA_TEMPLATES_TL 11 Release 11i: Used by Bill Presentment Architecture
AR_BPA_TEMPLATE_FIELDS 9 Release 11i: Used by Bill Presentment Architecture
AR_BPA_TEMPLATE_FILES 10 Release 11i: Used by Bill Presentment Architecture
AR_BPA_URLS_B 13 The AR_BPA_URLS_B table stores all URLs defined in Bill Presentment Architecture.
AR_BPA_URLS_TL 11 The AR_BPA_URLS_TL table provides multilingual support (MLS) for URLs defined in Bill Presentment Architecture.
AR_BPA_URL_PARAMS 13 The AR_BPA_URL_PARAMS table stores all parameters for the URLs defined in Bill Presentment Architecture.
AR_BR_FMT_TMP 5 Temporary table used to format and build Bills Receivable reports.
AR_BR_STAMP_VALUES_ALL 26 Bills Receivable-specific table that contain stamp information
AR_BR_STATUS_REP_ITF 90 RXi report interface table for the Bills Receivable by Status report
AR_BR_STATUS_SUM_ITF 14 RXi report interface table for the Bills Receivable by Status report
AR_BR_TRX_BATCH_RPT 24 Report table for the Automatic Transaction Batch report
AR_CALL_ACTIONS 13 Customer call actions
AR_CASH_AUTOMATCHES 15 This table stores Automatch Cash Rule Details (BETA)
AR_CASH_AUTOMATCHES_TL 10 This table stores language specific details of Automatch Cash Rules (BETA)
AR_CASH_AUTOMATCH_DTLS 12 This table stores string transformation details of an Automatch Rule (BETA)
AR_CASH_AUTOMATCH_RULE_MAP 9 This table stores Automatch rules associated to a Rule Set (BETA)
AR_CASH_AUTO_RULE_SETS 10 This table stores Automatch Rule Set details (BETA)
AR_CASH_AUTO_RULE_SETS_TL 10 This table stores language specific details of Automatch Rule Sets (BETA)
AR_CASH_BASIS_DISTS_ALL 33 Distribution of payments over revenue accounts, used in Cash Basis Accounting
AR_CASH_RECEIPTS_ALL 124 Detailed receipt information
AR_CASH_RECEIPT_HISTORY_ALL 64 History of actions and status changes in the life cycle of a receipt
AR_CASH_RECOS_ALL 31 This table stores Recommendation details generated for the document number references provided (BETA)
AR_CASH_RECOS_PS_GT 16 GT Table for Recommendations UI (BETA)
AR_CASH_RECO_LINES_ALL 22 This table stores Application Details for the Recommendations generated in AR_CASH_RECOS_ALL (BETA)
AR_CASH_RECPT_RULE_PARAM_GT 19
AR_CASH_REMIT_REFS_ALL 41 This table stores Cash Remittance Reference details (BETA)
AR_CASH_REMIT_REFS_INTERIM 19 An Interim Table used to store the subset of data from AR_CASH_REMIT_REFS_ALL for a particular run of Auto Cash Application Program (BETA)
AR_CCID_BY_GL_ACCOUNTS 8 Used as a processing table for Cumulative Activity Balance Report.
AR_CCID_CORRECTIONS_ALL 14 Individual GL distribution lines that contain invalid code combinations (GL accounts)
AR_CC_ERROR_HISTORY 19 This table stores the execution report information for AutoReceipt or Remittance batches.
AR_CC_ERROR_MAPPINGS 14 This table stores credit card errors and the corresponding corrective actions for automation.
AR_CHANGE_MATRIX 151 This table is no longer used.
AR_CHARGE_SCHEDULES 25 Charge Schedules
AR_CHARGE_SCHEDULE_HDRS 29 Charge Schedule Headers
AR_CHARGE_SCHEDULE_LINES 29 Charge Schedule lines
AR_CLOSED_GL_PERIODS 10 Used as a processing table for Cumulative Activity Balance Report.
AR_CMGT_AUTO_RECOMMENDS 13 The AR_CMGT_AUTO_RECOMMENDS table stores the credit recommendations that result from automated credit reviews.
AR_CMGT_AUTO_RULES 10 The AR_CMGT_AUTO_RULES table stores rules about whether a credit review and credit decision may be accomplished without user intervention.
AR_CMGT_AUTO_RULE_DTLS 14 The AR_CMGT_AUTO_RULE_DTLS table stores rules about whether a credit review and credit decision may be processed without user intervention.
AR_CMGT_BANK_REF_ACCTS 15 The AR_CMGT_BANK_REF_ACCTS table stores detailed bank account balance information for the company under credit review.
AR_CMGT_BANK_REF_DATA 22 The AR_CMGT_BANK_REF_DATA table stores information about the banks where a company under credit review has active accounts.
AR_CMGT_CASE_FOLDERS 27 The AR_CMGT_CASE_FOLDERS table stores information for each case folder.
AR_CMGT_CF_AGING_DTLS 10 The AR_CMGT_CF_AGING_DTLS table stores the calculated aging bucket values for the customer under credit review when the case folder is creat
AR_CMGT_CF_ANL_NOTES 12 The AR_CMGT_CF_ANL_NOTES table stores topical notes created by the credit analyst and stored in the case folder during a credit review.
AR_CMGT_CF_DNB_DTLS 11 The AR_CMGT_CF_DNB_DTLS table identifies to Oracle Credit Management where Dun & Bradstreet Global Data Product report data is stored, when
AR_CMGT_CF_DTLS 15 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 17 The AR_CMGT_CF_RECOMMENDS table stores the credit recommendations submitted for each case folder.
AR_CMGT_CHECK_LISTS 18 The AR_CMGT_CHECK_LISTS table stores information about your organizations credit policies. Each checklist defines what data points and requi
AR_CMGT_CHECK_LIST_DTLS 9 The AR_CMGT_CHECK_LIST_DTLS table stores detail level information for a checklist in Oracle Credit Management.
AR_CMGT_COLLATERAL_DATA 19 The AR_CMGT_COLLATERAL_DATA table stores detailed information about assets that can be pledged to secure credit available by the company und
AR_CMGT_CREDIT_REQUESTS 55 The AR_CMGT_CREDIT_REQUESTS table stores information for each credit request.
AR_CMGT_DATA_POINTS_B 21 The AR_CMGT_DATA_POINTS_B table stores information about the details of each data point in Oracle Credit Management.
AR_CMGT_DATA_POINTS_TL 13 The AR_CMGT_DATA_POINTS_TL table provides multilingual support (MLS) for all case folder data points that are available for display in Oracl
AR_CMGT_DNB_ELEMENTS_B 13 The AR_CMGT_DNB_ELEMENTS_B table identifies the intersection between where Dun & Bradstreet Global Data Product report data is stored and ho
AR_CMGT_DNB_ELEMENTS_TL 11 The AR_CMGT_DNB_ELEMENTS_TL table provides multilingual support (MLS) for all Dun & Bradstreet data points displayed in a case folder in Ora
AR_CMGT_DNB_MAPPINGS 8 The AR_CMGT_DNB_MAPPINGS table identifies each data point contained within the Dun & Bradstreet Global Data Product reports and maps them to
AR_CMGT_FINANCIAL_DATA 43 The AR_CMGT_FINANCIAL_DATA table stores financial statements information about the company under credit review.
AR_CMGT_GUARANTOR_DATA 44 The AR_CMGT_GUARANTOR_DATA table stores information about an entity who is legally responsible for fulfilling a credit obligation if the pri
AR_CMGT_HOLD_DETAILS 9 This table stores hold details of a credit request
AR_CMGT_OTHER_DATA 26 The AR_CMGT_OTHER_DATA table stores detailed information about Venture Capital funding in use by the company under credit review.
AR_CMGT_SCORES 15 The AR_CMGT_SCORES table stores header level information for a credit scoring model.
AR_CMGT_SCORE_DTLS 12 The AR_CMGT_SCORE_DTLS table stores detail level information for a credit scoring model used in Oracle Credit Management.
AR_CMGT_SCORE_WEIGHTS 8 The AR_CMGT_SCORE_WEIGHTS table stores weights for each data point in a scoring model.
AR_CMGT_SETUP_OPTIONS 13 The AR_CMGT_SETUP_OPTIONS table stores information that you supply to customize Oracle Credit Management.
AR_CMGT_TRADE_REF_DATA 32 The AR_CMGT_TRADE_REF_DATA table stores information about the a companys credit and trade relationships of a company under credit review wit
AR_CM_FROM_GT 20
AR_CM_TO_GT 43
AR_COGS_REV_ITF 23 The AR_COGS_REV_ITF table holds temporary data for the COGS RXi reports.
AR_COLIND 6 Temporary table used by the Oracle Business Intelligence System (OBIS)
AR_COLLECTION_INDICATORS_ALL 37 Collection Indicators for a closed period, used by the Collection Indicators report
AR_COLLECTORS 32 Information about collectors
AR_CONC_PROCESS_REQUESTS 2 Currently running or terminated concurrent requests
AR_CONC_REQUEST_MESSAGES 7 Untranslated messages for server PL/SQL error and log reporting
AR_CONFIRMATION_ACTIONS 13 This table stores information about which action to take based on the information that is included in trading partner's confirmation message
AR_CONS_BILL_CYCLES_B 56 The AR_CONS_BILL_CYCLES_B table stores information on defined cycles. Receivables creates one row for each billing cycle that you define. Th
AR_CONS_BILL_CYCLES_TL 12 The AR_CONS_BILL_CYCLES_TL table provides multilingual support (MLS) for each billing cycle that you define in Receivables. MLS lets you sto
AR_CONS_BILL_CYCLE_DATES 7 This table stores billing dates for given billing cycle.
AR_CONS_INV_ALL 58 Information about a consolidated billing invoice
AR_CONS_INV_TRX_ALL 14 Transactions included on a consolidated billing invoice
AR_CONS_INV_TRX_LINES_ALL 13 Transaction lines included on a consolidated billing invoice
AR_CONT_ACTIONS_ALL 11 Maps contingencies and revenue recognition events
AR_CORRESPONDENCES_ALL 19 Dunning letters sent to a customer
AR_CORR_PAY_SCHED_ALL 13 Intersection table to show invoices referenced in a dunning letter
AR_CREATE_RECEIPTS_ERROR 22 Used to store error details during receipt creation
AR_CREATE_RECEIPTS_GT 86
AR_CREDIT_HISTORIES 35 History of changes to a customer's credit profile
AR_CREDIT_MEMO_AMOUNTS 13 GL dates for credit memos that use invoicing rules to back out revenue
AR_CRH_APP_GT 56
AR_CRH_GT 23
AR_CUSTOMER_ALT_NAMES 10 Alternate customer names for AutoLockbox name matching
AR_CUSTOMER_BALANCE_ITF 30 Customers selected for the Customer Open Balance Letter report
AR_CUSTOMER_CALLS_ALL 41 Customer call information
AR_CUSTOMER_CALL_TOPICS_ALL 44 Topic of a customer call
AR_CUSTOMER_PROFILES 105 Customer credit information
AR_CUSTOMER_PROFILE_AMOUNTS 77 Customer profile amount limits for each currency
AR_CUSTOMER_PROFILE_CLASSES 95 Customer profile class information
AR_CUST_PROF_CLASS_AMOUNTS 71 Customer profile class amount limits for each currency
AR_CUST_SEARCH_GT_ALL 12
AR_DEBUG 6
AR_DEFERRAL_REASONS 16 Revenue Contingency Definitions
AR_DEFERRED_LINES_ALL 35 Stores revenue status information at the line level
AR_DETECT_GT 5
AR_DISPUTE_HISTORY 13 A history of invoice disputes for each payment schedule
AR_DISTRIBUTIONS_ALL 45 Accounting records for receipts
AR_DISTRIBUTION_SETS_ALL 11 Groups together a set of distribution lines
AR_DISTRIBUTION_SET_LINES_ALL 11 The percentage and account for each line in a distribution set
AR_DOCUMENT_TRANSFERS 24 This table stores information about document transfer to your trading partners.
AR_DOC_SEQUENCE_AUDIT 5 A record for every document number generated
AR_DUNNING_LETTERS_B 25 Information about dunning letters
AR_DUNNING_LETTERS_CUSTOM_TL 12 Provides multi-lingual support (MLS) for custom dunning letters
AR_DUNNING_LETTERS_TL 11 Provides multi-lingual support (MLS) for standard dunning letters
AR_DUNNING_LETTER_SETS 33 Sequence in which dunning letters are sent
AR_DUNNING_LETTER_SET_LINES 31 Individual lines within a dunning letter set
AR_GL_ACCT_BALANCES 22 Used as a processing table for Cumulative Activity Balance Report.
AR_GL_RECON_GT 22
AR_GTA_AR_DIFFERENCE_TEMP 5
AR_GTA_BATCH_NUMBERING 7 GTA invoice batch number
AR_GTA_CONSOL_INVS_TEMP 6
AR_GTA_CONSOL_TEMP 11
AR_GTA_DIFFERENCE_TEMP 13
AR_GTA_IMPORT_REP_TEMP 9
AR_GTA_MISSING_ARTRX_TEMP 5
AR_GTA_RULE_DFFS_ALL 12 transfer rule defined on DFF on AR transaction
AR_GTA_RULE_HEADERS_ALL 16 Header-level information for transfer rule
AR_GTA_RULE_TRX_TYPES_ALL 11 Transfer rule defined on transaction type
AR_GTA_SYSTEM_PARAMETERS_ALL 22 System parameters for GTA
AR_GTA_TAX_LIMITS_ALL 11 Limted information for GTA invoice
AR_GTA_TRANSFER_TEMP 10
AR_GTA_TRXIMP_TMP 35 Temporary interface table for VAT invoice
AR_GTA_TRX_HEADERS_ALL 79 Header-level information for GTA Invoice
AR_GTA_TRX_LINES_ALL 51 Detail information for GTA invoice and VAT invoice
AR_GTA_TYPE_MAPPINGS 8 Transaction type mapping to Tax Registration Number and Invoice Type
AR_GTA_UNMATCHED_TEMP 13
AR_INTEREST_BATCHES_ALL 14 Late Charge batches
AR_INTEREST_HEADERS_ALL 55 Late Charge headers
AR_INTEREST_LINES_ALL 34 Late Charge lines
AR_INTERFACE_CONTS_ALL 49 Contingency information for transactions imported using AutoInvoice
AR_INTERIM_CASH_LINE_DETAILS 46 Temporary table used to store QuickCash payment applications - line level details
AR_INTERIM_CASH_RCPT_LINES_ALL 66 Temporary table used to store QuickCash payment applications
AR_INTERIM_CASH_RECEIPTS_ALL 89 QuickCash payments processed by the PostBatch program
AR_INTERIM_POSTING 9 Used for posting when Cash Basis accounting is used
AR_INV_API_DIST_GT 9
AR_INV_API_HEADERS_GT 47
AR_INV_API_LINES_GT 17
AR_IREC_PAYMENT_GT_ALL 72
AR_IREC_PRINT_REQUESTS 17 Stores iReceivables transaction print requests and BPA immediate print output.
AR_IREC_SELFREG_CUST_QS 23 Contains the self registration customer verification questions.
AR_IREC_SELFREG_SITE_QS 23 Contains the self registration site verification questions.
AR_IREC_USER_ACCT_SITES_ALL 13 Contains the list of customer site IDs accessible by the current user.
AR_JOURNAL_INTERIM_ALL 93 Temporary table used by the Journal Entries report
AR_LATE_CHARGE_CREDITS_GT 6
AR_LATE_CHARGE_CUST_BALANCE_GT 7
AR_LATE_CHARGE_DOC_GT 38
AR_LATE_CHARGE_TRX_T 47 Late Charge processing table
AR_LC_CUST_SITES_T 47 Late Charge processing table
AR_LINE_APP_DETAIL_GT 44
AR_LINE_CONTS_ALL 17 Stores contingencies for a billing line
AR_LLCA_ADJ_TRX_ERRORS_GT 5
AR_LLCA_ADJ_TRX_LINES_GT 4
AR_LLCA_TRX_ERRORS_GT 4
AR_LLCA_TRX_LINES_GT 28
AR_LOCATION_ACCOUNTS_ALL 38 Stores the tax accounting information
AR_LOCATION_RATES_OLD 48 Sales tax rates for each tax authority
AR_LOCATION_VALUES_OLD 45 Defines the location and description for each of the value sets used in the Sales Tax Location flexfield
AR_LOCKBOXES_ALL 43 Lockbox details used by the AutoLockbox program
AR_LOC_COMBINATIONS_OLD 40 Defines each distinct tax authority
AR_MC_ADJUSTMENTS 7 Currency-related information about invoice adjustments for each reporting set of books
AR_MC_BATCHES 5 Currency-related information about receipt batches for each reporting set of books
AR_MC_CASH_BASIS_DISTS_ALL 24 Distribution of payments over revenue accounts, used in Cash Basis Accounting for MRC
AR_MC_CASH_RECEIPTS 5 Currency-related information about receipts for each reporting set of books
AR_MC_CASH_RECEIPT_HIST 16 Currency-related information about each step in the life cycle of a receipt for each reporting set of books
AR_MC_DISTRIBUTIONS_ALL 34 Currency-related information about distributions generated by the different steps in the life cycle of a cash receipt
AR_MC_MISC_CASH_DISTS 11 Currency and accounting information about miscellaneous cash applications for each reporting set of books
AR_MC_PAYMENT_SCHEDULES 8 Currency-related information about all transactions except adjustments and miscellaneous cash receipts
AR_MC_RATE_ADJUSTMENTS 9 Currency-related information about exchange rate adjustments for each reporting set of books
AR_MC_RECEIVABLE_APPS 21 Cash and credit memo applications for each reporting set of books
AR_MC_TRANSACTION_HISTORY 12 Stores posting-related information about transaction history lines for each reporting set of books associated with the parent record.
AR_MEMO_LINES_ALL_B 56 Standard memo lines for debit memos, on-account credits, debit memo reversals, and chargebacks
AR_MEMO_LINES_ALL_TL 12 Provides multilingual support (MLS) for standard memo lines
AR_MISC_CASH_DISTRIBUTIONS_ALL 47 All accounting entries for miscellaneous cash applications
AR_NOTES 12 Memopad information for customer calls
AR_PAYMENTS_INTERFACE_ALL 262 Imported Lockbox information that was not validated
AR_PAYMENT_SCHEDULES_ALL 133 All transactions except adjustments and miscellaneous cash receipts
AR_PERIODS 6 Information about accounting periods
AR_PERIOD_CLOSE_EXCPS_GT 26
AR_PERIOD_TYPES 2 Information about accounting period types
AR_PMTS_INTERFACE_HEADER_GT 13
AR_PMTS_INTERFACE_LINES_GT 12
AR_PMTS_INTERFACE_LINE_DETAILS 16 Table used to store Imported Lockbox line level application information that was not validated.
AR_POSTING_CONTROL 19 Details of each General Ledger Interface submission
AR_POSTING_REPORT_INTERIM 13 Temporary table used by the Posting Execution report
AR_POTENTIAL_CUSTOMERS_GT 2
AR_PROCESS_SETTLE_ERRORS_GT 2
AR_PURGE_OE_EXCEPTIONS 1 Interim table used by the Archive and Purge process to store identifiers for transactions that cannot be purged
AR_PURGE_REC_AUX 3 Interim table used by the Archive and Purge process to store identifiers for selected receipts
AR_PURGE_TRX_AUX 4 Interim table used by the Archive and Purge program to store identifiers for selected transactions
AR_RAMC_AUDIT_TRAIL 36 This maintains revenue related status changes for invoices.
AR_RATE_ADJUSTMENTS_ALL 46 Information about adjustments made to the exchange rates of foreign currency receipts
AR_RDR_PARAMETERS_GT 23
AR_RECEIPTS_GT 15
AR_RECEIPTS_REP_ITF 89 Report Exchange interface table for the Receivables Receipts reports
AR_RECEIPT_CLASSES 53 Information about receipt classes
AR_RECEIPT_METHODS 64 Information about payment methods
AR_RECEIPT_METHOD_ACCOUNTS_ALL 76 Account information for accounts used by payment methods
AR_RECEIVABLES_TRX_ALL 62 Accounting information for Receivables activities
AR_RECEIVABLE_APPLICATIONS_ALL 136 Accounting information for cash and credit memo applications
AR_RECEIVABLE_APPS_GT 45
AR_REC_TRX_LE_DETAILS_ALL 10 Stores the tax_rate_codes by legal entity for each receivable activity.
AR_REVENUE_ADJUSTMENTS_ALL 50 Stores information about specific revenue adjustments
AR_REVENUE_ASSIGNMENTS_GT 13
AR_REVIEWED_LINES_GT 12
AR_RR_CRH_GT 58
AR_SALES_TAX 45 Sales tax information for each tax authority defined in Oracle Receivables
AR_SALES_TAX_REP_ITF 119 Report Exchange interface table for the US Sales Tax report
AR_SELECTION_CRITERIA 19 Stores the selection criteria on a entity.
AR_SETTLEMENT_ERRORS_GT 5
AR_STANDARD_TEXT_B 28 Standard statement messages
AR_STANDARD_TEXT_TL 10 Multilingual support (MLS) for standard text messages that you define for statements
AR_STATEMENTS_HISTORY_ALL 24 The history of every customer statement that you generate
AR_STATEMENT_CYCLES 29 Information about statement cycles
AR_STATEMENT_CYCLE_DATES_ALL 15 Dates within a cycle for sending customer statements
AR_STATEMENT_CYCLE_INTERVALS 8 Statement cycle intervals
AR_STATEMENT_HEADERS 47 Interim table of statement header information
AR_STATEMENT_LINE_CLUSTERS 23 Interim table of transaction lines that appear on a statement
AR_SUM_REF_EVENT_HIST 15 The AR_SUM_REF_EVENT_HIST table temporarily stores the history of all AR business events that different transactional activities raise while
AR_SYSTEM_PARAMETERS_ALL 153 Oracle Receivables system options
AR_TAX_CONDITIONS_ALL 47 Tax Condition Sets
AR_TAX_CONDITION_ACTIONS_ALL 49 Actions performed by Tax Condition Sets
AR_TAX_CONDITION_LINES_ALL 52 Tax Condition Lines
AR_TAX_GROUP_CODES_ALL 57 Tax codes within a tax group
AR_TAX_INTERFACE 67 Sales tax rates import table
AR_TRANSACTIONS_REP_ITF 55 Report Exchange interface table for the Receivables Transactions reports
AR_TRANSACTION_HISTORY_ALL 47 Life cycle of a transaction
AR_TRANSMISSIONS_ALL 41 Lockbox transmission information
AR_TRANSMISSION_FORMATS 27 Lockbox transmission formats
AR_TRANS_FIELD_FORMATS 19 Format of each field in a Lockbox transmission format
AR_TRANS_RECORD_FORMATS 27 Format of a record within a Lockbox transmission format
AR_TRX_BAL_SUMMARY 41 This table stores the fields, such as 'Total Invoices Value', 'Total Invoices Count', 'Total Cash Receipts Value', etc., that require summar
AR_TRX_COGS_GT 10
AR_TRX_DIST_GT 101
AR_TRX_DIST_TMP_GT 56
AR_TRX_HEADER_GT 200
AR_TRX_HEADER_TMP_GT 123
AR_TRX_LINES_GT 148
AR_TRX_LINES_TMP_GT 119
AR_TRX_SUMMARY 50 This table stores the fields, such as 'Total Invoices Value', 'Total Invoices Count', 'Total Cash Receipts Value', etc., that require summar
AR_TRX_SUMMARY_HIST 22 This table stores the history of all the modifications, performed on different transactions, which would affect the data in the summary tabl
AR_UPG_120_CONTROL 11 This table is used to control ar 12.0 upgrade scripts
AR_VAT_TAX_ALL_B 77 Tax codes defined in the Tax Codes and Rates window
AR_VAT_TAX_ALL_TL 10 Multi-lingual support (MLS) for each tax code that you define
AR_XLA_HEADERS_EXTRACT 46
AR_XLA_LINES_EXTRACT 110
HZ_ADAPTERS 20 The HZ_ADAPTERS table stores information about the adapters that are configured to provide data integration services
HZ_ADAPTER_LOGS 13 The HZ_ADAPTER_LOGS table tracks requests for service from data integration services providers
HZ_ADAPTER_TERRITORIES 10 The HZ_ADAPTER_TERRITORIES table stores information about the countries or territories that are supported for a particular data integration
HZ_ADAPTER_USERS 8 Stores user information for adapters
HZ_ADDRESS_USAGES 12 Contains the address usages per country
HZ_ADDRESS_USAGE_DTLS 11 Contains the required geography
HZ_BILLING_PREFERENCES 20 Invoicing format
HZ_BUS_OBJ_DEFINITIONS 17 Stores definitions of TCA business objects
HZ_BUS_OBJ_TRACKING 14 Tracks granular (V2) entities for raising Business Object events
HZ_CERTIFICATIONS 19 Certifications given to parties
HZ_CITIZENSHIP 23 Person's claimed nationality
HZ_CLASS_CATEGORIES 16 Classification categories for classifying parties and related entities
HZ_CLASS_CATEGORY_USES 13 Usage of class categories by owner tables
HZ_CLASS_CODE_DENORM 22 Denormalization of the classification code hierarchy
HZ_CLASS_CODE_RELATIONS 14 Relationships between classification codes
HZ_CODE_ASSIGNMENTS 30 Intersection table linking industrial classification codes to parties or related entities
HZ_CONTACT_POINTS 105 Electronic methods of communicating with parties
HZ_CONTACT_POINT_VAL_GT 59
HZ_CONTACT_PREFERENCES 31 Stores contact preference information for parties or their addresses and contact points
HZ_CONTACT_RESTRICTIONS 18 Restrictions on contacting parties
HZ_CREDIT_PROFILES 36 Profiles about a party's credit policy
HZ_CREDIT_PROFILE_AMTS 30 Credit limits in specified currency
HZ_CREDIT_RATINGS 110 Credit ratings of parties
HZ_CREDIT_RATINGS_EXT_B 58 Stores extensible attributes for credit ratings.
HZ_CREDIT_RATINGS_EXT_TL 30 Provides multilingual support for extensible credit rating attributes.
HZ_CREDIT_USAGES 30 Association between credit limit and credit usage rule set
HZ_CREDIT_USAGE_RULES 31 Usage rules assigned to each credit limit
HZ_CREDIT_USAGE_RULE_SETS_B 27 Sets of credit usage rules in the base language
HZ_CREDIT_USAGE_RULE_SETS_TL 9 Sets of credit usage rules translated into multiple languages
HZ_CUSTOMER_MERGE_LOG 356 This table is used to record account merge audit history
HZ_CUSTOMER_PROFILES 120 Credit information for customer accounts and customer account sites
HZ_CUSTOMER_PROFILES_M 120 This table is used to store the deleted records for hz_customer_profiles during account merge
HZ_CUST_ACCOUNTS 139 Stores information about customer accounts.
HZ_CUST_ACCOUNTS_M 119 This table is used to store the deleted records for HZ_CUST_ACCOUNTS during account merge
HZ_CUST_ACCOUNT_ROLES 73 Roles that parties perform in customer accounts
HZ_CUST_ACCOUNT_ROLES_M 70 This table stores the information of a customer account role from HZ_CUST_ACCOUNT_ROLES table before the account merge happens. The primar
HZ_CUST_ACCT_RELATE_ALL 38 Relationships between customer accounts
HZ_CUST_ACCT_RELATE_ALL_M 40 This table is used to store the deleted records for HZ_CUST_ACCT_RELATE_ALL during account merge
HZ_CUST_ACCT_SITES_ALL 76 Stores all customer account sites across all operating units
HZ_CUST_ACCT_SITES_ALL_M 76 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
HZ_CUST_CONTACT_POINTS 15 This table is no longer used
HZ_CUST_MERGE_LOG_DICT 285 This table is used to define the data in hz_customer_merge_log
HZ_CUST_PROFILE_AMTS 95 Stores information about the credit limits specified for a customer's profile.
HZ_CUST_PROFILE_AMTS_M 97 The HZ_CUST_PROFILE_AMTS_M table stores the information of customer profile amounts from HZ_CUST_PROFILE_AMTS table before the account mer
HZ_CUST_PROFILE_CLASSES 112 Standard credit profile classes
HZ_CUST_PROF_CLASS_AMTS 91 Customer profile class amount limits for each currency
HZ_CUST_SITE_USES_ALL 117 Stores business purposes assigned to customer account sites.
HZ_CUST_SITE_USES_ALL_M 118 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 h
HZ_DL_SELECTED_CRITERIA 11 Stores criteria for selecting parties to include in batches
HZ_DNB_REQUEST_LOG 11 Requests for information from Dun & Bradstreet
HZ_DQM_SETUP_DIAGNOSTICS 10 Table for storing the Diagnostic Data for reports
HZ_DQM_SH_SYNC_INTERFACE 16 Stores the list of entities that have been created or updated by the DQM API since the DQM Shadow Staging Program concurrent program was las
HZ_DQM_STAGE_LOG 13 This table logs the phases that the DQM Staging Program is at
HZ_DQM_SYNC_INTERFACE 16 Stores the list of entities that have been updated by the DQM API.
HZ_DSS_ASSIGNMENTS 15 Data sharing group assignments
HZ_DSS_CRITERIA 16 Data sharing group criteria
HZ_DSS_ENTITIES 18 Entities that can be secured
HZ_DSS_GROUPS_B 11 Data Sharing Groups
HZ_DSS_GROUPS_TL 11 Translation table for HZ_DSS_GROUPS_TL
HZ_DSS_SCHEME_FUNCTIONS 11 Functions that are used by a particular data security scheme
HZ_DSS_SECURED_ENTITIES 11 Entities that are secured by a particular data sharing group
HZ_DUP_BATCH 13 Duplicate Identification Batch
HZ_DUP_EXCLUSIONS 10 Duplicate Exclusions
HZ_DUP_MATCH_DETAILS 11 Match Details
HZ_DUP_MERGE_PARTIES 8 Parties to be Merged
HZ_DUP_RESULTS 5 The HZ_DUP_RESULTS table temporarily stores duplicate identification data during the duplicate identification of interface tables. The table
HZ_DUP_SETS 13 Duplicate Party Sets
HZ_DUP_SET_PARTIES 16 Parties belonging to a Duplicate Party Set
HZ_EBI_CUST_LOAD_LOG 2
HZ_EDUCATION 23 Person's education information
HZ_EMAIL_DOMAINS 10 Entity that holds email domains of organization parties.
HZ_EMPLOYMENT_HISTORY 36 Person's employment information
HZ_ENTITY_ATTRIBUTES 17 Entities and Attribute information used by Third Party Data Integration.
HZ_EXT_DATA_RULES_TL 10 Rule Name translation table for Third Party Data Integration.
HZ_FINANCIAL_NUMBERS 23 Details of financial reports
HZ_FINANCIAL_PROFILE 21 Financial accounts of parties
HZ_FINANCIAL_REPORTS 38 Financial reports of parties
HZ_FIN_NUMBERS_EXT_B 58 Stores extensible attributes for financial numbers.
HZ_FIN_NUMBERS_EXT_TL 30 Provides multilingual support for extensible financial number attributes.
HZ_FIN_REPORTS_EXT_B 58 Stores extensible attributes for financial reports.
HZ_FIN_REPORTS_EXT_TL 30 Provides multilingual support for extensible financial report attributes.
HZ_GEOGRAPHIES 69 The HZ_GEOGRPHIES table stores data representing physical geographies.
HZ_GEOGRAPHY_IDENTIFIERS 21 HZ_GEOGRPHY_IDENTIFIERS stores multiple identifiers used to describe the same geography.
HZ_GEOGRAPHY_RANGES 21 Stores ranges associated with a given geography.
HZ_GEOGRAPHY_TYPES_B 17 HZ_GEOGRPHY_TYPES_B stores Geography Type classification for geographies: both Master Reference Geography Types and non-Master Reference Geo
HZ_GEOGRAPHY_TYPES_TL 16 HZ_GEOGRPHY_TYPES_TL stores Geography Types in MLS languages.
HZ_GEO_NAME_REFERENCES 14 Stores the mapping between location elements and Master Reference geography elements based on Geography Name Matching.
HZ_GEO_NAME_REFERENCE_LOG 15 Stores the mapping log between location elements and Master Reference geography elements based on Geography Name Matching.
HZ_GEO_STRUCTURE_LEVELS 20 Stores the geographical hierarchical structures.
HZ_GEO_STRUCT_MAP 9 The HZ_GEO_STRUCT_MAP table stores the map attributes for which a mapping of location components and geography types are defined.
HZ_GEO_STRUCT_MAP_DTL 10 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_STR
HZ_GROUP_VAL_GT 6
HZ_HIERARCHY_NODES 20 Contains denormalized data for hierarchical relationships.
HZ_IMP_ADAPTERS 16 The HZ_IMP_ADAPTERS table stores information about using location services adapters to validate addresses in the interface tables before imp
HZ_IMP_ADDRESSES_INT 81 TCA import table for HZ_LOCATIONS and HZ_PARTY_SITES
HZ_IMP_ADDRESSES_SG 15 TCA internal table for processing information loaded into the HZ_IMP_ADDRESSES_INT
HZ_IMP_ADDRESSUSES_INT 20 TCA import table for HZ_PARTY_SITE_USES
HZ_IMP_ADDRESSUSES_SG 12 TCA internal table for processing information loaded into the HZ_IMP_ADDRESSUSES_INT
HZ_IMP_BATCH_DETAILS 15 The HZ_IMP_BATCH_DETAILS table stores detail information about imports of records from the interface tables to the TCA Registry. The table i
HZ_IMP_BATCH_SUMMARY 158 The HZ_IMP_BATCH_SUMMARY table stores information about import batches
HZ_IMP_CLASSIFICS_INT 23 TCA import table for HZ_CODE_ASSIGNMENTS
HZ_IMP_CLASSIFICS_SG 15 TCA internal table for processing information loaded into the HZ_IMP_CLASSIFICS_INT
HZ_IMP_CONTACTPTS_INT 72 TCA import table for HZ_CONTACT_POINTS
HZ_IMP_CONTACTPTS_SG 15 TCA internal table for processing information loaded into the HZ_IMP_CONTACTPTS_INT
HZ_IMP_CONTACTROLES_INT 19 TCA import table for HZ_ORG_CONTACT_ROLES
HZ_IMP_CONTACTROLES_SG 9 TCA internal table for processing information loaded into the HZ_IMP_CONTACTROLES_INT
HZ_IMP_CONTACTS_INT 57 TCA import table for HZ_PARTIES, HZ_RELATIONSHIPS and HZ_ORG_CONTACTS
HZ_IMP_CONTACTS_SG 17 TCA internal table for processing information loaded into the HZ_IMP_CONTACTS_INT
HZ_IMP_CREDITRTNGS_INT 108 TCA import table for HZ_CREDIT_RATINGS
HZ_IMP_CREDITRTNGS_SG 9 TCA internal table for processing information loaded into the HZ_IMP_CREDITRTNGS_INT
HZ_IMP_DUP_DETAILS 15 No Comments
HZ_IMP_DUP_PARTIES 12 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 a
HZ_IMP_ERRORS 23 TCA import table used to record error found during the import process
HZ_IMP_FINNUMBERS_INT 28 TCA import table for HZ_FINANCIAL_NUMBERS
HZ_IMP_FINNUMBERS_SG 16 TCA internal table for processing information loaded into the HZ_IMP_FINNUMBERS_INT
HZ_IMP_FINREPORTS_INT 37 TCA import table for HZ_FINANCIAL_REPORTS
HZ_IMP_FINREPORTS_SG 15 TCA internal table for processing information loaded into the HZ_IMP_FINREPORTS_INT
HZ_IMP_INT_DEDUP_RESULTS 16 The HZ_IMP_INT_DEDEUP_RESULTS table stores the set of duplicates identified as part of the duplicate identification of interface tables. Eac
HZ_IMP_OSR_CHANGE 7 TCA internal table for processing information loaded into the
HZ_IMP_PARTIES_INT 133 TCA import table for HZ_PARTIES, HZ_PERSON_PROFILES and HZ_ORG_PROFILES
HZ_IMP_PARTIES_SG 9 TCA internal table for processing information loaded into the HZ_IMP_PARTIES_INT
HZ_IMP_RELSHIPS_INT 45 TCA import table for HZ_PARTIES, HZ_PERSON_PROFILES and HZ_ORG_PROFILES
HZ_IMP_RELSHIPS_SG 14 TCA internal table for processing information loaded into the HZ_IMP_RELSHIPS_INT
HZ_IMP_TMP_ERRORS 67 TCA import table used during runtime to record errors found during import process
HZ_IMP_TMP_REL_END_DATE 10 TCA internal table for storing relationships to be end dated during bulk import
HZ_IMP_WORK_UNITS 10 TCA import table used to manage work units during the import process
HZ_INDUSTRIAL_CLASSES 16
HZ_INDUSTRIAL_CLASS_APP 17
HZ_INDUSTRIAL_REFERENCE 17 Industrial references for organizations
HZ_INT_DUP_RESULTS 8 The HZ_INT_DUP_RESULTS table temporarily stores duplicate identification data during the duplicate identification of interface tables. The t
HZ_INT_DUP_RESULTS_GT 8
HZ_LOCATIONS 116 Physical addresses
HZ_LOCATIONS_EXT_B 58 Stores extensible attributes for locations.
HZ_LOCATIONS_EXT_TL 30 Provides multilingual support for extensible location attributes.
HZ_LOCATION_PROFILES 27 The HZ_LOCATION_PROFILES table stores information, including a history of any changes and address validations for a subset of attributes fro
HZ_LOCATION_VAL_GT 61
HZ_LOC_ASSIGNMENTS_OBS 16 No longer used in R12.
HZ_LOG2 12 No longer used.
HZ_MATCH_RULES_B 19 Stores information about match rules.
HZ_MATCH_RULES_TL 12 Stores translated information about match rules.
HZ_MATCH_RULE_CONDITIONS 20 Stores information conditions and match rules in match rule sets
HZ_MATCH_RULE_PRIMARY 13 Stores information about primary attributes in a match rule.
HZ_MATCH_RULE_SECONDARY 13 Stores information about secondary attributes in a match rule.
HZ_MERGE_BATCH 14 Party Merge batch header information
HZ_MERGE_DICTIONARY 23 Tables affected by party merge concurrent program
HZ_MERGE_ENTITY_ATTRIBUTES 14 Attribute level merge information for Party Merge
HZ_MERGE_PARTIES 12 Party Merge batch detail information
HZ_MERGE_PARTIES_SUGG 12 Suggested default information of party merge batch details
HZ_MERGE_PARTYDTLS_SUGG 11 Suggested default details for operations performed on the records for merge
HZ_MERGE_PARTY_DETAILS 11 Details regarding operations performed on the records
HZ_MERGE_PARTY_HISTORY 15 History of records affected by Party Merge operation
HZ_MERGE_PARTY_LOG 16 Information about the Party Merge operation
HZ_MOBILE_PREFIXES 10 Mobile telephone number prefixes based on country
HZ_NON_PURGE_CANDIDATES 13 Stores the parties that have not been identified for purge along with denormalized information about the parties.
HZ_ORGANIZATION_INDICATORS 18 Indicators related to finance, legal, and business standing for business sites
HZ_ORGANIZATION_PROFILES 185 Detailed information about organizations
HZ_ORG_CONTACTS 82 People as contacts for parties
HZ_ORG_CONTACT_ROLES 37 Roles played by organization contacts
HZ_ORG_PROFILES_EXT_B 59 Stores extensible attributes for organizations.
HZ_ORG_PROFILES_EXT_SG 4 Staging table for copying extensions data for organization profile versioning.
HZ_ORG_PROFILES_EXT_TL 30 Provides multilingual support for extensible organization attributes.
HZ_ORG_PROFILE_VAL_GT 138
HZ_ORIG_SYSTEMS_B 36 Stores basic source system information
HZ_ORIG_SYSTEMS_TL 11 Provides multilingual support for source system information
HZ_ORIG_SYS_MAPPING 35 The HZ_ORIG_SYS_MAPPING table stores the mapping among source systems and owner table names.
HZ_ORIG_SYS_REFERENCES 44 The HZ_ORIG_SYSTEM_REFERENCES table stores the mapping between source system references and the owner tables.
HZ_PARAM_TAB 6 No longer used
HZ_PARTIES 139 Information about parties such as organizations, people, and groups
HZ_PARTY_INTERFACE 262 Information about party retrieved from external source
HZ_PARTY_INTERFACE_ERRORS 8 Information about API errors
HZ_PARTY_PREFERENCES 20 Party Preferences
HZ_PARTY_RELATIONSHIPS 63 Relationships between parties
HZ_PARTY_SITES 75 Links party to physical locations
HZ_PARTY_SITES_EXT_B 58 Stores extensible attributes for party sites.
HZ_PARTY_SITES_EXT_TL 30 Provides multilingual support for extensible party site attributes.
HZ_PARTY_SITE_USES 21 The way that a party uses a particular site or address
HZ_PARTY_SITE_VAL_GT 34
HZ_PARTY_USAGES_B 13 Stores party usage definition.
HZ_PARTY_USAGES_TL 11 Provides multilingual support for party usage definitions.
HZ_PARTY_USAGE_RULES 13 Stores party usage rules.
HZ_PARTY_USG_ASSIGNMENTS 42 Stores information about party usage assignments.
HZ_PARTY_VAL_GT 32
HZ_PERSON_INTEREST 25 Information about a person's personal interests
HZ_PERSON_LANGUAGE 23 Languages that a person speaks, reads, or writes
HZ_PERSON_PROFILES 106 Detailed information about people
HZ_PER_PROFILES_EXT_B 59 Stores extensible attributes for persons.
HZ_PER_PROFILES_EXT_SG 4 Staging table for copying extensions data for person profile versioning.
HZ_PER_PROFILES_EXT_TL 30 Provides multilingual support for extensible person attributes.
HZ_PHONE_AREA_CODES 12 Telephone number area codes based on country
HZ_PHONE_COUNTRY_CODES 15 Country-specific phone number information
HZ_PHONE_FORMATS 12 Country-specific phone number formats
HZ_PRIMARY_TRANS 11 Stores information about transformation for the primary attributes.
HZ_PURGE_BATCHES 16 Stores the Batches that have been created for purge.
HZ_PURGE_CANDIDATES 13 Stores the parties that have been identified for purge along with denormalized information about the parties.
HZ_REFERENCES 18 References given for parties
HZ_RELATIONSHIPS 104 Relationships between entities
HZ_RELATIONSHIP_TYPES 25 Relationship types
HZ_RELATIONSHIP_VAL_GT 38
HZ_ROLE_RESPONSIBILITY 34 Responsibilities for parties related to their roles in the accounts
HZ_SECONDARY_TRANS 14 Stores information about transformation for the secondary attributes.
HZ_SECURITY_ISSUED 22 Financial instruments issued by an organization
HZ_SELECT_DATA_SOURCES 13 Selected data sources for Third Party Data Integration.
HZ_SHADOW_ST_CONTACTS 261
HZ_SHADOW_ST_CPTS 264
HZ_SHADOW_ST_PARTIES 261
HZ_SHADOW_ST_PSITES 262
HZ_SRCH_CONTACTS 264 This table stores the transformed data for the contacts in the interface tables.
HZ_SRCH_CPTS 268 This table stores the transformed data for the contact points in the interface tables.
HZ_SRCH_PARTIES 260 This table stores the transformed data for the parties in the interface tables.
HZ_SRCH_PSITES 264 This table stores the transformed data for the addresses in the interface tables.
HZ_STAGED_CONTACTS 261 Contact information that is staged for DQM.
HZ_STAGED_CONTACT_POINTS 264 Contact point information that is staged for DQM.
HZ_STAGED_PARTIES 261 Party information that is staged for DQM.
HZ_STAGED_PARTY_SITES 262 Party Site information that is staged for DQM.
HZ_STOCK_MARKETS 14 Exchanges for buying and selling financial instruments
HZ_STYLES_B 9 Styles to classify formats.
HZ_STYLES_TL 11 Translation table for HZ_STYLES_B
HZ_STYLE_FMT_LAYOUTS_B 25 Layout of particular style format Variation components.
HZ_STYLE_FMT_LAYOUTS_TL 10 Translation table for HZ_STYLE_FMT_LAYOUTS_B
HZ_STYLE_FMT_LOCALES 13 Specific locations for style formats.
HZ_STYLE_FMT_VARIATIONS 13 Variations in layout for style formats.
HZ_STYLE_FORMATS_B 10 Specific formats valid for one or more locations.
HZ_STYLE_FORMATS_TL 11 Translation table for HZ_STYLE_FORMATS_B.
HZ_SUSPENSION_ACTIVITY 22 The point in time that a service is no longer provided
HZ_THIN_ST_CONTACTS 7
HZ_THIN_ST_CPTS 10
HZ_THIN_ST_PARTIES 5
HZ_THIN_ST_PSITES 8
HZ_THIRDPARTY_EXCEPS 7 Exceptions to overwrite rules for specific attributes of specific parties for Third Party Data Integration.
HZ_THIRDPARTY_RULE 8 Overwrite rules for specific attributes for Third Party Data Integration.
HZ_TIMEZONES 22 Time zone information
HZ_TIMEZONES_TL 11 Time zone translations
HZ_TIMEZONE_MAPPING 14 Mapping of address elements to time zones
HZ_TRANS_ATTRIBUTES_B 14 Stores information about the transformations on attributes.
HZ_TRANS_ATTRIBUTES_TL 11 Stores translated information about the transformations on attributes.
HZ_TRANS_FUNCTIONS_B 16 Stores transformation functions.
HZ_TRANS_FUNCTIONS_TL 12 Stores translated transformation functions.
HZ_USER_CREATE_RULES 9 User data creation rules for Third Party Data Integration.
HZ_USER_OVERWRITE_RULES 9 User overwrite rules for Third Party Data Integration.
HZ_WIN_SOURCE_EXCEPS 13 Stores attribute exception information if data are overwritten contrary to the Third Party Data Integration data source ranking.
HZ_WORD_LISTS 12 Word Replacement Lists for Data Quality Management.
HZ_WORD_REPLACEMENTS 32 Word replacement rules for Fuzzy Find functionality
HZ_WORD_RPL_CONDS_B 11 Stores information about conditions in word replacement lists
HZ_WORD_RPL_CONDS_TL 12 Provides multilingual support for word replacement conditions.
HZ_WORD_RPL_COND_ATTRIBS 9 Stores attributes associated with word replacement conditions.
HZ_WORK_CLASS 18 Classifications or groupings of work activities
RA_ACCOUNT_COMBINATIONS 25 Account information for internal Oracle users
RA_ACCOUNT_DEFAULTS_ALL 24 AutoAccounting information
RA_ACCOUNT_DEFAULT_SEGMENTS 27 AutoAccounting segment information
RA_ADDRESSES_ALL 97 Customer address information
RA_AR_AMOUNTS_GT 77
RA_AR_GT 254
RA_BATCHES_ALL 47 Invoice batch information
RA_BATCH_SOURCES_ALL 98 Sources of invoice, credit memo and commitments
RA_CM_REQUESTS_ALL 90 Pending and approved credit memo requests
RA_CM_REQUEST_LINES_ALL 64 Pending and approved credit memo request lines
RA_CONTACTS 69
RA_CONTACT_PHONES_INT_ALL 72 Used by Customer Interface to import contact and telephone information
RA_CONTACT_ROLES 30 Contact roles
RA_CUSTOMERS 117 Customer information
RA_CUSTOMERS_INTERFACE_ALL 214 Customer Interface table
RA_CUSTOMER_BANKS_INT_ALL 108 Customer Interface table for customer banks
RA_CUSTOMER_MERGES 60 Information about customers, addresses, and site uses that are being merged or moved
RA_CUSTOMER_MERGE_HEADERS 46 This table is used to store the high level information about an account merge request.
RA_CUSTOMER_PROFILES_INT_ALL 154 Customer Interface table for customer profile information
RA_CUSTOMER_RELATIONSHIPS_ALL 32 Information about customer relationships
RA_CUSTOMER_TRX_ALL 187 Header-level information about invoices, debit memos, chargebacks, commitments and credit memos
RA_CUSTOMER_TRX_LINES_ALL 158 Invoice, debit memo, chargeback, credit memo and commitment lines
RA_CUSTOMER_TRX_LINES_GT 49
RA_CUST_PAY_METHOD_INT_ALL 31 Customer Interface table for Payment Methods
RA_CUST_RECEIPT_METHODS 32 Payment Methods assigned to a customer and/or customer site
RA_CUST_TRX_LINE_GL_DIST_ALL 95 Accounting records for revenue, unearned revenue and unbilled receivables
RA_CUST_TRX_LINE_SALESREPS_ALL 40 Sales credit assignments for transactions
RA_CUST_TRX_TYPES_ALL 83 Transaction type for invoices, commitments and credit memos
RA_GROUPING_RULES 28 AutoInvoice grouping rules
RA_GROUPING_TRX_TYPES 25 Transaction types associated with AutoInvoice grouping rules
RA_GROUP_BYS 24 Columns to group by for each grouping rule and transaction type
RA_GROUP_BY_COLUMNS 11 Table of columns to group by for AutoInvoice grouping rules
RA_INTERFACE_DISTRIBUTIONS_ALL 140 Accounting distributions for transactions imported using AutoInvoice
RA_INTERFACE_ERRORS_ALL 8 Interface data that failed AutoInvoice validation
RA_INTERFACE_LINES_ALL 342 Information for each invoice line imported using AutoInvoice
RA_INTERFACE_REQID_GT 3
RA_INTERFACE_SALESCREDITS_ALL 49 Sales credit information for transactions imported using AutoInvoice
RA_ITEM_EXCEPTION_RATES 48 Product tax rate exceptions
RA_LINE_ORDERING_RULES 27 AutoInvoice line ordering rules
RA_LINE_ORDER_BYS 26 Columns to order by for each AutoInvoice line ordering rule
RA_LINE_ORDER_BY_COLUMNS 9 Table of columns to order by for AutoInvoice line ordering rules
RA_MC_BATCHES 5 Currency-related information about invoice batches for each reporting set of books
RA_MC_CUSTOMER_TRX 5 Currency-related information about invoice, debit memo, commitment, and credit memo header information
RA_MC_CUSTOMER_TRX_LINES 8 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 10 Currency and accounting records for revenue, unearned revenue and unbilled receivables
RA_PHONES 36 Telephone and communications information
RA_RECUR_INTERIM 15 Temporary table that holds invoices to be copied
RA_REMIT_TOS_ALL 28 Links remit-to addresses with state and country
RA_RULES 30 Invoicing and accounting rules
RA_RULE_SCHEDULES 26 Accounting schedules for invoices with rules
RA_SALESREP_TERRITORIES 30 Territory information for salespeople
RA_SITE_USES_ALL 114 Business purpose of a customer address
RA_TAX_EXEMPTIONS_ALL 60 Percentage that a customer, site, or item is exempt from a tax code
RA_TERMS_B 35 Payment Term information
RA_TERMS_LINES 29 Line information for Payment Terms
RA_TERMS_LINES_DISCOUNTS 30 Discount information for Payment Terms
RA_TERMS_TL 11 Multi-lingual support (MLS) for Payment Terms
RA_TERRITORIES 49 Territory information