1. Tables and Views for SCM
  2. MSC_ST_INV_PA_OVERRIDES_INT

MSC_ST_INV_PA_OVERRIDES_INT

The staging table used by the collection program to validate and process data for table MSC_INV_PA_OVERRIDES

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: TABLE

  • Tablespace: INTERFACE

Columns

Name Datatype Length Precision Not-null Comments
SR_INSTANCE_CODE VARCHAR2 30 Source Instance code from which data is being populated.
ITEM_NAME VARCHAR2 300 Identifies the inventory item name.
INVENTORY_ITEM_ID NUMBER 18 Identifies the inventory item id.
ORGANIZATION_CODE VARCHAR2 18 This column gives the value of organization code.
ORGANIZATION_ID NUMBER 18 Organization identifier in the Planning system.
SUB_INVENTORY_CODE VARCHAR2 10 This is the name of the subinventory.
SUB_INVENTORY_ID NUMBER Sub Inventory identifier in the Planning system.
POLICY_SET_NAME VARCHAR2 120 User defined name of the policy assignment set.
POLICY_TYPE NUMBER Default is set to Min-Max planning . The other values must be Fixed Order Calendar, ROP-OQ (Re-Order Point - Order Quantity) and ROP-EOQ (Re-Order Point - economic Order Quantity).
POLICY_UOM NUMBER 4 Defines the uom of the values that will be calculated 1 - Units (Default), 2 - Days.
SS_OVERRIDE NUMBER Safety Stock Override - Only integer none zero values allowed.
MIN_OVERRIDE NUMBER Min Quantity Override - Only integer none zero values allowed. If SS Override is defined then a check should be done to ensure Min Quantity Override > SS Override.
MAX_OVERRIDE NUMBER Max Quantity Override - Only integer none zero values allowed. Have a check to ensure Max Quantity Override > Min Quantity Override > SS Override. Should be editable only when Policy type is ‘Min-Max Planning’.
EOQ_OVERRIDE NUMBER EOQ Override - Only integer none zero values allowed. Should be editable only when Policy type is ‘ROP-EOQ’.
ROP_OVERRIDE NUMBER Only integer none zero values allowed. Should be editable only when Policy type is ROP-OQ or ROP-EOQ.
ORDER_QTY_OVERRIDE NUMBER Order Quantity Override - Only integer none zero values allowed. Should be editable only when Policy type is ‘ROP-OQ’.
ORDERING_CALENDAR VARCHAR2 32 Only editable and mandatory when the Policy type is Fixed Order Calendar. This calendar governs on days when replenishment orders can be placed.
DELETED_FLAG NUMBER Yes/No flag indicates whether corresponding record in ODS will be deleted.
PROCESS_FLAG NUMBER Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed.
ERROR_CODE VARCHAR2 150 Error code for functional validation errors in the record.
ERROR_TEXT VARCHAR2 2000 This will describe the reason for the error if any.
LOAD_REQUEST_ID NUMBER It Stores the Request ID of Job that loaded the data.
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.
REFRESH_NUMBER NUMBER Refresh identifier to indicate the source system.
POLICY_SET_ID NUMBER Sequence generated primary key.
PAR_LEVEL_OVERRIDE NUMBER This field specifies the PAR level override. This should be greater than or equal to the safety stock.
PAR_MAX_OVERRIDE NUMBER This field specifies the PAR maximum quantity override. This should be greater that or equal to the PAR level override.