using SqlSugar;

namespace NewPdaSqlServer.entity
{
    /// <summary>
    /// 物料库存表
    ///</summary>
    [SugarTable("MES_INV_ITEM_STOCKS")]
    public class MesInvItemStocks
    {
        /// <summary>
        ///  
        /// 默认值: (newid())
        ///</summary>
         [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true   )]
         public Guid Guid { get; set; }
        /// <summary>
        /// 生产订单 
        ///</summary>
         [SugarColumn(ColumnName="TASK_NO"    )]
         public string TaskNo { get; set; }
        /// <summary>
        /// 物料条码 
        ///</summary>
         [SugarColumn(ColumnName="ITEM_BARCODE"    )]
         public string ItemBarcode { get; set; }
        /// <summary>
        /// 客户物料编码（无条码手工录入，有条码为冗余字段） 
        ///</summary>
         [SugarColumn(ColumnName="C_ITEM_CODE"    )]
         public string CItemCode { get; set; }
        /// <summary>
        /// 本司物料编码（无条码手工录入，有条码为冗余字段） 
        ///</summary>
         [SugarColumn(ColumnName="ITEM_NO"    )]
         public string ItemNo { get; set; }
        /// <summary>
        /// 子库id 
        ///</summary>
         [SugarColumn(ColumnName="DEPOTS_ID"    )]
         public long? DepotsId { get; set; }
        /// <summary>
        /// 货位id 
        ///</summary>
         [SugarColumn(ColumnName="DEPOT_SECTIONS_ID"    )]
         public long? DepotSectionsId { get; set; }
        /// <summary>
        /// 厂家批次 
        ///</summary>
         [SugarColumn(ColumnName="LOT_NO"    )]
         public string LotNo { get; set; }
        /// <summary>
        /// 数量 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="QUANTITY"    )]
         public decimal? Quantity { get; set; }
        /// <summary>
        /// 环保标志（无条码手工录入，有条码为冗余字段）(0-否，1-是) 
        ///</summary>
         [SugarColumn(ColumnName="EP_FLAG"    )]
         public byte? EpFlag { get; set; }
        /// <summary>
        /// 客户编码 
        ///</summary>
         [SugarColumn(ColumnName="CUSTOMER_NO"    )]
         public string CustomerNo { get; set; }
        /// <summary>
        /// 重量 
        ///</summary>
         [SugarColumn(ColumnName="ITEM_WT"    )]
         public decimal? ItemWt { get; set; }
        /// <summary>
        /// 子库CODE 
        ///</summary>
         [SugarColumn(ColumnName="DEPOTS_CODE"    )]
         public string DepotsCode { get; set; }
        /// <summary>
        /// 货位CODE 
        ///</summary>
         [SugarColumn(ColumnName="DEPOT_SECTIONS_CODE"    )]
         public string DepotSectionsCode { get; set; }
        /// <summary>
        /// 检验日期 
        ///</summary>
         [SugarColumn(ColumnName="CHECK_DATE"    )]
         public DateTime? CheckDate { get; set; }
        /// <summary>
        /// 0 物料 1 半成品 2 成品 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="ITEM_TYPE"    )]
         public byte? ItemType { get; set; }
        /// <summary>
        /// 入库日期 
        /// 默认值: (getdate())
        ///</summary>
         [SugarColumn(ColumnName="INDEP_DATE"    )]
         public DateTime? IndepDate { get; set; }
        /// <summary>
        /// 工厂编号 
        ///</summary>
         [SugarColumn(ColumnName="FACTORY"    )]
         public string Factory { get; set; }
        /// <summary>
        /// 公司编号 
        ///</summary>
         [SugarColumn(ColumnName="COMPANY"    )]
         public string Company { get; set; }
        /// <summary>
        /// 质量状态 
        ///</summary>
         [SugarColumn(ColumnName="IQC_STATUS"    )]
         public string IqcStatus { get; set; }
        /// <summary>
        /// F卡 
        ///</summary>
         [SugarColumn(ColumnName="FCAR"    )]
         public string Fcar { get; set; }
        /// <summary>
        /// 可见提交标志（0-否，1-是） 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="VISABLE_SUBMIT"    )]
         public byte? VisableSubmit { get; set; }
        /// <summary>
        /// 可见提交人 
        ///</summary>
         [SugarColumn(ColumnName="VISABLE_SUBMIT_BY"    )]
         public string VisableSubmitBy { get; set; }
        /// <summary>
        /// 可见提交时间 
        ///</summary>
         [SugarColumn(ColumnName="VISABLE_SUBMIT_DATE"    )]
         public DateTime? VisableSubmitDate { get; set; }
        /// <summary>
        /// 板型 
        ///</summary>
         [SugarColumn(ColumnName="BOARD_STYLE"    )]
         public string BoardStyle { get; set; }
        /// <summary>
        /// 工单号 
        ///</summary>
         [SugarColumn(ColumnName="WORK_NO"    )]
         public string WorkNo { get; set; }
        /// <summary>
        /// 工单行号 
        ///</summary>
         [SugarColumn(ColumnName="WORK_LINE"    )]
         public int? WorkLine { get; set; }
        /// <summary>
        /// 供应商编码 
        ///</summary>
         [SugarColumn(ColumnName="SUPP_NO"    )]
         public string SuppNo { get; set; }
        /// <summary>
        /// 行号 
        ///</summary>
         [SugarColumn(ColumnName="LINE_NO"    )]
         public string LineNo { get; set; }
        /// <summary>
        /// 单据编号 
        ///</summary>
         [SugarColumn(ColumnName="BILL_NO"    )]
         public string BillNo { get; set; }
        /// <summary>
        /// K3ID 
        ///</summary>
         [SugarColumn(ColumnName="EBELN_K3ID"    )]
         public long? EbelnK3id { get; set; }
        /// <summary>
        /// 行K3ID 
        ///</summary>
         [SugarColumn(ColumnName="LINE_K3ID"    )]
         public long? LineK3id { get; set; }
        /// <summary>
        /// 物料ID 
        ///</summary>
         [SugarColumn(ColumnName="ITEM_ID"    )]
         public long? ItemId { get; set; }
    }
}