Basic ERD diagram of PV Database
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105
  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 TblGalvanizedDeal
  14. {
  15. public TblGalvanizedDeal()
  16. {
  17. this.TblGalvanizedTransactions = new HashSet<TblGalvanizedTransaction>();
  18. }
  19. public int OID { get; set; }
  20. public string AccountNumber { get; set; }
  21. public string MemberName { get; set; }
  22. public Nullable<int> WebcollectorKey { get; set; }
  23. public string ContractNumber { get; set; }
  24. public string Status { get; set; }
  25. public string SubStatus { get; set; }
  26. public string CCDStatus { get; set; }
  27. public Nullable<System.DateTime> ContractDate { get; set; }
  28. public Nullable<System.DateTime> InstalmentStartDate { get; set; }
  29. public Nullable<int> StrikeDate { get; set; }
  30. public Nullable<bool> DeferOccupation { get; set; }
  31. public Nullable<decimal> AdminFee { get; set; }
  32. public string SpouseName { get; set; }
  33. public string SpouseIDNUmber { get; set; }
  34. public string PrincipalName { get; set; }
  35. public Nullable<decimal> GalvanizedPresentValue { get; set; }
  36. public Nullable<decimal> PrescribedCapital { get; set; }
  37. public Nullable<decimal> CapitalOutstanding { get; set; }
  38. public Nullable<decimal> Instalment { get; set; }
  39. public Nullable<decimal> Receipts { get; set; }
  40. public Nullable<decimal> OutstandingBalance { get; set; }
  41. public Nullable<decimal> TotalArrears { get; set; }
  42. public Nullable<decimal> GalvanizedInterestRate { get; set; }
  43. public Nullable<int> AddendumUnits { get; set; }
  44. public Nullable<int> ClubUnits { get; set; }
  45. public string GalvanizedPeriod { get; set; }
  46. public Nullable<bool> EFTPayment { get; set; }
  47. public Nullable<bool> ManFeeEFTPayment { get; set; }
  48. public string CollectorComments { get; set; }
  49. public string ApprovalComments { get; set; }
  50. public Nullable<System.DateTime> DeclinedDate { get; set; }
  51. public Nullable<decimal> CostPerUnit { get; set; }
  52. public Nullable<int> DowngradeUnitsBy { get; set; }
  53. public string DowngradePeriod { get; set; }
  54. public Nullable<decimal> DowngradeIntRate { get; set; }
  55. public Nullable<decimal> DowngradeGalInstalment { get; set; }
  56. public Nullable<decimal> GalInstalmentYR1 { get; set; }
  57. public Nullable<decimal> GalInstalmentYR2 { get; set; }
  58. public Nullable<decimal> GalInstalmentYR3 { get; set; }
  59. public Nullable<decimal> GalInstalmentYR4 { get; set; }
  60. public Nullable<decimal> GalInstalmentYR5 { get; set; }
  61. public Nullable<decimal> GalInstalmentYR6 { get; set; }
  62. public Nullable<decimal> GalInstalmentYR7 { get; set; }
  63. public Nullable<decimal> BubblePerc { get; set; }
  64. public Nullable<bool> BubblePercentageOverride { get; set; }
  65. public string WithBubblePeriod { get; set; }
  66. public Nullable<decimal> WithBubbleIntRate { get; set; }
  67. public Nullable<decimal> WithBubbleGalInstalment { get; set; }
  68. public Nullable<decimal> WithBubbleGalInstalmentYR1 { get; set; }
  69. public Nullable<decimal> WithBubbleGalInstalmentYR2 { get; set; }
  70. public Nullable<decimal> WithBubbleGalInstalmentYR3 { get; set; }
  71. public Nullable<decimal> WithBubbleGalInstalmentYR4 { get; set; }
  72. public Nullable<decimal> WithBubbleGalInstalmentYR5 { get; set; }
  73. public Nullable<decimal> WithBubbleGalInstalmentYR6 { get; set; }
  74. public Nullable<decimal> WithBubbleGalInstalmentYR7 { get; set; }
  75. public string SelectedOption { get; set; }
  76. public Nullable<System.DateTime> SelectedDate { get; set; }
  77. public Nullable<int> DealStatus { get; set; }
  78. public Nullable<System.DateTime> ApprovedDate { get; set; }
  79. public Nullable<System.DateTime> DocumentationSentDate { get; set; }
  80. public Nullable<System.DateTime> DocumentationReceivedDate { get; set; }
  81. public Nullable<System.DateTime> DetailsSentDate { get; set; }
  82. public Nullable<bool> PrevailSelected { get; set; }
  83. public Nullable<int> PrevailPoints { get; set; }
  84. public Nullable<int> PrevailAddendumPoints { get; set; }
  85. public Nullable<int> PrevailFinitePoints { get; set; }
  86. public Nullable<int> PrevailTradePoints { get; set; }
  87. public Nullable<decimal> PrevailCurrentManagementFee { get; set; }
  88. public Nullable<decimal> PrevailNewManagementFeeTotal { get; set; }
  89. public Nullable<int> PrevailNewPoints { get; set; }
  90. public string Affordability { get; set; }
  91. public Nullable<decimal> PrevailNewFee { get; set; }
  92. public Nullable<int> PrevailCurrentYear { get; set; }
  93. public Nullable<int> PrevailAffordNewPoints { get; set; }
  94. public string AllocatedTo { get; set; }
  95. public Nullable<int> OptimisticLockField { get; set; }
  96. public Nullable<int> GCRecord { get; set; }
  97. public Nullable<int> Debtor { get; set; }
  98. public virtual TblDebtor TblDebtor { get; set; }
  99. public virtual ICollection<TblGalvanizedTransaction> TblGalvanizedTransactions { get; set; }
  100. }
  101. }