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_RETURN_NOTICE_DETAIL", IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "MATERIAL_ID")]
|
public string MaterialId { 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 = "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 = "INVENTORY_UNIT")]
|
public string InventoryUnit { get; set; }
|
|
/// <summary>
|
/// 库存数量
|
/// </summary>
|
[SugarColumn(ColumnName = "INVENTORY_QUANTITY")]
|
public decimal InventoryQuantity { 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>
|
/// 行号 / Line number
|
/// </summary>
|
[SugarColumn(ColumnName = "LINE_NUMBER", SqlParameterDbType = System.Data.DbType.Int32)]
|
public int? FLineNumber { get; set; }
|
|
/// <summary>
|
/// 行状态 / Line status (e.g. 'Active','Cancelled')
|
/// </summary>
|
[SugarColumn(ColumnName = "LINE_STATUS", Length = 50)]
|
public string FLineStatus { get; set; }
|
|
/// <summary>
|
/// 退款客户编号 / Refund customer ID
|
/// </summary>
|
[SugarColumn(ColumnName = "REFUND_CUSTOMER", Length = 100)]
|
public string FRefundCustomer { get; set; }
|
|
/// <summary>
|
/// 供应商编码 / Supplier code
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPPLIER", Length = 100)]
|
public string FSupplier { get; set; }
|
|
/// <summary>
|
/// 免费品类型 / Freebie type (Sample/Gift etc.)
|
/// </summary>
|
[SugarColumn(ColumnName = "FREEBIE_TYPE", Length = 50)]
|
public string FFreebieType { get; set; }
|
|
/// <summary>
|
/// 免费品原因 / Freebie reason description
|
/// </summary>
|
[SugarColumn(ColumnName = "FREEBIE_REASON", Length = 200)]
|
public string FFreebieReason { get; set; }
|
|
/// <summary>
|
/// 源头单据行号 / Source document line number
|
/// </summary>
|
[SugarColumn(ColumnName = "SOURCE_DOC_LINE_NO", SqlParameterDbType = System.Data.DbType.Int32)]
|
public int? FSourceDocLineNo { get; set; }
|
|
/// <summary>
|
/// 源头单据子行号 / Source document sub-line number
|
/// </summary>
|
[SugarColumn(ColumnName = "SOURCE_DOC_SUB_LINE_NO", SqlParameterDbType = System.Data.DbType.Int32)]
|
public int? FSourceDocSubLineNo { get; set; }
|
|
/// <summary>
|
/// 来源单据类型 / Source document type (PO/SO/Invoice etc.)
|
/// </summary>
|
[SugarColumn(ColumnName = "SOURCE_DOC_TYPE", Length = 50)]
|
public string FSourceDocType { get; set; }
|
|
/// <summary>
|
/// 原始单据行号 / Original document line number
|
/// </summary>
|
[SugarColumn(ColumnName = "ORIGINAL_DOC_LINE_NO", SqlParameterDbType = System.Data.DbType.Int32)]
|
public int? FOriginalDocLineNo { get; set; }
|
|
/// <summary>
|
/// 补货组织代码 / Replenishment organization code
|
/// </summary>
|
[SugarColumn(ColumnName = "REPLENISH_ORG", Length = 50)]
|
public string FReplenishOrg { get; set; }
|
|
/// <summary>
|
/// 收货组织代码 / Receiving organization code
|
/// </summary>
|
[SugarColumn(ColumnName = "RECEIVING_ORG", Length = 50)]
|
public string FReceivingOrg { get; set; }
|
|
/// <summary>
|
/// 原业务员ID / Original salesman ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ORIGINAL_SALESMAN", Length = 50)]
|
public string FOriginalSalesman { get; set; }
|
|
/// <summary>
|
/// 原部门代码 / Original department code
|
/// </summary>
|
[SugarColumn(ColumnName = "ORIGINAL_DEPT", Length = 50)]
|
public string FOriginalDept { get; set; }
|
|
/// <summary>
|
/// 项目编号 / Project number
|
/// </summary>
|
[SugarColumn(ColumnName = "PROJECT", Length = 100)]
|
public string FProject { get; set; }
|
|
/// <summary>
|
/// 退货原因分类 / Return reason category
|
/// </summary>
|
[SugarColumn(ColumnName = "RETURN_REASON", Length = 200)]
|
public string FReturnReason { get; set; }
|
|
/// <summary>
|
/// 退货详细说明 / Detailed return description
|
/// <example>货物在运输过程中发生破损</example>
|
/// </summary>
|
[SugarColumn(ColumnName = "RETURN_DESCRIPTION", Length = 4000)]
|
public string FReturnDescription { get; set; }
|
|
|
}
|
