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. |