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 v_ware_inventory_by_all
    {
        [Key]
        [Column(Order = 0)]
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public long Id { get; set; }

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

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

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

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

        public bool? IsBackflush { get; set; }

        public decimal? Quantity { get; set; }

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

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

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

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

        public bool? IsLocked { get; set; }

        public DateTime? DoLockTime { get; set; }

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

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

        [StringLength(5)]
        public string OrderType { get; set; }

        public bool? IsDeleted { get; set; }

        public int? CreatedUserId { get; set; }

        public int? CreatedUserName { get; set; }

        public DateTimeOffset? CreatedTime { get; set; }

        public DateTime? RecordInsertTime { get; set; }

        public int? UpdatedUserId { get; set; }

        public int? UpdatedUserName { get; set; }

        public int? UpdatedTime { get; set; }

        public decimal? ScrapQuantity { get; set; }

        public int? WareAge { get; set; }

        public int? GridNumber { get; set; }

        public int? UseNumber { get; set; }

        [StringLength(32)]
        public string PalletType { get; set; }

        [Key]
        [Column(Order = 1)]
        [StringLength(100)]
        public string Sap_Location { get; set; }

        public int? CheckStatus { get; set; }

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

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

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

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