Created
February 26, 2014 12:50
-
-
Save bjarki/9228946 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
using System; | |
using System.ComponentModel; | |
using ServiceStack.DataAnnotations; | |
namespace SpiderServer.Models.DataModels | |
{ | |
[Localizable(false)] | |
[Alias("View_OrdersTasks2_Addresses_AddressNames")] | |
internal class DataViewOrdersTasks2AddressesAddressName | |
{ | |
public string OrderID { get; set; } | |
public string SpiderCustomerIDFK { get; set; } | |
public string GroupIDFK { get; set; } | |
public string CategoryIDFK { get; set; } | |
public string ShipmentNumber { get; set; } | |
public double? Revenue { get; set; } | |
public double Quantity0 { get; set; } | |
public double Quantity1 { get; set; } | |
public double Quantity2 { get; set; } | |
public string ProductIDFK { get; set; } | |
public double? Priority { get; set; } | |
public string Description { get; set; } | |
public string FreeText1 { get; set; } | |
public string FreeText2 { get; set; } | |
public string FreeText3 { get; set; } | |
public string FreeText4 { get; set; } | |
public string FreeText5 { get; set; } | |
public string FreeText6 { get; set; } | |
public int? PickupToDeliveryMetres { get; set; } | |
public int? PickupToDeliverySeconds { get; set; } | |
public double? PickupToDeliveryCost { get; set; } | |
public int? OrderSplitNumber { get; set; } | |
public string TourIDFK { get; set; } | |
public bool LockedToTour { get; set; } | |
public int Status { get; set; } | |
public DateTime StatusUpdateTime { get; set; } | |
public string StatusUpdatePerson { get; set; } | |
public int? SelectedFrequency { get; set; } | |
public double? MarginalCost { get; set; } | |
public double? MarginalSeconds { get; set; } | |
public double? MarginalMeters { get; set; } | |
public double? CurrentOrderToTourCost { get; set; } | |
public string FrequencyCode { get; set; } | |
public string VMIUnitIDFK { get; set; } | |
public double? EstimatedQuantity0 { get; set; } | |
public double? EstimatedQuantity1 { get; set; } | |
public double? EstimatedQuantity2 { get; set; } | |
public double? ActualQuantity0 { get; set; } | |
public double? ActualQuantity1 { get; set; } | |
public double? ActualQuantity2 { get; set; } | |
public TimeSpan NewOrUpdateTimeStamp { get; set; } | |
[Alias("OrderIDFK Pickup")] | |
public string OrderIDFKPickup { get; set; } | |
[Alias("Type Pickup")] | |
public int TypePickup { get; set; } | |
[Alias("LocationIDFK Pickup")] | |
public string LocationIDFK_Pickup { get; set; } | |
[Alias("AddressIDFK Pickup")] | |
public int? AddressIDFKPickup { get; set; } | |
[Alias("OriginalAddress_StreetNamePossiblyNumber Pickup")] | |
public string OriginalAddressStreetNamePossiblyNumberPickup { get; set; } | |
[Alias("OriginalAddress_StreetNumber Pickup")] | |
public int? OriginalAddressStreetNumberPickup { get; set; } | |
[Alias("OriginalAddress_StreetLetter Pickup")] | |
public string OriginalAddressStreetLetterPickup { get; set; } | |
[Alias("OriginalAddress_StreetNameEntryFrom Pickup")] | |
public string OriginalAddressStreetNameEntryFromPickup { get; set; } | |
[Alias("OriginalAddress_PostalCode Pickup")] | |
public string OriginalAddressPostalCodePickup { get; set; } | |
[Alias("OriginalAddress_PostalName Pickup")] | |
public string OriginalAddressPostalNamePickup { get; set; } | |
[Alias("OriginalAddress_Level5 Pickup")] | |
public string OriginalAddressLevel5Pickup { get; set; } | |
[Alias("OriginalAddress_Level4 Pickup")] | |
public string OriginalAddressLevel4Pickup { get; set; } | |
[Alias("OriginalAddress_Level3 Pickup")] | |
public string OriginalAddressLevel3Pickup { get; set; } | |
[Alias("OriginalAddress_Level2 Pickup")] | |
public string OriginalAddressLevel2Pickup { get; set; } | |
[Alias("OriginalAddress_Area Pickup")] | |
public string OriginalAddressAreaPickup { get; set; } | |
[Alias("OriginalAddress_X Pickup")] | |
public double? OriginalAddressXPickup { get; set; } | |
[Alias("OriginalAddress_Y Pickup")] | |
public double? OriginalAddressYPickup { get; set; } | |
[Alias("OriginalAddress_CoordinateSystem Pickup")] | |
public string OriginalAddressCoordinateSystemPickup { get; set; } | |
[Alias("Country Pickup")] | |
public string CountryPickup { get; set; } | |
[Alias("AddressSimilarity Pickup")] | |
public float? AddressSimilarityPickup { get; set; } | |
[Alias("PartsOfStreetNameRemoved Pickup")] | |
public bool PartsOfStreetNameRemovedPickup { get; set; } | |
[Alias("PostalCodeChanged Pickup")] | |
public bool PostalCodeChangedPickup { get; set; } | |
[Alias("PostalNameChanged Pickup")] | |
public bool PostalNameChangedPickup { get; set; } | |
[Alias("FreeeText Pickup")] | |
public string FreeeTextPickup { get; set; } | |
[Alias("TW1Start Pickup")] | |
public DateTime? TW1StartPickup { get; set; } | |
[Alias("TW1End Pickup")] | |
public DateTime? TW1EndPickup { get; set; } | |
[Alias("TW2Start Pickup")] | |
public DateTime? TW2StartPickup { get; set; } | |
[Alias("TW2End Pickup")] | |
public DateTime? TW2EndPickup { get; set; } | |
[Alias("ServiceTimeFormulaIDFK Pickup")] | |
public string ServiceTimeFormulaIDFKPickup { get; set; } | |
[Alias("FixedStopTimePrLocationSeconds Pickup")] | |
public int FixedStopTimePrLocationSecondsPickup { get; set; } | |
[Alias("TaskServiceTimeSeconds Pickup")] | |
public int TaskServiceTimeSecondsPickup { get; set; } | |
[Alias("SequenceNumber Pickup")] | |
public double? SequenceNumberPickup { get; set; } | |
[Alias("EstimatedArrival Pickup")] | |
public DateTime? EstimatedArrivalPickup { get; set; } | |
[Alias("EstimatedIllegalArrivalSeconds Pickup")] | |
public int? EstimatedIllegalArrivalSecondsPickup { get; set; } | |
[Alias("EstimatedDeparture Pickup")] | |
public DateTime? EstimatedDeparturePickup { get; set; } | |
[Alias("UnproductiveSeconds Pickup")] | |
public int? UnproductiveSecondsPickup { get; set; } | |
[Alias("FlexSeconds Pickup")] | |
public int? FlexSecondsPickup { get; set; } | |
[Alias("AccumulatedTimeSeconds Pickup")] | |
public int? AccumulatedTimeSecondsPickup { get; set; } | |
[Alias("AccumulatedDistanceMetres Pickup")] | |
public int? AccumulatedDistanceMetresPickup { get; set; } | |
[Alias("ChamberAllocation Pickup")] | |
public string ChamberAllocationPickup { get; set; } | |
[Alias("PlannedFixedStopTimePrLocationSeconds Pickup")] | |
public double? PlannedFixedStopTimePrLocationSecondsPickup { get; set; } | |
[Alias("PlannedSumServiceTimeSeconds Pickup")] | |
public double? PlannedSumServiceTimeSecondsPickup { get; set; } | |
[Alias("DrivingBeforeStart1 Pickup")] | |
public DateTime? DrivingBeforeStart1Pickup { get; set; } | |
[Alias("DrivingBeforeEnd1 Pickup")] | |
public DateTime? DrivingBeforeEnd1Pickup { get; set; } | |
[Alias("DrivingBeforeStart2 Pickup")] | |
public DateTime? DrivingBeforeStart2Pickup { get; set; } | |
[Alias("DrivingBeforeEnd2 Pickup")] | |
public DateTime? DrivingBeforeEnd2Pickup { get; set; } | |
[Alias("DrivingAfterStart1 Pickup")] | |
public DateTime? DrivingAfterStart1Pickup { get; set; } | |
[Alias("DrivingAfterEnd1 Pickup")] | |
public DateTime? DrivingAfterEnd1Pickup { get; set; } | |
[Alias("DrivingAfterStart2 Pickup")] | |
public DateTime? DrivingAfterStart2Pickup { get; set; } | |
[Alias("DrivingAfterEnd2 Pickup")] | |
public DateTime? DrivingAfterEnd2Pickup { get; set; } | |
[Alias("ActualArrival Pickup")] | |
public DateTime? ActualArrivalPickup { get; set; } | |
[Alias("ActualDeparture Pickup")] | |
public DateTime? ActualDeparturePickup { get; set; } | |
[Alias("OrderIDFK Delivery")] | |
public string OrderIDFKDelivery { get; set; } | |
[Alias("Type Delivery")] | |
public int TypeDelivery { get; set; } | |
[Alias("LocationIDFK Delivery")] | |
public string LocationIDFK_Delivery { get; set; } | |
[Alias("AddressIDFK Delivery")] | |
public int? AddressIDFKDelivery { get; set; } | |
[Alias("OriginalAddress_StreetNamePossiblyNumber Delivery")] | |
public string OriginalAddressStreetNamePossiblyNumberDelivery { get; set; } | |
[Alias("OriginalAddress_StreetNumber Delivery")] | |
public int? OriginalAddressStreetNumberDelivery { get; set; } | |
[Alias("OriginalAddress_StreetLetter Delivery")] | |
public string OriginalAddressStreetLetterDelivery { get; set; } | |
[Alias("OriginalAddress_StreetNameEntryFrom Delivery")] | |
public string OriginalAddressStreetNameEntryFromDelivery { get; set; } | |
[Alias("OriginalAddress_PostalCode Delivery")] | |
public string OriginalAddressPostalCodeDelivery { get; set; } | |
[Alias("OriginalAddress_PostalName Delivery")] | |
public string OriginalAddressPostalNameDelivery { get; set; } | |
[Alias("OriginalAddress_Level5 Delivery")] | |
public string OriginalAddressLevel5Delivery { get; set; } | |
[Alias("OriginalAddress_Level4 Delivery")] | |
public string OriginalAddressLevel4Delivery { get; set; } | |
[Alias("OriginalAddress_Level3 Delivery")] | |
public string OriginalAddressLevel3Delivery { get; set; } | |
[Alias("OriginalAddress_Level2 Delivery")] | |
public string OriginalAddressLevel2Delivery { get; set; } | |
[Alias("OriginalAddress_Area Delivery")] | |
public string OriginalAddressAreaDelivery { get; set; } | |
[Alias("OriginalAddress_X Delivery")] | |
public double? OriginalAddressXDelivery { get; set; } | |
[Alias("OriginalAddress_Y Delivery")] | |
public double? OriginalAddressYDelivery { get; set; } | |
[Alias("OriginalAddress_CoordinateSystem Delivery")] | |
public string OriginalAddressCoordinateSystemDelivery { get; set; } | |
[Alias("Country Delivery")] | |
public string CountryDelivery { get; set; } | |
[Alias("AddressSimilarity Delivery")] | |
public float? AddressSimilarityDelivery { get; set; } | |
[Alias("PartsOfStreetNameRemoved Delivery")] | |
public bool PartsOfStreetNameRemovedDelivery { get; set; } | |
[Alias("PostalCodeChanged Delivery")] | |
public bool PostalCodeChangedDelivery { get; set; } | |
[Alias("PostalNameChanged Delivery")] | |
public bool PostalNameChangedDelivery { get; set; } | |
[Alias("FreeeText Delivery")] | |
public string FreeeTextDelivery { get; set; } | |
[Alias("TW1Start Delivery")] | |
public DateTime? TW1StartDelivery { get; set; } | |
[Alias("TW1End Delivery")] | |
public DateTime? TW1EndDelivery { get; set; } | |
[Alias("TW2Start Delivery")] | |
public DateTime? TW2StartDelivery { get; set; } | |
[Alias("TW2End Delivery")] | |
public DateTime? TW2EndDelivery { get; set; } | |
[Alias("ServiceTimeFormulaIDFK Delivery")] | |
public string ServiceTimeFormulaIDFKDelivery { get; set; } | |
[Alias("FixedStopTimePrLocationSeconds Delivery")] | |
public int FixedStopTimePrLocationSecondsDelivery { get; set; } | |
[Alias("TaskServiceTimeSeconds Delivery")] | |
public int TaskServiceTimeSecondsDelivery { get; set; } | |
[Alias("SequenceNumber Delivery")] | |
public double? SequenceNumberDelivery { get; set; } | |
[Alias("EstimatedArrival Delivery")] | |
public DateTime? EstimatedArrivalDelivery { get; set; } | |
[Alias("EstimatedIllegalArrivalSeconds Delivery")] | |
public int? EstimatedIllegalArrivalSecondsDelivery { get; set; } | |
[Alias("EstimatedDeparture Delivery")] | |
public DateTime? EstimatedDepartureDelivery { get; set; } | |
[Alias("UnproductiveSeconds Delivery")] | |
public int? UnproductiveSecondsDelivery { get; set; } | |
[Alias("FlexSeconds Delivery")] | |
public int? FlexSecondsDelivery { get; set; } | |
[Alias("AccumulatedTimeSeconds Delivery")] | |
public int? AccumulatedTimeSecondsDelivery { get; set; } | |
[Alias("AccumulatedDistanceMetres Delivery")] | |
public int? AccumulatedDistanceMetresDelivery { get; set; } | |
[Alias("ChamberAllocation Delivery")] | |
public string ChamberAllocationDelivery { get; set; } | |
[Alias("PlannedFixedStopTimePrLocationSeconds Delivery")] | |
public double? PlannedFixedStopTimePrLocationSecondsDelivery { get; set; } | |
[Alias("PlannedSumServiceTimeSeconds Delivery")] | |
public double? PlannedSumServiceTimeSecondsDelivery { get; set; } | |
[Alias("DrivingBeforeStart1 Delivery")] | |
public DateTime? DrivingBeforeStart1Delivery { get; set; } | |
[Alias("DrivingBeforeEnd1 Delivery")] | |
public DateTime? DrivingBeforeEnd1Delivery { get; set; } | |
[Alias("DrivingBeforeStart2 Delivery")] | |
public DateTime? DrivingBeforeStart2Delivery { get; set; } | |
[Alias("DrivingBeforeEnd2 Delivery")] | |
public DateTime? DrivingBeforeEnd2Delivery { get; set; } | |
[Alias("DrivingAfterStart1 Delivery")] | |
public DateTime? DrivingAfterStart1Delivery { get; set; } | |
[Alias("DrivingAfterEnd1 Delivery")] | |
public DateTime? DrivingAfterEnd1Delivery { get; set; } | |
[Alias("DrivingAfterStart2 Delivery")] | |
public DateTime? DrivingAfterStart2Delivery { get; set; } | |
[Alias("DrivingAfterEnd2 Delivery")] | |
public DateTime? DrivingAfterEnd2Delivery { get; set; } | |
[Alias("ActualArrival Delivery")] | |
public DateTime? ActualArrivalDelivery { get; set; } | |
[Alias("ActualDeparture Delivery")] | |
public DateTime? ActualDepartureDelivery { get; set; } | |
[Alias("AddressID Pickup")] | |
public int? AddressIDPickup { get; set; } | |
[Alias("StreetIDFK Pickup")] | |
public int? StreetIDFKPickup { get; set; } | |
[Alias("Street Pickup")] | |
public string StreetPickup { get; set; } | |
[Alias("StreetNumber Pickup")] | |
public int? StreetNumberPickup { get; set; } | |
[Alias("StreetNumber2 Pickup")] | |
public int? StreetNumber2Pickup { get; set; } | |
[Alias("StreetLetterOrLOrR Pickup")] | |
public string StreetLetterOrLOrRPickup { get; set; } | |
[Alias("PostalCodeIDFK Pickup")] | |
public int? PostalCodeIDFKPickup { get; set; } | |
[Alias("PostalCode Pickup")] | |
public string PostalCodePickup { get; set; } | |
[Alias("PostalNameIDFK Pickup")] | |
public int? PostalNameIDFKPickup { get; set; } | |
[Alias("PostalName Pickup")] | |
public string PostalNamePickup { get; set; } | |
[Alias("Level5IDFK Pickup")] | |
public int? Level5IDFKPickup { get; set; } | |
[Alias("Level5 Pickup")] | |
public string Level5Pickup { get; set; } | |
[Alias("Level4IDFK Pickup")] | |
public int? Level4IDFKPickup { get; set; } | |
[Alias("Level4 Pickup")] | |
public string Level4Pickup { get; set; } | |
[Alias("Level3IDFK Pickup")] | |
public int? Level3IDFKPickup { get; set; } | |
[Alias("Level3 Pickup")] | |
public string Level3Pickup { get; set; } | |
[Alias("Level2IDFK Pickup")] | |
public int? Level2IDFKPickup { get; set; } | |
[Alias("Level2 Pickup")] | |
public string Level2Pickup { get; set; } | |
[Alias("CountryIDFK Pickup")] | |
public int? CountryIDFKPickup { get; set; } | |
[Alias("X Pickup")] | |
public float? XPickup { get; set; } | |
[Alias("Y Pickup")] | |
public float? YPickup { get; set; } | |
[Alias("X2 Pickup")] | |
public float? X2Pickup { get; set; } | |
[Alias("Y2 Pickup")] | |
public float? Y2Pickup { get; set; } | |
[Alias("RoadLinkID Pickup")] | |
public long? RoadLinkIDPickup { get; set; } | |
[Alias("Origin Pickup")] | |
public byte? OriginPickup { get; set; } | |
[Alias("AddressID Delivery")] | |
public int? AddressIDDelivery { get; set; } | |
[Alias("StreetIDFK Delivery")] | |
public int? StreetIDFKDelivery { get; set; } | |
[Alias("Street Delivery")] | |
public string StreetDelivery { get; set; } | |
[Alias("StreetNumber Delivery")] | |
public int? StreetNumberDelivery { get; set; } | |
[Alias("StreetNumber2 Delivery")] | |
public int? StreetNumber2Delivery { get; set; } | |
[Alias("StreetLetterOrLOrR Delivery")] | |
public string StreetLetterOrLOrRDelivery { get; set; } | |
[Alias("PostalCodeIDFK Delivery")] | |
public int? PostalCodeIDFKDelivery { get; set; } | |
[Alias("PostalCode Delivery")] | |
public string PostalCodeDelivery { get; set; } | |
[Alias("PostalNameIDFK Delivery")] | |
public int? PostalNameIDFKDelivery { get; set; } | |
[Alias("PostalName Delivery")] | |
public string PostalNameDelivery { get; set; } | |
[Alias("Level5IDFK Delivery")] | |
public int? Level5IDFKDelivery { get; set; } | |
[Alias("Level5 Delivery")] | |
public string Level5Delivery { get; set; } | |
[Alias("Level4IDFK Delivery")] | |
public int? Level4IDFKDelivery { get; set; } | |
[Alias("Level4 Delivery")] | |
public string Level4Delivery { get; set; } | |
[Alias("Level3IDFK Delivery")] | |
public int? Level3IDFKDelivery { get; set; } | |
[Alias("Level3 Delivery")] | |
public string Level3Delivery { get; set; } | |
[Alias("Level2IDFK Delivery")] | |
public int? Level2IDFKDelivery { get; set; } | |
[Alias("Level2 Delivery")] | |
public string Level2Delivery { get; set; } | |
[Alias("CountryIDFK Delivery")] | |
public int? CountryIDFKDelivery { get; set; } | |
[Alias("X Delivery")] | |
public float? XDelivery { get; set; } | |
[Alias("Y Delivery")] | |
public float? YDelivery { get; set; } | |
[Alias("X2 Delivery")] | |
public float? X2Delivery { get; set; } | |
[Alias("Y2 Delivery")] | |
public float? Y2Delivery { get; set; } | |
[Alias("RoadLinkID Delivery")] | |
public long? RoadLinkIDDelivery { get; set; } | |
[Alias("Origin Delivery")] | |
public byte? OriginDelivery { get; set; } | |
public double? CV1 { get; set; } | |
public double? CV2 { get; set; } | |
public double? CV3 { get; set; } | |
public double? CV4 { get; set; } | |
public double? CV5 { get; set; } | |
public double? CV6 { get; set; } | |
public double? CV7 { get; set; } | |
public double? CV8 { get; set; } | |
public double? CV9 { get; set; } | |
public double? CV10 { get; set; } | |
public double? CV11 { get; set; } | |
public double? CV12 { get; set; } | |
public double? CT1 { get; set; } | |
public double? CT2 { get; set; } | |
public double? CT3 { get; set; } | |
public double? CT4 { get; set; } | |
public double? CT5 { get; set; } | |
public double? CT6 { get; set; } | |
public double? CT7 { get; set; } | |
public double? CT8 { get; set; } | |
public double? CT9 { get; set; } | |
public double? CT10 { get; set; } | |
public double? CT11 { get; set; } | |
public double? CT12 { get; set; } | |
[Alias("NewOrUpdateTimeStamp Pickup")] | |
public TimeSpan NewOrUpdateTimeStamp_Pickup { get; set; } | |
[Alias("NewOrUpdateTimeStamp Delivery")] | |
public TimeSpan NewOrUpdateTimeStamp_Delivery { get; set; } | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment