using SqlSugar;

namespace NewPdaSqlServer.entity;

/// <summary>
///     物料入库条码明细
/// </summary>
[SugarTable("MES_INV_ITEM_IN_C_DETAILS")]
public class MesInvItemInCDetails
{
    /// <summary>
    ///     默认值: (newid())
    /// </summary>
    [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
    public Guid Guid { get; set; }

    /// <summary>
    ///     入库单id
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_IN_ID")]
    public Guid? ItemInId { get; set; }

    /// <summary>
    ///     物料条码PSN
    /// </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 = "C_ITEM_BARCODE")]
    public string? CItemBarcode { get; set; }

    /// <summary>
    ///     验收数量
    /// </summary>
    [SugarColumn(ColumnName = "QUANTITY")]
    public decimal? Quantity { get; set; }

    /// <summary>
    ///     入库方式(1:有条码,0:无条码)
    ///     默认值: ((1))
    /// </summary>
    [SugarColumn(ColumnName = "BARCODE_FLAG")]
    public bool? BarcodeFlag { get; set; }

    /// <summary>
    ///     环保标志（0-非环保,1-环保.无条码手工录入，有条码为冗余字段）
    ///     默认值: ((1))
    /// </summary>
    [SugarColumn(ColumnName = "EP_FLAG")]
    public bool? EpFlag { 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>
    ///     作业方式0-有线条码枪1-无线条码枪
    /// </summary>
    [SugarColumn(ColumnName = "WORK_TYPE")]
    public long? WorkType { 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:否，1:是)
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "COMANAGEMENT_FLAG")]
    public bool? ComanagementFlag { get; set; }

    /// <summary>
    ///     客户编码
    /// </summary>
    [SugarColumn(ColumnName = "CUST_NO")]
    public string? CustNo { get; set; }

    /// <summary>
    ///     检验结果
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_RES")]
    public string? CheckRes { get; set; }

    /// <summary>
    ///     进货数量
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_QTY")]
    public decimal? CheckQty { get; set; }

    /// <summary>
    ///     检验状态
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_STATES")]
    public string? CheckStates { get; set; }

