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