using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     销售发货通知单明细表
/// </summary>
[SugarTable("SALES_DELIVERY_NOTICE_DETAIL")]
public class SalesDeliveryNoticeDetail
{
    /// <summary>
    ///     SEQ_fhtz_mx序列
    /// </summary>
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_FHTZ_MX",
        IsPrimaryKey = true)]
    public decimal Id { get; set; }

    /// <summary>
    ///     销售订单号
    /// </summary>
    [SugarColumn(ColumnName = "SALES_ORDER_ID")]
    public string? SalesOrderId { get; set; }

    /// <summary>
    ///     物料编码
    /// </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 string? IsFree { get; set; }

    /// <summary>
    ///     要货日期
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_DATE")]
    public DateTime? DeliveryDate { 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 = "SRC_BILL_NO")]
    public string? SrcBillNo { get; set; }

    /// <summary>
    ///     计价数量
    /// </summary>
    [SugarColumn(ColumnName = "PRICE_QTY")]
    public decimal? PriceQty { get; set; }

    /// <summary>
    ///     货主
    /// </summary>
    [SugarColumn(ColumnName = "OWNER_ID")]
    public string? OwnerId { 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 = "PLAN_DELIVERY_DATE")]
    public DateTime? PlanDeliveryDate { get; set; }

    /// <summary>
    ///     超发控制单位
    /// </summary>
    [SugarColumn(ColumnName = "OUT_LMT_UNIT")]
    public string? OutLmtUnit { get; set; }

    /// <summary>
    ///     出库上限
    /// </summary>
    [SugarColumn(ColumnName = "OUT_MAX_QTY")]
    public decimal? OutMaxQty { get; set; }

    /// <summary>
    ///     出库下限
    /// </summary>
    [SugarColumn(ColumnName = "OUT_MIN_QTY")]
    public decimal? OutMinQty { get; set; }

    /// <summary>
    ///     交货地点
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERY_LOC")]
    public string? DeliveryLoc { get; set; }

    /// <summary>
    ///     交货地址
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERYL_ADDRESS")]
    public string? DeliveryAddress { 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>
    ///     终止状态
    /// </summary>
    [SugarColumn(ColumnName = "TERMINATION_STATUS")]
    public string? TerminationStatus { get; set; }

    /// <summary>
    ///     终止日期
    /// </summary>
    [SugarColumn(ColumnName = "TERMINATION_DATE")]
    public DateTime? TerminationDate { get; set; }

    /// <summary>
    ///     累计出库数量
    /// </summary>
    [SugarColumn(ColumnName = "SUM_OUT_QTY")]
    public decimal? SumOutQty { get; set; }

    /// <summary>
    ///     未出库数量
    /// </summary>
    [SugarColumn(ColumnName = "REMAIN_OUT_QTY")]
    public decimal? RemainOutQty { get; set; }

    /// <summary>
    ///     ERPID
    /// </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 = "FENTRYNOTE")]
    public string FentryNote { get; set; }

}