using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 销售订单明细表
|
/// </summary>
|
[SugarTable("SALES_ORDER_DETAIL")]
|
public class SalesOrderDetail
|
{
|
/// <summary>
|
///
|
///</summary>
|
[SugarColumn(ColumnName = "id", IsPrimaryKey = true)]
|
public Guid Id { get; set; }
|
|
/// <summary>
|
///
|
///</summary>
|
[SugarColumn(ColumnName = "pid")]
|
public Guid Pid { get; set; }
|
|
/// <summary>
|
///
|
///</summary>
|
[SugarColumn(ColumnName = "erp_id")]
|
public int? ErpId { get; set; }
|
|
/// <summary>
|
/// 物料编码
|
///</summary>
|
[SugarColumn(ColumnName = "material_id")]
|
public string? MaterialId { 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 = "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>
|
/// 累计退货通知数量（销售基本）
|
///</summary>
|
[SugarColumn(ColumnName = "base_ret_notice_qty")]
|
public decimal? BaseRetNoticeQty { get; set; }
|
|
/// <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; }
|
|
/// <summary>
|
/// 客户物料编码
|
///</summary>
|
[SugarColumn(ColumnName = "cust_ino")]
|
public string? CustIno { get; set; }
|
|
/// <summary>
|
/// 客户物料名称
|
///</summary>
|
[SugarColumn(ColumnName = "cust_inm")]
|
public string? CustInm { get; set; }
|
|
/// <summary>
|
/// 客户物料规格
|
///</summary>
|
[SugarColumn(ColumnName = "cust_imd")]
|
public string? CustImd { 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 = "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>
|
/// ERP单据表头id
|
///</summary>
|
[SugarColumn(ColumnName = "e_hid")]
|
public int? EHid { get; set; }
|
}
|
