This table requires activation of Project Asset functional area. This table stores summarized project CIP cost lines.
Module: Project Costing
PROJECT_ASSET_LINE_ID
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 | 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, 2022, Oracle and/or its affiliates.