1. Tables and Views for SCM
  2. CST_MNT_WO_COST_SUMMARY

CST_MNT_WO_COST_SUMMARY

This table contains total input cost, output cost, variance cost at each cost organization, cost book and work order level for maintenance work orders.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: DEFAULT

Primary Key

Name Columns

CST_MNT_WO_COST_SUMMARY_PK

CST_MNT_WO_COST_SUMMARY_ID

Columns

Name Datatype Length Precision Not-null Comments
CST_MNT_WO_COST_SUMMARY_ID NUMBER 18 Yes Surrogate key that identifies a row in this table.
COST_ORG_ID NUMBER 18 Yes Cost organization associated to the plant where the material and resources are consumed.
COST_BOOK_ID NUMBER 18 Yes Cost book associated to the cost organization.
CST_WORK_ORDER_ID NUMBER 18 Yes Unique identifier of the work order in costing.
ASSET_ID NUMBER 18 Yes Represents the unique identifier of the asset that is being maintained on this work order.
EXTERNAL_SYSTEM_REF_ID VARCHAR2 30 Yes Surrogate ID identifying the work order in the source system. Manufacturing work order ID.
WORK_ORDER_NUMBER VARCHAR2 120 Work order number in manufacturing. The uniqueness of which will be controlled by user at the work method level or at the plant level.
ASSET_NUMBER VARCHAR2 80 An user identifier for the asset object.
PRIMARY_BOOK_FLAG VARCHAR2 20 Identifies if the Cost Book has been associated with Primary/Secondary Ledger or its Ledger less book.
WORK_ORDER_STATUS_ID NUMBER 18 Work order status Identifier. Statuses are defined in a flexible user defined table. The user defined statuses will have to be defined on top of some seeded system statuses. The user defined status table is 'WIE_WO_STATUSES_B/TL'. The system statuses are seeded in the lookup type = 'WIE_WO_SYSTEM_STATUS'.
WORK_METHOD_ID NUMBER 18 The work method that will be used to execute the work order. The Master table for which is WIS_WORK_METHODS_B/TL.
ALLOW_MULTIPLE_ASSETS_FLAG VARCHAR2 1 Flag indicating that multiple assets can be associated to this maintenance work order.
COMPLETE_TO_INV_FLAG VARCHAR2 1 Flag indicating that the asset(s) involved in the work order will be completing to inventory upon completion of work.
CONTRACT_MFG_FLAG VARCHAR2 1 Indicates if this work order is meant for contract manufacturing.
WORK_ORDER_LESS_FLAG VARCHAR2 1 When products have well defined product definitions, they can be produced by means of something called work order less completions. Such completion transaction can trigger the creation of a work order and marks that with the ORDER_LESS_FLAG = "Y".
INVENTORY_ASSET_FLAG VARCHAR2 1 Indicates whether the end item on the work order is asset or expense.
WORK_ORDER_TYPE VARCHAR2 30 Based on the Work Method, this attribute further classifies the Work Order to indicate whether it is meant for either Standard or Non Standard Production. The value for which comes from a lookup_type = 'WIE_WO_TYPE'. This lookup is system defined and not alterable by the user.
WORK_ORDER_SUB_TYPE VARCHAR2 30 For a specific Work Order Type, this attribute represents the specific nature of work being performed such as Standard Production, Prototyping, or Repair. The value for which comes from a lookup_type = 'WIE_WO_SUB_TYPE'. This is a user extensible lookup.
RELEASED_DATE TIMESTAMP Yes Date when the work order is released.
CLOSED_DATE TIMESTAMP Date when the work order is closed. This value is available only when the work order is currently in closed status. If a closed work order is reopened then this value would be updated accordingly.
COMPLETION_DATE TIMESTAMP Date when the work order is completed. This value is available only when the work order is currently in closed/completed status. If a closed work order is reopened this value is updated accordingly.
INVENTORY_ORGANIZATION_ID NUMBER 18 Manufacturing organization in which the work order is created.
INVENTORY_ITEM_ID NUMBER 18 This refers to the primary product that needs to be manufactured, and can be any active item that has the "Build in WIP" flag checked at the Item Organization (Plant) level.
MNT_TRANSFORM_TO_ITEM_ID NUMBER 18 The end item that this asset will transform to upon completion of the work.
OUTPUT_QUANTITY NUMBER Output quantity reported in the work order.
COST_METHOD_CODE VARCHAR2 20 The cost method used for costing the item.
PJC_PROJECT_ID NUMBER 18 Unique identifier of the Project associated to the work order.
PJC_TASK_ID NUMBER 18 Unique identifier of the Task associated to the work order.
COUNTRY_OF_ORIGIN_CODE VARCHAR2 2 Code for the country of manufacture used to stripe Inventory transactions.
CURRENCY_CODE VARCHAR2 20 Currency code in which the cost is recorded.
INPUT_COST NUMBER Total input cost incurred for the work order.
OUTPUT_COST NUMBER Total output costs for the work order.
VARIANCE_COST NUMBER Total value of variances reported for the work order.
WIP_BALANCE NUMBER Balance in work in process for the selected work order.
TOTAL_COST NUMBER Total cost incurred for the work order (MATERIAL, RESOURCE).
MATERIAL_COST NUMBER Total cost of materials issued to the work order.
RESOURCE_COST NUMBER Total cost of resources consumed for the work order.
OVERHEAD_COST NUMBER Total overheads cost for the work order.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Indexes

Index Uniqueness Tablespace Columns
CST_MNT_WO_COST_SUMMARY_N1 Non Unique DEFAULT COST_ORG_ID, PRIMARY_BOOK_FLAG, RELEASED_DATE
CST_MNT_WO_COST_SUMMARY_N2 Non Unique DEFAULT WORK_ORDER_NUMBER, WORK_ORDER_STATUS_ID
CST_MNT_WO_COST_SUMMARY_N3 Non Unique DEFAULT INVENTORY_ORGANIZATION_ID, RELEASED_DATE
CST_MNT_WO_COST_SUMMARY_U1 Unique DEFAULT CST_MNT_WO_COST_SUMMARY_ID
CST_MNT_WO_COST_SUMMARY_U2 Unique DEFAULT COST_ORG_ID, COST_BOOK_ID, CST_WORK_ORDER_ID, ASSET_ID