DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/SRM/srm_po_list.cs

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

namespace Business.Domain
{
    /// <summary>
    /// 采购订单明细详情
    /// </summary>
    [CollectionName("dopbase", "srm_po_list")]
    [Comment("采购订单明细详情")]
    [Index(nameof(po_billno), nameof(polist_row), nameof(tenant_id), nameof(factory_id), IsUnique = true)]
    public class srm_po_list : BaseEntity
    {
        /// <summary>
        /// po单id
        /// </summary>
        [Required]
        [Comment("po单id")]
        public long? po_id { get; set; }
        /// <summary>
        /// po单号
        /// </summary>
        [StringLength(80)]
        [Comment("po单号")]
        public string po_billno { get; set; }
        /// <summary>
        /// 行号
        /// </summary>
        [Comment("行号")]
        public int? polist_row { get; set; }
        /// <summary>
        /// pr申请单id
        /// </summary>
        [Required]
        [Comment("pr申请单id")]
        public long? pr_id { get; set; }
        /// <summary>
        /// pr申请单号
        /// </summary>
        [StringLength(80)]
        [Comment("pr申请单号")]
        public string pr_billno { get; set; }
        /// <summary>
        /// 关联工单号
        /// </summary>
        [StringLength(80)]
        [Comment("关联工单号")]
        public string po_mono { get; set; }
        /// <summary>
        /// 供应商id
        /// </summary>
        [Required]
        [Comment("供应商id")]
        public long? pr_purchase_id { get; set; }
        /// <summary>
        /// 供应商名称
        /// </summary>
        [StringLength(80)]
        [Comment("供应商名称")]
        public string pr_purchase_name { get; set; }
        /// <summary>
        /// 收货仓库id
        /// </summary>
        [Required]
        [Comment("收货仓库id")]
        public long? stock_id { get; set; }
        /// <summary>
        /// 收货仓库名称
        /// </summary>
        [StringLength(80)]
        [Comment("收货仓库名称")]
        public string stock_name { get; set; }
        /// <summary>
        /// 物料id
        /// </summary>
        [Required]
        [Comment("物料id")]
        public long? icitem_id { get; set; }


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

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


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

        /// <summary>
        /// 规格型号
        /// </summary>
        [StringLength(200)]
        [Comment("规格型号")]
        public string model { get; set; }

        /// <summary>
        /// 交期确认状态
        /// </summary>
        [Comment("交期确认状态")]
        public int? deliveryconfirmstate { get; set; }

        /// <summary>
        /// 物流状态
        /// </summary>
        [Comment("物流状态")]
        public int? logisticsstate { get; set; }

        /// <summary>
        /// 订单数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("订单数量")]
        public decimal? qty { get; set; }
        /// <summary>
        /// 净价
        /// </summary>
        [Precision(23, 10)]
        [Comment("净价")]
        public decimal? netprice { get; set; }
        /// <summary>
        /// 税率
        /// </summary>
        [Precision(23, 10)]
        [Comment("税率")]
        public decimal? rate { get; set; }
        /// <summary>
        /// 含税单价
        /// </summary>
        [Precision(23, 10)]
        [Comment("含税单价")]
        public decimal? price { get; set; }
        /// <summary>
        /// 总价
        /// </summary>
        [Precision(23, 10)]
        [Comment("总价")]
        public decimal? total_price { get; set; }
        /// <summary>
        /// 计划数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("计划数量")]
        public decimal? plan_qty { get; set; }
        /// <summary>
        /// 单位
        /// </summary>
        [Comment("单位")]
        public string unit { get; set; }
        /// <summary>
        /// 数据状态标识 0停用 1启用
        /// </summary>
        [Comment("数据状态标识")]
        public int? state { get; set; }
        /// <summary>
        /// 需求到货日期
        /// </summary>
        [Comment("需求到货日期")]
        public DateTime? rarrdate { get; set; }
        /// <summary>
        /// 评审状态(0-待评审、1-评审通过、2-评审未通过)
        /// </summary>
        [Comment("评审状态")]
        public int? rstate { get; set; }
        /// <summary>
        /// 评审次数
        /// </summary>
        [Comment("评审次数")]
        public int rnumber { get; set; }

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

        /// <summary>
        /// 已收货数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("已收货数量")]
        public decimal? rqty { get; set; }
        /// <summary>
        /// 已入库数量
        /// </summary>
        [Precision(23, 10)]
        [Comment("已入库数量")]
        public decimal? esqty { get; set; }
        /// <summary>
        /// 采购到货日期
        /// </summary>
        [Comment("采购到货日期")]
        public DateTime? procurement_rarr_date { get; set; }
        /// <summary>
        /// 再计划到货日期
        /// </summary>
        [Comment("再计划到货日期")]
        public DateTime? rparrive_date { get; set; }
        /// <summary>
        /// 供应商交期
        /// </summary>
        [Comment("供应商交期")]
        public DateTime? purchase_date { get; set; }
        /// <summary>
        /// 采购确认到货日期
        /// </summary>
        [Comment("采购确认到货日期")]
        public DateTime? pur_affirmdate { get; set; }
        /// <summary>
        /// 币别
        /// </summary>
        [Required]
        [Comment("币别")]
        public long? currencytype { get; set; }

        /// <summary>
        /// 计算ID
        /// </summary>
        [Comment("计算id")]
        [NotMapped]
        public long? bang_id { get; set; }
    }
}