MSC_ST_SYSTEM_ITEMS
The staging table used by the collection program to validate and process data for table MSC_SYSTEM_ITEMS
Details
-
Schema: FUSION
-
Object owner: MSC
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
ORGANIZATION_ID | NUMBER | 18 | This column contains the value of ORGANIZATION identifier. | ||
AUTO_CREATED_CONFIG_FLAG | NUMBER | Auto Created Configration Flag values 1-Yes,2-No | |||
SR_ORGANIZATION_ID | NUMBER | 18 | Source side value of the organization identifier. | ||
INVENTORY_ITEM_ID | NUMBER | 18 | Identifies the inventory item id | ||
SR_INVENTORY_ITEM_ID | NUMBER | 18 | Source side value of the inventory item identifier. | ||
ITEM_NAME | VARCHAR2 | 300 | Identifies the inventory item name | ||
LOTS_EXPIRATION | NUMBER | 38 | Lots expiration value set for the inventory item. | ||
LOT_CONTROL_CODE | NUMBER | This column contains the value of lot control code. | |||
SHRINKAGE_RATE | NUMBER | Shrinkage rate of the inventory item. | |||
FIXED_DAYS_SUPPLY | NUMBER | Period of the supply days (in days) | |||
FIXED_ORDER_QUANTITY | NUMBER | Fixed order quantity for Vendor managed inventory | |||
FIXED_LOT_MULTIPLIER | NUMBER | Fixed quantitiy that a lot can contain | |||
MINIMUM_ORDER_QUANTITY | NUMBER | This column contains the value of MINIMUM ORDER QUANTITY. | |||
MAXIMUM_ORDER_QUANTITY | NUMBER | This column contains the value of MAXIMUM ORDER QUANTITY. | |||
ROUNDING_CONTROL_TYPE | NUMBER | Rounding control type for the inventory item. | |||
PLANNING_TIME_FENCE_CODE | NUMBER | Planning time fence code of the inventory item. | |||
PLANNING_TIME_FENCE_DAYS | NUMBER | Planning time fence code of the inventory item. | |||
DEMAND_TIME_FENCE_DAYS | NUMBER | This value indicates the Demand time fence days. | |||
DEMAND_TIME_FENCE_CODE | NUMBER | Demanding time fence code as computed by the planning engine | |||
DESCRIPTION | VARCHAR2 | 240 | Description of the inventory item | ||
RELEASE_TIME_FENCE_CODE | NUMBER | Release time fence code. Used during Auto release of the supplies within this time fence. | |||
RELEASE_TIME_FENCE_DAYS | NUMBER | Release time fence days. Used during Auto release of the supplies within this time fence. | |||
MRP_PLANNING_CODE | NUMBER | This column contains the value of MRP planning code. | |||
FIXED_LEAD_TIME | NUMBER | Represents the fixed lead time used to calculate the operations start and end date for the supplier operation. | |||
VARIABLE_LEAD_TIME | NUMBER | Variable lead time used in conjunction with the quantity of the item. | |||
PREPROCESSING_LEAD_TIME | NUMBER | Pre processing lead time used in supply network for supply generation. | |||
POSTPROCESSING_LEAD_TIME | NUMBER | Post processing lead time used in supply network for supply generation. | |||
FULL_LEAD_TIME | NUMBER | Full lead time defined for an inventory item at item organization level. | |||
CUMULATIVE_TOTAL_LEAD_TIME | NUMBER | Cumulative total lead time. This is used during item replenishment. | |||
CUM_MANUFACTURING_LEAD_TIME | NUMBER | Cumulative manufacturing lead time | |||
UOM_CODE | VARCHAR2 | 50 | Unit of measure code of the inventory item. | ||
UNIT_WEIGHT | NUMBER | Unit of measure of the weight class of the item. | |||
UNIT_VOLUME | NUMBER | Unit of measure of the volume class of the item. | |||
WEIGHT_UOM | VARCHAR2 | 50 | This value indicates the unit of measure defined in terms of weight. | ||
VOLUME_UOM | VARCHAR2 | 50 | This value indicates the unit of measure defined in terms of volume. | ||
PRODUCT_FAMILY_ID | NUMBER | 18 | This stores the value of Product family identifier if the item is part of product family. | ||
ATP_COMPONENTS_FLAG | NUMBER | Flag indicating whether to calculate components ATP | |||
BUILD_IN_WIP_FLAG | NUMBER | Flag indicates whether assembly can be built. | |||
PURCHASING_ENABLED_FLAG | NUMBER | Flag to indicate if the item can be purchased. 1-Yes, 2-No. | |||
PLANNING_MAKE_BUY_CODE | NUMBER | Indicate if this item should be made or bought. Make(1), Buy(2). | |||
STANDARD_COST | NUMBER | Standard cost of the inventory item. | |||
CARRYING_COST | NUMBER | Inventory carrying cost for the inventory item. | |||
ORDER_COST | NUMBER | This value indicates the order cost of the item. | |||
MATERIAL_COST | NUMBER | This value indicates the material cost for the inventory item. | |||
RESOURCE_COST | NUMBER | The value indicates resource code collected from source system. | |||
SUPPLIER_CAP_OVERUTIL_COST | NUMBER | Supplier capacity overutilization cost specified as per ASL agreements. | |||
LIST_PRICE | NUMBER | This column contains the value of list price. | |||
AVERAGE_DISCOUNT | NUMBER | Average discount on the price of the item | |||
WIP_SUPPLY_TYPE | NUMBER | 18 | Work in process supply type value for the record. Mainly used for phantom identification. | ||
MRP_SAFETY_STOCK_CODE | NUMBER | This flag indicates the MRP safety stock code value. | |||
MRP_SAFETY_STOCK_PERCENT | NUMBER | This flag indicates the MRP safety stock percent value. | |||
SAFETY_STOCK_BUCKET_DAYS | NUMBER | Days over which to average demand for MRP Planned safety stock percent. | |||
PLANNER_CODE | VARCHAR2 | 10 | This value indicates the Planner code associated with the record. | ||
BOM_ITEM_TYPE | NUMBER | BOM item type: Model(1), Option Class(2), Planning(3), Standard(4), Product Family(5) | |||
ATO_FORECAST_CONTROL | NUMBER | ATO forecast control code: Consume(1), Consume and derive(2), None(3) | |||
EFFECTIVITY_CONTROL | NUMBER | Effectivity control code: Date Effectivity(1), Unit Number effectivity(2) | |||
ORGANIZATION_CODE | VARCHAR2 | 18 | This column contains the value of organization code. | ||
ACCEPTABLE_EARLY_DELIVERY | NUMBER | The value indicates acceptable early delivery range. | |||
CALCULATE_ATP | NUMBER | Flag indicating whether to calculate ATP when planning this part | |||
INVENTORY_ITEM_FLAG | NUMBER | Indicates whether the item is an inventory item | |||
ATP_FLAG | NUMBER | Flag used for ATP. Possible values 1(Yes), 2(No). | |||
BASE_ITEM_ID | NUMBER | 18 | Base item identifier for configuration | ||
BASE_ITEM_NAME | VARCHAR2 | 300 | The value indicates item name of the model item | ||
PICK_COMPONENTS_FLAG | NUMBER | Flag indicates whether the item is a PTO item/model or not. 1-Yes, 2-No. | |||
REPLENISH_TO_ORDER_FLAG | NUMBER | Assemble to order flag. Used for ATO/CTO cases to identify whether the item can be assembled. | |||
CREATE_SUPPLY_FLAG | NUMBER | When Create supply is set to No, new planned orders are not created for the item in constrained plans | |||
VMI_FIXED_ORDER_QUANTITY | NUMBER | Fixed order quantity. Used in vendor managed inventory. | |||
LIFE_CYCLE_PHASE | VARCHAR2 | 120 | This value indicates the Life cycle phase defined for an item. | ||
SHIPPABLE_ITEM_FLAG | NUMBER | Flag indicates whether item can shipped. 1-Yes, 2-No. | |||
CUSTOMER_ORDER_FLAG | NUMBER | Flag indicates whether the item is customer orderable or not. 1-Yes, 2-No. | |||
SHIP_MODEL_COMPLETE_FLAG | NUMBER | Ship model complete flag. Indicates if the PTO is SMC enabled. | |||
BACK_TO_BACK_FLAG | NUMBER | Indicates whether a item is a back-to-back item. | |||
ENGINEERING_ITEM_FLAG | NUMBER | Flag indicating whether this is an ECO item | |||
MIN_SHELF_LIFE_DAYS | NUMBER | Minimum shelf life days demand for the demand. | |||
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. | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
PROGRAM_APPLICATION_ID | NUMBER | This value indicates the Program application identifier. | |||
PROGRAM_ID | NUMBER | This value indicates the Program identifier. | |||
PROGRAM_UPDATE_DATE | DATE | This value indicates the update date of the program. | |||
SR_INSTANCE_ID | NUMBER | 18 | Identifier of the source system from where the data is collected. | ||
REFRESH_NUMBER | NUMBER | Refresh identifier populated by the collection program. | |||
SR_INSTANCE_CODE | VARCHAR2 | 30 | The value indicates the source system code from where the data is collected. | ||
PROCESS_FLAG | NUMBER | Processing Flag indicating the status of records during pre-processing. 1- Complete Record, 2- Error Record, 3- Warning Record, 4- Retry Record, 5- New Record. | |||
ERROR_TEXT | VARCHAR2 | 2000 | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error | ||
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 contains the value of OPERATION TYPE. | ||
LOAD_REQUEST_ID | NUMBER | It Stores the Request ID of Job that loaded the data. | |||
BUYER_NAME | VARCHAR2 | 240 | Name of the buyer of the inventory item, used for reporting. | ||
ABC_CLASS_NAME | VARCHAR2 | 40 | This is the name of the ABC class for the item. | ||
SOURCE_ORG_ID | NUMBER | This value indicates the Organization identifier of the item source. | |||
SOURCE_ORG_CODE | VARCHAR2 | 30 | This value indicates the Organization code of the item source. | ||
CRITICAL_COMPONENT_FLAG | NUMBER | Critical component flag of item | |||
GLOBAL_ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Global Descriptive Flexfield: segment of the global descriptive flexfield. | ||
GLOBAL_ATTRIBUTE_NUMBER1 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER2 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER3 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER4 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_NUMBER5 | NUMBER | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_DATE1 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_DATE2 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_DATE3 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_DATE4 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
GLOBAL_ATTRIBUTE_DATE5 | DATE | Global Descriptive Flexfield: segment of the global descriptive flexfield. | |||
ORDER_MODIFIER_TO_START_QTY | NUMBER | Flag indicates Apply Order Modifier to Start Quantity: Yes(1), No(2); if No, it means Apply Order Modifier to Order Quantity. | |||
ENFORCE_PURCHASE_LT | VARCHAR2 | 1 | The column indicates whether the Purchase lead time has to be enforced: Yes(1) means enforced. No(2) means not enforced. Default value is Yes. | ||
INDIVISIBLE_FLAG | NUMBER | Attribute indicating whether the item can be ordered in fractions. | |||
HARD_PEGGING_LEVEL | VARCHAR2 | 25 | It determines the type of pegging considered by the planning engine during the supply or demand netting process. | ||
COMN_SUPPLY_PRJ_DEMAND_FLAG | NUMBER | It determines if material can be planned, picked and issued from common inventory if sufficient inventory does not exist in project inventory. | |||
LEAD_TIME_LOT_SIZE | NUMBER | Attribute indicating quantity used to compute processing lead time. | |||
ASSET_TRACKED_FLAG | NUMBER | Attribute indicating whether item is tracked as an asset in installed base. Collect Y (for Full Lifecycle) /C (for Customer Asset) as '1'. 'N'/Null as '2'. | |||
CREATE_SUPPLY_AFTER | DATE | When Create_supply_flag is set to Yes, this date column indicates from when the new planned orders can be created for the item in constrained plans |