DW_PROJECT_EVENT_TYPE_D

This table stores the implementation-defined classification of events that determine how Oracle Projects processes revenue and invoices events

Details

Module: Project Control

Key Columns

EVENT_TYPE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
EVENT_TYPE_ID NUMBER 38 0 True Unique identifier for the event type
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. System generated Unique Identifier.
START_DATE_ACTIVE DATE First effective date of the event type
END_DATE_ACTIVE DATE Last effective date of the event type
REVENUE_FLAG VARCHAR2 16 Revenue Flag
INVOICE_FLAG VARCHAR2 16 Invoice Flag
REVENUE_CATEGORY_CODE VARCHAR2 32 The revenue category to which event type belongs.
ALLOW_ADJUSTMENT_FLAG VARCHAR2 16 Indicates if the events created using this event type can be adjusted.
ALLOW_ITEM_FLAG VARCHAR2 16 Indicates if the event for this event type can be created as non-item based or item based.