using SqlSugar;

namespace MES.Service.Modes;

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

    /// <summary>
    ///     出库单号
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_OUT_NO")]
    public string? ItemOutNo { get; set; }

    /// <summary>
    ///     生产订单
    /// </summary>
    [SugarColumn(ColumnName = "TASK_NO")]
    public string? TaskNo { get; set; }

    /// <summary>
    ///     工序号
    /// </summary>
    [SugarColumn(ColumnName = "PROC_NO")]
    public string? ProcNo { get; set; }

    /// <summary>
    ///     状态|0-未审核1-审核
    /// </summary>
    [SugarColumn(ColumnName = "STATUS")]
    public decimal? Status { 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>
    ///     事务类型
    /// </summary>
    [SugarColumn(ColumnName = "TRANSACTION_NO")]
    public decimal? TransactionNo { get; set; }

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

    /// <summary>
    ///     出库原因
    /// </summary>
    [SugarColumn(ColumnName = "REASON")]
    public string? Reason { get; set; }

    /// <summary>
    ///     生产线编码
    /// </summary>
    [SugarColumn(ColumnName = "PRODUCE_LINE_NO")]
    public string? ProduceLineNo { 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 = "OUT_DATE")]
    public DateTime? OutDate { get; set; }

    /// <summary>
    ///     领料工段
    /// </summary>
    [SugarColumn(ColumnName = "MMLIST")]
    public string? Mmlist { get; set; }

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

    /// <summary>
    ///     SAP返回单据
    /// </summary>
    [SugarColumn(ColumnName = "SAPNO")]
    public string? Sapno { get; set; }

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

    /// <summary>
    ///     SAP返回年份
    /// </summary>
    [SugarColumn(ColumnName = "SAPYEAR")]
    public short? Sapyear { get; set; }

    /// <summary>
    ///     SAP返回信息
    /// </summary>
    [SugarColumn(ColumnName = "SAPTEXT")]
    public string? Saptext { get; set; }

    /// <summary>
    ///     工序线体
    /// </summary>
    [SugarColumn(ColumnName = "PROC_LINE_NO")]
    public string? ProcLineNo { get; set; }

    /// <summary>
    ///     领料部门
    /// </summary>
    [SugarColumn(ColumnName = "OUT_PART")]
    public string? OutPart { get; set; }

    /// <summary>
    ///     0 生产,1 委外
    /// </summary>
    [SugarColumn(ColumnName = "F_TYPE")]
    public long? FType { get; set; }

    /// <summary>
    ///     录入提交
    /// </summary>
    [SugarColumn(ColumnName = "OUT_STATUS")]
    public decimal? OutStatus { get; set; }

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

    /// <summary>
    ///     接收人
    /// </summary>
    [SugarColumn(ColumnName = "RECEIVER")]
    public string? Receiver { 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 = "MTRANSCTION_NO")]
    public decimal? MtransctionNo { 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 = "CMPOCODE")]
    public string? Cmpocode { get; set; }

    /// <summary>
    ///     原物料出货标识
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_FLAG")]
    public decimal? ItemFlag { get; set; }

    /// <summary>
    ///     1=半成品出货
    /// </summary>
    [SugarColumn(ColumnName = "BOARD_FLAG")]
    public decimal? BoardFlag { get; set; }

    /// <summary>
    ///     出库类别
    /// </summary>
    [SugarColumn(ColumnName = "OUT_TYPE")]
    public string? OutType { get; set; }

    /// <summary>
    ///     业务类型
    /// </summary>
    [SugarColumn(ColumnName = "BUSINESS_TYPE")]
    public string? BusinessType { get; set; }

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

    /// <summary>
    ///     产量
    /// </summary>
    [SugarColumn(ColumnName = "PLAN_QTY")]
    public decimal? PlanQty { get; set; }

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

    /// <summary>
    ///     补料申请单号
    /// </summary>
    [SugarColumn(ColumnName = "BBILL_NO")]
    public string? BbillNo { get; set; }

    /// <summary>
    ///     标识 /1已推送
    /// </summary>
    [SugarColumn(ColumnName = "NFLAG")]
    public short? Nflag { get; set; }

    /// <summary>
    ///     退料方式
    /// </summary>
    [SugarColumn(ColumnName = "FMRMODE")]
    public string? Fmrmode { get; set; }

    /// <summary>
    ///     erp返回信息
    /// </summary>
    [SugarColumn(ColumnName = "MSG")]
    public string? Msg { get; set; }

    /// <summary>
    ///     状态
    /// </summary>
    [SugarColumn(ColumnName = "STATES")]
    public string? States { get; set; }

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

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

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

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