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