    /// <summary>
    ///     强制入库标记0无，1-强制入库  退料单使用
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "FORCE_IN_FLAG")]
    public bool? ForceInFlag { get; set; }

    /// <summary>
    ///     仓库编码
    /// </summary>
    [SugarColumn(ColumnName = "DEPOT_CODE")]
    public string? DepotCode { get; set; }

    /// <summary>
    ///     货位编码
    /// </summary>
    [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")]
    public string? DepotSectionCode { get; set; }

    /// <summary>
    ///     特记事项
    /// </summary>
    [SugarColumn(ColumnName = "REMARK")]
    public string? Remark { get; set; }

    /// <summary>
    ///     物料条码
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_BARCODE2")]
    public string? ItemBarcode2 { get; set; }

    /// <summary>
    ///     新条码
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_BARCODE3")]
    public string? ItemBarcode3 { get; set; }

    /// <summary>
    ///     已使用数量
    /// </summary>
    [SugarColumn(ColumnName = "USE_QTY")]
    public decimal? UseQty { get; set; }

    /// <summary>
    ///     出库数量
    /// </summary>
    [SugarColumn(ColumnName = "OUT_QTY")]
    public decimal? OutQty { get; set; }

    /// <summary>
    ///     物料名称
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_SNAME")]
    public string? ItemSname { get; set; }

    /// <summary>
    ///     起始位置
    /// </summary>
    [SugarColumn(ColumnName = "SPOSTION")]
    public int? Spostion { get; set; }

    /// <summary>
    ///     结束位置
    /// </summary>
    [SugarColumn(ColumnName = "EPOSTION")]
    public int? Epostion { get; set; }

    /// <summary>
    ///     检验日期
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_DATE")]
    public DateTime? CheckDate { get; set; }

    /// <summary>
    ///     单位
    /// </summary>
    [SugarColumn(ColumnName = "UNIT")]
    public string? Unit { get; set; }

    /// <summary>
    ///     是否检验
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "ISCHECK")]
    public bool? Ischeck { get; set; }

    /// <summary>
    ///     采购单号
    /// </summary>
    [SugarColumn(ColumnName = "EBELN")]
    public string? Ebeln { get; set; }

    /// <summary>
    ///     批次日期
    /// </summary>
    [SugarColumn(ColumnName = "LOT_DATE")]
    public string? LotDate { get; set; }

    /// <summary>
    ///     发票号
    /// </summary>
    [SugarColumn(ColumnName = "BILL_NO")]
    public string? BillNo { get; set; }

    /// <summary>
    ///     是否入库成功
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "STOCK_OK")]
    public bool? StockOk { get; set; }

    /// <summary>
    ///     工厂
    /// </summary>
    [SugarColumn(ColumnName = "FACTORY")]
    public string? Factory { get; set; }

    /// <summary>
    ///     公司
    /// </summary>
    [SugarColumn(ColumnName = "COMPANY")]
    public string? Company { get; set; }

    /// <summary>
    ///     CB单号
    /// </summary>
    [SugarColumn(ColumnName = "CB_NO")]
    public string? CbNo { get; set; }

    /// <summary>
    ///     箱号
    /// </summary>
    [SugarColumn(ColumnName = "BOX_NO")]
    public string? BoxNo { get; set; }

    /// <summary>
    ///     仓库ID
    /// </summary>
    [SugarColumn(ColumnName = "DEPOT_ID")]
    public long? DepotId { get; set; }

    /// <summary>
    ///     货位ID
    /// </summary>
    [SugarColumn(ColumnName = "DEPOT_SECTION_ID")]
    public long? DepotSectionId { get; set; }

    /// <summary>
    ///     行号
    /// </summary>
    [SugarColumn(ColumnName = "LINE_NUM")]
    public string? LineNum { get; set; }

    /// <summary>
    ///     扫描数量
    /// </summary>
    [SugarColumn(ColumnName = "SM_QTY")]
    public decimal? SmQty { get; set; }

    /// <summary>
    ///     发货单号
    /// </summary>
    [SugarColumn(ColumnName = "VGBEL")]
    public string? Vgbel { get; set; }

    /// <summary>
    ///     行号
    /// </summary>
    [SugarColumn(ColumnName = "KDPOS")]
    public long? Kdpos { get; set; }

    /// <summary>
    ///     作业单号
    /// </summary>
    [SugarColumn(ColumnName = "WORK_NO")]
    public string? WorkNo { get; set; }

    /// <summary>
    ///     行号
    /// </summary>
    [SugarColumn(ColumnName = "EBELN_LINE_NO")]
    public long? EbelnLineNo { get; set; }

    /// <summary>
    ///     CB单号
    /// </summary>
    [SugarColumn(ColumnName = "CBILL_NO")]
    public string? CbillNo { get; set; }

    /// <summary>
    ///     紧急标记
    /// </summary>
    [SugarColumn(ColumnName = "URGENT_FLAG")]
    public bool? UrgentFlag { get; set; }

    /// <summary>
    ///     板型
    /// </summary>
    [SugarColumn(ColumnName = "BOARD_STYLE")]
    public string? BoardStyle { get; set; }

    /// <summary>
    ///     工作行号
    /// </summary>
    [SugarColumn(ColumnName = "WORK_LINE")]
    public int? WorkLine { get; set; }

    /// <summary>
    ///     任务号
    /// </summary>
    [SugarColumn(ColumnName = "TASK_NO")]
    public string? TaskNo { get; set; }

    /// <summary>
    ///     供应商编码
    /// </summary>
    [SugarColumn(ColumnName = "SUPP_NO")]
    public string? SuppNo { get; set; }

    /// <summary>
    ///     收货单号
    /// </summary>
    [SugarColumn(ColumnName = "RBILL_NO")]
    public string? RbillNo { get; set; }

    /// <summary>
    ///     K3 采购单号
    /// </summary>
    [SugarColumn(ColumnName = "EBELN_K3ID")]
    public long? EbelnK3id { get; set; }

    /// <summary>
    ///     K3 行号
    /// </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 = "SUPP_ID")]
    public string? SuppId { get; set; }

    /// <summary>
    ///     收料组织
    /// </summary>
    [SugarColumn(ColumnName = "ReceiveOrgId")]
    public string? ReceiveOrgId { get; set; }


    // 添加的字段，并且它们不属于数据库表
    [SugarColumn(IsIgnore = true)] public string? ItemName { get; set; }

    [SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; }

    [SugarColumn(IsIgnore = true)] public string? ItemUnit { get; set; }

    [SugarColumn(IsIgnore = true)] public decimal? SumQuantity { get; set; }
}