1. Tables and Views for SCM
  2. CST_INTR_ONHAND_VALUATIONS_GT

CST_INTR_ONHAND_VALUATIONS_GT

This table contains intransit inventory valuation with quantities at the inventory organization level and the costs as total costs.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: Default

Columns

Name Datatype Length Precision Not-null Comments
VAL_DETAIL_ID NUMBER 18 Surrogate key that identifies a row in this table.
PRIOR_VAL_DETAIL_ID NUMBER 18 Identifies the prior period valuation detail row.
VALUATION_ID NUMBER 18 Identifies the intransit onhand valuation row.
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_ITEM_ID NUMBER 18 Yes Identifies the Inventory Item for which the onhand is maintained
PERIOD_NAME VARCHAR2 15 Yes Period in which the valuation exists.
START_DATE DATE Yes Identifies the date of snapshot of On-hand Inventory and cost taken for OTBI usage
END_DATE DATE Yes Identifies the date effectivity. The information in the row is valid up to this date.
INVENTORY_ORG_ID NUMBER 18 Yes Inventory organization for the intransit node.
SHIP_FROM_INV_ORG_ID NUMBER 18 Ship from inventory organization for transfer flows.
SHIP_TO_INV_ORG_ID NUMBER 18 Ship to inventory organization for a transfer flow.
ITEM_ORGANIZATION_ID NUMBER 18 Master organization used for item lookup and validation. For intransit organizations, item definition may not exist in them.
BUSINESS_UNIT_ID NUMBER 18 Business unit associated to the intransit node.
TXN_SOURCE_REF_DOC_NUMBER VARCHAR2 240 Reference document of the intransit valuation.
TXN_SOURCE_REF_DOC_TYPE VARCHAR2 50 Reference document type of the intransit valuation.
TXN_SOURCE_DOC_NUMBER VARCHAR2 240 Document number of the intransit valuation.
TXN_SOURCE_DOC_TYPE VARCHAR2 50 Document type of the intransit valuation.
TRANSFER_TXN_ID NUMBER 18 Shipment transaction id for the transfer flow.
TRANSACTION_FLOW_TYPE NUMBER 18 Yes Identifies the intransit flow type.
QUANTITY_ONHAND NUMBER Owned Intransit Quantity for the period.
ACCTD_QUANTITY_ONHAND NUMBER Accounted Quantity Onhand for the period.
CMR_RCV_QUANTITY NUMBER Received quantity in receipt accounting for the flow where transfer receipts are not processed in the cost accounting.
ACCTD_CMR_RCV_QUANTITY NUMBER Accounted Received quantity in receipt accounting for the flow where transfer receipts are not processed in the cost accounting.
ACCOUNTED_FLAG VARCHAR2 1 Indicates if all transaction data for the valuation row is accounted.
UOM_CODE VARCHAR2 3 Yes Unit of Measure of the quantities
EXPENSE_TRANSACTION_FLAG VARCHAR2 1 Yes Indicates if the intransit onhand is for expense transactions.
CONSIGNED_FLAG VARCHAR2 1 Yes Indicates if the intransit onhand is for consigned transactions.
COST_ELEMENT_ID NUMBER 18 Cost element corresponding to the onhand valuation
ONHAND_VALUE NUMBER Intransit onhand valuation for a given item, organization and cost element.
ACCTD_ONHAND_VALUE NUMBER Intransit onhand valuation that is accounted.
CURRENCY_CODE VARCHAR2 30 Identifies the currency of the transaction / cost.
CMR_RCV_PROCESSED_FLAG VARCHAR2 1 Indicates if the expense receipt from receipt accounting has been processed for the in-transit flow. Value of N indicates not processed and NULL indicates that it has been processed or not applicable.
RUN_MODE VARCHAR2 10 Determines the internal logic for summarization.