[Home] [Help] [Dependency Information]
Object Name: | PA_SUMM_BALANCES |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_SUMM_BALANCES |
Subobject Name: | |
Status: | VALID |
PA_SUMM_BALANCES stores summarized balance informations for reporting objects.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_SUMM_BALANCES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERIOD_TYPE
OBJECT_TYPE_CODE OBJECT_ID VERSION_ID PERIOD_SET_NAME PERIOD_NAME GLOBAL_EXP_PERIOD_END_DATE AMOUNT_TYPE_ID |
PA_SUMM_BALANCES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PERIOD_TYPE
OBJECT_TYPE_CODE OBJECT_ID VERSION_ID PERIOD_YEAR PERIOD_SET_NAME QUARTER_OR_MONTH_NUMBER |
PA_SUMM_BALANCES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PERIOD_TYPE
OBJECT_TYPE_CODE OBJECT_ID VERSION_ID PERIOD_SET_NAME PERIOD_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OBJECT_ID | NUMBER | (15) | Yes | The identifier of the object for which the balance is created |
VERSION_ID | NUMBER | Yes | The identifier of the balance version | |
OBJECT_TYPE_CODE | VARCHAR2 | (30) | Yes | The object type |
PERIOD_TYPE | VARCHAR2 | (2) | Yes | The internal identifier of the period type for the period included in the balance. Values can be: PA ( balances are accrued based on PA Periods), GL ( balances are accrued based on GL Periods), GE ( balances are accrued based on Global Expenditure Weeks as defined at the site level) |
PERIOD_SET_NAME | VARCHAR2 | (15) | Yes | The accounting calendar associated with the ledger. This column stores a dummy value ("SUMM-DUMMY") for non-accounting periods (global expenditure week). |
PERIOD_NAME | VARCHAR2 | (15) | Yes | The name of the period for which the balance is created. This column stores a dummy value ("SUMM-DUMMY") for non-accounting periods ( global expenditure week ) |
GLOBAL_EXP_PERIOD_END_DATE | DATE | Yes | The global expenditure period for which the balance is created. This column stores a dummy value ("09-OCT-1492") for accounting periods ( PA and GL ) | |
PERIOD_YEAR | NUMBER | Yes | The accounting period year for the accouting periods. For non-accounting periods ( global expenditure week ), this column stores the year in which the global expenditure period falls | |
QUARTER_OR_MONTH_NUMBER | NUMBER | Yes | For balances based on PA or GL periods, the number of the quarter that contains the Period. For balances based on the global expenditure week, the month number. | |
AMOUNT_TYPE_ID | NUMBER | Yes | The identifier of the amount type associated with the balance. | |
PERIOD_NUM | NUMBER | The accounting period number for which the balance is created | ||
UNIT_OF_MEASURE | VARCHAR2 | (30) | The unit of measure | |
PERIOD_BALANCE | NUMBER | The period to date balance in the project currency | ||
GLOBAL_CURRENCY_CODE | VARCHAR2 | (15) | The global currency code | |
GLOBAL_PERIOD_BALANCE | NUMBER | The period to date balance in the global currency | ||
DENOM_CURRENCY_CODE | VARCHAR2 | (15) | The transaction currency code | |
DENOM_PERIOD_BALANCE | NUMBER | The period to date balance in the transaction currency | ||
PVDR_CURRENCY_CODE | VARCHAR2 | (15) | The expenditure functional currency Code | |
PVDR_PERIOD_BALANCE | NUMBER | The period to date balance in the expenditure functional currency | ||
RCVR_CURRENCY_CODE | VARCHAR2 | (15) | The project functional currency code | |
RCVR_PERIOD_BALANCE | NUMBER | The period to date balance in the project functional currency | ||
PROJ_CURRENCY_CODE | VARCHAR2 | (15) | The project currency code | |
PROJ_PERIOD_BALANCE | NUMBER | The period to date balance in the project currency |
Cut, paste (and edit) the following text to query this object:
SELECT OBJECT_ID
, VERSION_ID
, OBJECT_TYPE_CODE
, PERIOD_TYPE
, PERIOD_SET_NAME
, PERIOD_NAME
, GLOBAL_EXP_PERIOD_END_DATE
, PERIOD_YEAR
, QUARTER_OR_MONTH_NUMBER
, AMOUNT_TYPE_ID
, PERIOD_NUM
, UNIT_OF_MEASURE
, PERIOD_BALANCE
, GLOBAL_CURRENCY_CODE
, GLOBAL_PERIOD_BALANCE
, DENOM_CURRENCY_CODE
, DENOM_PERIOD_BALANCE
, PVDR_CURRENCY_CODE
, PVDR_PERIOD_BALANCE
, RCVR_CURRENCY_CODE
, RCVR_PERIOD_BALANCE
, PROJ_CURRENCY_CODE
, PROJ_PERIOD_BALANCE
FROM PA.PA_SUMM_BALANCES;
PA.PA_SUMM_BALANCES does not reference any database object
PA.PA_SUMM_BALANCES is referenced by following:
|
|
|