using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     物料移库条码明细从表
/// </summary>
[SugarTable("MES_INV_ITEM_MOVES_C_DETAILS")]
public class MesInvItemMovesCDetails
{
    /// <summary>
    ///     seq_inv_id
    /// </summary>
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID",
        IsPrimaryKey = true)]
    public decimal Id { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_MOVE_ID")]
    public decimal? ItemMoveId { 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>
    ///     厂家批次
    /// </summary>
    [SugarColumn(ColumnName = "LOT_NO")]
    public string? LotNo { get; set; }

    /// <summary>
    ///     数量（无条码手工录入，有条码为冗余字段）
    /// </summary>
    [SugarColumn(ColumnName = "QUANTITY")]
    public decimal? Quantity { get; set; }

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

    /// <summary>
    ///     环保标志（无条码手工录入，有条码为冗余字段）
    /// </summary>
    [SugarColumn(ColumnName = "EP_FLAG")]
    public short? 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>
    ///     子库id
    /// </summary>
    [SugarColumn(ColumnName = "INV_DEPOTS_ID")]
    public decimal? InvDepotsId { get; set; }

    /// <summary>
    ///     货位id
    /// </summary>
    [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")]
    public decimal? InvDepotSectionsId { get; set; }

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

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

    /// <summary>
    ///     移出仓库编号
    /// </summary>
    [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")]
    public string? FromDepotsCode { get; set; }

    /// <summary>
    ///     移出库位编号
    /// </summary>
    [SugarColumn(ColumnName = "FROM_DEPOT_SECTIONS_CODE")]
    public string? FromDepotSectionsCode { get; set; }

    /// <summary>
    ///     条码备注
    /// </summary>
    [SugarColumn(ColumnName = "REMARK")]
    public string? Remark { 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 = "BOX_NO")]
    public string? BoxNo { get; set; }

    /// <summary>
    ///     卡板号
    /// </summary>
    [SugarColumn(ColumnName = "KO_NO")]
    public string? KoNo { get; set; }

    /// <summary>
    ///     移入仓库编号
    /// </summary>
    [SugarColumn(ColumnName = "INV_DEPOTS_CODE")]
    public string? InvDepotsCode { get; set; }

    /// <summary>
    ///     移入库位编号
    /// </summary>
    [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")]
    public string? InvDepotSectionsCode { 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 = "INDEP_DATE")]
    public DateTime? IndepDate { get; set; }

    /// <summary>
    ///     冻结提交重检，0：冻结未提交重检，1：冻结并提交重检
    /// </summary>
    [SugarColumn(ColumnName = "VISABLE_SUBMIT")]
    public short? 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 decimal? WorkLine { get; set; }

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

    /// <summary>
    ///     调入
    /// </summary>
    [SugarColumn(ColumnName = "MOVE_OK")]
    public decimal? MoveOk { 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 string? SuppName { get; set; }
}