# DW_PROJECT_ASSET_ASSIGNMENT_D

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 |  |  | This column is for Oracle Internal use only. 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, 2026, Oracle and/or its affiliates.