CST_ONHAND_DAILY_GT

This table contains datewise snapshots of Inventory item onhand quantity within a valuation unit. Purpose of this data is to provide the information using BI reports or analytical dashboards.

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	Identifies the Cost Organization associated with the inventory organization.
COST_BOOK_ID	NUMBER		18	Yes	Identifies the Cost Book assigned to the Cost Organization.
VAL_UNIT_ID	NUMBER		18	Yes	Valuation unit identifier.
INVENTORY_ITEM_ID	NUMBER		18	Yes	Inventory Item Identifier.
BUSINESS_UNIT_ID	NUMBER		18	Yes	Business Unit Id of the Inventory Organization.
SNAPSHOT_DATE	DATE			Yes	Identifies the date of snapshot of On-hand Inventory and cost taken for OBIA/OTBI usage
EFF_TO_DATE	DATE				Identifies the date effectivity. The information in the row is valid upto this date.
INVENTORY_ORG_ID	NUMBER		18	Yes	INVENTORY_ORG_ID
SUBINVENTORY_CODE	VARCHAR2	10			The subinventory code where the item is stored
LOCATOR_ID	NUMBER		18		Inventory locator identifier
QUANTITY	NUMBER				Quantity Onhand.
UOM_CODE	VARCHAR2	3			Unit of Measure
UNIT_COST	NUMBER				Unit Cost - used for interim calculations.
AMOUNT	NUMBER				Amount.
CURRENCY_CODE	VARCHAR2	30			Identifies the currency of the transaction / cost.
PK_INDEX	VARCHAR2	256			PK_INDEX
VAL_STRUCTURE_TYPE_CODE	VARCHAR2	30			Valuation Struture Type.
POSTED_FLAG	VARCHAR2	5		Yes	POSTED_FLAG

Indexes

Index	Uniqueness	Columns
CST_ONHAND_DAILY_GT_U1	Unique	COST_ORG_ID, COST_BOOK_ID, VAL_UNIT_ID, INVENTORY_ITEM_ID, SNAPSHOT_DATE, INVENTORY_ORG_ID, SUBINVENTORY_CODE, LOCATOR_ID