mtl_system_items_b分析.docxVIP

IntroductionThe basic table mtl_system_items_b is the basic table of item in ERP system and there are a lot of columns,but I don’t know used of each column,particularly the column like %_flag. The reason of general exception may be because the ‘%_flag’ is ‘Y’ or ‘N’.So I record that the corresponding relationship between column and interface.I believe it is good for you when generate exception.物料：segment1说明：description主要：primary_unit_of_measure跟踪：tracking_quantity_ind定价：ont_pricing_qty_source辅助：secondary_uom_code默认：secondary_default_ind正值差系数：dual_uom_deviation_high物料状态：inventory_item_status_code负值差系数：dual_uom_deviation_low用户物料类型：item_type转换---标准：allowed_units_lookup_code = 2转换---特定物料：allowed_units_lookup_code = 1转换---二者：allowed_units_lookup_code = 3库存物料：inventory_item_flag（Y/N）可储存：stock_enabled_flag（Y/N）可处理：mtl_transactions_enabled_flag（Y/N）版本控制：revision_qty_control_code (1/2)不勾为1，勾选为2可保留：reservable_type（1/2）不勾为2，勾选为1检查物料短缺:check_shortages_flag（Y/N）批次控制—控制：shelf_life_code（不控制：1）（存储期限：2）（自定义：4）存储期限:shelf_life_days重新测试间隔：retest_interval到期活动间隔：expiration_action_interval到期活动：expiration_action_code启用周期盘点：cycle_count_enabled_flag负计量误差：negative_measurement_error正计量误差：positive_measurement_error序列—生成：serial_number_control_code（不控制：1，接受时：5，发放销售订单时：6，预定义：2）起始前缀：auto_serial_alpha_prefix起始编号：start_auto_serial_number批次--控制：lot_control_code（不控制：1，完全控制：2）批次—起始前缀：auto_lot_alpha_prefix批次—起始编号：start_auto_lot_number批次—到期天数：maturity_days批次—暂挂天数：hold_days按等级控制：grade_control_flag默认等级：default_grade货位控制：location_control_code（不控制：1，预指定：2，动态录入：3）限制子库存：restrict_subinventories_code（不限为2，限制为1）限制货位：restrict_locators_code（不限为2，限制为1）默认物料状态：default_material_status_id启用批次状态：lot_status_enabled启用序列状态：serial_status_enabled默认批次状态：default_lot_status_id默认序列状态:default_serial_status_id启用子批次：child_lot_flag生成子批次：parent_child_generation_flag（父加子：C,父流程：L）前缀：child_lot_prefix起始编号：child_lot_starting_number格式验证:child_lot_validation_flag复制批次属性：copy_lot_attribute_flag启用批次分解：lot_split_enabled启用批次合并：lot_merge_enabled启用