Search Results ar invoice amount

DeepseekTRM - AR Tables and Views in Oracle EBS 12.1.1/12.2.2

Oracle E-Business Suite (EBS) Receivables (AR) module relies on a comprehensive set of tables and views to manage customer transactions, invoices, receipts, and accounting entries. DeepseekTRM provides technical reference documentation for these critical database objects in Oracle EBS 12.1.1 and 12.2.2. Below is a detailed overview of key AR tables and views:

Core AR Tables

RA_CUSTOMERS - Master table storing customer information including name, address, and contact details.
RA_CUST_TRX_TYPES - Defines transaction types for invoices, debit memos, and credit memos.
RA_CUST_TRX_LINE_GL_DIST - Contains accounting distributions for transaction lines.
AR_CASH_RECEIPTS - Stores receipt header information including receipt number and amount.
AR_CASH_RECEIPT_HISTORY - Tracks the status history of cash receipts.
AR_PAYMENT_SCHEDULES - Maintains payment schedule information for customer transactions.
AR_ADJUSTMENTS - Records adjustments made to customer accounts.
AR_DISTRIBUTIONS - Contains accounting entries for AR transactions.

Important AR Views

AR_VAT_TAX_ALL - Provides tax information for transactions.
AR_TRANSACTION_HISTORY_V - Shows transaction history with status changes.
AR_PAYMENT_SCHEDULES_V - Combines payment schedule data with related transaction information.
AR_CASH_RECEIPTS_V - Presents receipt information with related application details.
AR_CUSTOMER_BALANCES_V - Displays current customer account balances.

Technical Architecture

The AR module follows Oracle's application table architecture with:

Header tables (e.g., RA_CUSTOMERS) storing master data
Line tables (e.g., RA_CUSTOMER_TRX_LINES) containing transaction details
Distribution tables (e.g., RA_CUST_TRX_LINE_GL_DIST) handling accounting entries
Interface tables (e.g., RA_INTERFACE_LINES_ALL) for data import/export
Temporary tables for batch processing

Integration Points

AR tables integrate with other EBS modules through:

GL_INTERFACE for general ledger postings
AP_INVOICES for supplier invoices
OE_ORDER_HEADERS for order management
XLA_AE_LINES for Subledger Accounting

Key Technical Considerations

Multi-org architecture implemented through ORG_ID column
Set of Books (SOB) information stored in GL tables
Flexfield columns for customizable data elements
Audit columns (CREATED_BY, CREATION_DATE, etc.) for tracking changes
Status columns controlling workflow (e.g., STATUS in AR_PAYMENT_SCHEDULES)

DeepseekTRM documentation provides complete data dictionaries including column definitions, indexes, constraints, and relationships between these tables and views. This technical reference is essential for custom reporting, data extraction, and system integrations in Oracle EBS AR implementations.

