Table Name: MTL_SYSTEM_ITEMS
select * from MTL_SYSTEM_ITEMS order by creation_date desc
Single Record View
As of: dd/mm/yyyy hh:mm:ss
INVENTORY_ITEM_ID: 236238
ORGANIZATION_ID: 204
LAST_UPDATE_DATE: 07/02/2015 16:48:30
LAST_UPDATED_BY: 1012012
CREATION_DATE: 07/02/2015 15:24:06
CREATED_BY: 1012012
LAST_UPDATE_LOGIN: 4139263
SUMMARY_FLAG: N
ENABLED_FLAG: Y
START_DATE_ACTIVE:
END_DATE_ACTIVE:
DESCRIPTION: A8 part for assem D1
BUYER_ID: 59
ACCOUNTING_RULE_ID:
INVOICING_RULE_ID:
SEGMENT1: A8P2
SEGMENT2:
SEGMENT3:
SEGMENT4:
SEGMENT5:
SEGMENT6:
SEGMENT7:
SEGMENT8:
SEGMENT9:
SEGMENT10:
SEGMENT11:
SEGMENT12:
SEGMENT13:
SEGMENT14:
SEGMENT15:
SEGMENT16:
SEGMENT17:
SEGMENT18:
SEGMENT19:
SEGMENT20:
ATTRIBUTE_CATEGORY:
ATTRIBUTE1:
ATTRIBUTE2:
ATTRIBUTE3:
ATTRIBUTE4:
ATTRIBUTE5:
ATTRIBUTE6:
ATTRIBUTE7:
ATTRIBUTE8:
ATTRIBUTE9:
ATTRIBUTE10:
ATTRIBUTE11:
ATTRIBUTE12:
ATTRIBUTE13:
ATTRIBUTE14:
ATTRIBUTE15:
PURCHASING_ITEM_FLAG: Y
SHIPPABLE_ITEM_FLAG: N
CUSTOMER_ORDER_FLAG: N
INTERNAL_ORDER_FLAG: N
SERVICE_ITEM_FLAG: N
INVENTORY_ITEM_FLAG: Y
ENG_ITEM_FLAG: N
INVENTORY_ASSET_FLAG: N
PURCHASING_ENABLED_FLAG: Y
CUSTOMER_ORDER_ENABLED_FLAG: N
INTERNAL_ORDER_ENABLED_FLAG: N
SO_TRANSACTIONS_FLAG: N
MTL_TRANSACTIONS_ENABLED_FLAG: Y
STOCK_ENABLED_FLAG: Y
BOM_ENABLED_FLAG: N
BUILD_IN_WIP_FLAG: Y
REVISION_QTY_CONTROL_CODE: 1
ITEM_CATALOG_GROUP_ID:
CATALOG_STATUS_FLAG: N
RETURNABLE_FLAG: N
DEFAULT_SHIPPING_ORG:
COLLATERAL_FLAG:
TAXABLE_FLAG: N
QTY_RCV_EXCEPTION_CODE:
ALLOW_ITEM_DESC_UPDATE_FLAG: Y
INSPECTION_REQUIRED_FLAG:
RECEIPT_REQUIRED_FLAG: Y
MARKET_PRICE:
HAZARD_CLASS_ID:
RFQ_REQUIRED_FLAG: N
QTY_RCV_TOLERANCE:
LIST_PRICE_PER_UNIT:
UN_NUMBER_ID:
PRICE_TOLERANCE_PERCENT: 0
ASSET_CATEGORY_ID:
ROUNDING_FACTOR:
UNIT_OF_ISSUE:
ENFORCE_SHIP_TO_LOCATION_CODE:
ALLOW_SUBSTITUTE_RECEIPTS_FLAG:
ALLOW_UNORDERED_RECEIPTS_FLAG:
ALLOW_EXPRESS_DELIVERY_FLAG:
DAYS_EARLY_RECEIPT_ALLOWED:
DAYS_LATE_RECEIPT_ALLOWED:
RECEIPT_DAYS_EXCEPTION_CODE:
RECEIVING_ROUTING_ID:
INVOICE_CLOSE_TOLERANCE:
RECEIVE_CLOSE_TOLERANCE:
AUTO_LOT_ALPHA_PREFIX:
START_AUTO_LOT_NUMBER:
LOT_CONTROL_CODE: 1
SHELF_LIFE_CODE: 1
SHELF_LIFE_DAYS: 0
SERIAL_NUMBER_CONTROL_CODE: 1
START_AUTO_SERIAL_NUMBER:
AUTO_SERIAL_ALPHA_PREFIX:
SOURCE_TYPE:
SOURCE_ORGANIZATION_ID:
SOURCE_SUBINVENTORY:
EXPENSE_ACCOUNT: 13185
ENCUMBRANCE_ACCOUNT:
RESTRICT_SUBINVENTORIES_CODE: 2
UNIT_WEIGHT:
WEIGHT_UOM_CODE:
VOLUME_UOM_CODE:
UNIT_VOLUME:
RESTRICT_LOCATORS_CODE: 2
LOCATION_CONTROL_CODE: 1
SHRINKAGE_RATE:
ACCEPTABLE_EARLY_DAYS:
PLANNING_TIME_FENCE_CODE: 4
DEMAND_TIME_FENCE_CODE:
LEAD_TIME_LOT_SIZE: 1
STD_LOT_SIZE:
CUM_MANUFACTURING_LEAD_TIME:
OVERRUN_PERCENTAGE:
MRP_CALCULATE_ATP_FLAG:
ACCEPTABLE_RATE_INCREASE: 0
ACCEPTABLE_RATE_DECREASE: 0
CUMULATIVE_TOTAL_LEAD_TIME:
PLANNING_TIME_FENCE_DAYS: 1
DEMAND_TIME_FENCE_DAYS:
END_ASSEMBLY_PEGGING_FLAG: N
REPETITIVE_PLANNING_FLAG: N
PLANNING_EXCEPTION_SET:
BOM_ITEM_TYPE: 4
PICK_COMPONENTS_FLAG: N
REPLENISH_TO_ORDER_FLAG: N
BASE_ITEM_ID:
ATP_COMPONENTS_FLAG: N
ATP_FLAG: N
FIXED_LEAD_TIME:
VARIABLE_LEAD_TIME:
WIP_SUPPLY_LOCATOR_ID:
WIP_SUPPLY_TYPE: 1
WIP_SUPPLY_SUBINVENTORY:
PRIMARY_UOM_CODE: Ea
PRIMARY_UNIT_OF_MEASURE: Each
ALLOWED_UNITS_LOOKUP_CODE: 3
COST_OF_SALES_ACCOUNT: 12951
SALES_ACCOUNT: 12879
DEFAULT_INCLUDE_IN_ROLLUP_FLAG:
INVENTORY_ITEM_STATUS_CODE: Active
INVENTORY_PLANNING_CODE: 6
PLANNER_CODE:
PLANNING_MAKE_BUY_CODE: 2
FIXED_LOT_MULTIPLIER:
ROUNDING_CONTROL_TYPE:
CARRYING_COST:
POSTPROCESSING_LEAD_TIME: 0
PREPROCESSING_LEAD_TIME:
FULL_LEAD_TIME:
ORDER_COST:
MRP_SAFETY_STOCK_PERCENT:
MRP_SAFETY_STOCK_CODE: 1
MIN_MINMAX_QUANTITY:
MAX_MINMAX_QUANTITY:
MINIMUM_ORDER_QUANTITY:
FIXED_ORDER_QUANTITY:
FIXED_DAYS_SUPPLY:
MAXIMUM_ORDER_QUANTITY:
ATP_RULE_ID:
PICKING_RULE_ID:
RESERVABLE_TYPE: 1
POSITIVE_MEASUREMENT_ERROR:
NEGATIVE_MEASUREMENT_ERROR:
ENGINEERING_ECN_CODE:
ENGINEERING_ITEM_ID:
ENGINEERING_DATE:
SERVICE_STARTING_DELAY:
VENDOR_WARRANTY_FLAG: N
SERVICEABLE_COMPONENT_FLAG: N
SERVICEABLE_PRODUCT_FLAG: N
BASE_WARRANTY_SERVICE_ID:
PAYMENT_TERMS_ID:
PREVENTIVE_MAINTENANCE_FLAG: N
PRIMARY_SPECIALIST_ID:
SECONDARY_SPECIALIST_ID:
SERVICEABLE_ITEM_CLASS_ID:
TIME_BILLABLE_FLAG:
MATERIAL_BILLABLE_FLAG:
EXPENSE_BILLABLE_FLAG:
PRORATE_SERVICE_FLAG: N
COVERAGE_SCHEDULE_ID:
SERVICE_DURATION_PERIOD_CODE:
SERVICE_DURATION:
WARRANTY_VENDOR_ID:
MAX_WARRANTY_AMOUNT:
RESPONSE_TIME_PERIOD_CODE:
RESPONSE_TIME_VALUE:
NEW_REVISION_CODE:
INVOICEABLE_ITEM_FLAG: N
TAX_CODE:
INVOICE_ENABLED_FLAG: N
MUST_USE_APPROVED_VENDOR_FLAG: N
REQUEST_ID:
PROGRAM_APPLICATION_ID:
PROGRAM_ID:
PROGRAM_UPDATE_DATE:
OUTSIDE_OPERATION_FLAG: N
OUTSIDE_OPERATION_UOM_TYPE:
SAFETY_STOCK_BUCKET_DAYS:
AUTO_REDUCE_MPS:
COSTING_ENABLED_FLAG: N
AUTO_CREATED_CONFIG_FLAG: N
CYCLE_COUNT_ENABLED_FLAG: N
ITEM_TYPE:
MODEL_CONFIG_CLAUSE_NAME:
SHIP_MODEL_COMPLETE_FLAG: N
MRP_PLANNING_CODE: 6
RETURN_INSPECTION_REQUIREMENT: 2
ATO_FORECAST_CONTROL:
RELEASE_TIME_FENCE_CODE:
RELEASE_TIME_FENCE_DAYS:
CONTAINER_ITEM_FLAG:
VEHICLE_ITEM_FLAG:
MAXIMUM_LOAD_WEIGHT:
MINIMUM_FILL_PERCENT:
CONTAINER_TYPE_CODE:
INTERNAL_VOLUME:
WH_UPDATE_DATE:
PRODUCT_FAMILY_ITEM_ID:
GLOBAL_ATTRIBUTE_CATEGORY:
GLOBAL_ATTRIBUTE1:
GLOBAL_ATTRIBUTE2:
GLOBAL_ATTRIBUTE3:
GLOBAL_ATTRIBUTE4:
GLOBAL_ATTRIBUTE5:
GLOBAL_ATTRIBUTE6:
GLOBAL_ATTRIBUTE7:
GLOBAL_ATTRIBUTE8:
GLOBAL_ATTRIBUTE9:
GLOBAL_ATTRIBUTE10:
PURCHASING_TAX_CODE:
OVERCOMPLETION_TOLERANCE_TYPE:
OVERCOMPLETION_TOLERANCE_VALUE:
EFFECTIVITY_CONTROL: 1
CHECK_SHORTAGES_FLAG: N
OVER_SHIPMENT_TOLERANCE:
UNDER_SHIPMENT_TOLERANCE:
OVER_RETURN_TOLERANCE:
UNDER_RETURN_TOLERANCE:
EQUIPMENT_TYPE: 2
RECOVERED_PART_DISP_CODE:
DEFECT_TRACKING_ON_FLAG:
USAGE_ITEM_FLAG:
EVENT_FLAG:
ELECTRONIC_FLAG:
DOWNLOADABLE_FLAG:
VOL_DISCOUNT_EXEMPT_FLAG:
COUPON_EXEMPT_FLAG:
COMMS_NL_TRACKABLE_FLAG:
ASSET_CREATION_CODE:
COMMS_ACTIVATION_REQD_FLAG:
ORDERABLE_ON_WEB_FLAG:
BACK_ORDERABLE_FLAG:
WEB_STATUS: UNPUBLISHED
INDIVISIBLE_FLAG:
DIMENSION_UOM_CODE:
UNIT_LENGTH:
UNIT_WIDTH:
UNIT_HEIGHT:
BULK_PICKED_FLAG: N
LOT_STATUS_ENABLED: N
DEFAULT_LOT_STATUS_ID:
SERIAL_STATUS_ENABLED: N
DEFAULT_SERIAL_STATUS_ID:
LOT_SPLIT_ENABLED: N
LOT_MERGE_ENABLED: N
INVENTORY_CARRY_PENALTY:
OPERATION_SLACK_PENALTY:
FINANCING_ALLOWED_FLAG:
EAM_ITEM_TYPE:
EAM_ACTIVITY_TYPE_CODE:
EAM_ACTIVITY_CAUSE_CODE:
EAM_ACT_NOTIFICATION_FLAG:
EAM_ACT_SHUTDOWN_STATUS:
DUAL_UOM_CONTROL: 1
SECONDARY_UOM_CODE:
DUAL_UOM_DEVIATION_HIGH: 0
DUAL_UOM_DEVIATION_LOW: 0
CONTRACT_ITEM_TYPE_CODE:
SUBSCRIPTION_DEPEND_FLAG:
SERV_REQ_ENABLED_CODE:
SERV_BILLING_ENABLED_FLAG: N
SERV_IMPORTANCE_LEVEL:
PLANNED_INV_POINT_FLAG:
LOT_TRANSLATE_ENABLED: N
DEFAULT_SO_SOURCE_TYPE: INTERNAL
CREATE_SUPPLY_FLAG: Y
SUBSTITUTION_WINDOW_CODE:
SUBSTITUTION_WINDOW_DAYS:
IB_ITEM_INSTANCE_CLASS:
CONFIG_MODEL_TYPE:
LOT_SUBSTITUTION_ENABLED:
MINIMUM_LICENSE_QUANTITY:
EAM_ACTIVITY_SOURCE_CODE:
LIFECYCLE_ID:
CURRENT_PHASE_ID:
OBJECT_VERSION_NUMBER: 2
TRACKING_QUANTITY_IND: P
ONT_PRICING_QTY_SOURCE: P
SECONDARY_DEFAULT_IND:
OPTION_SPECIFIC_SOURCED:
APPROVAL_STATUS:
VMI_MINIMUM_UNITS:
VMI_MINIMUM_DAYS:
VMI_MAXIMUM_UNITS:
VMI_MAXIMUM_DAYS:
VMI_FIXED_ORDER_QUANTITY:
SO_AUTHORIZATION_FLAG: 1
CONSIGNED_FLAG: 2
ASN_AUTOEXPIRE_FLAG: 2
VMI_FORECAST_TYPE: 1
FORECAST_HORIZON:
EXCLUDE_FROM_BUDGET_FLAG: 2
DAYS_TGT_INV_SUPPLY:
DAYS_TGT_INV_WINDOW:
DAYS_MAX_INV_SUPPLY:
DAYS_MAX_INV_WINDOW:
DRP_PLANNED_FLAG: 2
CRITICAL_COMPONENT_FLAG: 2
CONTINOUS_TRANSFER: 3
CONVERGENCE: 3
DIVERGENCE: 3
CONFIG_ORGS:
CONFIG_MATCH:
ATTRIBUTE16:
ATTRIBUTE17:
ATTRIBUTE18:
ATTRIBUTE19:
ATTRIBUTE20:
ATTRIBUTE21:
ATTRIBUTE22:
ATTRIBUTE23:
ATTRIBUTE24:
ATTRIBUTE25:
ATTRIBUTE26:
ATTRIBUTE27:
ATTRIBUTE28:
ATTRIBUTE29:
ATTRIBUTE30:
CAS_NUMBER:
CHILD_LOT_FLAG: N
CHILD_LOT_PREFIX:
CHILD_LOT_STARTING_NUMBER:
CHILD_LOT_VALIDATION_FLAG: N
COPY_LOT_ATTRIBUTE_FLAG: N
DEFAULT_GRADE:
EXPIRATION_ACTION_CODE:
EXPIRATION_ACTION_INTERVAL:
GRADE_CONTROL_FLAG: N
HAZARDOUS_MATERIAL_FLAG: N
HOLD_DAYS:
LOT_DIVISIBLE_FLAG: N
MATURITY_DAYS:
PARENT_CHILD_GENERATION_FLAG:
PROCESS_COSTING_ENABLED_FLAG: N
PROCESS_EXECUTION_ENABLED_FLAG: N
PROCESS_QUALITY_ENABLED_FLAG: N
PROCESS_SUPPLY_LOCATOR_ID:
PROCESS_SUPPLY_SUBINVENTORY:
PROCESS_YIELD_LOCATOR_ID:
PROCESS_YIELD_SUBINVENTORY:
RECIPE_ENABLED_FLAG: N
RETEST_INTERVAL:
CHARGE_PERIODICITY_CODE:
REPAIR_LEADTIME:
REPAIR_YIELD:
PREPOSITION_POINT: N
REPAIR_PROGRAM: 3
SUBCONTRACTING_COMPONENT:
OUTSOURCED_ASSEMBLY: 2
EGO_MASTER_ITEMS_DFF_CTX:
select * from MTL_SYSTEM_ITEMS order by creation_date desc
Single Record View
As of: dd/mm/yyyy hh:mm:ss
INVENTORY_ITEM_ID: 236238
ORGANIZATION_ID: 204
LAST_UPDATE_DATE: 07/02/2015 16:48:30
LAST_UPDATED_BY: 1012012
CREATION_DATE: 07/02/2015 15:24:06
CREATED_BY: 1012012
LAST_UPDATE_LOGIN: 4139263
SUMMARY_FLAG: N
ENABLED_FLAG: Y
START_DATE_ACTIVE:
END_DATE_ACTIVE:
DESCRIPTION: A8 part for assem D1
BUYER_ID: 59
ACCOUNTING_RULE_ID:
INVOICING_RULE_ID:
SEGMENT1: A8P2
SEGMENT2:
SEGMENT3:
SEGMENT4:
SEGMENT5:
SEGMENT6:
SEGMENT7:
SEGMENT8:
SEGMENT9:
SEGMENT10:
SEGMENT11:
SEGMENT12:
SEGMENT13:
SEGMENT14:
SEGMENT15:
SEGMENT16:
SEGMENT17:
SEGMENT18:
SEGMENT19:
SEGMENT20:
ATTRIBUTE_CATEGORY:
ATTRIBUTE1:
ATTRIBUTE2:
ATTRIBUTE3:
ATTRIBUTE4:
ATTRIBUTE5:
ATTRIBUTE6:
ATTRIBUTE7:
ATTRIBUTE8:
ATTRIBUTE9:
ATTRIBUTE10:
ATTRIBUTE11:
ATTRIBUTE12:
ATTRIBUTE13:
ATTRIBUTE14:
ATTRIBUTE15:
PURCHASING_ITEM_FLAG: Y
SHIPPABLE_ITEM_FLAG: N
CUSTOMER_ORDER_FLAG: N
INTERNAL_ORDER_FLAG: N
SERVICE_ITEM_FLAG: N
INVENTORY_ITEM_FLAG: Y
ENG_ITEM_FLAG: N
INVENTORY_ASSET_FLAG: N
PURCHASING_ENABLED_FLAG: Y
CUSTOMER_ORDER_ENABLED_FLAG: N
INTERNAL_ORDER_ENABLED_FLAG: N
SO_TRANSACTIONS_FLAG: N
MTL_TRANSACTIONS_ENABLED_FLAG: Y
STOCK_ENABLED_FLAG: Y
BOM_ENABLED_FLAG: N
BUILD_IN_WIP_FLAG: Y
REVISION_QTY_CONTROL_CODE: 1
ITEM_CATALOG_GROUP_ID:
CATALOG_STATUS_FLAG: N
RETURNABLE_FLAG: N
DEFAULT_SHIPPING_ORG:
COLLATERAL_FLAG:
TAXABLE_FLAG: N
QTY_RCV_EXCEPTION_CODE:
ALLOW_ITEM_DESC_UPDATE_FLAG: Y
INSPECTION_REQUIRED_FLAG:
RECEIPT_REQUIRED_FLAG: Y
MARKET_PRICE:
HAZARD_CLASS_ID:
RFQ_REQUIRED_FLAG: N
QTY_RCV_TOLERANCE:
LIST_PRICE_PER_UNIT:
UN_NUMBER_ID:
PRICE_TOLERANCE_PERCENT: 0
ASSET_CATEGORY_ID:
ROUNDING_FACTOR:
UNIT_OF_ISSUE:
ENFORCE_SHIP_TO_LOCATION_CODE:
ALLOW_SUBSTITUTE_RECEIPTS_FLAG:
ALLOW_UNORDERED_RECEIPTS_FLAG:
ALLOW_EXPRESS_DELIVERY_FLAG:
DAYS_EARLY_RECEIPT_ALLOWED:
DAYS_LATE_RECEIPT_ALLOWED:
RECEIPT_DAYS_EXCEPTION_CODE:
RECEIVING_ROUTING_ID:
INVOICE_CLOSE_TOLERANCE:
RECEIVE_CLOSE_TOLERANCE:
AUTO_LOT_ALPHA_PREFIX:
START_AUTO_LOT_NUMBER:
LOT_CONTROL_CODE: 1
SHELF_LIFE_CODE: 1
SHELF_LIFE_DAYS: 0
SERIAL_NUMBER_CONTROL_CODE: 1
START_AUTO_SERIAL_NUMBER:
AUTO_SERIAL_ALPHA_PREFIX:
SOURCE_TYPE:
SOURCE_ORGANIZATION_ID:
SOURCE_SUBINVENTORY:
EXPENSE_ACCOUNT: 13185
ENCUMBRANCE_ACCOUNT:
RESTRICT_SUBINVENTORIES_CODE: 2
UNIT_WEIGHT:
WEIGHT_UOM_CODE:
VOLUME_UOM_CODE:
UNIT_VOLUME:
RESTRICT_LOCATORS_CODE: 2
LOCATION_CONTROL_CODE: 1
SHRINKAGE_RATE:
ACCEPTABLE_EARLY_DAYS:
PLANNING_TIME_FENCE_CODE: 4
DEMAND_TIME_FENCE_CODE:
LEAD_TIME_LOT_SIZE: 1
STD_LOT_SIZE:
CUM_MANUFACTURING_LEAD_TIME:
OVERRUN_PERCENTAGE:
MRP_CALCULATE_ATP_FLAG:
ACCEPTABLE_RATE_INCREASE: 0
ACCEPTABLE_RATE_DECREASE: 0
CUMULATIVE_TOTAL_LEAD_TIME:
PLANNING_TIME_FENCE_DAYS: 1
DEMAND_TIME_FENCE_DAYS:
END_ASSEMBLY_PEGGING_FLAG: N
REPETITIVE_PLANNING_FLAG: N
PLANNING_EXCEPTION_SET:
BOM_ITEM_TYPE: 4
PICK_COMPONENTS_FLAG: N
REPLENISH_TO_ORDER_FLAG: N
BASE_ITEM_ID:
ATP_COMPONENTS_FLAG: N
ATP_FLAG: N
FIXED_LEAD_TIME:
VARIABLE_LEAD_TIME:
WIP_SUPPLY_LOCATOR_ID:
WIP_SUPPLY_TYPE: 1
WIP_SUPPLY_SUBINVENTORY:
PRIMARY_UOM_CODE: Ea
PRIMARY_UNIT_OF_MEASURE: Each
ALLOWED_UNITS_LOOKUP_CODE: 3
COST_OF_SALES_ACCOUNT: 12951
SALES_ACCOUNT: 12879
DEFAULT_INCLUDE_IN_ROLLUP_FLAG:
INVENTORY_ITEM_STATUS_CODE: Active
INVENTORY_PLANNING_CODE: 6
PLANNER_CODE:
PLANNING_MAKE_BUY_CODE: 2
FIXED_LOT_MULTIPLIER:
ROUNDING_CONTROL_TYPE:
CARRYING_COST:
POSTPROCESSING_LEAD_TIME: 0
PREPROCESSING_LEAD_TIME:
FULL_LEAD_TIME:
ORDER_COST:
MRP_SAFETY_STOCK_PERCENT:
MRP_SAFETY_STOCK_CODE: 1
MIN_MINMAX_QUANTITY:
MAX_MINMAX_QUANTITY:
MINIMUM_ORDER_QUANTITY:
FIXED_ORDER_QUANTITY:
FIXED_DAYS_SUPPLY:
MAXIMUM_ORDER_QUANTITY:
ATP_RULE_ID:
PICKING_RULE_ID:
RESERVABLE_TYPE: 1
POSITIVE_MEASUREMENT_ERROR:
NEGATIVE_MEASUREMENT_ERROR:
ENGINEERING_ECN_CODE:
ENGINEERING_ITEM_ID:
ENGINEERING_DATE:
SERVICE_STARTING_DELAY:
VENDOR_WARRANTY_FLAG: N
SERVICEABLE_COMPONENT_FLAG: N
SERVICEABLE_PRODUCT_FLAG: N
BASE_WARRANTY_SERVICE_ID:
PAYMENT_TERMS_ID:
PREVENTIVE_MAINTENANCE_FLAG: N
PRIMARY_SPECIALIST_ID:
SECONDARY_SPECIALIST_ID:
SERVICEABLE_ITEM_CLASS_ID:
TIME_BILLABLE_FLAG:
MATERIAL_BILLABLE_FLAG:
EXPENSE_BILLABLE_FLAG:
PRORATE_SERVICE_FLAG: N
COVERAGE_SCHEDULE_ID:
SERVICE_DURATION_PERIOD_CODE:
SERVICE_DURATION:
WARRANTY_VENDOR_ID:
MAX_WARRANTY_AMOUNT:
RESPONSE_TIME_PERIOD_CODE:
RESPONSE_TIME_VALUE:
NEW_REVISION_CODE:
INVOICEABLE_ITEM_FLAG: N
TAX_CODE:
INVOICE_ENABLED_FLAG: N
MUST_USE_APPROVED_VENDOR_FLAG: N
REQUEST_ID:
PROGRAM_APPLICATION_ID:
PROGRAM_ID:
PROGRAM_UPDATE_DATE:
OUTSIDE_OPERATION_FLAG: N
OUTSIDE_OPERATION_UOM_TYPE:
SAFETY_STOCK_BUCKET_DAYS:
AUTO_REDUCE_MPS:
COSTING_ENABLED_FLAG: N
AUTO_CREATED_CONFIG_FLAG: N
CYCLE_COUNT_ENABLED_FLAG: N
ITEM_TYPE:
MODEL_CONFIG_CLAUSE_NAME:
SHIP_MODEL_COMPLETE_FLAG: N
MRP_PLANNING_CODE: 6
RETURN_INSPECTION_REQUIREMENT: 2
ATO_FORECAST_CONTROL:
RELEASE_TIME_FENCE_CODE:
RELEASE_TIME_FENCE_DAYS:
CONTAINER_ITEM_FLAG:
VEHICLE_ITEM_FLAG:
MAXIMUM_LOAD_WEIGHT:
MINIMUM_FILL_PERCENT:
CONTAINER_TYPE_CODE:
INTERNAL_VOLUME:
WH_UPDATE_DATE:
PRODUCT_FAMILY_ITEM_ID:
GLOBAL_ATTRIBUTE_CATEGORY:
GLOBAL_ATTRIBUTE1:
GLOBAL_ATTRIBUTE2:
GLOBAL_ATTRIBUTE3:
GLOBAL_ATTRIBUTE4:
GLOBAL_ATTRIBUTE5:
GLOBAL_ATTRIBUTE6:
GLOBAL_ATTRIBUTE7:
GLOBAL_ATTRIBUTE8:
GLOBAL_ATTRIBUTE9:
GLOBAL_ATTRIBUTE10:
PURCHASING_TAX_CODE:
OVERCOMPLETION_TOLERANCE_TYPE:
OVERCOMPLETION_TOLERANCE_VALUE:
EFFECTIVITY_CONTROL: 1
CHECK_SHORTAGES_FLAG: N
OVER_SHIPMENT_TOLERANCE:
UNDER_SHIPMENT_TOLERANCE:
OVER_RETURN_TOLERANCE:
UNDER_RETURN_TOLERANCE:
EQUIPMENT_TYPE: 2
RECOVERED_PART_DISP_CODE:
DEFECT_TRACKING_ON_FLAG:
USAGE_ITEM_FLAG:
EVENT_FLAG:
ELECTRONIC_FLAG:
DOWNLOADABLE_FLAG:
VOL_DISCOUNT_EXEMPT_FLAG:
COUPON_EXEMPT_FLAG:
COMMS_NL_TRACKABLE_FLAG:
ASSET_CREATION_CODE:
COMMS_ACTIVATION_REQD_FLAG:
ORDERABLE_ON_WEB_FLAG:
BACK_ORDERABLE_FLAG:
WEB_STATUS: UNPUBLISHED
INDIVISIBLE_FLAG:
DIMENSION_UOM_CODE:
UNIT_LENGTH:
UNIT_WIDTH:
UNIT_HEIGHT:
BULK_PICKED_FLAG: N
LOT_STATUS_ENABLED: N
DEFAULT_LOT_STATUS_ID:
SERIAL_STATUS_ENABLED: N
DEFAULT_SERIAL_STATUS_ID:
LOT_SPLIT_ENABLED: N
LOT_MERGE_ENABLED: N
INVENTORY_CARRY_PENALTY:
OPERATION_SLACK_PENALTY:
FINANCING_ALLOWED_FLAG:
EAM_ITEM_TYPE:
EAM_ACTIVITY_TYPE_CODE:
EAM_ACTIVITY_CAUSE_CODE:
EAM_ACT_NOTIFICATION_FLAG:
EAM_ACT_SHUTDOWN_STATUS:
DUAL_UOM_CONTROL: 1
SECONDARY_UOM_CODE:
DUAL_UOM_DEVIATION_HIGH: 0
DUAL_UOM_DEVIATION_LOW: 0
CONTRACT_ITEM_TYPE_CODE:
SUBSCRIPTION_DEPEND_FLAG:
SERV_REQ_ENABLED_CODE:
SERV_BILLING_ENABLED_FLAG: N
SERV_IMPORTANCE_LEVEL:
PLANNED_INV_POINT_FLAG:
LOT_TRANSLATE_ENABLED: N
DEFAULT_SO_SOURCE_TYPE: INTERNAL
CREATE_SUPPLY_FLAG: Y
SUBSTITUTION_WINDOW_CODE:
SUBSTITUTION_WINDOW_DAYS:
IB_ITEM_INSTANCE_CLASS:
CONFIG_MODEL_TYPE:
LOT_SUBSTITUTION_ENABLED:
MINIMUM_LICENSE_QUANTITY:
EAM_ACTIVITY_SOURCE_CODE:
LIFECYCLE_ID:
CURRENT_PHASE_ID:
OBJECT_VERSION_NUMBER: 2
TRACKING_QUANTITY_IND: P
ONT_PRICING_QTY_SOURCE: P
SECONDARY_DEFAULT_IND:
OPTION_SPECIFIC_SOURCED:
APPROVAL_STATUS:
VMI_MINIMUM_UNITS:
VMI_MINIMUM_DAYS:
VMI_MAXIMUM_UNITS:
VMI_MAXIMUM_DAYS:
VMI_FIXED_ORDER_QUANTITY:
SO_AUTHORIZATION_FLAG: 1
CONSIGNED_FLAG: 2
ASN_AUTOEXPIRE_FLAG: 2
VMI_FORECAST_TYPE: 1
FORECAST_HORIZON:
EXCLUDE_FROM_BUDGET_FLAG: 2
DAYS_TGT_INV_SUPPLY:
DAYS_TGT_INV_WINDOW:
DAYS_MAX_INV_SUPPLY:
DAYS_MAX_INV_WINDOW:
DRP_PLANNED_FLAG: 2
CRITICAL_COMPONENT_FLAG: 2
CONTINOUS_TRANSFER: 3
CONVERGENCE: 3
DIVERGENCE: 3
CONFIG_ORGS:
CONFIG_MATCH:
ATTRIBUTE16:
ATTRIBUTE17:
ATTRIBUTE18:
ATTRIBUTE19:
ATTRIBUTE20:
ATTRIBUTE21:
ATTRIBUTE22:
ATTRIBUTE23:
ATTRIBUTE24:
ATTRIBUTE25:
ATTRIBUTE26:
ATTRIBUTE27:
ATTRIBUTE28:
ATTRIBUTE29:
ATTRIBUTE30:
CAS_NUMBER:
CHILD_LOT_FLAG: N
CHILD_LOT_PREFIX:
CHILD_LOT_STARTING_NUMBER:
CHILD_LOT_VALIDATION_FLAG: N
COPY_LOT_ATTRIBUTE_FLAG: N
DEFAULT_GRADE:
EXPIRATION_ACTION_CODE:
EXPIRATION_ACTION_INTERVAL:
GRADE_CONTROL_FLAG: N
HAZARDOUS_MATERIAL_FLAG: N
HOLD_DAYS:
LOT_DIVISIBLE_FLAG: N
MATURITY_DAYS:
PARENT_CHILD_GENERATION_FLAG:
PROCESS_COSTING_ENABLED_FLAG: N
PROCESS_EXECUTION_ENABLED_FLAG: N
PROCESS_QUALITY_ENABLED_FLAG: N
PROCESS_SUPPLY_LOCATOR_ID:
PROCESS_SUPPLY_SUBINVENTORY:
PROCESS_YIELD_LOCATOR_ID:
PROCESS_YIELD_SUBINVENTORY:
RECIPE_ENABLED_FLAG: N
RETEST_INTERVAL:
CHARGE_PERIODICITY_CODE:
REPAIR_LEADTIME:
REPAIR_YIELD:
PREPOSITION_POINT: N
REPAIR_PROGRAM: 3
SUBCONTRACTING_COMPONENT:
OUTSOURCED_ASSEMBLY: 2
EGO_MASTER_ITEMS_DFF_CTX:
No comments:
Post a Comment