using System;
using System.Collections.Generic;
using System.Text;

namespace Bailun.DC.Models
{
    /// <summary>
    /// sku利润分析
    /// </summary>
    public class dc_mid_sku_profit
    {
        /// <summary>
        /// 
        /// </summary>
        public int id { get; set; }

        /// <summary>
        /// 
        /// </summary>
        public string bailun_sku { get; set; }

        /// <summary>
        /// 仓库编码
        /// </summary>
        public string warehouse_code { get; set; }

        /// <summary>
        /// 仓库名称
        /// </summary>
        public string warehouse_name { get; set; }

        /// <summary>
        /// 分类id
        /// </summary>
        public int category_id { get; set; }

        /// <summary>
        /// 分类名称
        /// </summary>
        public string category_name { get; set; }

        /// <summary>
        /// 在库库存
        /// </summary>
        public int usable_stock { get; set; }

        /// <summary>
        /// 在库库存金额
        /// </summary>
        public decimal usable_stock_amount { get; set; }

        /// <summary>
        /// 采购在途数
        /// </summary>
        public int quantity_purchase { get; set; }

        /// <summary>
        /// 采购在途金额
        /// </summary>
        public decimal quantity_purchase_amount { get; set; }

        /// <summary>
        /// 调拨在途数
        /// </summary>
        public int quantity_transfer { get; set; }

        /// <summary>
        /// 调拨在途金额
        /// </summary>
        public decimal quantity_transfer_amount { get; set; }

        /// <summary>
        /// sku名称
        /// </summary>
        public string sku_title_cn { get; set; }

        /// <summary>
        /// 昨日销售额
        /// </summary>
        public decimal yd_sales_amount { get; set; }

        /// <summary>
        /// 昨日销售数量
        /// </summary>
        public int yd_sales_count { get; set; }

        /// <summary>
        /// 昨日销售库存金额
        /// </summary>
        public decimal yd_sales_stockamount { get; set; }

        /// <summary>
        /// 昨日毛利
        /// </summary>
        public decimal yd_grossprofit { get; set; }

        /// <summary>
        /// 昨日成本毛利率
        /// </summary>
        public decimal yd_grossprofit_rate { get; set; }

        /// <summary>
        /// 过去30天销售额
        /// </summary>
        public decimal pre30_sales_amount { get; set; }

        /// <summary>
        /// 过去30天销量
        /// </summary>
        public int pre30_sales_count { get; set; }

        /// <summary>
        /// 过去30天销售库存金额
        /// </summary>
        public decimal pre30_stockamount { get; set; }

        /// <summary>
        /// 过去30天毛利额
        /// </summary>
        public decimal pre30_grossprofit { get; set; }

        /// <summary>
        /// 过去30天成本毛利率
        /// </summary>
        public decimal pre30_grossprofit_rate { get; set; }

        /// <summary>
        /// 过去30天退货率   前一个30天/过去这30天（因为最近的30天的订单可能都还没收到）
        /// </summary>
        public decimal pre30_return_rate { get; set; }

        /// <summary>
        /// 过去30天金额库存周转率（卖出库存金额/除于统计时刻的库存在库总数+采购在途+调拨在途）
        /// </summary>
        public decimal pre30_stockamount_turn_rate { get; set; }

        /// <summary>
        /// 过去统计周期累计采购+调拨+已经入库的新增金额
        /// </summary>
        public decimal pre30_stockamount_add { get; set; }

        /// <summary>
        /// 过去30天 金额销进比 卖出数/采购入库数
        /// </summary>
        public decimal pre30_stockamount__rate { get; set; }

        /// <summary>
        /// 过去30天 件数库存周转率
        /// </summary>
        public decimal pre30_stocknum_turn_rate { get; set; }

        /// <summary>
        /// 过去30天 累积入库件数
        /// </summary>
        public int pre30_stock_add_count { get; set; }

        /// <summary>
        /// 过去30天 件数销进比
        /// </summary>
        public decimal pre30_stocknum_rate { get; set; }

        /// <summary>
        /// 过去30天 金额可售天数  库存总金额/过去30天日均销售成本金额
        /// </summary>
        public decimal pre30_stockamount_vendibility_day { get; set; }

        /// <summary>
        /// 过去30天 件数可售天数
        /// </summary>
        public decimal pre30_stocknum_vendibility_day { get; set; }

        /// <summary>
        /// 统计日期
        /// </summary>
        public DateTime day { get; set; }

        /// <summary>
        /// 创建时间
        /// </summary>
        public DateTime createtime { get; set; }

    }
}