File: R11510 AR POSTING.pdf 12.1.1
product: AR - Receivables , size: 59.81 KBytes , file_type: PDF Diagram ,
eTRM - AR External Dependencies 12.2.2
Lookup Type: AMOUNT MASK 12.1.1
product: AP - Payables , meaning: Amount Mask , description: Amount Mask ,
eTRM - AR External Dependencies 12.1.1
File: R11510 AR POSTING.pdf 12.2.2
product: AR - Receivables , size: 59.81 KBytes , file_type: PDF Diagram ,
Lookup Type: BUDGET AMOUNT 12.1.1
product: PA - Projects , meaning: Budget Amount , description: Budget Amount ,
Lookup Type: BUDGET AMOUNT 12.2.2
product: PA - Projects , meaning: Budget Amount , description: Budget Amount ,
Lookup Type: PROJECT AMOUNT OPTION 12.1.1
product: PA - Projects , meaning: Project Amount Option , description: Project Amount Option ,
Lookup Type: AMOUNT MASK 12.2.2
product: AP - Payables , meaning: Amount Mask , description: Amount Mask ,
eTRM - AR Tables and Views 12.2.2
description: Territory information ,
Lookup Type: AMOUNT BASIS OPTIONS 12.1.1
product: AP - Payables , meaning: Amount Basis Options , description: Amount basis options for Withholding tax amount ranges ,
Lookup Type: INVOICE ADJUSTMENTS 12.2.2
product: AP - Payables , meaning: Invoice Adjustments , description: Invoice Adjustment special adjustment zones ,
Lookup Type: INVOICE DETAIL 12.2.2
product: PA - Projects , meaning: Invoice Detail , description: Invoice Detail ,
File: AR Integration R12.pdf 12.1.1
product: ZX - E-Business Tax , size: 15.622 KBytes , file_type: PDF Diagram ,
File: AR Integration R12.pdf 12.2.2
product: ZX - E-Business Tax , size: 15.622 KBytes , file_type: PDF Diagram ,
eTRM - AR Tables and Views 12.2.2
description: Territory information ,
Lookup Type: BUDGET AMOUNT TYPES 12.1.1
product: PA - Projects , meaning: Project Intelligence Budget Amount Types , description: Project Intelligence Budget Amount Types ,
Lookup Type: BUDGET AMOUNT TYPES 12.2.2
product: PJI - Project Intelligence(Obsolete) , meaning: Project Intelligence Budget Amount Types , description: Project Intelligence Budget Amount Types ,
eTRM - AR Tables and Views 12.1.1
description: Territory information ,
eTRM - AR Tables and Views 12.1.1
description: Territory information ,
Lookup Type: INVOICE ACTION 12.1.1
product: PA - Projects , meaning: Invoice Action , description: Invoice Action ,
Lookup Type: INVOICE CATEGORY 12.1.1
product: PA - Projects , meaning: Invoice Category , description: Invoice Category ,
Lookup Type: INVOICE METHOD 12.1.1
product: PA - Projects , meaning: Invoice Method , description: Invoice Method ,
Lookup Type: INVOICE TYPE 12.1.1
product: IGI - Public Sector Financials International , meaning: Invoice Type , description: Invoice Type ,
Lookup Type: INVOICE DETAIL 12.2.2
product: AP - Payables , meaning: Invoice Detail , description: Invoice Detail ,
File: PA Invoice Formats.pdf 12.2.2
product: PA - Projects , size: 15.293 KBytes , file_type: PDF Diagram ,
Lookup Type: INVOICE TYPE 12.2.2
product: IGI - Public Sector Financials International , meaning: Invoice Type , description: Invoice Type ,
Lookup Type: INVOICE CLOSE 12.1.1
product: PO - Purchasing , meaning: Close PO for Invoicing option , description: Close PO for Invoicing option ,
Lookup Type: INVOICE ADJUSTMENTS 12.1.1
product: AP - Payables , meaning: Invoice Adjustments , description: Invoice Adjustment special adjustment zones ,
Lookup Type: INVOICE ZONES 12.1.1
product: AP - Payables , meaning: Invoice Zones , description: Invoice Entry special information zones ,
Lookup Type: INVOICE ACTION 12.2.2
product: PA - Projects , meaning: Invoice Action , description: Invoice Action ,
Lookup Type: INVOICE METHOD 12.2.2
product: PA - Projects , meaning: Invoice Method , description: Invoice Method ,
Lookup Type: BUDGET AMOUNT TYPES 12.1.1
product: PJI - Project Intelligence , meaning: Project Intelligence Budget Amount Types , description: Project Intelligence Budget Amount Types ,
Lookup Type: BUDGET AMOUNT TYPES 12.2.2
product: PA - Projects , meaning: Project Intelligence Budget Amount Types , description: Project Intelligence Budget Amount Types ,
Lookup Type: PROJECT AMOUNT OPTION 12.2.2
product: PA - Projects , meaning: Project Amount Option , description: Project Amount Option ,
Lookup Type: AMOUNT BASIS OPTIONS 12.2.2
product: AP - Payables , meaning: Amount Basis Options , description: Amount basis options for Withholding tax amount ranges ,
TABLE: PJI.PJI_FM_AGGR_ACT4 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_ACT4, object_name:PJI_FM_AGGR_ACT4, status:VALID,
Lookup Type: INVOICE DETAIL 12.1.1
product: AP - Payables , meaning: Invoice Detail , description: Invoice Detail ,
Lookup Type: INVOICE TYPE 12.1.1
product: AP - Payables , meaning: Invoice Type , description: Invoice Type ,
Lookup Type: INVOICE STATUS 12.1.1
product: PA - Projects , meaning: Invoice Status , description: Invoice Status ,
File: PA Invoice Formats.pdf 12.1.1
product: PA - Projects , size: 15.293 KBytes , file_type: PDF Diagram ,
Lookup Type: INVOICE STATUS 12.2.2
product: AP - Payables , meaning: Invoice Status , description: Invoice Status ,
Lookup Type: INVOICE MORE 12.2.2
product: AP - Payables , meaning: Invoice More , description: More options for invoice zone of invoice entry ,
TABLE: PJI.PJI_FM_AGGR_ACT4 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_ACT4, object_name:PJI_FM_AGGR_ACT4, status:VALID,
TABLE: PJI.PJI_FM_AGGR_ACT1 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_ACT1, object_name:PJI_FM_AGGR_ACT1, status:VALID,
TABLE: PJI.PJI_FM_AGGR_ACT1 12.1.1
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_AGGR_ACT1, object_name:PJI_FM_AGGR_ACT1, status:VALID,
TABLE: PJI.PJI_FM_DNGL_ACT 12.2.2
owner:PJI, object_type:TABLE, fnd_design_data:PJI.PJI_FM_DNGL_ACT, object_name:PJI_FM_DNGL_ACT, status:VALID,
Lookup Type: INVOICE STATUS 12.1.1
product: AP - Payables , meaning: Invoice Status , description: Invoice Status ,
Lookup Type: INVOICE MORE 12.1.1
product: AP - Payables , meaning: Invoice More , description: More options for invoice zone of invoice entry ,
Lookup Type: INVOICE DETAIL 12.1.1
product: PA - Projects , meaning: Invoice Detail , description: Invoice Detail ,