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

        public long SortId { get; set; }

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

        public int SortDetailStatus { get; set; }

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

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

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

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

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

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

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

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

        public decimal Quantity { get; set; }

        public decimal? DispenseQuantity { get; set; }

        public decimal? OffShelvesQuantity { get; set; }

        public decimal? DeliverQuantity { get; set; }

        public decimal? PickQuantity { get; set; }

        public decimal? IssueQuantity { get; set; }

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

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

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

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

        public DateTime? CreateTime { get; set; }

        public DateTime? UpdateTime { get; set; }

        public long? CreateUserId { get; set; }

        [StringLength(64)]
        public string CreateUserName { get; set; }

        public long? UpdateUserId { get; set; }

        [StringLength(64)]
        public string UpdateUserName { get; set; }

        public bool IsDelete { get; set; }

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

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

        public int? Priority { get; set; }
    }
}