using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
/// 采购退货申请表
/// </summary>
[SugarTable("MES_CGTH_SQ")]
public class MesCgthSq
{
    /// <summary>
    /// 记录唯一标识（主键）
    /// </summary>
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
    public Guid Id { get; set; }

    /// <summary>
    /// 单据编号
    /// </summary>
    [SugarColumn(ColumnName = "BILL_NO")]
    public string BillNo { 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 = "LAST_UPDATE_USER")]
    public string? LastUpdateUser { get; set; }

    /// <summary>
    /// 最后更新时间
    /// </summary>
    [SugarColumn(ColumnName = "LAST_UPDATE_TIME")]
    public DateTime? LastUpdateTime { 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>
    /// 状态标识（0/1）
    /// 默认值: 0
    /// </summary>
    [SugarColumn(ColumnName = "STATUS")]
    public bool? Status { get; set; }

    /// <summary>
    /// 是否完成标识（0/1）
    /// 默认值: 0
    /// </summary>
    [SugarColumn(ColumnName = "IS_FINISH")]
    public bool? IsFinish { get; set; }

    /// <summary>
    /// 退货方式
    /// </summary>
    [SugarColumn(ColumnName = "RETURN_METHOD")]
    public string? ReturnMethod { get; set; }

    /// <summary>
    /// 退货类型
    /// </summary>
    [SugarColumn(ColumnName = "RETURN_TYPE")]
    public string? ReturnType { get; set; }

    /// <summary>
    /// 仓库 ID
    /// </summary>
    [SugarColumn(ColumnName = "DEPOT_ID")]
    public int? DepotId { get; set; }

    /// <summary>
    /// 供应商 ID
    /// </summary>
    [SugarColumn(ColumnName = "SUPP_ID")]
    public int? SuppId { get; set; }

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

    /// <summary>
    /// 是否出库标识（0/1）
    /// </summary>
    [SugarColumn(ColumnName = "IS_OUT")]
    public bool? IsOut { get; set; }

    /// <summary>
    /// 退货组织 ID
    /// </summary>
    [SugarColumn(ColumnName = "TH_ORG_ID")]
    public string? ThOrgId { get; set; }

    /// <summary>
    /// 操作类型
    /// </summary>
    [SugarColumn(ColumnName = "TYPE")]
    public string? Type { get; set; }

    /// <summary>
    /// ERP 主表 id
    /// </summary>
    [SugarColumn(ColumnName = "ERPID")]
    public string? ErpId { get; set; }

    /// <summary>
    /// 退料日期
    /// </summary>
    [SugarColumn(ColumnName = "FDate")]
    public string? FDate { get; set; }

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

    /// <summary>
    /// 供应商 ID（外部系统）
    /// </summary>
    [SugarColumn(ColumnName = "FSupplierID")]
    public string? FSupplierId { get; set; }

    /// <summary>
    /// 单据类型
    /// </summary>
    [SugarColumn(ColumnName = "FBillTypeID")]
    public string? FBillTypeId { get; set; }

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

    /// <summary>
    /// 采购组织
    /// </summary>
    [SugarColumn(ColumnName = "FPurchaseOrgId")]
    public string? FPurchaseOrgId { get; set; }

    /// <summary>
    /// 需求组织
    /// </summary>
    [SugarColumn(ColumnName = "FRequireOrgId")]
    public string? FRequireOrgId { get; set; }

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

    /// <summary>
    /// 仓管员
    /// </summary>
    [SugarColumn(ColumnName = "FSTOCKERID")]
    public string? FStockerId { get; set; }

    /// <summary>
    /// 采购员
    /// </summary>
    [SugarColumn(ColumnName = "FPURCHASERID")]
    public string? FPurchaserId { get; set; }

    /// <summary>
    /// 退料原因
    /// </summary>
    [SugarColumn(ColumnName = "FMRREASON")]
    public string? FMRReason { get; set; }

    /// <summary>
    /// 采购部门
    /// </summary>
    [SugarColumn(ColumnName = "FPURCHASEDEPTID")]
    public string? FPurchaseDeptId { get; set; }

    /// <summary>
    /// 采购组
    /// </summary>
    [SugarColumn(ColumnName = "FPURCHASERGROUPID")]
    public string? FPurchaserGroupId { get; set; }

    /// <summary>
    /// 验收方式
    /// </summary>
    [SugarColumn(ColumnName = "FACCTYPE")]
    public string? FACCTYPE { get; set; }

    /// <summary>
    /// 创建日期（外部系统）
    /// </summary>
    [SugarColumn(ColumnName = "FCreateDate")]
    public string? FCreateDate { get; set; }

    /// <summary>
    /// 扫码标识
    /// </summary>
    [SugarColumn(ColumnName = "F_WPVT_INTEGER_L6W")]
    public int? FWPVTINTEGERL6W { get; set; }
}