Search Results po_distributions_all




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

Table Name: PO_DISTRIBUTIONS_ALL

Purpose:
- Stores distribution details for Purchase Order (PO) lines
- Captures accounting and financial distribution information for each PO line
- Tracks how costs are allocated across different departments, projects, or accounts

Key Columns:
1. PO_DISTRIBUTION_ID (Primary Key)
- Unique identifier for each distribution record
- Typically a system-generated sequence number

2. PO_HEADER_ID
- References the associated Purchase Order header
- Links to PO_HEADERS_ALL table

3. PO_LINE_ID
- References the specific Purchase Order line
- Links to PO_LINES_ALL table

4. DISTRIBUTION_NUM
- Sequence number for distributions within a PO line
- Helps track multiple distributions per line

5. CHARGE_ACCOUNT_ID
- GL account where the expense will be charged
- Links to GL_CODE_COMBINATIONS table

6. DESTINATION_TYPE_CODE
- Indicates the type of distribution (Expense, Inventory, Asset)
- Common values: EXPENSE, INVENTORY, ASSET

7. QUANTITY_ORDERED
- Quantity associated with this specific distribution

8. AMOUNT
- Monetary value of the distribution

9. PERIOD_NAME
- Accounting period for the distribution

10. BUDGET_ACCOUNT_ID
- Optional account for budget tracking

11. RECOVERABLE_TAX
- Tax amount that can be recovered

12. ACCRUAL_ACCOUNT_ID
- Account used for accrual accounting

Additional Attributes:
- CREATED_BY
- CREATION_DATE
- LAST_UPDATED_BY
- LAST_UPDATE_DATE

Primary Use Cases:
- Tracking purchase order cost allocations
- Supporting financial and management reporting
- Enabling detailed expense distribution
- Supporting multi-org accounting

Typical Joins:
- PO_HEADERS_ALL
- PO_LINES_ALL
- GL_CODE_COMBINATIONS
- HR_OPERATING_UNITS

Performance Considerations:
- Indexed on PO_HEADER_ID, PO_LINE_ID
- Can have large number of rows for organizations with high PO volumes

Customization/Extension:
- Often customized to add organization-specific distribution rules
- Can be extended with custom columns for specific tracking needs

Reporting and Analysis:
- Critical for financial reconciliation
- Used in cost center and project accounting
- Supports detailed spend analysis

Recommended Best Practices:
- Ensure proper setup of default distribution rules
- Regularly reconcile distributions with actual expenses
- Implement robust validation during distribution creation