/*
 *代码由框架生成,任何更改都可能导致被代码生成器覆盖
 *如果数据库字段发生变化，请在代码生器重新生成此Model
 */
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WIDESEA.Entity.SystemModels;

namespace WIDESEA.Entity.DomainModels
{
    [Entity(TableCnName = "盘点记录视图",TableName = "VV_QueryCheckRecordInfo")]
    public class VV_QueryCheckRecordInfo:BaseEntity
    {
        /// <summary>
       ///盘点头ID
       /// </summary>
       [Display(Name ="盘点头ID")]
       [Column(TypeName="uniqueidentifier")]
       [Required(AllowEmptyStrings=false)]
       public Guid stockhead_id { get; set; }

       /// <summary>
       ///盘点编号
       /// </summary>
       [Display(Name ="盘点编号")]
       [MaxLength(80)]
       [Column(TypeName="nvarchar(80)")]
       [Required(AllowEmptyStrings=false)]
       public string stockhead_number { get; set; }

       /// <summary>
       ///释放人
       /// </summary>
       [Display(Name ="释放人")]
       [MaxLength(40)]
       [Column(TypeName="nvarchar(40)")]
       public string stockhead_releaseby { get; set; }

       /// <summary>
       ///释放时间
       /// </summary>
       [Display(Name ="释放时间")]
       [Column(TypeName="datetime")]
       public DateTime? stockhead_releasetime { get; set; }

       /// <summary>
       ///等级
       /// </summary>
       [Display(Name ="等级")]
       [Column(TypeName="int")]
       public int? stockhead_grade { get; set; }

       /// <summary>
       ///盘点类型
       /// </summary>
       [Display(Name ="盘点类型")]
       [MaxLength(40)]
       [Column(TypeName="nvarchar(40)")]
       public string stockhead_type { get; set; }

       /// <summary>
       ///物料名称
       /// </summary>
       [Display(Name ="物料名称")]
       [MaxLength(400)]
       [Column(TypeName="nvarchar(400)")]
       [Required(AllowEmptyStrings=false)]
       public string materiel_name { get; set; }

       /// <summary>
       ///物料Id
       /// </summary>
       [Display(Name ="物料Id")]
       [MaxLength(200)]
       [Column(TypeName="nvarchar(200)")]
       [Required(AllowEmptyStrings=false)]
       public string materiel_id { get; set; }

       /// <summary>
       ///明细单据Id
       /// </summary>
       [Display(Name ="明细单据Id")]
       [Column(TypeName="uniqueidentifier")]
       [Required(AllowEmptyStrings=false)]
       public Guid stockdtl_id { get; set; }

       /// <summary>
       ///区域Id
       /// </summary>
       [Display(Name ="区域Id")]
       [MaxLength(80)]
       [Column(TypeName="nvarchar(80)")]
       public string stockdtl_areid { get; set; }

       /// <summary>
       ///批次号（供应商）
       /// </summary>
       [Display(Name ="批次号（供应商）")]
       [MaxLength(100)]
       [Column(TypeName="nvarchar(100)")]
       public string stockdtl_lotnumber { get; set; }

       /// <summary>
       ///明细状态
       /// </summary>
       [Display(Name ="明细状态")]
       [MaxLength(40)]
       [Column(TypeName="nvarchar(40)")]
       public string stockdtl_state { get; set; }

       /// <summary>
       ///记录Id
       /// </summary>
       [Key]
       [Display(Name ="记录Id")]
       [Column(TypeName="uniqueidentifier")]
       [Required(AllowEmptyStrings=false)]
       public Guid stockrecord_id { get; set; }

       /// <summary>
       ///库存数量
       /// </summary>
       [Display(Name ="库存数量")]
       [DisplayFormat(DataFormatString="18,2")]
       [Column(TypeName="decimal")]
       [Required(AllowEmptyStrings=false)]
       public decimal stockrecord_qty { get; set; }

       /// <summary>
       ///实际数量
       /// </summary>
       [Display(Name ="实际数量")]
       [DisplayFormat(DataFormatString="18,2")]
       [Column(TypeName="decimal")]
       public decimal? stockrecord_actualqty { get; set; }

       /// <summary>
       ///当前类型
       /// </summary>
       [Display(Name ="当前类型")]
       [MaxLength(80)]
       [Column(TypeName="nvarchar(80)")]
       public string stockrecord_type { get; set; }

       /// <summary>
       ///当前状态
       /// </summary>
       [Display(Name ="当前状态")]
       [MaxLength(40)]
       [Column(TypeName="nvarchar(40)")]
       public string stockrecord_state { get; set; }

       /// <summary>
       ///更新数量
       /// </summary>
       [Display(Name ="更新数量")]
       [DisplayFormat(DataFormatString="18,2")]
       [Column(TypeName="decimal")]
       public decimal? stockrecord_updateqty { get; set; }

       /// <summary>
       ///托盘号
       /// </summary>
       [Display(Name ="托盘号")]
       [MaxLength(100)]
       [Column(TypeName="nvarchar(100)")]
       public string stockrecord_sn { get; set; }

       /// <summary>
       ///创建人
       /// </summary>
       [Display(Name ="创建人")]
       [MaxLength(40)]
       [Column(TypeName="nvarchar(40)")]
       public string stockrecord_creator { get; set; }

       /// <summary>
       ///创建时间
       /// </summary>
       [Display(Name ="创建时间")]
       [Column(TypeName="datetime")]
       [Required(AllowEmptyStrings=false)]
       public DateTime stockrecord_createtime { get; set; }

       /// <summary>
       ///完成时间
       /// </summary>
       [Display(Name ="完成时间")]
       [Column(TypeName="datetime")]
       [Required(AllowEmptyStrings=false)]
       public DateTime stockrecord_finishtime { get; set; }

       /// <summary>
       ///操作者
       /// </summary>
       [Display(Name ="操作者")]
       [MaxLength(40)]
       [Column(TypeName="nvarchar(40)")]
       public string stockrecord_compeletor { get; set; }

       /// <summary>
       ///操作类型
       /// </summary>
       [Display(Name ="操作类型")]
       [MaxLength(20)]
       [Column(TypeName="nvarchar(20)")]
       public string stockrecord_operatetype { get; set; }

       /// <summary>
       ///来源货位
       /// </summary>
       [Display(Name ="来源货位")]
       [MaxLength(40)]
       [Column(TypeName="nvarchar(40)")]
       public string task_fromlocationid { get; set; }

       /// <summary>
       ///出库货位
       /// </summary>
       [Display(Name ="出库货位")]
       [MaxLength(40)]
       [Column(TypeName="nvarchar(40)")]
       public string task_outhsstation { get; set; }

       /// <summary>
       ///出库站台
       /// </summary>
       [Display(Name ="出库站台")]
       [MaxLength(40)]
       [Column(TypeName="nvarchar(40)")]
       public string task_outstation { get; set; }

       
    }
}