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				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			The Additional_Processing_Code of the transaction.
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 a 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				Start Date of the period.
END_DATE	DATE				End date of the period.

Indexes

Index	Uniqueness	Columns
CST_TRXN_LAYERS_GT_N1	Non Unique	TRANSACTION_ID, REC_TRXN_ID, DEP_TRXN_ID