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.

Transfiguration.cs 11KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206
  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 Transfiguration
  14. {
  15. public Transfiguration()
  16. {
  17. this.TransfigContractInfoes = new HashSet<TransfigContractInfo>();
  18. this.TransfigSearchResults = new HashSet<TransfigSearchResult>();
  19. this.TblOverrideAudits = new HashSet<TblOverrideAudit>();
  20. }
  21. public int OID { get; set; }
  22. public Nullable<bool> OverideActive { get; set; }
  23. public Nullable<int> SalesManager { get; set; }
  24. public Nullable<decimal> PrimeRate { get; set; }
  25. public Nullable<int> TransfigStatus { get; set; }
  26. public Nullable<int> SalesAgent { get; set; }
  27. public string Surname { get; set; }
  28. public string FirstNames { get; set; }
  29. public string Initials { get; set; }
  30. public string Title { get; set; }
  31. public string SPSurname { get; set; }
  32. public string SPFirstNames { get; set; }
  33. public string SPInitials { get; set; }
  34. public string SPTitle { get; set; }
  35. public Nullable<bool> JointPurchase { get; set; }
  36. public Nullable<int> HowMarried { get; set; }
  37. public string AddrLine1 { get; set; }
  38. public string AddrLine2 { get; set; }
  39. public string AddrLine3 { get; set; }
  40. public string AddrLine4 { get; set; }
  41. public string PostalCode { get; set; }
  42. public string PostAddr1 { get; set; }
  43. public string PostAddr2 { get; set; }
  44. public string PostAddr3 { get; set; }
  45. public string PostAddr4 { get; set; }
  46. public string PostPostCode { get; set; }
  47. public string MembershipNo { get; set; }
  48. public string TelephoneNo { get; set; }
  49. public string BusinessPhoneNo { get; set; }
  50. public string Cellphone { get; set; }
  51. public string Email { get; set; }
  52. public string SPEmail { get; set; }
  53. public string IDNumber { get; set; }
  54. public string SPIDNumber { get; set; }
  55. public Nullable<System.DateTime> MFCommencementDate { get; set; }
  56. public Nullable<System.DateTime> CapitalCommencementDate { get; set; }
  57. public Nullable<System.DateTime> InsuranceCommencementDate { get; set; }
  58. public Nullable<int> ActivationYear { get; set; }
  59. public Nullable<bool> DeferUsage { get; set; }
  60. public string Notes { get; set; }
  61. public Nullable<System.DateTime> TransfigDate { get; set; }
  62. public string NewCompany { get; set; }
  63. public string ContractNo { get; set; }
  64. public string TFContractNumber { get; set; }
  65. public Nullable<int> Developer { get; set; }
  66. public string OldCompany { get; set; }
  67. public Nullable<int> ClubUnits { get; set; }
  68. public Nullable<decimal> CapitalOutstanding { get; set; }
  69. public Nullable<decimal> CapitalBF { get; set; }
  70. public Nullable<decimal> CapitalACB { get; set; }
  71. public Nullable<decimal> CapitalREC { get; set; }
  72. public Nullable<decimal> CapitalDJC { get; set; }
  73. public Nullable<decimal> CapitalDJD { get; set; }
  74. public Nullable<decimal> CapitalSF { get; set; }
  75. public Nullable<decimal> CapitalINT { get; set; }
  76. public Nullable<decimal> CapitalOther { get; set; }
  77. public Nullable<decimal> CapitalInstallment { get; set; }
  78. public Nullable<decimal> CapitalServiceFee { get; set; }
  79. public Nullable<decimal> CapitalInterest { get; set; }
  80. public Nullable<decimal> CapitalArrears { get; set; }
  81. public Nullable<decimal> MFOutstanding { get; set; }
  82. public Nullable<decimal> MFBF { get; set; }
  83. public Nullable<decimal> MFACB { get; set; }
  84. public Nullable<decimal> MFREC { get; set; }
  85. public Nullable<decimal> MFDJC { get; set; }
  86. public Nullable<decimal> MFDJD { get; set; }
  87. public Nullable<decimal> MFSF { get; set; }
  88. public Nullable<decimal> MFINT { get; set; }
  89. public Nullable<decimal> MFOther { get; set; }
  90. public Nullable<decimal> MFInstallment { get; set; }
  91. public Nullable<decimal> MFServiceFee { get; set; }
  92. public Nullable<decimal> MFArrears { get; set; }
  93. public Nullable<decimal> LifeOutstanding { get; set; }
  94. public Nullable<decimal> LifeBF { get; set; }
  95. public Nullable<decimal> LifeACB { get; set; }
  96. public Nullable<decimal> LifeREC { get; set; }
  97. public Nullable<decimal> LifeDJC { get; set; }
  98. public Nullable<decimal> LifeDJD { get; set; }
  99. public Nullable<decimal> LifeSF { get; set; }
  100. public Nullable<decimal> LifeINT { get; set; }
  101. public Nullable<decimal> LifeOther { get; set; }
  102. public Nullable<decimal> LifeInstallment { get; set; }
  103. public Nullable<decimal> LifeServiceFee { get; set; }
  104. public Nullable<decimal> LifeArrears { get; set; }
  105. public Nullable<int> sumOriginalUnits { get; set; }
  106. public Nullable<int> sumAddendumUnits { get; set; }
  107. public Nullable<int> sumTradeInUnits { get; set; }
  108. public Nullable<int> sumFiniteUnits { get; set; }
  109. public Nullable<int> sumCarryUnits { get; set; }
  110. public Nullable<decimal> sumManFeeCarry { get; set; }
  111. public Nullable<int> cccFiniteUnits { get; set; }
  112. public Nullable<decimal> cmfCurrentManFee { get; set; }
  113. public Nullable<int> cmfClubUnitsAvail { get; set; }
  114. public Nullable<decimal> PointSellingPrice { get; set; }
  115. public Nullable<int> NewPoints { get; set; }
  116. public Nullable<int> PaymentType { get; set; }
  117. public Nullable<int> PayPeriod { get; set; }
  118. public Nullable<int> CashPayPeriod { get; set; }
  119. public Nullable<int> Insurance { get; set; }
  120. public Nullable<int> DepositPercent { get; set; }
  121. public Nullable<int> FinitePoints { get; set; }
  122. public string InterestCharged { get; set; }
  123. public Nullable<int> InterestAdjustment { get; set; }
  124. public Nullable<decimal> ManagementFeeDue { get; set; }
  125. public Nullable<int> ManagementFeeYear { get; set; }
  126. public Nullable<decimal> BaseInstallment { get; set; }
  127. public Nullable<int> BankName { get; set; }
  128. public string BranchName { get; set; }
  129. public string BranchNumber { get; set; }
  130. public string AccountNumber { get; set; }
  131. public Nullable<int> AccountType { get; set; }
  132. public Nullable<decimal> TotalAmount { get; set; }
  133. public Nullable<int> RepayPeriod { get; set; }
  134. public Nullable<System.DateTime> DOCommenceDate { get; set; }
  135. public Nullable<bool> ReceiveInfo { get; set; }
  136. public Nullable<bool> OptOut { get; set; }
  137. public Nullable<bool> Reconsider { get; set; }
  138. public Nullable<int> OptimisticLockField { get; set; }
  139. public Nullable<int> GCRecord { get; set; }
  140. public Nullable<int> TypeOfContract { get; set; }
  141. public Nullable<decimal> AdditionalDeposit { get; set; }
  142. public Nullable<bool> ManagementFeeOnceOff { get; set; }
  143. public Nullable<int> WindowPeriod { get; set; }
  144. public Nullable<int> Window1Year { get; set; }
  145. public Nullable<int> Window1Points { get; set; }
  146. public Nullable<int> Window2Year { get; set; }
  147. public Nullable<int> Window2Points { get; set; }
  148. public Nullable<int> Window3Year { get; set; }
  149. public Nullable<int> Window3Points { get; set; }
  150. public string FeeType { get; set; }
  151. public Nullable<bool> ApplySlidingScale { get; set; }
  152. public Nullable<decimal> UnpostedAddAmt { get; set; }
  153. public Nullable<int> sumUnpostedAddUnits { get; set; }
  154. public Nullable<bool> ZeroInterestDeal { get; set; }
  155. public Nullable<bool> SentToContracts { get; set; }
  156. public Nullable<System.DateTime> SentToContractsDate { get; set; }
  157. public Nullable<bool> DontShow { get; set; }
  158. public string PaymentOccurrence { get; set; }
  159. public Nullable<System.DateTime> DODate { get; set; }
  160. public string CompanyTrustName { get; set; }
  161. public string CompRegNo { get; set; }
  162. public string MembershipNumNoClub { get; set; }
  163. public Nullable<bool> MovedToContracts { get; set; }
  164. public string BookingRefText { get; set; }
  165. public string BookingRef { get; set; }
  166. public Nullable<System.DateTime> RegFeeDate { get; set; }
  167. public Nullable<decimal> RegistrationFees { get; set; }
  168. public string CreditCardNumber { get; set; }
  169. public string CVCNumber { get; set; }
  170. public Nullable<int> CardType { get; set; }
  171. public Nullable<System.DateTime> CardExpiryDate { get; set; }
  172. public Nullable<int> SearchByOption { get; set; }
  173. public string SearchString { get; set; }
  174. public Nullable<int> Portfolio { get; set; }
  175. public Nullable<int> ContractCurrency { get; set; }
  176. public Nullable<double> ConversionRate { get; set; }
  177. public Nullable<int> PeriodInMonths { get; set; }
  178. public Nullable<bool> PersonalDataShared { get; set; }
  179. public Nullable<bool> UseDefaultInterestAdjustmentValue { get; set; }
  180. public Nullable<int> CommissionCode { get; set; }
  181. public Nullable<int> AccountTypeTEMP { get; set; }
  182. public Nullable<int> InsuranceReason { get; set; }
  183. public Nullable<bool> FinitePointsExpired { get; set; }
  184. public Nullable<bool> IsCompany { get; set; }
  185. public Nullable<bool> ReceiveCorrespondence { get; set; }
  186. public Nullable<bool> ReconsiderReceivingInfo { get; set; }
  187. public string CapacityOfRepresentative { get; set; }
  188. public string SpouseCellphone { get; set; }
  189. public string SpouseWorkphone { get; set; }
  190. public Nullable<int> DefaultCommunication { get; set; }
  191. public virtual Title Title1 { get; set; }
  192. public virtual Title Title2 { get; set; }
  193. public virtual ICollection<TransfigContractInfo> TransfigContractInfoes { get; set; }
  194. public virtual ICollection<TransfigSearchResult> TransfigSearchResults { get; set; }
  195. public virtual TblDeveloper TblDeveloper { get; set; }
  196. public virtual TblInsuranceReason TblInsuranceReason { get; set; }
  197. public virtual ICollection<TblOverrideAudit> TblOverrideAudits { get; set; }
  198. public virtual TblPersonnel TblPersonnel { get; set; }
  199. public virtual TblPersonnel TblPersonnel1 { get; set; }
  200. public virtual TblPortfolio TblPortfolio { get; set; }
  201. }
  202. }