using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 销售退货通知单明细表
|
/// </summary>
|
[SugarTable("SALES_RETURN_NOTICE_DETAIL")]
|
public class SalesReturnNoticeDetail
|
{
|
/// <summary>
|
/// SEQ_sales
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales", 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 decimal IsFree { get; set; }
|
|
/// <summary>
|
/// 退货日期
|
/// </summary>
|
[SugarColumn(ColumnName = "RETURN_DATE")]
|
public DateTime? ReturnDate { 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 = "NOTE")]
|
public string Note { get; set; }
|
|
/// <summary>
|
/// 退货类型
|
/// </summary>
|
[SugarColumn(ColumnName = "RETURN_TYPE")]
|
public string ReturnType { get; set; }
|
|
/// <summary>
|
/// 跟单员
|
/// </summary>
|
[SugarColumn(ColumnName = "SALES_CLERK")]
|
public string SalesClerk { 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 = "OWNER_TYPE_ID")]
|
public string OwnerTypeId { get; set; }
|
|
/// <summary>
|
/// 货主
|
/// </summary>
|
[SugarColumn(ColumnName = "OWNER_ID")]
|
public string OwnerId { get; set; }
|
|
/// <summary>
|
/// 源单类型
|
/// </summary>
|
[SugarColumn(ColumnName = "SOURCE_BILL_TYPE")]
|
public string SourceBillType { 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>
|
/// ERP行ID
|
/// </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 = "SALES_ORDER")]
|
public string? SalesOrder { get; set; }
|
|
/// <summary>
|
/// 客户订单号
|
/// </summary>
|
[SugarColumn(ColumnName = "CUST_ORDER")]
|
public string? CustOrder { get; set; }
|
|
}
|
