DW_EXPENDITURE_ITEM_D

This table stores the smallest categorized expenditure units charged to projects and tasks.

Details

Module: Project Costing

Key Columns

EXPENDITURE_ITEM_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
EXPENDITURE_ITEM_ID NUMBER 38 0 True The system-generated number that uniquely identifies the expenditure item    
SOURCE_RECORD_ID VARCHAR2 64     System Generated    
EXPENDITURE_ENDING_DATE DATE       EXPENDITURE_ENDING_DATE    
EXPENDITURE_ITEM_DATE DATE       The date on which the work occurred    
EXPENDITURE_ORGANIZATION_ID NUMBER 38 0   EXPENDITURE_ORGANIZATION_ID for the Exp item which holds the value NVL(OVERRIDE_TO_ORGANIZATION_ID,INCURRED_BY_ORGANIZATION_ID)    
EXPENDITURE_TYPE_ID NUMBER 38 0   Identifier of the expenditure type    
PROJECT_ID NUMBER 38 0   The project_id of the event that the expenditure item is FIFO marked by    
PROJECT_UNIT_ID NUMBER 38 0   PROJECT_UNIT_ID    
QUANTITY NUMBER       The number of units of the work performed    
TASK_ID NUMBER 38 0   The identifier of the task to which the expenditure item is charged    
UNIT_OF_MEASURE VARCHAR2 32     Base unit of measure    
EXPENDITURE_COMMENT VARCHAR2 256     The free text comment entered for an expenditure item to further describe work done.