1. Tables and Views for SCM
  2. CST_TRANSACTION_LYRS_I_GT

CST_TRANSACTION_LYRS_I_GT

This is a global temporary table used in internal processing within the cost processor to temporarily store a subset of data from cst_transaction_layers table.

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_TRANSACTION_TYPE VARCHAR2 10 Costing transaction types are ISSUE or RECEIPT.
COST_DATE TIMESTAMP Yes Indicates Transaction layers Cost Date.
PERIOD_NAME VARCHAR2 15 Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method.
QUANTITY NUMBER Current Quantity Onhand for transaction layer.
QUANTITY_ONHAND NUMBER Contains the running onhand balance of the item in a valuation unit within a cost org book.
UOM_CODE VARCHAR2 30 Unit of Measure code for transaction layer.
POSTED_FLAG VARCHAR2 5 Indicates transaction layers are posted or not.
VAL_ONHAND_FLAG VARCHAR2 1 Indicates if the onhand calculations have been done for the layer. Values: N = Not processed, NULL = Processed for onhand calculations.
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 Onhand for a receipt layer. This attribute will have no value for a depletion layer.
COST_METHOD_CODE VARCHAR2 30 The cost method code like PERPETUAL AVERAGE, FIFO etc. Value comes from lookup type CST_COST_METHODS.
ROW_UPDATED_FLAG VARCHAR2 1 Indicates if this row has been updated during the process.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.

Indexes

Index Uniqueness Columns
CST_TRANSACTION_LYRS_I_GT_U1 Unique TRANSACTION_ID, REC_TRXN_ID, DEP_TRXN_ID