| Both sides previous revision
Previous revision
|
|
account_schema [2019/01/30 11:57]
kcifreo |
account_schema [2019/01/30 11:59] (current)
kcifreo |
| * 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 |