using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 销售订单明细表
|
/// </summary>
|
[SugarTable("SALES_ORDER_DETAIL")]
|
public class SalesOrderDetail
|
{
|
/// <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 = "LINE_NUMBER")]
|
public long? LineNumber { 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 = "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 = "UNIT_PRICE")]
|
public decimal? UnitPrice { get; set; }
|
|
/// <summary>
|
/// 金额
|
/// </summary>
|
[SugarColumn(ColumnName = "AMOUNT")]
|
public decimal? Amount { get; set; }
|
|
/// <summary>
|
/// 客户产品编码
|
/// </summary>
|
[SugarColumn(ColumnName = "CUSTOMER_PRODUCT_CODE")]
|
public string CustomerProductCode { 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>
|
/// ERPID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_ID")]
|
public string ErpId { get; set; }
|
|
/// <summary>
|
/// ERP头ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_HEAD_ID")]
|
public string ErpHeadId { get; set; }
|
}
|
