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(isstandalone), 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? inventoryamount { get; set; }

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

        /// <summary>
        /// 金额占比
        /// </summary>
        [Precision(20, 8)]
        [Comment("金额占比")]
        public decimal? amountpercent { get; set; }


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

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

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

        /// <summary>
        /// 次数占比
        /// </summary>
        [Precision(20, 8)]
        [Comment("次数占比")]
        public decimal? moveperent { 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; }

        /// <summary>
        /// 是否独立计算，成品跟产品计算，原材料跟原材料计算
        /// </summary>
        [Comment("是否独立计算，成品跟产品计算，原材料跟原材料计算")]
        public bool isstandalone { get; set; }
    }
}