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; }
|
}
|
