Skip to content

Instantly share code, notes, and snippets.

@bjarki
Created February 26, 2014 12:50
Show Gist options
  • Save bjarki/9228946 to your computer and use it in GitHub Desktop.
Save bjarki/9228946 to your computer and use it in GitHub Desktop.
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