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
| 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