using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     物料入库主表
/// </summary>
[SugarTable("MES_INV_ITEM_ARN")]
public class MesInvItemArn
{
   /// <summary>
   ///     ID(SEQ_INV_ID)
   /// </summary>
   [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
    public decimal Id { get; set; }

   /// <summary>
   ///     到货单号
   /// </summary>
   [SugarColumn(ColumnName = "BILL_NO")]
    public string BillNo { get; set; }

   /// <summary>
   ///     状态|0-未审核1-审核入库\结案
   /// </summary>
   [SugarColumn(ColumnName = "STATUS")]
    public short? Status { get; set; }

   /// <summary>
   ///     原因
   /// </summary>
   [SugarColumn(ColumnName = "REASON")]
    public string Reason { 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 = "BILL_TYPE_ID")]
    public decimal? BillTypeId { get; set; }

   /// <summary>
   ///     事务类型ID
   /// </summary>
   [SugarColumn(ColumnName = "TRANSACTION_ID")]
    public decimal? TransactionId { get; set; }

   /// <summary>
   ///     备注
   /// </summary>
   [SugarColumn(ColumnName = "REMARK")]
    public string Remark { get; set; }

   /// <summary>
   ///     送货单号
   /// </summary>
   [SugarColumn(ColumnName = "PAPER_BILL_NO")]
    public string PaperBillNo { get; set; }

   /// <summary>
   ///     退料人工号
   /// </summary>
   [SugarColumn(ColumnName = "USER_NO_BACK")]
    public string UserNoBack { get; set; }

   /// <summary>
   ///     提交人
   /// </summary>
   [SugarColumn(ColumnName = "CHECK_USER")]
    public string CheckUser { get; set; }

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

   /// <summary>
   ///     入库日期
   /// </summary>
   [SugarColumn(ColumnName = "INS_DATE")]
    public DateTime? InsDate { 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 = "DEPOTS_CODE")]
    public string DepotsCode { get; set; }

   /// <summary>
   ///     事务类型编码
   /// </summary>
   [SugarColumn(ColumnName = "TRANSCTION_NO")]
    public string TransctionNo { get; set; }

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

   /// <summary>
   ///     提交状态
   /// </summary>
   [SugarColumn(ColumnName = "FSTATUS")]
    public short? Fstatus { get; set; }

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

   /// <summary>
   ///     是否已回写SAP
   /// </summary>
   [SugarColumn(ColumnName = "SAPSTATUS")]
    public short? Sapstatus { get; set; }

   /// <summary>
   ///     确认入库日期
   /// </summary>
   [SugarColumn(ColumnName = "INS_DATE")]
    public DateTime? Insdate { get; set; }

   /// <summary>
   ///     是否检验
   /// </summary>
   [SugarColumn(ColumnName = "ISCHECK")]
    public decimal? Ischeck { get; set; }

   /// <summary>
   ///     审核入库人
   /// </summary>
   [SugarColumn(ColumnName = "INSBY")]
    public string Insby { get; set; }

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

   /// <summary>
   ///     急料标识
   /// </summary>
   [SugarColumn(ColumnName = "URGENT_FLAG")]
    public short? UrgentFlag { get; set; }

   /// <summary>
   ///     冲销事务类型编码
   /// </summary>
   [SugarColumn(ColumnName = "MTTRANSCTION_NO")]
    public decimal? MttransctionNo { get; set; }

   /// <summary>
   ///     IQC检验单号
   /// </summary>
   [SugarColumn(ColumnName = "IQC_RELEASE_NO")]
    public string IqcReleaseNo { get; set; }

   /// <summary>
   ///     是否显示
   /// </summary>
   [SugarColumn(ColumnName = "IS_VISUAL")]
    public decimal? IsVisual { get; set; }

   /// <summary>
   ///     0=采购，1=委外
   /// </summary>
   [SugarColumn(ColumnName = "F_TYPE")]
    public decimal? FType { get; set; }

   /// <summary>
   ///     ERP到货单ID
   /// </summary>
   [SugarColumn(ColumnName = "EBELN_K3ID")]
    public string EbelnK3id { get; set; }

   /// <summary>
   ///     条码条印进度
   /// </summary>
   [SugarColumn(ColumnName = "BARCODE_RATIO")]
    public decimal? BarcodeRatio { get; set; }

   /// <summary>
   ///     ERP单号
   /// </summary>
   [SugarColumn(ColumnName = "ERPNO")]
    public string Erpno { get; set; }

   /// <summary>
   ///     是否已退货0-未退货，1-退货
   /// </summary>
   [SugarColumn(ColumnName = "THSTATUS")]
    public short? Thstatus { get; set; }

   /// <summary>
   ///     ERP退货单号
   /// </summary>
   [SugarColumn(ColumnName = "ERPTHNO")]
    public string Erpthno { get; set; }


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

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