using Business.Core.Attributes;
using Microsoft.EntityFrameworkCore;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations;
namespace Business.Domain
{
///
/// 物料详情
///
[CollectionName("dopbase", "ic_item")]
[Comment("物料详情")]
[Index(nameof(number), nameof(fversion), nameof(tenant_id), nameof(company_id), nameof(factory_id), IsUnique = true)]
public class ic_item : BaseEntity
{
public ic_item(long Id) : base(Id)
{
}
///
/// 物料编码
///
[StringLength(80)]
[Comment("物料编码")]
public string number { get; set; }
///
/// 物料名称
///
[StringLength(80)]
[Comment("物料名称")]
public string name { get; set; }
///
/// 规格型号
///
[StringLength(200)]
[Comment("规格型号")]
public string model { get; set; }
///
/// 全名
///
[StringLength(255)]
[Comment("全名")]
public string full_name { get; set; }
///
/// fms旧料号
///
[StringLength(80)]
[Comment("fms旧料号")]
public string fms_number { get; set; }
///
/// erp旧料号
///
[StringLength(80)]
[Comment("erp旧料号")]
public string erp_oldnumber { get; set; }
///
/// 图号
///
[StringLength(80)]
[Comment("图号")]
public string chart_number { get; set; }
///
/// 版本号
///
[StringLength(80)]
[Comment("版本号")]
public string fversion { get; set; }
///
/// 盒贴规格
///
[StringLength(200)]
[Comment("盒贴规格")]
public string box_model { get; set; }
///
/// 物料属性
///
[Comment("物料属性")]
public int? erp_cls { get; set; }
///
/// 物料属性名称
///
[StringLength(80)]
[Comment("物料属性")]
public string erp_cls_name { get; set; }
///
/// 单位
///
[StringLength(80)]
[Comment("单位")]
public string unit { get; set; }
///
/// 物料等级
///
[Comment("物料等级")]
public long? item_level { get; set; }
///
/// 单位标准工时_小时
///
[Precision(23, 10)]
[Comment("单位标准工时_小时")]
public decimal? standard_manhour { get; set; }
///
/// 单位材料定额_元
///
[Precision(23, 10)]
[Comment("单位材料定额_元")]
public decimal? unititem_amount { get; set; }
///
/// 来源
///
[StringLength(200)]
[Comment("来源")]
public string? source { get; set; }
///
/// 是否为设备
///
[Comment("是否为设备")]
public int? is_equipment { get; set; }
///
/// 单位包装数量
///
[Precision(23, 10)]
[Comment("单位包装数量")]
public decimal? unit_qty { get; set; }
///
/// 是否关键件
///
[Comment("是否关键件")]
public int? iskeyitem { get; set; }
///
/// 毛重
///
[Precision(23, 10)]
[Comment("毛重")]
public decimal? gross_weight { get; set; }
///
/// 净重
///
[Precision(23, 10)]
[Comment("净重")]
public decimal? net_weight { get; set; }
///
/// 重量单位
///
[StringLength(80)]
[Comment("重量单位")]
public string maund { get; set; }
///
/// 长度
///
[Precision(23, 10)]
[Comment("长度")]
public decimal? length { get; set; }
///
/// 长度单位
///
[StringLength(80)]
[Comment("长度单位")]
public string cubic_measure { get; set; }
///
/// 宽度
///
[Precision(23, 10)]
[Comment("宽度")]
public decimal? width { get; set; }
///
/// 高度
///
[Precision(23, 10)]
[Comment("高度")]
public decimal? height { get; set; }
///
/// 体积
///
[Precision(23, 10)]
[Comment("体积")]
public decimal? size { get; set; }
///
/// 允许采购
///
[Comment("允许采购")]
public int? allowpur { get; set; }
///
/// 允许销售
///
[Comment("允许销售")]
public int? allowsale { get; set; }
///
/// 允许生产
///
[Comment("允许生产")]
public int? allowmanu { get; set; }
///
/// 允许委外
///
[Comment("允许委外")]
public int? allowout { get; set; }
///
/// 批号管理
///
[Comment("批号管理")]
public int? allowbatch { get; set; }
///
/// 序列号管理
///
[Comment("序列号管理")]
public int? allowserial { get; set; }
///
/// 图片
///
[StringLength(80)]
[Comment("图片")]
public string photo { get; set; }
///
/// 领料类型
///
[Comment("领料类型")]
public long? picktype { get; set; }
///
/// 出库类型
///
[Comment("出库类型")]
public long? output_type_id { get; set; }
///
/// 启用预警
///
[Comment("启用预警")]
public int? enable_warning { get; set; }
///
/// 生命周期状态:1-成熟品,2-新品,3-重点新品,4-退市
///
[Comment("生命周期状态")]
public int? life_state { get; set; }
///
/// 经济生产批量
///
[Comment("经济生产批量")]
[Precision(23, 10)]
public decimal? moq { get; set; }
///
/// 最大生产批量
///
[Comment("最大生产批量")]
[Precision(23, 10)]
public decimal? maq { get; set; }
///
/// 是否备料前预处理
///
[Comment("是否备料前预处理")]
public int? is_clean { get; set; }
///
/// 预处理提前期(天)
///
[Comment("预处理提前期")]
[Precision(23, 10)]
public decimal? clean_leadtime { get; set; }
///
/// 工序委外提前期/灭菌提前期(天)
///
[Comment("工序委外提前期")]
[Precision(23, 10)]
public decimal? sterilize_leadtime { get; set; }
///
/// 平台调拨提前期(天)
///
[Comment("平台调拨提前期")]
[Precision(23, 10)]
public decimal? transfer_leadtime { get; set; }
///
/// 标准工期(天)
///
[Comment("标准工期")]
[Precision(23, 10)]
public decimal? standard_period { get; set; }
///
/// FMR分类:F-F类,M-M类,R-R类
///
[Comment("FMR分类")]
[StringLength(80)]
public string fmr { get; set; }
///
/// ABC分类:A-A类,B-B类,C-C类
///
[Comment("ABC分类")]
[StringLength(80)]
public string abc { get; set; }
//ic_plan
/////
///// 物料id
/////
//[Required]
//[Comment("物料id")]
//public long icitem_id { get; set; }
/////
///// 物料名称
/////
//[StringLength(80)]
//[Comment("物料名称")]
//public string? icitem_name { get; set; }
/////
///// 计划员
/////
//[StringLength(80)]
//[Comment("计划员")]
//public string? planner_name { get; set; }
/////
///// 计划员_工号
/////
//[StringLength(80)]
//[Comment("计划员_工号")]
//public string? planner_num { get; set; }
/////
///// 工厂编码
/////
//[StringLength(80)]
//[Comment("工厂编码")]
//public string? factory_code { get; set; }
///
/// 固定提前期(天)
///
[Precision(23, 10)]
[Comment("固定提前期(天)")]
public decimal? fix_leadtime { get; set; }
///
/// 计划策略
///
[Comment("计划策略")]
public int? plan_trategy { get; set; }
///
/// 订货策略
///
[Comment("订货策略")]
public int? order_trategy { get; set; }
///
/// 订货间隔期_天
///
[Precision(23, 10)]
[Comment("订货间隔期_天")]
public decimal? order_inter_val { get; set; }
///
/// 变动提前期
///
[Precision(23, 10)]
[Comment("变动提前期")]
public decimal? lead_time { get; set; }
///
/// 变动提前期批量
///
[Precision(23, 10)]
[Comment("变动提前期批量")]
public decimal? bat_change_economy { get; set; }
///
/// 累计提前期
///
[Precision(23, 10)]
[Comment("累计提前期")]
public decimal? total_tqq { get; set; }
///
/// 再订货点
///
[Precision(23, 10)]
[Comment("再订货点")]
public decimal? order_point { get; set; }
///
/// 设置为固定再订货点
///
[Comment("设置为固定再订货点")]
public int? isfixedreorder { get; set; }
///
/// 安全库存数量
///
[Precision(23, 10)]
[Comment("安全库存数量")]
public decimal? secinv { get; set; }
///
/// 安全库存触发采购比例
///
[Precision(23, 10)]
[Comment("安全库存触发采购比例")]
public decimal? secinv_ratio { get; set; }
///
/// 是否需要进行订补货计划的运算
///
//[Comment("是否需要进行订补货计划的运算")]
//public int? book_plan { get; set; }
///
/// 辅助属性参与计划运算
///
//[Comment("辅助属性参与计划运算")]
//public int? aux_prop_plan { get; set; }
///
/// 计划备注
///
//[StringLength(1000)]
//[Comment("计划备注")]
//public string? plannote { get; set; }
///
/// 计算ID
///
//[Comment("计算id")]
//[NotMapped]
//public long? bang_id { get; set; }
///
/// 自检提前期
///
[Precision(23, 10)]
[Comment("自检提前期")]
public decimal? self_inspection_date { get; set; }
///
/// 入库提前期
///
[Precision(23, 10)]
[Comment("入库提前期")]
public decimal? Warehousing_date { get; set; }
///
/// 发运提前期
///
[Precision(23, 10)]
[Comment("发运提前期")]
public decimal? Shipping_date { get; set; }
//ic_factory_details
///
/// 物料id
///
//[Required]
//[Comment("物料id")]
//public long icitem_id { get; set; }
/////
///// 物料名称
/////
//[StringLength(80)]
//[Comment("物料名称")]
//public string? icitem_name { get; set; }
///
/// 工厂编码
///
//[StringLength(80)]
//[Comment("工厂编码")]
//public string? factory_fode { get; set; }
///
/// 特殊备注
///
//[StringLength(1000)]
//[Comment("特殊备注")]
//public string? note { get; set; }
///
/// 产品线
///
[StringLength(80)]
[Comment("产品线")]
public string product_line { get; set; }
///
/// 领料类型
///
//[Required]
//[Comment("领料类型")]
//public long pick_type { get; set; }
///
/// 是否采用业务批次管理
///
[Comment("是否采用业务批次管理")]
public int batch_manager { get; set; }
///
/// 是否需要库龄管理
///
//[Comment("是否需要库龄管理")]
//public int stock_time { get; set; }
///
/// 盘点周期单位
///
//[StringLength(80)]
//[Comment("盘点周期单位")]
//public string? check_cycunit { get; set; }
///
/// 盘点周期
///
//[Precision(23, 10)]
//[Comment("盘点周期")]
//public decimal? check_cycle { get; set; }
///
/// 每周_月第天
///
//[Comment("每周_月第天")]
//public int days_per { get; set; }
///
/// 上次盘点日期
///
//[Comment("上次盘点日期")]
//public DateTime? last_checkdate { get; set; }
/////
/// 默认待检仓库
///
//[Required]
//[Comment("默认待检仓库")]
//public long default_chkloc { get; set; }
///
/// 默认待检仓位
///
//[Required]
//[Comment("默认待检仓位")]
//public long default_chksp { get; set; }
///
/// 默认仓库
///
//[Required]
//[Comment("默认仓库")]
//public long default_loc { get; set; }
///
/// 默认仓位
///
//[Required]
//[Comment("默认仓位")]
//public long default_sp { get; set; }
///
/// 货架信息
///
//[StringLength(80)]
//[Comment("货架信息")]
//public string? item_shelve { get; set; }
///
/// 默认仓管员
///
//[StringLength(80)]
//[Comment("默认仓管员")]
//public string? default_manager { get; set; }
///
/// 最低存量
///
//[Precision(23, 10)]
//[Comment("最低存量")]
//public decimal? low_limit { get; set; }
///
/// 最高存量
///
//[Precision(23, 10)]
//[Comment("最高存量")]
//public decimal? high_limit { get; set; }
///
/// 最大订货量
///
//[Precision(23, 10)]
//[Comment("最大订货量")]
//public decimal? qty_max { get; set; }
///
/// 日消耗量
///
//[Precision(23, 10)]
//[Comment("日消耗量")]
//public decimal? daily_consume { get; set; }
///
/// 库存备注
///
//[StringLength(1000)]
//[Comment("库存备注")]
//public string? warehouse_note { get; set; }
///
/// 工单发料时间/天
///
[Precision(23, 10)]
[Comment("工单发料时间/天")]
public decimal? ordissu_days { get; set; }
/////
///// 原材料收货处理时间/天
/////
//[Precision(23, 10)]
//[Comment("原材料收货处理时间/天")]
//public decimal? raw_matreceiv_days { get; set; }
/////
///// 成品入库时间/天
/////
//[Precision(23, 10)]
//[Comment("成品入库时间/天")]
//public decimal? prdenter_days { get; set; }
/////
///// 原材料入库时间/天
/////
//[Precision(23, 10)]
//[Comment("原材料入库时间/天")]
//public decimal? mat_enter_days { get; set; }
/////
///// 成品发货时间/天
/////
//[Precision(23, 10)]
//[Comment("成品发货时间/天")]
//public decimal? prd_out_days { get; set; }
///
/// 运输中提前期_天
///
[Comment("运输中提前期_天")]
[Required]
[DefaultValue(0)]
[Precision(23, 10)]
public decimal? transportation_leadtime { get; set; }
///
/// 仓库中提前期_天
///
[Comment("仓库中提前期_天")]
[Required]
[DefaultValue(0)]
[Precision(23, 10)]
public decimal? stock_leadtime { get; set; }
///
/// 生产中提前期_天
///
[Comment("生产中提前期_天")]
[Required]
[DefaultValue(0)]
[Precision(23, 10)]
public decimal? production_leadtime { get; set; }
///
/// 下单前置期_天
///
[Comment("下单前置期_天")]
[Required]
[DefaultValue(0)]
[Precision(23, 10)]
public decimal? order_leadtime { get; set; }
///
/// 最小包装量
///
[Comment("最小包装量")]
[Required]
[DefaultValue(0)]
[Precision(23, 10)]
public decimal? minpackqty { get; set; }
///
/// 最小订单量
///
[Comment("最小订单量")]
[Required]
[DefaultValue(0)]
[Precision(23, 10)]
public decimal? minorderqty { get; set; }
///
/// 是否倒冲
///
[Comment("是否倒冲")]
public int? isbackflush { get; set; }
///
/// 生产负责人
///
//[StringLength(80)]
//[Comment("生产负责人")]
//public string? product_principal { get; set; }
///
/// 倒冲仓库
///
//[StringLength(80)]
//[Comment("倒冲仓库")]
//public string? back_flush_stock { get; set; }
///
/// 倒冲仓位
///
//[StringLength(80)]
//[Comment("倒冲仓位")]
//public string? back_flush_sp { get; set; }
///
/// 投料自动取整
///
[Comment("投料自动取整")]
public int? put_integer { get; set; }
///
/// RS50成品 RS30 组件 RS11 原材料 RS12 零件 RS13 包装材料 RS14 辅料 RS15 低值易耗品 RS99 虚拟物料
///
[StringLength(80)]
[Comment("物料类型")]
public string? item_type { get; set; }
///
/// 供应提前期
///
[Comment("供应提前期")]
[Required]
[DefaultValue(0)]
[Precision(23, 10)]
public int PurLT { get; set; }
///
/// bom设计时间
///
[Comment("bom设计时间")]
[DefaultValue(0)]
public decimal? BOMDesignTime { get; set; }
///
/// 工艺设计时间
///
[Comment("工艺设计时间")]
[DefaultValue(0)]
public decimal? RoutingDesignTime { get; set; }
}
}