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; }
|
}
|
}
|
