Search Results hz_cust_acct_sites_all




Here's a detailed description of the HZ_CUST_ACCT_SITES_ALL table in Oracle E-Business Suite (EBS):

Table Name: HZ_CUST_ACCT_SITES_ALL

Purpose:
- Stores customer account site information
- Represents physical locations or addresses associated with customer accounts
- Part of the Oracle Receivables and Customer Management modules

Key Columns:
1. CUST_ACCT_SITE_ID (Primary Key)
- Unique identifier for each customer account site
- Automatically generated sequence number

2. CUST_ACCOUNT_ID
- Links to the customer account in HZ_CUST_ACCOUNTS
- Identifies which customer account the site belongs to

3. PARTY_SITE_ID
- References the party site in HZ_PARTY_SITES
- Represents the physical address details

4. ORG_ID
- Multi-organization identifier
- Allows tracking sites across different operating units

5. STATUS
- Current status of the customer account site (Active/Inactive)

6. ATTRIBUTE_CATEGORY
- Flexfield for customization
- Allows additional attributes specific to your implementation

Common Use Cases:
- Billing addresses
- Shipping locations
- Contact management
- Tax reporting
- Credit and collection processes

Typical Join Relationships:
- HZ_CUST_ACCOUNTS
- HZ_PARTY_SITES
- AR_CUSTOMERS
- RA_CUSTOMER_TRX_ALL

Important Considerations:
- Populated and managed through Customer Setup forms
- Critical for financial and operational processes
- Supports multi-organization architecture