[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PA_CC_DIST_LINES_AR |
|---|---|
| Object Type: | TABLE |
| Owner: | PA |
| FND Design Data: |  PA.PA_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_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 |
| 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 | |
| CROSS_CHARGE_CODE | VARCHAR2 | (1) | Indicates the cross charge processing method for the expenditure item. | |
| ACCT_CURRENCY_CODE | VARCHAR2 | (15) | Functional currency code of the operating unit to which the cross charge distribution belongs | |
| AMOUNT | NUMBER | Amount to be posted to GL in the functional currency. If the line type is Borrowed or Lent, the amount is transfer price. If the line type is Provider Reclass, the amount is raw cost | ||
| PROJECT_ID | NUMBER | (15) | Identifier of the project to which the expenditure item belongs. Denormalized column | |
| TASK_ID | NUMBER | (15) | Identifier of the task to which the expenditure item belongs. Denormalized column | |
| REQUEST_ID | NUMBER | (15) | Identifier of the concurrent program that last processed the item | |
| 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) | Standard Who Column | |
| ORG_ID | NUMBER | (15) | Identifier of the operating unit to which the cross charge distribution belongs | |
| LINE_NUM_REVERSED | NUMBER | The distribution line number for the same expenditure item that is reversed by this distribution line | ||
| DIST_LINE_ID_REVERSED | NUMBER | (15) | Identifier of the cross charge distribution that the line reverses . | |
| REVERSED_FLAG | VARCHAR2 | (1) | Indicates whether the line has been reversed | |
| DENOM_TP_CURRENCY_CODE | VARCHAR2 | (15) | Transaction currency code of the transfer price | |
| DENOM_TRANSFER_PRICE | NUMBER | Transaction amount of the transfer price | ||
| ACCT_TP_RATE_TYPE | VARCHAR2 | (30) | Rate type used to convert the transfer price amount from the transaction currency to the functional currency. Defaulted from the implementation options currency conversion attributes for transfer price | |
| ACCT_TP_RATE_DATE | DATE | Rate date used to convert the transfer price amount from the transaction currency to the functional currency of the provider operating unit. Derived from the implementation options currency rate date code for transfer price conversion | ||
| ACCT_TP_EXCHANGE_RATE | NUMBER | Exchange rate used to convert the transfer price amount from the transaction currency to the functional currency of the provider operating unit | ||
| DR_CODE_COMBINATION_ID | NUMBER | (15) | Identifier of the GL debit account for the distribution | |
| CR_CODE_COMBINATION_ID | NUMBER | (15) | Identifier of the GL credit account for the distribution | |
| PA_DATE | DATE | The end date of the PA Period in which the distribution was processed. The PA date is determined by the cross charge process from the open or future PA period on or after the expenditure item date | ||
| GL_DATE | DATE | The end date of the GL accounting period to which the distribution is posted. This date is determined by the transfer program from the first open or future GL period on or after the distributions PA date | ||
| GL_BATCH_NAME | VARCHAR2 | (30) | The reference to a batch of lines transferred together. This is a concatenation of the liability code combination identifier, GL Date and Transfer request identifier separated by hyphens | |
| TRANSFER_STATUS_CODE | VARCHAR2 | (30) | The status of the distribution line as the accounting information is transferred to GL. | |
| 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 GL. | |
| MARKUP_CALC_BASE_CODE | VARCHAR2 | (1) | Audit column for transfer price derivation, thus only for borrowed and lent entries. Transaction amount on which the cross charge rate will be based. | |
| IND_COMPILED_SET_ID | NUMBER | (15) | Audit column for transfer price derivation, thus only for borrowed and lent entries. Identifier of the burden compiled set if a burden schedule is used in determining the transfer price. | |
| BILL_RATE | NUMBER | Audit column for transfer price derivation, thus only for borrowed and lent entries. Bill rate used in deriving the transfer price if the transfer price was based on a rate defined in a bill rate schedule | ||
| TP_BASE_AMOUNT | NUMBER | Audit column for transfer price derivation, thus only for borrowed and lent entries. Base amount used to derive the transfer price, held in transfer price transaction currency | ||
| BILL_MARKUP_PERCENTAGE | NUMBER | Audit column for transfer price derivation, thus only for borrowed and lent entries. Percentage used in deriving the transfer price if the transfer price was based on a markup in bill rate schedule | ||
| SCHEDULE_LINE_PERCENTAGE | NUMBER | Audit column for transfer price derivation, thus only for borrowed and lent entries. Percentage applied to the calculated transfer price from the schedule line | ||
| RULE_PERCENTAGE | NUMBER | Audit column for transfer price derivation, thus only for borrowed and lent entries. Percentage applied to the calculated transfer price from the rule definition | ||
| REFERENCE_1 | NUMBER | The reference to a record in another entity in Oracle Projects For Provider Reclassification entries, this contains the Invoice Detail identifier | ||
| REFERENCE_2 | VARCHAR2 | (240) | The reference to a record in another entity in Oracle Projects For Provider reclassification entries, this contains the source of the amount which may be either the raw cost or the burdened cost | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | This column is updated by the program application id when a concurrent program is run. | |
| PROGRAM_ID | NUMBER | (15) | This column is updated by the program id when a concurrent program is run. | |
| PROGRAM_UPDATE_DATE | DATE | This column is updated by the sysdate when a concurrent program is run. | ||
| REFERENCE_3 | NUMBER | The reference to a record in another entity in Oracle Projects For Provider Reclassification entries, this contains the line number of the corresponding cost distribution line | ||
| TP_JOB_ID | NUMBER | (15) | Cross charge id | |
| PROJFUNC_TP_EXCHANGE_RATE | NUMBER | Exchange rate used to convert the transfer price from the transaction currency to the project functional currency. | ||
| PROJFUNC_TRANSFER_PRICE | NUMBER | Transfer price in project functional currency. | ||
| TP_AMT_TYPE_CODE | VARCHAR2 | (30) | Cross charge classification. | |
| PROJFUNC_TP_RATE_TYPE | VARCHAR2 | (30) | Rate type used to convert the transfer price from the transaction currency to the project functional currency. | |
| PROJFUNC_TP_RATE_DATE | DATE | Rate date used to convert the transfer price from the transaction currency to the project functional currency. | ||
| GL_PERIOD_NAME | VARCHAR2 | (15) | The GL period in which the transaction is posted. | |
| PA_PERIOD_NAME | VARCHAR2 | (15) | The PA period in which the transaction is posted. | |
| PROJECT_TP_CURRENCY_CODE | VARCHAR2 | (15) | Project Currency code | |
| PROJECT_TP_RATE_DATE | DATE | Rate date used to convert the transfer price from the transaction currency to the project currency. | ||
| PROJECT_TP_RATE_TYPE | VARCHAR2 | (30) | Rate type used to convert the transfer price from the transaction currency to the project currency. | |
| PROJECT_TP_EXCHANGE_RATE | NUMBER | Exchange rate used to convert the transfer price from the transaction the currency to project currency. | ||
| PROJECT_TRANSFER_PRICE | NUMBER | Transfer price in project currency | ||
| PROJFUNC_TP_CURRENCY_CODE | VARCHAR2 | (15) | Project functional Currency. | |
| ACCT_EVENT_ID | NUMBER | (15) | ||
| ACCT_SOURCE_CODE | VARCHAR2 | (10) |
Cut, paste (and edit) the following text to query this object:
SELECT PURGE_BATCH_ID
, PURGE_RELEASE
, PURGE_PROJECT_ID
, CC_DIST_LINE_ID
, EXPENDITURE_ITEM_ID
, LINE_NUM
, LINE_TYPE
, CROSS_CHARGE_CODE
, ACCT_CURRENCY_CODE
, AMOUNT
, PROJECT_ID
, TASK_ID
, REQUEST_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ORG_ID
, LINE_NUM_REVERSED
, DIST_LINE_ID_REVERSED
, REVERSED_FLAG
, DENOM_TP_CURRENCY_CODE
, DENOM_TRANSFER_PRICE
, ACCT_TP_RATE_TYPE
, ACCT_TP_RATE_DATE
, ACCT_TP_EXCHANGE_RATE
, DR_CODE_COMBINATION_ID
, CR_CODE_COMBINATION_ID
, PA_DATE
, GL_DATE
, GL_BATCH_NAME
, TRANSFER_STATUS_CODE
, TRANSFERRED_DATE
, TRANSFER_REJECTION_CODE
, MARKUP_CALC_BASE_CODE
, IND_COMPILED_SET_ID
, BILL_RATE
, TP_BASE_AMOUNT
, BILL_MARKUP_PERCENTAGE
, SCHEDULE_LINE_PERCENTAGE
, RULE_PERCENTAGE
, REFERENCE_1
, REFERENCE_2
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REFERENCE_3
, TP_JOB_ID
, PROJFUNC_TP_EXCHANGE_RATE
, PROJFUNC_TRANSFER_PRICE
, TP_AMT_TYPE_CODE
, PROJFUNC_TP_RATE_TYPE
, PROJFUNC_TP_RATE_DATE
, GL_PERIOD_NAME
, PA_PERIOD_NAME
, PROJECT_TP_CURRENCY_CODE
, PROJECT_TP_RATE_DATE
, PROJECT_TP_RATE_TYPE
, PROJECT_TP_EXCHANGE_RATE
, PROJECT_TRANSFER_PRICE
, PROJFUNC_TP_CURRENCY_CODE
, ACCT_EVENT_ID
, ACCT_SOURCE_CODE
FROM PA.PA_CC_DIST_LINES_AR;
PA.PA_CC_DIST_LINES_AR does not reference any database object
PA.PA_CC_DIST_LINES_AR is referenced by following:
APPS
PA_CC_DIST_LINES_AR
|
|
|
|