1. Tables and Views for SCM
  2. CST_TRANSFERS_I_GT

CST_TRANSFERS_I_GT

Transfer Layers tracks quantity flow of intransit transactions

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

CST_TRANSFERS_I_GT_PK

TRANSACTION_ID, REC_TRXN_ID, DEP_TRXN_ID

Columns

Name Datatype Length Precision Not-null Comments Status
TRANSACTION_ID NUMBER 18 Yes Single column FK: Identifies the costing transaction. Active
REC_TRXN_ID NUMBER 18 Yes Single column FK to the cost transaction. For the given transaction, this identifies the Receipt Transaction. Active
DEP_TRXN_ID NUMBER 18 Yes Single column FK to the cost transaction. For the given transaction, this identifies the Deplete Transaction. 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
VAL_UNIT_ID NUMBER 18 Single Column FK. Identifies the Valuation unit for the cost transaction. Active
INVENTORY_ITEM_ID NUMBER 18 Yes Inventory Item Identifier to identify the item being transacted. Active
COST_TRANSACTION_TYPE VARCHAR2 10 Costing transaction types are ISSUE or RECEIPT Active
COST_DATE TIMESTAMP Date to be used for transaction sequencing Active
TRANSFER_COST_ORG_ID NUMBER 18 Cost Organization identifier associated with Inventory organization of the other leg of transfer transaction
FOB_POINT NUMBER 1 Indicates the Free on board point and determines the point of transfer of liability/ownership. It is 1 for SHIPMENT and 2 for RECEIPT
QUANTITY NUMBER The Transfer transactions Quantity in costing unit of measure Active
UOM_CODE VARCHAR2 30 Costing Unit of Measure for the transaction quantity Active
POSTED_FLAG VARCHAR2 5 Indicates transfer layers are posted or not. Active
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
STAGED_FOR_CONV_FLAG VARCHAR2 1 Identifies if this row has been staged in cst_transfer_txn_costs for pre-processor cost conversion and cost element remapping.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
PERIOD_NAME VARCHAR2 15 Period in which the inventory valuation will be calculated.
START_DATE DATE Start Date of the period in which the inventory valuation will be calculated.
END_DATE DATE End date of the period in which the inventory valuation will be calculated.

Indexes

Index Uniqueness Columns
CST_TRANSFERS_I_GT_U1 Unique TRANSACTION_ID, REC_TRXN_ID, DEP_TRXN_ID