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 DateTime? 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 int? 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>
    ///     供应商id
    /// </summary>
    [SugarColumn(ColumnName = "supp_id")]
    public string? SuppId { get; set; }

    /// <summary>
    ///     临时批量guid
    /// </summary>
    [SugarColumn(ColumnName = "tmpGuid")]
    public Guid? TmpGuid { get; set; }

    /// <summary>
    ///     关联表的guid
    /// </summary>
    [SugarColumn(ColumnName = "ABOUT_GUID")]
    public Guid? AboutGuid { get; set; }
}