using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     出库申请物料表
/// </summary>
[SugarTable("MES_INV_ITEM_OUT_ITEMS")]
public class MesInvItemOutItems
{
    /// <summary>
    ///     SEQ_ITEM_ID
    /// </summary>
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID",
        IsPrimaryKey = true)]
    public decimal Id { get; set; }

    /// <summary>
    ///     出库ID
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_OUT_ID")]
    public decimal? ItemOutId { get; set; }

    /// <summary>
    ///     物料编号
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_NO")]
    public string? ItemNo { get; set; }

    /// <summary>
    ///     申请数量
    /// </summary>
    [SugarColumn(ColumnName = "QUANTITY")]
    public decimal? Quantity { 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 = "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 = "DEPOT_CODE")]
    public string? DepotCode { get; set; }

    /// <summary>
    ///     推介库位
    /// </summary>
    [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")]
    public string? DepotSectionCode { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "TASK_NO")]
    public string? TaskNo { 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>
    ///     ERP 主表ID
    /// </summary>
    [SugarColumn(ColumnName = "ERP_ID")]
    public decimal? ErpId { get; set; }

    /// <summary>
    ///     ERP 从表ID
    /// </summary>
    [SugarColumn(ColumnName = "ERP_AUTOID")]
    public decimal? ErpAutoid { get; set; }

    /// <summary>
    ///     ERP_料号
    /// </summary>
    [SugarColumn(ColumnName = "ERP_ITEM_NO")]
    public string? ErpItemNo { get; set; }

    /// <summary>
    ///     颜色
    /// </summary>
    [SugarColumn(ColumnName = "COLOR_NAME")]
    public string? ColorName { get; set; }

    /// <summary>
    ///     最新下载更新标识
    /// </summary>
    [SugarColumn(ColumnName = "UPDATE_FLG")]
    public decimal? UpdateFlg { get; set; }

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

    /// <summary>
    ///     采购单行ID
    /// </summary>
    [SugarColumn(ColumnName = "LINE_K3ID")]
    public decimal? LineK3id { get; set; }

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

    /// <summary>
    ///     采购订单行号
    /// </summary>
    [SugarColumn(ColumnName = "EBELN_LINE")]
    public decimal? EbelnLine { get; set; }

    /// <summary>
    ///     采购订单数量
    /// </summary>
    [SugarColumn(ColumnName = "EBELN_QTY")]
    public decimal? EbelnQty { get; set; }

    /// <summary>
    ///     产品编号
    /// </summary>
    [SugarColumn(ColumnName = "BOARD_ITEM")]
    public string? BoardItem { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "F_TYPE")]
    public decimal? FType { get; set; }

    /// <summary>
    /// </summary>
    [SugarColumn(ColumnName = "STATUS")]
    public decimal? Status { get; set; }

    /// <summary>
    ///     子子表ID
    /// </summary>
    [SugarColumn(ColumnName = "ALLOCATEID")]
    public decimal? Allocateid { get; set; }

    /// <summary>
    ///     领料编号/生产工单
    /// </summary>
    [SugarColumn(ColumnName = "PBILL_NO")]
    public string? PbillNo { get; set; }

    /// <summary>
    ///     erp接口返回
    /// </summary>
    [SugarColumn(ColumnName = "ERP_MARK")]
    public string? ErpMark { get; set; }

    /// <summary>
    ///     入库单号
    /// </summary>
    [SugarColumn(ColumnName = "RK_NO")]
    public string? RkNo { get; set; }

    /// <summary>
    ///     已入库数
    /// </summary>
    [SugarColumn(ColumnName = "RK_QTY")]
    public decimal? RkQty { get; set; }

    /// <summary>
    ///     已扫数量
    /// </summary>
    [SugarColumn(ColumnName = "TL_QTY")]
    public decimal? TlQty { get; set; }

    /// <summary>
    ///     物料ID
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_ID")]
    public decimal? ItemId { get; set; }

    /// <summary>
    ///     物料投料单ID
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_DABID")]
    public decimal? ItemDabid { 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? QuantityOk { get; set; }
}