This table stores the smallest categorized expenditure units charged to projects and tasks.
Module: Project Costing
EXPENDITURE_ITEM_ID
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. |
Copyright © 2019, 2022, Oracle and/or its affiliates.