DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/Bang/b_bom_child_examine.cs

using Business.Core.Attributes;
using Microsoft.EntityFrameworkCore;
using System;
using System.ComponentModel.DataAnnotations;

namespace Business.Domain
{
    /// <summary>
    /// Bom明细检查结果
    /// </summary>
    [CollectionName("dopbase", "b_bom_child_examine")]
    [Comment("Bom明细检查结果")]
    public class b_bom_child_examine : BaseEntity
    {
        /// <summary>
        /// 资源检查ID
        /// </summary>
        [Comment("资源检查ID")]
        public long? examine_id { get; set; }

        /// <summary>
        /// 本级id
        /// </summary>
        [Comment("本级id")]
        public long fid { get; set; }

        /// <summary>
        /// 父级id
        /// </summary>
        [Comment("父级id")]
        public long? parent_id { get; set; }

        /// <summary>
        /// bom明细主键
        /// </summary>
        [Comment("bom明细主键")]
        public long? bom_child_id { get; set; }

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

        /// <summary>
        /// bom编号
        /// </summary>
        [Comment("bom编号")]
        [StringLength(20)]
        public string bom_number { get; set; }

        /// <summary>
        /// 物料编号
        /// </summary>
        [Comment("物料编号")]
        [StringLength(80)]
        public string item_number { get; set; }

        /// <summary>
        /// level
        /// </summary>
        [Comment("level")]
        public int? level { get; set; }

        /// <summary>
        /// 订单行ID
        /// </summary>
        [Comment("订单行ID")]
        public long? sentry_id { get; set; }

        /// <summary>
        /// BOMid
        /// </summary>
        [Comment("BOMid")]
        public long? bom_id { get; set; }

        /// <summary>
        /// 项次号
        /// </summary>
        [Comment("项次号")]
        [StringLength(100)]
        public string num { get; set; }

        /// <summary>
        /// 排序使用
        /// </summary>
        [Comment("排序使用")]
        public long? num_order { get; set; }

        /// <summary>
        /// 类型 0标准件，1替代件
        /// </summary>
        [Comment("类型")]
        public int? type { get; set; }

        /// <summary>
        /// 物料id
        /// </summary>
        [Comment("物料id")]
        public long? item_id { get; set; }

        /// <summary>
        /// 物料名称
        /// </summary>
        [Comment("物料名称")]
        [StringLength(200)]
        public string item_name { get; set; }

        /// <summary>
        /// 规格型号
        /// </summary>
        [Comment("规格型号")]
        [StringLength(200)]
        public string model { get; set; }

        /// <summary>
        /// 单位
        /// </summary>
        [Comment("单位")]
        [StringLength(80)]
        public string unit { get; set; }

        /// <summary>
        /// 物料属性 0.配置类 1.自制 2.委外加工 3.外购 4.虚拟件
        /// </summary>
        [Comment("物料属性")]
        public int? erp_cls { get; set; }

        /// <summary>
        /// 物料属性名称
        /// </summary>
        [Comment("物料属性名称")]
        [StringLength(80)]
        public string erp_cls_name { get; set; }

        /// <summary>
        /// 是否倒冲
        /// </summary>
        [Comment("是否倒冲")]
        public int? backflush { get; set; }

        /// <summary>
        /// 单位用量
        /// </summary>
        [Comment("单位用量")]
        [Precision(23, 10)]
        public decimal? qty { get; set; }

        /// <summary>
        /// 库存数量
        /// </summary>
        [Comment("库存数量")]
        [Precision(23, 10)]
        public decimal? sqty { get; set; }

        /// <summary>
        /// 库存占用数量
        /// </summary>
        [Comment("库存占用数量")]
        [Precision(23, 10)]
        public decimal? use_qty { get; set; }

        /// <summary>
        /// 本级缺料数量
        /// </summary>
        [Comment("本级缺料数量")]
        [Precision(23, 10)]
        public decimal? self_lack_qty { get; set; }

        /// <summary>
        /// 缺料数量
        /// </summary>
        [Comment("缺料数量")]
        [Precision(23, 10)]
        public decimal? lack_qty { get; set; }

