DW_PROJECT_CAPITAL_EVENT_D (Preview)

This table requires activation of Project Asset functional area. This table stored the Capital Event details.

Details

Module: Project Costing

Key Columns

CAPITAL_EVENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
CAPITAL_EVENT_ID NUMBER 38 0 True Capital event identifier.
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. System generated Unique Identifier.
PROJECT_ID NUMBER 38 0 Identifier of the Project.
CAPITAL_EVENT_NUMBER NUMBER 38 0 Number that identifies the event within the Project.
EVENT_TYPE VARCHAR2 32 Event Classification. Values are C:Capital and R:Retirement
EVENT_NAME VARCHAR2 256 Capital Event Name
ASSET_ALLOCATION_METHOD VARCHAR2 32 Identifies the method used to allocate indirect and common costs across the assets assigned to a grouping level.
EVENT_PERIOD VARCHAR2 16 General Ledger Period associated with the event.