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

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

        /// <summary>
        /// 安全库存
        /// </summary>
        [Comment("安全库存")]
        public decimal SafetyStk { get; set; }

        /// <summary>
        /// 状态：C为不可用状态
        /// </summary>
        [Comment("状态")]
        public string Status { get; set; }

        /// <summary>
        /// 状态：C为不可用状态
        /// </summary>
        [Comment("状态")]
        public string Location { get; set; }

        public string Descr { get; set; }
        public string Descr1 { get; set; }
        public string PurMfg { get; set; }
        public bool IsMainMas { get; set; }

        public decimal? NetWeight { get; set; }
        public string NetWeightUM { get; set; }
        public decimal? Length { get; set; }
        public decimal? Width { get; set; }
        public decimal? Height { get; set; }
        public bool LotSerialControl { get; set; }
        public string DefaultShelf { get; set; }
        public decimal MaxOrd { get; set; }
        public decimal MinOrd { get; set; }
        /// <summary>
        /// 前处理天数
        /// </summary>
        public int? MFGMTTR { get; set; }
        /// <summary>
        /// 是否前处理
        /// </summary>
        [Comment("是否前处理")]
        public bool IssuePolicy { get; set; }

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

        /// <summary>
        /// 是否打标：1-打标；0-不达标
        /// </summary>
        [Comment("是否打标")]
        public bool Install { get; set; }

        /// <summary>
        /// 是否有效：1-有效；0-无效
        /// </summary>
        [Comment("是否整包发料")]
        public bool TraceDetail { get; set; }

        /// <summary>
        /// 供应提前期
        /// </summary>
        [Comment("供应提前期")]
        public int PurLT { get; set; }

        /// <summary>
        /// bom设计时间
        /// </summary>
        public decimal? BOMDesignTime { get; set; }

        /// <summary>
        /// 工艺设计时间
        /// </summary>
        public decimal? RoutingDesignTime { get; set; }

        /// <summary>
        /// 存货周转率
        /// </summary>
        [Comment("存货周转率")]
        public decimal StockTurnOver { get; set; }

        /// <summary>
        /// 物料类型
        /// </summary>
        public string ItemType { get; set; }

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

        /// <summary>
        /// BOM
        /// </summary>
        public string PMBOM { get; set; }

        /// <summary>
        /// 检验天数
        /// </summary>
        [Comment("检验天数")]
        public int InsLT { get; set; }

        /// <summary>
        /// 特殊采购类型
        /// </summary>
        public string EMTType { get; set; }

        /// <summary>
        /// 起订量
        /// </summary>
        [Comment("起订量")]
        public decimal MinOrdSales { get; set; }

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

        /// <summary>
        /// 是否需要走MRP
        /// </summary>
        [Comment("是否需要走MRP")]
        public short MRPRequired { get; set; }

        /// <summary>
        /// 物料类型
        /// </summary>
        public string Drawing { get; set; }

        /// <summary>
        /// 物料状态
        /// </summary>
        public string PORcptStatus { get; set; }

        public string Series { get; set; }
    }
}