CST_WO_EST_COST_SERVICE_OUT_GT

Global temporary table used in the processing of work order cost service requests. This is the output table where the costs of components and resources at the operation level are captured.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
CST_WO_COST_SERVICE_ID	NUMBER		18	Yes	Indicates the unique identifier for the work order component and resource cost request.
OPERATION_SEQ_NUMBER	NUMBER				This is the user defined key for the order of the operations within the work order.
OPERATION_NAME	VARCHAR2	120			Represents the translatable name for the work order operation.
ITEM_NUMBER	VARCHAR2	300			Item number of the component required on a work order operation.
INVENTORY_ITEM_ID	NUMBER		18		Item identifier of the component required on a work order operation.
INVENTORY_ORG_ID	NUMBER		18		The organization identifier that represents the manufacturing plant to which this operation material or resource belongs.
RESOURCE_NAME	VARCHAR2	120			Indicates the name of the resource defined in the work order.
RESOURCE_CODE	VARCHAR2	30			Represents the user key of the resource defined in the work order.
RESOURCE_ID	NUMBER		18		Represents the internal identifier to the resource which is a foreign key to the WIS_RESOURCES_B table.
QUANTITY	NUMBER				For Component: Quantity of the material either consumed in the operation or produced from the operation. This is usually the work order quantity times the QUANTITY_PER_ASSEMBLY when the basis type is VARIABLE. For Resource: Represents the total required usage for the resource based on the basis type, usage rate, and work order quantity. It is the usage per assembly unit (variable basis) or the usage per work order (fixed basis). For example, assuming usage rate = 1 hour and work order quantity = 10: If Basis = Variable, then required usage = 1 * 10 = 10 hours If Basis = Fixed, then required usage = 1 hour
UNIT_COST	NUMBER				Unit Cost for component or resource defined in the work order.
TOTAL_COST	NUMBER				Total cost for each component or resource defined in the work order at operation level.
CURRENCY_CODE	VARCHAR2	15			Currency code of the component or resource cost.
UOM_CODE	VARCHAR2	3			Represents the unit of measure code of the specified component quantity or resource usage.
UOM_NAME	VARCHAR2	25			Represents the unit of measure name of the specified component quantity or resource usage.
MESSAGE	VARCHAR2	512			Indicates the error details if cost is not fetched.

Indexes

Index	Uniqueness	Columns
CST_WO_EST_COST_SERVICE_OUT_U1	Unique	CST_WO_COST_SERVICE_ID