CST_PERPAVG_COST_GT

Current Transaciton Quantity and Quantity Onhand

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: TRANSACTION_TABLES

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
PERPAVG_COST_ID	NUMBER		18		Surrogate used to identify a perpetual average cost row.
TRANSACTION_ID	NUMBER		18	Yes	Single column FK: Identifies the costing transaction.	Active
REC_TRXN_ID	NUMBER		18	Yes	Receipt Transaction Identifyer	Active
DEP_TRXN_ID	NUMBER		18	Yes	Deplete Transaction Identifyer	Active
COST_ELEMENT_ID	NUMBER		18	Yes	Cost element corresponding to the cost of the transaction.	Active
EXPENSE_POOL_ID	NUMBER		18	Yes	Expense Pool Identifier	Active
EFF_DATE	TIMESTAMP			Yes	Cost in Effect Date	Active
COST_DATE	TIMESTAMP			Yes	Transaciton Cost Date	Active
TRANSACTION_COST_ID	NUMBER		18	Yes	Single column FK: Identifies the transaction cost.	Active
COST_ORG_ID	NUMBER		18	Yes	Single column FK: Identifies the Cost Organization associated with the inventory organization.	Active
COST_BOOK_ID	NUMBER		18	Yes	Single column FK: Identifies the Cost Book assigned to the Cost Organization.	Active
INVENTORY_ITEM_ID	NUMBER		18	Yes	Inventory Item Identifier	Active
VAL_UNIT_ID	NUMBER		18	Yes	Valuation unit identifier	Active
COST_METHOD_CODE	VARCHAR2	30			Cost Method Code
PROPAGATE_COST_ADJ_FLAG	VARCHAR2	1			Indicates if the cost adjustment propagation is enabled. Y = Yes, N = No.
QUANTITY_ONHAND	NUMBER				Current Quantity Onhand	Active
UNIT_COST_ONHAND	NUMBER				Current Perpavg Cost	Active
QUANTITY_NEW	NUMBER				Current Transaction Quantity	Active
UNIT_COST_NEW	NUMBER				Current Transaction Cost	Active
QUANTITY_ADJUST	NUMBER				Current Adjustment Quantity	Active
UNIT_COST_ADJUST	NUMBER				Current Adjustment Cost	Active
CURRENCY_CODE	VARCHAR2	30		Yes	Identifies the currency of the transaction / cost.	Active
UOM_CODE	VARCHAR2	30		Yes	Unit of Measure	Active
POSTED_FLAG	VARCHAR2	5			Posted Flag	Active
BASE_TXN_TYPE_ID	NUMBER		18		Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table.	Active
COST_TRANSACTION_TYPE	VARCHAR2	10			Cost Transaction Type is used by the costing engine to categorize group processing. Set to ADJUST for adjustments, null otherwise.	Active
ADDITIONAL_PROCESSING_CODE	VARCHAR2	240			Additional Processing Code is an optional further definition of the Cost Transaction Type. It is used on adjustment transactions (Cost Transaction Type is set to ADJUST) and is set to USER when the adjustment was done by the user, otherwise, it is set to null.	Active
COST_DRIVER	VARCHAR2	30			Cost Driver for the expense rows.
COST_DRIVER_VALUE	NUMBER		18		Cost Driver Value. Used for calculation of the expense unit_rate while perp average cost calculations.
ESTIMATED_RATE	NUMBER				Estimated rate defined for the overhead rule.
UNIT_RATE	NUMBER				Unit rate for the overhead as selected after Overhead engine call or calculated while perp average cost calculation.
UNIT_COST_AVERAGE	NUMBER				Perpetual Average Cost
USE_ITEM_COST_FLAG	VARCHAR2	1			Indicates if the row uses the current perpetual average as its transaction cost.
ABSORPTION_TYPE	VARCHAR2	30			Absoption type. Valid values are NULL, 0, 1,2,3.
OVERHEAD_ID	NUMBER		18		Identifies a transaction overhead row .
COST_CREATION_DATE	TIMESTAMP				Indicates the date and time of the creation of the row.
CONSIGNED_PO_RECEIPT_FLAG	VARCHAR2	1			Indicates the record is a consigned purchase order receipt.
CREATED_BY	VARCHAR2	64			Who column: indicates the user who created the row.	Obsolete
CREATION_DATE	TIMESTAMP				Who column: indicates the date and time of the creation of the row.	Obsolete
LAST_UPDATED_BY	VARCHAR2	64			Who column: indicates the user who last updated the row.	Obsolete
LAST_UPDATE_DATE	TIMESTAMP				Who column: indicates the date and time of the last update of the row.	Obsolete
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.	Obsolete

Indexes

Index	Uniqueness	Columns
CST_PERPAVG_COST_GT_N1	Non Unique	TRANSACTION_COST_ID
CST_PERPAVG_COST_GT_N2	Non Unique	OVERHEAD_ID
CST_PERPAVG_COST_GT_N3	Non Unique	COST_TRANSACTION_TYPE