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

        public long? ParentId { get; set; }

        public long? OrderId { get; set; }

        public long? OrderDetailId { get; set; }

        public string OrderNo { get; set; }

        public int? OrderType { get; set; }

        public string MaterialName { get; set; }

        public string MaterialCode { get; set; }

        public decimal? Quantity { get; set; }

        public string BatchNo { get; set; }

        public bool? IsBatchMge { get; set; }

        public string LineNumber { get; set; }

        public string Unit { get; set; }

        public string Sap_Location { get; set; }

        public string Costcenter { get; set; }

        public string MaterialResvNo { get; set; }

        public string MaterialResvItem { get; set; }

        [Column(TypeName = "datetime2")]
        public DateTime? RequirementDate { get; set; }

        public int? Sap_ConfirmCount { get; set; }

        public int? Sap_ConfirmStatus { get; set; }

        public string Sap_ConfirmMessage { get; set; }

        [Column(TypeName = "datetime2")]
        public DateTime? Sap_PushTime { get; set; }

        public string Remark { get; set; }

        public int Sap_ActionType { get; set; }

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

        public string Client { get; set; }

        public string ClientName { 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 string OrderEquipment { get; set; }

        public int? ReviewSatus { get; set; }

        public string ReviewComments { get; set; }

        public string ReviewMan { get; set; }

        [Column(TypeName = "datetime2")]
        public DateTime? ReviewTime { get; set; }

        public string Recipient { get; set; }

        public string WareMaterialCode { get; set; }

        public bool? IsContainAppendix { get; set; }

        public DateTimeOffset? CreatedTime { get; set; }

        public DateTimeOffset? UpdatedTime { get; set; }

        public long? CreatedUserId { get; set; }

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

        public long? UpdatedUserId { get; set; }

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

        public bool IsDeleted { get; set; }

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

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

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

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

        public long? ware_delivery_record_Id { get; set; }

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

        public long? OldDeliveryRecordId { get; set; }

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

        public bool? IsPicking { get; set; }

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