DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/MES/IC/PurOrdDetail.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 PurOrdDetail
    {
        /// <summary>
        /// 主键
        /// </summary>
        [Comment("主键")]
        [Key]
        public int RecID { get; set; }

        public int PurOrdRecID { get; set; }


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

        /// <summary>
        /// 租户ID
        /// </summary>
        [Comment("租户ID")]
        public long? tenant_id { get; set; }

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

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


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


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

        /// <summary>
        /// 订单数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("订单数量")]
        public decimal QtyOrded { get; set; }

        /// <summary>
        /// 已收货数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("已收货数量")]
        public decimal RctQty { get; set; }

        /// <summary>
        /// 含税单价
        /// </summary>
        [Precision(23, 10)]
        [Comment("含税单价")]
        public decimal? PurCost { get; set; }

        /// <summary>
        /// 不含税单价
        /// </summary>
        [Precision(23, 10)]
        [Comment("不含税单价")]
        public decimal? StdCost { get; set; }


        /// <summary>
        /// 税率
        /// </summary>
        [Precision(23, 10)]
        [Comment("税率")]
        public decimal? TaxRate { get; set; }



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


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

        /// <summary>
        /// 是否有效：1-有效；0-无效
        /// </summary>
        [Comment("是否有效")]
        public bool IsActive { 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 Rev { get; set; }

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

        /// <summary>
        /// 状态
        /// </summary>
        [Comment("状态")]
        public string Status { get; set; }

        /// <summary>
        /// 状态
        /// </summary>
        [Comment("状态")]
        public string Req { get; set; }

        /// <summary>
        /// 状态
        /// </summary>
        [Comment("状态")]
        public int ReqLine { get; set; }

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

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

        /// <summary>
        /// 项目
        /// </summary>
        [Comment("项目")]
        public string Project { get; set; }

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

        /// <summary>
        /// 工序号
        /// </summary>
        [Comment("工序号")]
        public int Op { get; set; }

        /// <summary>
        /// BOM版本
        /// </summary>
        [Comment("BOM版本")]
        public string ActiveRlseID1 { get; set; }

        /// <summary>
        /// 委外工序
        /// </summary>
        public string PkgCode { get; set; }

        /// <summary>
        /// erp
        /// </summary>
        public string ERPfld1 { get; set; }

    }
}