CST_DEL_ONHAND_DAILY_GT

This table contains datewise snapshots of Inventory item onhand quantity within a valuation unit - transaction level. 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.
REC_TRXN_ID	NUMBER		18	Yes	Receipt Transaction Identifier Column
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
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_DEL_ONHAND_DAILY_GT_U1	Unique	REC_TRXN_ID, SNAPSHOT_DATE