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 This column is for Oracle Internal use only. 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.
BILLABLE_FLAG VARCHAR2 16 Flag that indicates if the item can accrue revenue.
CAPITALIZABLE_FLAG VARCHAR2 16 A separate flag for capitalizable as separate from billable, since capital projects can now be billed.