Search Results pn_space_assign_cust_all




Overview
Explore in AI Chat

Overview

The PN_SPACE_ASSIGN_CUST_ALL table is a core data repository within Oracle E-Business Suite (EBS) Property Manager (PN) module, versions 12.1.1 and 12.2.2. It serves as the definitive table for storing detailed customer space assignment information. This object is central to the leasing and property management lifecycle, establishing the critical link between a leased property space (tenancy), the occupying customer, and the associated financial and project accounting setup. Its multi-org enabled structure, denoted by the '_ALL' suffix, supports implementations with multiple operating units, allowing data segregation by the ORG_ID context.

Key Information Stored

The table's primary key, CUST_SPACE_ASSIGN_ID, uniquely identifies each customer space assignment record. Its foreign key relationships define the essential business entities involved. The TENANCY_ID links to PN_TENANCIES_ALL, connecting the assignment to a specific leased space. The CUST_ACCOUNT_ID and SITE_USE_ID foreign keys to HZ_CUST_ACCOUNTS and HZ_CUST_SITE_USES_ALL, respectively, identify the customer (from Trading Community Architecture) and their specific bill-to site for the assignment. The LEASE_ID links the assignment to its governing contract in PN_LEASES_ALL. For financial integration, the EXPENSE_ACCOUNT_ID references GL_CODE_COMBINATIONS to post associated expenses, while PROJECT_ID and TASK_ID link to PA_PROJECTS_ALL and PA_TASKS for project-related cost tracking.

Common Use Cases and Queries

This table is pivotal for generating occupancy reports, billing schedules, and customer chargebacks. A common operational query involves retrieving all active customer assignments for a specific lease to review tenancy status. For financial reconciliation, queries often join this table with receivable and expense line detail tables (PN_REC_ARCL_DTLLN_ALL, PN_REC_EXPCL_DTLLN_ALL) to trace charges back to their source assignment. In reporting scenarios, it is frequently joined with customer (HZ) and tenancy (PN) tables to produce summaries of leased area per customer, vacancy analysis, or customer contact lists for a property.

Related Objects

The table maintains extensive foreign key relationships, acting as a hub for transactional data. Key documented relationships include:

  • Primary Source Entities: PN_TENANCIES_ALL (via TENANCY_ID), PN_LEASES_ALL (via LEASE_ID), HZ_CUST_ACCOUNTS (via CUST_ACCOUNT_ID), HZ_CUST_SITE_USES_ALL (via SITE_USE_ID).
  • Financial & Project Integration: GL_CODE_COMBINATIONS (via EXPENSE_ACCOUNT_ID), PA_PROJECTS_ALL (via PROJECT_ID), PA_TASKS (via TASK_ID).
  • Downstream Transaction Lines: PN_REC_ARCL_DTLLN_ALL and PN_REC_EXPCL_DTLLN_ALL (both via CUST_SPACE_ASSIGN_ID). These tables store detailed receivable and expense line items generated from the space assignment, making PN_SPACE_ASSIGN_CUST_ALL the parent record for billing and cost allocation.