CST_WO_COST_SUMMARY_S_GT

This table is used to temporarily store a subset of the data from cst_work_order_costs table for internal processing of work order cost summary program.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
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.
ASSET_ID	NUMBER		18		Represents the unique identifier of the asset that is being maintained on this work order.
EXTERNAL_SYSTEM_REF_ID	VARCHAR2	30		Yes	Unqiue identifier of the work order in the source system. Manufacturing work order ID.
ASSET_NUMBER	VARCHAR2	80			An user identifier for the asset object.
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.
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.
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.
INVENTORY_ASSET_FLAG	VARCHAR2	1			Indicates whether the end item on the work order is asset or expense.
RELEASED_DATE	TIMESTAMP				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	Yes	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.
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.
OUTPUT_QUANTITY	NUMBER				Output quantity reported in the work order.
INPUT_COST	NUMBER				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.
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.
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.

Indexes

Index	Uniqueness	Columns
CST_WO_COST_SUMMARY_S_GT_N1	Non Unique	COST_ORG_ID, COST_BOOK_ID, CST_WORK_ORDER_ID, ASSET_ID
CST_WO_COST_SUMMARY_S_GT_N2	Non Unique	COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID