using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 销售发货通知单明细表
|
/// </summary>
|
[SugarTable("SALES_DELIVERY_NOTICE_DETAIL")]
|
public class SalesDeliveryNoticeDetail
|
{
|
/// <summary>
|
/// SEQ_fhtz_mx序列
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_FHTZ_MX",
|
IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 销售订单号
|
/// </summary>
|
[SugarColumn(ColumnName = "SALES_ORDER_ID")]
|
public string? SalesOrderId { get; set; }
|
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "MATERIAL_ID")]
|
public string? MaterialId { get; set; }
|
|
/// <summary>
|
/// 物料名称
|
/// </summary>
|
[SugarColumn(ColumnName = "MATERIAL_NAME")]
|
public string? MaterialName { get; set; }
|
|
/// <summary>
|
/// 物料规格
|
/// </summary>
|
[SugarColumn(ColumnName = "MATERIAL_SPECIFICATION")]
|
public string? MaterialSpecification { get; set; }
|
|
/// <summary>
|
/// 销售单位
|
/// </summary>
|
[SugarColumn(ColumnName = "SALES_UNIT_ID")]
|
public string? SalesUnitId { get; set; }
|
|
/// <summary>
|
/// 销售数量
|
/// </summary>
|
[SugarColumn(ColumnName = "SALES_QUANTITY")]
|
public decimal? SalesQuantity { get; set; }
|
|
/// <summary>
|
/// 是否赠品
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_FREE")]
|
public string? IsFree { get; set; }
|
|
/// <summary>
|
/// 要货日期
|
/// </summary>
|
[SugarColumn(ColumnName = "DELIVERY_DATE")]
|
public DateTime? DeliveryDate { get; set; }
|
|
/// <summary>
|
/// 出货仓库
|
/// </summary>
|
[SugarColumn(ColumnName = "WAREHOUSE")]
|
public string? WareHouse { get; set; }
|
|
/// <summary>
|
/// 计划跟踪号
|
/// </summary>
|
[SugarColumn(ColumnName = "PLAN_TRACKING_NUMBER")]
|
public string? PlanTrackingNumber { get; set; }
|
|
/// <summary>
|
/// 批号
|
/// </summary>
|
[SugarColumn(ColumnName = "LOT_NUMBER")]
|
public string? LotNumber { get; set; }
|
|
/// <summary>
|
/// 源单编号
|
/// </summary>
|
[SugarColumn(ColumnName = "SRC_BILL_NO")]
|
public string? SrcBillNo { get; set; }
|
|
/// <summary>
|
/// 计价数量
|
/// </summary>
|
[SugarColumn(ColumnName = "PRICE_QTY")]
|
public decimal? PriceQty { get; set; }
|
|
/// <summary>
|
/// 货主
|
/// </summary>
|
[SugarColumn(ColumnName = "OWNER_ID")]
|
public string? OwnerId { get; set; }
|
|
/// <summary>
|
/// 库存单位
|
/// </summary>
|
[SugarColumn(ColumnName = "INVENTORY_UNIT")]
|
public string? InventoryUnit { get; set; }
|
|
/// <summary>
|
/// 库存数量
|
/// </summary>
|
[SugarColumn(ColumnName = "INVENTORY_QUANTITY")]
|
public decimal? InventoryQuantity { get; set; }
|
|
/// <summary>
|
/// 物料类别
|
/// </summary>
|
[SugarColumn(ColumnName = "MATERIAL_CATEGORY")]
|
public string? MaterialCategory { get; set; }
|
|
/// <summary>
|
/// 计划发货日期
|
/// </summary>
|
[SugarColumn(ColumnName = "PLAN_DELIVERY_DATE")]
|
public DateTime? PlanDeliveryDate { get; set; }
|
|
/// <summary>
|
/// 超发控制单位
|
/// </summary>
|
[SugarColumn(ColumnName = "OUT_LMT_UNIT")]
|
public string? OutLmtUnit { get; set; }
|
|
/// <summary>
|
/// 出库上限
|
/// </summary>
|
[SugarColumn(ColumnName = "OUT_MAX_QTY")]
|
public decimal? OutMaxQty { get; set; }
|
|
/// <summary>
|
/// 出库下限
|
/// </summary>
|
[SugarColumn(ColumnName = "OUT_MIN_QTY")]
|
public decimal? OutMinQty { get; set; }
|
|
/// <summary>
|
/// 交货地点
|
/// </summary>
|
[SugarColumn(ColumnName = "DELIVERY_LOC")]
|
public string? DeliveryLoc { get; set; }
|
|
/// <summary>
|
/// 交货地址
|
/// </summary>
|
[SugarColumn(ColumnName = "DELIVERYL_ADDRESS")]
|
public string? DeliveryAddress { get; set; }
|
|
/// <summary>
|
/// 源单单号
|
/// </summary>
|
[SugarColumn(ColumnName = "SOURCE_BILL_NO")]
|
public string? SourceBillNo { get; set; }
|
|
/// <summary>
|
/// 订单单号
|
/// </summary>
|
[SugarColumn(ColumnName = "ORDER_BILL_NO")]
|
public string? OrderBillNo { get; set; }
|
|
/// <summary>
|
/// 终止状态
|
/// </summary>
|
[SugarColumn(ColumnName = "TERMINATION_STATUS")]
|
public string? TerminationStatus { get; set; }
|
|
/// <summary>
|
/// 终止日期
|
/// </summary>
|
[SugarColumn(ColumnName = "TERMINATION_DATE")]
|
public DateTime? TerminationDate { get; set; }
|
|
/// <summary>
|
/// 累计出库数量
|
/// </summary>
|
[SugarColumn(ColumnName = "SUM_OUT_QTY")]
|
public decimal? SumOutQty { get; set; }
|
|
/// <summary>
|
/// 未出库数量
|
/// </summary>
|
[SugarColumn(ColumnName = "REMAIN_OUT_QTY")]
|
public decimal? RemainOutQty { get; set; }
|
|
/// <summary>
|
/// ERPID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_LINE_ID")]
|
public string ErpLineId { get; set; }
|
|
/// <summary>
|
/// ERP头ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_HEAD_ID")]
|
public string ErpHeadId { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[SugarColumn(ColumnName = "FENTRYNOTE")]
|
public string FentryNote { get; set; }
|
|
}
|
