CST_WO_COST_SUMMARY
This table contains total input cost, output cost, variance cost, scrap costs at each cost organization, cost book and work order level for discrete, process and flow manufacturing work orders.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: DEFAULT
Primary Key
| Name | Columns |
|---|---|
|
CST_WO_COST_SUMMARY_PK |
CST_WO_COST_SUMMARY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CST_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. | |
| WORK_ORDER_NUMBER | VARCHAR2 | 120 | Yes | Work order number in manufacturing. The uniqueness of which will be controlled by user at the work method level or at the plant level. | |
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Surrogate ID identifying the work order in the source system. Manufacturing work order ID. | |
| PRIMARY_BOOK_FLAG | VARCHAR2 | 1 | Yes | Identifies if the Cost Book has been associated with Primary/Secondary Ledger or its Ledger less book. | |
| WORK_ORDER_STATUS_ID | NUMBER | 18 | Yes | 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 | Yes | The work method that will be used to execute the work order. The Master table for which is WIS_WORK_METHODS_B/TL. | |
| WORK_DEFINITION_ID | NUMBER | 18 | Surrogate ID identifying the work definition associated to the work order. | ||
| WORK_DEFINITION_VERSION_NUM | VARCHAR2 | 10 | Indicates the version of the work definition. | ||
| CLOSE_PROCESSING_PENDING_FLAG | VARCHAR2 | 1 | Indicates if the closed work order is having unprocessed transactions. | ||
| 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". | ||
| CONTAINS_OP_YIELD_OPERATION | VARCHAR2 | 1 | Indicates if the work order has at least one operation with operation yield factor not equal to 1. Possible values are Y, NULL. | ||
| 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 | Yes | 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. | ||
| 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. | |||
| PRIMARY_OUTPUT_COST | NUMBER | Total cost of the primary output item of the work order. | |||
| OUTPUT_COST_PER_UNIT | NUMBER | Per unit output cost for the work order. | |||
| WIP_BALANCE | NUMBER | Balance in work in process for the selected work order. | |||
| SCRAP_IN_INVENTORY_COST | NUMBER | Scrap cost absorbed in inventory for the work order. | |||
| SCRAP_EXPENSE_COST | NUMBER | Scrap expense cost for the work order. | |||
| VARIANCE_COST | NUMBER | Total value of variances reported for the work order. | |||
| VARIANCE_PERCENT | NUMBER | Total variance reported as a percentage of the total cost for the work order. | |||
| SCRAP_PERCENT | NUMBER | Scrap value reported as a percentage of the total cost for the work order. | |||
| 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_WO_COST_SUMMARY_N1 | Non Unique | DEFAULT | COST_ORG_ID, PRIMARY_BOOK_FLAG, RELEASED_DATE |
| CST_WO_COST_SUMMARY_N2 | Non Unique | DEFAULT | INVENTORY_ORGANIZATION_ID, CLOSED_DATE |
| CST_WO_COST_SUMMARY_N3 | Non Unique | DEFAULT | WORK_ORDER_NUMBER, WORK_ORDER_STATUS_ID |
| CST_WO_COST_SUMMARY_N4 | Non Unique | DEFAULT | INVENTORY_ORGANIZATION_ID, WORK_METHOD_ID, RELEASED_DATE |
| CST_WO_COST_SUMMARY_U1 | Unique | DEFAULT | CST_WO_COST_SUMMARY_ID |
| CST_WO_COST_SUMMARY_U2 | Unique | DEFAULT | COST_ORG_ID, COST_BOOK_ID, CST_WORK_ORDER_ID |