# DW_PROJECT_ASSET_LINE_UNTRNSFRD_CF (Preview)

This table requires activation of Project Asset functional area. This table stores summarized project CIP cost lines. It contains only pending asset lines.

## Details

Module: Project Costing

## Key Columns

PROJECT_ASSET_LINE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
PROJECT_ASSET_LINE_ID | NUMBER | 38 | 0 | True | Unique Identifier for Asset Line |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. System |  |
PROJECT_ASSET_ID | NUMBER | 38 | 0 |  | The identifier of the asset assigned to the line; value is 0 on unassigned lines |  |
PROJECT_ID | NUMBER | 38 | 0 |  | The identifier of the project to which the CIP cost was charged | DW_PROJECT_D | PROJECT_ID
TASK_ID | NUMBER | 38 | 0 |  | The identifier of the task against which the CIP cost is charged | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
ASSET_CATEGORY_ID | NUMBER | 38 | 0 |  | Asset category derived from inventory item on lines with supplier invoice cost |  |
PROJECT_ASSET_LINE_DETAIL_ID | NUMBER | 38 | 0 |  | Identifier of the asset line details linking this line to cost distribution lines |  |
PROJECT_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Project business unit identifier | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
PROJECT_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Legal entity assigned to the project. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
PROJECT_UNIT_ID | NUMBER | 38 | 0 |  | Project unit assigned to the project. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
PROJECT_LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity assigned to the project. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
PROJECT_LEDGER_ID | NUMBER | 38 | 0 |  | Ledger identifier of Project | DW_LEDGER_D | LEDGER_ID
CIP_CCID | NUMBER | 38 | 0 |  | The identifier of the GL account to which CIP cost is charged |  |
ORIGINAL_ASSET_COST | NUMBER |  |  |  | The cost amount of the line at the time the line was originally created |  |
CURRENT_ASSET_COST | NUMBER |  |  |  | The line's current cost amount; split lines have a current cost <> original cost |  |
SPLIT_PERCENTAGE | NUMBER |  |  |  | Split percentage. |  |
LEDGER_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Ledger currency of the project. |  |
FA_PERIOD_NAME | VARCHAR2 | 16 |  |  | Asset book depreciation calendar period name to which the asset cost was posted. |  |
LINE_TYPE | VARCHAR2 | 32 |  |  | Asset Line Classification. Available values are C = Capital and R = Retirement. |  |
LINE_DESCRIPTION | VARCHAR2 | 256 |  |  | Description of the asset line |  |
RETIREMENT_COST_TYPE | VARCHAR2 | 32 |  |  | Retirement Cost Classification. |  |
TRANSFER_STATUS_CODE | VARCHAR2 | 16 |  |  | Status of the asset line as the cost information is transferred to Oracle Assets |  |
TRANSFER_REJECTION_REASON | VARCHAR2 | 32 |  |  | The reason why the line was rejected by the Interface Assets program |  |
RET_ADJUSTMENT_TXN_ID | NUMBER | 38 | 0 |  | Transaction Identifier of the Group Retirement Adjustment Transaction. |  |
REV_PROJ_ASSET_LINE_ID | NUMBER | 38 | 0 |  | The id of the asset line which is reversed by this line. |  |
CREATION_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the creation of the row. |  |
LAST_UPDATE_DATE | TIMESTAMP |  |  |  | Who column: indicates the date and time of the last update of the row. |  |
CREATED_BY | VARCHAR2 | 64 |  |  | Who column: indicates the user who created the row. |  |
GL_BALANCING_SEGMENT | VARCHAR2 | 32 |  |  | Balancing segment for the ledger. | DW_BALANCING_SEGMENT_D | GL_BALANCING_SEGMENT
GL_BLNC_SGMNT_VALUESET_CODE | VARCHAR2 | 64 |  |  | Balancing segment value set code. | DW_BALANCING_SEGMENT_D | GL_BLNC_SGMNT_VALUESET_CODE
COST_CENTER_SEGMENT | VARCHAR2 | 32 |  |  | Cost center segment. | DW_COST_CENTER_D | COST_CENTER_SEGMENT
COST_CENTER_VALUESET_CODE | VARCHAR2 | 64 |  |  | Cost center value set code. | DW_COST_CENTER_D | COST_CENTER_VALUESET_CODE
NATURAL_ACCOUNT_SEGMENT | VARCHAR2 | 32 |  |  | Natural account segment. | DW_NATURAL_ACCOUNT_D | NATURAL_ACCOUNT_SEGMENT
NTRL_ACNT_SGMNT_VALUESET_CODE | VARCHAR2 | 64 |  |  | Natural account value set code. | DW_NATURAL_ACCOUNT_D | NTRL_ACNT_SGMNT_VALUESET_CODE
GL_SEGMENT1 | VARCHAR2 | 32 |  |  | Accounting segment 1. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT1_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 1 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT2 | VARCHAR2 | 32 |  |  | Accounting segment 2. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT2_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 2 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT3 | VARCHAR2 | 32 |  |  | Accounting segment 3. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT3_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 3 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT4 | VARCHAR2 | 32 |  |  | Accounting segment 4. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT4_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 4 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT5 | VARCHAR2 | 32 |  |  | Accounting segment 5. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT5_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 5 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT6 | VARCHAR2 | 32 |  |  | Accounting segment 6. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT6_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 6 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT7 | VARCHAR2 | 32 |  |  | Accounting segment 7. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT7_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 7 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT8 | VARCHAR2 | 32 |  |  | Accounting segment 8. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT8_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 8 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT9 | VARCHAR2 | 32 |  |  | Accounting segment 9. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT9_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 9 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
GL_SEGMENT10 | VARCHAR2 | 32 |  |  | Accounting segment 10. | DW_GL_SEGMENT_D | GL_SEGMENT_CODE
GL_SEGMENT10_VALUESET_CODE | VARCHAR2 | 64 |  |  | Accounting segment 10 value set code. | DW_GL_SEGMENT_D | GL_SEGMENT_VALUESET_CODE
CAPITAL_EVENT_ID | NUMBER | 38 | 0 |  | PjcPrjAssetLnsAllCapitalEventId |  |
DEPRECIATION_EXPENSE_CCID | NUMBER | 38 | 0 |  | The identifier of the depreciation expense account for the asset |  |
LOCATION_ID | NUMBER | 38 | 0 |  | The identifier of the location to which the asset is assigned |  |
ASSET_KEY_CCID | NUMBER | 38 | 0 |  | Key flexfield code combination identifier for asset key flexfield |  |
BOOK_TYPE_CODE | VARCHAR2 | 32 |  |  | The corporate book to which the asset is assigned |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.