using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 销售订单明细表
|
/// </summary>
|
[SugarTable("SALES_ORDER_DETAIL")]
|
public class SalesOrderDetail
|
{
|
/// <summary>
|
/// SEQ_sales序列
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
|
public Guid Id { get; set; }
|
|
/// <summary>
|
/// SEQ_sales序列
|
/// </summary>
|
[SugarColumn(ColumnName = "pid")]
|
public Guid? Pid { get; set; }
|
|
/// <summary>
|
/// ERPID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_ID")]
|
public decimal? ErpID { get; set; }
|
|
/// <summary>
|
/// ERP头ID
|
/// </summary>
|
[SugarColumn(ColumnName = "E_HID")]
|
public decimal? EHID { get; set; }
|
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "MATERIAL_ID")]
|
public string? MaterialId { get; set; }
|
|
/// <summary>
|
/// 客户物料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "MAP_ID")]
|
public string? MapId { get; set; }
|
|
/// <summary>
|
/// 客户物料名称
|
/// </summary>
|
[SugarColumn(ColumnName = "MAP_NAME")]
|
public string? MapName { get; set; }
|
|
/// <summary>
|
/// 客户物料规格
|
/// </summary>
|
[SugarColumn(ColumnName = "MAP_SPEC")]
|
public string? MapSpec { get; set; }
|
|
/// <summary>
|
/// 序号
|
/// </summary>
|
[SugarColumn(ColumnName = "Seq")]
|
public int? Seq { get; set; }
|
|
/// <summary>
|
/// 销售单位
|
/// </summary>
|
[SugarColumn(ColumnName = "UNIT_ID")]
|
public string? UnitId { get; set; }
|
|
/// <summary>
|
/// 销售数量
|
/// </summary>
|
[SugarColumn(ColumnName = "QTY")]
|
public decimal? Qty { get; set; }
|
|
/// <summary>
|
/// 计价单位
|
/// </summary>
|
[SugarColumn(ColumnName = "PRICE_UNIT_ID")]
|
public string? PriceUnitId { get; set; }
|
|
/// <summary>
|
/// 计价数量
|
/// </summary>
|
[SugarColumn(ColumnName = "PRICE_UNIT_QTY")]
|
public decimal? PriceUnitQty { get; set; }
|
|
/// <summary>
|
/// 要货日期
|
/// </summary>
|
[SugarColumn(ColumnName = "DELIVERY_DATE")]
|
public DateTime? DeliveryDate { get; set; }
|
|
/// <summary>
|
/// 是否赠品
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_FREE")]
|
public string? IsFree { get; set; }
|
|
///// <summary>
|
///// 销售订单号
|
///// </summary>
|
//[SugarColumn(ColumnName = "UNW_TEXT_XSDDH")]
|
//public string? SalesOrderNo { get; set; }
|
|
/// <summary>
|
/// 供应组织
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPPLY_ORG_ID")]
|
public string? SupplyOrgId { get; set; }
|
|
/// <summary>
|
/// 库存组织
|
/// </summary>
|
[SugarColumn(ColumnName = "STOCK_ORG_ID")]
|
public string? StockOrgId { get; set; }
|
|
/// <summary>
|
/// 结算组织
|
/// </summary>
|
[SugarColumn(ColumnName = "SETTLE_ORG_IDS")]
|
public string? SettleOrgIds { get; set; }
|
|
|
///// <summary>
|
///// 跟单员
|
///// </summary>
|
//[SugarColumn(ColumnName = "UNW_BASE_GDY")]
|
//public string? SalesFollowUp { get; set; }
|
|
/// <summary>
|
/// 货主类型
|
/// </summary>
|
[SugarColumn(ColumnName = "OWNER_TYPE_ID")]
|
public string? OwnerTypeId { get; set; }
|
|
/// <summary>
|
/// 货主
|
/// </summary>
|
[SugarColumn(ColumnName = "OWNER_ID")]
|
public string? OwnerId { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[SugarColumn(ColumnName = "ENTRY_NOTE")]
|
public string? EntryNote { get; set; }
|
|
/// <summary>
|
/// 计划跟踪号
|
/// </summary>
|
[SugarColumn(ColumnName = "MTO_NO")]
|
public string? MtoNo { get; set; }
|
|
/// <summary>
|
/// 批号
|
/// </summary>
|
[SugarColumn(ColumnName = "LOT")]
|
public string? Lot { get; set; }
|
|
/// <summary>
|
/// 发货上限
|
/// </summary>
|
[SugarColumn(ColumnName = "DELIVERY_MAX_QTY")]
|
public decimal? DeliveryMaxQty { get; set; }
|
|
/// <summary>
|
/// 发货下限
|
/// </summary>
|
[SugarColumn(ColumnName = "DELIVERY_MIN_QTY")]
|
public decimal? DeliveryMinQty { get; set; }
|
|
/// <summary>
|
/// 超发控制单位
|
/// </summary>
|
[SugarColumn(ColumnName = "OUT_LMT_UNIT_ID")]
|
public string? OutLmtUnitId { get; set; }
|
|
/// <summary>
|
/// 业务关闭
|
/// </summary>
|
[SugarColumn(ColumnName = "MRP_CLOSE_STATUS")]
|
public string? MrpCloseStatus { get; set; }
|
|
/// <summary>
|
/// 业务终止
|
/// </summary>
|
[SugarColumn(ColumnName = "MRP_TERMINATE_STATUS")]
|
public string? MrpTerminateStatus { get; set; }
|
|
/// <summary>
|
/// 终止日期
|
/// </summary>
|
[SugarColumn(ColumnName = "TERMINATE_DATE")]
|
public DateTime? TerminateDate { get; set; }
|
|
/// <summary>
|
/// 终止人
|
/// </summary>
|
[SugarColumn(ColumnName = "TERMINATER_ID")]
|
public string? TerminaterId { get; set; }
|
|
/// <summary>
|
/// 源单类型
|
/// </summary>
|
[SugarColumn(ColumnName = "SRC_TYPE")]
|
public string? SrcType { get; set; }
|
|
/// <summary>
|
/// 源单单号
|
/// </summary>
|
[SugarColumn(ColumnName = "SRC_BILL_NO")]
|
public string? SrcBillNo { get; set; }
|
|
/// <summary>
|
/// 累计发货通知数量
|
/// </summary>
|
[SugarColumn(ColumnName = "DELI_QTY")]
|
public decimal? DeliQty { get; set; }
|
|
/// <summary>
|
/// 累计出库数量
|
/// </summary>
|
[SugarColumn(ColumnName = "STOCK_OUT_QTY")]
|
public decimal? StockOutQty { get; set; }
|
|
/// <summary>
|
/// 累计退货通知数量（销售基本）
|
[SugarColumn(ColumnName = "BASE_RET_NOTICE_QTY")]
|
public decimal? BaseRetNoticeQty { get; set; } /// </summary>
|
|
/// <summary>
|
/// 累计退货数量（销售基本）
|
/// </summary>
|
[SugarColumn(ColumnName = "BASE_RETURN_QTY")]
|
public decimal? BaseReturnQty { get; set; }
|
|
/// <summary>
|
/// 剩余未出数量（销售基本）
|
/// </summary>
|
[SugarColumn(ColumnName = "BASE_REMAIN_OUT_QTY")]
|
public decimal? BaseRemainOutQty { get; set; }
|
|
/// <summary>
|
/// 累计应收数量（销售基本）
|
/// </summary>
|
[SugarColumn(ColumnName = "BASEARQTY")]
|
public decimal? BASEARQTY { get; set; }
|
|
}
|
