Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision 		Previous revision
Last revision Both sides next revision
account_schema [2019/01/29 10:58]
kcifreo 		account_schema [2019/01/30 11:57]
kcifreo
Line 6: Line 6:
       * AccountContact       * AccountContact
  
-linked on Account.ID = AccountContact.AccountID+<html><div style="margin-left: 40px;"> linked on Account.ID = AccountContact.AccountID </div></html>
  
-backlink on Account.PrimaryContactID = AccountContact.ID+<html><div style="margin-left: 40px;"> backlink on Account.PrimaryContactID = AccountContact.ID </div></html>
  
-backlink on Account.BillingContactID = AccountContact.ID+<html><div style="margin-left: 40px;"> backlink on Account.BillingContactID = AccountContact.ID </div></html>
  
   * AccountContactUserField   * AccountContactUserField
  
-linked on AccountContact.ID = AccountContactUserField.ID+<html><div style="margin-left: 40px;">>> linked on AccountContact.ID = AccountContactUserField.ID </div></html>
  
   * Address   * Address
  
-linked on AccountContact.BillingAddressID = Address.ID+<html><div style="margin-left: 40px;">>> linked on AccountContact.BillingAddressID = Address.ID </div></html>
  
-linked on AccountContact.ShippingAddressID = Address.ID+<html><div style="margin-left: 40px;">>> linked on AccountContact.ShippingAddressID = Address.ID </div></html>
  
   * AddressLink   * AddressLink
  
-linked on AccountContact.ID = AddressLink.ParentID and AccountContact.ClassTypeID = AddressLink.ParentClassTypeID+<html><div style="margin-left: 40px;">>> linked on AccountContact.ID = AddressLink.ParentID and AccountContact.ClassTypeID = AddressLink.ParentClassTypeID </div></html>
  
   * Address   * Address
  
-linked on AddressLink.AddressID = Address.ID+<html><div style="margin-left: 40px;">>>> linked on AddressLink.AddressID = Address.ID </div></html>
  
   * PhoneNumber   * PhoneNumber
  
-linked on AccountContact.MainPhoneNumberID = PhoneNumber.ID+<html><div style="margin-left: 40px;">>> linked on AccountContact.MainPhoneNumberID = PhoneNumber.ID </div></html>
  
-linked on AccountContact.MainFaxNumberID = PhoneNumber.ID+<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)
  
-linked on Account.SalespersonID1 = Employee.ID+<html><div style="margin-left: 40px;">>> linked on Account.SalespersonID1 = Employee.ID </div></html>
  
-linked on Account.SalespersonID2 = Employee.ID+<html><div style="margin-left: 40px;">>> linked on Account.SalespersonID2 = Employee.ID </div></html>
  
-linked on Account.SalespersonID3 = Employee.ID+<html><div style="margin-left: 40px;">>> linked on Account.SalespersonID3 = Employee.ID </div></html>
  
   * AccountUserField   * AccountUserField
  
-linked on Account.ID = AccountUserField.ID+<html><div style="margin-left: 40px;">> linked on Account.ID = AccountUserField.ID </div></html>
  
   * Address   * Address
  
-linked on AccountContact.BillingAddressID = Address.ID+<html><div style="margin-left: 40px;">> linked on AccountContact.BillingAddressID = Address.ID </div></html>
  
-linked on AccountContact.ShippingAddressID = Address.ID+<html><div style="margin-left: 40px;">> linked on AccountContact.ShippingAddressID = Address.ID </div></html>
  
   * AddressLink   * AddressLink
  
-linked on Account.ID = AddressLink.ParentID and Account.ClassTypeID = AddressLink.ParentClassTypeID+<html><div style="margin-left: 40px;">> linked on Account.ID = AddressLink.ParentID and Account.ClassTypeID = AddressLink.ParentClassTypeID </div></html>
  
   * Address   * Address
  
-linked on AddressLink.AddressID = Address.ID+<html><div style="margin-left: 40px;">>> linked on AddressLink.AddressID = Address.ID </div></html>
  
   * PhoneNumber   * PhoneNumber
  
-linked on Account.MainPhoneNumberID = PhoneNumber.ID+<html><div style="margin-left: 40px;">> linked on Account.MainPhoneNumberID = PhoneNumber.ID </div></html>
  
-linked on Account.MainFaxNumberID = PhoneNumber.ID+<html><div style="margin-left: 40px;">> linked on Account.MainFaxNumberID = PhoneNumber.ID </div></html>
  
   * PricingLevel   * PricingLevel
  
-linked on Account.PricingLevelID = PricingLevel.ID+<html><div style="margin-left: 40px;">> linked on Account.PricingLevelID = PricingLevel.ID </div></html>
  
   * Promotion   * Promotion
  
-linked on Account.PromotionID = Promotion.ID+<html><div style="margin-left: 40px;">> linked on Account.PromotionID = Promotion.ID </div></html>
  
   * PaymentTerms   * PaymentTerms
  
-linked on Account.PaymentTermsID = PaymentTerm.ID+<html><div style="margin-left: 40px;">> linked on Account.PaymentTermsID = PaymentTerm.ID </div></html>
  
   * TaxClass   * TaxClass
  
-linked on Account.ClassTypeID = ClassType.ID+<html><div style="margin-left: 40px;">> linked on Account.ClassTypeID = ClassType.ID </div></html>
  
   * Employee   * Employee
  
-linked on Account.SalespersonID1 = Employee.ID+<html><div style="margin-left: 40px;">> linked on Account.SalespersonID1 = Employee.ID </div></html>
  
-linked on Account.SalespersonID2 = Employee.ID+<html><div style="margin-left: 40px;">> linked on Account.SalespersonID2 = Employee.ID </div></html>
  
-linked on Account.SalespersonID3 = Employee.ID+<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)
  
-linked on Account.ParentID = Account.ID+<html><div style="margin-left: 40px;">> linked on Account.ParentID = Account.ID </div></html>
  
-==== Source ====+=Source=
  
 Contributor: Cyrious Contributor: Cyrious