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