Search Results ra_cust_trx_line_salesreps_all




Overview
Explore in AI Chat

Overview

The RA_CUST_TRX_LINE_SALESREPS_ALL table is a core transactional table within Oracle E-Business Suite Receivables (AR) module. It serves as the definitive repository for sales credit assignments, a critical component of commission calculations and sales performance analysis. This table stores the relationship between individual transaction lines and the sales representatives or sales teams credited for generating that revenue. Its role is to accurately attribute sales performance, enabling the system to calculate commissions, generate sales reports, and support territory management. The "_ALL" suffix indicates it is a multi-organization table, storing data for all operating units accessible to a responsibility, in line with Oracle's Multi-Org architecture.

Key Information Stored

The table's primary purpose is to link transaction lines, sales representatives, and their credited revenue splits. Its primary key is CUST_TRX_LINE_SALESREP_ID, a unique system-generated identifier. The table enforces a unique constraint (RA_CUST_TRX_LINE_SALESREPS_UK1) on the combination of CUSTOMER_TRX_LINE_ID and SALESREP_ID, preventing duplicate credit assignments for the same representative on a single line. Key foreign key columns define its relationships: CUSTOMER_TRX_ID and CUSTOMER_TRX_LINE_ID link to the parent transaction and its lines (RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES_ALL). The SALESREP_ID column links to the primary credited salesperson (RA_SALESREPS_ALL). Additional columns support advanced functionality, such as ORIGINAL_LINE_SALESREP_ID for tracking changes, and REVENUE_SALESGROUP_ID and NON_REVENUE_SALESGROUP_ID for crediting sales teams (JTF_RS_GROUPS_B).

Common Use Cases and Queries

This table is central to sales credit reporting and commission processing. A common use case is generating a sales performance report by joining to transaction and salesperson tables. For example, to list all sales credits for a specific transaction, one might query:

  • SELECT rct.trx_number, rctl.line_number, rs.name salesrep_name, rctls.revenue_amount_split FROM ra_cust_trx_line_salesreps_all rctls JOIN ra_customer_trx_all rct ON rct.customer_trx_id = rctls.customer_trx_id JOIN ra_customer_trx_lines_all rctl ON rctl.customer_trx_line_id = rctls.customer_trx_line_id JOIN ra_salesreps_all rs ON rs.salesrep_id = rctls.salesrep_id WHERE rct.trx_number = '<Number>';

Another critical scenario is during transaction adjustments or line cancellations, where the system must reference or update the associated sales credits to maintain accurate commission histories. Data from this table is also a primary source for the Financial Intelligence for AR (FII_AR_SALES_CREDITS) and Operational Reporting (FII_AR_SALES_CREDITS_D_T) schemas.

Related Objects

The table has extensive relationships within the AR schema. It is a child of RA_CUSTOMER_TRX_ALL and RA_CUSTOMER_TRX_LINES_ALL, and a parent to RA_CUST_TRX_LINE_GL_DIST_ALL, linking sales credits to their corresponding general ledger distributions. It holds multiple foreign key relationships to RA_SALESREPS_ALL for different representative roles and to JTF_RS_GROUPS_B for sales team credits. As noted in the metadata, it is a direct source for the Financial Intelligence (FII) views FII_AR_SALES_CREDITS and FII_AR_SALES_CREDITS_D_T, which feed data warehouses and business intelligence tools for sales analytics.