Search Results hz_cust_site_uses_all




Here's a detailed description of the HZ_CUST_SITE_USES_ALL table in Oracle E-Business Suite:

Table Name: HZ_CUST_SITE_USES_ALL
Purpose: Stores customer site use information across different operating units

Key Columns:
1. SITE_USE_ID (Primary Key)
- Unique identifier for each customer site use
- Typically a sequenced number

2. SITE_USE_CODE
- Defines the purpose of the site use
- Common values:
- BILL_TO
- SHIP_TO
- SOLD_TO
- PAYING

3. CUST_ACCT_SITE_ID
- Foreign key linking to HZ_CUST_ACCT_SITES_ALL
- Identifies the specific customer site

4. ORGANIZATION_ID
- Operating unit identifier
- Allows tracking site uses across different business units

5. STATUS
- Current status of the site use
- Values like ACTIVE, INACTIVE

6. PRIMARY_FLAG
- Indicates if this is the primary site use for the customer

7. CREATION_DATE
- Timestamp of record creation

8. CREATED_BY
- User who created the record

Additional Attributes:
- Supports multiple site uses per customer
- Used in Order Management, Receivables, and Purchasing modules
- Allows for complex customer site configurations

Typical Use Cases:
- Defining billing and shipping addresses
- Managing customer site relationships
- Supporting multi-organization setups