[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_PROJECT_FUNDINGS |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_PROJECT_FUNDINGS
|
| Subobject Name: | |
| Status: | VALID |
PA_PROJECT_FUNDINGS stores incremental allocations of
agreement funds to projects or top tasks.
Funding is required for a contract project before that
project can accrue revenue and generate invoices.
Indirect or capital projects can be funded with $0 funding to
link a project to an agreement for reporting purposes.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PA_PROJECT_FUNDINGS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PROJECT_FUNDING_ID
|
| PA_PROJECT_FUNDINGS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
AGREEMENT_ID
|
| PA_PROJECT_FUNDINGS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROJECT_ID
TASK_ID
|
| PA_PROJECT_FUNDINGS_N3 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PM_PRODUCT_CODE
PM_FUNDING_REFERENCE
|
| PA_PROJECT_FUNDINGS_N4 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PROJECT_ID
PJI_SUMMARIZED_FLAG
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PA_PROJECT_FUNDINGS_PROJECT_ID | NUMBER | (15) | Not used | |
| PROJECT_FUNDING_ID | NUMBER | (15) | Yes | The system-generated number that uniquely identifies the project funding record |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who Column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who Column |
| AGREEMENT_ID | NUMBER | (15) | Yes | The identifier of the agreement that is allocating funds to the project or task |
| PROJECT_ID | NUMBER | (15) | Yes | The identifier of the project to which funds are allocated |
| TASK_ID | NUMBER | (15) | The identifier of the top task to which funds are allocated | |
| BUDGET_TYPE_CODE | VARCHAR2 | (30) | Yes | The status of the funding, indicating if it is baselined or not |
| ALLOCATED_AMOUNT | NUMBER | (22) | Yes | Amount of funding allocated to the project or top task in funding currency |
| DATE_ALLOCATED | DATE | Yes | The date on which the funding is allocated to the project or the top task | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield context field | |
| 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 | |
| PM_FUNDING_REFERENCE | VARCHAR2 | (25) | The identifier of the funding in the external system from which the funding was imported. | |
| PM_PRODUCT_CODE | VARCHAR2 | (25) | The identifier of the external system from which the funding was imported. | |
| FUNDING_CURRENCY_CODE | VARCHAR2 | (15) | Currency code of the project funding currency | |
| PROJECT_CURRENCY_CODE | VARCHAR2 | (15) | Project currency code of the project | |
| PROJECT_RATE_TYPE | VARCHAR2 | (30) | Funding currency to project currency exchange rate type | |
| PROJECT_RATE_DATE | DATE | Funding currency to project currency exchange rate date | ||
| PROJECT_EXCHANGE_RATE | NUMBER | Funding currency to project currency exchange rate | ||
| PROJECT_ALLOCATED_AMOUNT | NUMBER | (22) | Amount of funding allocated to the project or top task iin the project currency | |
| PROJFUNC_CURRENCY_CODE | VARCHAR2 | (15) | Project functional currency code of the project | |
| PROJFUNC_RATE_TYPE | VARCHAR2 | (30) | Funding currency to project functional currency exchange rate type | |
| PROJFUNC_RATE_DATE | DATE | Funding currency to project functional currency exchange rate date | ||
| PROJFUNC_EXCHANGE_RATE | NUMBER | Funding currency to project functional currency exchange rate | ||
| PROJFUNC_ALLOCATED_AMOUNT | NUMBER | (22) | Amount of funding allocated to the project or top task in the project functional currency | |
| INVPROC_CURRENCY_CODE | VARCHAR2 | (15) | Invoice processing currency code of the project | |
| INVPROC_RATE_TYPE | VARCHAR2 | (30) | Funding currency to invoice procesiing currency exchange rate type | |
| INVPROC_RATE_DATE | DATE | Funding currency to invoice processing currency exchange rate date | ||
| INVPROC_EXCHANGE_RATE | NUMBER | Funding currency to invoice processing currency exchange rate | ||
| INVPROC_ALLOCATED_AMOUNT | NUMBER | (22) | Amount of funding allocated to the project or top task in the invoice processing currency | |
| REVPROC_CURRENCY_CODE | VARCHAR2 | (15) | Revenue processing currency code of the project | |
| REVPROC_RATE_TYPE | VARCHAR2 | (30) | Funding currency to revenue processing currency exchange rate type | |
| REVPROC_RATE_DATE | DATE | Funding currency to revenue processing currency exchange rate date | ||
| REVPROC_EXCHANGE_RATE | NUMBER | Funding currency to revenue processing currency exchange rate | ||
| REVPROC_ALLOCATED_AMOUNT | NUMBER | (22) | Amount of funding allocated to the project or top task in the revenue processing currency | |
| FUNDING_CATEGORY | VARCHAR2 | (30) | Identifier of Funding Line | |
| PJI_SUMMARIZED_FLAG | VARCHAR2 | (1) | PJI Summarized Flag | |
| REVALUATION_THROUGH_DATE | DATE | The date through which to derive the billed amount for revaluation process. This column will be populated by funding revaluation process | ||
| REVALUATION_RATE_DATE | DATE | Revaluation rate date is used to derive the revaluation rate. This column will be populated by funding revaluation process | ||
| REVALUATION_PROJFUNC_RATE_TYPE | VARCHAR2 | (30) | Revaluation rate type is used to derive the revaluation rate for project functional currency. This column will be populated by funding revaluation process. | |
| REVALUATION_PROJFUNC_RATE | NUMBER | Revaluation exchange rate is used to convert the funding amount to project functional amount | ||
| REVALUATION_INVPROC_RATE_TYPE | VARCHAR2 | (30) | Revaluation rate type is used to derive the revaluation rate for invoice processing currency. This column will be populated by funding revaluation process . | |
| REVALUATION_INVPROC_RATE | NUMBER | Revaluation exchange rate is used to convert the funding amount to invoice processing amount | ||
| FUNDING_INV_APPLIED_AMOUNT | NUMBER | Invoice applied amount in funding currency. This column will be populated by funding revaluation process | ||
| FUNDING_INV_DUE_AMOUNT | NUMBER | Invoice due amount in funding currency. This column will be populated by funding revaluation process | ||
| FUNDING_BACKLOG_AMOUNT | NUMBER | Backlog amount in funding currency. This column will be populated by funding revaluation process | ||
| PROJFUNC_REALIZED_GAINS_AMT | NUMBER | Realized Gains amount in project functional currency. This column will be populated by funding revaluation process | ||
| PROJFUNC_REALIZED_LOSSES_AMT | NUMBER | Realized losses amount in project functional currency. This column will be populated by funding revaluation process | ||
| PROJFUNC_INV_APPLIED_AMOUNT | NUMBER | Revalued invoice applied amount in project functional currency. This column will be populated by funding revaluation process | ||
| PROJFUNC_INV_DUE_AMOUNT | NUMBER | Revalued invoice due amount in project functional currency. This column will be populated by funding revaluation process | ||
| PROJFUNC_BACKLOG_AMOUNT | NUMBER | Revalued backlog amount in project functional currency . This column will be populated by funding revaluation process | ||
| NON_UPDATEABLE_FLAG | VARCHAR2 | (1) | This column indicates whether funding line is updateable or not. This column will be populated by funding revaluation processValid values Y or N. | |
| INVPROC_BACKLOG_AMOUNT | NUMBER | Revalued Backlog amount in invoice processing currency. This column will be populated by funding revaluation process | ||
| FUNDING_REVAL_AMOUNT | NUMBER | Total baselined funding amount revaluation in funding currency. This column will be populated by funding revaluation process | ||
| PROJFUNC_REVAL_AMOUNT | NUMBER | Total baselined funding amount in project functional currency. This column will be populated by funding revaluation process. | ||
| PROJFUNC_REVALUED_AMOUNT | NUMBER | Revalued amount in project functional currency. This column will be populated by funding revaluation process | ||
| INVPROC_REVAL_AMOUNT | NUMBER | Amount subject to revaluation in invoice processing currency. This column will be populated by funding revaluation process. | ||
| INVPROC_REVALUED_AMOUNT | NUMBER | Revalued amount in invoice processing currency. This column will be populated by funding revaluation process | ||
| FUNDING_REVALUATION_FACTOR | NUMBER | Funding revaluation factor which is used in the revaluation calculation.This column will be populated by funding revaluation process. | ||
| REQUEST_ID | NUMBER | (15) | Standard Who Column | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who Column | |
| PROGRAM_ID | NUMBER | (15) | Standard Who Column | |
| PROGRAM_UPDATE_DATE | DATE | Standard Who Column | ||
| CI_ID | NUMBER | (15) | Unique identifier of the Control Item Id | |
| SUBMIT_BASELINE_FLAG | VARCHAR2 | (1) | Flag indicating whether the funding line is submitted for baseline |
Cut, paste (and edit) the following text to query this object:
SELECT PA_PROJECT_FUNDINGS_PROJECT_ID
, PROJECT_FUNDING_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, AGREEMENT_ID
, PROJECT_ID
, TASK_ID
, BUDGET_TYPE_CODE
, ALLOCATED_AMOUNT
, DATE_ALLOCATED
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, PM_FUNDING_REFERENCE
, PM_PRODUCT_CODE
, FUNDING_CURRENCY_CODE
, PROJECT_CURRENCY_CODE
, PROJECT_RATE_TYPE
, PROJECT_RATE_DATE
, PROJECT_EXCHANGE_RATE
, PROJECT_ALLOCATED_AMOUNT
, PROJFUNC_CURRENCY_CODE
, PROJFUNC_RATE_TYPE
, PROJFUNC_RATE_DATE
, PROJFUNC_EXCHANGE_RATE
, PROJFUNC_ALLOCATED_AMOUNT
, INVPROC_CURRENCY_CODE
, INVPROC_RATE_TYPE
, INVPROC_RATE_DATE
, INVPROC_EXCHANGE_RATE
, INVPROC_ALLOCATED_AMOUNT
, REVPROC_CURRENCY_CODE
, REVPROC_RATE_TYPE
, REVPROC_RATE_DATE
, REVPROC_EXCHANGE_RATE
, REVPROC_ALLOCATED_AMOUNT
, FUNDING_CATEGORY
, PJI_SUMMARIZED_FLAG
, REVALUATION_THROUGH_DATE
, REVALUATION_RATE_DATE
, REVALUATION_PROJFUNC_RATE_TYPE
, REVALUATION_PROJFUNC_RATE
, REVALUATION_INVPROC_RATE_TYPE
, REVALUATION_INVPROC_RATE
, FUNDING_INV_APPLIED_AMOUNT
, FUNDING_INV_DUE_AMOUNT
, FUNDING_BACKLOG_AMOUNT
, PROJFUNC_REALIZED_GAINS_AMT
, PROJFUNC_REALIZED_LOSSES_AMT
, PROJFUNC_INV_APPLIED_AMOUNT
, PROJFUNC_INV_DUE_AMOUNT
, PROJFUNC_BACKLOG_AMOUNT
, NON_UPDATEABLE_FLAG
, INVPROC_BACKLOG_AMOUNT
, FUNDING_REVAL_AMOUNT
, PROJFUNC_REVAL_AMOUNT
, PROJFUNC_REVALUED_AMOUNT
, INVPROC_REVAL_AMOUNT
, INVPROC_REVALUED_AMOUNT
, FUNDING_REVALUATION_FACTOR
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CI_ID
, SUBMIT_BASELINE_FLAG
FROM PA.PA_PROJECT_FUNDINGS;
PA.PA_PROJECT_FUNDINGS does not reference any database object
PA.PA_PROJECT_FUNDINGS is referenced by following:
PA
PA_PROJECT_FUNDINGS#
|
|
|
|