using SqlSugar;

namespace NewPdaSqlServer.entity
{
    /// <summary>
    /// 物料条码表
    ///</summary>
    [SugarTable("MES_INV_ITEM_BARCODES")]
    public class MesInvItemBarcodes
    {
        /// <summary>
        ///  
        /// 默认值: (newid())
        ///</summary>
         [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true   )]
         public Guid Guid { get; set; }
        /// <summary>
        /// 物料条码 
        ///</summary>
         [SugarColumn(ColumnName="ITEM_BARCODE"    )]
         public string ItemBarcode { get; set; }
        /// <summary>
        /// 客户成品编码 
        ///</summary>
         [SugarColumn(ColumnName="C_PRODUCT_CODE"    )]
         public string CProductCode { get; set; }
        /// <summary>
        /// 客户物料条码 
        ///</summary>
         [SugarColumn(ColumnName="C_ITEM_BARCODE"    )]
         public string CItemBarcode { 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>
        /// 厂家批次 
        ///</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 bool? EpFlag { get; set; }
        /// <summary>
        /// 生产工单 
        ///</summary>
         [SugarColumn(ColumnName="TASK_NO"    )]
         public string TaskNo { 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="CUST_NO"    )]
         public string CustNo { get; set; }
        /// <summary>
        /// 物料条码注释行[冗余，条码重打使用] 
        ///</summary>
         [SugarColumn(ColumnName="ITEM_BARCODE_TEXT"    )]
         public string ItemBarcodeText { get; set; }
        /// <summary>
        /// 原PSN物料条码 
        ///</summary>
         [SugarColumn(ColumnName="OLD_ITEM_BARCODE"    )]
         public string OldItemBarcode { get; set; }
        /// <summary>
        /// SAP收货物料凭证号    --采购单号 
        ///</summary>
         [SugarColumn(ColumnName="MBLNR"    )]
         public string Mblnr { get; set; }
        /// <summary>
        /// SAP收货物料凭证行号  --采购单行号 
        ///</summary>
         [SugarColumn(ColumnName="ZEILE"    )]
         public int? Zeile { get; set; }
        /// <summary>
        /// 收料表ID 
        ///</summary>
         [SugarColumn(ColumnName="ROH_IN_ID"    )]
         public long? RohInId { get; set; }
        /// <summary>
        /// 0为有效条码；1为无效条码 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="BARCODESTATUS"    )]
         public bool? Barcodestatus { get; set; }
        /// <summary>
        /// 原始数量 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="OLDQTY"    )]
         public long? Oldqty { get; set; }
        /// <summary>
        /// 使用数量 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="USEQTY"    )]
         public long? Useqty { get; set; }
        /// <summary>
        /// 0在库，1在线，2作废 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="LOCATION"    )]
         public byte? Location { get; set; }
        /// <summary>
        /// 单位 
        ///</summary>
         [SugarColumn(ColumnName="UNIT"    )]
         public string Unit { get; set; }
        /// <summary>
        /// 重量（单位：公斤） 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="WEIGHT_UNIT"    )]
         public decimal? WeightUnit { get; set; }
        /// <summary>
        /// 单价 
        ///</summary>
         [SugarColumn(ColumnName="PRICE"    )]
         public decimal? Price { get; set; }
        /// <summary>
        /// 原条码数量 
        ///</summary>
         [SugarColumn(ColumnName="OLD_BAR_QUANTITY"    )]
         public long? OldBarQuantity { get; set; }
        /// <summary>
        /// 汇总条码 
        ///</summary>
         [SugarColumn(ColumnName="SUM_BARCODE"    )]
         public string SumBarcode { get; set; }
        /// <summary>
        /// 批次日期 
        ///</summary>
         [SugarColumn(ColumnName="LOT_DATE"    )]
         public string LotDate { get; set; }
        /// <summary>
        /// 成品条码 
        ///</summary>
         [SugarColumn(ColumnName="MOCODE"    )]
         public string Mocode { get; set; }
        /// <summary>
        /// 备注 
        ///</summary>
         [SugarColumn(ColumnName="MEMO"    )]
         public string Memo { get; set; }
        /// <summary>
        /// 供应商编号 
        ///</summary>
         [SugarColumn(ColumnName="SUPP_NO"    )]
         public string SuppNo { get; set; }
        /// <summary>
        /// 发货位置 
        ///</summary>
         [SugarColumn(ColumnName="SPOSTION"    )]
         public string Spostion { get; set; }
        /// <summary>
        /// 到货位置 
        ///</summary>
         [SugarColumn(ColumnName="EPOSTION"    )]
         public string Epostion { get; set; }
        /// <summary>
        /// 物料名称 
        ///</summary>
         [SugarColumn(ColumnName="ITEM_SNAME"    )]
         public string ItemSname { get; set; }
        /// <summary>
        /// 是否可见 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="VISABLE"    )]
         public bool? Visable { get; set; }
        /// <summary>
        /// 外发批次号 
        ///</summary>
         [SugarColumn(ColumnName="TR_LOTNO"    )]
         public string TrLotno { get; set; }
        /// <summary>
        /// 发货日期 
        ///</summary>
         [SugarColumn(ColumnName="FLEZZ_DATE"    )]
         public DateTime? FlezzDate { get; set; }
        /// <summary>
        /// 外发原因 
        ///</summary>
         [SugarColumn(ColumnName="FLEZZ_REASON"    )]
         public string FlezzReason { get; set; }
        /// <summary>
        /// 外发人 
        ///</summary>
         [SugarColumn(ColumnName="FLEZZ_BY"    )]
         public string FlezzBy { get; set; }
        /// <summary>
        /// 发货月 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="DELANY_MONTH"    )]
         public int? DelanyMonth { get; set; }
        /// <summary>
        /// 是否最小包装 
        ///</summary>
         [SugarColumn(ColumnName="MINPACK_FLAG"    )]
         public bool? MinpackFlag { get; set; }
        /// <summary>
        /// 打印ID 
        ///</summary>
         [SugarColumn(ColumnName="PRINT_ID"    )]
         public string PrintId { get; set; }
        /// <summary>
        /// 环境物料 
        ///</summary>
         [SugarColumn(ColumnName="EP_ITEM"    )]
         public string EpItem { 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="CB_NO"    )]
         public string CbNo { get; set; }
        /// <summary>
        /// 行号 
        ///</summary>
         [SugarColumn(ColumnName="LINFLINE"    )]
         public string Linfline { get; set; }
        /// <summary>
        /// 有效时间 
        ///</summary>
         [SugarColumn(ColumnName="VALID_TIME"    )]
         public DateTime? ValidTime { get; set; }
        /// <summary>
        /// 质检状态 
        ///</summary>
         [SugarColumn(ColumnName="IQC_STATUS"    )]
         public string IqcStatus { get; set; }
        /// <summary>
        /// 车号 
        ///</summary>
         [SugarColumn(ColumnName="FCAR"    )]
         public string Fcar { get; set; }
        /// <summary>
        /// 毛重 
        ///</summary>
         [SugarColumn(ColumnName="GWEIGHT"    )]
         public string Gweight { get; set; }
        /// <summary>
        /// 净重 
        ///</summary>
         [SugarColumn(ColumnName="NWEIGHT"    )]
         public string Nweight { get; set; }
        /// <summary>
        /// 扩展日期 
        ///</summary>
         [SugarColumn(ColumnName="EXT_DATE"    )]
         public long? ExtDate { get; set; }
        /// <summary>
        /// 条码类型 
        ///</summary>
         [SugarColumn(ColumnName="BARCODETYPE"    )]
         public string Barcodetype { get; set; }
        /// <summary>
        /// 供应商名称 
        ///</summary>
         [SugarColumn(ColumnName="SUPP_NAME"    )]
         public string SuppName { get; set; }
        /// <summary>
        /// 发票编号 
        ///</summary>
         [SugarColumn(ColumnName="BILL_NO"    )]
         public string BillNo { get; set; }
        /// <summary>
        /// 是否紧急 
        ///</summary>
         [SugarColumn(ColumnName="URGENT_FLAG"    )]
         public bool? UrgentFlag { get; set; }
        /// <summary>
        /// 颜色名称 
        ///</summary>
         [SugarColumn(ColumnName="COLOR_NAME"    )]
         public string ColorName { get; set; }
        /// <summary>
        /// 板型 
        ///</summary>
         [SugarColumn(ColumnName="BOARD_STYLE"    )]
         public string BoardStyle { get; set; }
        /// <summary>
        /// 创建日期 
        ///</summary>
         [SugarColumn(ColumnName="INS_DATE"    )]
         public DateTime? InsDate { get; set; }
        /// <summary>
        /// 工序线 
        ///</summary>
         [SugarColumn(ColumnName="WORK_LINE"    )]
         public int? WorkLine { get; set; }
        /// <summary>
        /// 不良备注 
        ///</summary>
         [SugarColumn(ColumnName="MEMO_BAD"    )]
         public string MemoBad { get; set; }
        /// <summary>
        /// 工单 
        ///</summary>
         [SugarColumn(ColumnName="WORK_NO"    )]
         public string WorkNo { get; set; }
        /// <summary>
        /// 到货标记 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="COME_FLG"    )]
         public bool? ComeFlg { get; set; }
        /// <summary>
        /// 行号 
        ///</summary>
         [SugarColumn(ColumnName="LINE_NO"    )]
         public string LineNo { get; set; }
        /// <summary>
        /// 丝印数量 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="SILK_PQTY"    )]
         public long? SilkPqty { get; set; }
        /// <summary>
        /// 丝印规格 
        ///</summary>
         [SugarColumn(ColumnName="SILK"    )]
         public string Silk { get; set; }
        /// <summary>
        /// 丝印ID 
        ///</summary>
         [SugarColumn(ColumnName="SILK_ID"    )]
         public long? SilkId { get; set; }
        /// <summary>
        /// 工单状态 
        /// 默认值: ((0))
        ///</summary>
         [SugarColumn(ColumnName="WORK_FLG"    )]
         public bool? WorkFlg { get; set; }
        /// <summary>
        /// 工单最后行 
        ///</summary>
         [SugarColumn(ColumnName="WORK_LAST"    )]
         public int? WorkLast { get; set; }
        /// <summary>
        /// HBDY 
        ///</summary>
         [SugarColumn(ColumnName="HBDY"    )]
         public int? Hbdy { get; set; }
        /// <summary>
        /// HBDYTM 
        ///</summary>
         [SugarColumn(ColumnName="HBDYTM"    )]
         public int? Hbdytm { get; set; }
        /// <summary>
        /// 工序时间 
        ///</summary>
         [SugarColumn(ColumnName="WORK_FLGTIME"    )]
         public string WorkFlgtime { 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; }
        /// <summary>
        ///  
        ///</summary>
         [SugarColumn(ColumnName="GX_ID"    )]
         public long? GxId { get; set; }
        /// <summary>
        /// 临时批量guid 
        ///</summary>
         [SugarColumn(ColumnName="tmpGuid"    )]
         public Guid? TmpGuid { get; set; }
        /// <summary>
        /// 供应商id 
        ///</summary>
         [SugarColumn(ColumnName="supp_id"    )]
         public string SuppId { get; set; }
    }
}