CST_VU_ONHAND_VALUATIONS

Details

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

Columns

Name	Datatype	Length	Precision	Not-null	Comments
VALUATION_ID	NUMBER		18		Surrogate key to reference the onhand valuations
VAL_DETAIL_ID	NUMBER		18		Reference to onhand valuation details
SOURCE_TABLE	VARCHAR2	30			Source table of the onhand 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	Single column FK: Identifies the Valuation unit for the onhand valuation
INVENTORY_ITEM_ID	NUMBER		18	Yes	Identifies the Inventory Item for which the onhand is maintained
PERIOD_NAME	VARCHAR2	15		Yes	Period in which the valuation exists.
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.
QUANTITY_ONHAND	NUMBER			Yes	The Onhand Quantity 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 the costs and amounts.
COST_ELEMENT_ID	NUMBER		18		Cost element associated to costs and amounts
AMOUNT	NUMBER			Yes	The amount based on the onhand quantity
WRITEOFF_AMOUNT	NUMBER			Yes	Quantity onhand amount that is in write-off instead of inventory.
UNIT_COST	NUMBER			Yes	Unit cost for the onhand valuation
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	Onhand Valuation 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.
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
REC_TRXN_ID	NUMBER		18		Identifies the receipt for layer valuation.
TXN_SOURCE_REF_DOC_NUMBER	VARCHAR2	240			Transactions Source Documents Reference Document Number for intransit valuation

Indexes

Index	Uniqueness	Columns
CST_VU_ONHAND_VAL_GT_N1	Non Unique	ACTION_FLAG