[Home] [Help] [Dependency Information]
Object Name: | PA_MC_CC_DIST_LINES_AR |
---|---|
Object Type: | TABLE |
Owner: | PA |
FND Design Data: | PA.PA_MC_CC_DIST_LINES_AR |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PA_MC_CC_DIST_LINES_AR_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SET_OF_BOOKS_ID
CC_DIST_LINE_ID |
PA_MC_CC_DIST_LINES_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 | Purged Project id |
SET_OF_BOOKS_ID | NUMBER | (15) | The reporting set of books unique identifier | |
PRC_ASSIGNMENT_ID | NUMBER | (15) | The assignment identifier for the project reporting currency | |
CC_DIST_LINE_ID | NUMBER | (15) | The system-generated number that uniquely identifies the cross charge distribution | |
EXPENDITURE_ITEM_ID | NUMBER | (15) | The identifier of the expenditure item to which the cross charge distribution belongs | |
LINE_NUM | NUMBER | The sequential line number that identifies the cross charge distribution line for an expenditure item | ||
LINE_TYPE | VARCHAR2 | (2) | The type of the cross charge distribution line | |
ACCT_CURRENCY_CODE | VARCHAR2 | (15) | Functional currency code of the reporting set of books | |
AMOUNT | NUMBER | Amount to be posted to GL in the functional currency of the reporting set of books. If the line type is Borrowed or Lent | ||
PROGRAM_ID | NUMBER | (15) | Standard Who Column | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who Column | |
PROGRAM_UPDATE_DATE | DATE | Standard Who Column | ||
REQUEST_ID | NUMBER | (15) | Identifier of the concurrent request that last processed the item | |
TRANSFER_STATUS_CODE | VARCHAR2 | (30) | The status of the distribution line as the accounting information is transferred to GL | |
ACCT_TP_RATE_TYPE | VARCHAR2 | (30) | Rate type used to convert to the reporting set of books currency | |
ACCT_TP_RATE_DATE | DATE | Rate date used to convert the transfer price amount to the reporting set of books currency | ||
ACCT_TP_EXCHANGE_RATE | NUMBER | Exchange rate used to convert the transfer price amount to the reporting set of books currency | ||
GL_BATCH_NAME | VARCHAR2 | (30) | The reference to a batch of lines transferred together to General Ledger. | |
TRANSFERRED_DATE | DATE | The date the record was transferred to GL | ||
TRANSFER_REJECTION_CODE | VARCHAR2 | (30) | Rejection code if the record is rejected in transfer to General Ledger. |
Cut, paste (and edit) the following text to query this object:
SELECT PURGE_BATCH_ID
, PURGE_RELEASE
, PURGE_PROJECT_ID
, SET_OF_BOOKS_ID
, PRC_ASSIGNMENT_ID
, CC_DIST_LINE_ID
, EXPENDITURE_ITEM_ID
, LINE_NUM
, LINE_TYPE
, ACCT_CURRENCY_CODE
, AMOUNT
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, TRANSFER_STATUS_CODE
, ACCT_TP_RATE_TYPE
, ACCT_TP_RATE_DATE
, ACCT_TP_EXCHANGE_RATE
, GL_BATCH_NAME
, TRANSFERRED_DATE
, TRANSFER_REJECTION_CODE
FROM PA.PA_MC_CC_DIST_LINES_AR;
PA.PA_MC_CC_DIST_LINES_AR does not reference any database object
PA.PA_MC_CC_DIST_LINES_AR is referenced by following:
|
|
|