[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PN_OPEX_RECON_PRTBS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | PN |
| FND Design Data: |  PN.PN_OPEX_RECON_PRTBS_ALL
|
| Subobject Name: | |
| Status: | VALID |
PN_OPEX_RECON_PRTBS_ALL stores pro rata basis information for operating expense reconciliations.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PN_OPEX_RECON_PRTBS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 RECON_PRTBS_ID
|
| PN_OPEX_RECON_PRTBS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
RECON_ID
|
| PN_OPEX_RECON_PRTBS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PRTBS_DTL_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| RECON_PRTBS_ID | NUMBER | Yes | Identifier of the pro rata basis used for the reconciliation | |
| RECON_ID | NUMBER | Yes | Identifier of the reconciliation | |
| PRTBS_DTL_ID | NUMBER | Yes | Identifier of the pro rata basis record of the agreement | |
| TENANT_AREA_ST | NUMBER | Tenant area as specified in the landlord statement | ||
| TOTAL_AREA_ST | NUMBER | Total area as specified in the landlord statement | ||
| OCCUPIED_ST | NUMBER | Occupied area as specified in the landlord statement | ||
| FLOOR_PCT_ST | NUMBER | The minimum building occupancy level (lowest floor) as specified in the landlord statement that is to be used for calculating pro rata share of occupied area | ||
| PRORATA_PCT_ST | NUMBER | The tenant pro rata percentage as specified in the landlord statement | ||
| TOTAL_AREA_OVR | NUMBER | User-entered value for total area | ||
| OCCUPIED_OVR | NUMBER | User-entered value for occupied area | ||
| PRORATA_PCT_OVR | NUMBER | User-entered value for pro rata percent | ||
| PRORAT_BASIS_NAME | VARCHAR2 | (90) | Name of the pro rata basis | |
| TENANT_AREA | NUMBER | User entered value for tenant area | ||
| FLOOR_PCT | NUMBER | The minimum building occupancy level (lowest floor) as specified in the agreement that is to be used for calculating pro rata share of occupied area | ||
| TOTAL_AREA | NUMBER | User entered value for tenant area | ||
| TOT_EXPENSE | NUMBER | Total Expense | ||
| NET_SUB_TO_FEE | NUMBER | Net expense subject to fees | ||
| CAPPED_EXP | NUMBER | Expense after applying constraints | ||
| SAVINGS_CREDIT | NUMBER | Landlord savings credit amount | ||
| OVERRUN_CREDIT | NUMBER | Landlord overrun credit amount | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column. | |
| LAST_UPDATED_BY | NUMBER | Yes | Standard Who column. | |
| CREATION_DATE | DATE | Yes | Standard Who column. | |
| CREATED_BY | NUMBER | Yes | Standard Who column. | |
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column. | ||
| ORG_ID | NUMBER | (15) | Identifier of the operating unit |
Cut, paste (and edit) the following text to query this object:
SELECT RECON_PRTBS_ID
, RECON_ID
, PRTBS_DTL_ID
, TENANT_AREA_ST
, TOTAL_AREA_ST
, OCCUPIED_ST
, FLOOR_PCT_ST
, PRORATA_PCT_ST
, TOTAL_AREA_OVR
, OCCUPIED_OVR
, PRORATA_PCT_OVR
, PRORAT_BASIS_NAME
, TENANT_AREA
, FLOOR_PCT
, TOTAL_AREA
, TOT_EXPENSE
, NET_SUB_TO_FEE
, CAPPED_EXP
, SAVINGS_CREDIT
, OVERRUN_CREDIT
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ORG_ID
FROM PN.PN_OPEX_RECON_PRTBS_ALL;
PN.PN_OPEX_RECON_PRTBS_ALL does not reference any database object
PN.PN_OPEX_RECON_PRTBS_ALL is referenced by following:
PN
PN_OPEX_RECON_PRTBS_ALL#
|
|
|
|