1. Tables and Views for SCM
  2. CST_INV_ONHAND_MATCH_T

CST_INV_ONHAND_MATCH_T

This persistem temp table stores the mismatch details between Inventory system and costing at Cost Org, Cost Book, Item & Expense flag level (in v1.0). But the design is so that it can store the mismatch at Valuation Unit level too, in that case the expense_onhand_flag would become redundant.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CST_INV_ONHAND_MATCH_T_PK

COST_ORG_ID, COST_BOOK_ID, EXTERNAL_SYSTEM_REFERENCE, INVENTORY_ITEM_ID, EXPENSE_ONHAND_FLAG, VAL_UNIT_ID

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 60 Yes Identifies the external source syste
INVENTORY_ITEM_ID NUMBER 18 Yes Inventory Item Identifier
INV_CALC_ONHAND_QTY NUMBER The current onhand quantity of the item at Inventory
INV_UNSENT_TXN_QTY NUMBER The sum of quantity from transactions not sent to costing
VAL_UNIT_ID NUMBER 18 Yes Valuation unit identifier
CST_ONHAND_QTY NUMBER Costed onhand quantity from the running on-hand view
CST_BACKDATED_ONHAND_QTY NUMBER The sum of costing onhand quantity for backdated transactions
CST_UNPROCESSED_QTY NUMBER Unprocessed transaction quantity
CST_CT_ERROR_QTY NUMBER Sum of transaction quantity for transactions in error status
CST_INTERFACE_ERROR_QTY NUMBER Sum of transaction quantity for interfaced transactions in error status
CST_INTERFACE_UNPROCESSED_QTY NUMBER Sum of transaction quantity for interfaced transactions
CST_CT_UNCOSTED_QTY NUMBER The quantity in successfully preprocessed transaction in CST_TRANSACTIONS that is pending costing.
MISMATCH_QTY NUMBER Yes Mismatch is calculated as follows: (InvCalcOnhand - CstCTErrorQty - CstIntfQty - CstUnprocessed) - (CstOnhand)
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.
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.
EXPENSE_ONHAND_FLAG VARCHAR2 1 Yes Indicates whether or not this onhand is for a expense item or from a expense SubInventory

Foreign Keys

Table Foreign Table Foreign Key Column
CST_INV_ONHAND_MATCH_T cst_cost_books_b COST_BOOK_ID

Indexes

Index Uniqueness Tablespace Columns
CST_INV_ONHAND_MATCH_T_PK Unique FUSION_TS_TX_DATA COST_ORG_ID, COST_BOOK_ID, EXTERNAL_SYSTEM_REFERENCE, INVENTORY_ITEM_ID, EXPENSE_ONHAND_FLAG, VAL_UNIT_ID