INV_AGING_ANALYSIS_DETAILS_GT

This temporary table is used for monthly aging analysis data calculations.

Details

• Schema: FUSION

• Object owner: INV

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
INV_AGING_ANALYSIS_DET_GT_PK	INVENTORY_ITEM_ID, ORGANIZATION_ID, PERIOD_START_DATE

Columns

Name	Datatype	Length	Precision	Not-null	Comments
INVENTORY_ITEM_ID	NUMBER		18	Yes	Value that identifies the inventory item.
ORGANIZATION_ID	NUMBER		18	Yes	Value that identifies the inventory organization.
ORGANIZATION_CODE	VARCHAR2	18			Code that identifies the inventory organization.
PERIOD_START_DATE	DATE			Yes	Start date of the period for which the record is created.
PERIOD_END_DATE	DATE				End date of the period for which the record is created.
PRIMARY_ONHAND_QUANTITY	NUMBER				Primary onhand quantity at the end of the period.
PRIMARY_UOM_CODE	VARCHAR2	3			Code that identifies the primary unit of measure of the inventory item.
START_DATE_ITEM_COST	NUMBER				Item cost at the start date of the period.
END_DATE_ITEM_COST	NUMBER				Item cost at the end date of the period.
COGS	NUMBER				Cost of goods sold value for the item in the organization for the given period.
CURRENCY	VARCHAR2	20			Currency in which the COGS is recorded.
WEIGHTED_AVG_INVENTORY_AGE	NUMBER				Weighted average inventory age at the end of the period.
SALES_QUANTITY	NUMBER				The quantity sold during the period, expressed in the item’s primary unit of measure.

Indexes

Index	Uniqueness	Columns
INV_AGING_ANALYSIS_DET_GT_U1	Unique	INVENTORY_ITEM_ID, ORGANIZATION_ID, PERIOD_START_DATE