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, 2024, Oracle and/or its affiliates.