1、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,完全控制:批次起始前缀: auto_lot_alpha_p
2、refix批次起始编号: 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_e
3、nabled启用序列状态:serial_status_enabled默认批次状态:default_lot_status_id默认序列状态:default_serial_status_id启用子批次:child_lot_flag生成子批次:parent_child_generation_flag(父加子:C,父流程:L)前缀:child_lot_prefixchild_lot_starting_number格式验证:child_lot_validation_flag复制批次属性:copy_lot_attribute_flag启用批次分解:lot_split_enabled启用批次合并:lot_m
4、erge_enabled启用批次转换:lot_translate_enabled启用批次替代lot_substitution_enabled可分批次:lot_divisible_flag批量调库:bulk_picked_flag允许在BOM:bom_enabled_flag基本模型:base_item_idBOM物料类型:bom_item_type(标准:4,模型:1,选件类:2,计划:3,产品系列:5)有效性控制: effectivity_control(日期:1,模型/部件号:自动创建配置:auto_created_config_flag配置器模型类型: config_model_type
5、创建配置项,BOM: config_orgs匹配配置: config_match资产项目类型: eam_item_type活动类型: eam_activity_type_code关闭类型: eam_act_shutdown_status活动原因: eam_activity_cause_code要求提供活动通知: eam_act_notification_flag活动来源: eam_activity_source_code启用成本计算: costing_enabled_flag库存资产值: inventory_asset_flag包括在累计中: default_include_in_rollup
6、_flag销货成本账户: select * from GL_CODE_COMBINATIONS where code_combination_id=(select cost_of_sales_account from mtl_system_items_b where segment1=jamtest)标准批量: std_lot_size已采购:purchasing_item_flag可采购:purchasing_enabled_flag使用批量的供应商:must_use_approved_vendor_flag允许更新说明:allow_item_desc_update_flag外包装配件:ou
7、tsourced_assembly(勾选:1,不勾选:外协加工物料:outside_operation_flag单位类型:outside_operation_uom_type(装配件:ASSEMBLY,资源:RESOURCE)要求询价:RFQ_REQUIRED_FLAG应纳税:taxable_flag要求接受:receipt_required_flag要求检验:inspection_required_flag默认采购员:buyer_id接受关闭允差:receive_close_toleranceUN编号:un_number_id价目表价格:list_price_per_unit价格允差:pri
8、ce_tolerance_percent保留款账户:encumbrance_account费用账户:expense_account资产类别:asset_category_id发放单位:unit_of_issue发票关闭允差:invoice_close_tolerance危险等级:hazard_class_id市场价格:market_price尾数处理因子:rounding_factor接受日期活动:receipt_days_exception_code(无:NONE,拒绝:REJECT,警告:WARNING)提前天数:DAYS_EARLY_RECEIPT_ALLOWED延迟天数:days_la
9、te_receipt_allowed允许替代接收:allow_substitute_receipts_flag允许未订购接收:allow_unordered_receipts_flag允许快速处理事务:allow_express_delivery_flag超量接收控制活动:qty_rcv_exception_code超量接收控制允差: qty_rcv_tolerance接收方式: receiving_routing_id(标准:1,检验:2,直接:强制收货方: enforce_ship_to_location_code重量单位: weight_uom_code单位重量: unit_weight
10、体积单位: volume_uom_code单位体积: unit_volume维单位: dimension_uom_code维长度: unit_length维宽度: unit_width维高度: unit_height容器: container_item_flag运载工具: vehicle_item_flag货箱类型: container_type_code内容积: internal_volume最大装载重量: maximum_load_weight最小装载百分比: minimum_fill_percent宣传品物料: collateral_flag电子格式: electronic_flag事件
11、: event_flag可下载: downloadable_flag设备: equipment_type(勾选为1,不勾为2)OM整数: indivisible_flag库存计划方法: inventory_planning_code(未计划:6,最大-最小:2,再订购点:1,供应商管理的库存:7)计划员: planner_code分包组件: subcontracting_component制造或采购: planning_make_buy_code(制造:1,采购:最小-最大数量最小: min_minmax_quantity max_minmax_quantity订货量最小: minimum_o
12、rder_quantity maximum_order_quantity成本订单: order_cost成本保留: carrying_cost来源类型: source_type(库存:1,供应商:2,子库存:来源组织: source_organization_id来源子库存: source_subinventory安全库存方法: mrp_safety_stock_code时段天数: safety_stock_bucket_days百分比: mrp_safety_stock_percent固定订货量: fixed_order_quantity固定供应天数: fixed_days_supply固定
13、批次增加: fixed_lot_multiplier最小数量: vmi_minimum_units最小供应天数: vmi_minimum_days最大数量: vmi_maximum_units最大供应天数: vmi_maximum_days固定数量: vmi_fixed_order_quantity要求发放审批: so_authorization_flag(客户:寄销: consigned_flag(勾:1,不勾:自动到期: asn_autoexpire_flag(勾:预测类型:vmi_forecast_type(订单预测:1,销售预测:2,历史销售量:期限天数:forecast_horizo
14、n计划方法:mrp_planning_code(未计划:6,MRP计划:3,MPS计划:4,MPS/MRP计划:7,MPS/MPP计划:8,MPP计划:9)预测控制:ato_forecast_control追溯:end_assembly_pegging_flag例外集:planning_exception_set损耗率:shrinkage_rate容许提前天数:acceptable_early_days重要组件:critical_component_flag(2)舍入订单数量:rounding_control_type(2)计划库存点:planned_inv_point_flag创建供应:cr
15、eate_supply_flag预算中排除:exclude_from_budget_flag重复计划:repetitive_planning_flag超出:overrun_percentage生产率增加允差:acceptable_rate_increase生产率减少允差:acceptable_rate_decrease计算ATP: mrp_calculate_atp_flag减少MPS: auto_reduce_mps计划时间栏: planning_time_fence_code天数: planning_time_fence_days需求时间栏: demand_time_fence_code
16、demand_time_fence_days发放时间栏: release_time_fence_code release_time_fence_days替代件期限: substitution_window_code substitution_window_days持续组织间转移: continous_transfer集中模式: convergence分散模式: divergence计划分配: drp_planned_flag最大库存供应天数: days_max_inv_supply最大库存窗口: days_max_inv_window目标库存供应天数: days_tgt_inv_supply目
17、标库存窗口: days_tgt_inv_window维修方案: repair_program维修产量: repair_yield维修提前期: repair_leadtime预置点: preposition_point预加工: preprocessing_lead_time加工中: full_lead_time后加工: postprocessing_lead_time固定: fixed_lead_time变量: variable_lead_time累计制造:cum_manufacturing_lead_time累计总额:cumulative_total_lead_time提前期批量: lead_
18、time_lot_size在WIP中制造: build_in_wip_flag供应类型: wip_supply_type(推式:1,装配拉式:2,工序拉式:3,批量:4,供应商:5,虚拟:6)供应子库存: wip_supply_subinventory供应货位: wip_supply_locator_id库存存储: inventory_carry_penalty工序损耗: operation_slack_penalty允差类型: overcompletion_tolerance_type(百分比:1,金额:允差值: overcompletion_tolerance_value客户订购: cus
19、tomer_order_flag启用客户订单: customer_order_enabled_flag可发运: shippable_item_flag内部订购: internal_order_flag启用内部订购: internal_order_enabled_flag so_transactions_flag挑选组件: pick_components_flag按订单装配: replenish_to_order_flag完成发运模型: ship_model_complete_flag可退回: returnable_flag要求RMA检验: return_inspection_requireme
20、nt允许财务处理: financing_allowed_flag检查ATP: atp_flagATP规则: atp_rule_idATP组件: atp_components_flag挑库规则: picking_rule_id默认发运组织: default_shipping_org默认销售订单来源类型: default_so_source_type( INTERNAL/ EXTERNAL)计费周期: charge_periodicity_code超量发运: over_shipment_tolerance超量退货: over_return_tolerance短量发运: under_shipment
21、_tolerance短量退货: under_return_tolerance可开票物料:invoiceable_item_flag启用开票:invoice_enabled_flag会计规则:accounting_rule_id开票规则:invoicing_rule_id销项税分类代码:tax_code销售账户:sales_account付款条件:payment_terms_id启用流程质量:process_quality_enabled_flag启用流程成本计算:process_costing_enabled_flag启用处方:recipe_enabled_flag危险物料:hazardous
22、_material_flagCAS编号:cas_number启用执行流程:process_execution_enabled_flagprocess_supply_subinventoryprocess_supply_locator_id产量子库存:process_yield_subinventory产量货位:process_yield_locator_id服务请求:serv_req_enabled_code启用合同服务范围:serviceable_product_flag启用缺陷跟踪:defect_tracking_on_flag启用处理:comms_activation_reqd_flag
23、合同物料类型:contract_item_type_code服务期限:service_duration延续期间:service_duration_period_code模板:coverage_schedule_id起始延迟天数:service_starting_delay在产品安装信息库中跟踪:comms_nl_trackable_flag创建固定资产:asset_creation_code例程分类:ib_item_instance_class处理修复部件:recovered_part_disp_code启用服务开单:serv_billing_enabled_flag开单类型:material_billable_flagWeb状态:web_status可在Web上订购:orderable_on_web_flag可延交订单:back_orderable_flag最少许可证数量:minimum_license_quantity
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1