Search Results discount_customer_id

Overview

The SO_DISCOUNT_CUSTOMERS table is a core data object within the Oracle E-Business Suite (EBS) Order Entry (OE) module. It serves as a junction table that defines the specific customer-level applicability of discount rules. Its primary role is to establish a many-to-many relationship between discounts, defined in the SO_DISCOUNTS table, and the customer entities stored in the Receivables (AR) module. This table is essential for implementing targeted pricing strategies, enabling businesses to assign promotional discounts, volume breaks, or special terms to specific customers or customer ship-to sites, thereby driving the discounting logic within the order management lifecycle.

Key Information Stored

The table's structure centers on linking discount identifiers to customer identifiers. The primary key, DISCOUNT_CUSTOMER_ID, uniquely identifies each customer-discount assignment record. The critical foreign key columns are DISCOUNT_ID, which references the parent discount definition in SO_DISCOUNTS; CUSTOMER_ID, which links to the customer master record in RA_CUSTOMERS; and SITE_USE_ID, which provides granularity by optionally linking to a specific customer ship-to site in RA_SITE_USES_ALL. When SITE_USE_ID is populated, the discount applies only to that particular site; a null value typically indicates the discount applies to all sites for the given customer.

Common Use Cases and Queries

A primary use case is validating discount eligibility during order entry or price calculation. For instance, when a sales order is created for a customer, the pricing engine can query this table to determine which discount rules are valid for that customer and ship-to location. Common reporting needs include generating a list of all customers eligible for a specific promotion or auditing discount assignments. A sample query to retrieve active discounts for a customer would join SO_DISCOUNT_CUSTOMERS to SO_DISCOUNTS and RA_CUSTOMERS:

• SELECT d.discount_name, c.customer_name, c.customer_number FROM oe.so_discount_customers dc, oe.so_discounts d, ar.ra_customers c WHERE dc.discount_id = d.discount_id AND dc.customer_id = c.customer_id AND c.customer_id = :p_cust_id;

Related Objects

SO_DISCOUNT_CUSTOMERS is centrally connected to several key EBS tables via documented foreign key relationships. It is a child of the SO_DISCOUNTS table, joining on the DISCOUNT_ID column, which is the master definition of the discount rule. For customer data, it references RA_CUSTOMERS on the CUSTOMER_ID column. For greater specificity at the address level, it references RA_SITE_USES_ALL on the SITE_USE_ID column. These relationships ensure referential integrity and are critical for any data analysis or integration involving customer-specific discounts. The table is primarily accessed through the standard Order Management APIs and user interfaces for discount setup and maintenance.