namespace wcftest.orm
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    public partial class Stat_StorageDay
    {
        [Key]
        public long StorageDay_Id { get; set; }

        [Column(TypeName = "date")]
        public DateTime? StorageDay { get; set; }

        public int Storage_Id { get; set; }

        [Required]
        [StringLength(50)]
        public string StorageName { get; set; }

        public int Consignor_Id { get; set; }

        [Required]
        [StringLength(50)]
        public string ConsignorCode { get; set; }

        [Required]
        [StringLength(150)]
        public string ConsignorName { get; set; }

        public long Product_Id { get; set; }

        [Required]
        [StringLength(50)]
        public string ProductCode { get; set; }

        [Required]
        [StringLength(500)]
        public string ProductName { get; set; }

        [Required]
        [StringLength(300)]
        public string ProductModel { get; set; }

        public string ProductSpec { get; set; }

        public int? ProductStorage { get; set; }

        public int? ValidStorage { get; set; }

        public int? OrignStorage { get; set; }

        [Column(TypeName = "money")]
        public decimal? PurchasePrice { get; set; }

        [Column(TypeName = "money")]
        public decimal? PurchaseMoney { get; set; }

        public decimal? ScanInQuantity { get; set; }

        public decimal? ScanShelveQuantity { get; set; }

        public decimal? OtherInQuantity { get; set; }

        public decimal? BorrowInQuantity { get; set; }

        public decimal? ReturnQuantity { get; set; }

        public int? CheckInQuantity { get; set; }

        public int? BorrowOutQuantity { get; set; }

        public int? ScanOutQuantity { get; set; }

        public int? OtherOutQuantity { get; set; }

        public int? CheckOutQuantity { get; set; }

        public string Remark { get; set; }

        public int? CreateID { get; set; }

        [StringLength(50)]
        public string Creator { get; set; }

        public DateTime? CreateDate { get; set; }

        public int? ModifyID { get; set; }

        [StringLength(50)]
        public string Modifier { get; set; }

        public DateTime? ModifyDate { get; set; }

        [StringLength(150)]
        public string TypeName { get; set; }

        [StringLength(150)]
        public string BrandName { get; set; }

        public int? AvgStorage { get; set; }

        public decimal? TurnoverRate { get; set; }

        public decimal? TurnoverDays { get; set; }

        public decimal? Inventorytime { get; set; }

        public int? PlatUser_Id { get; set; }

        [StringLength(50)]
        public string PlatUserCode { get; set; }

        [StringLength(50)]
        public string PlatUserName { get; set; }

        [StringLength(50)]
        public string PlatCorpName { get; set; }

        public int? UserProduct_Id { get; set; }

        [StringLength(50)]
        public string UserProductCode { get; set; }

        [StringLength(100)]
        public string UserProductAlias { get; set; }

        [StringLength(50)]
        public string ContainerNo { get; set; }

        public string ExpandFields { get; set; }
    }
}