CST_ATTR_ONHAND_VALUATIONS_GT

This temporary table contains inventory valuation with quantities at the inventory attribute level and the costs at cost element level.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
VALUATION_ID	NUMBER		18		Reference to onhand valuation
VAL_DETAIL_ID	NUMBER		18		Reference to onhand valuation details
SOURCE_TABLE	VARCHAR2	30			Source of the valuation information.
COST_ORG_ID	NUMBER		18	Yes	Single column FK: Identifies the Cost Organization associated with the inventory organization.
COST_BOOK_ID	NUMBER		18	Yes	Single column FK: 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
PERIOD_NAME	VARCHAR2	15		Yes	Period in which the valuation exist.
START_DATE	DATE			Yes	Identifies the date of snapshot of On-hand Inventory and cost taken for OBIA/OTBI usage
END_DATE	DATE			Yes	Identifies the date effectivity. The information in the row is valid up to this date.
INVENTORY_ORG_ID	NUMBER		18	Yes	Indicates The Inventory Org To Which The Item Belongs
SUBINVENTORY_CODE	VARCHAR2	10		Yes	The subinventory code where the item is stored
LOCATOR_ID	NUMBER		18	Yes	Inventory locator identifier
PROJECT_ID	NUMBER		18	Yes	Project associated to the valuation
TASK_ID	NUMBER		18	Yes	Project task associated to the valuation.
COUNTRY_OF_ORIGIN_CODE	VARCHAR2	2		Yes	Country of origin associated to the valuation.
QUANTITY_ONHAND	NUMBER			Yes	Quantity Onhand for the period.
STARTING_QUANTITY	NUMBER			Yes	Beginning onhand quantity for the period.
NEW_RECEIPT_QUANTITY	NUMBER			Yes	New receipt quantity in this period.
NEW_ISSUE_QUANTITY	NUMBER			Yes	New issue quantity in this period.
UOM_CODE	VARCHAR2	3		Yes	Unit of Measure of the quantities
EXPENSE_POOL_ID	NUMBER		18		Expense Pool associated to costs and amounts
COST_ELEMENT_ID	NUMBER		18		Cost element associated to costs and amounts
AMOUNT	NUMBER			Yes	Quantity onhand amount
WRITEOFF_AMOUNT	NUMBER			Yes	Quantity onhand amount that is in write-off instead of inventory.
UNIT_COST	NUMBER			Yes	Unit of the valuation
VU_QUANTITY_ONHAND	NUMBER			Yes	Total quantity at the VU level.
VU_AMOUNT	NUMBER			Yes	Total amount at the VU level
VU_WRITEOFF_AMOUNT	NUMBER			Yes	Total amount that is in write-off instead of Inventory at the VU level.
VU_UNIT_COST	NUMBER			Yes	Unit Cost at the VU level
STANDARD_COST	NUMBER				Standard cost, if the valuation is for standard cost method.
PERP_AVERAGE_COST	NUMBER				Perpetual Average cost, if the valuation is for perpetual average cost method.
ACCTD_AMOUNT	NUMBER			Yes	Amount that is final accounted.
ACCTD_WRITEOFF_AMOUNT	NUMBER			Yes	Amount in write-off that should be in inventory and is final accounted.
EXCL_FROM_ACCTG_AMOUNT	NUMBER			Yes	Amount that is excluded from accounting.
EXCL_FROM_ACCTG_WO_AMOUNT	NUMBER			Yes	Amount in write-off that should be in inventory and is excluded from accounting.
CURRENCY_CODE	VARCHAR2	30		Yes	Identifies the currency of the transaction / cost.
COST_METHOD_CODE	VARCHAR2	30		Yes	The cost method code like PERPETUAL AVERAGE, FIFO etc. Value comes from lookup_type CST_COST_METHODS
ACTION_FLAG	VARCHAR2	1		Yes	Flag that indicates if the rows should be inserted or updated to the persistent table. Possible values are: I - Insert row. U - Update row

Indexes

Index	Uniqueness	Columns
CST_ATTR_ONHAND_VAL_GT_N1	Non Unique	ACTION_FLAG