using Business.Core.Attributes; using Microsoft.EntityFrameworkCore; using System; using System.ComponentModel.DataAnnotations; using System.ComponentModel.DataAnnotations.Schema; namespace Business.Domain { /// /// 交货计划表 /// [Comment("交货计划表")] public class ic_demandschedule : BaseEntity { /// /// 物料编码 /// [Required] [Comment("物料编码")] [StringLength(80)] public string itemnum { get; set; } /// /// 版本号 /// [Comment("版本号")] [StringLength(80)] public string fversion { get; set; } /// /// 图号 /// [Comment("图号")] [StringLength(24)] public string drawing { get; set; } /// /// 需求日期 /// [Comment("需求日期")] public DateTime requestdate { get; set; } /// /// 建议到货日期 /// [Comment("建议到货日期")] public DateTime arrivaldate { get; set; } /// /// 缺料数量 /// [Precision(23, 10)] [Comment("缺料数量")] public decimal shortqty { get; set; } /// /// 车间需求数量=工单需求+已下达工单领料单待发料 /// [Precision(23, 10)] [Comment("车间需求数量=工单需求+已下达工单领料单待发料")] public decimal mesqty { get; set; } /// /// 起初库存数量=1000库+1001库+5007+5008(实时数量) /// [Precision(23, 10)] [Comment("起初库存数量=1000库+1001库+5007+5008(实时数量)")] public decimal locqty { get; set; } /// /// 在途数量=该物料累计在途(交货单数量-对应此交货单的收货数量1000库) /// [Precision(23, 10)] [Comment("起初库存数量=1000库+1001库+5007+5008(实时数量)")] public decimal sechedqty { get; set; } /// /// 物料净需求数量=H起初库存数量+I在途数量-G车间需求数量 /// [Precision(23, 10)] [Comment("物料净需求数量=H起初库存数量+I在途数量-G车间需求数量")] public decimal tosechedqty { get; set; } /// /// 发布状态(P已发布,其他为未发布) /// [Comment("发布状态(P已发布,其他为未发布)")] [StringLength(2)] public string status { get; set; } /// /// 备注 /// [Comment("备注")] [StringLength(500)] public string remarks { get; set; } /// /// 是否历史版本(Y/N) /// [Comment("是否历史版本(Y/N)")] [StringLength(2)] public string? ishistoryversion { get; set; } /// /// 改为历史版本的时间 /// [Comment("改为历史版本的时间")] public DateTime? historyversionTime { get; set; } /// /// 工单号 /// [Comment("工单号")] public string wolist { get; set; } /// /// 资源检查id /// [Comment("资源检查id")] public string bangid { get; set; } } }