using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
namespace MES.Service.Modes
{
    /// <summary>
    /// 销售退货通知单子表
    ///</summary>
    [SugarTable("MES_RETURNWARE_DETAILS")]
    public class MesReturnwareDetails
    {
        /// <summary>
        /// 主键ID 
        ///</summary>
         [SugarColumn(ColumnName="ID" , OracleSequenceName = "SEQ_BASEINFO_ID", IsPrimaryKey = true   )]
         public decimal Id { get; set; }
        /// <summary>
        /// 主表ID 
        ///</summary>
         [SugarColumn(ColumnName="PID")]
         public decimal? Pid { get; set; }
        /// <summary>
        /// 物料编码(品号) 
        ///</summary>
         [SugarColumn(ColumnName="ITEM_NO"    )]
         public string ItemNo { get; set; }
        /// <summary>
        /// 物料名称(品名) 
        ///</summary>
         [SugarColumn(ColumnName="ITEM_NAME"    )]
         public string ItemName { get; set; }
        /// <summary>
        /// 规格型号 
        ///</summary>
         [SugarColumn(ColumnName="ITEM_MODEL"    )]
         public string ItemModel { get; set; }
        /// <summary>
        /// 类型 
        ///</summary>
         [SugarColumn(ColumnName="TYPE"    )]
         public string Type { get; set; }
        /// <summary>
        /// 数量 
        ///</summary>
        [SugarColumn(ColumnName = "QUANTITY")]
        public decimal? Quantity { get; set; }
        /// <summary>
        /// 退货仓库 
        ///</summary>
        [SugarColumn(ColumnName="DEPOT_CODE"    )]
         public string DepotCode { get; set; }
        /// <summary>
        /// 销售退货单别 
        ///</summary>
         [SugarColumn(ColumnName="RETURN_TYPE"    )]
         public string? ReturnType { get; set; }
        /// <summary>
        /// 销售退货单号 
        ///</summary>
         [SugarColumn(ColumnName="RETURN_NO"    )]
         public string ReturnNo { get; set; }
        /// <summary>
        /// 销售退货序号 
        ///</summary>
         [SugarColumn(ColumnName="RETURN_ORDER"    )]
         public string ReturnOrder { get; set; }
        /// <summary>
        /// 订单单别 
        ///</summary>
         [SugarColumn(ColumnName="ORDER_TYPE"    )]
         public string? OrderType { get; set; }
        /// <summary>
        /// 订单序号 
        ///</summary>
         [SugarColumn(ColumnName="ORDER_NUMBER"    )]
         public string OrderNumber { get; set; }
        /// <summary>
        /// 订单单号 
        ///</summary>
         [SugarColumn(ColumnName="ORDER_NO"    )]
         public string OrderNo { get; set; }

        /// <summary>
        /// 赠品量
        ///</summary>
        [SugarColumn(ColumnName = "ACTUAL_QUANTITY")]
        public decimal? ActualQuantity { get; set; }

        /// <summary>
        /// 客户品号 
        ///</summary>
        [SugarColumn(ColumnName = "CUST_ITEM_NO")]
        public string? CustItemNo { get; set; }

        /// <summary>
        /// 客户品名
        ///</summary>
        [SugarColumn(ColumnName = "CUST_ITEM_NAME")]
        public string? CustItemName { get; set; }

        /// <summary>
        /// 客户规格 
        ///</summary>
        [SugarColumn(ColumnName = "CUST_ITEM_MODEL")]
        public string? CustItemModel { get; set; }

        /// <summary>
        /// 客户规格 
        ///</summary>
        [SugarColumn(ColumnName = "REMARKS")]
        public string? Remarks { get; set; }
    }
}