CST_ATTR_ONHAND_SUMMARY_I

Details

Schema: FUSION
Object owner: CST
Object type: TABLE
Tablespace: Default

Primary Key

Name	Columns
CST_ATTR_ONHAND_SUM_I_GT_PK	VALUATION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
VALUATION_ID	NUMBER		18	Yes	Surrogate key that identifies a row in this table.
PRIOR_VALUATION_ID	NUMBER		18		Identifies the prior period valuation row in this table.
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.
VAL_UNIT_ID	NUMBER		18		Identifier for the valuation unit.
INVENTORY_ORG_ID	NUMBER		18		Indicates the inventory organization to which the item belongs.
SUBINVENTORY_CODE	VARCHAR2	10			Indicates the subinventory code where the item is stored.
PERIOD_NAME	VARCHAR2	15			Indicates the period in which the valuation exists.
PERIOD_START_DATE	DATE				Indicates the start date of the period.
PERIOD_END_DATE	DATE				Indicates the end date of the period.
COST_METHOD_CODE	VARCHAR2	30			Indicates the cost method code of the valuation record.
STANDARD_COST	NUMBER				Standard cost, if the valuation is for standard cost method.
VU_UNIT_COST	NUMBER				Indicates the unit cost at the valuation unit level.
PERP_AVERAGE_COST	NUMBER				Perpetual average cost, if the valuation is for perpetual average cost method.
PERIODIC_AVG_COST	NUMBER				Periodic average cost, if the valuation is for periodic average cost method.
QUANTITY_ONHAND	NUMBER				Indicates the quantity onhand for the period.
AMOUNT	NUMBER				The inventory value of the item for the onhand quantity.
WRITEOFF_AMOUNT	NUMBER				Quantity onhand amount that is in write-off instead of inventory.
ACCTD_AMOUNT	NUMBER				Amount that is final accounted.
ACCTD_WRITEOFF_AMOUNT	NUMBER				Amount in write-off that should be in inventory and is final accounted.
PRIOR_PERIOD_NAME	VARCHAR2	15			Indicates the prior period in which the valuation exists.
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_VU_UNIT_COST	NUMBER				Indicates the prior period unit cost at the valuation unit level.
PRIOR_STANDARD_COST	NUMBER				Prior standard cost, if the valuation is for standard cost method.
PRIOR_PERP_AVERAGE_COST	NUMBER				Prior perpetual average cost, if the valuation is for perpetual average cost method.
PRIOR_PERIODIC_AVG_COST	NUMBER				Prior periodic average cost, if the valuation is for periodic average cost method.
PRIOR_QUANTITY_ONHAND	NUMBER				Prior quantity onhand for the prior period.
PRIOR_COSTED_AMOUNT	NUMBER				Indicates the costed amount of the item for the prior period.
PRIOR_COSTED_WRITEOFF_AMOUNT	NUMBER				Indicates the costed amount in write-off instead of inventory for the prior period.
PRIOR_ACCTD_AMOUNT	NUMBER				Indicates the amount that is final accounted for the prior period.
PRIOR_ACCTD_WRITEOFF_AMOUNT	NUMBER				Indicates the amount in write-off that should be in inventory and is final accounted for the prior period.

Indexes

Index	Uniqueness	Columns
CST_ATTR_ONHAND_SUM_I_GT_N1	Non Unique	PRIOR_VALUATION_ID
CST_ATTR_ONHAND_SUM_I_GT_U1	Unique	VALUATION_ID