DEMOMySql/MicroServices/Business/Business.Domain/StructuredDB/Production/DMS_IN_LOCDETAIL.cs

using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Business.Domain
{
    /// <summary>
    /// DMS库存明细
    /// </summary>
    [Comment("DMS库存明细")]
    public class DMS_IN_LOCDETAIL
    {
        /// <summary>
        /// 产品线编码
        /// </summary>
        [Comment("产品线编码")]
        public string? DivisionCode { get; set; }

        /// <summary>
        /// 产品线名称
        /// </summary>
        [Comment("产品线名称")]
        public string? DivisionName { get; set; }

        /// <summary>
        /// 合同产品分类编码
        /// </summary>
        [Comment("合同产品分类编码")]
        public string? SubBUCode { get; set; }

        /// <summary>
        /// 合同产品分类名称
        /// </summary>
        [Comment("合同产品分类名称")]
        public string? SubBUName { get; set; }

        /// <summary>
        /// 经销商编码
        /// </summary>
        [Comment("经销商编码")]
        public string? DealerCode { get; set; }

        /// <summary>
        /// 经销商名称
        /// </summary>
        [Comment("经销商名称")]
        public string? DealerName { get; set; }


        /// <summary>
        /// 经销商类型
        /// </summary>
        [Comment("经销商类型")]
        public string? DealerLevel { get; set; }

        /// <summary>
        /// 经销商状态
        /// </summary>
        [Comment("经销商状态")]
        public string? DealerStatus { get; set; }


        /// <summary>
        /// 上游公司编码
        /// </summary>
        [Comment("上游公司编码")]
        public string? ParentDealerCode { get; set; }

        /// <summary>
        /// 上游公司名称
        /// </summary>
        [Comment("上游公司名称")]
        public string? ParentDealerName { get; set; }

        /// <summary>
        /// 仓库名称
        /// </summary>
        [Comment("仓库名称")]
        public string? WarehouseName { get; set; }

        /// <summary>
        /// 仓库类型
        /// </summary>
        [Comment("仓库类型")]
        public string? WarehouseType { get; set; }

        /// <summary>
        /// 产品型号
        /// </summary>
        [Comment("产品型号")]
        public string? UPN { get; set; }


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

        /// <summary>
        /// 产品有效期
        /// </summary>
        [Comment("产品有效期")]
        public DateOnly? ExpiredDate { get; set; }

        /// <summary>
        /// 转移时间
        /// </summary>
        [Comment("转移时间")]
        public DateOnly? TransferDate { get; set; }

        /// <summary>
        /// 库存日期
        /// </summary>
        [Comment("库存日期")]
        public DateOnly? InventoryDate { get; set; }

        /// <summary>
        /// 库存类型
        /// </summary>
        [Comment("库存类型")]
        public string? InventoryType { get; set; }

        /// <summary>
        /// 数量
        /// </summary>
        [Comment("数量")]
        [Precision(15,5)]
        public decimal? Qty { get; set; }

        /// <summary>
        /// 更新日期
        /// </summary>
        [Comment("更新日期")]
        [Timestamp]
        public byte[]? TSN { get; set; }
    }
}