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
26Oct/130

How is Receiving supported across multiple operating units in Release 12?

When the Receipts form is opened, the list of values (LOV) will be displayed of the inventory organizations which are available to the user through the security profile. Receiving forms unlike other  transaction entry forms in Oracle Purchasing, does not make it mandatory for the user to choose an  operating unit even after selecting the inventory organization to receive the shipment. User will still be allowed to change to an operating unit which may not necessarily include the inventory organization chosen initially. For eg. if M1 is an inventory organization which is not included in an operating unit 'Vision Communications (USA)', and if M1 is chosen initially as the receiving inventory organization, user is still allowed to select the operating unit context as Vision Communications (USA). This is an intended feature in Release 12.

Filed under: Receivables No Comments
25Oct/130

How to identify Receipts on Bank Account Number in Lockbox Process?

A Magnetic Ink Character Recognition (MICR)

An MICR number consists of two segments.

1. The first segment is the Transit Routing Number.

The transit routing number should be filled in the field Bank Branch Number of the Banks window (NAV Setup/Receipts/Banks). When this number is not available in Applications, a Bank Branch will automatically be generated by the Lockbox process.

2. The second segment identifies the Bank Account of the customer.

A Customer Bank should be defined in Bank Accounts window
Responsibility:  Receivables Manager
Navigation:  Setup > /Receipts > Banks - Customer Bank

Also make sure this Bank Account is defined with the Customer on Customer level
Responsibility: Receivables Manager
Navigation: Customers > Customers

The MICR number is used to identify the Customer.
The MICR numbers used are shown on the Lockbox Execution Report.
The ACCOUNT (customer bank account number) and the TRANSIT_ROUTING_NUMBER (bank branch number) should be available in the lockbox interface table AR_PAYMENTS_INTERFACE_ALL in order to get identified receipts.

Remark that when the receipt batch is queried after validation, and when the application type is changed from Unidentified to On Account and a Customer is added, the system will automatically add the customer bank to the Bank Accounts window and the Customer window.

Filed under: Receivables No Comments

Recent Posts

Recent Comments

Archives

Categories