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

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

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

        public decimal? Quantity { get; set; }

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

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

        public DateTimeOffset? CreatedTime { get; set; }

        public long? CreatedUserId { get; set; }

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

        public DateTimeOffset? UpdatedTime { get; set; }

        public long? UpdatedUserId { get; set; }

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

        public bool? IsDeleted { get; set; }

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

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

        [StringLength(50)]
        public string Process { 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(50)]
        public string BatchNo { get; set; }

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

        public int? OrderType { get; set; }

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

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

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

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

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

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

        public DateTime? Sap_PushTime { get; set; }

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

        public long? OrderDetailId { get; set; }

        public long? SortOrderDetailId { get; set; }

        public bool IsCancel { get; set; }

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

        public long? OldDeliveryRecordId { get; set; }

        public int? CancelStatus { get; set; }

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

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

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

        public DateTime? Sap_CancelPushTime { get; set; }

        public DateTime? Sap_UpdatePushTime { get; set; }

        public DateTime? Sap_DeletePushTime { get; set; }

        public int? CheckStatus { get; set; }

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

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

        public long? PurchaseOrderDetailId { get; set; }

        public int DeliveryType { get; set; }

        public long? YueKuId { get; set; }

        public bool IsYueKu { get; set; }

        public DateTime? RecordInsertTime { get; set; }

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

        public decimal? ReturnQuantity { get; set; }
    }
}