Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
account_schema [2019/01/30 11:57]
kcifreo
account_schema [2019/01/30 11:59] (current)
kcifreo
Line 14: Line 14:
   * AccountContactUserField   * AccountContactUserField
  
-<​html><​div style="​margin-left:​ 40px;">>> linked on AccountContact.ID = AccountContactUserField.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on AccountContact.ID = AccountContactUserField.ID </​div></​html>​
  
   * Address   * Address
  
-<​html><​div style="​margin-left:​ 40px;">>> linked on AccountContact.BillingAddressID = Address.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on AccountContact.BillingAddressID = Address.ID </​div></​html>​
  
-<​html><​div style="​margin-left:​ 40px;">>> linked on AccountContact.ShippingAddressID = Address.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on AccountContact.ShippingAddressID = Address.ID </​div></​html>​
  
   * AddressLink   * AddressLink
  
-<​html><​div style="​margin-left:​ 40px;">>> linked on AccountContact.ID = AddressLink.ParentID and AccountContact.ClassTypeID = AddressLink.ParentClassTypeID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on AccountContact.ID = AddressLink.ParentID and AccountContact.ClassTypeID = AddressLink.ParentClassTypeID </​div></​html>​
  
   * Address   * Address
  
-<​html><​div style="​margin-left:​ 40px;">>>​> linked on AddressLink.AddressID = Address.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on AddressLink.AddressID = Address.ID </​div></​html>​
  
   * PhoneNumber   * PhoneNumber
  
-<​html><​div style="​margin-left:​ 40px;">>> linked on AccountContact.MainPhoneNumberID = PhoneNumber.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on AccountContact.MainPhoneNumberID = PhoneNumber.ID </​div></​html>​
  
-<​html><​div style="​margin-left:​ 40px;">>> linked on AccountContact.MainFaxNumberID = PhoneNumber.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on AccountContact.MainFaxNumberID = PhoneNumber.ID </​div></​html>​
  
   * Employee (used when using separate sales people for contacts)   * Employee (used when using separate sales people for contacts)
  
-<​html><​div style="​margin-left:​ 40px;">>> linked on Account.SalespersonID1 = Employee.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on Account.SalespersonID1 = Employee.ID </​div></​html>​
  
-<​html><​div style="​margin-left:​ 40px;">>> linked on Account.SalespersonID2 = Employee.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on Account.SalespersonID2 = Employee.ID </​div></​html>​
  
-<​html><​div style="​margin-left:​ 40px;">>> linked on Account.SalespersonID3 = Employee.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on Account.SalespersonID3 = Employee.ID </​div></​html>​
  
   * AccountUserField   * AccountUserField
  
-<​html><​div style="​margin-left:​ 40px;">> linked on Account.ID = AccountUserField.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on Account.ID = AccountUserField.ID </​div></​html>​
  
   * Address   * Address
  
-<​html><​div style="​margin-left:​ 40px;">> linked on AccountContact.BillingAddressID = Address.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on AccountContact.BillingAddressID = Address.ID </​div></​html>​
  
-<​html><​div style="​margin-left:​ 40px;">> linked on AccountContact.ShippingAddressID = Address.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on AccountContact.ShippingAddressID = Address.ID </​div></​html>​
  
   * AddressLink   * AddressLink
  
-<​html><​div style="​margin-left:​ 40px;">> linked on Account.ID = AddressLink.ParentID and Account.ClassTypeID = AddressLink.ParentClassTypeID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on Account.ID = AddressLink.ParentID and Account.ClassTypeID = AddressLink.ParentClassTypeID </​div></​html>​
  
   * Address   * Address
  
-<​html><​div style="​margin-left:​ 40px;">>> linked on AddressLink.AddressID = Address.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on AddressLink.AddressID = Address.ID </​div></​html>​
  
   * PhoneNumber   * PhoneNumber
  
-<​html><​div style="​margin-left:​ 40px;">> linked on Account.MainPhoneNumberID = PhoneNumber.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on Account.MainPhoneNumberID = PhoneNumber.ID </​div></​html>​
  
-<​html><​div style="​margin-left:​ 40px;">> linked on Account.MainFaxNumberID = PhoneNumber.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on Account.MainFaxNumberID = PhoneNumber.ID </​div></​html>​
  
   * PricingLevel   * PricingLevel
  
-<​html><​div style="​margin-left:​ 40px;">> linked on Account.PricingLevelID = PricingLevel.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on Account.PricingLevelID = PricingLevel.ID </​div></​html>​
  
   * Promotion   * Promotion
  
-<​html><​div style="​margin-left:​ 40px;">> linked on Account.PromotionID = Promotion.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on Account.PromotionID = Promotion.ID </​div></​html>​
  
   * PaymentTerms   * PaymentTerms
  
-<​html><​div style="​margin-left:​ 40px;">> linked on Account.PaymentTermsID = PaymentTerm.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on Account.PaymentTermsID = PaymentTerm.ID </​div></​html>​
  
   * TaxClass   * TaxClass
  
-<​html><​div style="​margin-left:​ 40px;">> linked on Account.ClassTypeID = ClassType.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on Account.ClassTypeID = ClassType.ID </​div></​html>​
  
   * Employee   * Employee
  
-<​html><​div style="​margin-left:​ 40px;">> linked on Account.SalespersonID1 = Employee.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on Account.SalespersonID1 = Employee.ID </​div></​html>​
  
-<​html><​div style="​margin-left:​ 40px;">> linked on Account.SalespersonID2 = Employee.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on Account.SalespersonID2 = Employee.ID </​div></​html>​
  
-<​html><​div style="​margin-left:​ 40px;">> linked on Account.SalespersonID3 = Employee.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on Account.SalespersonID3 = Employee.ID </​div></​html>​
  
   * Account (self-reference for parent/​subsidiaries)   * Account (self-reference for parent/​subsidiaries)
  
-<​html><​div style="​margin-left:​ 40px;">> linked on Account.ParentID = Account.ID </​div></​html>​+<​html><​div style="​margin-left:​ 40px;">​ linked on Account.ParentID = Account.ID </​div></​html>​
  
-=Source=+==== Source ​====
  
 Contributor:​ Cyrious Contributor:​ Cyrious