# DW_CST_WORK_ORDER_COST_DETAILS_CF (Preview)

This table requires activation of Work Order Costing functional area. This table stores information about work order costs

## Details

Module: Cost Management

## Key Columns

WORK_ORDER_COST_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
WORK_ORDER_COST_ID | NUMBER | 38 | 0 | True | The unique identifier of work order costs record |  |
SOURCE_RECORD_ID | VARCHAR2 | 64 |  |  | This column is for Oracle Internal use only. System Generated |  |
COST_ORG_ID | NUMBER | 38 | 0 |  | Cost Org identifier | DW_CST_COST_ORG_BOOKS_D | COST_ORG_ID
COST_BOOK_ID | NUMBER | 38 | 0 |  | Cost Book identifier | DW_CST_COST_ORG_BOOKS_D | COST_BOOK_ID
COST_ORG_BOOK_LEGAL_ENTITY_ID | NUMBER | 38 | 0 |  | Legal entity Identifier corresponding to the cost organization and cost book. | DW_LEGAL_ENTITY_D | LEGAL_ENTITY_ID
COST_ORG_BOOK_LEDGER_ID | NUMBER | 38 | 0 |  | Ledger identifier corresponding to the cost organization and cost book. | DW_LEDGER_D | LEDGER_ID
FISCAL_PERIOD_TYPE | VARCHAR2 | 16 |  |  | Fiscal Period type. Examples are Weekly, Monthly, Quarterly #2 | DW_FISCAL_DAY_D | FISCAL_PERIOD_TYPE
FISCAL_PERIOD_SET_NAME | VARCHAR2 | 16 |  |  | Fiscal Period Set Name #2 | DW_FISCAL_DAY_D | FISCAL_PERIOD_SET_NAME
CST_WORK_ORDER_ID | NUMBER | 38 | 0 |  | Unique identifier for a work order in costing |  |
WORK_ORDER_ID | NUMBER | 38 | 0 |  | Unique identifier for a work order |  |
WORK_ORDER_NUMBER | VARCHAR2 | 128 |  |  | Represents the user-facing identifier of the work order. |  |
INVENTORY_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Unique identifier for Manufacturing Organization in which the work order is created. | DW_INTERNAL_ORG_D | ORGANIZATION_ID
INV_ORG_BUSINESS_UNIT_ID | NUMBER | 38 | 0 |  | Business unit for the Manufacturing Organization | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
INV_ORG_PROFIT_CENTER_BU_ID | NUMBER | 38 | 0 |  | Profit Center Business unit for the Manufacturing Organization | DW_BUSINESS_UNIT_D | BUSINESS_UNIT_ID
PRIMARY_OUTPUT_ITEM_ID | NUMBER | 38 | 0 |  | Primary Product that needs to be manufactured #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
WORK_METHOD_ID | NUMBER | 38 | 0 |  | Work method identifier that is used to execute the work order | DW_MFG_WORK_METHODS_TL | WORK_METHOD_ID
WORK_METHOD_CODE | VARCHAR2 | 32 |  |  | Work method code that is used to execute the work order |  |
WORK_ORDER_TYPE_CODE | VARCHAR2 | 32 |  |  | Indicates the type of this work order. | DW_ORA_WIE_WO_TYPE_LKP_TL | ORA_WIE_WO_TYPE_CODE
WORK_ORDER_SUB_TYPE_CODE | VARCHAR2 | 32 |  |  | The subtype specifically will be populated for non-standard work. This is used to derive the appropriate costing account for non-standard work. | DW_ORA_WIE_WO_SUB_TYPE_LKP_TL | ORA_WIE_WO_SUB_TYPE_CODE
WORK_DEFINITION_ID | NUMBER | 38 | 0 |  | Unique identifier to the work definition |  |
WORK_DEFINITION_VERSION_ID | NUMBER | 38 | 0 |  | Work definition version identifier |  |
WORK_ORDER_STATUS_ID | NUMBER | 38 | 0 |  | Represents the internal identifier of the user-defined status of the work order. | DW_MFG_STATUSES_TL | WO_STATUS_ID
WORK_ORDER_SYSTEM_STATUS_CODE | VARCHAR2 | 32 |  |  | Represents the system status code for a given work order status. | DW_ORA_WIE_WO_SYSTEM_STATUS_LKP_TL | ORA_WIE_WO_SYSTEM_STATUS_CODE
RELEASED_TIMESTAMP | TIMESTAMP |  |  |  | Date when the work order is released, with timestamp |  |
RELEASED_DATE | DATE |  |  |  | Date when the work order is released, without timestamp | DW_DAY_D | CALENDAR_DATE
COMPLETION_TIMESTAMP | TIMESTAMP |  |  |  | Completion date of the work order with timestamp |  |
COMPLETION_DATE | DATE |  |  |  | Completion date of the work order without timestamp | DW_DAY_D | CALENDAR_DATE
CLOSED_TIMESTAMP | TIMESTAMP |  |  |  | Date when the work order is closed, with timestamp |  |
CLOSED_DATE | DATE |  |  |  | Date when the work order is closed, without timestamp | DW_DAY_D | CALENDAR_DATE
CONTRACT_MFG_FLAG | VARCHAR2 | 16 |  |  | Flag that Indicates if this work order is meant for contract manufacturing | DW_YN_LKP_TL | YN_LKP_CODE
PJC_PROJECT_ID | NUMBER | 38 | 0 |  | Identifier of the project used for project-related transaction distributions | DW_PROJECT_D | PROJECT_ID
PJC_TASK_ID | NUMBER | 38 | 0 |  | Identifier of the task used for project-related transaction distributions | DW_PROJECT_ELEMENT_D | PROJ_ELEMENT_ID
PJC_EXPENDITURE_TYPE_ID | NUMBER | 38 | 0 |  | Identifier of the expenditure type used for project-related transaction distributions | DW_PROJECT_EXPENDITURE_TYPE_D | EXPENDITURE_TYPE_ID
PJC_EXPENDITURE_ITEM_DATE | DATE |  |  |  | Date on which a project-related transaction is incurred. | DW_DAY_D | CALENDAR_DATE
PJC_ORGANIZATION_ID | NUMBER | 38 | 0 |  | Identifier of the expenditure organization used for project-related transaction distributions | DW_INTERNAL_ORG_D | ORGANIZATION_ID
CST_WORK_ORDER_OPERATION_ID | NUMBER | 38 | 0 |  | Unique identifier for the work order operation in costing |  |
WORK_ORDER_OPERATION_ID | NUMBER | 38 | 0 |  | Unique identifier for a work order operation |  |
OPERATION_SEQ_NUMBER | NUMBER |  |  |  | Operation sequence number |  |
OPERATION_TYPE_CODE | VARCHAR2 | 32 |  |  | Specifies the type of the operation. | DW_ORA_WIS_OPERATION_TYPE_LKP_TL | ORA_WIS_OPERATION_TYPE_CODE
WORK_CENTER_ID | NUMBER | 38 | 0 |  | Indicates the work center where this operation is executed. | DW_MFG_WORK_CENTERS_D | WORK_CENTER_ID
WORK_AREA_ID | NUMBER | 38 | 0 |  | Indicates the work area where this operation is executed. | DW_MFG_WORK_AREAS_D | WORK_AREA_ID
OSP_ITEM_ID | NUMBER | 38 | 0 |  | Item that represents the value added service in a supplier operation #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
INVENTORY_ITEM_ID | NUMBER | 38 | 0 |  | Unique identifier for inventory item associated with the WIP inventory transaction. #1 | DW_INVENTORY_ITEM_D | INVENTORY_ITEM_ID
RESOURCE_ID | NUMBER | 38 | 0 |  | Unique identifier for resource associated with the WIP inventory transaction. | DW_MFG_RESOURCES_D | RESOURCE_ID
RESOURCE_TYPE_CODE | VARCHAR2 | 32 |  |  | Type of Resource, Labor or Equipment | DW_ORA_WIS_RESOURCE_TYPE_LKP_TL | ORA_WIS_RESOURCE_TYPE_CODE
WIP_COST_TYPE | VARCHAR2 | 32 |  |  | Indicates the type of cost that is captured. |  |
COST_ELEMENT_ID | NUMBER | 38 | 0 |  | Unique identifier for cost element against which the cost is captured. | DW_CST_COST_ELEMENTS_D | COST_ELEMENT_ID
EXPENSE_POOL_ID | NUMBER | 38 | 0 |  | Unique identifier for expense pool against which the cost is captured. | DW_CST_EXPENSE_POOLS_D | EXPENSE_POOL_ID
COST_TIMESTAMP | TIMESTAMP |  |  |  | Cost date with timestamp of the inventory/resource transaction. |  |
COST_DATE | DATE |  |  |  | Cost date without timestamp of the inventory/resource transaction. | DW_DAY_D | CALENDAR_DATE
COSTING_TRANSACTION_ID | NUMBER | 38 | 0 |  | Unique identifier for Costing Transactions |  |
UOM_CODE | VARCHAR2 | 16 |  |  | The unit of measure on the corresponding transaction. | DW_UNIT_OF_MEASURE_D_TL | UOM_CODE
QUANTITY | NUMBER |  |  |  | The quantity recorded on the inventory/resource transaction. |  |
CURRENCY_CODE | VARCHAR2 | 16 |  |  | Currency code in which the cost is recorded. | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
UNIT_COST | NUMBER |  |  |  | The unit cost recorded at cost element, expense pool level. |  |
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 |  |  | Analytics currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE
GLOBAL_CURRENCY_EXCH_RATE | NUMBER |  |  |  | Transaction to Analytics currency exchange rate |  |
GLOBAL_UNIT_COST | NUMBER |  |  |  | The unit cost in Analytics currency recorded at cost element, expense pool level. |  |
WIP_TXN_SIGN | NUMBER | 38 | 0 |  | Indicates if the cost row is to be added or subtracted from the total WIP cost. |  |
ABSORPTION_TYPE_CODE | VARCHAR2 | 32 |  |  | Indicates whether the cost needs to be included in total WIP value or Expensed. | DW_CST_ABSORPTION_TYPE_LKP_TL | CST_ABSORPTION_TYPE_CODE
CREATION_TIMESTAMP | TIMESTAMP |  |  |  | Indicates the date and time of the creation of the row. |  |
LAST_UPDATE_TIMESTAMP | TIMESTAMP |  |  |  | Indicates the date and time of the last update of the row. |  |

## Notes

#1 In these cases in addition to the item column INVENTORY_ORGANIZATION_ID column should also be used for join with DW_INVENTORY_ITEM_D #2 In these cases to join with DW_FISCAL_DAY_D apart from FISCAL_PERIOD_TYPE and FISCAL_PERIOD_SET_NAME the relationship should be based on RELEASED_DATE column

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