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

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.Domain
{
    /// <summary>
    /// 物料单据明细表
    /// </summary>
    [Comment("物料单据明细表")]
    public class NbrDetail
    {
        /// <summary>
        /// 主键
        /// </summary>
        [Comment("主键")]
        [Key]
        public int RecID { get; set; }

        /// <summary>
        /// 域名
        /// </summary>
        [Comment("域名")]
        public string Domain { get; set; }

        /// <summary>
        /// 类型
        /// </summary>
        [Comment("类型")]
        public string Type { get; set; }

        /// <summary>
        /// 单据编号
        /// </summary>
        [Comment("单据编号")]
        public string Nbr { get; set; }

        /// <summary>
        /// 物料编号
        /// </summary>
        [Comment("物料编号")]
        public string ItemNum { get; set; }

        /// <summary>
        /// 转出数量
        /// </summary>
        [Comment("转出数量")]
        public decimal? QtyFrom { get; set; }

        /// <summary>
        /// 转入数量
        /// </summary>
        [Comment("转入数量")]
        public decimal? QtyTo { get; set; }

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

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

        /// <summary>
        /// erpid
        /// </summary>
        [Comment("erpid")]
        public string OrdNbr { get; set; }

        /// <summary>
        /// ERP行号
        /// </summary>
        [Comment("ERP行号")]
        public short OrdLine { get; set; }

        /// <summary>
        /// ERPid
        /// </summary>
        [Comment("ERPid")]
        public string ERPfld1 { get; set; }

        /// <summary>
        /// ERP行号
        /// </summary>
        [Comment("ERP行号")]
        public string ERPfld2 { get; set; }

        /// <summary>
        /// 原始库位
        /// </summary>
        [Comment("原始库位")]
        public string LocationFrom { get; set; }
        /// <summary>
        /// 目标库位
        /// </summary>
        [Comment("目标库位")]
        public string LocationTo { get; set; }

        /// <summary>
        /// 订单数量
        /// </summary>
        [Comment("订单数量")]
        public decimal QtyOrd { get; set; }

        /// <summary>
        /// 工单需求数量
        /// </summary>
        [Comment("工单需求数量")]
        public decimal? CurrQtyOpened { get; set; }

        /// <summary>
        /// 行号
        /// </summary>
        [Comment("行号")]
        public short Line { get; set; }

        /// <summary>
        /// 主表主键
        /// </summary>
        [Comment("主表主键")]
        public int NbrRecID { get; set; }
        /// <summary>
        /// 是否有效：1-有效；0-无效
        /// </summary>
        [Comment("是否有效")]
        public bool IsActive { get; set; }

        /// <summary>
        /// 单位
        /// </summary>
        [Comment("单位")]
        public string UM { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        [Comment("创建时间")]
        public DateTime? CreateTime { get; set; }

        /// <summary>
        /// 创建人
        /// </summary>
        [Comment("创建人")]
        public string CreateUser { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        [Comment("修改时间")]
        public DateTime? UpdateTime { get; set; }

        /// <summary>
        /// 修改人
        /// </summary>
        [Comment("修改人")]
        public string UpdateUser { get; set; }

        /// <summary>
        /// 批次序列
        /// </summary>
        [Comment("批次序列")]
        public string LotSerial { get; set; }

        /// <summary>
        /// 工单已发料数量
        /// </summary>
        [Comment("工单已发料数量")]
        public decimal QtyRec { get; set; }

        /// <summary>
        /// 物料名称
        /// </summary>
        [Comment("物料名称")]
        public string ItemName { get; set; }

        /// <summary>
        /// 状态：C为已下架、出库
        /// </summary>
        [Comment("状态")]
        public string Status { get; set; }
    }
}