CST_AS_OF_DATE_INV_VAL_GT

This temporary table contains inventory valuation with quantities for a combination of cost organization, cost book, valuation unit and item as of a specific date.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
COST_ORG_ID	NUMBER		18		Single column FK: Identifies the Cost Organization associated with the inventory organization.
COST_BOOK_ID	NUMBER		18		Single column FK: Identifies the Cost Book assigned to the Cost Organization.
COST_ORG_NAME	VARCHAR2	240			Denotes the translated name for the Cost Organization Unit.
COST_BOOK_CODE	VARCHAR2	30			A unique code given for a particular cost book. Usually named to indicate the purpose of that cost book.
PERIOD_START_DATE	DATE			Yes	Indicates the start date of the period.
PERIOD_END_DATE	DATE			Yes	Indicates the end date of the period.
PERIOD_NAME	VARCHAR2	15		Yes	Period for which the valuation data exist.
PRIOR_PERIOD_START_DATE	DATE				Indicates the start date of the prior period.
PRIOR_PERIOD_END_DATE	DATE				Indicates the end date of the prior period.
PRIOR_PERIOD_NAME	VARCHAR2	15			Indicates the prior period applicable for the valuation data.
INVENTORY_ITEM_ID	NUMBER		18		Identifier for the inventory item.
ITEM_NUMBER	VARCHAR2	300			Item number for the valuation data record.
ITEM_DESCRIPTION	VARCHAR2	240			Item description for the valuation data record.
ITEM_CATEGORY_CODE	VARCHAR2	820			A unique identification assigned to an item class which can be easily associated with the UNSPC category.
ITEM_CATEGORY_NAME	VARCHAR2	250			Translatable name of the category.
VAL_UNIT_ID	NUMBER		18		Identifier for the valuation unit.
VAL_UNIT_CODE	VARCHAR2	1000			Indicates the valuation unit code of the record.
UNIT_COST	NUMBER			Yes	The unit cost of the item at the valuation unit level.
QUANTITY	NUMBER			Yes	Onhand quantity at the valuation unit level for the as of date.
PRIOR_QUANTITY	NUMBER			Yes	Quantity onhand for the prior period.
INVENTORY_VALUE	NUMBER			Yes	Indicates as of date inventory valuation.
PRIOR_INVENTORY_VALUE	NUMBER			Yes	Indicates the inventory valuation for the prior period.
PERIOD_ACTIVITY_QUANTITY	NUMBER			Yes	Indicates the as of date period activity quantity.
PERIOD_ACTIVITY_VALUE	NUMBER			Yes	Indicates as of date period activity inventory value.
PERIOD_COSTED_VALUE	NUMBER			Yes	Indicates as of date period costed amount of the item.
PERIOD_ACCOUNTED_VALUE	NUMBER			Yes	Indicates the amount that is final accounted for the period as of date.
UOM_CODE	VARCHAR2	3			Unit of measure of the quantities.
UNIT_OF_MEASURE	VARCHAR2	25			Translatable Unit of Measure (UOM) name.
COST_METHOD_CODE	VARCHAR2	30		Yes	The cost method code like PERPETUAL AVERAGE, FIFO.
VAL_UNIT_TYPE	VARCHAR2	30		Yes	Indicates the valuation structure type.
INVENTORY_ORG_ID	NUMBER		18		Indicates the inventory organization id to which the item belongs.
INV_ORG_NAME	VARCHAR2	240			Indicates the inventory organization name to which the item belongs.
SUBINVENTORY_CODE	VARCHAR2	10			The subinventory code where the item is stored.
CURRENCY_CODE	VARCHAR2	30			Identifies the currency of the cost.
PRIOR_UNIT_COST	NUMBER				The prior period unit cost of the item at the valuation unit level.