using SqlSugar;

namespace NewPdaSqlServer.entity;

/// <summary>
/// </summary>
[SugarTable("MES_INV_ITEM_ARN")]
public class MesInvItemArn
{
    /// <summary>
    ///     主键
    ///     默认值: (newid())
    /// </summary>
    [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
    public Guid Guid { get; set; }

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

    /// <summary>
    ///     状态|0-未审核1-审核入库\结案
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "status")]
    public int? 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 int? BillTypeId { get; set; }

    /// <summary>
    ///     事务类型ID
    /// </summary>
    [SugarColumn(ColumnName = "transaction_id")]
    public int? 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 int? CheckQty { get; set; }

    /// <summary>
    ///     仓库id
    /// </summary>
    [SugarColumn(ColumnName = "depots_id")]
    public string? DepotsId { get; set; }

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

    /// <summary>
    ///     供应商id
    /// </summary>
    [SugarColumn(ColumnName = "supp_id")]
    public string? SuppId { get; set; }

    /// <summary>
    ///     提交状态
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "fstatus")]
    public bool? Fstatus { get; set; }

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

    /// <summary>
    ///     是否已回写SAP
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "sapstatus")]
    public int? Sapstatus { get; set; }

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

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

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

    /// <summary>
    ///     急料标识
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "urgent_flag")]
    public bool? UrgentFlag { get; set; }

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

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

    /// <summary>
    ///     是否显示
    ///     默认值: ((0))
    /// </summary>
    [SugarColumn(ColumnName = "is_visual")]
    public int? IsVisual { get; set; }

    /// <summary>
    ///     0=采购，1=委外
    ///     默认值: ((1))
    /// </summary>
    [SugarColumn(ColumnName = "f_type")]
    public bool? FType { get; set; }

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

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

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

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

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

    /// <summary>
    ///     组织编码
    /// </summary>
    [SugarColumn(ColumnName = "organize_code")]
    public string? OrganizeCode { get; set; }

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

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

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

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

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