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

        [Key]
        [Column(Order = 1)]
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public long OrdersId { get; set; }

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

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

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

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

        public int? ReviewSatus { get; set; }

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

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

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

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

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

        public decimal? Long { get; set; }

        public decimal? Width { get; set; }

        public decimal? High { get; set; }

        public decimal? Weight { get; set; }

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

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

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

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

        public int? OrderStatus { get; set; }

        [Key]
        [Column(Order = 2)]
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public int OrderDetailStatus { 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; }

        public int? Status { get; set; }

        public int? SourceBy { 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(5)]
        public string OrderType { get; set; }

        public int? LockedQty { get; set; }

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

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

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

        public int? Sap_ConfirmStatus { get; set; }

        public int? Sap_ConfirmCount { get; set; }

        public int? Sap_CancelConfirmStatus { get; set; }

        public bool? IsBatchMge { 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; }

        public int? Sap_CancelConfirmCount { get; set; }

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

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

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

        public DateTime? Sap_PushTime { get; set; }

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

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

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

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

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

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

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

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

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

        public decimal? Quantity { get; set; }

        public decimal? HasCreateWaveQuantity { get; set; }

        public decimal? HasIssueQuantity { get; set; }

        public decimal? HasPickQuantity { get; set; }

        public decimal? HasSortQuantity { get; set; }

        public decimal? HasDeliverQuantity { get; set; }

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

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

        public DateTime? RequirementDate { get; set; }

        public DateTime? SAPCreationDate { get; set; }

        public DateTime? SAPLastMovementDate { get; set; }

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

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

        public decimal? QI { get; set; }

        public decimal? SAPUnrestricted { get; set; }

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

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

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

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

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

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

        public DateTime? ActualDate { get; set; }

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

        public bool? Order_IsDeleted { get; set; }

        public bool? IsIgnore { get; set; }
    }
}