CST_RCL_SCR_REPORT_S_GT

This table is used to temporarily store a subset of the data from cst_rcl_cost_rec_txns table for internal processing within the Service Cost Recognition BIP Report.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TRANSACTION_ID	NUMBER		18	Yes	Transaction identifier which uniquely identifies a service cost recognition transaction in costing.
CST_TRANSACTION_ID	NUMBER		18		Stores the source transaction identifier against which the service cost recognition or service cost recognition reversal transaction is created.
COST_ORG_ID	NUMBER		18		The unique identifier for the cost organization.
COST_BOOK_ID	NUMBER		18		The unique identifier for the cost book.
INVENTORY_ORG_ID	NUMBER		18		Indicates the inventory organization to which the item belongs.
CST_WORK_ORDER_ID	NUMBER		18		The unique identifier for the work order in Costing.
INVENTORY_ITEM_ID	NUMBER		18		The unique identifier for the inventory item.
RESOURCE_ID	NUMBER		18		The unique identifier for the resource.
SUBSCRIPTION_TYPE	VARCHAR2	240			Value that indicates the subscription type.
SUBSCRIPTION_NUMBER	VARCHAR2	120			Subscription number for new subscriptions. For Migration appended by the contract modifier for renewed contracts.
RECOGNITION_PERCENTAGE	NUMBER				Percentage of the service cost recognized.
RECOGNIZED_COST	NUMBER				Indicates the recognized service cost for a WIP transaction or a maintenance work order related to the field service flow.

Indexes

Index	Uniqueness	Columns
CST_RCL_SCR_REPORT_S_GT_U1	Unique	TRANSACTION_ID