CST_TRANSACTION_LAYERS

Details

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

Columns

Name	Datatype	Length	Precision	Not-null	Comments
TRANSACTION_ID	NUMBER		18	Yes	Single column FK: Identifies the cost transaction.
REC_TRXN_ID	NUMBER		18	Yes	Receipt transaction identifier for transaction layer.
DEP_TRXN_ID	NUMBER		18	Yes	Indicates deplete transaction Identifier for layers.
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		Valuation unit identifier for transaction layer.
INVENTORY_ITEM_ID	NUMBER		18	Yes	Inventory Item Identifier for transaction layers.
COST_DATE	TIMESTAMP			Yes	Indicates Transaction layers Cost Date.
EFF_DATE	TIMESTAMP				Indicates the effective date of the cost.
QUANTITY	NUMBER				Current quantity onhand for transaction layer.
UOM_CODE	VARCHAR2	30			Unit of Measure code for transaction layer.
ADDITIONAL_PROCESSING_CODE	VARCHAR2	240			Code specifying what kind of processing needs to be done. The value is defined in CST_INTERNAL_TXN_TYPE for the transaction type and is used by Cost Processors for additional processing.
POSTED_FLAG	VARCHAR2	5			Indicates transaction layers are posted or not.
QUANTITY_ONHAND	NUMBER				Contains the running onhand balance of the item in a valuation unit within a cost org book.
SOURCE_TABLE	VARCHAR2	20			Indicates transaction layers source.
REC_ONHAND_AVAIL_FLAG	VARCHAR2	1			Indicates if the receipt has onhand available so that it can be used for depletion.
REC_ONHAND	NUMBER				Undepleted receipt onhand for a receipt layer.
TOTAL_QUANTITY_DEPLETED	NUMBER				Total quantity depleted for the issue transaction in the session.
COST_TRANSACTION_TYPE	VARCHAR2	10			Costing transaction types are ISSUE or RECEIPT
PERIOD_NAME	VARCHAR2	15			Period in which the inventory valuation will be calculated.
START_DATE	DATE				Indicates the start date of the costing period.
END_DATE	DATE				Indicates the end date of the costing period.
NEGATIVE_QTY_CODE	VARCHAR2	30			The negative quantity code defines the action of cost method processors when the inventory quantity becomes negative. Values come from LOOKUP_TYPE CST_NEGATIVE_QUANTITY_CODES.
COST_METHOD_CODE	VARCHAR2	30			The cost method code like PERPETUAL AVERAGE, FIFO etc. Value comes from lookup type CST_COST_METHODS.

Indexes

Index	Uniqueness	Columns
CST_TRXN_LAYERS_GT_N1	Non Unique	TRANSACTION_ID, REC_TRXN_ID, DEP_TRXN_ID