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_container_vs_material
    {
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public long Id { get; set; }

        public long? locationVsContainerid { get; set; }

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

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

        public decimal? Quantity { get; set; }

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

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

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

        public decimal? OCCQuantity { get; set; }

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

        [StringLength(50)]
        public string OrdersNo { 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; }

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

        public long? UpdatedUserId { get; set; }

        public bool? IsLocked { get; set; }

        public bool? IsDeleted { get; set; }

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

        public int? StockStatus { get; set; }

        public decimal? Price { get; set; }

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

        public int? MaterialType { get; set; }

        public int? LocationType { get; set; }

        public long? MaterialRegionId { get; set; }

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

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

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

        public DateTime? DoLockTime { get; set; }

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

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

        public int? CheckStatus { get; set; }

        public long? PurchaseOrderDetailId { get; set; }

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

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

        public DateTime? RecordInsertTime { get; set; }

        public long? GoodsDeliveryDetailsId { get; set; }
    }
}