1. Tables and Views for SCM
  2. CST_INV_ONHAND_MISMATCH

CST_INV_ONHAND_MISMATCH

The table stores the onhand mismatch between Inventory and Costing at Cost Org, Cost Book, Item & Expense flag level for each validation (request id) run from the UI. The data from this table is used to display the mismatch to the user via a popup from the Manage Cost Periods UI.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CST_INV_ONHAND_MISMATCH_PK

REQUEST_ID, COST_ORG_ID, COST_BOOK_ID, EXTERNAL_SYSTEM_REFERENCE, INVENTORY_ITEM_ID, EXPENSE_ONHAND_FLAG, UOM_CODE, AS_OF_DATE

Columns

Name Datatype Length Precision Not-null Comments
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.
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 20 Yes Identifies the external source syste
INVENTORY_ITEM_ID NUMBER 18 Yes Inventory Item Identifier
INV_ONHAND_QTY NUMBER Yes The current onhand quantity of the item at Inventory
CST_ONHAND_QTY NUMBER Yes Costed onhand quantity from the running on-hand view
MISMATCH_QTY NUMBER Yes The difference between the Inventory onhand quantity and costing onhand quantity.
UOM_CODE VARCHAR2 3 Yes The unit of measure for costing quantities
AS_OF_DATE TIMESTAMP Yes The mismatch calculation is done till this date.
EXPENSE_ONHAND_FLAG VARCHAR2 1 Yes Identifies whether the onhand is expense or not
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 Yes 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 Tablespace Columns
CST_INV_ONHAND_MISMATCH_PK Unique FUSION_TS_TX_DATA REQUEST_ID, COST_ORG_ID, COST_BOOK_ID, EXTERNAL_SYSTEM_REFERENCE, INVENTORY_ITEM_ID, EXPENSE_ONHAND_FLAG, UOM_CODE, AS_OF_DATE