DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/Replenishment/ReplenishmentServiceLevel.cs

using Microsoft.EntityFrameworkCore;
using System;
using System.ComponentModel.DataAnnotations;

namespace Business.Domain
{
    /// <summary>
    ///补货模型物料Z服务水平
    /// </summary>
    [Comment("补货模型物料abcfmr")]
    [Index(nameof(number), nameof(tenant_id), nameof(fversion), nameof(factory_id), IsUnique = true)]
    public class ReplenishmentServiceLevel : BaseEntity
    {
        /// <summary>
        /// 物料编码
        /// </summary>
        [StringLength(80)]
        [Comment("物料编码")]
        public string number { get; set; }
        /// <summary>
        /// 物料名称
        /// </summary>
        [StringLength(200)]
        [Comment("物料名称")]
        public string name { get; set; }
        /// <summary>
        /// 规格型号
        /// </summary>
        [StringLength(200)]
        [Comment("规格型号")]
        public string model { get; set; }

        /// <summary>
        /// RS50成品  RS30 组件  RS11 原材料 RS12 零件 RS13 包装材料 RS14 辅料 RS15 低值易耗品 RS99 虚拟物料
        /// </summary>
        [StringLength(50)]
        [Comment("物料类型")]
        public string item_type { get; set; }

        /// <summary>
        /// 版本号
        /// </summary>
        [StringLength(80)]
        [Comment("版本号")]
        public string? fversion { get; set; }


        /// <summary>
        /// 总移库次数
        /// </summary>
        [Precision(20, 8)]
        [Comment("总移库次数")]
        public decimal? totalCount { get; set; }

        /// <summary>
        /// 月均出库次数
        /// </summary>
        [Precision(20, 8)]
        [Comment("月均出库次数")]
        public decimal? avgOutStock { get; set; }

        /// <summary>
        /// 总出货金额
        /// </summary>
        [Precision(20, 8)]
        [Comment("总出货金额")]
        public decimal? totalPrice { get; set; }

        /// <summary>
        /// 物料出货金额
        /// </summary>
        [Precision(20, 8)]
        [Comment("物料出货金额")]
        public decimal? Price { get; set; }


        /// <summary>
        /// ABC分类
        /// </summary>
        [StringLength(8)]
        [Comment("ABC分类")]
        public string? abc { get; set; }

        /// <summary>
        /// FMR分类
        /// </summary>
        [StringLength(8)]
        [Comment("FMR分类")]
        public string? fmr { get; set; }

        /// <summary>
        /// Z服务水平参数
        /// </summary>
        [Precision(20, 8)]
        [Comment("Z服务水平参数")]
        public decimal? service_level_pct { get; set; }
    }
}