DW_PROJECT_WORK_TYPE_D

This table stores Implementation-defined work types.

Details

Module: Project Costing

Key Columns

WORK_TYPE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
WORK_TYPE_ID NUMBER 38 0 True The system generated number that uniquely identifies the work type
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System generated Unique Identifier.
BILLABLE_CAPITALIZABLE_FLAG VARCHAR2 16 Flag that indicates whether the work type is billable or capitalizable
UTILIZABLE_FLAG VARCHAR2 16 Indicates if the work type is utilizable or not.
START_DATE_ACTIVE DATE First effective date of the work type
END_DATE_ACTIVE DATE Last effective date of the work type
TP_AMT_TYPE_CODE VARCHAR2 32 Determines the classification of the cross charge amount "Cost","Revenue"