DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/Replenishment/ReplenishmentROP.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(long_period),nameof(short_period),nameof(isparam), nameof(seqno),nameof(zero_based_seqno), nameof(factory_id), IsUnique = true)]
    public class ReplenishmentROP : 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? actual_period_start_instock { get; set; }

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

        /// <summary>
        /// 实际发货 为空或-1时表示不适用，为0时表示没有发货记录。注意能区分这两种形式
        /// </summary>
        [Precision(20, 8)]
        [Comment("实际发货")]
        public decimal? actual_out_qty { get; set; }

        /// <summary>
        /// 计划生产
        /// </summary>
        [Precision(20, 8)]
        [Comment("计划生产")]
        public decimal? plan_in { get; set; }

        /// <summary>
        /// 实际生产
        /// </summary>
        [Precision(20, 8)]
        [Comment("实际生产")]
        public decimal? actual_in { get; set; }

        /// <summary>
        /// 计划期末库存
        /// </summary>
        [Precision(20, 8)]
        [Comment("计划期末库存")]
        public decimal? plan_period_end_instock { get; set; }

        /// <summary>
        /// 实际期末库存
        /// </summary>
        [Precision(20, 8)]
        [Comment("实际期末库存")]
        public decimal? actual_period_end_instock { get; set; }

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

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

        /// <summary>
        /// 长周期:年Y月M周W
        /// </summary>
        [StringLength(8)]
        [Comment("长周期")]
        public string? long_period { get; set; }

        /// <summary>
        /// 短周期:月M周W日D
        /// </summary>
        [StringLength(8)]
        [Comment("短周期")]
        public string? short_period { get; set; }


        /// <summary>
        /// 序次号，短在长中间的序次号，在补货模型中，长周期都是年，短周期是月（1~12）， 或周（1~53）
        /// </summary>
        [Comment("序次号，短在长中间的序次号，在补货模型中，长周期都是年，短周期是月（1~12）， 或周（1~53）")]
        public int? seqno { get; set; }

        /// <summary>
        /// 计算辅助列，由于月和周是分别的记录，都可以区分开。	当前周期为0，前后到h ~f每个周期末动态修改方便计算使用
        /// </summary>
        [Comment("计算辅助列，由于月和周是分别的记录，都可以区分开。当前周期为0，前后到h ~f每个周期末动态修改方便计算使用")]
        public int? zero_based_seqno { get; set; }

        /// <summary>
        /// 周期开始日期
        /// </summary>
        [Comment("周期开始日期")]
        public DateTime? period_start_date { get; set; }
        /// <summary>
        /// 周期结束日期
        /// </summary>
        [Comment("周期结束日期")]
        public DateTime? period_end_date { 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>
        [Comment("销售/渠道")]
        public string distributionchannel { get; set; }

        /// <summary>
        /// 是否是计算参数，默认为否，是的话一月更新一次
        /// </summary>
        [Comment("是否是计算参数，默认为否，是的话一月更新一次")]
        public bool isparam { get; set; }
    }
}