CST_ITEM_COST_SERVICE_VU_GT

Global temporary table used in the bulk processing of item cost service requests. This holds valuation unit and maximum cost date for each layer for ACTUAL cost method.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Comments
COST_ORG_ID	NUMBER		18	Indicates the cost organization identifier.
COST_BOOK_ID	NUMBER		18	Indicates the cost book identifier.
INVENTORY_ITEM_ID	NUMBER		18	Indicates the inventory item identifier.
VAL_UNIT_ID	NUMBER		18	Indicates the valuation unit identifier.
REFERENCE_DATE	TIMESTAMP			Indicates the reference date. It specifies the effective date time for which to retrieve the cost. If null then the system date time is used.
COST_DATE	TIMESTAMP			Cost date used for processing transaction.
UNIT_COST	NUMBER			Current transaction cost for one quantity.
UOM_CODE	VARCHAR2	3		Indicates the target UOM code. This column is optional and can be null.
CURRENCY_CODE	VARCHAR2	15		Indicates the target currency code.

Indexes

Index	Uniqueness	Columns
CST_ITEM_COST_SERVICE_VU_GT_U1	Unique	COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, VAL_UNIT_ID