DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/Replenishment/ReplenishmentROPWeekPlan.cs

using Microsoft.EntityFrameworkCore;
using System;
using System.ComponentModel.DataAnnotations;

namespace Business.Domain
{
    /// <summary>
    ///补货模型ROP
    /// </summary>
    [Comment("补货模型ROP周计划")]
    [Index(nameof(number), nameof(tenant_id), nameof(fversion),nameof(planmonth), nameof(factory_id), IsUnique = true)]
    public class ReplenishmentROPWeekPlan : BaseEntity
    {
        /// <summary>
        /// 物料编码
        /// </summary>
        [StringLength(80)]
        [Comment("物料编码")]
        public string number { get; set; }
        /// <summary>
        /// 物料名称
        /// </summary>
        [StringLength(200)]
        [Comment("物料名称")]
        public string name { get; set; }
        /// <summary>
        /// 规格型号
        /// </summary>
        [StringLength(200)]
        [Comment("规格型号")]
        public string model { get; set; }

        /// <summary>
        /// 生命周期    
        /// </summary>
        [StringLength(50)]
        public string? lifecycle { get; set; }

        /// <summary>
        /// 市场    
        /// </summary>
        [StringLength(50)]
        public string? area { get; set; }

        /// <summary>
        /// 物料属性:0.配置类 1.自制 2.委外加工 3.外购 4.虚拟件
        /// </summary>
        [Comment("物料属性")]
        public int? erp_cls { get; set; }


        /// <summary>
        /// 版本号
        /// </summary>
        [StringLength(80)]
        [Comment("版本号")]
        public string? fversion { get; set; }


        /// <summary>
        /// 计划发货数量
        /// </summary>
        [Precision(20, 8)]
        [Comment("发货计划")]
        public decimal? plan_out_qty { get; set; }

        /// <summary>
        /// 月均需求
        /// </summary>
        [Precision(20, 8)]
        [Comment("月均需求")]
        public decimal? monthl_avg_demand { get; set; }


        /// <summary>
        /// 月均需求标准方差
        /// </summary>
        [Precision(20, 8)]
        [Comment("月均需求标准方差")]
        public decimal? monthl_avg_demand_variance { get; set; }


        /// <summary>
        /// 月均出库
        /// </summary>
        [Precision(20, 8)]
        [Comment("月均出库")]
        public decimal? monthl_avg_outstock { get; set; }



        /// <summary>
        /// 供应前置期参数(天）
        /// </summary>
        [Precision(20, 8)]
        [Comment("供应前置期参数(天）")]
        public decimal? supply_leadtime { get; set; }

        /// <summary>
        /// ABC分类
        /// </summary>
        [StringLength(8)]
        [Comment("ABC分类")]
        public string? abc { get; set; }

        /// <summary>
        /// FMR分类
        /// </summary>
        [StringLength(8)]
        [Comment("FMR分类")]
        public string? fmr { get; set; }

        /// <summary>
        /// Z服务水平参数
        /// </summary>
        [Precision(20, 8)]
        [Comment("Z服务水平参数")]
        public decimal? service_level_pct { get; set; }

        /// <summary>
        /// 存货周转率
        /// </summary>
        [Precision(20, 8)]
        [Comment("存货周转率")]
        public decimal? stock_turnover { get; set; }


        /// <summary>
        /// 最小包装
        /// </summary>
        [Precision(20, 8)]
        [Comment("最小包装")]
        public decimal? min_pack_qty { get; set; }

        /// <summary>
        /// 最小批量
        /// </summary>
        [Precision(20, 8)]
        [Comment("最小批量")]
        public decimal? moq { get; set; }

        /// <summary>
        /// 安全库存
        /// </summary>
        [Precision(20, 8)]
        [Comment("安全库存")]
        public decimal? security_stock { get; set; }

        /// <summary>
        /// 圆整后供应批量
        /// </summary>
        [Precision(20, 8)]
        [Comment("圆整后供应批量")]
        public decimal? eop { get; set; }

        /// <summary>
        /// 重新订货点
        /// </summary>
        [Precision(20, 8)]
        [Comment("重新订货点")]
        public decimal? rop_computed { get; set; }

        /// <summary>
        /// 月均出库最高库存
        /// </summary>
        [Precision(20, 8)]
        [Comment("月均出库最高库存")]
        public decimal? max_stock_level { get; set; }

        /// <summary>
        /// 修正后重新订货点
        /// </summary>
        [Precision(20, 8)]
        [Comment("修正后重新订货点")]
        public decimal? rop_revised { get; set; }

        /// <summary>
        /// 该月触发补货量
        /// </summary>
        [Precision(20, 8)]
        [Comment("该月触发补货量")]
        public decimal? montheop1 { get; set; }

        /// <summary>
        /// 该月触发安全库存补货量
        /// </summary>
        [Precision(20, 8)]
        [Comment("该月触发安全库存补货量")]
        public decimal? montheop2 { get; set; }

        /// <summary>
        /// 可用库存
        /// </summary>
        [Precision(20, 8)]
        [Comment("可用库存")]
        public decimal? avaStockQty { get; set; }

        /// <summary>
        /// 销售/渠道   
        /// </summary>
        [Comment("销售/渠道")]
        public string distributionchannel { get; set; }

        /// <summary>
        /// 年份
        /// </summary>
        [Comment("年份")]
        public int? year { get; set; }

        /// <summary>
        /// 月份
        /// </summary>
        [Comment("月份")]
        public int? month { get; set; }

        /// <summary>
        /// 计划年月
        /// </summary>
        [Comment("计划年月")]
        public string planmonth { get; set; }

        /// <summary>
        /// 产品线    
        /// </summary>
        [StringLength(128)]
        [Comment("产品线")]
        public string? ProdLine { get; set; }

        /// <summary>
        /// 产品系列    
        /// </summary>
        [StringLength(128)]
        [Comment("产品系列")]
        public string? ProdRange { get; set; }

        /// <summary>
        /// 语种    
        /// </summary>
        [StringLength(128)]
        [Comment("语种")]
        public string? Languages { get; set; }

    }
}