namespace iWareSql.MyDbContext
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    public partial class ware_material
    {
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public long Id { get; set; }

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

        [StringLength(200)]
        public string Name { get; set; }

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

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

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

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

        public decimal? Long { get; set; }

        public decimal? Width { get; set; }

        public decimal? High { get; set; }

        public decimal? Weight { get; set; }

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

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

        public int? MinMaterials { get; set; }

        public decimal? Miniquantity { get; set; }

        public decimal? Maxquantity { get; set; }

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

        public decimal? QualityAssurance { get; set; }

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

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

        public int? Status { get; set; }

        public long? TenantId { get; set; }

        public DateTimeOffset? CreatedTime { get; set; }

        public DateTimeOffset? UpdatedTime { get; set; }

        public long? CreatedUserId { get; set; }

        [StringLength(20)]
        public string CreatedUserName { get; set; }

        public long? UpdatedUserId { get; set; }

        [StringLength(20)]
        public string UpdatedUserName { get; set; }

        public bool? IsDeleted { get; set; }

        public int? DepositQuality { get; set; }

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

        public decimal? Proportion { get; set; }

        public decimal? MaterialMinStock { get; set; }

        public decimal? MaterialMaxStock { get; set; }

        public int? OverdueTime { get; set; }

        public bool? IsCheck { get; set; }

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

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

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

        public DateTime? SAP_CreatedTime { get; set; }

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

        public DateTime? SAP_UpdatedTime { get; set; }

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

        public bool? IsBatchMge { get; set; }

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

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

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

        public decimal? SafetyStovk { get; set; }

        public bool? IsBackflush { get; set; }

        public DateTimeOffset? PlannedDeliveryDate { get; set; }

        public bool? IsQualityManagement { get; set; }

        [StringLength(200)]
        public string Manufacturer { get; set; }
    }
}