using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 销售订单表
|
/// </summary>
|
[SugarTable("SALES_ORDER")]
|
public class SalesOrder
|
{
|
/// <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_TYPE")]
|
public string OrderType { get; set; }
|
|
/// <summary>
|
/// 受订日期
|
/// </summary>
|
[SugarColumn(ColumnName = "ORDER_DATE")]
|
public DateTime? OrderDate { get; set; }
|
|
/// <summary>
|
/// 单据版本
|
/// </summary>
|
[SugarColumn(ColumnName = "DOCUMENT_VERSION")]
|
public long? DocumentVersion { get; set; }
|
|
/// <summary>
|
/// 单据日期
|
/// </summary>
|
[SugarColumn(ColumnName = "DOCUMENT_DATE")]
|
public DateTime? DocumentDate { get; set; }
|
|
/// <summary>
|
/// 工厂编号
|
/// </summary>
|
[SugarColumn(ColumnName = "FACTORY_ID")]
|
public string FactoryId { get; set; }
|
|
/// <summary>
|
/// 工厂简称
|
/// </summary>
|
[SugarColumn(ColumnName = "FACTORY_NAME")]
|
public string FactoryName { get; set; }
|
|
/// <summary>
|
/// 客户编号
|
/// </summary>
|
[SugarColumn(ColumnName = "CUSTOMER_ID")]
|
public string CustomerId { get; set; }
|
|
/// <summary>
|
/// 客户简称
|
/// </summary>
|
[SugarColumn(ColumnName = "CUSTOMER_NAME")]
|
public string CustomerName { get; set; }
|
|
/// <summary>
|
/// 客户单号
|
/// </summary>
|
[SugarColumn(ColumnName = "CUSTOMER_ORDER_ID")]
|
public string CustomerOrderId { get; set; }
|
|
/// <summary>
|
/// 部门编号
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPARTMENT_ID")]
|
public string DepartmentId { get; set; }
|
|
/// <summary>
|
/// 总数量
|
/// </summary>
|
[SugarColumn(ColumnName = "TOTAL_QUANTITY")]
|
public decimal? TotalQuantity { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARKS")]
|
public string Remarks { get; set; }
|
|
/// <summary>
|
/// erp审核日期
|
/// </summary>
|
[SugarColumn(ColumnName = "APPROVAL_DATE")]
|
public DateTime? ApprovalDate { get; set; }
|
|
/// <summary>
|
/// erp审核者
|
/// </summary>
|
[SugarColumn(ColumnName = "APPROVER")]
|
public string Approver { get; set; }
|
|
/// <summary>
|
/// ERPID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_ID")]
|
public string ErpId { get; set; }
|
}
|