using Microsoft.EntityFrameworkCore; using System; using System.ComponentModel.DataAnnotations; namespace Business.Domain { /// ///补货模型ROP /// [Comment("补货模型ROP周计划")] [Index(nameof(number), nameof(tenant_id), nameof(fversion),nameof(planmonth), nameof(factory_id), IsUnique = true)] public class ReplenishmentROPWeekPlan : BaseEntity { /// /// 物料编码 /// [StringLength(80)] [Comment("物料编码")] public string number { get; set; } /// /// 物料名称 /// [StringLength(200)] [Comment("物料名称")] public string name { get; set; } /// /// 规格型号 /// [StringLength(200)] [Comment("规格型号")] public string model { get; set; } /// /// 生命周期 /// [StringLength(50)] public string? lifecycle { get; set; } /// /// 市场 /// [StringLength(50)] public string? area { get; set; } /// /// 物料属性:0.配置类 1.自制 2.委外加工 3.外购 4.虚拟件 /// [Comment("物料属性")] public int? erp_cls { get; set; } /// /// 版本号 /// [StringLength(80)] [Comment("版本号")] public string? fversion { get; set; } /// /// 计划发货数量 /// [Precision(20, 8)] [Comment("发货计划")] public decimal? plan_out_qty { get; set; } /// /// 月均需求 /// [Precision(20, 8)] [Comment("月均需求")] public decimal? monthl_avg_demand { get; set; } /// /// 月均需求标准方差 /// [Precision(20, 8)] [Comment("月均需求标准方差")] public decimal? monthl_avg_demand_variance { get; set; } /// /// 月均出库 /// [Precision(20, 8)] [Comment("月均出库")] public decimal? monthl_avg_outstock { get; set; } /// /// 供应前置期参数(天) /// [Precision(20, 8)] [Comment("供应前置期参数(天)")] public decimal? supply_leadtime { get; set; } /// /// ABC分类 /// [StringLength(8)] [Comment("ABC分类")] public string? abc { get; set; } /// /// FMR分类 /// [StringLength(8)] [Comment("FMR分类")] public string? fmr { get; set; } /// /// Z服务水平参数 /// [Precision(20, 8)] [Comment("Z服务水平参数")] public decimal? service_level_pct { get; set; } /// /// 存货周转率 /// [Precision(20, 8)] [Comment("存货周转率")] public decimal? stock_turnover { get; set; } /// /// 最小包装 /// [Precision(20, 8)] [Comment("最小包装")] public decimal? min_pack_qty { get; set; } /// /// 最小批量 /// [Precision(20, 8)] [Comment("最小批量")] public decimal? moq { get; set; } /// /// 安全库存 /// [Precision(20, 8)] [Comment("安全库存")] public decimal? security_stock { get; set; } /// /// 圆整后供应批量 /// [Precision(20, 8)] [Comment("圆整后供应批量")] public decimal? eop { get; set; } /// /// 重新订货点 /// [Precision(20, 8)] [Comment("重新订货点")] public decimal? rop_computed { get; set; } /// /// 月均出库最高库存 /// [Precision(20, 8)] [Comment("月均出库最高库存")] public decimal? max_stock_level { get; set; } /// /// 修正后重新订货点 /// [Precision(20, 8)] [Comment("修正后重新订货点")] public decimal? rop_revised { get; set; } /// /// 该月触发补货量 /// [Precision(20, 8)] [Comment("该月触发补货量")] public decimal? montheop1 { get; set; } /// /// 该月触发安全库存补货量 /// [Precision(20, 8)] [Comment("该月触发安全库存补货量")] public decimal? montheop2 { get; set; } /// /// 可用库存 /// [Precision(20, 8)] [Comment("可用库存")] public decimal? avaStockQty { get; set; } /// /// 销售/渠道 /// [Comment("销售/渠道")] public string distributionchannel { get; set; } /// /// 年份 /// [Comment("年份")] public int? year { get; set; } /// /// 月份 /// [Comment("月份")] public int? month { get; set; } /// /// 计划年月 /// [Comment("计划年月")] public string planmonth { get; set; } /// /// 产品线 /// [StringLength(128)] [Comment("产品线")] public string? ProdLine { get; set; } /// /// 产品系列 /// [StringLength(128)] [Comment("产品系列")] public string? ProdRange { get; set; } /// /// 语种 /// [StringLength(128)] [Comment("语种")] public string? Languages { get; set; } } }