[Home] [Help] [Dependency Information]
Object Name: | PA_DRAFT_REVENUES_AR |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_DRAFT_REVENUES_AR |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_DRAFT_REVENUES_AR_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PURGE_PROJECT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PURGE_BATCH_ID | NUMBER | (15) | Yes | Purge batch Id |
PURGE_RELEASE | VARCHAR2 | (50) | Yes | Purge release version |
PURGE_PROJECT_ID | NUMBER | (15) | Yes | Purge Project Id |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
RESOURCE_ACCUMULATED_FLAG | VARCHAR2 | (1) | Flag to indicate whether this cost distribution lines is resource accumulated or not. The cost distribution line may be accumulated in the current reporting period or future periods. In both cases the resource accum flag will be = 'Y' | |
ORG_ID | NUMBER | (15) | Operating unit identifier for multi-organization installations | |
PROJECT_ID | NUMBER | (15) | The identifier of the project for which the revenue is generated | |
DRAFT_REVENUE_NUM | NUMBER | (15) | The sequential number that identifies the draft revenue within a project | |
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 |
AGREEMENT_ID | NUMBER | (15) | The identifier of the agreement that funds the revenue | |
TRANSFER_STATUS_CODE | VARCHAR2 | (1) | The status of the revenue as it is transferred to General Ledger | |
GENERATION_ERROR_FLAG | VARCHAR2 | (1) | Flag that indicates that an error was encountered during the Generate Draft Revenue program that caused the draft revenue to not be successfully generated | |
PA_DATE | DATE | The end date of the PA period in which the revenue is generated. The PA period is the open or future PA period on or after the latest date of the expenditure item dates and the event completion dates included on the revenue. | ||
REQUEST_ID | NUMBER | (15) | Concurrent program Who column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Concurrent program Who column | |
PROGRAM_ID | NUMBER | (15) | Concurrent program Who column | |
PROGRAM_UPDATE_DATE | DATE | Concurrent program Who column | ||
CUSTOMER_BILL_SPLIT | NUMBER | (7) | The percentage of the total project revenue that the customer is funding on the draft revenue | |
ACCRUE_THROUGH_DATE | DATE | The date through which to accrue revenue for the project. Expenditure items with item date and events with completion date on or before the accrue through date are included on a revenue. For cost-to-cost accrual, the item PA date is used. | ||
RELEASED_DATE | DATE | The date on which the draft revenue is released | ||
TRANSFERRED_DATE | DATE | The date that the draft revenue was transferred to General Ledger | ||
TRANSFER_REJECTION_REASON | VARCHAR2 | (250) | The reason why the draft revenue was rejected by the Transfer Revenue program or rejected by the General Ledger interface program, EZLink | |
UNBILLED_RECEIVABLE_DR | NUMBER | (22) | The amount of unbilled receivables debit by the draft revenue | |
UNEARNED_REVENUE_CR | NUMBER | (22) | The amount of unearned revenue credited by this draft revenue | |
UNBILLED_CODE_COMBINATION_ID | NUMBER | (15) | The identifier of the gl account to which the unbilled receivables amount of this draft revenue is charged | |
UNEARNED_CODE_COMBINATION_ID | NUMBER | (15) | The identifier of the gl account to which the unearned revenue amount of this draft revenue is charged | |
UNBILLED_BATCH_NAME | VARCHAR2 | (30) | The identifier of the GL je line in which the UBR amount is included when posted to GL. This value is a concatenation of the UBR ccid, draft revenue gl date, transfer request id separated by hyphens. Joins to GL_JE_LINES.REFERENCE_1 | |
UNEARNED_BATCH_NAME | VARCHAR2 | (30) | The identifier of the GL je line in which the UER amount is included when posted to GL. This value is a concatenation of UER ccid, draft revenue gl date, transfer request id separated by hyphens. Joins to GL_JE_LINES.REFERENCE_1. | |
GL_DATE | DATE | The end date of the GL accounting period to which to post the draft revenue transactions.The GL period is determined by the Transfer Revenue program from the first open or future GL period on or after the PA date of the draft revenue. | ||
ACCUMULATED_FLAG | VARCHAR2 | (1) | Flag indicating whether the revenue amounts of the draft revenue are included in the accumulator tables. (Obsolete in Version 4 with the new project summary amounts.) | |
DRAFT_REVENUE_NUM_CREDITED | NUMBER | (15) | The draft revenue number that is credited by this draft revenue | |
GL_PERIOD_NAME | VARCHAR2 | (15) | The GL period in which the revenue is posted. | |
PA_PERIOD_NAME | VARCHAR2 | (15) | The PA period in which the revenue is posted. | |
ADJUSTING_REVENUE_FLAG | VARCHAR2 | (1) | Indicate that the event is an adjusting revenue event | |
UBR_SUMMARY_ID | NUMBER | (15) | The UBR summary ID. | |
UER_SUMMARY_ID | NUMBER | (15) | The UER summary ID | |
UBR_UER_PROCESS_FLAG | VARCHAR2 | (1) | The UBR/UER process flag. | |
PJI_SUMMARIZED_FLAG | VARCHAR2 | (1) | PJI Summarized Flag | |
REALIZED_GAINS_AMOUNT | NUMBER | The amount realized gains debit by the draft revenue | ||
REALIZED_LOSSES_AMOUNT | NUMBER | The amount realized losses credited by the draft revenue | ||
REALIZED_GAINS_CCID | NUMBER | (15) | The identifier of the GL account to which the realized gains amount of this draft revenue is charged. This will be populated by Interface revenue to GL process. | |
REALIZED_LOSSES_CCID | NUMBER | (15) | The identifier of the GL account to which the realized losses amount of this draft revenue is charged. This will be populated by Interface revenue to GL process. | |
REALIZED_GAINS_BATCH_NAME | VARCHAR2 | (30) | The identifier of the GL JE line in which the realized gains amount is included when posted to GL. This value is a concatenation of realized gains ccid, draft revenue gl date and transfer request id seperated by hyphens. Joins to GL_JE_LINES.REFERENCE_1 | |
REALIZED_LOSSES_BATCH_NAME | VARCHAR2 | (30) | The identifier of the GL JE line in which the realized losses amount is included when posted to GL. This value is a concatenation of realized losses ccid, draft revenue gl date and transfer request id seperated by hyphens. Joins to GL_JE_LINES.REFERENCE_1 |
Cut, paste (and edit) the following text to query this object:
SELECT PURGE_BATCH_ID
, PURGE_RELEASE
, PURGE_PROJECT_ID
, LAST_UPDATE_LOGIN
, RESOURCE_ACCUMULATED_FLAG
, ORG_ID
, PROJECT_ID
, DRAFT_REVENUE_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, AGREEMENT_ID
, TRANSFER_STATUS_CODE
, GENERATION_ERROR_FLAG
, PA_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CUSTOMER_BILL_SPLIT
, ACCRUE_THROUGH_DATE
, RELEASED_DATE
, TRANSFERRED_DATE
, TRANSFER_REJECTION_REASON
, UNBILLED_RECEIVABLE_DR
, UNEARNED_REVENUE_CR
, UNBILLED_CODE_COMBINATION_ID
, UNEARNED_CODE_COMBINATION_ID
, UNBILLED_BATCH_NAME
, UNEARNED_BATCH_NAME
, GL_DATE
, ACCUMULATED_FLAG
, DRAFT_REVENUE_NUM_CREDITED
, GL_PERIOD_NAME
, PA_PERIOD_NAME
, ADJUSTING_REVENUE_FLAG
, UBR_SUMMARY_ID
, UER_SUMMARY_ID
, UBR_UER_PROCESS_FLAG
, PJI_SUMMARIZED_FLAG
, REALIZED_GAINS_AMOUNT
, REALIZED_LOSSES_AMOUNT
, REALIZED_GAINS_CCID
, REALIZED_LOSSES_CCID
, REALIZED_GAINS_BATCH_NAME
, REALIZED_LOSSES_BATCH_NAME
FROM PA.PA_DRAFT_REVENUES_AR;
PA.PA_DRAFT_REVENUES_AR does not reference any database object
PA.PA_DRAFT_REVENUES_AR is referenced by following:
|
|
|