using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     销售退货通知单明细表
/// </summary>
[SugarTable("SALES_RETURN_NOTICE_DETAIL")]
public class SalesReturnNoticeDetail
{
    /// <summary>
    ///     主键
    /// </summary>
    [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
    public Guid? Id { get; set; }

    /// <summary>
    ///     申请单主键
    /// </summary>
    [SugarColumn(ColumnName = "pid")]
    public Guid? Pid { get; set; }

    /// <summary>
    ///     物料ID
    /// </summary>
    [SugarColumn(ColumnName = "MATERIAL_ID")]
    public string? MaterialId { get; set; }

    /// <summary>
    ///     物料名称
    /// </summary>
    [SugarColumn(ColumnName = "MATERIAL_NAME")]
    public string? MaterialName { get; set; }

    /// <summary>
    ///     物料规格
    /// </summary>
    [SugarColumn(ColumnName = "MATERIAL_SPECIFICATION")]
    public string? MaterialSpecification { get; set; }

    /// <summary>
    ///     销售单位
    /// </summary>
    [SugarColumn(ColumnName = "SALES_UNIT_ID")]
    public string? SalesUnitId { get; set; }

    /// <summary>
    ///     销售数量
    /// </summary>
    [SugarColumn(ColumnName = "SALES_QUANTITY")]
    public decimal? SalesQuantity { get; set; }

    /// <summary>
    ///     是否赠品
    /// </summary>
    [SugarColumn(ColumnName = "IS_FREE")]
    public bool? IsFree { get; set; }

    /// <summary>
    ///     退货日期
    /// </summary>
    [SugarColumn(ColumnName = "RETURN_DATE")]
    public DateTime? ReturnDate { get; set; }

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

    /// <summary>
    ///     计划跟踪号
    /// </summary>
    [SugarColumn(ColumnName = "PLAN_TRACKING_NUMBER")]
    public string? PlanTrackingNumber { get; set; }

    /// <summary>
    ///     批号
    /// </summary>
    [SugarColumn(ColumnName = "LOT_NUMBER")]
    public string? LotNumber { get; set; }

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

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

    /// <summary>
    ///     跟单员
    /// </summary>
    [SugarColumn(ColumnName = "SALES_CLERK")]
    public string? SalesClerk { get; set; }

    /// <summary>
    ///     库存单位
    /// </summary>
    [SugarColumn(ColumnName = "INVENTORY_UNIT")]
    public string? InventoryUnit { get; set; }

    /// <summary>
    ///     库存数量
    /// </summary>
    [SugarColumn(ColumnName = "INVENTORY_QUANTITY")]
    public decimal? InventoryQuantity { get; set; }

    /// <summary>
    ///     物料类别
    /// </summary>
    [SugarColumn(ColumnName = "MATERIAL_CATEGORY")]
    public string? MaterialCategory { get; set; }

    /// <summary>
    ///     货主类型
    /// </summary>
    [SugarColumn(ColumnName = "OWNER_TYPE_ID")]
    public string? OwnerTypeId { get; set; }

    /// <summary>
    ///     货主
    /// </summary>
    [SugarColumn(ColumnName = "OWNER_ID")]
    public string? OwnerId { get; set; }

    /// <summary>
    ///     源单类型
    /// </summary>
    [SugarColumn(ColumnName = "SOURCE_BILL_TYPE")]
    public string? SourceBillType { get; set; }

    /// <summary>
    ///     源单单号
    /// </summary>
    [SugarColumn(ColumnName = "SOURCE_BILL_NO")]
    public string? SourceBillNo { get; set; }

    /// <summary>
    ///     订单单号
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_BILL_NO")]
    public string? OrderBillNo { get; set; }

    /// <summary>
    ///     ERP行ID
    /// </summary>
    [SugarColumn(ColumnName = "ERP_LINE_ID")]
    public string? ErpLineId { get; set; }

    /// <summary>
    ///     ERP头ID
    /// </summary>
    [SugarColumn(ColumnName = "ERP_HEAD_ID")]
    public string? ErpHeadId { get; set; }

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

    /// <summary>
    ///     已扫数量
    /// </summary>
    [SugarColumn(ColumnName = "YS_Qty")]
    public decimal? YsQty { get; set; }

    /// <summary>
    ///     送货单明细GUID
    /// </summary>
    [SugarColumn(ColumnName = "DELIVE_DETAIL_GUID")]
    public Guid? DeliverDetailGuid { get; set; }

    /// <summary>
    ///     序号
    /// </summary>
    [SugarColumn(ColumnName = "FSEQ")]
    public int? FSeq { get; set; }
}