oracle-apps-account-receivable-tables

Oracle Apps Account Receivable tables

AR Table	Description
HZ_SRCH_CPTS	This table stores the transformed data for the contact points in the interface tables.
HZ_SRCH_CONTACTS	This table stores the transformed data for the contacts in the interface tables.
HZ_SRCH_PSITES	This table stores the transformed data for the addresses in the interface tables.
HZ_SRCH_PARTIES	This table stores the transformed data for the parties in the interface tables.
HZ_STAGED_PARTY_SITES	Party Site information that is staged for DQM.
HZ_STAGED_PARTIES	Party information that is staged for DQM.
HZ_STAGED_CONTACT_POINTS	Contact point information that is staged for DQM.
HZ_STAGED_CONTACTS	Contact information that is staged for DQM.
AR_TAX_EXTRACT_DCL_ITF	Reporting and legal entities selected by the Tax Reporting Ledger Tax Extract program
AR_STATEMENT_HEADERS	Interim table of statement header information
AR_LOCATION_COMBINATIONS	Defines each distinct tax authority
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_EXTRACT_SUB_ITF	Tax Extract interface table
HZ_IMP_BATCH_SUMMARY	The HZ_IMP_BATCH_SUMMARY table stores information about import batches
MTL_SYSTEM_ITEMS_B	Inventory item definitions
HZ_CUSTOMER_MERGE_LOG	This table is used to record account merge audit history
PSB_DATA_EXTRACTS	Data extract definitions. All position related data are partitioned by data extract.
OE_HEADERS_IFACE_ALL	This is a multi-org table for sales order headers open interface.
PN_PAYMENT_TERMS_ALL	Payment and billing terms defined in a lease
AR_DISTRIBUTIONS_ALL	Accounting records for receipts
IGS_FI_CONTROL_ALL	This table stores a flag to indicate if Oracle Accounts Receivables is installed or not.
IGS_DA_REQ_BATCH	Storage for Degree Audits on criteria for students in the request.
OE_LINES_IFACE_ALL	This is a multi-org table for sales order lines open interface.
OE_HEADER_ACKS	This tables stores information about the acknowledgements for Order Headers.
OP_ORDR_DTL	Order detail (order lines).
OKC_K_ARTICLES_BH	History table for OKC_K_ARTICLES_B.
OKC_K_ARTICLES_B	OKC_K_ARTICLES holds the use of standard and non-standard ("custom", one-time use) clauses in business documents. When associated with a document header, the clause governs the entire document. When associated with a line, the article govern
MTL_SYSTEM_ITEMS_INTERFACE	Inventory Items Open Interface table
PN_TERM_TEMPLATES_ALL	PN_TERM_TEMPLATES_ALL stores the payment/billing term details defaults.
AR_SYSTEM_PARAMETERS_ALL	Oracle Receivables system options
AR_STATEMENT_LINE_CLUSTERS	Interim table of transaction lines that appear on a statement
AR_CMGT_CREDIT_REQUESTS	The AR_CMGT_CREDIT_REQUESTS table stores information for each credit request.
AR_CONS_INV_ALL	Information about a consolidated billing invoice
MTL_MFG_PART_NUMBERS	Define manufacturer part numbers
PQP_ASSIGNMENT_ATTRIBUTES_F	Table to hold attribution required at assignment level for public sector payroll
JL_BR_AR_OCCURRENCE_DOCS_ALL	Occurrences for collection documents
AHM_APPS_CONFIGURATIONS	This table hold all Oracle Applications tables. TABLE_ID maps to FND_TABLES. TABLE_CATEGORY holds whether the table is Global, Local SEED or Local Transactional
MSC_ITEM_SUBSTITUTES	This table stores all the Relationships between Item Substitutes for planning.
JTF_RS_SALESREPS	This table stores information about salesreps. Salesrep_id is the primary key. If resource category is 'OTHERS' then salesrep_number and org_id are unique.
IBY_INSTRHOLDER	IBY_INSTRHOLDER stores the information about the holder of the instrument. A payment instrument can be held by different users or payees or payers.
OE_PAYMENTS_IFACE_ALL	This table is used to store Payments data to be imported into OE_PAYMENTS table. This table will be used by Order Import Program.
OE_TRANSACTION_TYPES_ALL	This table stores information about the order and line transaction types
OKL_CURE_PAYMENT_LINES	Stores line level information for OKL CURE PAYMENTS
OKL_XTL_CSH_APPS_B	Receipt application specifying amount applied to Receivables invoices
OKL_TXL_ADJSTS_LNS_B	Application of OKL write offs to AR invoices
PA_IMPLEMENTATIONS_ALL	Information about the configuration of an Oracle Projects installation
HZ_INT_DUP_RESULTS	The HZ_INT_DUP_RESULTS table temporarily stores duplicate identification data during the duplicate identification of interface tables.
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.
HR_DM_TABLES	This entity contains a HRMS table listing that will be processed by the data migrator.
AR_CHANGE_MATRIX	This table is no longer used.
AR_RECEIPT_METHOD_ACCOUNTS_ALL	Account information for accounts used by payment methods
AR_ADJUSTMENTS_ALL	Pending and approved invoice adjustments
AR_TAX_INTERFACE	Sales tax rates import table
CE_UPG_BANK_ACCOUNTS	This table stores new CE bank account information for bank upgrade purpose
CE_UPGA_BANK_ACCOUNTS	This table is an audit table of CE_UPG_BANK_ACCOUNTS
CE_BANK_ACCOUNTS	This table contains bank account information. Each bank account must be affiliated with one bank branch.
CE_FORECAST_ROWS	Forecast template rows - forecast sources
CE_STATEMENT_LINES_INTERFACE	Open interface for bank statement lines
CE_SYSTEM_PARAMETERS_ALL	System options
HZ_ORIG_SYS_MAPPING	The HZ_ORIG_SYS_MAPPING table stores the mapping among source systems and owner table names.
AR_PAYMENTS_INTERFACE_ALL	Imported Lockbox information that was not validated
AR_TAX_GROUP_CODES_ALL	Tax codes within a tax group
JL_BR_AR_SELECT_CONTROLS_ALL	Selection Criteria for invoices sent to Bank transfer batches
JL_BR_AR_BANK_OCCURRENCES	Bank Occurrence codes
CZ_XFR_FIELDS	Import rules specifications, field level
WSH_DEL_LEGS_INTERFACE	Delivery Legs Interface Table
OE_PAYMENTS_HISTORY	Table to store payment audit trail.
OE_ORDER_HEADERS_ALL	OE_ORDER_HEADERS_ALL stores header information for orders in Order Management.
GML_GASNO_DETAILS	Contains detail line data of the order that the shipment generated from.
GMA_AUDIT_DISP_COLS	This table is to store Display columns for Shown on Audit Query Navigator
OKL_XTL_SELL_INVS_B	The transaction table for "bill" type transactions, where cash receipts are expected
OKL_TXL_RCPT_APPS_B	Apply cash to various OKL objects
PA_COST_DISTRIBUTION_LINES_ALL	Information about expenditure item cost distribution
FND_ID_FLEXS	Registration information about key Flexfields
AX_SLE_LINES	Journal entry lines information
HR_DM_HIERARCHIES	This entity will contain the relationships between tables. The following relationship will be recorded:
QRM_ANA_ATTS_LOOKUPS	Deal attributes properties to control Risk Analysis behavior.
FA_RX_REPORTS Stores	Report exchange report definitions
IGI_AR_CASH_BASIS_DISTS_ALL	Distribution information for combined basis accounting
AX_SLE_LINES_ARCH	Accounting rows purged from the AX_SLE_LINES table
CE_ARCH_INTERFACE_LINES	Archived CE_STATEMENT_LINES_INTERFACE records
CE_ARCH_LINES	Archived CE_STATEMENT_LINES records
CE_STATEMENT_LINES	Bank statement lines
PN_PAYMENT_ITEMS_ALL	Payment and billing items associated with a payment or a billing schedule
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
AR_CCID_CORRECTIONS_ALL	Individual GL distribution lines that contain invalid code combinations (GL accounts)
AR_BPA_DATA_SOURCES_B	The AR_BPA_DATA_SOURCES_B table stores all the data sources that Bill Presentment Architecture can access.
AR_BPA_URL_PARAMS	The AR_BPA_URL_PARAMS table stores all parameters for the URLs defined in Bill Presentment Architecture.
AR_BPA_RULE_TEMPLATES	The AR_BPA_RULE_TEMPLATES table stores all assignment templates for assignment rules defined in Bill Presentment Architecture.
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_AREA_ITEMS	The AR_BPA_AREA_ITEMS table stores the selected content items for each template defined in Bill Presentment Architecture.
AR_CMGT_FINANCIAL_DATA	The AR_CMGT_FINANCIAL_DATA table stores financial statements information about the company under credit review.
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_BPA_TEMPLATES_B	Release 11i:Used by Bill Presentment Architecture
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_MC_DISTRIBUTIONS_ALL	Currency-related information about distributions generated by the different steps in the life cycle of a cash receipt
RA_SITE_USES_ALL	Business purpose of a customer address
RA_CUSTOMER_TRX_LINES_ALL	Invoice, debit memo, chargeback, credit memo and commitment lines
RA_CUSTOMERS	Customer information
AR_SALES_TAX	Sales tax information for each tax authority defined in Oracle Receivables
AR_LOCATION_VALUES	Defines the location and description for each of the value sets used in the Sales Tax Location Flexfields
AR_CASH_BASIS_DISTS_ALL	Distribution of payments over revenue accounts, used in Cash Basis Accounting
AR_CASH_RECEIPTS_ALL	Detailed receipt information
AR_BATCHES_ALL	Receipt batch information
PSP_ENC_SUMMARY_LINES_ARCH	Stores the archived summary lines from summarized encumbrance lines
PSP_ENC_SUMMARY_LINES	Stores summary of all summarized encumbrance lines
PSB_POSITION_EVENTS_ALL	Position Event definitions
JL_BR_JOURNALS_ALL	Accounting entries successfully transferred from the sub ledgers to GL
JL_BR_AR_COLLECTION_DOCS_ALL	Collection Documents
JL_BR_AR_BORDEROS_ALL	Bank Transfer Batches
PAY_DATETRACKED_EVENTS	Stores details of events to track on HRMS Date track tables
MSC_PLANS	This table stores different plans, with their names, and settings in the Oracle Advanced Planning and Scheduling (APS) and Oracle Supply Chain Hub products.
MRP_PLANS	Settings for a specific plan name
CST_AP_VARIANCE_LINES	Stores the variance information detail for a purchase order distribution and each batch run
JTF_ACT_TYPES_ATTRS_TL	the translation table of jtf_act_types_attrs_b table.
OZF_TIME_RPT_STRUCT	This is a time structure table used for calculating period amounts and XTD amounts for the given period range. It stores time structure data to resolve given period range.
OZF_REASON_CODES_ALL_B	This table is used for storing the reasons for a claim
IBY_BANKACCT IBY_BANKACCOUNT	Stores bank account related information of the customer (payer) or payee.
OE_PAYMENTS	It holds the commitment payment information.
OE_ORDER_HEADER_HISTORY	Stores history of attribute change for Order Headers
OE_BLANKET_HEADERS_HIST	Table to capture blanket agreement header history. Primary for storing revisions.
OE_BLANKET_LINES_ALL	Table to capture blanket agreement Line details.(Attributes common between Sales Order and Blanket Agreements).
OE_BLANKET_LINES_HIST	Table to capture blanket agreement lines history.
OE_BLANKET_HEADERS_ALL	Table to capture blanket agreement header details..
OE_LINE_ACKS	This table stores information about the acknowledgements for Order Lines.
OE_ORDER_LINES_HISTORY	Stores history of attribute change for Order Lines.
OE_ORDER_LINES_ALL	OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management.
OP_ORDR_TYP_B	User-defined order types and descriptions.
SY_PURG_MST	Table storing data of all OPM Archives/Purges that have been run
SY_PURG_DEF	OPM Purge and Archive definitions are stored in this table
OKL_CURE_REFUND_LINES	Stores details at line level when refunds are made. This will hold all the cash applied against a cure invoice. The Receivables_Application_id is stored as the appl_rct_id.
OKL_TXD_AR_LN_DTLS_B	Transaction line details to be included into Receivables invoices
OKL_TXL_AR_INV_LNS_B	Transaction lines to be included into Receivables invoices
OKL_TRNS_ACC_DSTRS	Accounting distributions
IES_DEPLOYED_SCRIPTS	This table holds all deployed scripts and related information.
OKS_BTN_PR	The transaction (invoice, credit etc.) which is eventually received from AR.
OKS_BILL_TRANSACTIONS	The transaction (invoice, credit etc.) which is eventually received from AR.
OKC_SECTIONS_B	Sections are used to format clauses of a Contract while printing
OKC_SECTIONS_BH	History table for OKC_SECTIONS_B
FII_AR_TRX_DIST_F_DLOG	This is a delete log table for the Accounts Receivable Revenue Fact (FII_AR_TRX_DIST_F). When a record is updated in the Accounts Receivable Revenue Fact, the old record is moved into the DLOG table.
FII_AR_TRX_DIST_F	Accounts Receivable Revenue Fact table.
MTL_PENDING_ITEM_STATUS	History of item-status assignments
MTL_CROSS_REFERENCES	Assign cross references to items
PA_DRAFT_INVOICES_AR	Pa_Draft_Invoices_ar is a table for Archive/Purge. Refer to comments on the columns in the main table