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

        public long OrdersId { get; set; }

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

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

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

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

        [StringLength(255)]
        public string BatchNo { get; set; }

        [StringLength(255)]
        public string TONo { get; set; }

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

        public decimal? CompleteQuantity { get; set; }

        public decimal? Quantity { get; set; }

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

        public int OrderStatus { 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? IsDeleted { get; set; }

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

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

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

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

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

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

        public decimal? DeliveryQuantity { get; set; }

        public DateTime? DemandDate { get; set; }

        public long? OrderDetailId { get; set; }

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

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

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

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

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

        public int? SortOrderIssueStatus { get; set; }

        public int? OrderSortStatus { get; set; }

        public int? OrderPickStatus { get; set; }

        public int? OrderDeliverGoodsStatus { get; set; }

        public decimal HasPickQuantity { get; set; }

        public decimal? HasDeliverQuantity { get; set; }
    }
}