DW_PROJECT_ASSET_ASSIGNMENT_D (Preview)

This table requires activation of Project Asset functional area. This table stored the Assest Assignment details.

Details

Module: Project Costing

Key Columns

ASSET_ASSIGNMENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ASSET_ASSIGNMENT_ID NUMBER 38 0 True Unique identifier for the asset assignment record.    
SOURCE_RECORD_ID VARCHAR2 128     System generated Unique Identifier.    
PROJECT_ASSET_ID NUMBER 38 0   The identifier of the asset; value is 0 for common cost assignments    
TASK_ID NUMBER 38 0   The identifier of the task; value is 0 on project-level assignments    
PROJECT_ID NUMBER 38 0   The identifier of the project involved in the assignment    

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