using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     销售订单明细表
/// </summary>
[SugarTable("MES_SALES_ORDER_DETAIL")]
public class MesSalesOrderDetail
{
    /// <summary>
    ///     SEQ_sales序列
    /// </summary>
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales",
        IsPrimaryKey = true)]
    public decimal Id { get; set; }

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

    /// <summary>
    ///     序号
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_NUMBER")]
    public string OrderNumber { get; set; }

    /// <summary>
    ///     订单单别
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_TYPE")]
    public string? OrderType { get; set; }

    /// <summary>
    ///     产品编码
    /// </summary>
    [SugarColumn(ColumnName = "PRODUCT_CODE")]
    public string ProductCode { get; set; }

    /// <summary>
    ///     产品名称
    /// </summary>
    [SugarColumn(ColumnName = "PRODUCT_NAME")]
    public string ProductName { get; set; }

    /// <summary>
    ///     产品规格
    /// </summary>
    [SugarColumn(ColumnName = "PRODUCT_SPEC")]
    public string ProductSpec { get; set; }

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

    /// <summary>
    ///     预交货日期
    /// </summary>
    [SugarColumn(ColumnName = "SCHEDULED_DELIVERY_DATE")]
    public DateTime? ScheduledDeliveryDate { get; set; }

    /// <summary>
    ///     订单数量
    /// </summary>
    [SugarColumn(ColumnName = "ORDER_QUANTITY")]
    public decimal? OrderQuantity { get; set; }

    /// <summary>
    ///     单位
    /// </summary>
    [SugarColumn(ColumnName = "UNIT")]
    public string Unit { get; set; }

    /// <summary>
    ///     赠品量
    /// </summary>
    [SugarColumn(ColumnName = "GIFT_QUANTITY")]
    public decimal? GiftQuantity { get; set; }

    /// <summary>
    ///     赠品已交量
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERED_GIFT_QUANTITY")]
    public decimal? DeliveredGiftQuantity { get; set; }

    /// <summary>
    ///     借出未销数量
    /// </summary>
    [SugarColumn(ColumnName = "UNSETTLED_BORROWED_QTY")]
    public decimal? UnsettledBorrowedQty { get; set; }

    /// <summary>
    ///     配置方案
    /// </summary>
    [SugarColumn(ColumnName = "CONFIGURATION_PLAN")]
    public string ConfigurationPlan { get; set; }

    /// <summary>
    ///     已交货数
    /// </summary>
    [SugarColumn(ColumnName = "DELIVERED_QUANTITY")]
    public decimal? DeliveredQuantity { get; set; }

    /// <summary>
    ///     结束
    /// </summary>
    [SugarColumn(ColumnName = "IS_CLOSED")]
    public string IsClosed { get; set; }

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

    /// <summary>
    ///     机型
    /// </summary>
    [SugarColumn(ColumnName = "DEVICE_MODEL")]
    public string DeviceModel { get; set; }

    /// <summary>
    ///     客户品号
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_PRODUCT_ID")]
    public string CustomerProductId { get; set; }

    /// <summary>
    ///     客户品名
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_PRODUCT_NAME")]
    public string CustomerProductName { get; set; }

    /// <summary>
    ///     客户规格
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_SPEC")]
    public string CustomerSpec { get; set; }

    /// <summary>
    ///     客户单号
    /// </summary>
    [SugarColumn(ColumnName = "CUSTOMER_ORDER_ID")]
    public string CustomerOrderId { get; set; }
}