using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 销售订单表
|
/// </summary>
|
[SugarTable("SALES_ORDER")]
|
public class SalesOrder
|
{
|
/// <summary>
|
/// SEQ_sales序列
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
|
public Guid? Id { get; set; }
|
|
[SugarColumn(ColumnName = "ERP_ID")]
|
public decimal? ErpID { get; set; } // ERPID
|
|
[SugarColumn(ColumnName = "BILL_NO")]
|
public string? BillNo { get; set; } // 单据编号
|
|
[SugarColumn(ColumnName = "BILL_TYPE_ID")]
|
public string? BillTypeId { get; set; } // 单据类型
|
|
[SugarColumn(ColumnName = "DOCUMENT_STATUS")]
|
public string? DocumentStatus { get; set; } // 单据状态
|
|
[SugarColumn(ColumnName = "F_DATE")]
|
public DateTime? FDate { get; set; } // 日期
|
|
[SugarColumn(ColumnName = "BUSINESS_TYPE")]
|
public string? BusinessType { get; set; } // 业务类型
|
|
[SugarColumn(ColumnName = "HEAD_DELIVERY_WAY")]
|
public string? HeadDeliveryWay { get; set; } // 交货方式
|
|
[SugarColumn(ColumnName = "HEAD_LOC_ID")]
|
public string? HeadLocId { get; set; } // 交货地点
|
|
[SugarColumn(ColumnName = "SALE_ORG_ID")]
|
public string? SaleOrgId { get; set; } // 销售组织
|
|
//[SugarColumn(ColumnName = "UNW_TEXT_KHDD")]
|
//public string? UnWTextKhdd { get; set; } // 客户订单
|
|
//[SugarColumn(ColumnName = "UNW_DATE_KHXQ")]
|
//public DateTime? UnWDateKhxq { get; set; } // 客户需求交期
|
|
//[SugarColumn(ColumnName = "UNW_BASE_PROPERTY_KHDJ")]
|
//public string? UnWBasePropertyKhdj { get; set; } // 客户等级
|
|
[SugarColumn(ColumnName = "CUST_ID")]
|
public string? CustId { get; set; } // 客户
|
|
//[SugarColumn(ColumnName = "UNW_LARGE_TEXT_TBKHBZ")]
|
//public string? UnWLargetextTbkhbz { get; set; } // 淘宝客户备注
|
|
[SugarColumn(ColumnName = "CLOSE_STATUS")]
|
public string? CloseStatus { get; set; } // 关闭状态
|
|
[SugarColumn(ColumnName = "SALE_DEPT_ID")]
|
public string? SaleDeptId { get; set; } // 销售部门
|
|
[SugarColumn(ColumnName = "SALER_ID")]
|
public string? SalerId { get; set; } // 销售员
|
|
[SugarColumn(ColumnName = "NOTE")]
|
public string? Note { get; set; } // 备注
|
|
//[SugarColumn(ColumnName = "UNW_REMARKS_KHJHDD")]
|
//public string? UnWRemarksKhjHdd { get; set; } // 客户交货地点
|
[SugarColumn(ColumnName = "RECEIVE_ID")]
|
public string? ReceiveId { get; set; } // 收货方
|
|
[SugarColumn(ColumnName = "RECEIVE_CONTACT")]
|
public string? ReceiveContact { get; set; } // 收货方联系人
|
|
[SugarColumn(ColumnName = "SETTLE_ID")]
|
public string? SettleId { get; set; } // 结算方
|
|
[SugarColumn(ColumnName = "APPROVER_ID")]
|
public string? ApproverId { get; set; } // 审核人
|
|
[SugarColumn(ColumnName = "LINK_MAN")]
|
public string? LinkMan { get; set; } // 收货人姓名
|
|
[SugarColumn(ColumnName = "CHARGE_ID")]
|
public string? ChargeId { get; set; } // 付款方
|
|
[SugarColumn(ColumnName = "LINK_PHONE")]
|
public string? LinkPhone { get; set; } // 联系电话
|
|
[SugarColumn(ColumnName = "CREATOR_ID")]
|
public string? CreatorId { get; set; } // 创建人
|
|
[SugarColumn(ColumnName = "CREATE_DATE")]
|
public DateTime? CreateDate { get; set; } // 创建日期
|
|
[SugarColumn(ColumnName = "MODIFIER_ID")]
|
public string? ModifierId { get; set; } // 最后修改人
|
|
[SugarColumn(ColumnName = "MODIFY_DATE")]
|
public DateTime? ModifyDate { get; set; } // 最后修改日期
|
|
[SugarColumn(ColumnName = "APPROVE_DATE")]
|
public DateTime? ApproveDate { get; set; } // 审核日期
|
|
[SugarColumn(ColumnName = "CLOSER_ID")]
|
public string? CloserId { get; set; } // 关闭人
|
|
[SugarColumn(ColumnName = "CLOSE_DATE")]
|
public DateTime? CloseDate { get; set; } // 关闭日期
|
|
[SugarColumn(ColumnName = "CHANGE_DATE")]
|
public DateTime? ChangeDate { get; set; } // 变更日期
|
|
[SugarColumn(ColumnName = "CANCEL_STATUS")]
|
public string? CancelStatus { get; set; } // 作废状态
|
|
[SugarColumn(ColumnName = "CANCELLER_ID")]
|
public string? CancellerId { get; set; } // 作废人
|
|
[SugarColumn(ColumnName = "VERSION_NO")]
|
public double? VersionNo { get; set; } // 版本号
|
|
[SugarColumn(ColumnName = "CHANGE_REASON")]
|
public string? ChangeReason { get; set; } // 变更原因
|
|
[SugarColumn(ColumnName = "CHANGER_ID")]
|
public string? ChangerId { get; set; } // 变更人
|
|
[SugarColumn(ColumnName = "ENTRY_NOTE")]
|
public string? EntryNote { get; set; } // 备注
|
|
|
}
|
