Exigo Sync ERD List¶
Introduction¶
Page 1
4/15/2025 11:29 AM
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
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)
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
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)
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)
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)
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
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)
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
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)
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)
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)
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)
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)
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)
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
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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
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)
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)
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)
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)
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)
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)
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)
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)
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
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
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
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
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)