Oracle Apps Functional All About Oracle Apps functional & Technical FAQs, Tutorials

9Apr/150

Account Receivables Tables list oracle r12.2

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
Filed under: Receivables No Comments
2Apr/150

General Ledger tables

These are the general ledger module tables and the purpose they are used for

GL_ACCESS_SETS Data access set definitions
GL_ACCESS_SET_ASSIGNMENTS Flattened data access set privilege assignments
GL_ACCESS_SET_NORM_ASSIGN Data access set privilege assignments
GL_ACCOUNT_HIERARCHIES Summary/Detail account hierarchies
GL_ALLOC_BATCHES MassAllocations and MassBudget batches
GL_ALLOC_HISTORY History of MassAllocation and MassBudget runs
GL_ALLOC_INTERIM_1 Temporary table for MassAllocations and MassBudgets
GL_ALLOC_TARGETS Temporary table for MassAllocations and MassBudgets
GL_APPLICATION_GROUPS Application product groups that use Oracle General Ledger accounting periods
GL_ARCHIVE_DAILY_BALANCES Archive daily aggregate balances
GL_ARCHIVE_HEADERS Archive journal headers
GL_ALLOC_INTERIM_2 Temporary table for MassAllocations and MassBudgets
GL_ALLOC_FORMULAS MassAllocations and MassBudget formulas
GL_ALLOC_INTERIM_3 Temporary table for MassAllocations and MassBudgets
GL_ALLOC_FORMULA_LINES MassAllocations and MassBudget formula lines
GL_ARCHIVE_BATCHES Archive journal batches
GL_ARCHIVE_BALANCES Archive account balances
GL_ARCHIVE_LINES Archive journal entry lines
GL_ARCHIVE_HISTORY History of the archive and purges of journals and balances
GL_AUTOMATIC_POSTING_OPTIONS Individual automatic posting criteria
GL_AUTOMATIC_POSTING_SETS Sets of automatic posting criteria
GL_ARCHIVE_REFERENCES Archive table for GL_IMPORT_REFERENCES
GL_AUTHORIZATION_LIMITS Journal approval authorization limits for employees
GL_AUTO_ALLOC_BATCHES Assignments of MassAllocation, Mass Budgets, Mass Encumbrances, Recurring Journals or Projects batches to an allocation set
GL_AUTO_ALLOC_BATCH_HISTORY History of all batches included in an allocation set run
GL_AUTOREV_CRITERIA_SETS Journal reversal criteria sets
GL_AUTOREVERSE_OPTIONS Reversal criteria for generating automatic journal reversals
GL_AUTO_ALLOC_BAT_HIST_DET Status of concurrent program submitted for each step in the allocation set
GL_AUTO_ALLOC_SETS Autoallocation set definition for step-down or parallel allocations
GL_AUTO_ALLOC_SET_HISTORY History of allocation set runs
GL_AUTO_ALLOC_REV_BATCHES Reverse journal batches generated by AutoAllocation rollback process
GL_BC_DUAL2 Budgetary control concurrency table
GL_BC_EVENT_TIMESTAMPS Budgetary control events (Summary Templates and Budget Assignment Ranges)
GL_BALANCES Account balances for both detail and summary accounts
GL_BALANCES_DELTA Incremental changes to account balances
GL_BALANCES_DELTA_INTERIM Interim tracking of incremental account balances
GL_BC_DUAL Budgetary control concurrency table
GL_BC_OPTIONS Budgetary control options
GL_BC_OPTION_DETAILS Budgetary control option details
GL_BC_PACKETS Budgetary control queue table
GL_BC_PACKETS_HISTS GL_BC_PACKETS_HISTS is Oracle General Ledger's history table for the Budgetary Control feature. This table stores the budgetary control packets that are deleted from table GL_BC_PACKETS.
GL_BUDGETS Budget definitions
GL_BUDGET_ASSIGNMENTS Budget organization accounts
GL_BC_PACKET_ARRIVAL_ORDER Budgetary control packet processing sequence
GL_BUDGET_ENTITIES Budget organization definitions
GL_BC_PERIOD_MAP Budgetary control period boundaries
GL_BUDGET_FROZEN_RANGES Frozen account ranges for a budget or budget organization
GL_BUDGET_INTERFACE Upload budget data from external sources
GL_BUDGET_ASSIGNMENT_RANGES Budget organization account ranges
GL_BUDGET_BATCHES Budget formula batches
GL_BUDGET_INTERIM Budget posting interim balances
GL_BUDGET_TYPES Budget type definitions
GL_BUDGET_PERIOD_RANGES Status of budget period ranges (open/not open)
GL_CARRYFORWARD_RANGES Ranges of encumbrance accounts to carry across fiscal years
GL_BUDGET_RANGE_INTERIM Interim table to hold budget balances entered in the Enter Budget Amounts and Enter Budget Journals forms
GL_CONCURRENCY_CONTROL Concurrent process internal locking mechanism
GL_BUDGET_VERSIONS Budget version definitions
GL_CONCURRENT_SCHEDULES Oracle General Ledger concurrent schedule definitions
GL_COA_MAPPINGS Chart of accounts mapping definitions
GL_CONSOLIDATION_SETS Consolidation sets
GL_CONS_BATCHES Transaction method consolidation batches
GL_CONSOLIDATION Consolidation definitions
GL_CONSOLIDATION_ACCOUNTS Account ranges for consolidating balances
GL_CONSOLIDATION_AUDIT Audit data for consolidation run
GL_CONS_SEGMENT_MAP Consolidation segment rules
GL_CONS_SET_ASSIGNMENTS Assignments of consolidations to consolidation sets
GL_CONSOLIDATION_HISTORY History of consolidation runs
GL_CONS_FLEXFIELD_MAP Consolidation account rules
GL_CONS_FLEX_HIERARCHIES Consolidation subsidiary segment hierarchies
GL_DAILY_BALANCES Daily aggregate balances for both detail and summary accounts
GL_DAILY_CONVERSION_RATES Foreign currency daily exchange rates
GL_CROSS_RATE_RULES Cross Rate Rules
GL_DAILY_RATES_INTERFACE Import daily conversion rates
GL_DATE_PERIOD_MAP Date to period mappings
GL_CROSS_RATE_RULE_DTLS Cross Rate Rule Details
GL_DEFAS_ACCESS_SETS Definition access set definitions
GL_DEFAS_ASSIGNMENTS Definition access set privilege assignments
GL_DAILY_RATES Daily conversion rates for foreign currency transactions
GL_CODE_COMBINATIONS Account combinations
GL_DAILY_CONVERSION_TYPES Foreign currency daily conversion rate types
GL_DEFAS_RESP_ASSIGN Assignment of definition access sets to responsibilities
GL_EFC_BUDGET_MAPPING Budget and budget organization mappings for Euro as Functional Currency process
GL_EFC_CHANGED_TRX Transactions that need to be reprocessed by the Euro as Functional Currency process
GL_DOC_SEQUENCE_AUDIT Sequential numbering audit table
GL_DYNAMIC_SUMM_COMBINATIONS Newly created summary account combinations
GL_EFC_DISABLED_TRIGGERS Triggers disabled by the Euro as Functional Currency process
GL_EFC_RUN_HISTORY Euro as Functional Currency process history
GL_ELIMINATION_HISTORY Intercompany elimination history
GL_ELIMINATION_JOURNALS Intercompany elimination journals
GL_ELIM_ACCOUNTS_MAP Intercompany elimination account mappings
GL_ENTITY_BUDGETS Freeze budget organizations for particular budgets
GL_FIXED_CONV_RATES Fixed conversion rates for changes in national currency
GL_ELIMINATION_SETS Intercompany elimination set definitions
GL_ELIM_BAL_OPTIONS Intercompany elimination balancing options.
GL_HISTORICAL_RATE_RANGES Historical translation rates account ranges
GL_ENCUMBRANCE_TYPES Encumbrance type definitions
GL_EXTRACT_HISTORY Successful full or incremental extract requests information from the GL_BALANCES_DELTA table generated from programs like Analyzer-Extract Incremental Balances
GL_IEA_AUTOGEN_MAP Automatic account generation mapping rules for the Global Intercompany System
GL_HISTORICAL_RATES Foreign currency translation rates for historical accounts
GL_IEA_CLEARING_ACCOUNTS Clearing accounts
GL_IEA_INTERFACE Transactional data for import into Global Intercompany System
GL_IEA_RECUR_HISTORY History of recurring intercompany batch runs
GL_IEA_SEGMENT_RULE_MAP Automatic account generation individual segment mapping rules for the Global Intercompany System
GL_IEA_SEGMENT_MAP Automatic account generation segment mapping rules for the Global Intercompany System
GL_IEA_IMPORT_REGISTRY Global Intercompany System import execution control
GL_IEA_SUBSIDIARIES Subsidiary definitions
GL_IEA_RECUR_BATCHES Recurring intercompany batches
GL_IEA_RECUR_LINES Recurring intercompany transaction lines
GL_IEA_RECUR_TRANSACTIONS Recurring intercompany transactions
GL_IEA_TRANSACTIONS Intercompany transactions
GL_IEA_TRANSACTION_LINES Intercompany transaction lines
GL_IMPORT_REFERENCES Cross-references between subledgers and Oracle General Ledger's journal entries
GL_IMP_COA_ERR_INTERFACE Error message interface table for the Chart of Account Segment Values Import process.
GL_IMP_COA_SEG_VAL_INTERFACE Import of Chart of Accounts Segment Values
GL_INTERCOMPANY_ACCOUNTS Assignments of intercompany due to and due from accounts to a source, category, and balancing segment value.
GL_IEA_TRANSACTION_TYPES Intercompany transaction types
GL_INTERFACE_CONTROL Journal import execution control
GL_IMP_COA_NORM_HIER_INTERFACE Interface table to capture data for the import Child Ranges for Parent Chart of Account Segment Values.
GL_ISPEED_COA_SEGMENTS Chart of Accounts segments information.
GL_INTERCOMPANY_ACC_SETS Intercompany transaction processing rules
GL_ISPEED_COA_TEMPLATES Chart of Accounts template definition.
GL_INTERFACE Import journal entry batches
GL_INTERFACE_HISTORY Imported journal entry batches
GL_JE_INCLUSION_RULES Journal Inclusion rule
GL_JE_SEGMENT_VALUES Journal entry balancing and management segment values.
GL_JE_SOURCES_TL Journal entry sources
GL_JE_CATEGORIES_TL Journal entry categories
GL_JE_HEADERS Journal entry headers
GL_JE_LINES Journal entry lines
GL_JE_BATCHES Journal entry batches
GL_JOURNAL_REPORTS_ITF Interface table for RXi Oracle General Ledger journal reports.
GL_LEDGERS Ledger definition
GL_LEDGER_CONFIG_DETAILS Primary ledgers and their associated secondary ledgers, legal entities, reporting currencies and setup.
GL_LEDGER_NORM_SEG_VALS Valid balancing segment values for ledger
GL_LEDGER_SETS Ledger set definition
GL_LEDGER_CONFIGURATIONS Primary ledgers
GL_LEDGER_SET_NORM_ASSIGN Ledger set assignments
GL_LEDGER_RELATIONSHIPS Relationships between ledgers
GL_LEDGER_SEGMENT_VALUES Flattened valid balancing segment values for ledger
GL_LEDGER_SET_ASSIGNMENTS Flattened ledger set assignments
GL_LEDGER_SET_REQUESTS Ledger set child request status.
GL_LEGAL_ENTITIES_BSVS Legal entity balancing segment value assignments.
GL_LOOKUPS_OLD General Ledger lookups
GL_LE_VALUE_SETS Legal entity value set assignments.
GL_MC_BOOK_ASSIGNMENTS Assignments of reporting sets of books to primary sets of books
GL_MC_CONVERSION_RULES Multiple reporting currency conversion rules for Oracle General Ledger
GL_MC_BOOK_ASSIGNMENTS_11I Assignments of reporting sets of books to primary sets of books
GL_MC_UPGRADE_RATES Exchange rates used for the multiple reporting currency upgrade programs
GL_MC_UPGRADE_HISTORY History of upgrade for each application and reporting set of books
GL_MC_REPORTING_OPTIONS_11I Multiple reporting currency conversion options by application/operating unit/asset book
GL_MGT_SEG_UPGRADE Management segment upgrade unprocessed journal batches.
GL_MC_CONVERSION_RULES_11I Multiple reporting currency conversion rules for Oracle General Ledger
GL_MC_REPORTING_OPTIONS Multiple reporting currency conversion options by application
GL_MGT_SEG_UPGRADE_H History of management segment upgrade.
GL_MOVEMERGE_ACCOUNTS Mass maintenance request account mappings
GL_NET_INCOME_ACCOUNTS Net income accounts
GL_OASIS_FIN_ASSIGNMENTS Natural account value mappings for financial items
GL_OASIS_FIN_ASSIGNMENTS_11I Natural account value mappings for financial items
GL_OASIS_FIN_ITEMS Financial items
GL_OASIS_FIN_ITEMS_11I Financial items
GL_OASIS_FIN_METRICS The new table stores the summarized financial metrics.
GL_OASIS_FIN_METRICS_11I Summarized financial metrics
GL_MOVEMERGE_REQUESTS Mass maintenance request definitions
GL_OASIS_SUMMARY_DATA Summarized financial data needed for Business Intelligence System reports
GL_PERIODS Calendar period definitions
GL_PERIOD_SETS Calendar definitions
GL_PERIOD_STATUSES Calendar period statuses
GL_PERIOD_TYPES Calendar period types
GL_POSTING_INTERIM Posting interim balances
GL_RECURRING_BATCHES Recurring journal entry and budget formula batches
GL_RECURRING_HEADERS Recurring journal entry and budget formula headers
GL_REVALUATION Revaluation default gain/loss account
GL_RECURRING_LINES Recurring journal entry and recurring budget formula target lines
GL_RECURRING_LINE_CALC_RULES Recurring journal entry and budget formula lines
GL_REVALUATIONS Revaluation definitions
GL_REVALUATION_ACCOUNTS Revaluation account ranges
GL_ROLLUP_GROUP_SCORES Rollup group usages
GL_ROW_MULTIPLIERS Constant row multipliers
GL_RX_TRIAL_BALANCE_ITF Interface table for country-specific trial balance reports
GL_SEGMENT_FREQUENCIES Segment value and period usages
GL_SEGVAL_INHERIT_HISTORY Segment value inheritance history
GL_REVAL_ACCOUNT_RANGES Revaluation account ranges
GL_SHARES_ACTIVITY Stock split or dividend
GL_SHARES_OUTSTANDING Number of shares outstanding
GL_STAT_ACCOUNT_UOM Statistical units of measure
GL_STORAGE_PARAMETERS Interim table storage parameters
GL_SETS_OF_BOOKS Set of books definitions
GL_SUMMARY_HIERARCHY_INT Interim segment value hierarchy changes for Incremental Add/Delete Summary Templates
GL_SUMMARY_INTERIM Temporary table for Summarization
GL_SETS_OF_BOOKS_11I Set of books definitions
GL_SUMMARY_HIERARCHIES Child segment value ranges for summary templates
GL_SYSTEM_SETUP System setup information
GL_SUMMARY_TEMPLATES Summary account templates
GL_SYSTEM_SETUP_11I System setup information
GL_SYSTEM_USAGES System feature usage
GL_SUSPENSE_ACCOUNTS Additional suspense accounts for source/category combinations
GL_TAX_OPTIONS Setup tax options
GL_TAX_OPTION_ACCOUNTS Setup tax options for natural account values
GL_TEMPORARY_COMBINATIONS Newly created account combinations
GL_TRACK_DELTA_BALANCES GL_TRACK_DELTA_BALANCES stores information about requests to track incremental balances using the GL_BALANCES_DELTA table.
GL_TRANSACTION_DATES Business vs. non-business days for transaction calendars
GL_TRANSACTION_CALENDAR Transaction calendar definitions
GL_TRANSACTION_RATE_EXCEPTIONS No longer used
GL_UPDATE_RECOVERY_H Updated columns history for update recovery
GL_TRANSLATION_RATES Foreign currency translation rates
GL_TRANSLATION_INTERIM Foreign currency translated interim balances
GL_TRANSLATION_RATES_11I Foreign currency translation rates
GL_TRANSLATION_STATUSES Foreign currency translation status of periods
GL_TRANSLATION_TRACKING Foreign currency translation history
GL_USSGL_ACCOUNT_PAIRS USSGL account pairings
GL_USSGL_TRANSACTION_CODES USSGL transaction codes
GL_XFR_CALENDAR_MAPPINGS This table is used to store calendar mappings between EBS and Fusion ledger.
GL_XFR_CCID_MAPPINGS This table contains the account mappings for each period for a ledger mapping.
GL_XFR_INTERFACE This table is a custom version of the gl_interface table for use by the balance transfer.
GL_WEIGHTED_AVG_DETAILS No longer used
GL_XFR_LEDGER_BSV_MAPS Stores specific Balancing segment values of a Fusion Ledger that can be used for booking balances by the external instances.
GL_XFR_LED_MAP_PERIODS This table contains the transfer information for each period that has been transferred for a ledger mapping.
GL_XFR_PERIOD_MAPPINGS Uses Calendar Mapping Id and stores mapping between EBS periods to Fusion Periods.
GL_XFR_LEDGER_MAPPINGS This table is used to store ledger mappings between EBS and Fusion ledger.
GL_XFR_SOURCE_SYSTEMS Stores the list of External Instances with URL info that will be used to drill down from Fusion GL balances to the external instance
GL_XFR_SYSTEM_LEDGERS Stores the list of Fusion Ledgers with their corresponding BSV assignment type.
GL_XFR_TRACKING This table contains the tracking information that Golden Gate will use to launch Journal Import.
Filed under: General Ledger No Comments

Recent Posts

Recent Comments

Archives

Categories