Basic ERD diagram of PV Database
Vous ne pouvez pas sélectionner plus de 25 sujets Les noms de sujets doivent commencer par une lettre ou un nombre, peuvent contenir des tirets ('-') et peuvent comporter jusqu'à 35 caractères.

TblLead.cs 6.0KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119
  1. //------------------------------------------------------------------------------
  2. // <auto-generated>
  3. // This code was generated from a template.
  4. //
  5. // Manual changes to this file may cause unexpected behavior in your application.
  6. // Manual changes to this file will be overwritten if the code is regenerated.
  7. // </auto-generated>
  8. //------------------------------------------------------------------------------
  9. namespace ERD
  10. {
  11. using System;
  12. using System.Collections.Generic;
  13. public partial class TblLead
  14. {
  15. public int LeadNum { get; set; }
  16. public string Title { get; set; }
  17. public string FirstName { get; set; }
  18. public string Initials { get; set; }
  19. public string Surname { get; set; }
  20. public string IDNumber { get; set; }
  21. public Nullable<System.DateTime> DateOfBirth { get; set; }
  22. public Nullable<int> MaritalStatus { get; set; }
  23. public string Cellphone { get; set; }
  24. public string WorkPhone { get; set; }
  25. public string HomePhone { get; set; }
  26. public string EmailAddress { get; set; }
  27. public string SpouseTitle { get; set; }
  28. public string SpouseFirstName { get; set; }
  29. public string SpouseInitials { get; set; }
  30. public string SpouseSurname { get; set; }
  31. public string SpouseIDNumber { get; set; }
  32. public Nullable<System.DateTime> SpouseDateOfBirth { get; set; }
  33. public string AddressLine1 { get; set; }
  34. public string AddressLine2 { get; set; }
  35. public string AddressLine3 { get; set; }
  36. public string AddressLine4 { get; set; }
  37. public string AddressLine5 { get; set; }
  38. public Nullable<System.DateTime> LastCalled { get; set; }
  39. public Nullable<System.DateTime> ConsentToCall { get; set; }
  40. public Nullable<bool> DoNotContact { get; set; }
  41. public Nullable<System.Guid> OwnedBy { get; set; }
  42. public Nullable<System.Guid> AllocatedTo { get; set; }
  43. public Nullable<System.DateTime> AllocatedDateTime { get; set; }
  44. public Nullable<System.DateTime> LeadDate { get; set; }
  45. public string OPCRef { get; set; }
  46. public Nullable<System.DateTime> OPCDate { get; set; }
  47. public string OPCCompany { get; set; }
  48. public Nullable<int> ImportSource { get; set; }
  49. public Nullable<int> OptimisticLockField { get; set; }
  50. public string FaxNumber { get; set; }
  51. public string Region { get; set; }
  52. public string LastNumberCalled { get; set; }
  53. public Nullable<int> Language { get; set; }
  54. public Nullable<short> Age { get; set; }
  55. public string Occupation { get; set; }
  56. public string SpouseOccupation { get; set; }
  57. public Nullable<bool> RegularHolidays { get; set; }
  58. public Nullable<int> TotalHolidayDuration { get; set; }
  59. public Nullable<int> LocalHolidayDuration { get; set; }
  60. public Nullable<int> IntHolidayDuration { get; set; }
  61. public string DreamDestination { get; set; }
  62. public string LastHolidayDestination { get; set; }
  63. public Nullable<int> LastHolidayYear { get; set; }
  64. public Nullable<int> AgeBand { get; set; }
  65. public string LeadID { get; set; }
  66. public Nullable<int> IncomeGroup { get; set; }
  67. public Nullable<int> Ethnicity { get; set; }
  68. public string BatchNumber { get; set; }
  69. public Nullable<bool> NotQualified { get; set; }
  70. public string VoucherNo { get; set; }
  71. public Nullable<int> ReferredBy { get; set; }
  72. public string Surveyor { get; set; }
  73. public string Comments { get; set; }
  74. public Nullable<bool> SurveyedBefore { get; set; }
  75. public string SurveyedByWhom { get; set; }
  76. public string PriorPresentedBy { get; set; }
  77. public Nullable<System.DateTime> DateCreated { get; set; }
  78. public Nullable<System.Guid> CreatedBy { get; set; }
  79. public Nullable<bool> DuplicateLead { get; set; }
  80. public Nullable<System.DateTime> LastShow { get; set; }
  81. public string CTBatchNumber { get; set; }
  82. public Nullable<System.Guid> SpecialTMAllocation { get; set; }
  83. public Nullable<System.DateTime> CallReschedule { get; set; }
  84. public Nullable<bool> CreditCard { get; set; }
  85. public string ImportSourceText { get; set; }
  86. public string RegionText { get; set; }
  87. public Nullable<bool> HardBlock { get; set; }
  88. public string SurveyorName { get; set; }
  89. public string CallStatus { get; set; }
  90. public Nullable<int> SalesRegion { get; set; }
  91. public Nullable<System.Guid> Countryname { get; set; }
  92. public Nullable<int> MostRecentRanking { get; set; }
  93. public Nullable<System.DateTime> SoftblockDateTime { get; set; }
  94. public Nullable<bool> SoftBlock { get; set; }
  95. public Nullable<bool> TimeOffLead { get; set; }
  96. public Nullable<int> TimeOffVoucherNumber { get; set; }
  97. public Nullable<int> TimeOffNonVoucherNumber { get; set; }
  98. public Nullable<System.Guid> OccupationNew { get; set; }
  99. public Nullable<System.Guid> SpouseOccupationNew { get; set; }
  100. public Nullable<int> HolidayInNigeria { get; set; }
  101. public Nullable<int> HolidayInternational { get; set; }
  102. public Nullable<bool> UseCreditCard { get; set; }
  103. public Nullable<bool> UseCheque { get; set; }
  104. public Nullable<bool> UseATM { get; set; }
  105. public Nullable<int> OPCLocation { get; set; }
  106. public string MarketingCampaign { get; set; }
  107. public Nullable<bool> CanMakeBooking { get; set; }
  108. public virtual TblEthnicity TblEthnicity { get; set; }
  109. public virtual TblImportSource TblImportSource { get; set; }
  110. public virtual TblIncomeBracket TblIncomeBracket { get; set; }
  111. public virtual Title Title1 { get; set; }
  112. public virtual TblTimeOffNoVoucher TblTimeOffNoVoucher { get; set; }
  113. public virtual TblTimeOffVoucher TblTimeOffVoucher { get; set; }
  114. public virtual Title Title2 { get; set; }
  115. }
  116. }