DEMOMySql/MicroServices/Business/Business.Application.Contracts/Dto/MonthlyShipmentPlanDto.cs

using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Business.Dto
{
    /// <summary>
    /// 物料供应提前期
    /// </summary>
    public class MonthlyShipmentPlanDto
    {
        /// <summary>
        /// 年    
        /// </summary>
        public int Year { get; set; }

        /// <summary>
        /// 地区    
        /// </summary>
        public string Area { get; set; }

        /// <summary>
        /// 产品线    
        /// </summary>
        public string ProdLine { get; set; }

        /// <summary>
        /// 产品系列    
        /// </summary>
        public string ProdRange { get; set; }

        /// <summary>
        /// 规格型号    
        /// </summary>
        public string Model { get; set; }

        /// <summary>
        /// 计划年月    
        /// </summary>
        public string PlanMonth { get; set; }

        /// <summary>
        /// 数量    
        /// </summary>
        public decimal Qty { get; set; }

        /// <summary>
        /// 排序编码    
        /// </summary>
        public int OrderNum { get; set; }

        /// <summary>
        /// 生命周期    
        /// </summary>
        public string LifeCycle { get; set; }

        /// <summary>
        /// SAP料号   
        /// </summary>
        public string SAPItemNumber { get; set; }

        /// <summary>
        /// 语种   
        /// </summary>
        public string Languages { get; set; }

        /// <summary>
        /// 销售/渠道   
        /// </summary>
        public string DistributionChannel { get; set; }

        /// <summary>
        /// 物料属性
        /// </summary>
        [Comment("物料属性")]
        public int? erp_cls { get; set; }

        /// <summary>
        /// 供应提前期
        /// </summary>
        public decimal? PLT { get; set; }

        /// <summary>
        /// 是否长周期物料
        /// </summary>
        public bool IsLongPeriod { get; set; }

        /// <summary>
        /// 期初库存
        /// </summary>
        [Precision(20, 8)]
        public decimal? actual_period_start_instock { get; set; }

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

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

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

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

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

        /// <summary>
        /// 实际期末库存
        /// </summary>
        [Precision(20, 8)]
        public decimal? actual_period_end_instock { 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>
        [Precision(20, 8)]
        [Comment("ABC分类")]
        public string? abc { get; set; }

        /// <summary>
        /// FMR分类
        /// </summary>
        [Precision(20, 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; }
    }
}