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

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

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

        public decimal? ReceivedQuantity { get; set; }

        public decimal? DeliveryTotalQuantity { get; set; }

        public decimal? UncollectedQuantity { get; set; }

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

        public decimal? SurplusWarehousQuantity { get; set; }

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

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

        public DateTime? ReceiptDate { get; set; }

        [StringLength(500)]
        public string Remark { 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; }

        public long? UpdatedUserId { get; set; }

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

        public bool? IsDeleted { get; set; }

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

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

        public int? MaterialType { get; set; }

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

        public bool IsCheck { get; set; }

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

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

        public DateTimeOffset? CancelTime { get; set; }

        public long? CancelUserId { get; set; }

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

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

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

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

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

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