using SqlSugar;

namespace MES.Service.Modes;

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

    /// <summary>
    /// 关联主表（MES_CGTH_SQ）的 ID
    /// </summary>
    [SugarColumn(ColumnName = "MID")]
    public Guid? Mid { get; set; }

    /// <summary>
    /// 库存单据编号
    /// </summary>
    [SugarColumn(ColumnName = "INV_BILL_NO")]
    public string? InvBillNo { get; set; }

    /// <summary>
    /// 库存作业行号
    /// </summary>
    [SugarColumn(ColumnName = "INV_WORK_LINE")]
    public int? InvWorkLine { get; set; }

    /// <summary>
    /// 采购订单号（通常来自 ERP 系统）
    /// </summary>
    [SugarColumn(ColumnName = "EBELN")]
    public string? Ebeln { get; set; }

    /// <summary>
    /// 外部系统 ID（关联其他系统记录）
    /// </summary>
    [SugarColumn(ColumnName = "EID")]
    public int? Eid { get; set; }

    /// <summary>
    /// ERP 系统中的明细记录 ID
    /// </summary>
    [SugarColumn(ColumnName = "ERPID")]
    public int? ErpId { get; set; }

    /// <summary>
    /// 物料 ID（关联物料主表）
    /// </summary>
    [SugarColumn(ColumnName = "ITEM_ID")]
    public int? ItemId { get; set; }

    /// <summary>
    /// 申请退货数量
    /// </summary>
    [SugarColumn(ColumnName = "SQ_NUM")]
    public decimal? SqNum { get; set; }

    /// <summary>
    /// 已收退货数量
    /// </summary>
    [SugarColumn(ColumnName = "YS_NUM")]
    public decimal? YsNum { get; set; }

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

    /// <summary>
    /// 明细完成标识（0/1）
    /// </summary>
    [SugarColumn(ColumnName = "IS_FINISH")]
    public bool? IsFinish { get; set; }

    /// <summary>
    /// 明细排序号
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_NO")]
    public int? OrderNo { get; set; }

    /// <summary>
    /// 入库明细 GUID（关联入库单明细）
    /// </summary>
    [SugarColumn(ColumnName = "RKMX_GUID")]
    public Guid? RkmxGuid { get; set; }

    /// <summary>
    /// 仓库 ID（关联仓库表）
    /// </summary>
    [SugarColumn(ColumnName = "depot_id")]
    public long? DepotId { get; set; }

    /// <summary>
    /// 源单单号（关联原始业务单据）
    /// </summary>
    [SugarColumn(ColumnName = "FSRCBillNo")]
    public string? FsrcBillNo { get; set; }

    /// <summary>
    /// 源单类型（标识原始单据类型）
    /// </summary>
    [SugarColumn(ColumnName = "FSRCBillTypeId")]
    public string? FsrcBillTypeId { get; set; }

    /// <summary>
    /// 库存单位（物料的库存计量单位）
    /// </summary>
    [SugarColumn(ColumnName = "FUnitID")]
    public string? FUnitId { get; set; }

    /// <summary>
    /// 仓位（物料在仓库中的具体存储位置）
    /// </summary>
    [SugarColumn(ColumnName = "FSTOCKLOCID")]
    public string? FstockLocId { get; set; }

    /// <summary>
    /// 批号（物料生产批次编号）
    /// </summary>
    [SugarColumn(ColumnName = "FLot")]
    public string? FLot { get; set; }

    /// <summary>
    /// 计划跟踪号（跟踪物料计划）
    /// </summary>
    [SugarColumn(ColumnName = "FMtoNo")]
    public string? FMtoNo { get; set; }
}