CST_DEPLETIONS_GT

This global temporary table is used to hold the depletion layers during processing.

Details

• Schema: FUSION

• Object owner: CST

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
CST_DEPLETIONS_GT_PK	DEP_TRXN_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments	Status
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.	Active
DEP_TRXN_ID	NUMBER		18	Yes	Indicates deplete transaction identifier for layers.	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_ORG_ID	NUMBER				Indicates the inventory organization associated with the transaction.
VAL_UNIT_ID	NUMBER		18	Yes	Valuation unit identifier for transaction layer.	Active
INVENTORY_ITEM_ID	NUMBER		18	Yes	Inventory item identifier for transaction layers.	Active
COST_DATE	TIMESTAMP				Indicates transaction layer's cost date.	Active
QUANTITY_REMAIN	NUMBER				Quantity remaining to be depleted on the issue transaction.	Active
REVERSAL_EXISTS_FLAG	VARCHAR2	4			Possible values are Y, N and null. Y indicates that a negative inventory reversal layer exists. N indicates that a negative inventory reversal layer does not exist. Null indicates record is not for negative layer.
COST_TRANSACTION_TYPE	VARCHAR2	30			Costing transaction type ISSUE or RECEIPT.
CT_COST_DATE	TIMESTAMP				Date to be used for transaction sequencing.
UOM_CODE	VARCHAR2	4			Unit of measure code of the costing quantity.
COST_METHOD_CODE	VARCHAR2	30			The cost method code like PERPETUAL AVERAGE, FIFO etc. Value comes from LOOKUP_TYPE CST_COST_METHODS.
PERIOD_NAME	VARCHAR2	15			Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method.
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.

Indexes

Index	Uniqueness	Columns
CST_DEPLETIONS_GT_U1	Unique	DEP_TRXN_ID