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

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

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

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

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

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

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

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

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

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

        public int? OrderStatus { get; set; }

        public int? Status { get; set; }

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

        public int? SourceBy { get; set; }

        public long? TenantId { get; set; }

        public long? UpdatedUserId { get; set; }

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

        public DateTimeOffset? UpdatedTime { get; set; }

        public long? CreatedUserId { get; set; }

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

        public DateTimeOffset? CreatedTime { get; set; }

        public bool? IsDeleted { get; set; }

        public DateTime? RequirementDate { get; set; }

        public int? WriteOffState { get; set; }

        public int? SortStatus { get; set; }

        public string WareMaterialCode { get; set; }

        public bool? IsContainAppendix { get; set; }

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

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

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

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

        [Key]
        [Column(Order = 1)]
        public decimal TotalQuantity { get; set; }

        public decimal? HasCreateWaveQuantity { get; set; }

        public decimal? HasIssueQuantity { get; set; }

        public decimal? HasPickQuantity { get; set; }

        public decimal? DeliveryQuantity { get; set; }

        public decimal? SortQuantity { get; set; }

        public decimal? BeSortQuantity { get; set; }

        public decimal? BeDeliveryQuantity { get; set; }

        public int? SAP_ConfirmStatus { get; set; }

        public int? SAP_ConfirmCount { get; set; }

        public int? SAP_CancelConfirmStatus { get; set; }

        public int? SAP_CancelConfirmCount { get; set; }

        public int? SAP_UpdateConfirmStatus { get; set; }

        public int? SAP_UpdateConfirmCount { get; set; }

        public int? SAP_DeleteConfirmStatus { get; set; }

        public int? SAP_DeleteConfirmCount { get; set; }

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

        public DateTime? SAP_PushTime { get; set; }

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

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

        public int? ReviewSatus { get; set; }

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

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

        public DateTime? ReviewTime { get; set; }

        public int? OrderCreateWaveStatus { get; set; }

        public int? SortOrderIssueStatus { get; set; }

        public int? OrderPickStatus { get; set; }

        public int? OrderSortStatus { get; set; }

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