using SqlSugar;

namespace NewPdaSqlServer.entity
{
    /// <summary>
    /// 
    ///</summary>
    [SugarTable("MES_ITEMS")]
    public class MesItems
    {
        /// <summary>
        ///  
        /// 默认值: (newid())
        ///</summary>
         [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true   )]
         public Guid Guid { get; set; }
        /// <summary>
        /// 物料ID 
        ///</summary>
         [SugarColumn(ColumnName="id"    )]
         public long Id { get; set; }
        /// <summary>
        /// 工厂 
        ///</summary>
         [SugarColumn(ColumnName="factory"    )]
         public string Factory { get; set; }
        /// <summary>
        /// 公司编号 
        ///</summary>
         [SugarColumn(ColumnName="company"    )]
         public string Company { get; set; }
        /// <summary>
        /// 物料编码 = ERP物料编号||颜色编号 
        ///</summary>
         [SugarColumn(ColumnName="item_no"    )]
         public string ItemNo { get; set; }
        /// <summary>
        /// 物料名称 
        ///</summary>
         [SugarColumn(ColumnName="item_name"    )]
         public string ItemName { get; set; }
        /// <summary>
        /// 物料简称 
        ///</summary>
         [SugarColumn(ColumnName="item_sname"    )]
         public string ItemSname { get; set; }
        /// <summary>
        /// 规格型号 
        ///</summary>
         [SugarColumn(ColumnName="item_model"    )]
         public string ItemModel { get; set; }
        /// <summary>
        /// 物料描述 
        ///</summary>
         [SugarColumn(ColumnName="item_description"    )]
         public string ItemDescription { get; set; }
        /// <summary>
        /// 物料单位 
        ///</summary>
         [SugarColumn(ColumnName="item_unit"    )]
         public string ItemUnit { get; set; }
        /// <summary>
        /// 物料类型 
        ///</summary>
         [SugarColumn(ColumnName="item_type"    )]
         public string ItemType { get; set; }
        /// <summary>
        /// 产品版本 
        ///</summary>
         [SugarColumn(ColumnName="item_version"    )]
         public string ItemVersion { get; set; }
        /// <summary>
        /// 客户编号 
        ///</summary>
         [SugarColumn(ColumnName="cust_no"    )]
         public string CustNo { get; set; }
        /// <summary>
        /// 创建人 
        ///</summary>
         [SugarColumn(ColumnName="create_by"    )]
         public string CreateBy { get; set; }
        /// <summary>
        /// 创建时间 
        ///</summary>
         [SugarColumn(ColumnName="create_date"    )]
         public DateTime? CreateDate { get; set; }
        /// <summary>
        /// 最后更新人 
        ///</summary>
         [SugarColumn(ColumnName="lastupdate_by"    )]
         public string LastupdateBy { get; set; }
        /// <summary>
        /// 最后更新时间 
        ///</summary>
         [SugarColumn(ColumnName="lastupdate_date"    )]
         public DateTime? LastupdateDate { get; set; }
        /// <summary>
        /// 最低库存 
        ///</summary>
         [SugarColumn(ColumnName="lowlimit"    )]
         public decimal? Lowlimit { get; set; }
        /// <summary>
        /// 最大库存 
        ///</summary>
         [SugarColumn(ColumnName="highlimit"    )]
         public decimal? Highlimit { get; set; }
        /// <summary>
        /// 最小包装数 
        ///</summary>
         [SugarColumn(ColumnName="prd_pack"    )]
         public decimal? PrdPack { get; set; }
        /// <summary>
        /// 订单单位 
        ///</summary>
         [SugarColumn(ColumnName="orderunit"    )]
         public string Orderunit { get; set; }
        /// <summary>
        /// 销售单位 
        ///</summary>
         [SugarColumn(ColumnName="saleunit"    )]
         public string Saleunit { get; set; }
        /// <summary>
        /// 库房单位 
        ///</summary>
         [SugarColumn(ColumnName="storeunit"    )]
         public string Storeunit { get; set; }
        /// <summary>
        /// 物料ID 
        ///</summary>
         [SugarColumn(ColumnName="e_item_id"    )]
         public long? EItemId { get; set; }
        /// <summary>
        /// ERP料号 
        ///</summary>
         [SugarColumn(ColumnName="erp_item_no"    )]
         public string ErpItemNo { get; set; }
        /// <summary>
        /// 默认仓库 
        ///</summary>
         [SugarColumn(ColumnName="depot_code"    )]
         public string DepotCode { get; set; }
        /// <summary>
        /// 物料分类编号 
        ///</summary>
         [SugarColumn(ColumnName="ppbom00019124"    )]
         public string Ppbom00019124 { get; set; }
        /// <summary>
        /// 物料分组 
        ///</summary>
         [SugarColumn(ColumnName="remarks"    )]
         public string Remarks { get; set; }
        /// <summary>
        /// 采购员 
        ///</summary>
         [SugarColumn(ColumnName="fpurchaserid"    )]
         public string Fpurchaserid { get; set; }
        /// <summary>
        /// 禁用状态 
        ///</summary>
         [SugarColumn(ColumnName="fforbidstatus"    )]
         public string Fforbidstatus { get; set; }
        /// <summary>
        /// 物料分组 
        ///</summary>
         [SugarColumn(ColumnName="fmaterialgroup"    )]
         public string Fmaterialgroup { get; set; }
        /// <summary>
        /// 完工超收比例 
        ///</summary>
         [SugarColumn(ColumnName="ffinishreceiptoverrate"    )]
         public int? Ffinishreceiptoverrate { get; set; }
        /// <summary>
        /// 发料方式 
        ///</summary>
         [SugarColumn(ColumnName="fissuetype"    )]
         public string Fissuetype { get; set; }
        /// <summary>
        /// 启用批号管理 
        ///</summary>
         [SugarColumn(ColumnName="fisbatchmanage"    )]
         public int? Fisbatchmanage { get; set; }
        /// <summary>
        /// 采购单位 
        ///</summary>
         [SugarColumn(ColumnName="fpurchaseunitid"    )]
         public string Fpurchaseunitid { get; set; }
        /// <summary>
        /// 损耗率 
        ///</summary>
         [SugarColumn(ColumnName="loss_percent"    )]
         public string LossPercent { get; set; }
        /// <summary>
        /// 助记码 
        ///</summary>
         [SugarColumn(ColumnName="mnemonic_code"    )]
         public string MnemonicCode { get; set; }
        /// <summary>
        /// 保质期 
        ///</summary>
         [SugarColumn(ColumnName="exp_period"    )]
         public string ExpPeriod { get; set; }
        /// <summary>
        /// 生产车间 
        ///</summary>
         [SugarColumn(ColumnName="production_workshop"    )]
         public string ProductionWorkshop { get; set; }
        /// <summary>
        /// 物料属性 
        ///</summary>
         [SugarColumn(ColumnName="material_properti"    )]
         public string MaterialProperti { get; set; }
        /// <summary>
        /// 生产单位 
        ///</summary>
         [SugarColumn(ColumnName="produce_unit"    )]
         public string ProduceUnit { get; set; }
        /// <summary>
        /// 委外单位 
        ///</summary>
         [SugarColumn(ColumnName="subcon_unit"    )]
         public string SubconUnit { get; set; }
        /// <summary>
        /// 图片1 
        ///</summary>
         [SugarColumn(ColumnName="bz06"    )]
         public string Bz06 { get; set; }
        /// <summary>
        /// 图片2 
        ///</summary>
         [SugarColumn(ColumnName="bz07"    )]
         public string Bz07 { get; set; }
        /// <summary>
        /// 图片3 
        ///</summary>
         [SugarColumn(ColumnName="bz08"    )]
         public string Bz08 { get; set; }
        /// <summary>
        /// 图片4 
        ///</summary>
         [SugarColumn(ColumnName="bz09"    )]
         public string Bz09 { get; set; }
        /// <summary>
        /// 图片5 
        ///</summary>
         [SugarColumn(ColumnName="bz10"    )]
         public string Bz10 { get; set; }
        /// <summary>
        /// QC分组ID 
        ///</summary>
         [SugarColumn(ColumnName="qc_teamid"    )]
         public string QcTeamid { get; set; }
        /// <summary>
        /// 物料ID 
        ///</summary>
         [SugarColumn(ColumnName="item_id"    )]
         public long? ItemId { get; set; }
        /// <summary>
        /// 颜色 
        ///</summary>
         [SugarColumn(ColumnName="color_name"    )]
         public string ColorName { get; set; }
        /// <summary>
        /// 创建组织 
        ///</summary>
         [SugarColumn(ColumnName="Fumbrella"    )]
         public string Fumbrella { get; set; }
        /// <summary>
        /// 使用组织 
        ///</summary>
         [SugarColumn(ColumnName="FSubsidiary"    )]
         public string FSubsidiary { get; set; }
    }
}