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

Copyright © 2019, 2022, Oracle and/or its affiliates.