=Description=



The Account Schema is the logical relationship between tables in a Control database that deal with Customers and Contacts.
  * Account 
    * AccountContact 



>>> linked on Account.ID = AccountContact.AccountID



>>> backlink on Account.PrimaryContactID = AccountContact.ID



>>> backlink on Account.BillingContactID = AccountContact.ID
      * AccountContactUserField



>>>> linked on AccountContact.ID = AccountContactUserField.ID
      * Address 



>>>> linked on AccountContact.BillingAddressID = Address.ID



>>>> linked on AccountContact.ShippingAddressID = Address.ID
      * AddressLink



>>>> linked on AccountContact.ID = AddressLink.ParentID and AccountContact.ClassTypeID = AddressLink.ParentClassTypeID
        * Address



>>>>> linked on AddressLink.AddressID = Address.ID
      * PhoneNumber 



>>>> linked on AccountContact.MainPhoneNumberID = PhoneNumber.ID



>>>> linked on AccountContact.MainFaxNumberID = PhoneNumber.ID
      * Employee (used when using separate sales people for contacts)



>>>> linked on Account.SalespersonID1 = Employee.ID



>>>> linked on Account.SalespersonID2 = Employee.ID



>>>> linked on Account.SalespersonID3 = Employee.ID
    * AccountUserField



>>> linked on Account.ID = AccountUserField.ID
    * Address 



>>> linked on AccountContact.BillingAddressID = Address.ID



>>> linked on AccountContact.ShippingAddressID = Address.ID
    * AddressLink



>>> linked on Account.ID = AddressLink.ParentID and Account.ClassTypeID = AddressLink.ParentClassTypeID
      * Address



>>>> linked on AddressLink.AddressID = Address.ID
    * PhoneNumber 



>>> linked on Account.MainPhoneNumberID = PhoneNumber.ID



>>> linked on Account.MainFaxNumberID = PhoneNumber.ID
    * PricingLevel



>>> linked on Account.PricingLevelID = PricingLevel.ID
    * Promotion



>>> linked on Account.PromotionID = Promotion.ID
    * PaymentTerms



>>> linked on Account.PaymentTermsID = PaymentTerm.ID
    * TaxClass



>>> linked on Account.ClassTypeID = ClassType.ID
    * Employee



>>> linked on Account.SalespersonID1 = Employee.ID



>>> linked on Account.SalespersonID2 = Employee.ID



>>> linked on Account.SalespersonID3 = Employee.ID
    * Account (self-reference for parent/subsidiaries)



>>> linked on Account.ParentID = Account.ID



=Source=



Contributor: Cyrious



Date: 6/2016



Version: Control 5/7



=See Also=
  * Backlinks [[include_pagepage_componentbacklinks]]