[Home] [Help] [Dependency Information]
Object Name: | PA_MC_DRAFT_REVS_AR |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_MC_DRAFT_REVS_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_MC_DRAFT_REVS_AR_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SET_OF_BOOKS_ID
PROJECT_ID DRAFT_REVENUE_NUM |
PA_MC_DRAFT_REVS_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 |
SET_OF_BOOKS_ID | NUMBER | (15) | The reporting set of books unique identifier | |
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 | |
TRANSFER_STATUS_CODE | VARCHAR2 | (1) | The status of the revenue in the reporting set of books as it is transferred to General Ledger | |
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 | ||
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 General Ledger. | |
UNBILLED_RECEIVABLE_DR | NUMBER | The amount of unbilled receivables debit by the draft revenue in the reporting currency | ||
UNEARNED_REVENUE_CR | NUMBER | The amount of unearned revenue credited by this draft revenue in the reporting currency | ||
UNBILLED_BATCH_NAME | VARCHAR2 | (30) | The identifier of the GL je line in which the UBR amount is included when posted to GL. | |
UNEARNED_BATCH_NAME | VARCHAR2 | (30) | The identifier of the GL je line in which the UER amount is included when posted to GL. | |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard who column |
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_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
, SET_OF_BOOKS_ID
, PROJECT_ID
, DRAFT_REVENUE_NUM
, TRANSFER_STATUS_CODE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, TRANSFERRED_DATE
, TRANSFER_REJECTION_REASON
, UNBILLED_RECEIVABLE_DR
, UNEARNED_REVENUE_CR
, UNBILLED_BATCH_NAME
, UNEARNED_BATCH_NAME
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REALIZED_GAINS_AMOUNT
, REALIZED_LOSSES_AMOUNT
, REALIZED_GAINS_BATCH_NAME
, REALIZED_LOSSES_BATCH_NAME
FROM PA.PA_MC_DRAFT_REVS_AR;
PA.PA_MC_DRAFT_REVS_AR does not reference any database object
PA.PA_MC_DRAFT_REVS_AR is referenced by following:
|
|
|