Exigo Sync ERD List
Introduction¶
Page 1
4/15/2025 11:29 AM
Untitled
Dependency List
This report includes visible dependencies for all objects in the project.
Objects and dependencies that are not visible are not included.
backoffice.ActiveCustomers (Table)
ERDExample
No dependencies
backoffice.ActiveStatuses (Table)
ERDExample
No dependencies
backoffice.Assets (Table)
ERDExample
Used By
backoffice.CorporateContacts (Table)
backoffice.Navigation (Table)
backoffice.PageTabs (Table)
Uses
backoffice.AssetTypes (Table)
backoffice.AssetTypes (Table)
ERDExample
Used By
backoffice.Assets (Table)
backoffice.Branding (Table)
ERDExample
No dependencies
backoffice.Cache (Table)
ERDExample
No dependencies
Section 2¶
Page 2
4/15/2025 11:29 AM
backoffice.CalendarEventPrivacyTypes (Table)
ERDExample
Used By
backoffice.CalendarEvents (Table)
backoffice.CalendarEvents (Table)
ERDExample
Uses
backoffice.CalendarEventPrivacyTypes (Table)
backoffice.CalendarEventTypes (Table)
ERDExample
No dependencies
backoffice.Calendars (Table)
ERDExample
Used By
backoffice.CalendarSubscriptions (Table)
Uses
backoffice.CalendarTypes (Table)
backoffice.CalendarSettings (Table)
ERDExample
No dependencies
backoffice.CalendarSubscriptions (Table)
ERDExample
Uses
backoffice.Calendars (Table)
backoffice.CalendarTypes (Table)
ERDExample
Used By
backoffice.Calendars (Table)
Section 3¶
Page 3
4/15/2025 11:29 AM
backoffice.Colors (Table)
ERDExample
No dependencies
backoffice.CompanySocialNetworks (Table)
ERDExample
No dependencies
backoffice.CompanyWidgets (Table)
ERDExample
No dependencies
backoffice.ConversationParticipants (Table)
ERDExample
No dependencies
backoffice.Conversations (Table)
ERDExample
No dependencies
backoffice.CorporateContacts (Table)
ERDExample
Uses
backoffice.Assets (Table)
backoffice.CustomerSettings (Table)
ERDExample
No dependencies
backoffice.Environments (Table)
ERDExample
No dependencies
Section 4¶
Page 4
4/15/2025 11:29 AM
backoffice.GeneralSettings (Table)
ERDExample
No dependencies
backoffice.Images (Table)
ERDExample
Uses
backoffice.ImageTypes (Table)
backoffice.ImageTypes (Table)
ERDExample
Used By
backoffice.Images (Table)
backoffice.Markets (Table)
ERDExample
No dependencies
backoffice.Messages (Table)
ERDExample
No dependencies
backoffice.MetricDisplayTypes (Table)
ERDExample
No dependencies
backoffice.MetricMappedValues (Table)
ERDExample
Uses
backoffice.Metrics (Table)
backoffice.Metrics (Table)
ERDExample
Used By
backoffice.MetricMappedValues (Table)
Section 5¶
Page 5
4/15/2025 11:29 AM
backoffice.MetricWidgets (Table)
ERDExample
No dependencies
backoffice.MFAToken (Table)
ERDExample
Uses
backoffice.MFATokenDeliveryTy (Table)
backoffice.MFATokenDeliveryType (Table)
backoffice.MFATokenDeliveryTy (Table)
ERDExample
Used By
backoffice.MFAToken (Table)
backoffice.MFATokenDeliveryType (Table)
ERDExample
Used By
backoffice.MFAToken (Table)
backoffice.MFATokenValidationAttemptLog (Table)
ERDExample
No dependencies
backoffice.NavIcons (Table)
ERDExample
Used By
backoffice.NavigationFolders (Table)
backoffice.Navigation (Table)
ERDExample
Uses
backoffice.Assets (Table)
Section 6¶
Page 6
4/15/2025 11:29 AM
backoffice.NavigationFolders (Table)
ERDExample
Uses
backoffice.NavIcons (Table)
backoffice.NavigationLinks (Table)
ERDExample
No dependencies
backoffice.Pages (Table)
ERDExample
No dependencies
backoffice.PageTabs (Table)
ERDExample
Uses
backoffice.Assets (Table)
backoffice.PageWidgets (Table)
ERDExample
No dependencies
backoffice.PartyHostCustomerTypes (Table)
ERDExample
No dependencies
backoffice.PartyKpiRewards (Table)
ERDExample
No dependencies
backoffice.PartyKpis (Table)
ERDExample
Uses
backoffice.PartyKpiTemplates (Table)
Section 7¶
Page 7
4/15/2025 11:29 AM
backoffice.PartyKpiTemplates (Table)
ERDExample
Used By
backoffice.PartyKpis (Table)
backoffice.PartySettings (Table)
ERDExample
No dependencies
backoffice.ResourceBlobs (Table)
ERDExample
No dependencies
backoffice.Resources (Table)
ERDExample
No dependencies
backoffice.ShoppingCarts (Table)
ERDExample
No dependencies
backoffice.SilentLoginKeys (Table)
ERDExample
No dependencies
backoffice.SilentLogins (Table)
ERDExample
No dependencies
backoffice.SqlDataGridComplexFilters (Table)
ERDExample
No dependencies
Section 8¶
Page 8
4/15/2025 11:29 AM
backoffice.SqlDataGridFilterTypes (Table)
ERDExample
No dependencies
backoffice.SqlDataGrids (Table)
ERDExample
Uses
backoffice.SqlDataGridTypes (Table)
backoffice.SqlDataGridTypes (Table)
ERDExample
Used By
backoffice.SqlDataGrids (Table)
backoffice.SystemWidgets (Table)
ERDExample
No dependencies
backoffice.SystemWidgetTabMetrics (Table)
ERDExample
No dependencies
backoffice.SystemWidgetTabs (Table)
ERDExample
No dependencies
backoffice.TeamDashboardTypes (Table)
ERDExample
No dependencies
backoffice.TrainingCoursePreRequisites (Table)
ERDExample
Uses
backoffice.TrainingCourses (Table)
Section 9¶
Page 9
4/15/2025 11:29 AM
backoffice.TrainingCourses (Table)
ERDExample
Used By
backoffice.TrainingCoursePreRequisites (Table)
backoffice.TrainingCourseSteps (Table)
backoffice.TrainingCourseSubscribers (Table)
backoffice.TrainingCourseSteps (Table)
ERDExample
Used By
backoffice.TrainingCourseSubscribers (Table)
backoffice.TrainingCourseTasks (Table)
Uses
backoffice.TrainingCourses (Table)
backoffice.TrainingCourseSubscribers (Table)
ERDExample
Uses
backoffice.TrainingCourses (Table)
backoffice.TrainingCourseSteps (Table)
backoffice.TrainingCourseTasks (Table)
backoffice.TrainingCourseTasks (Table)
ERDExample
Used By
backoffice.TrainingCourseSubscribers (Table)
Uses
backoffice.TrainingCourseSteps (Table)
backoffice.Trees (Table)
ERDExample
No dependencies
backoffice.TreeViewerSettings (Table)
ERDExample
No dependencies
Section 10¶
Page 10
4/15/2025 11:29 AM
dbo.AuthenticateCustomer (Stored Procedure)
ERDExample
Uses
dbo.GetLocalDate (Function)
dbo.Customers (Table)
dbo.CustomerTempAuthRequests (Table)
dbo.AutoOrderChangeLog (Table)
ERDExample
Uses
dbo.AutoOrders (Table)
dbo.AutoOrderChargeLog (Table)
ERDExample
Uses
dbo.Currencies (Table)
dbo.Orders (Table)
dbo.Warehouses (Table)
dbo.AutoOrderDetails (Table)
ERDExample
Uses
dbo.AutoOrders (Table)
dbo.Items (Table)
dbo.AutoOrderPaymentTypes (Table)
ERDExample
Used By
dbo.AutoOrders (Table)
dbo.AutoOrderProcessTypes (Table)
ERDExample
Used By
dbo.AutoOrders (Table)
Section 11¶
Page 11
4/15/2025 11:29 AM
dbo.AutoOrders (Table)
ERDExample
Used By
dbo.AutoOrderChangeLog (Table)
dbo.AutoOrderDetails (Table)
dbo.AutoOrderSchedules (Table)
dbo.AutoOrderStatusChangeLog (Table)
dbo.Orders (Table)
Uses
dbo.AutoOrderPaymentTypes (Table)
dbo.AutoOrderProcessTypes (Table)
dbo.AutoOrderStatuses (Table)
dbo.Currencies (Table)
dbo.Customers (Table)
dbo.FrequencyTypes (Table)
dbo.ShipMethods (Table)
dbo.Warehouses (Table)
dbo.AutoOrderSchedules (Table)
ERDExample
Uses
dbo.AutoOrders (Table)
dbo.AutoOrderStatusChangeLog (Table)
ERDExample
Uses
dbo.AutoOrders (Table)
dbo.AutoOrderStatuses (Table)
dbo.AutoOrderStatuses (Table)
ERDExample
Used By
dbo.AutoOrders (Table)
dbo.AutoOrderStatusChangeLog (Table)
Section 12¶
Page 12
4/15/2025 11:29 AM
dbo.Bills (Table)
ERDExample
Used By
dbo.PayoutBills (Table)
Uses
dbo.BillStatuses (Table)
dbo.BillTypes (Table)
dbo.CommissionRuns (Table)
dbo.Customers (Table)
dbo.BillStatuses (Table)
ERDExample
Used By
dbo.Bills (Table)
dbo.BillTypes (Table)
ERDExample
Used By
dbo.Bills (Table)
dbo.BinaryDownline (View)
ERDExample
Uses
dbo.BinaryTree (Table)
dbo.BinaryPlacementTypes (Table)
ERDExample
Used By
dbo.Customers (Table)
dbo.BinaryTree (Table)
ERDExample
Used By
dbo.BinaryDownline (View)
dbo.BinaryUpline (View)
Section 13¶
Page 13
4/15/2025 11:29 AM
dbo.BinaryUpline (View)
ERDExample
Uses
dbo.BinaryTree (Table)
dbo.Bonuses (Table)
ERDExample
Used By
dbo.CommissionBonuses (Table)
dbo.CommissionDetails (Table)
Uses
dbo.PeriodTypes (Table)
dbo.Broadcasts (Table)
ERDExample
Used By
dbo.EmailOutLog (Table)
dbo.SmsMessages (Table)
Uses
dbo.BroadcastTypes (Table)
dbo.BroadcastTypes (Table)
ERDExample
Used By
dbo.Broadcasts (Table)
dbo.CodedRanks (Table)
ERDExample
Uses
dbo.CodingTypes (Table)
dbo.Customers (Table)
dbo.Ranks (Table)
dbo.CodingTypes (Table)
ERDExample
Used By
dbo.CodedRanks (Table)
Section 14¶
Page 14
4/15/2025 11:29 AM
dbo.CommandLog (Table)
ERDExample
No dependencies
dbo.CommissionBinaryTree (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.CommissionBonuses (Table)
ERDExample
Uses
dbo.Bonuses (Table)
dbo.CommissionRuns (Table)
dbo.Customers (Table)
dbo.CommissionCurrentExchangeRates (Table)
ERDExample
Uses
dbo.Currencies (Table)
dbo.CommissionCustomers (Table)
ERDExample
Uses
dbo.CommissionRuns (Table)
dbo.Customers (Table)
dbo.Ranks (Table)
dbo.CommissionDetails (Table)
ERDExample
Uses
dbo.Bonuses (Table)
dbo.CommissionRuns (Table)
dbo.Currencies (Table)
dbo.Customers (Table)
Section 15¶
Page 15
4/15/2025 11:29 AM
dbo.CommissionEnrollerTree (Table)
ERDExample
Uses
dbo.CommissionRuns (Table)
dbo.Customers (Table)
dbo.CommissionExchangeRates (Table)
ERDExample
Uses
dbo.CommissionRuns (Table)
dbo.Currencies (Table)
dbo.CommissionOverrides (Table)
ERDExample
Uses
dbo.CommissionRuns (Table)
dbo.Customers (Table)
dbo.CommissionRankGroups (Table)
ERDExample
Uses
dbo.CommissionRuns (Table)
dbo.Customers (Table)
dbo.Ranks (Table)
dbo.CommissionRuns (Table)
ERDExample
Used By
dbo.Bills (Table)
dbo.CommissionBonuses (Table)
dbo.CommissionCustomers (Table)
dbo.CommissionDetails (Table)
dbo.CommissionEnrollerTree (Table)
dbo.CommissionExchangeRates (Table)
dbo.CommissionOverrides (Table)
dbo.CommissionRankGroups (Table)
dbo.Commissions (Table)
Uses
dbo.CommissionRunStatuses (Table)
Section 16¶
Page 16
4/15/2025 11:29 AM
dbo.CommissionRunStatuses (Table)
ERDExample
Used By
dbo.CommissionRuns (Table)
dbo.Commissions (Table)
ERDExample
Uses
dbo.CommissionRuns (Table)
dbo.Currencies (Table)
dbo.Customers (Table)
dbo.CommissionUniLevelTree (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.CommissionVolumes (Table)
ERDExample
Uses
dbo.CommissionVolumeTypes (Table)
dbo.Customers (Table)
dbo.CommissionVolumeTypes (Table)
ERDExample
Used By
dbo.CommissionVolumes (Table)
dbo.Company (Table)
ERDExample
No dependencies
dbo.CompanyNews (Table)
ERDExample
No dependencies
Section 17¶
Page 17
4/15/2025 11:29 AM
dbo.CompanyNewsDepartments (Table)
ERDExample
No dependencies
dbo.Countries (Table)
ERDExample
Used By
dbo.CountryRegions (Table)
dbo.CountryRegions (Table)
ERDExample
Used By
dbo.ItemCountryRegions (Table)
Uses
dbo.Countries (Table)
dbo.CreditCardTypes (Table)
ERDExample
Used By
dbo.CustomerAccounts (Table)
dbo.Payments (Table)
Section 18¶
Page 18
4/15/2025 11:29 AM
dbo.Currencies (Table)
ERDExample
Used By
dbo.AutoOrderChargeLog (Table)
dbo.AutoOrders (Table)
dbo.CommissionCurrentExchangeRates (Table)
dbo.CommissionDetails (Table)
dbo.CommissionExchangeRates (Table)
dbo.Commissions (Table)
dbo.CustomerAdjustments (Table)
dbo.Customers (Table)
dbo.ExpectedPayments (Table)
dbo.ItemPrices (Table)
dbo.MerchantDeclineLog (Table)
dbo.Orders (Table)
dbo.Payments (Table)
dbo.PointAccounts (Table)
dbo.ShipRates (Table)
dbo.WarehouseCurrencies (Table)
dbo.CustomerAccountChangeLog (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.CustomerAccounts (Table)
ERDExample
Uses
dbo.CreditCardTypes (Table)
dbo.Customers (Table)
dbo.WalletTypes (Table)
dbo.CustomerAdjustments (Table)
ERDExample
Used By
dbo.CustomerTransactions (View)
Uses
dbo.Currencies (Table)
dbo.Customers (Table)
dbo.CustomerTransactionTypes (Table)
Section 19¶
Page 19
4/15/2025 11:29 AM
dbo.CustomerChangeLog (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.CustomerContacts (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.CustomerEventHistory (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.CustomerEvents (Table)
ERDExample
No dependencies
dbo.CustomerExtendedChangeLogs (Table)
ERDExample
Uses
dbo.CustomerExtendedGroups (Table)
dbo.CustomerExtendedDetails (Table)
ERDExample
Uses
dbo.CustomerExtendedGroups (Table)
dbo.Customers (Table)
dbo.CustomerExtendedGroups (Table)
ERDExample
Used By
dbo.CustomerExtendedChangeLogs (Table)
dbo.CustomerExtendedDetails (Table)
Section 20¶
Page 20
4/15/2025 11:29 AM
dbo.CustomerFieldNames (Table)
ERDExample
No dependencies
dbo.CustomerInquiries (Table)
ERDExample
Uses
dbo.CustomerInquiryCategories (Table)
dbo.CustomerInquiryStatuses (Table)
dbo.CustomerInquiryTypes (Table)
dbo.Customers (Table)
dbo.CustomerInquiryCategories (Table)
ERDExample
Used By
dbo.CustomerInquiries (Table)
dbo.CustomerInquiryStatuses (Table)
ERDExample
Used By
dbo.CustomerInquiries (Table)
dbo.CustomerInquiryTypes (Table)
ERDExample
Used By
dbo.CustomerInquiries (Table)
dbo.CustomerLeads (Table)
ERDExample
Uses
dbo.Customers (Table)
Section 21¶
Page 21
4/15/2025 11:29 AM
dbo.CustomerOverrides (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.Overrides (Table)
dbo.PeriodTypes (Table)
dbo.CustomerPayoutSettings (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.TaxAddressTypes (Table)
dbo.TaxNameTypes (Table)
dbo.CustomerPointAccounts (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.CustomerRankChangeLog (Table)
ERDExample
Uses
dbo.Customers (Table)
Section 22¶
Page 22
4/15/2025 11:29 AM
dbo.Customers (Table)
ERDExample
Used By
dbo.AuthenticateCustomer (Stored Procedure)
dbo.AutoOrders (Table)
dbo.Bills (Table)
dbo.CodedRanks (Table)
dbo.CommissionBinaryTree (Table)
dbo.CommissionBonuses (Table)
dbo.CommissionCustomers (Table)
dbo.CommissionDetails (Table)
dbo.CommissionEnrollerTree (Table)
dbo.CommissionOverrides (Table)
dbo.CommissionRankGroups (Table)
dbo.Commissions (Table)
dbo.CommissionUniLevelTree (Table)
dbo.CommissionVolumes (Table)
dbo.CustomerAccountChangeLog (Table)
dbo.CustomerAccounts (Table)
dbo.CustomerAdjustments (Table)
dbo.CustomerChangeLog (Table)
dbo.CustomerContacts (Table)
dbo.CustomerEventHistory (Table)
dbo.CustomerExtendedDetails (Table)
dbo.CustomerInquiries (Table)
dbo.CustomerLeads (Table)
dbo.CustomerOverrides (Table)
dbo.CustomerPayoutSettings (Table)
dbo.CustomerPointAccounts (Table)
dbo.CustomerRankChangeLog (Table)
dbo.CustomerSiteChangeLog (Table)
dbo.CustomerSites (Table)
dbo.CustomerSocialNetworks (Table)
dbo.CustomerStatusChangeLog (Table)
dbo.CustomerSubscriptions (Table)
dbo.CustomerTempAuthRequests (Table)
dbo.CustomerTypeChangeLog (Table)
dbo.CustomerWall (Table)
dbo.EmailOutLog (Table)
dbo.EnrollerTreeHistory (Table)
dbo.ExpectedRetailPayments (Table)
dbo.Guests (Table)
dbo.MerchantDeclineLog (Table)
dbo.Orders (Table)
dbo.Parties (Table)
dbo.PartyGuests (Table)
dbo.PaymentCards (Table)
dbo.Payments (Table)
Section 23¶
Page 23
4/15/2025 11:29 AM
dbo.Payouts (Table)
dbo.PeriodRankScores (Table)
dbo.PeriodVolumes (Table)
dbo.SmsMessages (Table)
dbo.UnilevelTreeHistory (Table)
Uses
dbo.BinaryPlacementTypes (Table)
dbo.Currencies (Table)
dbo.CustomerStatuses (Table)
dbo.CustomerTerminationReasons (Table)
dbo.CustomerTypes (Table)
dbo.Languages (Table)
dbo.PayableTypes (Table)
dbo.TaxCodeTypes (Table)
dbo.Warehouses (Table)
dbo.CustomerSiteChangeLog (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.CustomerSites (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.CustomerSocialNetworks (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.SocialNetworks (Table)
dbo.CustomerStatusChangeLog (Table)
ERDExample
Uses
dbo.Customers (Table)
Section 24¶
Page 24
4/15/2025 11:29 AM
dbo.CustomerStatuses (Table)
ERDExample
Used By
dbo.Customers (Table)
dbo.CustomerSubscriptions (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.Subscriptions (Table)
dbo.CustomerTempAuthRequests (Table)
ERDExample
Used By
dbo.AuthenticateCustomer (Stored Procedure)
Uses
dbo.Customers (Table)
dbo.CustomerTerminationReasons (Table)
ERDExample
Used By
dbo.Customers (Table)
dbo.CustomerTransactions (View)
ERDExample
Uses
dbo.CustomerAdjustments (Table)
dbo.Orders (Table)
dbo.Payments (Table)
dbo.CustomerTransactionTypes (Table)
ERDExample
Used By
dbo.CustomerAdjustments (Table)
Section 25¶
Page 25
4/15/2025 11:29 AM
dbo.CustomerTypeChangeLog (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.CustomerTypes (Table)
ERDExample
Used By
dbo.Customers (Table)
dbo.CustomerWall (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.Departments (Table)
ERDExample
Used By
dbo.Users (Table)
dbo.EmailOutLog (Table)
ERDExample
Uses
dbo.Broadcasts (Table)
dbo.Customers (Table)
dbo.EnrollerDownline (View)
ERDExample
Uses
dbo.EnrollerTree (Table)
dbo.EnrollerTree (Table)
ERDExample
Used By
dbo.EnrollerDownline (View)
dbo.EnrollerUpline (View)
Section 26¶
Page 26
4/15/2025 11:29 AM
dbo.EnrollerTreeHistory (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.EnrollerUpline (View)
ERDExample
Uses
dbo.EnrollerTree (Table)
dbo.ExpectedPaymentFieldNames (Table)
ERDExample
No dependencies
dbo.ExpectedPayments (Table)
ERDExample
Uses
dbo.Currencies (Table)
dbo.ExpectedPaymentStatusTypes (Table)
dbo.Orders (Table)
dbo.ExpectedPaymentStatusTypes (Table)
ERDExample
Used By
dbo.ExpectedPayments (Table)
dbo.ExpectedRetailPayments (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.FrequencyTypes (Table)
ERDExample
Used By
dbo.AutoOrders (Table)
Section 27¶
Page 27
4/15/2025 11:29 AM
dbo.GetLocalDate (Function)
ERDExample
Used By
FraudContext.FraudLogs (Table)
FraudContext.MerchantResponses (Table)
FraudContext.AciDeviceIDs (Table)
dbo.AuthenticateCustomer (Stored Procedure)
dbo.Guests (Table)
ERDExample
Used By
dbo.PartyGuests (Table)
Uses
dbo.Customers (Table)
dbo.GuestStatusTypes (Table)
dbo.Languages (Table)
dbo.GuestStatusTypes (Table)
ERDExample
Used By
dbo.Guests (Table)
dbo.ImageFiles (Table)
ERDExample
No dependencies
dbo.ItemChangeLog (Table)
ERDExample
Uses
dbo.Items (Table)
dbo.ItemCountryRegions (Table)
ERDExample
Uses
dbo.CountryRegions (Table)
dbo.Items (Table)
Section 28¶
Page 28
4/15/2025 11:29 AM
dbo.ItemDynamicKitCategories (Table)
ERDExample
Used By
dbo.ItemDynamicKitCategoryItemMembers (Table)
dbo.ItemDynamicKitCategoryMembers (Table)
dbo.ItemDynamicKitCategoryItemMembers (Table)
ERDExample
Uses
dbo.ItemDynamicKitCategories (Table)
dbo.Items (Table)
dbo.ItemDynamicKitCategoryMembers (Table)
ERDExample
Uses
dbo.ItemDynamicKitCategories (Table)
dbo.ItemFieldNames (Table)
ERDExample
No dependencies
dbo.ItemGroupMembers (Table)
ERDExample
Uses
dbo.Items (Table)
dbo.ItemImages (Table)
ERDExample
No dependencies
dbo.ItemLanguages (Table)
ERDExample
Uses
dbo.Items (Table)
dbo.Languages (Table)
Section 29¶
Page 29
4/15/2025 11:29 AM
dbo.ItemPointAccounts (Table)
ERDExample
Uses
dbo.Items (Table)
dbo.PointAccounts (Table)
dbo.ItemPrices (Table)
ERDExample
Uses
dbo.Currencies (Table)
dbo.Items (Table)
dbo.PriceTypes (Table)
dbo.Items (Table)
ERDExample
Used By
dbo.AutoOrderDetails (Table)
dbo.ItemChangeLog (Table)
dbo.ItemCountryRegions (Table)
dbo.ItemDynamicKitCategoryItemMembers (Table)
dbo.ItemGroupMembers (Table)
dbo.ItemLanguages (Table)
dbo.ItemPointAccounts (Table)
dbo.ItemPrices (Table)
dbo.ItemStaticKitMembers (Table)
dbo.ItemSubscriptions (Table)
dbo.ItemWarehouses (Table)
dbo.OrderDetails (Table)
dbo.WebCategoryItems (Table)
Uses
dbo.ItemTypes (Table)
dbo.ItemStaticKitMembers (Table)
ERDExample
Uses
dbo.Items (Table)
Section 30¶
Page 30
4/15/2025 11:29 AM
dbo.ItemSubscriptions (Table)
ERDExample
Uses
dbo.Items (Table)
dbo.Subscriptions (Table)
dbo.ItemTypes (Table)
ERDExample
Used By
dbo.Items (Table)
dbo.ItemWarehouses (Table)
ERDExample
Uses
dbo.Items (Table)
dbo.Warehouses (Table)
dbo.Languages (Table)
ERDExample
Used By
dbo.Customers (Table)
dbo.Guests (Table)
dbo.ItemLanguages (Table)
dbo.Parties (Table)
dbo.MerchantDeclineLog (Table)
ERDExample
Uses
dbo.Currencies (Table)
dbo.Customers (Table)
dbo.MerchantDeclineReasons (Table)
dbo.MerchantTypes (Table)
dbo.Orders (Table)
dbo.MerchantDeclineReasons (Table)
ERDExample
Used By
dbo.MerchantDeclineLog (Table)
Section 31¶
Page 31
4/15/2025 11:29 AM
dbo.MerchantTypes (Table)
ERDExample
Used By
dbo.MerchantDeclineLog (Table)
dbo.Payments (Table)
dbo.OrderBatches (Table)
ERDExample
Uses
dbo.Warehouses (Table)
dbo.OrderChangeLog (Table)
ERDExample
Uses
dbo.Orders (Table)
dbo.OrderDetails (Table)
ERDExample
Uses
dbo.Items (Table)
dbo.Orders (Table)
dbo.OrderFieldNames (Table)
ERDExample
No dependencies
Section 32¶
Page 32
4/15/2025 11:29 AM
dbo.Orders (Table)
ERDExample
Used By
dbo.AutoOrderChargeLog (Table)
dbo.ExpectedPayments (Table)
dbo.MerchantDeclineLog (Table)
dbo.OrderChangeLog (Table)
dbo.OrderDetails (Table)
dbo.CustomerTransactions (View)
dbo.OrderStatusChangeLog (Table)
dbo.Payments (Table)
Uses
dbo.AutoOrders (Table)
dbo.Currencies (Table)
dbo.Customers (Table)
dbo.OrderStatuses (Table)
dbo.OrderSubStatusTypes (Table)
dbo.OrderTypes (Table)
dbo.PriceTypes (Table)
dbo.ReplacementCategories (Table)
dbo.ReturnCategories (Table)
dbo.ShipMethods (Table)
dbo.Warehouses (Table)
dbo.OrderStatusChangeLog (Table)
ERDExample
Uses
dbo.Orders (Table)
dbo.OrderStatuses (Table)
dbo.OrderStatuses (Table)
ERDExample
Used By
dbo.Orders (Table)
dbo.OrderStatusChangeLog (Table)
dbo.OrderStatusOrderSubStatuses (Table)
dbo.OrderStatusOrderSubStatuses (Table)
ERDExample
Uses
dbo.OrderStatuses (Table)
dbo.OrderSubStatusTypes (Table)
Section 33¶
Page 33
4/15/2025 11:29 AM
dbo.OrderSubStatusTypes (Table)
ERDExample
Used By
dbo.Orders (Table)
dbo.OrderStatusOrderSubStatuses (Table)
dbo.OrderTypes (Table)
ERDExample
Used By
dbo.Orders (Table)
dbo.Overrides (Table)
ERDExample
Used By
dbo.CustomerOverrides (Table)
dbo.Parties (Table)
ERDExample
Used By
dbo.PartyGuests (Table)
Uses
dbo.Customers (Table)
dbo.Languages (Table)
dbo.PartyStatuses (Table)
dbo.PartyTypes (Table)
dbo.PartyGuests (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.Guests (Table)
dbo.Parties (Table)
dbo.PartyStatuses (Table)
ERDExample
Used By
dbo.Parties (Table)
Section 34¶
Page 34
4/15/2025 11:29 AM
dbo.PartyTypes (Table)
ERDExample
Used By
dbo.Parties (Table)
dbo.PayableTypes (Table)
ERDExample
Used By
dbo.Customers (Table)
dbo.PaymentCards (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.PaymentCardTypes (Table)
dbo.PaymentCardTypes (Table)
ERDExample
Used By
dbo.PaymentCards (Table)
dbo.Payments (Table)
ERDExample
Used By
dbo.CustomerTransactions (View)
Uses
dbo.CreditCardTypes (Table)
dbo.Currencies (Table)
dbo.Customers (Table)
dbo.MerchantTypes (Table)
dbo.Orders (Table)
dbo.PaymentTypes (Table)
dbo.WalletTypes (Table)
dbo.Warehouses (Table)
Section 35¶
Page 35
4/15/2025 11:29 AM
dbo.PaymentTypes (Table)
ERDExample
Used By
dbo.Payments (Table)
dbo.PayoutBills (Table)
ERDExample
Uses
dbo.Bills (Table)
dbo.Payouts (Table)
dbo.Payouts (Table)
ERDExample
Used By
dbo.PayoutBills (Table)
Uses
dbo.Customers (Table)
dbo.PayoutTypes (Table)
dbo.PayoutTypes (Table)
ERDExample
Used By
dbo.Payouts (Table)
dbo.PeriodRankScores (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.Periods (Table)
dbo.Ranks (Table)
dbo.Periods (Table)
ERDExample
Used By
dbo.PeriodRankScores (Table)
dbo.PeriodVolumes (Table)
Uses
dbo.PeriodTypes (Table)
Section 36¶
Page 36
4/15/2025 11:29 AM
dbo.PeriodTypes (Table)
ERDExample
Used By
dbo.Bonuses (Table)
dbo.CustomerOverrides (Table)
dbo.Periods (Table)
dbo.PeriodVolumes (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.Periods (Table)
dbo.Ranks (Table)
dbo.PointAccounts (Table)
ERDExample
Used By
dbo.ItemPointAccounts (Table)
dbo.PointTransactions (Table)
Uses
dbo.Currencies (Table)
dbo.PointTransactions (Table)
ERDExample
Uses
dbo.PointAccounts (Table)
dbo.PointTransactionTypes (Table)
dbo.PointTransactionTypes (Table)
ERDExample
Used By
dbo.PointTransactions (Table)
dbo.PriceTypes (Table)
ERDExample
Used By
dbo.ItemPrices (Table)
dbo.Orders (Table)
Section 37¶
Page 37
4/15/2025 11:29 AM
dbo.Ranks (Table)
ERDExample
Used By
dbo.CodedRanks (Table)
dbo.CommissionCustomers (Table)
dbo.CommissionRankGroups (Table)
dbo.PeriodRankScores (Table)
dbo.PeriodVolumes (Table)
dbo.ReplacementCategories (Table)
ERDExample
Used By
dbo.Orders (Table)
dbo.ReturnCategories (Table)
ERDExample
Used By
dbo.Orders (Table)
dbo.ShipCarriers (Table)
ERDExample
Used By
dbo.ShipMethods (Table)
dbo.ShipMethods (Table)
ERDExample
Used By
dbo.AutoOrders (Table)
dbo.Orders (Table)
dbo.ShipRates (Table)
Uses
dbo.ShipCarriers (Table)
dbo.ShipRates (Table)
ERDExample
Uses
dbo.Currencies (Table)
dbo.ShipMethods (Table)
Section 38¶
Page 38
4/15/2025 11:29 AM
dbo.SmsMessages (Table)
ERDExample
Uses
dbo.Broadcasts (Table)
dbo.Customers (Table)
dbo.SmsStatuses (Table)
dbo.SmsStatuses (Table)
ERDExample
Used By
dbo.SmsMessages (Table)
dbo.SocialNetworks (Table)
ERDExample
Used By
dbo.CustomerSocialNetworks (Table)
dbo.Subscriptions (Table)
ERDExample
Used By
dbo.CustomerSubscriptions (Table)
dbo.ItemSubscriptions (Table)
dbo.TaxAddressTypes (Table)
ERDExample
Used By
dbo.CustomerPayoutSettings (Table)
dbo.TaxCodeTypes (Table)
ERDExample
Used By
dbo.Customers (Table)
dbo.TaxNameTypes (Table)
ERDExample
Used By
dbo.CustomerPayoutSettings (Table)
Section 39¶
Page 39
4/15/2025 11:29 AM
dbo.UniLevelDownline (View)
ERDExample
Uses
dbo.UniLevelTree (Table)
dbo.UniLevelTree (Table)
ERDExample
Used By
dbo.UniLevelDownline (View)
dbo.UniLevelUpline (View)
dbo.UnilevelTreeHistory (Table)
ERDExample
Uses
dbo.Customers (Table)
dbo.UniLevelUpline (View)
ERDExample
Uses
dbo.UniLevelTree (Table)
dbo.Users (Table)
ERDExample
Uses
dbo.Departments (Table)
dbo.VolumePushCycleLogs (Table)
ERDExample
No dependencies
dbo.WalletTypes (Table)
ERDExample
Used By
dbo.CustomerAccounts (Table)
dbo.Payments (Table)
Section 40¶
Page 40
4/15/2025 11:29 AM
dbo.WarehouseCurrencies (Table)
ERDExample
Uses
dbo.Currencies (Table)
dbo.Warehouses (Table)
dbo.Warehouses (Table)
ERDExample
Used By
dbo.AutoOrderChargeLog (Table)
dbo.AutoOrders (Table)
dbo.Customers (Table)
dbo.ItemWarehouses (Table)
dbo.OrderBatches (Table)
dbo.Orders (Table)
dbo.Payments (Table)
dbo.WarehouseCurrencies (Table)
dbo.WebCategories (Table)
ERDExample
Used By
dbo.WebCategoryItems (Table)
dbo.WebCategoryItems (Table)
ERDExample
Uses
dbo.Items (Table)
dbo.WebCategories (Table)
ExigoOrderCalc.ZipCodes (Table)
ERDExample
No dependencies
ExigoWebContext.CalendarEventPrivacyTypes (Table)
ERDExample
No dependencies
Section 41¶
Page 41
4/15/2025 11:29 AM
ExigoWebContext.CalendarEvents (Table)
ERDExample
No dependencies
ExigoWebContext.CalendarEventTags (Table)
ERDExample
No dependencies
ExigoWebContext.CalendarEventTypes (Table)
ERDExample
No dependencies
ExigoWebContext.CalendarMarketLanguages (Table)
ERDExample
No dependencies
ExigoWebContext.Calendars (Table)
ERDExample
No dependencies
ExigoWebContext.CalendarSpeakers (Table)
ERDExample
No dependencies
ExigoWebContext.CalendarSubscriptions (Table)
ERDExample
No dependencies
ExigoWebContext.CalendarTypes (Table)
ERDExample
No dependencies
Section 42¶
Page 42
4/15/2025 11:29 AM
ExigoWebContext.CompatibleVersions (Table)
ERDExample
No dependencies
ExigoWebContext.ContentEnvironments (Table)
ERDExample
No dependencies
ExigoWebContext.ContentItems (Table)
ERDExample
No dependencies
ExigoWebContext.ContentSites (Table)
ERDExample
No dependencies
ExigoWebContext.CustomSortNodePositions (Table)
ERDExample
No dependencies
ExigoWebContext.CustomSortNodes (Table)
ERDExample
No dependencies
ExigoWebContext.ImageFiles (Table)
ERDExample
No dependencies
ExigoWebContext.Logs (Table)
ERDExample
No dependencies
Section 43¶
Page 43
4/15/2025 11:29 AM
ExigoWebContext.ResourceAvailabilities (Table)
ERDExample
No dependencies
ExigoWebContext.ResourceCategories (Table)
ERDExample
No dependencies
ExigoWebContext.ResourceCategoryItems (Table)
ERDExample
No dependencies
ExigoWebContext.ResourceItems (Table)
ERDExample
No dependencies
ExigoWebContext.ResourceItemTags (Table)
ERDExample
No dependencies
ExigoWebContext.ResourceStatuses (Table)
ERDExample
No dependencies
ExigoWebContext.ResourceTranslatedCategoryItems (Table)
ERDExample
No dependencies
ExigoWebContext.ResourceTypes (Table)
ERDExample
No dependencies
Section 44¶
Page 44
4/15/2025 11:29 AM
ExigoWebContext.Tags (Table)
ERDExample
No dependencies
FraudContext.AciDeviceIDs (Table)
ERDExample
Uses
dbo.GetLocalDate (Function)
FraudContext.FraudLogs (Table)
ERDExample
Uses
dbo.GetLocalDate (Function)
FraudContext.MerchantResponses (Table)
ERDExample
Uses
dbo.GetLocalDate (Function)