CST_RUNNING_DEPLETIONS_GT

This global temporary table is used to store the running depletions while generating depletions layers.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Columns

Name	Datatype	Length	Precision	Not-null	Comments
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.
INVENTORY_ORG_ID	NUMBER				Inventory organization of deplete/receipt transaction.
VAL_UNIT_ID	NUMBER		18	Yes	Valuation unit identifier for transaction layer.
INVENTORY_ITEM_ID	NUMBER		18	Yes	Inventory Item Identifier for transaction layers.
COST_DATE	TIMESTAMP				Indicates transaction layer's Cost Date.
RCPT_DATE	TIMESTAMP				Indicates the cost date of the depleting receipt.
RUNNING_DEPL_QTY	NUMBER				Running depletion quantity of this transaction.
ISSUE_QTY	NUMBER				Quantity of the issue transaction.
REC_ONHAND_AVAIL_FLAG	VARCHAR2	1			Indicates if the receipt has onhand available so that it can be used for depletion.
REC_ONHAND	NUMBER				Receipt available onhand quantity prior to the depletions in this table.
COST_TRANSACTION_TYPE	VARCHAR2	30			Costing transaction type ISSUE or RECEIPT.
UOM_CODE	VARCHAR2	4			Unit of measure code of the transaction quantity.
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	20			The cost method code like PERPETUAL AVERAGE, FIFO etc. Value comes from LOOKUP_TYPE CST_COST_METHODS.
PERIOD_NAME	VARCHAR2	20			Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method.