DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/SaleFcst/ProductionMasterPlan.cs

using Business.Domain;
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Business.StructuredDB.SaleFcst
{

    /// <summary>
    ///  主生产计划    
    /// </summary>
    public class ProductionMasterPlan :BaseEntity
    {

        /// <summary>
        /// 地区    
        /// </summary>
        [StringLength(50)]
        public string Area { get; set; }

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

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

        /// <summary>
        /// 车间线体    
        /// </summary>
        [StringLength(128)]
        public string WorkshopLine { get; set; }

        /// <summary>
        /// 物料编码    
        /// </summary>
        [StringLength(128)]
        public string ItemNumber { get; set; }

        /// <summary>
        /// 规格型号    
        /// </summary>
        [StringLength(128)]
        public string Model { get; set; }

        /// <summary>
        /// 语种    
        /// </summary>
        [StringLength(50)]
        public string Languages { get; set; }
        /// <summary>
        /// 计划年月    
        /// </summary>
        [StringLength(128)]
        public string PlanMonth { get; set; }

        /// <summary>
        /// 计划发货数量    
        /// </summary>
        [Precision(18, 5)]
        public decimal PlanShipQty { get; set; }

        /// <summary>
        /// 计划生产数量    
        /// </summary>
        [Precision(18, 5)]
        public decimal PlanProductQty { get; set; }

        /// <summary>
        /// 期末库存    
        /// </summary>
        [Precision(18, 5)]
        public decimal PlanStockQty { get; set; }

        /// <summary>
        /// 8001库存    
        /// </summary>
        [Precision(18, 5)]
        public decimal Inventory { get; set; }

        /// <summary>
        /// 8000库存    
        /// </summary>
        [Precision(18,5)]
        public decimal Inventory1 { get; set; }

        /// <summary>
        /// 5008库存    
        /// </summary>
        public decimal Inventory2 { get; set; }

        /// <summary>
        /// 灭菌中    
        /// </summary>
        [Precision(18, 5)]
        public decimal DuringSterilization { get; set; }

        /// <summary>
        /// 在制    
        /// </summary>
        [Precision(18, 5)]
        public decimal InProduction { get; set; }

        /// <summary>
        /// 经济批量    
        /// </summary>
        public decimal EconomicLotSize { get; set; }

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

    }

}