DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/MES/IC/ic_demandschedule.cs

using Business.Core.Attributes;
using Microsoft.EntityFrameworkCore;
using System;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace Business.Domain
{
    /// <summary>
    /// 交货计划表
    /// </summary>
    [Comment("交货计划表")]
    public class ic_demandschedule : BaseEntity
    {
        /// <summary>
        /// 物料编码
        /// </summary>
        [Required]
        [Comment("物料编码")]
        [StringLength(80)]
        public string itemnum { get; set; }


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


        /// <summary>
        /// 图号
        /// </summary>
        [Comment("图号")]
        [StringLength(24)]
        public string drawing { get; set; }


        /// <summary>
        /// 需求日期
        /// </summary>
        [Comment("需求日期")]
        public DateTime requestdate { get; set; }

        /// <summary>
        /// 建议到货日期
        /// </summary>
        [Comment("建议到货日期")]
        public DateTime arrivaldate { get; set; }


        /// <summary>
        /// 缺料数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("缺料数量")]
        public decimal shortqty { get; set; }

        /// <summary>
        /// 车间需求数量=工单需求+已下达工单领料单待发料
        /// </summary>
        [Precision(23, 10)]
        [Comment("车间需求数量=工单需求+已下达工单领料单待发料")]
        public decimal mesqty { get; set; }

        /// <summary>
        /// 起初库存数量=1000库+1001库+5007+5008(实时数量)
        /// </summary>
        [Precision(23, 10)]
        [Comment("起初库存数量=1000库+1001库+5007+5008(实时数量)")]
        public decimal locqty { get; set; }

        /// <summary>
        /// 在途数量=该物料累计在途（交货单数量-对应此交货单的收货数量1000库)
        /// </summary>
        [Precision(23, 10)]
        [Comment("起初库存数量=1000库+1001库+5007+5008(实时数量)")]
        public decimal sechedqty { get; set; }


        /// <summary>
        /// 物料净需求数量=H起初库存数量+I在途数量-G车间需求数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("物料净需求数量=H起初库存数量+I在途数量-G车间需求数量")]
        public decimal tosechedqty { get; set; }

        /// <summary>
        /// 发布状态(P已发布，其他为未发布)
        /// </summary>
        [Comment("发布状态(P已发布，其他为未发布)")]
        [StringLength(2)]
        public string status { get; set; }

        /// <summary>
        /// 备注
        /// </summary>
        [Comment("备注")]
        [StringLength(500)]
        public string remarks { get; set; }

        /// <summary>
        /// 是否历史版本(Y/N)
        /// </summary>
        [Comment("是否历史版本(Y/N)")]
        [StringLength(2)]
        public string? ishistoryversion { get; set; }
        /// <summary>
        /// 改为历史版本的时间
        /// </summary>
        [Comment("改为历史版本的时间")]

        public DateTime? historyversionTime { get; set; }

        /// <summary>
        /// 工单号
        /// </summary>
        [Comment("工单号")]
        public string wolist { get; set; }

        /// <summary>
        /// 资源检查id
        /// </summary>
        [Comment("资源检查id")]
        public string bangid { get; set; }
    }
}