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
| 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 |