DW_PROJECT_EXPENDITURE_TYPE_D

This table stores the classifications of expenditures charged to projects and tasks.

Details

Module: Project Costing

Key Columns

EXPENDITURE_TYPE_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
EXPENDITURE_TYPE_ID NUMBER 38 0 True Unique Identifier for the Expenditure Types
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. System generated Unique Identifier.
EXPENDITURE_CATEGORY_ID NUMBER 38 0 Unique identifier for Expenditure Categories.
REVENUE_CATEGORY_CODE VARCHAR2 32 The revenue category that classifies the expenditure type into a revenue group
UNIT_OF_MEASURE VARCHAR2 32 The unit by which to measure amounts entered for the expenditure type
START_DATE_ACTIVE DATE First effective date of the expenditure type
END_DATE_ACTIVE DATE Last effective date of the expenditure type