        /// <summary>
        /// 在制占用数量
        /// </summary>
        [Comment("在制占用数量")]
        [Precision(23, 10)]
        public decimal? mo_qty { get; set; }

        /// <summary>
        /// 自制数量
        /// </summary>
        [Comment("自制数量")]
        [Precision(23, 10)]
        public decimal? make_qty { get; set; }

        /// <summary>
        /// 采购数量
        /// </summary>
        [Comment("采购数量")]
        [Precision(23, 10)]
        public decimal? purchase_qty { get; set; }

        /// <summary>
        /// 采购明细占用数量
        /// </summary>
        [Comment("采购明细占用数量")]
        [Precision(23, 10)]
        public decimal? purchase_occupy_qty { get; set; }

        /// <summary>
        /// 在检占用数量
        /// </summary>
        [Comment("在检占用数量")]
        [Precision(23, 10)]
        public decimal fqc_occupy_qty { get; set; }

        /// <summary>
        /// 委外数量
        /// </summary>
        [Comment("委外数量")]
        [Precision(23, 10)]
        public decimal? subcontracting_qty { get; set; }

        /// <summary>
        /// 齐套时间
        /// </summary>
        [Comment("齐套时间")]
        public DateTime? kitting_time { get; set; }

        /// <summary>
        /// 自制时长（天）
        /// </summary>
        [Comment("自制时长（天）")]
        public int? make_time { get; set; }

        /// <summary>
        /// 采购前置（需加上自制）
        /// </summary>
        [Comment("采购前置时间")]
        public int? pre_time { get; set; }

        /// <summary>
        /// 满足时间
        /// </summary>
        [Comment("满足时间")]
        public DateTime? satisfy_time { get; set; }

        /// <summary>
        /// 是否BOM
        /// </summary>
        [Comment("是否BOM")]
        public int? isbom { get; set; }

        /// <summary>
        /// 存在替代关系
        /// </summary>
        [Comment("存在替代关系")]
        public int? haveicsubs { get; set; }

        /// <summary>
        /// 群组代码
        /// </summary>
        [Comment("群组代码")]
        [StringLength(20)]
        public string substitute_code { get; set; }

        /// <summary>
        /// 群组优先级
        /// </summary>
        [Comment("群组优先级")]
        public int? substitute_all_num { get; set; }

        /// <summary>
        /// 替代策略
        /// </summary>
        [Comment("替代策略")]
        public int? substitute_strategy { get; set; }

        /// <summary>
        /// 替代方式
        /// </summary>
        [Comment("替代方式")]
        public int? substitute_mode { get; set; }

        /// <summary>
        /// 物料状态-- -1.无需求 0.缺料 1.充足 2.可制,时间满足 3.可制，时间不满足 4.采购 5.委外
        /// </summary>
        [Comment("物料状态")]
        public int? stock_state { get; set; }

        /// <summary>
        /// 物料齐套状态-- -1.库存可满足 2.在途可满足 3.在制可满足 4.承诺交期可满足 5.不齐套
        /// </summary>
        public int? kitting_state { get; set; }

        /// <summary>
        /// 单个产品总需要用量(含损耗率和固定损耗量)
        /// </summary>
        [Comment("单个产品总需要用量")]
        [Precision(23, 10)]
        public decimal? needCount { get; set; }

        /// <summary>
        /// 单个产品总需要用量（不含损耗率和固定损耗量）
        /// </summary>
        [Comment("总需要用量")]
        [Precision(23, 10)]
        public decimal? needCountNoloss { get; set; }

        /// <summary>
        /// 是否使用此物料
        /// </summary>
        [Comment("是否使用此物料")]
        public bool is_use { get; set; }

        /// <summary>
        /// 工序
        /// </summary>
        [Comment("工序")]
        public int Op { get; set; }

        /// <summary>
        /// 损耗率
        /// </summary>
        [Comment("损耗率")]
        [Precision(23, 10)]
        public decimal? scrap { get; set; }

        /// <summary>
        /// 固定损耗量
        /// </summary>
        [Comment("固定损耗量")]
        [Precision(12, 5)]
        public decimal? wastage { get; set; }
    }
}