MSC_ST_ITEM_SUPPLIERS
The staging table used by the collection program to validate and process data for table MSC_ITEM_SUPPLIERS.
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
INVENTORY_ITEM_ID | NUMBER | Identifies the inventory item id | |||
LOAD_REQUEST_ID | NUMBER | It Stores the Request ID of Job that loaded the data. | |||
ORGANIZATION_ID | NUMBER | This column indicates the Organization identifier. | |||
SUPPLIER_ID | NUMBER | This value indicates the Supplier identifier in the planning system. | |||
SUPPLIER_SITE_ID | NUMBER | This value indicates the Supplier site identifier. | |||
USING_ORGANIZATION_ID | NUMBER | Using organization identifier of the approved supplier list. | |||
ASL_ID | NUMBER | Unique sequence generated for the ASL | |||
PROCESSING_LEAD_TIME | NUMBER | Processing lead time used in supply network for supply generation. | |||
MINIMUM_ORDER_QUANTITY | NUMBER | This column indicates the Minimum Order Quantity. | |||
FIXED_LOT_MULTIPLE | NUMBER | Minimum lot multiple that can be ordered on top of minimum-order quantity | |||
DELIVERY_CALENDAR_CODE | VARCHAR2 | 100 | Delivery calendar code associated with the supplier | ||
VENDOR_NAME | VARCHAR2 | 360 | Name of the supplier attached to an Item in ASL. | ||
VENDOR_SITE_CODE | VARCHAR2 | 240 | Name of the supplier site attached to an Item in ASL. | ||
VENDOR_CAP_OVER_UTIL_COST | NUMBER | Cost incurred for over utilizing vendor capacity | |||
DELETED_FLAG | NUMBER | Flag indicating whether this is a deleted record | |||
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
SR_INSTANCE_ID | NUMBER | Source application instance identifier | |||
REFRESH_NUMBER | NUMBER | Refresh identifier populated by the collection program. | |||
SR_INSTANCE_ID2 | NUMBER | Source application instance identifier of using organization | |||
SUPPLIER_CAP_OVER_UTIL_COST | NUMBER | Supplier capacity overutilization cost specified as per ASL agreements. | |||
PURCHASING_UNIT_OF_MEASURE | VARCHAR2 | 25 | Purchasing unit of measure specified in ASL. | ||
ITEM_PRICE | NUMBER | Identifies the inventory item price | |||
COMPANY_ID | NUMBER | Unique id assigned to the company | |||
COMPANY_NAME | VARCHAR2 | 255 | Party name with which the company is registered. | ||
ITEM_NAME | VARCHAR2 | 300 | Identifies the inventory item name | ||
ORGANIZATION_CODE | VARCHAR2 | 18 | Short alphanumeric code to identify the Organization. | ||
SR_INSTANCE_CODE | VARCHAR2 | 30 | Source Instance code from which data is being populated. | ||
MESSAGE_ID | NUMBER | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML | |||
PROCESS_FLAG | NUMBER | Process Flag indicates the status of records during pre-processing. 1- Compete Record, 2- Error Record, 3- Warning Record, 4- Retry Record, 5- New Record. | |||
DATA_SOURCE_TYPE | VARCHAR2 | 15 | Source Type indicating the source of data | ||
ST_TRANSACTION_ID | NUMBER | Transaction ID generated during pre-processing to uniquely identify a record in the staging table | |||
ERROR_TEXT | VARCHAR2 | 2000 | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error | ||
BATCH_ID | NUMBER | Batch identifier generated during pre-processing | |||
SUPPLIER_ITEM_NAME | VARCHAR2 | 300 | Supplier cross reference item name | ||
PLANNER_CODE | VARCHAR2 | 10 | This value indicates the Planner code associated with the record. | ||
SUPPLIER_COMPANY_ID | NUMBER | Supplier company identifier. Used by planning collaboration(not in use currently). | |||
SUPPLIER_COMPANY_SITE_ID | NUMBER | Supplier company site identifier | |||
VMI_FLAG | NUMBER | Flag to identify item is VMI planned | |||
MIN_MINMAX_QUANTITY | NUMBER | Minimum minmax quantity. Used by vendor managed inventory. | |||
MAX_MINMAX_QUANTITY | NUMBER | This column indicates the Maximum Minmax Quantity. | |||
MAXIMUM_ORDER_QUANTITY | NUMBER | This column indicates the Maximum Order Quantity. | |||
VMI_REPLENISHMENT_APPROVAL | VARCHAR2 | 30 | VMI Replenishment Approval. Used in vendor managed inventory. | ||
ENABLE_VMI_AUTO_REPLENISH_FLAG | VARCHAR2 | 1 | Flag to indicate VMI Auto Replenishment | ||
ASL_LEVEL | NUMBER | Level of the Approved supplier list | |||
USING_ORGANIZATION_CODE | VARCHAR2 | 18 | Using organization identifier of the approved supplier list. | ||
MIN_MINMAX_DAYS | NUMBER | Minimum Quantity in days. Used by vendor managed inventory. | |||
MAX_MINMAX_DAYS | NUMBER | This column indicates the max days of supply in VMI. | |||
FIXED_ORDER_QUANTITY | NUMBER | Fixed order quantity for Vendor managed inventory | |||
FORECAST_HORIZON | NUMBER | Number of working days in the order forecast considered by Collaborative Planning to calculate the average daily usage. | |||
REPLENISHMENT_METHOD | NUMBER | Replenishment Method: 1- MIN-MAX quantities, 2- MIN-MAX days, 3-Min quantity and Fixed order quantity, 4- Min days and Fixed order Quantity | |||
ASL_ATTRIBUTE_CREATION_DATE | DATE | Approved Supplier List Creation Date | |||
RETRY_COUNT | NUMBER | Number of retries to process failed records. | |||
ERROR_CODE | VARCHAR2 | 150 | Error code for functional validation errors in the record | ||
OPERATION_TYPE | VARCHAR2 | 2 | This column indicates the Operation Type. | ||
CRITICAL_SUPPLIER_FLAG | NUMBER | 1 | Flag to enforce capacity constraints only for critical bottleneck suppliers for item-supplier site combinations. Valid values are 1(Yes) and 2(No). |