Reporting Data Dictionary¶
Reporting Database¶
Database Properties Property Value SQL Server Version Azure Sql Database Compatibility Level Max Creation date 12/19/2024 9:36:19 PM Database Options Property Value Compatibility Level 160 Database collation SQL_Latin1_General_CP1_CI_AS Restrict access MULTI_USER Is read-only False Auto close False Auto shrink False Database status ONLINE In standby False Cleanly shutdown False Supplemental logging enabled False Snapshot isolation state ON Read committed snapshot on True Recovery model FULL Page verify option CHECKSUM Auto create statistics True Auto update statistics True Auto update statistics asynchronously False ANSI NULL default False ANSI NULL enabled False ANSI padding enabled False ANSI warnings enabled False Arithmetic abort enabled False Concatenating NULL yields NULL False Numeric roundabort enabled False Quoted Identifier On False Recursive triggers enabled False Close cursors on commit False
Local cursors by default False Fulltext enabled True Trustworthy False Database chaining False Forced parameterization False Master key encrypted by server False Published False Subscribed False Merge published False Is distribution database False Sync with backup False Service broker GUID 31e7c3cf-8dec-4b7c-b01a-e9270c4bf7d1 Service broker enabled False Date correlation False CDC enabled False Encrypted True Honor broker priority False Containment NONE Target recovery time 60
Tables¶
Tables¶
Objects¶
Name cache.Session Web session caching cache.Store Web shopping cart caching dbo.AutoOrderChangeLog Auto Order Template Change History dbo.AutoOrderChargeLog Payments Against Auto Orders dbo.AutoOrderDetails Auto Order Template Details dbo.AutoOrderPaymentTypes Auto Order Payment Type Reference Table dbo.AutoOrderProcessTypes Auto Order Process Type Reference Table dbo.AutoOrders Auto Order Templates dbo.AutoOrderSchedules Auto Order Schedules dbo.AutoOrderStatusChangeLog Auto Order Status Change History dbo.AutoOrderStatuses Auto Order Statuses Reference Table dbo.Bills Bills To Pay (Typically Commissions Bills) dbo.BillStatuses Bill Statuses Reference Table dbo.BillTypes Bill Types Reference Table dbo.BinaryPlacementTypes Binary Placement Types Reference Table dbo.BinaryTree Binary Tree (Memory Optimized Table) dbo.Bonuses Bonuses Reference Table dbo.Broadcasts Broadcasts (Emails or SMS) dbo.BroadcastTypes Broadcast Types Reference Table dbo.CodedRanks One Time Commissions Events dbo.CodingTypes Coded Ranks Coding Types dbo.CommandLog
Tables¶
Log Table for Maintenance Jobs dbo.CommissionBinaryTree Commission Binary Tree (Recommended To Use dbo.BinaryDownline or dbo.BinaryUpline Views Instead) dbo.CommissionBonuses Commission Bonuses dbo.CommissionCurrentExchangeRates Exchange Rate Defined By Client For Currency Codes Used In Paying Commissions dbo.CommissionCustomers Customer Rank Stats Per Accepted Commission Run dbo.CommissionDetails Details Per Commission Run dbo.CommissionEnrollerTree Commissions Enroller Tree dbo.CommissionExchangeRates Commission Exchange Rates History By Commission Run dbo.CommissionOverrides Commission Overrides dbo.CommissionRankGroups Rank Groups for Commissions dbo.CommissionRuns Commission Run Reference Table dbo.CommissionRunStatuses Commission Run Statuses Reference Table dbo.Commissions Commissions Calculated dbo.CommissionUniLevelTree Commissions Unilevel Tree dbo.CommissionVolumes Commission Volumes dbo.CommissionVolumeTypes Commission Volume Types Reference Table dbo.Company Your Company Key With Exigo dbo.CompanyNews Company News dbo.CompanyNewsDepartments Company News Departments dbo.Countries Countries dbo.CountryRegions Country Regions dbo.CreditCardTypes Credit Card Types dbo.Currencies Currencies (Allows Custom Currencies) dbo.CustomerAccountChangeLog Change Log for the dbo.CustomerAccounts Records dbo.CustomerAccounts Customer Payment Accounts dbo.CustomerAdjustments Customer Adjustments
Tables¶
dbo.CustomerChangeLog Log History For Changes in dbo.Customers dbo.CustomerContacts Customer Contact Info dbo.CustomerEventHistory Customer Event History dbo.CustomerEvents Reference Data Used For Auto Responders dbo.CustomerExtendedChangeLogs History of Customer Extended Group Changes dbo.CustomerExtendedDetails Fully Custom Fields For Customer Records dbo.CustomerExtendedGroups Fully Custom Fields For Customer Groups dbo.CustomerFieldNames Custom Display Names For Fields in dbo.Customers Table dbo.CustomerInquiries Customer Inquiries dbo.CustomerInquiryCategories Customer Inquiry Category Reference Table dbo.CustomerInquiryStatuses Customer Inquiry Status Reference Table dbo.CustomerInquiryTypes Customer Inquiry Type Reference Table dbo.CustomerLeads Customer Sales Leads dbo.CustomerOverrides Commissions Overrides Per Customer dbo.CustomerPayoutSettings Customer Payout Settings dbo.CustomerPointAccounts Customer Point Accounts dbo.CustomerRankChangeLog Customer Rank Change History dbo.Customers Customers dbo.CustomerSiteChangeLog dbo.CustomerSites Replicated Site Population Data dbo.CustomerSocialNetworks Customer Social Networks dbo.CustomerStatusChangeLog History of Customer Status Changes dbo.CustomerStatuses Customer Status Reference Table dbo.CustomerSubscriptions Customer Subscriptions dbo.CustomerTempAuthRequests
Local Authentication Caching Table dbo.CustomerTerminationReasons Customer Termination Reasons Reference Table
Tables¶
dbo.CustomerTransactionTypes Customer Transaction Types Reference Table dbo.CustomerTypeChangeLog History of Customer Type Changes dbo.CustomerTypes Customer Types Reference Table dbo.CustomerWall Downline Events dbo.Departments User Departments dbo.EmailOutLog Email Sent Logs dbo.EnrollerTree Enroller Tree (Memory Optimized Table) dbo.EnrollerTreeHistory History of Changes in Enroller Tree dbo.ExpectedPaymentFieldNames Expected Payment Field Names dbo.ExpectedPayments Expected Payments dbo.ExpectedPaymentStatusTypes Expected Payment Status Types dbo.ExpectedRetailPayments Expected Retail Payments dbo.FrequencyTypes Frequency Types dbo.Guests Party Guests dbo.GuestStatusTypes Guest Status Types dbo.ImageFiles Image Files (Binary) dbo.ItemChangeLog History of Item Changes dbo.ItemCountryRegions Tax Override by Item Per Country and Region dbo.ItemDynamicKitCategories Categories for Dynamic Item Kits dbo.ItemDynamicKitCategoryItemMembers Item Members in Dynamic Kit Categories dbo.ItemDynamicKitCategoryMembers Layout of Items and Quantity in Dynamic Kit dbo.ItemFieldNames Display Names for Customer Fields in dbo.Items Table dbo.ItemGroupMembers dbo.ItemImages Image Mapping for Items dbo.ItemLanguages Item Descriptions in Other Languages dbo.ItemPointAccounts Item Point Accounts
Tables¶
dbo.ItemPrices Item Prices dbo.Items Items dbo.ItemStaticKitMembers Static Kit Members dbo.ItemSubscriptions Item Subscriptions dbo.ItemTypes Item Types Reference Table dbo.ItemWarehouses Item Warehouses dbo.Languages Languages dbo.MerchantDeclineLog Merchant Decline Log dbo.MerchantDeclineReasons Merchant Decline Reasons Reference Table dbo.MerchantTypes Merchant Types dbo.OrderBatches
Order Batches dbo.OrderChangeLog History of Order Changes dbo.OrderDetails Order Details dbo.OrderFieldNames Display Names for Custom Fields in Orders Table dbo.Orders Orders dbo.OrderStatusChangeLog History of Order Status Changes dbo.OrderStatuses Order Status Reference Table dbo.OrderStatusOrderSubStatuses Order Status Order Sub Status Mapping Table dbo.OrderSubStatusTypes Order Sub Status Types dbo.OrderTypes Order Types Reference Table dbo.Overrides Overrides dbo.Parties Parties dbo.PartyGuests Party Guests dbo.PartyStatuses Party Statuses Reference Table dbo.PartyTypes Party Types Reference Table dbo.PayableTypes Payable Types
Tables¶
dbo.PaymentCards Payment Cards dbo.PaymentCardTypes Payment Card Types Reference Table dbo.Payments Payments dbo.PaymentTypes Payment Types dbo.PayoutBills Bills to be Paid Out dbo.Payouts Payouts dbo.PayoutTypes Payout Types dbo.PeriodRankScores Period Rank Scores dbo.Periods Periods dbo.PeriodTypes Period Types dbo.PeriodVolumes Period Volumes dbo.PointAccounts Point Accounts dbo.PointTransactions Point Transactions dbo.PointTransactionTypes Point Transaction Types dbo.PriceTypes Price Types dbo.Ranks Ranks dbo.ReplacementCategories Replacement Categories dbo.ReturnCategories Return Categories dbo.ShipCarriers Ship Carriers dbo.ShipMethods Ship Methods dbo.ShipRates Ship Rates dbo.SmsMessages SMS Messages dbo.SmsStatuses
SMS Statuses Reference Table dbo.SocialNetworks Social Networks Reference Table dbo.Subscriptions Subscriptions Reference Table dbo.TaxAddressTypes Tax Address Types Reference Table
Tables¶
dbo.TaxCodeTypes Tax Code Types Reference Table dbo.TaxNameTypes Tax Name Types Reference Table dbo.UniLevelTree Unilevel Tree (Memory Optimized Table) dbo.UnilevelTreeHistory History of Unilievel Tree Changes dbo.Users Users dbo.VolumePushCycleLogs Volume Push Cycle Logs dbo.WalletTypes Wallet Types dbo.WarehouseCurrencies Warehouse Currencies dbo.Warehouses Warehouses dbo.WebCategories Web Categories dbo.WebCategoryItems Web Category Items
Tables > cache.Session¶
[cache].[Session]¶
MS_Description Web session caching Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------- | ---------------- | ------------------ | ----------- | | SessionID | uniqueidentifier | 16 | NOT NULL | Unique ID | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Modified Date | Data | nvarchar(max) | max | NOT NULL | | ---- | ------------- | --- | -------- | Session Data Indexes | Key Name | Key Columns | Unique | Compression | | ---------- | ----------- | ------ | ----------- | | Session_PK | SessionID | True | PAGE | Uses [cache] Used By
[cache].[ExpireSessions]¶
[cache].[GetSession]¶
[cache].[SetSession]¶
Tables > cache.Store¶
[cache].[Store]¶
MS_Description Web shopping cart caching Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | ------------- | ------------------ | ----------- | | ID | nvarchar(850) | 1700 | NOT NULL | Unique ID | Data | nvarchar(max) | max | NULL allowed | | ---- | ------------- | --- | ------------ | Shopping Cart Data | CreatedDate | datetime | 8 | NOT NULL | | ----------- | -------- | --- | -------- | Record Create Date | SecondsToLive | bigint | 8 | NOT NULL | | ------------- | ------ | --- | -------- | Data Retention Indexes | Key Name | | Key Columns | Unique Compression | | ------------- | --- | ----------- | ------------------ | | PK_CacheStore | | ID | True PAGE | Uses [cache] Used By
[cache].[Get]¶
[cache].[Purge]¶
[cache].[Set]¶
Tables > dbo.AutoOrderChangeLog¶
[dbo].[AutoOrderChangeLog]¶
MS_Description Auto Order Template Change History Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------------------- | --------- | ------------------ | ----------- | | AutoOrderChangeLogID | int | 4 | NOT NULL | Unique ID - Not typically used anywhere | AutoOrderID | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | AutoOrderID - Map back to dbo.AutoOrders | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Change Date | ModifiedBy | nvarchar(50) | 100 | NOT NULL | | ---------- | ------------ | --- | -------- | Who Changed It | Detail | nvarchar(max) | max | NOT NULL | | ------ | ------------- | --- | -------- | From and To Values Indexes | Key Name | Key Columns | Unique | Compression | | --------------------- | ------------------- | ------ | ----------- | | PK_AutoOrderChangeLog | AutoOrderChangeLog- | True | PAGE | ID | IX_AutoOrderChangeLog_AutoOrderID | AutoOrderID | | PAGE | | --------------------------------- | ----------- | --- | ---- |
Tables > dbo.AutoOrderChargeLog¶
[dbo].[AutoOrderChargeLog]¶
MS_Description Payments Against Auto Orders Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | -------------------- | --------- | ------- | ----------- | | AutoOrderChargeLogID | int | 4 | NOT NULL | Unique ID - Not typically used anywhere | PaymentTypeID | int | 4 | NOT NULL | | ------------- | --- | --- | -------- | Payment Type - Map to dbo.PaymentTypes | WarehouseID | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Warehouse - Map to dbo.Warehouses | CurrencyCode | nvarchar(3) | 6 | NOT NULL | | ------------ | ----------- | --- | -------- | Currency Code of the Payment - Map to dbo.Currencies | OrderID | int | 4 | NOT NULL | | ------- | --- | --- | -------- | Order Reference - Map to dbo.Orders | Amount | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Payment Amount in Native Currency Code | EntryDate | datetime | 8 | NOT NULL | | --------- | -------- | --- | -------- | Payment Date | BatchID | int | 4 | NOT NULL | | ------- | --- | --- | -------- | Payment Batch | IsAuthorized | bit | 1 | NOT NULL | | ------------ | --- | --- | -------- | Authorization Boolean | ServerResponse | nvarchar(1000) | 2000 | NOT NULL | | -------------- | -------------- | ---- | -------- | Vendor Server Response | PaymentID | int | 4 | NULL allowed | | --------- | --- | --- | ------------ | Payment ID - Map to dbo.Payments Indexes | Key Name | Key Columns | Unique | Compression | | --------------------- | -------------------- | ------ | ----------- | | PK_AutoOrderChargeLog | AutoOrderChargeLogID | True | PAGE |
Tables > dbo.AutoOrderDetails¶
[dbo].[AutoOrderDetails]¶
MS_Description Auto Order Template Details Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------- | --------- | ------------------ | ----------- | | AutoOrderID | int | 4 | NOT NULL | Auto Order ID - Map to dbo.AutoOrders | OrderLine | int | 4 | NOT NULL | | --------- | --- | --- | -------- | Order Line - Map to dbo.OrderDetails | AutoOrderDetailID | uniqueidentifier | 16 | NULL allowed | | ----------------- | ---------------- | --- | ------------ | Unique ID | ParentAutoOrderDetailID | uniqueidentifier | 16 | NULL allowed | | ----------------------- | ---------------- | --- | ------------ | Unique ID for Parent | ItemID | int | 4 | NOT NULL | | ------ | --- | --- | -------- | Item ID - Map to dbo.Items | ItemCode | nvarchar(max) | max | NULL allowed | | -------- | ------------- | --- | ------------ | Item Code - Map to dbo.Items | ItemDescription | nvarchar(255) | 510 | NOT NULL | | --------------- | ------------- | --- | -------- | Item Description | Quantity | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Quantity on Auto Order | PriceEach | money | 8 | NOT NULL | | --------- | ----- | --- | -------- | Price Each for Item | PriceTotal | money | 8 | NOT NULL | | ---------- | ----- | --- | -------- | Quantity * PriceEach | BusinessVolumeEach | money | 8 | NOT NULL | | ------------------ | ----- | --- | -------- | BV Each for Item | BusinessVolume | money | 8 | NOT NULL | | -------------- | ----- | --- | -------- | Total BV | CommissionableVolumeEach | money | 8 | NOT NULL | | ------------------------ | ----- | --- | -------- | CV Each for Item | CommissionableVolume | money | 8 | NOT NULL | | -------------------- | ----- | --- | -------- | Total CV | PriceEachOverride | money | 8 | NULL allowed | | ----------------- | ----- | --- | ------------ | Price Each Override for Item | TaxableEachOverride | money | 8 | NULL allowed | | ------------------- | ----- | --- | ------------ | Taxable Override for Item | ShippingPriceEachOverride | money | 8 | NULL allowed | | ------------------------- | ----- | --- | ------------ | Shipping Override for Item | BusinessVolumeEachOverride | money | 8 | NULL allowed | | -------------------------- | ----- | --- | ------------ | BV Override for Item | CommissionableVolumeEachOverride | money | 8 | NULL allowed | | -------------------------------- | ----- | --- | ------------ | CV Override for Item | ParentItemID | int | 4 | NULL allowed | | ------------ | --- | --- | ------------ |
Tables > dbo.AutoOrderDetails¶
Parent Item ID - Map to dbo.Items | Reference1 | nvarchar(100) | 200 | NOT NULL | | ---------- | ------------- | --- | -------- | Custom Field | DetailStartDate | datetime | 8 | NULL allowed | | ----------------- | -------- | --- | ------------ | | DetailEndDate | datetime | 8 | NULL allowed | | DetailInterval | int | 4 | NULL allowed | | DetailNextRunDate | datetime | 8 | NULL allowed | Indexes | Key Name | Key Columns | | Unique Compression | | ------------------- | ---------------------- | --- | ------------------ | | PK_AutoOrderDetails | AutoOrderID, OrderLine | | True PAGE |
Tables > dbo.AutoOrderPaymentTypes¶
[dbo].[AutoOrderPaymentTypes]¶
MS_Description Auto Order Payment Type Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------------------- | --------- | ------------------ | ----------- | | AutoOrderPaymentTypeID | int | 4 | NOT NULL | Unique ID - Not Typically Used Anywhere | AutoOrderPaymentTypeDescription | nvarchar(50) | 100 | NOT NULL | | ------------------------------- | ------------ | --- | -------- | Payment Type Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------ | ---------------------- | ------ | ----------- | | PK_AutoOrderPaymentTypes | AutoOrderPaymentTypeID | True | PAGE |
Tables > dbo.AutoOrderProcessTypes¶
[dbo].[AutoOrderProcessTypes]¶
MS_Description Auto Order Process Type Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------------------- | --------- | ------------------ | ----------- | | AutoOrderProcessTypeID | int | 4 | NOT NULL | Unique ID - Typically Not Used Anywhere | AutoOrderProcessTypeDescription | nvarchar(50) | 100 | NOT NULL | | ------------------------------- | ------------ | --- | -------- | Process Type Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------ | ---------------------- | ------ | ----------- | | PK_AutoOrderProcessTypes | AutoOrderProcessTypeID | True | PAGE |
Tables > dbo.AutoOrders¶
[dbo].[AutoOrders]¶
MS_Description Auto Order Templates Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | ----------- | --------- | ------- | ----------- | | AutoOrderID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | AutoOrderStatusID | int | 4 | NOT NULL | | ----------------- | --- | --- | -------- | Auto Order Status ID - Map to dbo.AutoOrderStatuses | FrequencyTypeID | int | 4 | NOT NULL | | --------------- | --- | --- | -------- | Frequency Type ID - Map to dbo.FrequencyTypes | StartDate | datetime | 8 | NOT NULL | | --------- | -------- | --- | -------- | Auto Order Start Date | StopDate | datetime | 8 | NULL allowed | | -------- | -------- | --- | ------------ | Auto Order Stop Date | LastRunDate | datetime | 8 | NULL allowed | | ----------- | -------- | --- | ------------ | Last Auto Order Run Date | NextRunDate | datetime | 8 | NULL allowed | | ----------- | -------- | --- | ------------ | Next Auto Order Run Date | CancelledDate | datetime | 8 | NULL allowed | | ------------- | -------- | --- | ------------ | Cancel Date | CurrencyCode | nvarchar(3) | 6 | NOT NULL | | ------------ | ----------- | --- | -------- | Currency Code of Auto Order - Map to dbo.Currencies | WarehouseID | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Warehouse ID - Map to dbo.Warehouses | ShipMethodID | int | 4 | NOT NULL | | ------------ | --- | --- | -------- | Ship Method ID - Map to dbo.ShipMethods | AutoOrderPaymentTypeID | int | 4 | NOT NULL | | ---------------------- | --- | --- | -------- | Auto Order Payment Type ID - Map to dbo.AutoOrder- PaymentTypes | AutoOrderProcessTypeID | int | 4 | NOT NULL | | ---------------------- | --- | --- | -------- | Auto Order Process Type ID - Map to dbo.AutoOrderProcess- Types | FirstName | nvarchar(50) | 100 | NOT NULL | | --------- | ------------ | --- | -------- | Customer First Name | MiddleName | nvarchar(50) | 100 | NOT NULL | | ---------- | ------------ | --- | -------- | Customer Middle Name | LastName | nvarchar(50) | 100 | NOT NULL | | -------- | ------------ | --- | -------- | Customer Last Name | NameSuffix | nvarchar(50) | 100 | NOT NULL | | ---------- | ------------ | --- | -------- | Customer Name Suffix | Company | nvarchar(100) | 200 | NOT NULL | | ------- | ------------- | --- | -------- |
Tables > dbo.AutoOrders¶
Company Name | Address1 | nvarchar(100) | 200 | NOT NULL | | -------- | ------------- | --- | -------- | Order Address Line 1 | Address2 | nvarchar(100) | 200 | NOT NULL | | -------- | ------------- | --- | -------- | Order Address Line 2 | Address3 | nvarchar(100) | 200 | NOT NULL | | -------- | ------------- | --- | -------- | Order Address Line 3 | City | nvarchar(50) | 100 | NOT NULL | | ---- | ------------ | --- | -------- | Order City | State | nvarchar(50) | 100 | NOT NULL | | ----- | ------------ | --- | -------- | Order State | Zip | nvarchar(50) | 100 | NOT NULL | | --- | ------------ | --- | -------- | Order Zip Code | Country | nvarchar(50) | 100 | NOT NULL | | ------- | ------------ | --- | -------- | Order Country | County | nvarchar(50) | 100 | NOT NULL | | ------ | ------------ | --- | -------- | Order County | Email | nvarchar(200) | 400 | NOT NULL | | ----- | ------------- | --- | -------- | Customer Order Email | Phone | nvarchar(50) | 100 | NOT NULL | | ----- | ------------ | --- | -------- | Customer Order Phone | Notes | nvarchar(500) | 1000 | NOT NULL | | ----- | ------------- | ---- | -------- | Order Notes | Total | money | 8 | NOT NULL | | ----- | ----- | --- | -------- | Order Total in Native Currency Code | SubTotal | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Order SubTotal in Native Currency Code | TaxTotal | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Order TaxTotal in Native Currency Code | ShippingTotal | money | 8 | NOT NULL | | ------------- | ----- | --- | -------- | Order Shipping in Native Currency Code | DiscountTotal | money | 8 | NOT NULL | | ------------- | ----- | --- | -------- | Order Discount Total in Native Currency Code | BusinessVolumeTotal | money | 8 | NOT NULL | | ------------------- | ----- | --- | -------- | Order BV in Native Currency Code | CommissionableVolumeTotal | money | 8 | NOT NULL | | ------------------------- | ----- | --- | -------- | Order CV in Native Currency Code | AutoOrderDescription | nvarchar(100) | 200 | NOT NULL | | -------------------- | ------------- | --- | -------- | Order Description | Other11 | nvarchar(400) | 800 | NULL allowed | | ------- | ------------- | --- | ------------ | Custom Field | Other12 | nvarchar(400) | 800 | NULL allowed | | ------- | ------------- | --- | ------------ | Custom Field | Other13 | nvarchar(400) | 800 | NULL allowed | | ------- | ------------- | --- | ------------ | Custom Field | Other14 | nvarchar(400) | 800 | NULL allowed | | ------- | ------------- | --- | ------------ | Custom Field | Other15 | nvarchar(400) | 800 | NULL allowed | | ------- | ------------- | --- | ------------ | Custom Field | Other16 | nvarchar(400) | 800 | NULL allowed | | ------- | ------------- | --- | ------------ | Custom Field
Tables > dbo.AutoOrders¶
| Other17 | nvarchar(400) | 800 | NULL allowed |
|---|---|---|---|
| Custom Field | |||
| Other18 | nvarchar(400) | 800 | NULL allowed |
| ------- | ------------- | --- | ------------ |
| Custom Field | |||
| Other19 | nvarchar(400) | 800 | NULL allowed |
| ------- | ------------- | --- | ------------ |
| Custom Field | |||
| Other20 | nvarchar(400) | 800 | NULL allowed |
| ------- | ------------- | --- | ------------ |
| Custom Field | |||
| CreatedDate | datetime | 8 | NOT NULL |
| ----------- | -------- | --- | -------- |
| Auto Order Created Date | |||
| ModifiedDate | datetime | 8 | NOT NULL |
| ------------ | -------- | --- | -------- |
| Auto Order Last Modified Date | |||
| CreatedBy | nvarchar(30) | 60 | NOT NULL |
| --------- | ------------ | --- | -------- |
| Auto Order Created By Name | |||
| ModifiedBy | nvarchar(30) | 60 | NOT NULL |
| ---------- | ------------ | --- | -------- |
| Auto Order Last Modified By Name | |||
| Indexes | |||
| Key Name | Key Columns | Unique | Compression |
| ------------------------ | ----------- | ------ | ----------- |
| PK_AutoOrders | AutoOrderID | True | PAGE |
| IX_AutoOrders_CustomerID | CustomerID | PAGE |
Tables > dbo.AutoOrderSchedules¶
[dbo].[AutoOrderSchedules]¶
MS_Description Auto Order Schedules Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------- | --------- | ------------------ | ----------- | | AutoOrderID | int | 4 | NOT NULL | Auto Order ID - Map to dbo.AutoOrders | ScheduledDate | datetime | 8 | NOT NULL | | ------------- | -------- | --- | -------- | Auto Order Schedule Date | IsEnabled | bit | 1 | NOT NULL | | --------- | --- | --- | -------- | Is Schedule Enabled? | ProcessedDate | datetime | 8 | NULL allowed | | ------------- | -------- | --- | ------------ | Processed Date for Scheduled Date | OrderID | int | 4 | NULL allowed | | ------- | --- | --- | ------------ | OrderID of Auto Order - Map to dbo.Orders Indexes | Key Name | Key Columns | | Unique Compression | | --------------------- | ----------------------- | --- | ------------------ | | PK_AutoOrderSchedules | AutoOrderID, Scheduled- | | True PAGE | Date
Tables > dbo.AutoOrderStatusChangeLog¶
[dbo].[AutoOrderStatusChangeLog]¶
MS_Description Auto Order Status Change History Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------------------------- | --------- | ------------------ | ----------- | | AutoOrderStatusChangeLogID | int | 4 | NOT NULL | Unique ID - Typically not used anywhere | AutoOrderID | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Auto Order ID - Map to dbo.AutoOrders | AutoOrderStatusID | int | 4 | NOT NULL | | ----------------- | --- | --- | -------- | Auto Order Status ID - Map to dbo.AutoOrderStatuses | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Last Status Modified Date Indexes | Key Name | Key Columns | Unique | Compression | | --------------------------- | ---------------- | ------ | ----------- | | PK_AutoOrderStatusChangeLog | AutoOrderStatus- | True | PAGE | ChangeLogID | IX_AutoOrderStatusChangeLog_AutoOrderID | AutoOrderID | | PAGE | | --------------------------------------- | ----------- | --- | ---- |
Tables > dbo.AutoOrderStatuses¶
[dbo].[AutoOrderStatuses]¶
MS_Description Auto Order Statuses Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------------- | --------- | ------------------ | ----------- | | AutoOrderStatusID | int | 4 | NOT NULL | Unique ID | AutoOrderStatusDescription | nvarchar(50) | 100 | NOT NULL | | -------------------------- | ------------ | --- | -------- | Status Description Indexes | Key Name | Key Columns | Unique | Compression | | -------------------- | ----------------- | ------ | ----------- | | PK_AutoOrderStatuses | AutoOrderStatusID | True | PAGE |
Tables > dbo.Bills¶
[dbo].[Bills]¶
MS_Description Bills To Pay (Typically Commissions Bills) Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | -------- | --------- | ------- | ----------- | | BillID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | BillStatusID | int | 4 | NOT NULL | | ------------ | --- | --- | -------- | Bill Status ID - Map to dbo.BillStatuses | DueDate | datetime | 8 | NOT NULL | | ------- | -------- | --- | -------- | Bill Due Date | BillTypeID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Bill Type ID - Map to dbo.BillTypes | CurrencyCode | nvarchar(3) | 6 | NOT NULL | | ------------ | ----------- | --- | -------- | Currency Code of Bill To Pay | Amount | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Total Amount in Native Currency Type | CommissionRunID | int | 4 | NULL allowed | | --------------- | --- | --- | ------------ | Commission Run ID for Bill - Map to dbo.Commissions | IsOtherIncome | bit | 1 | NOT NULL | | ------------- | --- | --- | -------- | Is Other Income? | Reference | nvarchar(50) | 100 | NULL allowed | | --------- | ------------ | --- | ------------ | Custom Reference Text | PayableTypeIDOverride | int | 4 | NULL allowed | | --------------------- | --- | --- | ------------ | Payable Type Override - Map to dbo.PayableTypes | Notes | nvarchar(500) | 1000 | NOT NULL | | ----- | ------------- | ---- | -------- | Custom Notes Text | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Last Modified Date of Record | CreatedBy | nvarchar(30) | 60 | NOT NULL | | --------- | ------------ | --- | -------- | Record Created By Name | ModifiedBy | nvarchar(30) | 60 | NOT NULL | | ---------- | ------------ | --- | -------- | Record Last Modified By Name | TaxablePeriodTypeID | int | 4 | NULL allowed | | ------------------- | --- | --- | ------------ | Taxable Period Type - Map to dbo.PeriodTypes | TaxablePeriodID | int | 4 | NULL allowed | | --------------- | --- | --- | ------------ | Taxable Period ID - Map to dbo.Periods
Tables > dbo.Bills¶
Indexes | Key Name | Key Columns | Unique Compression | | -------- | ----------- | ------------------ | | PK_Bills | BillID | True PAGE |
Tables > dbo.BillStatuses¶
[dbo].[BillStatuses]¶
MS_Description Bill Statuses Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------ | --------- | ------------------ | ----------- | | BillStatusID | int | 4 | NOT NULL | Unique ID | BillStatusDescription | nvarchar(20) | 40 | NOT NULL | | --------------------- | ------------ | --- | -------- | Status Description Indexes | Key Name | Key Columns | Unique | Compression | | --------------- | ------------ | ------ | ----------- | | PK_BillStatuses | BillStatusID | True | PAGE |
Tables > dbo.BillTypes¶
[dbo].[BillTypes]¶
MS_Description Bill Types Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------- | --------- | ------------------ | ----------- | | BillTypeID | int | 4 | NOT NULL | Unique ID | BillTypeDescription | nvarchar(50) | 100 | NOT NULL | | ------------------- | ------------ | --- | -------- | Bill Type Descriptions Indexes | Key Name | Key Columns | Unique | Compression | | ------------ | ----------- | ------ | ----------- | | PK_BillTypes | BillTypeID | True | PAGE |
Tables > dbo.BinaryPlacementTypes¶
[dbo].[BinaryPlacementTypes]¶
MS_Description Binary Placement Types Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------------- | --------- | ------------------ | ----------- | | BinaryPlacementTypeID | int | 4 | NOT NULL | Unique ID | BinaryPlacementDescription | nvarchar(50) | 100 | NOT NULL | | -------------------------- | ------------ | --- | -------- | Binary Placement Description Indexes | Key Name | Key Columns | Unique | Compression | | ----------------------- | --------------------- | ------ | ----------- | | PK_BinaryPlacementTypes | BinaryPlacementTypeID | True | PAGE |
Tables > dbo.BinaryTree¶
[dbo].[BinaryTree]¶
MS_Description Binary Tree (Memory Optimized Table) Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------- | --------- | ------------------ | ----------- | | CustomerID | int | 4 | NOT NULL | Customer ID - Map to dbo.Customers | ParentID | int | 4 | NOT NULL | | -------- | --- | --- | -------- | Parent ID - Map to dbo.Customers | NestedLevel | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Nested Level | Placement | int | 4 | NOT NULL | | --------- | --- | --- | -------- | Placement | Lft | int | 4 | NOT NULL | | --- | --- | --- | -------- | Index Left Boundary | Rgt | int | 4 | NOT NULL | | --- | --- | --- | -------- | Index Right Boundary Indexes | Key Name | | Key Columns | Unique | | ------------- | --- | ----------- | ------ | | PK_BinaryTree | | CustomerID | True | Used By
[dbo].[BinaryDownline]¶
[dbo].[BinaryUpline]¶
Tables > dbo.Bonuses¶
[dbo].[Bonuses]¶
MS_Description Bonuses Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | BonusID | int | 4 | NOT NULL | Unique ID | BonusDescription | nvarchar(100) | 200 | NOT NULL | | ---------------- | ------------- | --- | -------- | Bonus Description | PeriodTypeID | int | 4 | NOT NULL | | ------------ | --- | --- | -------- | Period Type ID - Map to dbo.PeriodTypes Indexes | Key Name | Key Columns | Unique | Compression | | ---------- | ----------- | ------ | ----------- | | PK_Bonuses | BonusID | True | PAGE |
Tables > dbo.Broadcasts¶
[dbo].[Broadcasts]¶
MS_Description Broadcasts (Emails or SMS) Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | ----------- | --------- | ------- | ----------- | | BroadCastID | int | 4 | NOT NULL | Unique ID | BroadcastTypeID | int | 4 | NOT NULL | | --------------- | --- | --- | -------- | Broadcast Type ID - Map to dbo.BroadcastTypes | Subject | nvarchar(255) | 510 | NOT NULL | | ------- | ------------- | --- | -------- | Email or SMS Subject Text | SendEmail | bit | 1 | NOT NULL | | --------- | --- | --- | -------- | Send Email? Boolean | EmailContent | nvarchar(max) | max | NOT NULL | | ------------ | ------------- | --- | -------- | Email Content (HTML Enabled) | SendSms | bit | 1 | NOT NULL | | ------- | --- | --- | -------- | Send SMS? Boolean | SmsContent | nvarchar(max) | max | NOT NULL | | ---------- | ------------- | --- | -------- | SMS Content | Notes | nvarchar(max) | max | NOT NULL | | ----- | ------------- | --- | -------- | Broadcast Notes | IsEnabled | bit | 1 | NOT NULL | | --------- | --- | --- | -------- | Is Enabled? | CreatedDate | datetime | 8 | NOT NULL | | ----------- | -------- | --- | -------- | Broadcast Created Date | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Broadcast Last Modified Date Indexes | Key Name | Key Columns | Unique | Compression | | ------------- | ----------- | ------ | ----------- | | PK_Broadcasts | BroadCastID | True | PAGE |
Tables > dbo.BroadcastTypes¶
[dbo].[BroadcastTypes]¶
MS_Description Broadcast Types Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------- | --------- | ------------------ | ----------- | | BroadcastTypeID | int | 4 | NOT NULL | Unique ID | BroadcastTypeDescription | nvarchar(50) | 100 | NOT NULL | | ------------------------ | ------------ | --- | -------- | Type Description Indexes | Key Name | Key Columns | Unique | Compression | | ----------------- | --------------- | ------ | ----------- | | PK_BroadcastTypes | BroadcastTypeID | True | PAGE |
Tables > dbo.CodedRanks¶
[dbo].[CodedRanks]¶
MS_Description One Time Commissions Events Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------------- | --------- | ------------------ | ----------- | | CodedRankEntryID | int | 4 | NOT NULL | Unique ID | CodingTypeID | int | 4 | NOT NULL | | ------------ | --- | --- | -------- | Coding Type ID - Map to dbo.CodingTypes | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer iD - Map to dbo.Customers | RankID | int | 4 | NOT NULL | | ------ | --- | --- | -------- | Rank ID - Map to dbo.Ranks | CodedDate | datetime | 8 | NOT NULL | | --------- | -------- | --- | -------- | Coded Date | CodedToCustomerID | int | 4 | NOT NULL | | ----------------- | --- | --- | -------- | Customer Record Applies To - Map to dbo.Customers | EntryDate | datetime | 8 | NOT NULL | | --------- | -------- | --- | -------- | Record Create Date | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date Indexes | Key Name | Key Columns | Unique | Compression | | -------------------------- | ---------------- | ------ | ----------- | | PK_CodedRanks | CodedRankEntryID | True | PAGE | | IX_CodedRanks_CodingTypeID | CodingTypeID | | PAGE | | IX_CodedRanks_CustomerID | CustomerID | | PAGE |
Tables > dbo.CodingTypes¶
[dbo].[CodingTypes]¶
MS_Description Coded Ranks Coding Types Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------ | --------- | ------------------ | ----------- | | CodingTypeID | int | 4 | NOT NULL | Unique ID | CodingTypeDescription | nvarchar(100) | 200 | NULL allowed | | --------------------- | ------------- | --- | ------------ | Coding Description Indexes | Key Name | | Key Columns | Unique Compression | | -------------- | --- | ------------ | ------------------ | | PK_CodingTypes | | CodingTypeID | True PAGE |
Tables > dbo.CommandLog¶
[dbo].[CommandLog]¶
MS_Description Log Table for Maintenance Jobs Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | Identity | | --------------- | --------------- | ------------------ | ------------ | -------- | | ID | int | 4 | NOT NULL | 1 - 1 | | DatabaseName | [sys].[sysname] | 256 | NULL allowed | | | SchemaName | [sys].[sysname] | 256 | NULL allowed | | | ObjectName | [sys].[sysname] | 256 | NULL allowed | | | ObjectType | char(2) | 2 | NULL allowed | | | IndexName | [sys].[sysname] | 256 | NULL allowed | | | IndexType | tinyint | 1 | NULL allowed | | | StatisticsName | [sys].[sysname] | 256 | NULL allowed | | | PartitionNumber | int | 4 | NULL allowed | | | ExtendedInfo | xml | max | NULL allowed | | | Command | nvarchar(max) | max | NOT NULL | | | CommandType | nvarchar(60) | 120 | NOT NULL | | | StartTime | datetime2 | 8 | NOT NULL | | | EndTime | datetime2 | 8 | NULL allowed | | | ErrorNumber | int | 4 | NULL allowed | | | ErrorMessage | nvarchar(max) | max | NULL allowed | | Indexes | Key Name | | | Key Columns | Unique | | ------------- | --- | --- | ----------- | ------ | | PK_CommandLog | | | ID | True | Used By
[dbo].[CommandExecute]¶
Tables > dbo.CommissionBinaryTree¶
[dbo].[CommissionBinaryTree]¶
MS_Description Commission Binary Tree (Recommended To Use dbo.BinaryDownline or dbo.BinaryUpline Views Instead) Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------- | --------- | ------------------ | ----------- | | CommissionRunID | int | 4 | NOT NULL | Commission Run ID - Map to dbo.CommissionRuns | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | ParentID | int | 4 | NOT NULL | | -------- | --- | --- | -------- | Parent ID - Map to dbo.Customers | NestedLevel | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Nested Level | Placement | int | 4 | NOT NULL | | --------- | --- | --- | -------- | Placement In Tree | Lft | int | 4 | NOT NULL | | --- | --- | --- | -------- | Left Index Boundary | Rgt | int | 4 | NOT NULL | | --- | --- | --- | -------- | Right Index Boundary Indexes | Key Name | Key Columns | Unique | Compression | | ----------------------- | ----------------- | ------ | ----------- | | PK_CommissionBinaryTree | CommissionRunID, | True | PAGE | CustomerID
Tables > dbo.CommissionBonuses¶
[dbo].[CommissionBonuses]¶
MS_Description Commission Bonuses Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------- | --------- | ------------------ | ----------- | | CommissionRunID | int | 4 | NOT NULL | Commission Run ID - Map to dbo.CommissionRuns | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | BonusID | int | 4 | NOT NULL | | ------- | --- | --- | -------- | Bonus ID - Map to dbo.Bonuses | Amount | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Dollar Amount in Currency Code of the dbo.Commissions Table by CustomerID and CommissionsRunID Indexes | Key Name | Key Columns | Unique | Compression | | -------------------- | ----------------- | ------ | ----------- | | PK_CommissionBonuses | CommissionRunID, | True | PAGE | CustomerID, BonusID
Tables > dbo.CommissionCurrentExchangeRates¶
[dbo].[CommissionCurrentExchangeRates]¶
MS_Description Exchange Rate Defined By Client For Currency Codes Used In Paying Commissions Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------ | ----------- | ------------------ | ----------- | | CurrencyCode | nvarchar(3) | 6 | NOT NULL | Currency Code | Rate | money | 8 | NOT NULL | | ---- | ----- | --- | -------- | Rate (Customer Defined) | Fee | money | 8 | NOT NULL | | --- | ----- | --- | -------- | Fee Indexes | Key Name | Key Columns | Unique | Compression | | --------------------------------- | ------------ | ------ | ----------- | | PK_CommissionCurrentExchangeRates | CurrencyCode | True | PAGE |
Tables > dbo.CommissionCustomers¶
[dbo].[CommissionCustomers]¶
MS_Description Customer Rank Stats Per Accepted Commission Run Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | --------------- | --------- | ------- | ----------- | | CommissionRunID | int | 4 | NOT NULL | Commission Run ID - Map to dbo.CommissionRuns | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | CustomerTypeID | int | 4 | NOT NULL | | -------------- | --- | --- | -------- | Customer Type ID - Map to dbo.CustomerTypes | CustomerStatusID | int | 4 | NOT NULL | | ---------------- | --- | --- | -------- | Customer Status ID - Map to dbo.CustomerStatuses | RankID | int | 4 | NULL allowed | | ------ | --- | --- | ------------ | Highest Rank ID Ever Achieved - Map to dbo.Ranks | NewRankID | int | 4 | NULL allowed | | --------- | --- | --- | ------------ | New Highest Rank ID - RankID Gets Updated Next Run With This Value - Map to dbo.Ranks | PaidRankID | int | 4 | NULL allowed | | ---------- | --- | --- | ------------ | Paid Rank ID For Current Commission Run - Map to dbo.Ranks | Country | nvarchar(50) | 100 | NULL allowed | | ------- | ------------ | --- | ------------ | Country of Customer Record Indexes | Key Name | Key Columns | Unique | Compression | | ---------------------- | ----------------- | ------ | ----------- | | PK_CommissionCustomers | CommissionRunID, | True | PAGE | CustomerID
Tables > dbo.CommissionDetails¶
[dbo].[CommissionDetails]¶
MS_Description Details Per Commission Run Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | --------------- | --------- | ------- | ----------- | | CommissionRunID | int | 4 | NOT NULL | Commission Run ID - Map to dbo.CommissionRuns | CommissionDetailID | bigint | 8 | NOT NULL | | ------------------ | ------ | --- | -------- | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | BonusID | int | 4 | NOT NULL | | ------- | --- | --- | -------- | Bonus ID - Map to dbo.Bonuses | FromCustomerID | int | 4 | NULL allowed | | -------------- | --- | --- | ------------ | Downline Customer Commission Is From | OrderID | int | 4 | NULL allowed | | ------- | --- | --- | ------------ | Downline Customer Order Commission Is From | SourceAmount | money | 8 | NOT NULL | | ------------ | ----- | --- | -------- | Order Dollar Amount Converted to CurrencyCode | Percentage | money | 8 | NOT NULL | | ---------- | ----- | --- | -------- | Commission Percent | CommissionAmount | money | 8 | NOT NULL | | ---------------- | ----- | --- | -------- | Calculated Commission Amount Converted to CurrencyCode | Level | int | 4 | NULL allowed | | ----- | --- | --- | ------------ | Levels Up From Source Customer | PaidLevel | int | 4 | NULL allowed | | --------- | --- | --- | ------------ | Levels Up From Source Customer - Bonus Specific | CurrencyCode | nvarchar(3) | 6 | NOT NULL | | ------------ | ----------- | --- | -------- | Currency Code For SourceAmount & CommissionAmount | EntryCurrencyCode | nvarchar(3) | 6 | NOT NULL | | ----------------- | ----------- | --- | -------- | Currency Code For Order | EntrySourceAmount | money | 8 | NOT NULL | | ----------------- | ----- | --- | -------- | Order Amount Converted to USD From EntryCurrencyCode | EntryCommissionAmount | money | 8 | NOT NULL | | --------------------- | ----- | --- | -------- | Commission Amount Converted to USD From EntryCurrency- Code | ToRankID | int | 4 | NULL allowed | | -------- | --- | --- | ------------ | Prior Rank ID | FromRankID | int | 4 | NULL allowed | | ---------- | --- | --- | ------------ | New Rank ID
Tables > dbo.CommissionDetails¶
Indexes | Key Name | Key Columns | Unique Compression | | -------------------- | ----------------- | ------------------ | | PK_CommissionDetails | CommissionRunID, | True PAGE | CommissionDetailID
Tables > dbo.CommissionEnrollerTree¶
[dbo].[CommissionEnrollerTree]¶
MS_Description Commissions Enroller Tree Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------- | --------- | ------------------ | ----------- | | CommissionRunID | int | 4 | NOT NULL | Commission Run ID - Map to dbo.CommissionRuns | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | EnrollerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Enroller ID - Map to dbo.Customers | NestedLevel | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Nested Level | Lft | int | 4 | NOT NULL | | --- | --- | --- | -------- | Left Index Boundary | Rgt | int | 4 | NOT NULL | | --- | --- | --- | -------- | Right Index Boundary Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------- | ----------------- | ------ | ----------- | | PK_CommissionEnrollerTree | CommissionRunID, | True | PAGE | CustomerID
Tables > dbo.CommissionExchangeRates¶
[dbo].[CommissionExchangeRates]¶
MS_Description Commission Exchange Rates History By Commission Run Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | --------------- | --------- | ------- | ----------- | | CommissionRunID | int | 4 | NOT NULL | Commission Run ID - Map to dbo.CommissionRuns | CurrencyCode | nvarchar(3) | 6 | NOT NULL | | ------------ | ----------- | --- | -------- | Currency Code | Rate | money | 8 | NOT NULL | | ---- | ----- | --- | -------- | Customer Defined Rate | Fee | money | 8 | NOT NULL | | --- | ----- | --- | -------- | Fee Indexes | Key Name | Key Columns | Unique | Compression | | -------------------------- | ----------------- | ------ | ----------- | | PK_CommissionExchangeRates | CommissionRunID, | True | PAGE | CurrencyCode
Tables > dbo.CommissionOverrides¶
[dbo].[CommissionOverrides]¶
MS_Description Commission Overrides Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------- | --------- | ------------------ | ----------- | | CommissionRunID | int | 4 | NOT NULL | Commission Run ID - Map to dbo.CommissionRuns | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | OverrideID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Override ID - Map to dbo.Overrides | Qualifies | bit | 1 | NOT NULL | | --------- | --- | --- | -------- | Qualifies? Boolean | PeriodTypeID | int | 4 | NULL allowed | | ------------ | --- | --- | ------------ | Period Type ID - Map to dbo.Periods | StartPeriodID | int | 4 | NULL allowed | | ------------- | --- | --- | ------------ | Period Start ID - Map to dbo.Periods | EndPeriodID | int | 4 | NULL allowed | | ----------- | --- | --- | ------------ | Period End ID - Map to dbo.Periods | Amount | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Amount of Override (Raw number that can be exchanged downstream) Indexes | Key Name | Key Columns | Unique | Compression | | ---------------------- | ----------------- | ------ | ----------- | | PK_CommissionOverrides | CommissionRunID, | True | PAGE | CustomerID, OverrideID
Tables > dbo.CommissionRankGroups¶
[dbo].[CommissionRankGroups]¶
MS_Description Rank Groups for Commissions Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------- | --------- | ------------------ | ----------- | | CommissionRunID | int | 4 | NOT NULL | Commission Run ID - Map to dbo.CommissionRuns | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | RankGroupID | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Unique ID | RankID | int | 4 | NOT NULL | | ------ | --- | --- | -------- | Highest Rank ID Ever Achieved | PaidRankID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Paid Rank ID For Current Commission Run | LegRankID | int | 4 | NOT NULL | | --------- | --- | --- | -------- | Highest Paid Rank ID in Leg Indexes | Key Name | Key Columns | Unique | Compression | | ----------------------- | ----------------- | ------ | ----------- | | PK_CommissionRankGroups | CommissionRunID, | True | PAGE | CustomerID, RankGroup- ID
Tables > dbo.CommissionRuns¶
[dbo].[CommissionRuns]¶
MS_Description Commission Run Reference Table Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | --------------- | --------- | ------- | ----------- | | CommissionRunID | int | 4 | NOT NULL | Unique ID | CommissionRunDescription | nvarchar(100) | 200 | NOT NULL | | ------------------------ | ------------- | --- | -------- | Description for the Run | PeriodTypeID | int | 4 | NOT NULL | | ------------ | --- | --- | -------- | Period Type ID - Map to dbo.PeriodTypes | PeriodID | int | 4 | NOT NULL | | -------- | --- | --- | -------- | Period ID - Map to dbo.Periods | RunDate | datetime | 8 | NULL allowed | | ------- | -------- | --- | ------------ | Run Date of Commission Run | AcceptedDate | datetime | 8 | NULL allowed | | ------------ | -------- | --- | ------------ | Acceptance Date of Commission Run | CommissionRunStatusID | int | 4 | NOT NULL | | --------------------- | --- | --- | -------- | Commission Run Status - Map to dbo.CommissionRun- Statuses | HideFromWeb | bit | 1 | NOT NULL | | ----------- | --- | --- | -------- | Hide From Web? Boolean | PlanID | int | 4 | NULL allowed | | ------ | --- | --- | ------------ | Plan Project ID | ArchivedDate | datetime | 8 | NULL allowed | | ------------ | -------- | --- | ------------ | Archive Date of Commission Run Indexes | Key Name | Key Columns | Unique | Compression | | ----------------- | --------------- | ------ | ----------- | | PK_CommissionRuns | CommissionRunID | True | PAGE |
Tables > dbo.CommissionRunStatuses¶
[dbo].[CommissionRunStatuses]¶
MS_Description Commission Run Statuses Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------------- | --------- | ------------------ | ----------- | | CommissionRunStatusID | int | 4 | NOT NULL | Unique ID | CommissionRunStatusDescription | nvarchar(50) | 100 | NOT NULL | | ------------------------------ | ------------ | --- | -------- | Status Description Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------ | --------------------- | ------ | ----------- | | PK_CommissionRunStatuses | CommissionRunStatusID | True | PAGE |
Tables > dbo.Commissions¶
[dbo].[Commissions]¶
MS_Description Commissions Calculated Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | --------------- | --------- | ------- | ----------- | | CommissionRunID | int | 4 | NOT NULL | Commission Run ID - Map to dbo.CommissionRuns | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | CurrencyCode | nvarchar(3) | 6 | NOT NULL | | ------------ | ----------- | --- | -------- | Currency Code of Commission Paid | Earnings | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Amount in Currency Code | PreviousBalance | money | 8 | NOT NULL | | --------------- | ----- | --- | -------- | Unused | BalanceForward | money | 8 | NOT NULL | | -------------- | ----- | --- | -------- | Unused | Fee | money | 8 | NOT NULL | | --- | ----- | --- | -------- | Fee | Total | money | 8 | NOT NULL | | ----- | ----- | --- | -------- | Earnings Minus Fee Indexes | Key Name | Key Columns | Unique | Compression | | -------------- | -------------------------- | ------ | ----------- | | PK_Commissions | CommissionRunID, Customer- | True | PAGE | ID
Tables > dbo.CommissionUniLevelTree¶
[dbo].[CommissionUniLevelTree]¶
MS_Description Commissions Unilevel Tree Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------- | --------- | ------------------ | ----------- | | CommissionRunID | int | 4 | NOT NULL | Commission Run ID - Map to dbo.CommissionRuns | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | SponsorID | int | 4 | NOT NULL | | --------- | --- | --- | -------- | Sponsor ID - Map to dbo.Customers | NestedLevel | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Nested Level | Lft | int | 4 | NOT NULL | | --- | --- | --- | -------- | Index Left Boundary | Rgt | int | 4 | NOT NULL | | --- | --- | --- | -------- | Index Right Boundary Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------- | ----------------- | ------ | ----------- | | PK_CommissionUniLevelTree | CommissionRunID, | True | PAGE | CustomerID
Tables > dbo.CommissionVolumes¶
[dbo].[CommissionVolumes]¶
MS_Description Commission Volumes Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------- | --------- | ------------------ | ----------- | | CommissionRunID | int | 4 | NOT NULL | Commission Run ID - Map to dbo.CommissionRuns | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | VolumeTypeID | int | 4 | NOT NULL | | ------------ | --- | --- | -------- | Volume Type ID - Map to dbo.CommissionVolumeTypes | Volume | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Volume Indexes | Key Name | Key Columns | Unique | Compression | | -------------------- | ----------------- | ------ | ----------- | | PK_CommissionVolumes | CommissionRunID, | True | PAGE | CustomerID, VolumeTypeID
Tables > dbo.CommissionVolumeTypes¶
[dbo].[CommissionVolumeTypes]¶
MS_Description Commission Volume Types Reference Table Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | --------------- | --------- | ------- | ----------- | | CommissionRunID | int | 4 | NOT NULL | Commission Run ID - Map to dbo.CommissionRuns | VolumeTypeID | int | 4 | NOT NULL | | ------------ | --- | --- | -------- | Unique ID | VolumeTypeDescription | nvarchar(500) | 1000 | NOT NULL | | --------------------- | ------------- | ---- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------ | ----------------- | ------ | ----------- | | PK_CommissionVolumeTypes | CommissionRunID, | True | PAGE | VolumeTypeID
Tables > dbo.Company¶
[dbo].[Company]¶
MS_Description Your Company Key With Exigo Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------- | ------------ | ------------------ | ----------- | | CompanyKey | nvarchar(15) | 30 | NOT NULL | Company Key | Name | nvarchar(50) | 100 | NOT NULL | | ---- | ------------ | --- | -------- | Company Name Indexes | Key Name | Key Columns | Unique | Compression | | ---------- | ----------- | ------ | ----------- | | PK_Company | CompanyKey | True | PAGE |
Tables > dbo.CompanyNews¶
[dbo].[CompanyNews]¶
MS_Description Company News Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------- | --------- | ------------------ | ----------- | | CompanyNewsID | int | 4 | NOT NULL | Unique ID | Title | nvarchar(225) | 450 | NOT NULL | | ----- | ------------- | --- | -------- | News Title | Content | nvarchar(max) | max | NOT NULL | | ------- | ------------- | --- | -------- | News Body Content | IsCompanyWide | bit | 1 | NOT NULL | | ------------- | --- | --- | -------- | Is Company Wide? Boolean | AvailableOnWeb | bit | 1 | NOT NULL | | -------------- | --- | --- | -------- | Available On Web? Boolean | CreatedDate | datetime | 8 | NOT NULL | | ----------- | -------- | --- | -------- | Created Date Indexes | Key Name | Key Columns | Unique | Compression | | -------------- | ------------- | ------ | ----------- | | PK_CompanyNews | CompanyNewsID | True | PAGE |
Tables > dbo.CompanyNewsDepartments¶
[dbo].[CompanyNewsDepartments]¶
MS_Description Company News Departments Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | NewsID | int | 4 | NOT NULL | Company News ID - Map to dbo.CompanyNews | DepartmentID | int | 4 | NOT NULL | | ------------ | --- | --- | -------- | Department ID - Map to dbo.Departments Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------- | -------------------- | ------ | ----------- | | PK_CompanyNewsDepartments | NewsID, DepartmentID | True | PAGE |
Tables > dbo.Countries¶
[dbo].[Countries]¶
MS_Description Countries Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------- | ----------- | ------------------ | ----------- | | CountryCode | nvarchar(2) | 4 | NOT NULL | Country Code | CountryDescription | nvarchar(50) | 100 | NULL allowed | | ------------------ | ------------ | --- | ------------ | Country Description | Priority | int | 4 | NOT NULL | | -------- | --- | --- | -------- | Sorting Order Indexes | Key Name | | Key Columns | Unique Compression | | ------------ | --- | ----------- | ------------------ | | PK_Countries | | CountryCode | True PAGE |
Tables > dbo.CountryRegions¶
[dbo].[CountryRegions]¶
MS_Description Country Regions Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------- | ----------- | ------------------ | ----------- | | CountryCode | nvarchar(2) | 4 | NOT NULL | Country Code - Map to dbo.Countries | RegionCode | nvarchar(50) | 100 | NOT NULL | | ---------- | ------------ | --- | -------- | Region Code | RegionDescription | nvarchar(50) | 100 | NULL allowed | | ----------------- | ------------ | --- | ------------ | Region Description Indexes | Key Name | Key Columns | | Unique Compression | | ----------------- | ----------------------- | --- | ------------------ | | PK_CountryRegions | CountryCode, RegionCode | | True PAGE |
Tables > dbo.CreditCardTypes¶
[dbo].[CreditCardTypes]¶
MS_Description Credit Card Types Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------------- | --------- | ------------------ | ----------- | | CreditCardTypeID | int | 4 | NOT NULL | Unique ID | CreditCardTypeDescription | nvarchar(100) | 200 | NOT NULL | | ------------------------- | ------------- | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ------------------ | ---------------- | ------ | ----------- | | PK_CreditCardTypes | CreditCardTypeID | True | PAGE |
Tables > dbo.Currencies¶
[dbo].[Currencies]¶
MS_Description Currencies (Allows Custom Currencies) Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------ | ----------- | ------------------ | ----------- | | CurrencyCode | nvarchar(3) | 6 | NOT NULL | Currency Code | CurrencyDescription | nvarchar(50) | 100 | NULL allowed | | ------------------- | ------------ | --- | ------------ | Currency Description | CurrencySymbol | nvarchar(10) | 20 | NULL allowed | | -------------- | ------------ | --- | ------------ | Currency Symbol Indexes | Key Name | | Key Columns | Unique Compression | | ------------- | --- | ------------ | ------------------ | | PK_Currencies | | CurrencyCode | True PAGE |
Tables > dbo.CustomerAccountChangeLog¶
[dbo].[CustomerAccountChangeLog]¶
MS_Description Change Log for the dbo.CustomerAccounts Records Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------------------------- | --------- | ------------------ | ----------- | | CustomerAccountChangeLogID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.CustomerAccounts | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Modified Date | ModifiedBy | nvarchar(50) | 100 | NOT NULL | | ---------- | ------------ | --- | -------- | Record Modified By User | Detail | nvarchar(max) | max | NOT NULL | | ------ | ------------- | --- | -------- | Detail of Change From and To Indexes | Key Name | Key Columns | Unique | Compression | | --------------------------- | ---------------- | ------ | ----------- | | PK_CustomerAccountChangeLog | CustomerAccount- | True | PAGE | ChangeLogID | IX_CustomerAccountChangeLog_CustomerID | CustomerID | | PAGE | | -------------------------------------- | ---------- | --- | ---- |
Tables > dbo.CustomerAccounts¶
[dbo].[CustomerAccounts]¶
MS_Description Customer Payment Accounts Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | ---------- | --------- | ------- | ----------- | | CustomerID | int | 4 | NOT NULL | Customer ID - Map to dbo.Customers | PrimaryCreditCardDisplay | nvarchar(50) | 100 | NULL allowed | | ------------------------ | ------------ | --- | ------------ | Primary CC Display - Masked | PrimaryExpirationMonth | int | 4 | NULL allowed | | ---------------------- | --- | --- | ------------ | Primary CC Expire Month | PrimaryExpirationYear | int | 4 | NULL allowed | | --------------------- | --- | --- | ------------ | Primary CC Expire Year | PrimaryCreditCardTypeID | int | 4 | NOT NULL | | ----------------------- | --- | --- | -------- | Primary CC Type ID - Map to dbo.PaymentCardTypes | PrimaryBillingName | nvarchar(50) | 100 | NOT NULL | | ------------------ | ------------ | --- | -------- | Primary Billing Person Name | PrimaryBillingAddress | nvarchar(100) | 200 | NULL allowed | | --------------------- | ------------- | --- | ------------ | Primary Billing Address Field 1 | PrimaryBillingAddress2 | nvarchar(100) | 200 | NULL allowed | | ---------------------- | ------------- | --- | ------------ | Primary Billing Address Field 2 | PrimaryBillingCity | nvarchar(50) | 100 | NULL allowed | | ------------------ | ------------ | --- | ------------ | Primary Billing City | PrimaryBillingState | nvarchar(50) | 100 | NULL allowed | | ------------------- | ------------ | --- | ------------ | Primary Billing State | PrimaryBillingZip | nvarchar(50) | 100 | NULL allowed | | ----------------- | ------------ | --- | ------------ | Primary Billing Zip | PrimaryBillingCountry | nvarchar(50) | 100 | NULL allowed | | --------------------- | ------------ | --- | ------------ | Primary Billing Country | SecondaryCreditCardDisplay | nvarchar(50) | 100 | NULL allowed | | -------------------------- | ------------ | --- | ------------ | Secondary CC Display - Masked | SecondaryExpirationMonth | int | 4 | NULL allowed | | ------------------------ | --- | --- | ------------ | Secondary CC Expire Month | SecondaryExpirationYear | int | 4 | NULL allowed | | ----------------------- | --- | --- | ------------ | Secondary CC Expire Month | SecondaryCreditCardTypeID | int | 4 | NOT NULL | | ------------------------- | --- | --- | -------- | Secondary CC Type ID - Map to dbo.PaymentCardTypes | SecondaryBillingName | nvarchar(50) | 100 | NOT NULL | | -------------------- | ------------ | --- | -------- | Secondary Billing Person Name | SecondaryBillingAddress | nvarchar(100) | 200 | NULL allowed | | ----------------------- | ------------- | --- | ------------ | Secondary Billing Address Field 1 | SecondaryBillingAddress2 | nvarchar(100) | 200 | NULL allowed | | ------------------------ | ------------- | --- | ------------ | Secondary Billing Address Field 2
Tables > dbo.CustomerAccounts¶
| SecondaryBillingCity | nvarchar(50) | 100 | NULL allowed |
|---|---|---|---|
| Secondary Billing City | |||
| SecondaryBillingState | nvarchar(50) | 100 | NULL allowed |
| --------------------- | ------------ | --- | ------------ |
| Secondary Billing State | |||
| SecondaryBillingZip | nvarchar(50) | 100 | NULL allowed |
| ------------------- | ------------ | --- | ------------ |
| Secondary Billing Zip | |||
| SecondaryBillingCountry | nvarchar(50) | 100 | NULL allowed |
| ----------------------- | ------------ | --- | ------------ |
| Secondary Billing Country | |||
| BankAccountNumber | nvarchar(50) | 100 | NULL allowed |
| ----------------- | ------------ | --- | ------------ |
| Bank Account Number - Masked | |||
| BankRoutingNumber | nvarchar(50) | 100 | NOT NULL |
| ----------------- | ------------ | --- | -------- |
| Bank Routing Number | |||
| BankNameOnAccount | nvarchar(50) | 100 | NOT NULL |
| ----------------- | ------------ | --- | -------- |
| Name on Bank Account | |||
| BankAccountAddress | nvarchar(100) | 200 | NULL allowed |
| ------------------ | ------------- | --- | ------------ |
| Bank Account Address | |||
| BankAccountCity | nvarchar(50) | 100 | NULL allowed |
| --------------- | ------------ | --- | ------------ |
| Bank Account City | |||
| BankAccountState | nvarchar(50) | 100 | NULL allowed |
| ---------------- | ------------ | --- | ------------ |
| Bank Account State | |||
| BankAccountZip | nvarchar(50) | 100 | NULL allowed |
| -------------- | ------------ | --- | ------------ |
| Bank Account Zip | |||
| BankAccountCountry | nvarchar(50) | 100 | NULL allowed |
| ------------------ | ------------ | --- | ------------ |
| Bank Account Country | |||
| DriversLicenseNumber | nvarchar(50) | 100 | NOT NULL |
| -------------------- | ------------ | --- | -------- |
| Drivers License Number | |||
| DepositNameOnAcount | nvarchar(50) | 100 | NOT NULL |
| ------------------- | ------------ | --- | -------- |
| Deposit Name on Account | |||
| DepositAccountNumber | nvarchar(50) | 100 | NOT NULL |
| -------------------- | ------------ | --- | -------- |
| Deposit Account Number - Masked | |||
| DepositRoutingNumber | nvarchar(50) | 100 | NOT NULL |
| -------------------- | ------------ | --- | -------- |
| Deposit Routing Number | |||
| Iban | nvarchar(50) | 100 | NOT NULL |
| ---- | ------------ | --- | -------- |
| IBAN | |||
| SwiftCode | nvarchar(50) | 100 | NOT NULL |
| --------- | ------------ | --- | -------- |
| Swift Code | |||
| CheckIban | nvarchar(50) | 100 | NOT NULL |
| --------- | ------------ | --- | -------- |
| Check IBAN | |||
| CheckSwiftCode | nvarchar(50) | 100 | NOT NULL |
| -------------- | ------------ | --- | -------- |
| Check Swift Code | |||
| DepositBankName | nvarchar(100) | 200 | NOT NULL |
| --------------- | ------------- | --- | -------- |
| Deposit Bank Name | |||
| DepositBankAddress | nvarchar(250) | 500 | NOT NULL |
| ------------------ | ------------- | --- | -------- |
| Deposit Bank Address | |||
| DepositBankCity | nvarchar(50) | 100 | NOT NULL |
| --------------- | ------------ | --- | -------- |
| Deposit Bank City | |||
| DepositBankState | nvarchar(50) | 100 | NOT NULL |
| ---------------- | ------------ | --- | -------- |
| Deposit Bank State | |||
| DepositBankZip | nvarchar(50) | 100 | NOT NULL |
| -------------- | ------------ | --- | -------- |
| Deposit Bank Zip | |||
| DepositBankCountry | nvarchar(50) | 100 | NOT NULL |
| ------------------ | ------------ | --- | -------- |
| Deposit Bank Country |
Tables > dbo.CustomerAccounts¶
| PrimaryWalletTypeID | int | 4 | NOT NULL |
|---|---|---|---|
| Primary Wallet Type ID - Map to dbo.WalletTypes | |||
| PrimaryWalletAccount | nvarchar(max) | max | NULL allowed |
| -------------------- | ------------- | --- | ------------ |
| Primary Wallet Account - Masked | |||
| PrimaryWalletOther1 | nvarchar(200) | 400 | NULL allowed |
| ------------------- | ------------- | --- | ------------ |
| Primary Wallet Other 1 (Custom) | |||
| PrimaryWalletOther2 | nvarchar(200) | 400 | NULL allowed |
| ------------------- | ------------- | --- | ------------ |
| Primary Wallet Other 2 (Custom) | |||
| PrimaryWalletOther3 | nvarchar(200) | 400 | NULL allowed |
| ------------------- | ------------- | --- | ------------ |
| Primary Wallet Other 3 (Custom) | |||
| SecondaryWalletTypeID | int | 4 | NOT NULL |
| --------------------- | --- | --- | -------- |
| Secondary Wallet Type ID - Map to dbo.WalletTypes | |||
| SecondaryWalletAccount | nvarchar(max) | max | NULL allowed |
| ---------------------- | ------------- | --- | ------------ |
| Secondary Wallet Account - Masked | |||
| SecondaryWalletOther1 | nvarchar(200) | 400 | NULL allowed |
| --------------------- | ------------- | --- | ------------ |
| Secondary Wallet Other 1 (Custom) | |||
| SecondaryWalletOther2 | nvarchar(200) | 400 | NULL allowed |
| --------------------- | ------------- | --- | ------------ |
| Secondary Wallet Other 2 (Custom) | |||
| SecondaryWalletOther3 | nvarchar(200) | 400 | NULL allowed |
| --------------------- | ------------- | --- | ------------ |
| Secondary Wallet Other 3 (Custom) | |||
| TertiaryWalletTypeID | int | 4 | NOT NULL |
| -------------------- | --- | --- | -------- |
| Tertiary Wallet Type ID - Map to dbo.WalletTypes | |||
| TertiaryWalletAccount | nvarchar(max) | max | NULL allowed |
| --------------------- | ------------- | --- | ------------ |
| Tertiary Wallet Account - Masked | |||
| TertiaryWalletOther1 | nvarchar(200) | 400 | NULL allowed |
| -------------------- | ------------- | --- | ------------ |
| Tertiary Wallet Other 1 (Custom) | |||
| TertiaryWalletOther2 | nvarchar(200) | 400 | NULL allowed |
| -------------------- | ------------- | --- | ------------ |
| Tertiary Wallet Other 2 (Custom) | |||
| TertiaryWalletOther3 | nvarchar(200) | 400 | NULL allowed |
| -------------------- | ------------- | --- | ------------ |
| Tertiary Wallet Other 3 (Custom) | |||
| QuaternaryWalletTypeID | int | 4 | NOT NULL |
| ---------------------- | --- | --- | -------- |
| Quaternary Wallet Type ID - Map to dbo.WalletTypes | |||
| QuaternaryWalletAccount | nvarchar(max) | max | NULL allowed |
| ----------------------- | ------------- | --- | ------------ |
| Quaternary Wallet Account - Masked | |||
| QuaternaryWalletOther1 | nvarchar(200) | 400 | NULL allowed |
| ---------------------- | ------------- | --- | ------------ |
| Quaternary Wallet Other 1 (Custom) | |||
| QuaternaryWalletOther2 | nvarchar(200) | 400 | NULL allowed |
| ---------------------- | ------------- | --- | ------------ |
| Quaternary Wallet Other 2 (Custom) | |||
| QuaternaryWalletOther3 | nvarchar(200) | 400 | NULL allowed |
| ---------------------- | ------------- | --- | ------------ |
| Quaternary Wallet Other 3 (Custom) | |||
| QuinaryWalletTypeID | int | 4 | NOT NULL |
| ------------------- | --- | --- | -------- |
| Quinary Wallet Type ID - Map to dbo.WalletTypes | |||
| QuinaryWalletAccount | nvarchar(max) | max | NULL allowed |
| -------------------- | ------------- | --- | ------------ |
| Quinary Wallet Account - Masked | |||
| QuinaryWalletOther1 | nvarchar(200) | 400 | NULL allowed |
| ------------------- | ------------- | --- | ------------ |
| Quinary Wallet Other 1 (Custom) | |||
| QuinaryWalletOther2 | nvarchar(200) | 400 | NULL allowed |
| ------------------- | ------------- | --- | ------------ |
| Quinary Wallet Other 2 (Custom) | |||
| QuinaryWalletOther3 | nvarchar(200) | 400 | NULL allowed |
| ------------------- | ------------- | --- | ------------ |
| Quinary Wallet Other 3 (Custom) | |||
| CreditCardTokenType | int | 4 | NULL allowed |
| ------------------- | --- | --- | ------------ |
| Credit Card Token Type - (Needs reference table created) |
Tables > dbo.CustomerAccounts¶
| CreditCardToken | nvarchar(50) | 100 | NULL allowed |
|---|---|---|---|
| Credit Card Token | |||
| CreditCardTokenType2 | int | 4 | NULL allowed |
| -------------------- | --- | --- | ------------ |
| Secondary Credit Card Token Type - (Needs reference table | |||
| created) | |||
| CreditCardToken2 | nvarchar(50) | 100 | NULL allowed |
| ---------------- | ------------ | --- | ------------ |
| Secondary Credit Card Token | |||
| ModifiedDate | datetime | 8 | NOT NULL |
| ------------ | -------- | --- | -------- |
| Last Record Modified Date | |||
| ModifiedBy | nvarchar(50) | 100 | NOT NULL |
| ---------- | ------------ | --- | -------- |
| Last Record Modified By User | |||
| BankAccountType | int | 4 | NOT NULL |
| --------------- | --- | --- | -------- |
| Bank Account Type - (Needs reference table created) | |||
| Indexes | |||
| Key Name | Key Columns | Unique | Compression |
| ------------------- | ----------- | ------ | ----------- |
| PK_CustomerAccounts | CustomerID | True | PAGE |
| Used By |
[queue].[Refresh]¶
Tables > dbo.CustomerAdjustments¶
[dbo].[CustomerAdjustments]¶
MS_Description Customer Adjustments Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | ------------- | --------- | ------- | ----------- | | TransactionID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | CustomerTransactionTypeID | int | 4 | NOT NULL | | ------------------------- | --- | --- | -------- | Customer Transaction Type ID - Map to dbo.Customer- TransactionTypes | TransactionDate | datetime | 8 | NOT NULL | | --------------- | -------- | --- | -------- | Transaction Date | Amount | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Amount in Specified Currency Code | CurrencyCode | nvarchar(3) | 6 | NOT NULL | | ------------ | ----------- | --- | -------- | Currency Code - Map to dbo.Currencies | ModifiedBy | nvarchar(30) | 60 | NOT NULL | | ---------- | ------------ | --- | -------- | Record Last Modified By User | Notes | nvarchar(50) | 100 | NOT NULL | | ----- | ------------ | --- | -------- | Notes Indexes | Key Name | Key Columns | Unique | Compression | | --------------------------------- | ------------- | ------ | ----------- | | PK_CustomerAdjustments | TransactionID | True | PAGE | | IX_CustomerAdjustments_CustomerID | CustomerID | | PAGE | Used By
[dbo].[CustomerTransactions]¶
Tables > dbo.CustomerChangeLog¶
[dbo].[CustomerChangeLog]¶
MS_Description Log History For Changes in dbo.Customers Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------------- | --------- | ------------------ | ----------- | | CustomerChangeLogID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Last Record Modified Date | ModifiedBy | nvarchar(100) | 200 | NOT NULL | | ---------- | ------------- | --- | -------- | Last Record Modified By User | Detail | nvarchar(4000) | 8000 | NOT NULL | | ------ | -------------- | ---- | -------- | Detail From and To Values Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------------- | ------------------- | ------ | ----------- | | PK_CustomerChangeLog | CustomerChangeLogID | True | PAGE | | IX_CustomerChangeLog_CustomerID | CustomerID | | PAGE |
Tables > dbo.CustomerContacts¶
[dbo].[CustomerContacts]¶
MS_Description Customer Contact Info Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------------- | --------- | ------------------ | ----------- | | CustomerContactID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | FirstName | nvarchar(50) | 100 | NOT NULL | | --------- | ------------ | --- | -------- | Customer First Name | LastName | nvarchar(50) | 100 | NOT NULL | | -------- | ------------ | --- | -------- | Customer Last Name | Email | nvarchar(50) | 100 | NOT NULL | | ----- | ------------ | --- | -------- | Customer Email | Phone | nvarchar(20) | 40 | NOT NULL | | ----- | ------------ | --- | -------- | Customer Phone | Phone2 | nvarchar(20) | 40 | NOT NULL | | ------ | ------------ | --- | -------- | Customer Phone 2 | MobilePhone | nvarchar(20) | 40 | NOT NULL | | ----------- | ------------ | --- | -------- | Customer Mobile Phone | Fax | nvarchar(20) | 40 | NOT NULL | | --- | ------------ | --- | -------- | Customer Fax | Address1 | nvarchar(50) | 100 | NOT NULL | | -------- | ------------ | --- | -------- | Customer Address Field 1 | Address2 | nvarchar(50) | 100 | NOT NULL | | -------- | ------------ | --- | -------- | Customer Address Field 2 | City | nvarchar(50) | 100 | NOT NULL | | ---- | ------------ | --- | -------- | Customer City | State | nvarchar(20) | 40 | NOT NULL | | ----- | ------------ | --- | -------- | Customer State | Zip | nvarchar(20) | 40 | NOT NULL | | --- | ------------ | --- | -------- | Customer Zip | Country | nvarchar(10) | 20 | NOT NULL | | ------- | ------------ | --- | -------- | Customer Country | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date Indexes | Key Name | Key Columns | Unique | Compression | | ------------------- | ----------------- | ------ | ----------- | | PK_CustomerContacts | CustomerContactID | True | PAGE |
Tables > dbo.CustomerContacts¶
| IX_CustomerContacts_CustomerID | CustomerID | PAGE |
|---|---|---|
Tables > dbo.CustomerEventHistory¶
[dbo].[CustomerEventHistory]¶
MS_Description Customer Event History Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------- | --------- | ------------------ | ----------- | | CustomerEventID | int | 4 | NOT NULL | Customer Event ID - Map to dbo.CustomerEvents | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | Key1 | int | 4 | NOT NULL | | ---- | --- | --- | -------- | Custom Values | Key2 | int | 4 | NOT NULL | | ---- | --- | --- | -------- | Custom Values | Key3 | int | 4 | NOT NULL | | ---- | --- | --- | -------- | Custom Values | EntryDate | datetime | 8 | NOT NULL | | --------- | -------- | --- | -------- | Record Insert Date Indexes | Key Name | Key Columns | Unique | Compression | | ----------------------- | ----------------- | ------ | ----------- | | PK_CustomerEventHistory | CustomerEventID, | True | PAGE | CustomerID, Key1, Key2, Key3
Tables > dbo.CustomerEvents¶
[dbo].[CustomerEvents]¶
MS_Description Reference Data Used For Auto Responders Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------- | --------- | ------------------ | ----------- | | CustomerEventID | int | 4 | NOT NULL | Unique ID | CustomerEventDescription | nvarchar(50) | 100 | NOT NULL | | ------------------------ | ------------ | --- | -------- | Description | Key1Description | nvarchar(50) | 100 | NOT NULL | | --------------- | ------------ | --- | -------- | Custom Values | Key2Description | nvarchar(50) | 100 | NOT NULL | | --------------- | ------------ | --- | -------- | Custom Values | Key3Description | nvarchar(50) | 100 | NOT NULL | | --------------- | ------------ | --- | -------- | Custom Values | Notes | nvarchar(max) | max | NOT NULL | | ----- | ------------- | --- | -------- | Notes Indexes | Key Name | Key Columns | Unique | Compression | | ----------------- | --------------- | ------ | ----------- | | PK_CustomerEvents | CustomerEventID | True | PAGE |
Tables > dbo.CustomerExtendedChangeLogs¶
[dbo].[CustomerExtendedChangeLogs]¶
MS_Description History of Customer Extended Group Changes Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | --------------------------- | --------- | ------- | ----------- | | CustomerExtendedChangeLogId | int | 4 | NOT NULL | Unique ID | CustomerExtendedId | int | 4 | NOT NULL | | ------------------ | --- | --- | -------- | Customer Extended Detail ID - Map to dbo.CustomerExtended- Details | ExtendedGroupId | int | 4 | NOT NULL | | --------------- | --- | --- | -------- | Customer Extended Group ID - Map to dbo.CustomerExtended- Groups | CustomerId | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date | ModifiedBy | nvarchar(100) | 200 | NOT NULL | | ---------- | ------------- | --- | -------- | Record Last Modified By User | Detail | nvarchar(4000) | 8000 | NOT NULL | | ------ | -------------- | ---- | -------- | Detail From and To Values Indexes | Key Name | Key Columns | Unique | Compression | | ----------------------------- | ----------- | ------ | ----------- | | PK_CustomerExtendedChangeLogs | Customer- | True | PAGE | ExtendedChange- LogId | IX_CustomerExtendedChangeLogs_CustomerId | CustomerId | | PAGE | | ---------------------------------------- | ---------- | --- | ---- |
Tables > dbo.CustomerExtendedDetails¶
[dbo].[CustomerExtendedDetails]¶
MS_Description Fully Custom Fields For Customer Records Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | ------------------------ | --------- | ------- | ----------- | | CustomerExtendedDetailID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | CustomerExtendedGroupID | int | 4 | NOT NULL | | ----------------------- | --- | --- | -------- | Customer Extended Group ID - Map to dbo.CustomerExtended- Groups | Field1 | nvarchar(200) | 400 | NOT NULL | | ------ | ------------- | --- | -------- | Custom Field | Field2 | nvarchar(200) | 400 | NOT NULL | | ------ | ------------- | --- | -------- | Custom Field | Field3 | nvarchar(200) | 400 | NOT NULL | | ------ | ------------- | --- | -------- | Custom Field | Field4 | nvarchar(200) | 400 | NOT NULL | | ------ | ------------- | --- | -------- | Custom Field | Field5 | nvarchar(200) | 400 | NOT NULL | | ------ | ------------- | --- | -------- | Custom Field | Field6 | nvarchar(200) | 400 | NOT NULL | | ------ | ------------- | --- | -------- | Custom Field | Field7 | nvarchar(200) | 400 | NOT NULL | | ------ | ------------- | --- | -------- | Custom Field | Field8 | nvarchar(200) | 400 | NOT NULL | | ------ | ------------- | --- | -------- | Custom Field | Field9 | nvarchar(200) | 400 | NOT NULL | | ------ | ------------- | --- | -------- | Custom Field | Field10 | nvarchar(200) | 400 | NOT NULL | | ------- | ------------- | --- | -------- | Custom Field | Field11 | nvarchar(200) | 400 | NOT NULL | | ------- | ------------- | --- | -------- | Custom Field | Field12 | nvarchar(200) | 400 | NOT NULL | | ------- | ------------- | --- | -------- | Custom Field | Field13 | nvarchar(200) | 400 | NOT NULL | | ------- | ------------- | --- | -------- | Custom Field | Field14 | nvarchar(200) | 400 | NOT NULL | | ------- | ------------- | --- | -------- | Custom Field | Field15 | nvarchar(200) | 400 | NOT NULL | | ------- | ------------- | --- | -------- | Custom Field | Field16 | nvarchar(200) | 400 | NOT NULL | | ------- | ------------- | --- | -------- | Custom Field
Tables > dbo.CustomerExtendedDetails¶
| Field17 | nvarchar(200) | 400 | NOT NULL |
|---|---|---|---|
| Custom Field | |||
| Field18 | nvarchar(200) | 400 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Custom Field | |||
| Field19 | nvarchar(200) | 400 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Custom Field | |||
| Field20 | nvarchar(200) | 400 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Custom Field | |||
| Field21 | nvarchar(200) | 400 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Custom Field | |||
| Field22 | nvarchar(200) | 400 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Custom Field | |||
| Field23 | nvarchar(200) | 400 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Custom Field | |||
| Field24 | nvarchar(200) | 400 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Custom Field | |||
| Field25 | nvarchar(200) | 400 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Custom Field | |||
| Field26 | nvarchar(200) | 400 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Custom Field | |||
| Field27 | nvarchar(200) | 400 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Custom Field | |||
| Field28 | nvarchar(200) | 400 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Custom Field | |||
| Field29 | nvarchar(200) | 400 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Custom Field | |||
| Field30 | nvarchar(200) | 400 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Custom Field | |||
| ModifiedDate | datetime | 8 | NOT NULL |
| ------------ | -------- | --- | -------- |
| Record Last Modified Date | |||
| Indexes | |||
| Key Name | Key Columns | Unique | Compression |
| -------------------------- | ----------------- | ------ | ----------- |
| PK_CustomerExtendedDetails | CustomerExtended- | True | PAGE |
| DetailID | |||
| IX_CustomerExtendedDetails_CustomerID | CustomerID | PAGE | |
| ------------------------------------- | ---------- | --- | ---- |
Tables > dbo.CustomerExtendedGroups¶
[dbo].[CustomerExtendedGroups]¶
MS_Description Fully Custom Fields For Customer Groups Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------------------- | --------- | ------------------ | ----------- | | CustomerExtendedGroupID | int | 4 | NOT NULL | Unique ID | CustomerExtendedGroupDescription | nvarchar(100) | 200 | NOT NULL | | -------------------------------- | ------------- | --- | -------- | Group Description | Field1Name | nvarchar(100) | 200 | NOT NULL | | ---------- | ------------- | --- | -------- | Custom Field | Field2Name | nvarchar(100) | 200 | NOT NULL | | ---------- | ------------- | --- | -------- | Custom Field | Field3Name | nvarchar(100) | 200 | NOT NULL | | ---------- | ------------- | --- | -------- | Custom Field | Field4Name | nvarchar(100) | 200 | NOT NULL | | ---------- | ------------- | --- | -------- | Custom Field | Field5Name | nvarchar(100) | 200 | NOT NULL | | ---------- | ------------- | --- | -------- | Custom Field | Field6Name | nvarchar(100) | 200 | NOT NULL | | ---------- | ------------- | --- | -------- | Custom Field | Field7Name | nvarchar(100) | 200 | NOT NULL | | ---------- | ------------- | --- | -------- | Custom Field | Field8Name | nvarchar(100) | 200 | NOT NULL | | ---------- | ------------- | --- | -------- | Custom Field | Field9Name | nvarchar(100) | 200 | NOT NULL | | ---------- | ------------- | --- | -------- | Custom Field | Field10Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field11Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field12Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field13Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field14Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field15Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field16Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field17Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field18Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- |
Tables > dbo.CustomerExtendedGroups¶
Custom Field | Field19Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field20Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field21Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field22Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field23Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field24Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field25Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field26Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field27Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field28Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field29Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field | Field30Name | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Custom Field Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------- | ---------------------- | ------ | ----------- | | PK_CustomerExtendedGroups | CustomerExtendedGroup- | True | PAGE | ID
Tables > dbo.CustomerFieldNames¶
[dbo].[CustomerFieldNames]¶
MS_Description Custom Display Names For Fields in dbo.Customers Table Columns | Name | Data Type | Max Length (Bytes) | Nullability | | ----------------- | ------------ | ------------------ | ----------- | | Field1DisplayName | nvarchar(50) | 100 | NOT NULL | Custom Display Name for dbo.Customers.Field1 | Field2DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Field2 | Field3DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Field3 | Field4DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Field4 | Field5DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Field5 | Field6DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Field6 | Field7DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Field7 | Field8DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Field8 | Field9DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Field9 | Field10DisplayName | nvarchar(50) | 100 | NOT NULL | | ------------------ | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Field10 | Field11DisplayName | nvarchar(50) | 100 | NOT NULL | | ------------------ | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Field11 | Field12DisplayName | nvarchar(50) | 100 | NOT NULL | | ------------------ | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Field12 | Field13DisplayName | nvarchar(50) | 100 | NOT NULL | | ------------------ | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Field13 | Field14DisplayName | nvarchar(50) | 100 | NOT NULL | | ------------------ | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Field14 | Field15DisplayName | nvarchar(50) | 100 | NOT NULL | | ------------------ | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Field15 | Date1DisplayName | nvarchar(50) | 100 | NOT NULL | | ---------------- | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Date1 | Date2DisplayName | nvarchar(50) | 100 | NOT NULL | | ---------------- | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Date2 | Date3DisplayName | nvarchar(50) | 100 | NOT NULL | | ---------------- | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Date3 | Date4DisplayName | nvarchar(50) | 100 | NOT NULL | | ---------------- | ------------ | --- | -------- | Custom Display Name for dbo.Customers.Date4 | Date5DisplayName | nvarchar(50) | 100 | NOT NULL | | ---------------- | ------------ | --- | -------- |
Tables > dbo.CustomerFieldNames¶
Custom Display Name for dbo.Customers.Date5
Tables > dbo.CustomerInquiries¶
[dbo].[CustomerInquiries]¶
MS_Description Customer Inquiries Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | ----------------- | --------- | ------- | ----------- | | CustomerInquiryID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | CustomerInquiryTypeID | int | 4 | NOT NULL | | --------------------- | --- | --- | -------- | Customer Inquiry Type ID - Map to dbo.CustomerInquiryTypes | CustomerInquiryCategoryID | int | 4 | NULL allowed | | ------------------------- | --- | --- | ------------ | Customer Inquiry Category ID - Map to dbo.CustomerInquiry- Categories | CustomerInquiryStatusID | int | 4 | NOT NULL | | ----------------------- | --- | --- | -------- | Customer Inquiry Status ID - Map to dbo.CustomerInquiry- Statuses | ParentID | int | 4 | NULL allowed | | -------- | --- | --- | ------------ | Parent ID - Map to dbo.Customers | CreatedDate | datetime | 8 | NOT NULL | | ----------- | -------- | --- | -------- | Inquiry Record Created Date | Description | nvarchar(200) | 400 | NOT NULL | | ----------- | ------------- | --- | -------- | Inquiry Description | Detail | nvarchar(max) | max | NOT NULL | | ------ | ------------- | --- | -------- | Inquiry Details | CreatedBy | nvarchar(50) | 100 | NULL allowed | | --------- | ------------ | --- | ------------ | Inquiry Created By User | AssignedTo | nvarchar(50) | 100 | NULL allowed | | ---------- | ------------ | --- | ------------ | Inquiry Assigned To User | ClosedDate | datetime | 8 | NULL allowed | | ---------- | -------- | --- | ------------ | Inquiry Closed Date | ClosedBy | nvarchar(50) | 100 | NULL allowed | | -------- | ------------ | --- | ------------ | Inquiry Closed By User | Reference | nvarchar(200) | 400 | NOT NULL | | --------- | ------------- | --- | -------- | Reference Notes Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------------- | ----------------- | ------ | ----------- | | PK_CustomerInquiries | CustomerInquiryID | True | PAGE | | IX_CustomerInquiries_CustomerID | CustomerID | | PAGE |
Tables > dbo.CustomerInquiryCategories¶
[dbo].[CustomerInquiryCategories]¶
MS_Description Customer Inquiry Category Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------------------- | --------- | ------------------ | ----------- | | CustomerInquiryCategoryID | int | 4 | NOT NULL | Unique ID CustomerInquiryCategoryDescription nvarchar(100) 200 NOT NULL Description Indexes | Key Name | Key Columns | Unique | Compression | | ---------------------------- | ---------------- | ------ | ----------- | | PK_CustomerInquiryCategories | CustomerInquiry- | True | PAGE | CategoryID
Tables > dbo.CustomerInquiryStatuses¶
[dbo].[CustomerInquiryStatuses]¶
MS_Description Customer Inquiry Status Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------------------- | --------- | ------------------ | ----------- | | CustomerInquiryStatusID | int | 4 | NOT NULL | Unique ID | CustomerInquiryStatusDescription | nvarchar(50) | 100 | NOT NULL | | -------------------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | -------------------------- | ----------------------- | ------ | ----------- | | PK_CustomerInquiryStatuses | CustomerInquiryStatusID | True | PAGE |
Tables > dbo.CustomerInquiryTypes¶
[dbo].[CustomerInquiryTypes]¶
MS_Description Customer Inquiry Type Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------------- | --------- | ------------------ | ----------- | | CustomerInquiryTypeID | int | 4 | NOT NULL | Unique ID | CustomerInquiryTypeDescription | nvarchar(50) | 100 | NOT NULL | | ------------------------------ | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ----------------------- | --------------------- | ------ | ----------- | | PK_CustomerInquiryTypes | CustomerInquiryTypeID | True | PAGE |
Tables > dbo.CustomerLeads¶
[dbo].[CustomerLeads]¶
MS_Description Customer Sales Leads Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------------- | --------- | ------------------ | ----------- | | CustomerLeadID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | FirstName | nvarchar(50) | 100 | NOT NULL | | --------- | ------------ | --- | -------- | First Name | LastName | nvarchar(50) | 100 | NOT NULL | | -------- | ------------ | --- | -------- | Last Name | Company | nvarchar(50) | 100 | NOT NULL | | ------- | ------------ | --- | -------- | Company | Email | nvarchar(50) | 100 | NOT NULL | | ----- | ------------ | --- | -------- | Email | Phone | nvarchar(50) | 100 | NOT NULL | | ----- | ------------ | --- | -------- | Phone | Phone2 | nvarchar(50) | 100 | NOT NULL | | ------ | ------------ | --- | -------- | Phone 2 | MobilePhone | nvarchar(50) | 100 | NOT NULL | | ----------- | ------------ | --- | -------- | Mobile Phone | Fax | nvarchar(50) | 100 | NOT NULL | | --- | ------------ | --- | -------- | Fax | Address1 | nvarchar(50) | 100 | NOT NULL | | -------- | ------------ | --- | -------- | Address Field 1 | Address2 | nvarchar(50) | 100 | NOT NULL | | -------- | ------------ | --- | -------- | Address Field 2 | City | nvarchar(50) | 100 | NOT NULL | | ---- | ------------ | --- | -------- | City | State | nvarchar(50) | 100 | NOT NULL | | ----- | ------------ | --- | -------- | State | Zip | nvarchar(50) | 100 | NOT NULL | | --- | ------------ | --- | -------- | Zip | Country | nvarchar(50) | 100 | NOT NULL | | ------- | ------------ | --- | -------- | Country | BirthDate | datetime | 8 | NULL allowed | | --------- | -------- | --- | ------------ | DOB | Notes | nvarchar(2000) | 4000 | NOT NULL | | ----- | -------------- | ---- | -------- | Notes | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date
Tables > dbo.CustomerLeads¶
Indexes | Key Name | Key Columns | Unique Compression | | --------------------------- | -------------- | ------------------ | | PK_CustomerLeads | CustomerLeadID | True PAGE | | IX_CustomerLeads_CustomerID | CustomerID | PAGE |
Tables > dbo.CustomerOverrides¶
[dbo].[CustomerOverrides]¶
MS_Description Commissions Overrides Per Customer Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | PlanID | int | 4 | NOT NULL | Plan ID - Map to dbo.CommissionRuns | OverrideID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Override ID - Map to dbo.CommissionOverrides | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | Qualifies | bit | 1 | NOT NULL | | --------- | --- | --- | -------- | Qualifies? Boolean | PeriodTypeID | int | 4 | NULL allowed | | ------------ | --- | --- | ------------ | Period Type ID - Map to dbo.PeriodTypes | StartPeriodID | int | 4 | NULL allowed | | ------------- | --- | --- | ------------ | Period ID When Override Starts To Apply | EndPeriodID | int | 4 | NULL allowed | | ----------- | --- | --- | ------------ | Period ID When Override Ends | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date | Amount | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Override Amount Indexes | Key Name | Key Columns | | Unique Compression | | -------------------- | -------------------- | --- | ------------------ | | PK_CustomerOverrides | PlanID, OverrideID, | | True PAGE | CustomerID
Tables > dbo.CustomerPayoutSettings¶
[dbo].[CustomerPayoutSettings]¶
MS_Description Customer Payout Settings Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | ---------- | --------- | ------- | ----------- | | CustomerID | int | 4 | NOT NULL | Customer ID - Map to dbo.Customers | Produce1099 | bit | 1 | NOT NULL | | ----------- | --- | --- | -------- | Produce 1099? Boolean | TaxAddressTypeID | int | 4 | NOT NULL | | ---------------- | --- | --- | -------- | Tax Address Type ID - Map to dbo.TaxAddressTypes | TaxNameTypeID | int | 4 | NOT NULL | | ------------- | --- | --- | -------- | Tax Name Type ID - Map to dbo.TaxNameTypes | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date | ModifiedBy | nvarchar(30) | 60 | NOT NULL | | ---------- | ------------ | --- | -------- | Record Last Modified By User Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------- | ----------- | ------ | ----------- | | PK_CustomerPayoutSettings | CustomerID | True | PAGE |
Tables > dbo.CustomerPointAccounts¶
[dbo].[CustomerPointAccounts]¶
MS_Description Customer Point Accounts Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------------- | --------- | ------------------ | ----------- | | PointAccountID | int | 4 | NOT NULL | Point Account ID - Map to dbo.PointAccounts | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | PointBalance | money | 8 | NOT NULL | | ------------ | ----- | --- | -------- | Point Balance Amount Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------ | ------------------------- | ------ | ----------- | | PK_CustomerPointAccounts | PointAccountID, Customer- | True | PAGE | ID
Tables > dbo.CustomerRankChangeLog¶
[dbo].[CustomerRankChangeLog]¶
MS_Description Customer Rank Change History Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------------------- | --------- | ------------------ | ----------- | | CustomerRankChangeLogID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | RankID | int | 4 | NULL allowed | | ------ | --- | --- | ------------ | Rank ID - Map to dbo.Ranks | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date Indexes | Key Name | Key Columns | | Unique Compression | | ------------------------ | ------------- | --- | ------------------ | | PK_CustomerRankChangeLog | CustomerRank- | | True PAGE | ChangeLogID | IX_CustomerRankChangeLog_CustomerID | CustomerID | | PAGE | | ----------------------------------- | ---------- | --- | ---- |
Tables > dbo.Customers¶
[dbo].[Customers]¶
MS_Description Customers Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | ---------- | --------- | ------- | ----------- | | CustomerID | int | 4 | NOT NULL | Unique ID | FirstName | nvarchar(50) | 100 | NOT NULL | | --------- | ------------ | --- | -------- | First Name | MiddleName | nvarchar(50) | 100 | NOT NULL | | ---------- | ------------ | --- | -------- | Middle Name | LastName | nvarchar(50) | 100 | NOT NULL | | -------- | ------------ | --- | -------- | Last Name | NameSuffix | nvarchar(50) | 100 | NOT NULL | | ---------- | ------------ | --- | -------- | Name Suffix | Company | nvarchar(100) | 200 | NOT NULL | | ------- | ------------- | --- | -------- | Company (Optional) | CustomerTypeID | int | 4 | NOT NULL | | -------------- | --- | --- | -------- | Customer Type ID - Map to dbo.CustomerTypes | CustomerStatusID | int | 4 | NOT NULL | | ---------------- | --- | --- | -------- | Customer Status ID - Map to dbo.CustomerStatuses | Email | nvarchar(50) | 100 | NOT NULL | | ----- | ------------ | --- | -------- | Email | Phone | nvarchar(20) | 40 | NOT NULL | | ----- | ------------ | --- | -------- | Phone | Phone2 | nvarchar(20) | 40 | NOT NULL | | ------ | ------------ | --- | -------- | Phone 2 | MobilePhone | nvarchar(20) | 40 | NOT NULL | | ----------- | ------------ | --- | -------- | Mobile Phone | Fax | nvarchar(20) | 40 | NOT NULL | | --- | ------------ | --- | -------- | Fax | MainAddress1 | nvarchar(100) | 200 | NOT NULL | | ------------ | ------------- | --- | -------- | Main Address Line 1 | MainAddress2 | nvarchar(100) | 200 | NULL allowed | | ------------ | ------------- | --- | ------------ | Main Address Line 2 | MainAddress3 | nvarchar(100) | 200 | NOT NULL | | ------------ | ------------- | --- | -------- | Main Address Line 3 | MainCity | nvarchar(50) | 100 | NOT NULL | | -------- | ------------ | --- | -------- | Main City | MainState | nvarchar(50) | 100 | NOT NULL | | --------- | ------------ | --- | -------- | Main State | MainZip | nvarchar(50) | 100 | NOT NULL | | ------- | ------------ | --- | -------- | Main Zip
Tables > dbo.Customers¶
| MainCountry | nvarchar(50) | 100 | NOT NULL |
|---|---|---|---|
| Main Country | |||
| MainCounty | nvarchar(50) | 100 | NOT NULL |
| ---------- | ------------ | --- | -------- |
| Main County | |||
| MainVerified | bit | 1 | NOT NULL |
| ------------ | --- | --- | -------- |
| Main Verified? Boolean | |||
| MailAddress1 | nvarchar(100) | 200 | NOT NULL |
| ------------ | ------------- | --- | -------- |
| Mail Address Line 1 | |||
| MailAddress2 | nvarchar(100) | 200 | NULL allowed |
| ------------ | ------------- | --- | ------------ |
| Mail Address Line 2 | |||
| MailAddress3 | nvarchar(100) | 200 | NOT NULL |
| ------------ | ------------- | --- | -------- |
| Mail Address Line 3 | |||
| MailCity | nvarchar(50) | 100 | NOT NULL |
| -------- | ------------ | --- | -------- |
| Mail City | |||
| MailState | nvarchar(50) | 100 | NOT NULL |
| --------- | ------------ | --- | -------- |
| Mail State | |||
| MailZip | nvarchar(50) | 100 | NOT NULL |
| ------- | ------------ | --- | -------- |
| Mail Zip | |||
| MailCountry | nvarchar(50) | 100 | NOT NULL |
| ----------- | ------------ | --- | -------- |
| Mail Country | |||
| MailCounty | nvarchar(50) | 100 | NOT NULL |
| ---------- | ------------ | --- | -------- |
| Mail County | |||
| MailVerified | bit | 1 | NOT NULL |
| ------------ | --- | --- | -------- |
| Mail Verified? Boolean | |||
| OtherAddress1 | nvarchar(100) | 200 | NOT NULL |
| ------------- | ------------- | --- | -------- |
| Other Address Line 1 | |||
| OtherAddress2 | nvarchar(100) | 200 | NULL allowed |
| ------------- | ------------- | --- | ------------ |
| Other Address Line 2 | |||
| OtherAddress3 | nvarchar(100) | 200 | NOT NULL |
| ------------- | ------------- | --- | -------- |
| Other Address Line 3 | |||
| OtherCity | nvarchar(50) | 100 | NOT NULL |
| --------- | ------------ | --- | -------- |
| Other City | |||
| OtherState | nvarchar(50) | 100 | NOT NULL |
| ---------- | ------------ | --- | -------- |
| Other State | |||
| OtherZip | nvarchar(50) | 100 | NOT NULL |
| -------- | ------------ | --- | -------- |
| Other Zip | |||
| OtherCountry | nvarchar(50) | 100 | NOT NULL |
| ------------ | ------------ | --- | -------- |
| Other Country | |||
| OtherCounty | nvarchar(50) | 100 | NOT NULL |
| ----------- | ------------ | --- | -------- |
| Other County | |||
| OtherVerified | bit | 1 | NOT NULL |
| ------------- | --- | --- | -------- |
| Other Verified? Boolean | |||
| CanLogin | bit | 1 | NOT NULL |
| -------- | --- | --- | -------- |
| Can Login? Boolean | |||
| LoginName | nvarchar(100) | 200 | NULL allowed |
| --------- | ------------- | --- | ------------ |
| Login Name | |||
| PasswordHash | varbinary(50) | 50 | NULL allowed |
| ------------ | ------------- | --- | ------------ |
| Password Hash - Hashed version of the customer password | |||
| RankID | int | 4 | NULL allowed |
| ------ | --- | --- | ------------ |
| Highest Ever Rank ID as of Last Accepted Period - Map to | |||
| dbo.Ranks |
Tables > dbo.Customers¶
| EnrollerID | int | 4 | NULL allowed |
|---|---|---|---|
| Current Enroller | |||
| SponsorID | int | 4 | NULL allowed |
| --------- | --- | --- | ------------ |
| Current Sponsor | |||
| BirthDate | datetime | 8 | NULL allowed |
| --------- | -------- | --- | ------------ |
| DOB | |||
| CurrencyCode | nvarchar(3) | 6 | NOT NULL |
| ------------ | ----------- | --- | -------- |
| Currency Code Used For Payouts | |||
| PayableToName | nvarchar(50) | 100 | NOT NULL |
| ------------- | ------------ | --- | -------- |
| Name Used For Payouts | |||
| DefaultWarehouseID | int | 4 | NULL allowed |
| ------------------ | --- | --- | ------------ |
| Default Warehouse ID - Map to dbo.Warehouses | |||
| PayableTypeID | int | 4 | NOT NULL |
| ------------- | --- | --- | -------- |
| Payable Type ID - Map to dbo.PayoutTypes | |||
| CheckThreshold | money | 8 | NOT NULL |
| -------------- | ----- | --- | -------- |
| Minimum Amount To Initiate a Payout | |||
| LanguageID | int | 4 | NULL allowed |
| ---------- | --- | --- | ------------ |
| Language ID - Map to dbo.Languages | |||
| Gender | nvarchar(1) | 2 | NOT NULL |
| ------ | ----------- | --- | -------- |
| Gender (M/F) | |||
| TaxCode | nvarchar(50) | 100 | NULL allowed |
| ------- | ------------ | --- | ------------ |
| Tax Code (SSN/TaxID/etc.) - Masked | |||
| TaxCodeTypeID | int | 4 | NOT NULL |
| ------------- | --- | --- | -------- |
| Tax Code Type ID - Map to dbo.TaxCodeTypes | |||
| IsSalesTaxExempt | bit | 1 | NOT NULL |
| ---------------- | --- | --- | -------- |
| Is Sales Tax Exempt? Boolean | |||
| SalesTaxCode | nvarchar(50) | 100 | NULL allowed |
| ------------ | ------------ | --- | ------------ |
| Sales Tax Code - Masked | |||
| SalesTaxExemptExpireDate | datetime | 8 | NULL allowed |
| ------------------------ | -------- | --- | ------------ |
| Sales Tax Exemption Expire Date | |||
| VatRegistration | nvarchar(50) | 100 | NOT NULL |
| --------------- | ------------ | --- | -------- |
| VAT Registration | |||
| BinaryPlacementTypeID | int | 4 | NOT NULL |
| --------------------- | --- | --- | -------- |
| Binary Placement Type ID - Map to dbo.BinaryPlacement- | |||
| Types | |||
| UseBinaryHoldingTank | bit | 1 | NOT NULL |
| -------------------- | --- | --- | -------- |
| Use Binary Holding Tank? Boolean | |||
| IsInBinaryHoldingTank | bit | 1 | NOT NULL |
| --------------------- | --- | --- | -------- |
| Is In Binary Holding Tank? Boolean | |||
| IsEmailSubscribed | bit | 1 | NULL allowed |
| ----------------- | --- | --- | ------------ |
| Is Email Subscribed? Boolean | |||
| EmailSubscribeIP | nvarchar(50) | 100 | NULL allowed |
| ---------------- | ------------ | --- | ------------ |
| Email Subscribe IP Address | |||
| IsSMSSubscribed | bit | 1 | NULL allowed |
| --------------- | --- | --- | ------------ |
| Is SMS Subscribed? Boolean | |||
| Notes | nvarchar(max) | max | NULL allowed |
| ----- | ------------- | --- | ------------ |
| Notes | |||
| Field1 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Custom Field - Map to dbo.CustomerFieldNames | |||
| Field2 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Custom Field - Map to dbo.CustomerFieldNames | |||
| Field3 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
Tables > dbo.Customers¶
Custom Field - Map to dbo.CustomerFieldNames | Field4 | nvarchar(100) | 200 | NOT NULL | | ------ | ------------- | --- | -------- | Custom Field - Map to dbo.CustomerFieldNames | Field5 | nvarchar(100) | 200 | NOT NULL | | ------ | ------------- | --- | -------- | Custom Field - Map to dbo.CustomerFieldNames | Field6 | nvarchar(100) | 200 | NOT NULL | | ------ | ------------- | --- | -------- | Custom Field - Map to dbo.CustomerFieldNames | Field7 | nvarchar(100) | 200 | NOT NULL | | ------ | ------------- | --- | -------- | Custom Field - Map to dbo.CustomerFieldNames | Field8 | nvarchar(100) | 200 | NOT NULL | | ------ | ------------- | --- | -------- | Custom Field - Map to dbo.CustomerFieldNames | Field9 | nvarchar(100) | 200 | NOT NULL | | ------ | ------------- | --- | -------- | Custom Field - Map to dbo.CustomerFieldNames | Field10 | nvarchar(100) | 200 | NOT NULL | | ------- | ------------- | --- | -------- | Custom Field - Map to dbo.CustomerFieldNames | Field11 | nvarchar(100) | 200 | NOT NULL | | ------- | ------------- | --- | -------- | Custom Field - Map to dbo.CustomerFieldNames | Field12 | nvarchar(100) | 200 | NOT NULL | | ------- | ------------- | --- | -------- | Custom Field - Map to dbo.CustomerFieldNames | Field13 | nvarchar(100) | 200 | NOT NULL | | ------- | ------------- | --- | -------- | Custom Field - Map to dbo.CustomerFieldNames | Field14 | nvarchar(100) | 200 | NOT NULL | | ------- | ------------- | --- | -------- | Custom Field - Map to dbo.CustomerFieldNames | Field15 | nvarchar(100) | 200 | NOT NULL | | ------- | ------------- | --- | -------- | Custom Field - Map to dbo.CustomerFieldNames | Date1 | datetime | 8 | NULL allowed | | ----- | -------- | --- | ------------ | Custom Field - Map to dbo.CustomerFieldNames | Date2 | datetime | 8 | NULL allowed | | ----- | -------- | --- | ------------ | Custom Field - Map to dbo.CustomerFieldNames | Date3 | datetime | 8 | NULL allowed | | ----- | -------- | --- | ------------ | Custom Field - Map to dbo.CustomerFieldNames | Date4 | datetime | 8 | NULL allowed | | ----- | -------- | --- | ------------ | Custom Field - Map to dbo.CustomerFieldNames | Date5 | datetime | 8 | NULL allowed | | ----- | -------- | --- | ------------ | Custom Field - Map to dbo.CustomerFieldNames | CreatedDate | datetime | 8 | NOT NULL | | ----------- | -------- | --- | -------- | Record Created Date | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date | CreatedBy | nvarchar(30) | 60 | NOT NULL | | --------- | ------------ | --- | -------- | Record Created By User | ModifiedBy | nvarchar(30) | 60 | NOT NULL | | ---------- | ------------ | --- | -------- | Record Last Modified By User | EmailUnsubscribeDate | datetime | 8 | NULL allowed | | -------------------- | -------- | --- | ------------ | Email Unsubscribe Date | EmailSubscribeDate | datetime | 8 | NULL allowed | | ------------------ | -------- | --- | ------------ | Email Subscribe Date | SMSSubscribeDate | datetime | 8 | NULL allowed | | ---------------- | -------- | --- | ------------ | SMS Subscribe Date | SMSUnsubscribeDate | datetime | 8 | NULL allowed | | ------------------ | -------- | --- | ------------ | SMS Unsubscribe Date
Tables > dbo.Customers¶
| TerminationReason | int | 4 | NULL allowed |
|---|---|---|---|
| Termination Reason ID - Map to dbo.CustomerTermination- | |||
| Reasons | |||
| CustomerKey | nvarchar(50) | 100 | NULL allowed |
| ----------- | ------------ | --- | ------------ |
| Customer Key (Typically Blank Unless Used by Client) | |||
| Indexes | |||
| Key Name | Key Columns | Unique | Compression |
| ----------------------------- | ---------------- | ------ | ----------- |
| PK_Customers | CustomerID | True | PAGE |
| IX_Customers_CustomerStatusID | CustomerStatusID | PAGE | |
| IX_Customers_CustomerTypeID | CustomerTypeID | PAGE | |
| IX_Customers_EnrollerID | EnrollerID | PAGE | |
| IX_Customers_LoginName | LoginName | PAGE | |
| Used By |
[dbo].[AuthenticateCustomer]¶
[queue].[Refresh]¶
Tables > dbo.CustomerSiteChangeLog¶
[dbo].[CustomerSiteChangeLog]¶
Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------------------- | ------------- | ------------------ | ----------- | | CustomerSiteChangeLogID | int | 4 | NOT NULL | | CustomerID | int | 4 | NOT NULL | | ModifiedDate | datetime | 8 | NOT NULL | | ModifiedBy | nvarchar(50) | 100 | NOT NULL | | Detail | nvarchar(max) | max | NOT NULL | Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------ | ------------- | ------ | ----------- | | PK_CustomerSiteChangeLog | CustomerSite- | True | PAGE | ChangeLogID | IX_CustomerSiteChangeLog_CustomerID | CustomerID | | PAGE | | ----------------------------------- | ---------- | --- | ---- |
Tables > dbo.CustomerSites¶
[dbo].[CustomerSites]¶
MS_Description Replicated Site Population Data Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------- | --------- | ------------------ | ----------- | | CustomerID | int | 4 | NOT NULL | Customer ID - Map to dbo.Customers | WebAlias | nvarchar(100) | 200 | NOT NULL | | -------- | ------------- | --- | -------- | Web Alias Name | FirstName | nvarchar(100) | 200 | NOT NULL | | --------- | ------------- | --- | -------- | First Name | LastName | nvarchar(100) | 200 | NOT NULL | | -------- | ------------- | --- | -------- | Last Name | Company | nvarchar(255) | 510 | NOT NULL | | ------- | ------------- | --- | -------- | Company (Optional) | Email | nvarchar(100) | 200 | NOT NULL | | ----- | ------------- | --- | -------- | Email | Phone | nvarchar(100) | 200 | NOT NULL | | ----- | ------------- | --- | -------- | Phone | Phone2 | nvarchar(100) | 200 | NOT NULL | | ------ | ------------- | --- | -------- | Phone 2 | Fax | nvarchar(100) | 200 | NOT NULL | | --- | ------------- | --- | -------- | Fax | Address1 | nvarchar(200) | 400 | NOT NULL | | -------- | ------------- | --- | -------- | Address Line 1 | Address2 | nvarchar(200) | 400 | NOT NULL | | -------- | ------------- | --- | -------- | Address Line 2 | City | nvarchar(100) | 200 | NOT NULL | | ---- | ------------- | --- | -------- | City | State | nvarchar(100) | 200 | NOT NULL | | ----- | ------------- | --- | -------- | State | Zip | nvarchar(100) | 200 | NOT NULL | | --- | ------------- | --- | -------- | Zip | Country | nvarchar(50) | 100 | NOT NULL | | ------- | ------------ | --- | -------- | Country | Notes1 | nvarchar(max) | max | NOT NULL | | ------ | ------------- | --- | -------- | Notes 1 | Notes2 | nvarchar(max) | max | NOT NULL | | ------ | ------------- | --- | -------- | Notes 2 | Notes3 | nvarchar(max) | max | NOT NULL | | ------ | ------------- | --- | -------- | Notes 3 | Notes4 | nvarchar(max) | max | NOT NULL | | ------ | ------------- | --- | -------- | Notes 4 | Url1 | nvarchar(200) | 400 | NOT NULL | | ---- | ------------- | --- | -------- |
Tables > dbo.CustomerSites¶
URL 1 | Url2 | nvarchar(200) | 400 | NOT NULL | | ---- | ------------- | --- | -------- | URL 2 | Url3 | nvarchar(200) | 400 | NOT NULL | | ---- | ------------- | --- | -------- | URL 3 | Url4 | nvarchar(200) | 400 | NOT NULL | | ---- | ------------- | --- | -------- | URL 4 | Url5 | nvarchar(200) | 400 | NOT NULL | | ---- | ------------- | --- | -------- | URL 5 | Url6 | nvarchar(200) | 400 | NOT NULL | | ---- | ------------- | --- | -------- | URL 6 | Url7 | nvarchar(200) | 400 | NOT NULL | | ---- | ------------- | --- | -------- | URL 7 | Url8 | nvarchar(200) | 400 | NOT NULL | | ---- | ------------- | --- | -------- | URL 8 | Url9 | nvarchar(200) | 400 | NOT NULL | | ---- | ------------- | --- | -------- | URL 9 | Url10 | nvarchar(200) | 400 | NOT NULL | | ----- | ------------- | --- | -------- | URL 10 | Url1Description | nvarchar(200) | 400 | NOT NULL | | --------------- | ------------- | --- | -------- | URL 1 Description | Url2Description | nvarchar(200) | 400 | NOT NULL | | --------------- | ------------- | --- | -------- | URL 2 Description | Url3Description | nvarchar(200) | 400 | NOT NULL | | --------------- | ------------- | --- | -------- | URL 3 Description | Url4Description | nvarchar(200) | 400 | NOT NULL | | --------------- | ------------- | --- | -------- | URL 4 Description | Url5Description | nvarchar(200) | 400 | NOT NULL | | --------------- | ------------- | --- | -------- | URL 5 Description | Url6Description | nvarchar(200) | 400 | NOT NULL | | --------------- | ------------- | --- | -------- | URL 6 Description | Url7Description | nvarchar(200) | 400 | NOT NULL | | --------------- | ------------- | --- | -------- | URL 7 Description | Url8Description | nvarchar(200) | 400 | NOT NULL | | --------------- | ------------- | --- | -------- | URL 8 Description | Url9Description | nvarchar(200) | 400 | NOT NULL | | --------------- | ------------- | --- | -------- | URL 9 Description | Url10Description | nvarchar(200) | 400 | NOT NULL | | ---------------- | ------------- | --- | -------- | URL 10 Description | DataImage1 | varbinary(max) | max | NULL allowed | | ---------- | -------------- | --- | ------------ | Data Image 1 | DataImageType1 | nvarchar(200) | 400 | NULL allowed | | -------------- | ------------- | --- | ------------ | Data Image Type 1 | DataImage2 | varbinary(max) | max | NULL allowed | | ---------- | -------------- | --- | ------------ | Data Image 2 | DataImageType2 | nvarchar(200) | 400 | NULL allowed | | -------------- | ------------- | --- | ------------ | Data Image Type 2 | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date
Tables > dbo.CustomerSites¶
Indexes | Key Name | Key Columns | Unique Compression | | ------------------------- | ----------- | ------------------ | | PK_CustomerSites | CustomerID | True PAGE | | IX_CustomerSites_WebAlias | WebAlias | PAGE | Used By
[queue].[Refresh]¶
Tables > dbo.CustomerSocialNetworks¶
[dbo].[CustomerSocialNetworks]¶
MS_Description Customer Social Networks Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------- | --------- | ------------------ | ----------- | | CustomerID | int | 4 | NOT NULL | Customer ID - Map to dbo.Customers | SocialNetworkID | int | 4 | NOT NULL | | --------------- | --- | --- | -------- | Social Network ID - Map to dbo.SolcialNetworks | Url | nvarchar(500) | 1000 | NULL allowed | | --- | ------------- | ---- | ------------ | URL or Handle | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------- | ------------------- | ------ | ----------- | | PK_CustomerSocialNetworks | CustomerID, Social- | True | PAGE | NetworkID
Tables > dbo.CustomerStatusChangeLog¶
[dbo].[CustomerStatusChangeLog]¶
MS_Description History of Customer Status Changes Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | ------------------------- | --------- | ------- | ----------- | | CustomerStatusChangeLogID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | CustomerStatusID | int | 4 | NOT NULL | | ---------------- | --- | --- | -------- | Customer Status ID - Map to dbo.CustomerStatuses | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date | ModifiedBy | nvarchar(50) | 100 | NOT NULL | | ---------- | ------------ | --- | -------- | Record Last Modified By User Indexes | Key Name | Key Columns | Unique | Compression | | -------------------------- | --------------- | ------ | ----------- | | PK_CustomerStatusChangeLog | CustomerStatus- | True | PAGE | ChangeLogID | IX_CustomerStatusChangeLog_CustomerID | CustomerID | | PAGE | | ------------------------------------- | ---------- | --- | ---- |
Tables > dbo.CustomerStatuses¶
[dbo].[CustomerStatuses]¶
MS_Description Customer Status Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------------- | --------- | ------------------ | ----------- | | CustomerStatusID | int | 4 | NOT NULL | Unique ID | CustomerStatusDescription | nvarchar(50) | 100 | NOT NULL | | ------------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ------------------- | ---------------- | ------ | ----------- | | PK_CustomerStatuses | CustomerStatusID | True | PAGE |
Tables > dbo.CustomerSubscriptions¶
[dbo].[CustomerSubscriptions]¶
MS_Description Customer Subscriptions Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------------- | --------- | ------------------ | ----------- | | SubscriptionID | int | 4 | NOT NULL | Subscription ID - Map to dbo.Subscriptions | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | IsActive | bit | 1 | NOT NULL | | -------- | --- | --- | -------- | Is Active? Boolean | StartDate | datetime | 8 | NOT NULL | | --------- | -------- | --- | -------- | Subscription Start Date | ExpireDate | datetime | 8 | NOT NULL | | ---------- | -------- | --- | -------- | Subscription Expiration Date | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------ | ------------------------- | ------ | ----------- | | PK_CustomerSubscriptions | SubscriptionID, Customer- | True | PAGE | ID
Tables > dbo.CustomerTempAuthRequests¶
[dbo].[CustomerTempAuthRequests]¶
MS_Description Local Authentication Caching Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------------------- | --------- | ------------------ | ----------- | | CustomerTempAuthRequestId | int | 4 | NOT NULL | Unique ID | CustomerId | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | Token | varbinary(255) | 255 | NOT NULL | | ----- | -------------- | --- | -------- | Token | RequestBy | int | 4 | NOT NULL | | --------- | --- | --- | -------- | Request By User ID | RequestDate | datetime | 8 | NOT NULL | | ----------- | -------- | --- | -------- | Request Date | RequestClientIp | nvarchar(15) | 30 | NULL allowed | | --------------- | ------------ | --- | ------------ | Requesting Client IP Address | RequestSessionId | uniqueidentifier | 16 | NULL allowed | | ---------------- | ---------------- | --- | ------------ | Request Session ID | ClaimDate | datetime | 8 | NULL allowed | | --------- | -------- | --- | ------------ | Claim Date Indexes | Key Name | Key Columns | | Unique Compression | | --------------------------- | ----------------- | --- | ------------------ | | PK_CustomerTempAuthRequests | CustomerTempAuth- | | True PAGE | RequestId
Tables > dbo.CustomerTerminationReasons¶
[dbo].[CustomerTerminationReasons]¶
MS_Description Customer Termination Reasons Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | ReasonID | int | 4 | NOT NULL | Unique ID | Reason | nvarchar(256) | 512 | NOT NULL | | ------ | ------------- | --- | -------- | Reason Text Indexes | Key Name | Key Columns | Unique | Compression | | ----------------------------- | ----------- | ------ | ----------- | | PK_CustomerTerminationReasons | ReasonID | True | PAGE |
Tables > dbo.CustomerTransactionTypes¶
[dbo].[CustomerTransactionTypes]¶
MS_Description Customer Transaction Types Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------------------- | --------- | ------------------ | ----------- | | CustomerTransactionTypeID | int | 4 | NOT NULL | Unique ID | CustomerTransactionTypeDescription | nvarchar(50) | 100 | NOT NULL | | ---------------------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | --------------------------- | -------------------- | ------ | ----------- | | PK_CustomerTransactionTypes | CustomerTransaction- | True | PAGE | TypeID
Tables > dbo.CustomerTypeChangeLog¶
[dbo].[CustomerTypeChangeLog]¶
MS_Description History of Customer Type Changes Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | ----------------------- | --------- | ------- | ----------- | | CustomerTypeChangeLogID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | CustomerTypeID | int | 4 | NOT NULL | | -------------- | --- | --- | -------- | Customer Type ID - Map to dbo.CustomerTypes | PrevousCustomerTypeID | int | 4 | NULL allowed | | --------------------- | --- | --- | ------------ | Previous Customer Type ID - Map to dbo.CustomerTypes | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date | ModifiedBy | nvarchar(50) | 100 | NOT NULL | | ---------- | ------------ | --- | -------- | Record Last Modified By User Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------ | ------------- | ------ | ----------- | | PK_CustomerTypeChangeLog | CustomerType- | True | PAGE | ChangeLogID | IX_CustomerTypeChangeLog_CustomerID | CustomerID | | PAGE | | ----------------------------------- | ---------- | --- | ---- |
Tables > dbo.CustomerTypes¶
[dbo].[CustomerTypes]¶
MS_Description Customer Types Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------------- | --------- | ------------------ | ----------- | | CustomerTypeID | int | 4 | NOT NULL | Unique ID | CustomerTypeDescription | nvarchar(50) | 100 | NOT NULL | | ----------------------- | ------------ | --- | -------- | Description | PriceTypeID | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Price Type ID - Map to dbo.PriceTypes Indexes | Key Name | Key Columns | Unique | Compression | | ---------------- | -------------- | ------ | ----------- | | PK_CustomerTypes | CustomerTypeID | True | PAGE |
Tables > dbo.CustomerWall¶
[dbo].[CustomerWall]¶
MS_Description Downline Events Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------------ | --------- | ------------------ | ----------- | | CustomerWallItemID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | EntryDate | datetime | 8 | NOT NULL | | --------- | -------- | --- | -------- | Record Create Date | Text | nvarchar(2000) | 4000 | NOT NULL | | ---- | -------------- | ---- | -------- | Event Detail | Field1 | nvarchar(50) | 100 | NULL allowed | | ------ | ------------ | --- | ------------ | Custom Field 1 | Field2 | nvarchar(50) | 100 | NULL allowed | | ------ | ------------ | --- | ------------ | Custom Field 2 | Field3 | nvarchar(50) | 100 | NULL allowed | | ------ | ------------ | --- | ------------ | Custom Field 3 Indexes | Key Name | Key Columns | | Unique Compression | | -------------------------- | ------------------ | --- | ------------------ | | PK_CustomerWall | CustomerWallItemID | | True PAGE | | IX_CustomerWall_CustomerID | CustomerID | | PAGE |
Tables > dbo.Departments¶
[dbo].[Departments]¶
MS_Description User Departments Columns | Name | Data Type | Max Length (Bytes) | Nullability | | ------------ | --------- | ------------------ | ----------- | | DepartmentID | int | 4 | NOT NULL | Unique ID | DepartmentDescription | nvarchar(50) | 100 | NOT NULL | | --------------------- | ------------ | --- | -------- | Description
Tables > dbo.EmailOutLog¶
[dbo].[EmailOutLog]¶
MS_Description Email Sent Logs Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------- | --------- | ------------------ | ----------- | | OutMailID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NULL allowed | | ---------- | --- | --- | ------------ | Customer ID - Map to dbo.Customers | SubmitDate | datetime | 8 | NOT NULL | | ---------- | -------- | --- | -------- | Email Submit Date | MailTo | nvarchar(200) | 400 | NOT NULL | | ------ | ------------- | --- | -------- | Email To Email Address | Subject | nvarchar(200) | 400 | NOT NULL | | ------- | ------------- | --- | -------- | Email Subject | BroadCastID | int | 4 | NULL allowed | | ----------- | --- | --- | ------------ | Broadcast ID - Map to dbo.Broadcasts | DeliveryStatus | nvarchar(500) | 1000 | NOT NULL | | -------------- | ------------- | ---- | -------- | Delivery Status Indexes | Key Name | | Key Columns | Unique Compression | | ------------------------- | --- | ----------- | ------------------ | | PK_EmailOutLog | | OutMailID | True PAGE | | IX_EmailOutLog_CustomerID | | CustomerID | PAGE |
Tables > dbo.EnrollerTree¶
[dbo].[EnrollerTree]¶
MS_Description Enroller Tree (Memory Optimized Table) Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------- | --------- | ------------------ | ----------- | | CustomerID | int | 4 | NOT NULL | Customer ID - Map to dbo.Customers | EnrollerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Enroller ID - Map to dbo.Customers | NestedLevel | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Nested Level | Lft | int | 4 | NOT NULL | | --- | --- | --- | -------- | Index Left Boundary | Rgt | int | 4 | NOT NULL | | --- | --- | --- | -------- | Index Right Boundary Indexes | Key Name | | Key Columns | Unique | | --------------- | --- | ----------- | ------ | | PK_EnrollerTree | | CustomerID | True | Used By
[dbo].[EnrollerDownline]¶
[dbo].[EnrollerUpline]¶
Tables > dbo.EnrollerTreeHistory¶
[dbo].[EnrollerTreeHistory]¶
MS_Description History of Changes in Enroller Tree Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------------- | --------- | ------------------ | ----------- | | EnrollerTreeHistoryID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | MoveDate | datetime | 8 | NOT NULL | | -------- | -------- | --- | -------- | Date of Tree Move | PreviousEnrollerID | int | 4 | NOT NULL | | ------------------ | --- | --- | -------- | Previous Enroller ID - Map to dbo.Customers | PreviousNestedLevel | int | 4 | NOT NULL | | ------------------- | --- | --- | -------- | Previous Nested Level | NewEnrollerID | int | 4 | NOT NULL | | ------------- | --- | --- | -------- | New Enroller ID - Map to dbo.Customers | NewNestedLevel | int | 4 | NOT NULL | | -------------- | --- | --- | -------- | New Nested Level | Reason | nvarchar(1000) | 2000 | NOT NULL | | ------ | -------------- | ---- | -------- | Reason for Move Indexes | Key Name | Key Columns | Unique | Compression | | ---------------------- | ----------------------- | ------ | ----------- | | PK_EnrollerTreeHistory | EnrollerTreeHistoryID, | True | PAGE | CustomerID
Tables > dbo.ExpectedPaymentFieldNames¶
[dbo].[ExpectedPaymentFieldNames]¶
MS_Description Expected Payment Field Names Columns | Name | Data Type | Max Length (Bytes) | Nullability | | ----------- | ------------- | ------------------ | ------------ | | BillingName | nvarchar(200) | 400 | NULL allowed | Billing Name | BankName | nvarchar(200) | 400 | NULL allowed | | -------- | ------------- | --- | ------------ | Bank Name | Memo | nvarchar(200) | 400 | NULL allowed | | ---- | ------------- | --- | ------------ | Memo
Tables > dbo.ExpectedPayments¶
[dbo].[ExpectedPayments]¶
MS_Description Expected Payments Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | ----------------- | --------- | ------- | ----------- | | ExpectedPaymentID | int | 4 | NOT NULL | Unique ID | OrderID | int | 4 | NULL allowed | | ------- | --- | --- | ------------ | Order ID - Map to dbo.Orders | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | PaymentType | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Payment Type - Map to dbo.PaymentTypes | PaymentDate | datetime | 8 | NOT NULL | | ----------- | -------- | --- | -------- | Payment Date | Amount | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Amount in Currency Code | CurrencyCode | nvarchar(3) | 6 | NOT NULL | | ------------ | ----------- | --- | -------- | Currency Code - Map to dbo.Currencies | CreditNumber | nvarchar(50) | 100 | NULL allowed | | ------------ | ------------ | --- | ------------ | Credit Number | CreditIssue | nvarchar(10) | 20 | NULL allowed | | ---------------- | ------------ | --- | ------------ | | CreditExpiration | datetime | 8 | NULL allowed | Credit Expiration | CreditAuthorization | nvarchar(50) | 100 | NULL allowed | | ------------------- | ------------ | --- | ------------ | Credit Authorization | CheckNumber | nvarchar(50) | 100 | NULL allowed | | ----------- | ------------ | --- | ------------ | Check Number | CheckAccountNumber | nvarchar(50) | 100 | NULL allowed | | ------------------ | ------------ | --- | ------------ | Check Account Number | CheckRoutingNumber | nvarchar(50) | 100 | NULL allowed | | ------------------ | ------------ | --- | ------------ | Check Routing Number | CheckDate | datetime | 8 | NULL allowed | | --------- | -------- | --- | ------------ | Check Date | BillingName | nvarchar(50) | 100 | NULL allowed | | ----------- | ------------ | --- | ------------ | Billing Name | BillingAddress1 | nvarchar(50) | 100 | NULL allowed | | --------------- | ------------ | --- | ------------ | Billing Address Line 1 | BillingAddress2 | nvarchar(50) | 100 | NULL allowed | | --------------- | ------------ | --- | ------------ | Billing Address Line 2 | BillingCity | nvarchar(40) | 80 | NULL allowed | | ----------- | ------------ | --- | ------------ | Billing City
Tables > dbo.ExpectedPayments¶
| BillingState | nvarchar(10) | 20 | NULL allowed |
|---|---|---|---|
| Billing State | |||
| BillingZip | nvarchar(20) | 40 | NULL allowed |
| ---------- | ------------ | --- | ------------ |
| Billing Zip | |||
| BillingCountry | nvarchar(2) | 4 | NULL allowed |
| -------------- | ----------- | --- | ------------ |
| Billing Country | |||
| BankName | nvarchar(50) | 100 | NULL allowed |
| -------- | ------------ | --- | ------------ |
| Bank Name | |||
| BankAddress | nvarchar(200) | 400 | NULL allowed |
| ----------- | ------------- | --- | ------------ |
| Bank Address | |||
| BankCity | nvarchar(40) | 80 | NULL allowed |
| -------- | ------------ | --- | ------------ |
| Bank City | |||
| BankState | nvarchar(10) | 20 | NULL allowed |
| --------- | ------------ | --- | ------------ |
| Bank State | |||
| BankZip | nvarchar(20) | 40 | NULL allowed |
| ------- | ------------ | --- | ------------ |
| Bank Zip | |||
| ExpectedPaymentStatusTy | int | 4 | NOT NULL |
| ----------------------- | --- | --- | -------- |
| Expected Payment Status Type - Map to dbo.Expected- | |||
| PaymentStatusTypes | |||
| Memo | nvarchar(500) | 1000 | NULL allowed |
| ---- | ------------- | ---- | ------------ |
| Memo | |||
| ModifiedDate | datetime | 8 | NOT NULL |
| ------------ | -------- | --- | -------- |
| Record Last Modified Date | |||
| Indexes | |||
| Key Name | Key Columns | Unique | Compression |
| ------------------- | ----------------- | ------ | ----------- |
| PK_ExpectedPayments | ExpectedPaymentID | True | PAGE |
Tables > dbo.ExpectedPaymentStatusTypes¶
[dbo].[ExpectedPaymentStatusTypes]¶
MS_Description Expected Payment Status Types Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------------------- | --------- | ------------------ | ----------- | | ExpectedPaymentStatusTypeID | int | 4 | NOT NULL | Unique ID | Description | nvarchar(50) | 100 | NOT NULL | | ----------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ----------------------------- | ---------------- | ------ | ----------- | | PK_ExpectedPaymentStatusTypes | ExpectedPayment- | True | PAGE | StatusTypeID
Tables > dbo.ExpectedRetailPayments¶
[dbo].[ExpectedRetailPayments]¶
MS_Description Expected Retail Payments Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------- | --------- | ------------------ | ----------- | | RetailOrderID | int | 4 | NOT NULL | Order ID - Map to dbo.Orders | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | PaymentType | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Payment Type - Map to dbo.PaymentTypes | PaymentDate | datetime | 8 | NOT NULL | | ----------- | -------- | --- | -------- | Payment Date | Amount | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Amount in Currency Code | CurrencyCode | nvarchar(3) | 6 | NOT NULL | | ------------ | ----------- | --- | -------- | Currency Code - Map to dbo.Currencies | CreditCardDescription | nvarchar(50) | 100 | NULL allowed | | --------------------- | ------------ | --- | ------------ | Credit Card Description | CreditCardNumber | nvarchar(50) | 100 | NULL allowed | | ---------------- | ------------ | --- | ------------ | Credit Card Number | CreditCardExpiration | datetime | 8 | NULL allowed | | -------------------- | -------- | --- | ------------ | Credit Card Expiration | CreditCardAuthorization | nvarchar(50) | 100 | NULL allowed | | ----------------------- | ------------ | --- | ------------ | Credit Card Authorization | CheckNumber | nvarchar(50) | 100 | NULL allowed | | ----------- | ------------ | --- | ------------ | Check Number | CheckAccountNumber | nvarchar(50) | 100 | NULL allowed | | ------------------ | ------------ | --- | ------------ | Check Account Number | CheckRoutingNumber | nvarchar(50) | 100 | NULL allowed | | ------------------ | ------------ | --- | ------------ | Check Routing Number | CheckDate | datetime | 8 | NULL allowed | | --------- | -------- | --- | ------------ | Check Date | BillingName | nvarchar(50) | 100 | NULL allowed | | ----------- | ------------ | --- | ------------ | Billing Name | BillingAddress1 | nvarchar(50) | 100 | NULL allowed | | --------------- | ------------ | --- | ------------ | Billing Address Line 1 | BillingAddress2 | nvarchar(50) | 100 | NULL allowed | | --------------- | ------------ | --- | ------------ | Billing Address Line 2 | BillingCity | nvarchar(40) | 80 | NULL allowed | | ----------- | ------------ | --- | ------------ | Billing City | BillingState | nvarchar(10) | 20 | NULL allowed | | ------------ | ------------ | --- | ------------ | Billing State | BillingZip | nvarchar(20) | 40 | NULL allowed | | ---------- | ------------ | --- | ------------ |
Tables > dbo.ExpectedRetailPayments¶
Billing Zip | BillingCountry | nvarchar(20) | 40 | NULL allowed | | -------------- | ------------ | --- | ------------ | Billing Country Indexes | Key Name | | Key Columns | Unique Compression | | ------------------------- | --- | ------------- | ------------------ | | PK_ExpectedRetailPayments | | RetailOrderID | True PAGE |
Tables > dbo.FrequencyTypes¶
[dbo].[FrequencyTypes]¶
MS_Description Frequency Types Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------- | --------- | ------------------ | ----------- | | FrequencyTypeID | int | 4 | NOT NULL | Unique ID | FrequencyTypeDescription | nvarchar(50) | 100 | NOT NULL | | ------------------------ | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ----------------- | --------------- | ------ | ----------- | | PK_FrequencyTypes | FrequencyTypeID | True | PAGE |
Tables > dbo.Guests¶
[dbo].[Guests]¶
MS_Description Party Guests Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | -------- | --------- | ------- | ----------- | | GuestID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NULL allowed | | ---------- | --- | --- | ------------ | Customer ID - Map to dbo.Customers | HostID | int | 4 | NOT NULL | | ------ | --- | --- | -------- | Host ID - Map to dbo.Customers.CustomerID | FirstName | nvarchar(50) | 100 | NOT NULL | | --------- | ------------ | --- | -------- | Guest First Name | MiddleName | nvarchar(50) | 100 | NOT NULL | | ---------- | ------------ | --- | -------- | Guest Middle Name | LastName | nvarchar(50) | 100 | NOT NULL | | -------- | ------------ | --- | -------- | Guest Last Name | NameSuffix | nvarchar(50) | 100 | NOT NULL | | ---------- | ------------ | --- | -------- | Guest Name Suffix | Company | nvarchar(50) | 100 | NOT NULL | | ------- | ------------ | --- | -------- | Guest Company (Optional) | Gender | nvarchar(1) | 2 | NOT NULL | | ------ | ----------- | --- | -------- | Guest Gender (M/F) | GuestStatusTypeID | int | 4 | NOT NULL | | ----------------- | --- | --- | -------- | Guest Status Type ID - Map to dbo.GuestStatusTypes | LanguageID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Guest Language ID - Map to dbo.Languages | Address1 | nvarchar(100) | 200 | NOT NULL | | -------- | ------------- | --- | -------- | Guest Address Line 1 | Address2 | nvarchar(100) | 200 | NOT NULL | | -------- | ------------- | --- | -------- | Guest Address Line 2 | Address3 | nvarchar(100) | 200 | NOT NULL | | -------- | ------------- | --- | -------- | Guest Address Line 3 | City | nvarchar(50) | 100 | NOT NULL | | ---- | ------------ | --- | -------- | Guest City | County | nvarchar(50) | 100 | NOT NULL | | ------ | ------------ | --- | -------- | Guest County | State | nvarchar(50) | 100 | NOT NULL | | ----- | ------------ | --- | -------- | Guest State | Zip | nvarchar(50) | 100 | NOT NULL | | --- | ------------ | --- | -------- | Guest Zip | Country | nvarchar(50) | 100 | NOT NULL | | ------- | ------------ | --- | -------- | Guest Country
Tables > dbo.Guests¶
| Phone | nvarchar(20) | 40 | NOT NULL |
|---|---|---|---|
| Guest Phone | |||
| Phone2 | nvarchar(20) | 40 | NOT NULL |
| ------ | ------------ | --- | -------- |
| Guest Phone 2 | |||
| MobilePhone | nvarchar(20) | 40 | NOT NULL |
| ----------- | ------------ | --- | -------- |
| Guest Mobile Phone | |||
| nvarchar(50) | 100 | NOT NULL | |
| ----- | ------------ | --- | -------- |
| Guest Email | |||
| Field1 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Guest Customer Field 1 - Map to dbo.CustomerFieldNames | |||
| Field2 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Guest Customer Field 2 - Map to dbo.CustomerFieldNames | |||
| Field3 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Guest Customer Field 3 - Map to dbo.CustomerFieldNames | |||
| Field4 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Guest Customer Field 4 - Map to dbo.CustomerFieldNames | |||
| Field5 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Guest Customer Field 5 - Map to dbo.CustomerFieldNames | |||
| Field6 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Guest Customer Field 6 - Map to dbo.CustomerFieldNames | |||
| Field7 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Guest Customer Field 7 - Map to dbo.CustomerFieldNames | |||
| Field8 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Guest Customer Field 8 - Map to dbo.CustomerFieldNames | |||
| Field9 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Guest Customer Field 9 - Map to dbo.CustomerFieldNames | |||
| Field10 | nvarchar(100) | 200 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Guest Customer Field 10 - Map to dbo.CustomerFieldNames | |||
| Field11 | nvarchar(100) | 200 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Guest Customer Field 11 - Map to dbo.CustomerFieldNames | |||
| Field12 | nvarchar(100) | 200 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Guest Customer Field 12 - Map to dbo.CustomerFieldNames | |||
| Field13 | nvarchar(100) | 200 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Guest Customer Field 13 - Map to dbo.CustomerFieldNames | |||
| Field14 | nvarchar(100) | 200 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Guest Customer Field 14 - Map to dbo.CustomerFieldNames | |||
| Field15 | nvarchar(100) | 200 | NOT NULL |
| ------- | ------------- | --- | -------- |
| Guest Customer Field 15 - Map to dbo.CustomerFieldNames | |||
| Date1 | datetime | 8 | NULL allowed |
| ----- | -------- | --- | ------------ |
| Guest Customer Date 1 - Map to dbo.CustomerFieldNames | |||
| Date2 | datetime | 8 | NULL allowed |
| ----- | -------- | --- | ------------ |
| Guest Customer Date 2 - Map to dbo.CustomerFieldNames | |||
| Date3 | datetime | 8 | NULL allowed |
| ----- | -------- | --- | ------------ |
| Guest Customer Date 3 - Map to dbo.CustomerFieldNames | |||
| Date4 | datetime | 8 | NULL allowed |
| ----- | -------- | --- | ------------ |
| Guest Customer Date 4 - Map to dbo.CustomerFieldNames | |||
| Date5 | datetime | 8 | NULL allowed |
| ----- | -------- | --- | ------------ |
| Guest Customer Date 5 - Map to dbo.CustomerFieldNames | |||
| Notes | nvarchar(max) | max | NULL allowed |
| ----- | ------------- | --- | ------------ |
| Guest Notes | |||
| EntryDate | datetime | 8 | NOT NULL |
| --------- | -------- | --- | -------- |
| Record Create Date |
Tables > dbo.Guests¶
| CreatedBy | nvarchar(30) | 60 | NOT NULL |
|---|---|---|---|
| Record Created By User | |||
| ModifiedDate | datetime | 8 | NOT NULL |
| ------------ | -------- | --- | -------- |
| Record Last Modified Date | |||
| ModifiedBy | nvarchar(30) | 60 | NOT NULL |
| ---------- | ------------ | --- | -------- |
| Record Last Modified By User | |||
| Indexes | |||
| Key Name | Key Columns | Unique | Compression |
| -------------------- | ----------- | ------ | ----------- |
| PK_Guests | GuestID | True | PAGE |
| IX_Guests_CustomerID | CustomerID | PAGE | |
| IX_Guests_HostID | HostID | PAGE |
Tables > dbo.GuestStatusTypes¶
[dbo].[GuestStatusTypes]¶
MS_Description Guest Status Types Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------------- | --------- | ------------------ | ----------- | | GuestStatusTypeID | int | 4 | NOT NULL | Unique ID | GuestStatusTypeDescription | nvarchar(50) | 100 | NOT NULL | | -------------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ------------------- | ----------------- | ------ | ----------- | | PK_GuestStatusTypes | GuestStatusTypeID | True | PAGE |
Tables > dbo.ImageFiles¶
[dbo].[ImageFiles]¶
MS_Description Image Files (Binary) Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | ------------- | ------------------ | ----------- | | Path | nvarchar(700) | 1400 | NOT NULL | File Path | Name | nvarchar(100) | 200 | NOT NULL | | ---- | ------------- | --- | -------- | Image Name | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date | Size | int | 4 | NOT NULL | | ---- | --- | --- | -------- | Image Size (KB) | ImageData | varbinary(max) | max | NOT NULL | | --------- | -------------- | --- | -------- | Image Binary Data Indexes | Key Name | Key Columns | Unique | Compression | | ------------- | ----------- | ------ | ----------- | | PK_ImageFiles | Path, Name | True | PAGE |
Tables > dbo.ItemChangeLog¶
[dbo].[ItemChangeLog]¶
MS_Description History of Item Changes Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------- | --------- | ------------------ | ----------- | | ItemChangeLogID | int | 4 | NOT NULL | Unique ID | ItemID | int | 4 | NOT NULL | | ------ | --- | --- | -------- | Item ID - Map to dbo.Items | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date | ModifiedBy | nvarchar(50) | 100 | NOT NULL | | ---------- | ------------ | --- | -------- | Record Last Modified By User | Detail | nvarchar(max) | max | NOT NULL | | ------ | ------------- | --- | -------- | Detail of From and To Indexes | Key Name | Key Columns | Unique | Compression | | ----------------------- | --------------- | ------ | ----------- | | PK_ItemChangeLog | ItemChangeLogID | True | PAGE | | IX_ItemChangeLog_ItemID | ItemID | | PAGE |
Tables > dbo.ItemCountryRegions¶
[dbo].[ItemCountryRegions]¶
MS_Description Tax Override by Item Per Country and Region Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | ItemID | int | 4 | NOT NULL | Item ID - Map to dbo.Items | CountryCode | nvarchar(2) | 4 | NOT NULL | | ----------- | ----------- | --- | -------- | Country Code - Map to dbo.Countries | RegionCode | nvarchar(3) | 6 | NOT NULL | | ---------- | ----------- | --- | -------- | Region Code - Map to dbo.CountryRegions | UseTaxOverride | bit | 1 | NOT NULL | | -------------- | --- | --- | -------- | Use Tax Override? Boolean | TaxOverridePercent | money | 8 | NOT NULL | | ------------------ | ----- | --- | -------- | Tax Override Percent | Taxed | int | 4 | NOT NULL | | ----- | --- | --- | -------- | Taxed? Boolean | TaxedFederal | int | 4 | NOT NULL | | ------------ | --- | --- | -------- | Taxed Federal? Boolean | TaxedState | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Taxed State? Boolean Indexes | Key Name | Key Columns | Unique | Compression | | --------------------- | --------------------- | ------ | ----------- | | PK_ItemCountryRegions | ItemID, CountryCode, | True | PAGE | RegionCode
Tables > dbo.ItemDynamicKitCategories¶
[dbo].[ItemDynamicKitCategories]¶
MS_Description Categories for Dynamic Item Kits Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------------------- | --------- | ------------------ | ----------- | | DynamicKitCategoryID | int | 4 | NOT NULL | Unique ID | DynamicKitCategoryDescription | nvarchar(50) | 100 | NOT NULL | | ----------------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | --------------------------- | -------------------- | ------ | ----------- | | PK_ItemDynamicKitCategories | DynamicKitCategoryID | True | PAGE |
Tables > dbo.ItemDynamicKitCategoryItemMembers¶
[dbo].[ItemDynamicKitCategoryItemMembers]¶
MS_Description Item Members in Dynamic Kit Categories Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------------------- | --------- | ------------------ | ----------- | | DynamicKitCategoryID | int | 4 | NOT NULL | Dynamic Kit Category ID - Map to dbo.ItemDynamicKitCategories | ItemID | int | 4 | NOT NULL | | ------ | --- | --- | -------- | Item ID - Map to dbo.Items Indexes | Key Name | Key Columns | Unique | Compression | | -------- | ----------- | ------ | ----------- | PK_ItemDynamicKitCategoryItemMembers DynamicKitCategory- True PAGE ID, ItemID
Tables > dbo.ItemDynamicKitCategoryMembers¶
[dbo].[ItemDynamicKitCategoryMembers]¶
MS_Description Layout of Items and Quantity in Dynamic Kit Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------ | --------- | ------------------ | ----------- | | MasterItemID | int | 4 | NOT NULL | Master Item ID - Map to dbo.ItemGroupMembers | DynamicKitCategoryID | int | 4 | NOT NULL | | -------------------- | --- | --- | -------- | Dynamic Kit Category ID - Map to dbo.ItemDynamicKitCategories | Quantity | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Quantity of Item in Kit Indexes | Key Name | Key Columns | Unique | Compression | | -------------------------------- | -------------- | ------ | ----------- | | PK_ItemDynamicKitCategoryMembers | MasterItemID, | True | PAGE | DynamicKitCategoryID
Tables > dbo.ItemFieldNames¶
[dbo].[ItemFieldNames]¶
MS_Description Display Names for Customer Fields in dbo.Items Table Columns | Name | Data Type | Max Length (Bytes) | Nullability | | ---------------------- | ------------ | ------------------ | ----------- | | ShortDetailDisplayName | nvarchar(50) | 100 | NOT NULL | Custom Field Name | ShortDetail2DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------------- | ------------ | --- | -------- | Custom Field Name | ShortDetail3DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------------- | ------------ | --- | -------- | Custom Field Name | ShortDetail4DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------------- | ------------ | --- | -------- | Custom Field Name | LongDetailDisplayName | nvarchar(50) | 100 | NOT NULL | | --------------------- | ------------ | --- | -------- | Custom Field Name | LongDetail2DisplayName | nvarchar(50) | 100 | NOT NULL | | ---------------------- | ------------ | --- | -------- | Custom Field Name | LongDetail3DisplayName | nvarchar(50) | 100 | NOT NULL | | ---------------------- | ------------ | --- | -------- | Custom Field Name | LongDetail4DisplayName | nvarchar(50) | 100 | NOT NULL | | ---------------------- | ------------ | --- | -------- | Custom Field Name | Field1DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Custom Field Name | Field2DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Custom Field Name | Field3DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Custom Field Name | Field4DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Custom Field Name | Field5DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Custom Field Name | Field6DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Custom Field Name | Field7DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Custom Field Name | Field8DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Custom Field Name | Field9DisplayName | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Custom Field Name | Field10DisplayName | nvarchar(50) | 100 | NOT NULL | | ------------------ | ------------ | --- | -------- | Custom Field Name | OtherCheck1DisplayName | nvarchar(50) | 100 | NOT NULL | | ---------------------- | ------------ | --- | -------- | Custom Field Name | OtherCheck2DisplayName | nvarchar(50) | 100 | NOT NULL | | ---------------------- | ------------ | --- | -------- |
Tables > dbo.ItemFieldNames¶
Custom Field Name | OtherCheck3DisplayName | nvarchar(50) | 100 | NOT NULL | | ---------------------- | ------------ | --- | -------- | Custom Field Name | OtherCheck4DisplayName | nvarchar(50) | 100 | NOT NULL | | ---------------------- | ------------ | --- | -------- | Custom Field Name | OtherCheck5DisplayName | nvarchar(50) | 100 | NOT NULL | | ---------------------- | ------------ | --- | -------- | Custom Field Name | Auto1DisplayName | nvarchar(50) | 100 | NOT NULL | | ---------------- | ------------ | --- | -------- | Custom Field Name | Auto2DisplayName | nvarchar(50) | 100 | NOT NULL | | ---------------- | ------------ | --- | -------- | Custom Field Name | Auto3DisplayName | nvarchar(50) | 100 | NOT NULL | | ---------------- | ------------ | --- | -------- | Custom Field Name
Tables > dbo.ItemGroupMembers¶
[dbo].[ItemGroupMembers]¶
Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------------------- | ------------- | ------------------ | ----------- | | MasterItemID | int | 4 | NOT NULL | | ItemID | int | 4 | NOT NULL | | Priority | int | 4 | NOT NULL | | GroupMemberDescription | nvarchar(100) | 200 | NOT NULL | Indexes | Key Name | Key Columns | Unique | Compression | | ------------------- | -------------------- | ------ | ----------- | | PK_ItemGroupMembers | MasterItemID, ItemID | True | PAGE |
Tables > dbo.ItemImages¶
[dbo].[ItemImages]¶
MS_Description Image Mapping for Items Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------- | --------- | ------------------ | ----------- | | ItemImageID | int | 4 | NOT NULL | Unique ID | ImageName | nvarchar(500) | 1000 | NOT NULL | | --------- | ------------- | ---- | -------- | Image Name | ImageData | varbinary(max) | max | NULL allowed | | --------- | -------------- | --- | ------------ | Image Data (Binary) | CompressionTypeID | int | 4 | NULL allowed | | ----------------- | --- | --- | ------------ | Compression Type ID | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date Indexes | Key Name | | Key Columns | Unique Compression | | ----------------------- | --- | ----------- | ------------------ | | PK_ItemImages | | ItemImageID | True PAGE | | IX_ItemImages_ImageName | | ImageName | PAGE |
Tables > dbo.ItemLanguages¶
[dbo].[ItemLanguages]¶
MS_Description Item Descriptions in Other Languages Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | ItemID | int | 4 | NOT NULL | Item ID - Map to dbo.Items | LanguageID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Language ID - Map to dbo.Languages | ItemDescription | nvarchar(255) | 510 | NOT NULL | | --------------- | ------------- | --- | -------- | Item Description | ShortDetail | nvarchar(2048) | 4096 | NOT NULL | | ----------- | -------------- | ---- | -------- | Short Detail | ShortDetail2 | nvarchar(2048) | 4096 | NOT NULL | | ------------ | -------------- | ---- | -------- | Short Detail 2 | ShortDetail3 | nvarchar(2048) | 4096 | NOT NULL | | ------------ | -------------- | ---- | -------- | Short Detail 3 | ShortDetail4 | nvarchar(2048) | 4096 | NOT NULL | | ------------ | -------------- | ---- | -------- | Short Detail 4 | LongDetail | nvarchar(max) | max | NOT NULL | | ---------- | ------------- | --- | -------- | Long Detail | LongDetail2 | nvarchar(max) | max | NOT NULL | | ----------- | ------------- | --- | -------- | Long Detail 2 | LongDetail3 | nvarchar(max) | max | NOT NULL | | ----------- | ------------- | --- | -------- | Long Detail 3 | LongDetail4 | nvarchar(max) | max | NOT NULL | | ----------- | ------------- | --- | -------- | Long Detail 4 | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date Indexes | Key Name | Key Columns | Unique | Compression | | ---------------- | ------------------ | ------ | ----------- | | PK_ItemLanguages | ItemID, LanguageID | True | PAGE |
Tables > dbo.ItemPointAccounts¶
[dbo].[ItemPointAccounts]¶
MS_Description Item Point Accounts Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | ItemID | int | 4 | NOT NULL | Item ID - Map to dbo.Items | PointAccountID | int | 4 | NOT NULL | | -------------- | --- | --- | -------- | Point Account ID - Map to dbo.PointAccounts | Increment | money | 8 | NOT NULL | | --------- | ----- | --- | -------- | Increment Indexes | Key Name | Key Columns | Unique | Compression | | -------------------- | ---------------------- | ------ | ----------- | | PK_ItemPointAccounts | ItemID, PointAccountID | True | PAGE |
Tables > dbo.ItemPrices¶
[dbo].[ItemPrices]¶
MS_Description Item Prices Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | ItemID | int | 4 | NOT NULL | Item ID - Map to dbo.Items | CurrencyCode | nvarchar(3) | 6 | NOT NULL | | ------------ | ----------- | --- | -------- | Currency Code - Map to dbo.Currencies | PriceTypeID | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Price Type ID - Map to dbo.PriceTypes | Price | money | 8 | NOT NULL | | ----- | ----- | --- | -------- | Amount in Currency Code | CommissionableVolume | money | 8 | NOT NULL | | -------------------- | ----- | --- | -------- | Commissionable Volume | BusinessVolume | money | 8 | NOT NULL | | -------------- | ----- | --- | -------- | Business Volume | TaxablePrice | money | 8 | NOT NULL | | ------------ | ----- | --- | -------- | Taxable Amount | ShippingPrice | money | 8 | NOT NULL | | ------------- | ----- | --- | -------- | Shipping Amount | Other1Price | money | 8 | NOT NULL | | ----------- | ----- | --- | -------- | Customer Amount | Other2Price | money | 8 | NOT NULL | | ----------- | ----- | --- | -------- | Customer Amount | Other3Price | money | 8 | NOT NULL | | ----------- | ----- | --- | -------- | Customer Amount | Other4Price | money | 8 | NOT NULL | | ----------- | ----- | --- | -------- | Customer Amount | Other5Price | money | 8 | NOT NULL | | ----------- | ----- | --- | -------- | Customer Amount | Other6Price | money | 8 | NOT NULL | | ----------- | ----- | --- | -------- | Customer Amount | Other7Price | money | 8 | NOT NULL | | ----------- | ----- | --- | -------- | Customer Amount | Other8Price | money | 8 | NOT NULL | | ----------- | ----- | --- | -------- | Customer Amount | Other9Price | money | 8 | NOT NULL | | ----------- | ----- | --- | -------- | Customer Amount | Other10Price | money | 8 | NOT NULL | | ------------ | ----- | --- | -------- | Customer Amount
Tables > dbo.ItemPrices¶
Indexes | Key Name | Key Columns | Unique Compression | | ------------- | ---------------------------- | ------------------ | | PK_ItemPrices | ItemID, CurrencyCode, Price- | True PAGE | TypeID
Tables > dbo.Items¶
[dbo].[Items]¶
MS_Description Items Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | -------- | --------- | ------- | ----------- | | ItemID | int | 4 | NOT NULL | Unique ID | ItemCode | nvarchar(20) | 40 | NOT NULL | | -------- | ------------ | --- | -------- | Item Code | ItemDescription | nvarchar(500) | 1000 | NOT NULL | | --------------- | ------------- | ---- | -------- | Item Description | ItemTypeID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Item Type ID - Map to dbo.ItemTypes | ShortDetail | nvarchar(2048) | 4096 | NOT NULL | | ----------- | -------------- | ---- | -------- | Short Detail | ShortDetail2 | nvarchar(2048) | 4096 | NOT NULL | | ------------ | -------------- | ---- | -------- | Short Detail 2 | ShortDetail3 | nvarchar(2048) | 4096 | NOT NULL | | ------------ | -------------- | ---- | -------- | Short Detail 3 | ShortDetail4 | nvarchar(2048) | 4096 | NOT NULL | | ------------ | -------------- | ---- | -------- | Short Detail 4 | LongDetail | nvarchar(max) | max | NOT NULL | | ---------- | ------------- | --- | -------- | Long Detail | LongDetail2 | nvarchar(max) | max | NOT NULL | | ----------- | ------------- | --- | -------- | Long Detail 2 | LongDetail3 | nvarchar(max) | max | NOT NULL | | ----------- | ------------- | --- | -------- | Long Detail 3 | LongDetail4 | nvarchar(max) | max | NOT NULL | | ----------- | ------------- | --- | -------- | Long Detail 4 | Notes | nvarchar(2048) | 4096 | NOT NULL | | ----- | -------------- | ---- | -------- | Notes | Weight | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Item Weight (Typically lbs, but is not defined) | IsVirtual | bit | 1 | NOT NULL | | --------- | --- | --- | -------- | Is Virtual Item? Boolean | IsGroupMaster | bit | 1 | NOT NULL | | ------------- | --- | --- | -------- | Is Group Master? Boolean | SuppressGroupMaster | bit | 1 | NOT NULL | | ------------------- | --- | --- | -------- | Suppress Group Master? Boolean | GroupDescription | nvarchar(500) | 1000 | NOT NULL | | ---------------- | ------------- | ---- | -------- | Group Description | GroupMembersDescription | nvarchar(500) | 1000 | NOT NULL | | ----------------------- | ------------- | ---- | -------- | Group Members Description
Tables > dbo.Items¶
| AllowOnAutoOrder | bit | 1 | NOT NULL |
|---|---|---|---|
| Allow On Auto Order? Boolean | |||
| HideFromSearch | bit | 1 | NOT NULL |
| -------------- | --- | --- | -------- |
| Hide From Search? Boolean | |||
| AvailableAllCountryRegions | bit | 1 | NOT NULL |
| -------------------------- | --- | --- | -------- |
| Available in All Countries and Regions? Boolean | |||
| TinyImageName | nvarchar(255) | 510 | NOT NULL |
| ------------- | ------------- | --- | -------- |
| Tiny Image Name | |||
| SmallImageName | nvarchar(255) | 510 | NOT NULL |
| -------------- | ------------- | --- | -------- |
| Small Image Name | |||
| LargeImageName | nvarchar(255) | 510 | NOT NULL |
| -------------- | ------------- | --- | -------- |
| Large Image Name | |||
| Field1 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Custom Field | |||
| Field2 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Custom Field | |||
| Field3 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Custom Field | |||
| Field4 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Custom Field | |||
| Field5 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Custom Field | |||
| Field6 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Custom Field | |||
| Field7 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Custom Field | |||
| Field8 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Custom Field | |||
| Field9 | nvarchar(100) | 200 | NOT NULL |
| ------ | ------------- | --- | -------- |
| Custom Field | |||
| Field10 | nvarchar(100) | 200 | NULL allowed |
| ------- | ------------- | --- | ------------ |
| Custom Field | |||
| OtherCheck1 | bit | 1 | NOT NULL |
| ----------- | --- | --- | -------- |
| Custom Field | |||
| OtherCheck2 | bit | 1 | NOT NULL |
| ----------- | --- | --- | -------- |
| Custom Field | |||
| OtherCheck3 | bit | 1 | NOT NULL |
| ----------- | --- | --- | -------- |
| Custom Field | |||
| OtherCheck4 | bit | 1 | NOT NULL |
| ----------- | --- | --- | -------- |
| Custom Field | |||
| OtherCheck5 | bit | 1 | NOT NULL |
| ----------- | --- | --- | -------- |
| Custom Field | |||
| Auto1 | nvarchar(100) | 200 | NOT NULL |
| ----- | ------------- | --- | -------- |
| Custom Field | |||
| Auto2 | nvarchar(100) | 200 | NOT NULL |
| ----- | ------------- | --- | -------- |
| Custom Field | |||
| Auto3 | nvarchar(100) | 200 | NOT NULL |
| ----- | ------------- | --- | -------- |
| Custom Field | |||
| ModifiedDate | datetime | 8 | NOT NULL |
| ------------ | -------- | --- | -------- |
| Record Last Modified Date | |||
| CalculateTaxOnKitDetail | bit | 1 | NOT NULL |
| ----------------------- | --- | --- | -------- |
| Calculate Tax On Kit Detail? Boolean |
Tables > dbo.Items¶
| CalculateShipOnKitDetail | bit | 1 | NOT NULL |
|---|---|---|---|
| Calculate Shipping On Kit Detail? Boolean | |||
| ItemStatus | int | 4 | NULL allowed |
| ---------- | --- | --- | ------------ |
| Item Status | |||
| EntryDate | datetime | 8 | NULL allowed |
| --------- | -------- | --- | ------------ |
| Item Created Date | |||
| AvailableInAllWarehouses | bit | 1 | NULL allowed |
| ------------------------ | --- | --- | ------------ |
| Available in All Warehouses? - Boolean | |||
| TaxedInAllCountryRegions | bit | 1 | NULL allowed |
| ------------------------ | --- | --- | ------------ |
| Taxed in All Countries and Regions - Boolean | |||
| IsSubscriptionUpdate | bit | 1 | NULL allowed |
| -------------------- | --- | --- | ------------ |
| Is Subscription Update? - Boolean | |||
| IsPointIncrement | bit | 1 | NULL allowed |
| ---------------- | --- | --- | ------------ |
| Is Point Increment? - Boolean | |||
| Indexes | |||
| Key Name | Key Columns | Unique Compression | |
| -------- | --- | ----------- | ------------------ |
| PK_Items | ItemID | True PAGE |
Tables > dbo.ItemStaticKitMembers¶
[dbo].[ItemStaticKitMembers]¶
MS_Description Static Kit Members Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------ | --------- | ------------------ | ----------- | | MasterItemID | int | 4 | NOT NULL | Unique ID | ItemID | int | 4 | NOT NULL | | ------ | --- | --- | -------- | Item ID - Map to dbo.Items | Quantity | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Quantity of Item in Master Item | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Update Date Indexes | Key Name | Key Columns | Unique | Compression | | ----------------------- | -------------------- | ------ | ----------- | | PK_ItemStaticKitMembers | MasterItemID, ItemID | True | PAGE |
Tables > dbo.ItemSubscriptions¶
[dbo].[ItemSubscriptions]¶
MS_Description Item Subscriptions Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | ItemID | int | 4 | NOT NULL | Item ID - Map to dbo.Items | SubscriptionID | int | 4 | NOT NULL | | -------------- | --- | --- | -------- | Subscription ID - Map to dbo.Subscriptions | DaysEach | int | 4 | NOT NULL | | -------- | --- | --- | -------- | Increment Days Indexes | Key Name | Key Columns | Unique | Compression | | -------------------- | ---------------------- | ------ | ----------- | | PK_ItemSubscriptions | ItemID, SubscriptionID | True | PAGE |
Tables > dbo.ItemTypes¶
[dbo].[ItemTypes]¶
MS_Description Item Types Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------- | --------- | ------------------ | ----------- | | ItemTypeID | int | 4 | NOT NULL | Unique ID | ItemTypeDescription | nvarchar(50) | 100 | NULL allowed | | ------------------- | ------------ | --- | ------------ | Description Indexes | Key Name | | Key Columns | Unique Compression | | ------------ | --- | ----------- | ------------------ | | PK_ItemTypes | | ItemTypeID | True PAGE |
Tables > dbo.ItemWarehouses¶
[dbo].[ItemWarehouses]¶
MS_Description Item Warehouses Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | ItemID | int | 4 | NOT NULL | Item ID - Map to dbo.Items | WarehouseID | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Warehouse ID - Map to dbo.Warehouses | MaxAllowedOnOrder | int | 4 | NOT NULL | | ----------------- | --- | --- | -------- | Max Quantity of ItemID Allowed Per Order | StockLevel | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Stock Level Indexes | Key Name | Key Columns | Unique | Compression | | ----------------- | ------------------- | ------ | ----------- | | PK_ItemWarehouses | ItemID, WarehouseID | True | PAGE |
Tables > dbo.Languages¶
[dbo].[Languages]¶
MS_Description Languages Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------- | --------- | ------------------ | ----------- | | LanguageID | int | 4 | NOT NULL | Unique ID | LanguageDescription | nvarchar(50) | 100 | NOT NULL | | ------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ------------ | ----------- | ------ | ----------- | | PK_Languages | LanguageID | True | PAGE |
Tables > dbo.MerchantDeclineLog¶
[dbo].[MerchantDeclineLog]¶
MS_Description Merchant Decline Log Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | -------------------- | --------- | ------- | ----------- | | MerchantDeclineLogID | int | 4 | NOT NULL | Unique ID | EntryDate | datetime | 8 | NOT NULL | | --------- | -------- | --- | -------- | Record Creation Date | MerchantDeclineReasonID | int | 4 | NOT NULL | | ----------------------- | --- | --- | -------- | Merchant Decline Reason ID - Map to dbo.MerchantDecline- Reasons | Message | nvarchar(500) | 1000 | NOT NULL | | ------- | ------------- | ---- | -------- | Merchant Message | MerchantTypeID | int | 4 | NOT NULL | | -------------- | --- | --- | -------- | Merchant Type ID - Map to dbo.MerchantTypes | Amount | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Amount of Decline | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | OrderID | int | 4 | NOT NULL | | ------- | --- | --- | -------- | Order ID - Map to dbo.Orders | CurrencyCode | nvarchar(3) | 6 | NOT NULL | | ------------ | ----------- | --- | -------- | Currency Code - Map to dbo.Currencies | CreditCardDisplay | nvarchar(50) | 100 | NULL allowed | | ----------------- | ------------ | --- | ------------ | Credit Card Display | PassedCvvCode | bit | 1 | NULL allowed | | ------------- | --- | --- | ------------ | Passed CVV Code | ExpirationMonth | int | 4 | NULL allowed | | --------------- | --- | --- | ------------ | Expire Month | ExpirationYear | int | 4 | NULL allowed | | -------------- | --- | --- | ------------ | Expire Year | BillingName | nvarchar(100) | 200 | NULL allowed | | ----------- | ------------- | --- | ------------ | Billing Name | BillingAddress | nvarchar(100) | 200 | NULL allowed | | -------------- | ------------- | --- | ------------ | Billing Address | BillingCity | nvarchar(50) | 100 | NULL allowed | | ----------- | ------------ | --- | ------------ | Billing City | BillingState | nvarchar(50) | 100 | NULL allowed | | ------------ | ------------ | --- | ------------ | Billing State | BillingZip | nvarchar(50) | 100 | NULL allowed | | ---------- | ------------ | --- | ------------ | Billing Zip | BillingCountry | nvarchar(50) | 100 | NULL allowed | | -------------- | ------------ | --- | ------------ | Billing Country
Tables > dbo.MerchantDeclineLog¶
| AdditionalReturnData | nvarchar(max) | max | NULL allowed |
|---|---|---|---|
| Additional Return Data | |||
| Indexes | |||
| Key Name | Key Columns | Unique | Compression |
| --------------------- | -------------------- | ------ | ----------- |
| PK_MerchantDeclineLog | MerchantDeclineLogID | True | PAGE |
Tables > dbo.MerchantDeclineReasons¶
[dbo].[MerchantDeclineReasons]¶
MS_Description Merchant Decline Reasons Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------------------- | --------- | ------------------ | ----------- | | MerchantDeclineReasonID | int | 4 | NOT NULL | Unique ID | MerchantDeclineReasonDescription | nvarchar(50) | 100 | NOT NULL | | -------------------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------- | ---------------------- | ------ | ----------- | | PK_MerchantDeclineReasons | MerchantDeclineReason- | True | PAGE | ID
Tables > dbo.MerchantTypes¶
[dbo].[MerchantTypes]¶
MS_Description Merchant Types Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------------- | --------- | ------------------ | ----------- | | MerchantTypeID | int | 4 | NOT NULL | Unique ID | Description | nvarchar(50) | 100 | NOT NULL | | ----------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ---------------- | -------------- | ------ | ----------- | | PK_MerchantTypes | MerchantTypeID | True | PAGE |
Tables > dbo.OrderBatches¶
[dbo].[OrderBatches]¶
MS_Description Order Batches Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------- | --------- | ------------------ | ----------- | | WarehouseID | int | 4 | NOT NULL | Warehouse ID - Map to dbo.Warehouses | BatchID | int | 4 | NOT NULL | | ------- | --- | --- | -------- | Batch ID | PrintedDate | datetime | 8 | NOT NULL | | ----------- | -------- | --- | -------- | Printed Date | TotalOrders | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Total Orders Count Indexes | Key Name | Key Columns | Unique | Compression | | --------------- | ---------------------- | ------ | ----------- | | PK_OrderBatches | WarehouseID, BatchID, | True | PAGE | PrintedDate
Tables > dbo.OrderChangeLog¶
[dbo].[OrderChangeLog]¶
MS_Description History of Order Changes Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------------- | --------- | ------------------ | ----------- | | OrderChangeLogID | int | 4 | NOT NULL | Unique ID | OrderID | int | 4 | NOT NULL | | ------- | --- | --- | -------- | Order ID - Map to dbo.Orders | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date | ModifiedBy | nvarchar(50) | 100 | NOT NULL | | ---------- | ------------ | --- | -------- | Record Last Modified User | Detail | nvarchar(max) | max | NOT NULL | | ------ | ------------- | --- | -------- | Detail From and To Values Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------- | ---------------- | ------ | ----------- | | PK_OrderChangeLog | OrderChangeLogID | True | PAGE | | IX_OrderChangeLog_OrderID | OrderID | | PAGE |
Tables > dbo.OrderDetails¶
[dbo].[OrderDetails]¶
MS_Description Order Details Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | OrderID | int | 4 | NOT NULL | Order ID - Map to dbo.Orders | OrderLine | int | 4 | NOT NULL | | --------- | --- | --- | -------- | Sorting Order of Items on Order | OrderDetailID | uniqueidentifier | 16 | NULL allowed | | ------------- | ---------------- | --- | ------------ | Unique ID | ParentOrderDetailID | uniqueidentifier | 16 | NULL allowed | | ------------------- | ---------------- | --- | ------------ | Parent Order Detail ID | ItemID | int | 4 | NOT NULL | | ------ | --- | --- | -------- | Item ID - Map to dbo.Items | ItemCode | nvarchar(20) | 40 | NOT NULL | | -------- | ------------ | --- | -------- | Item Code | ItemDescription | nvarchar(500) | 1000 | NOT NULL | | --------------- | ------------- | ---- | -------- | Item Description | Quantity | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Quantity on Order Line | PriceEach | money | 8 | NOT NULL | | --------- | ----- | --- | -------- | Price Each Item | PriceTotal | money | 8 | NOT NULL | | ---------- | ----- | --- | -------- | Price Each * Quantity | Tax | money | 8 | NOT NULL | | --- | ----- | --- | -------- | Tax | WeightEach | money | 8 | NOT NULL | | ---------- | ----- | --- | -------- | Weight Each | Weight | money | 8 | NULL allowed | | ------ | ----- | --- | ------------ | Weight Each * Quantity | BusinessVolumeEach | money | 8 | NOT NULL | | ------------------ | ----- | --- | -------- | Business Volume Each | BusinessVolume | money | 8 | NOT NULL | | -------------- | ----- | --- | -------- | Business Volume Each * Quantity | CommissionableVolumeEach | money | 8 | NOT NULL | | ------------------------ | ----- | --- | -------- | Commissionable Volume Each | CommissionableVolume | money | 8 | NOT NULL | | -------------------- | ----- | --- | -------- | Commissionable Volume Each * Quantity | Other1Each | money | 8 | NOT NULL | | ---------- | ----- | --- | -------- | Other 1 Each | Other1 | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Other 1 Each * Quantity | Other2Each | money | 8 | NOT NULL | | ---------- | ----- | --- | -------- |
Tables > dbo.OrderDetails¶
Other 2 Each | Other2 | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Other 2 Each * Quantity | Other3Each | money | 8 | NOT NULL | | ---------- | ----- | --- | -------- | Other 3 Each | Other3 | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Other 3 Each * Quantity | Other4Each | money | 8 | NOT NULL | | ---------- | ----- | --- | -------- | Other 4 Each | Other4 | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Other 4 Each * Quantity | Other5Each | money | 8 | NOT NULL | | ---------- | ----- | --- | -------- | Other 5 Each | Other5 | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Other 5 Each * Quantity | OriginalTaxableEach | money | 8 | NOT NULL | | ------------------- | ----- | --- | -------- | Original Taxable Each | OriginalBusinessVolumeEach | money | 8 | NOT NULL | | -------------------------- | ----- | --- | -------- | Original Business Volume Each | OriginalCommissionableVolumeEach | money | 8 | NOT NULL | | -------------------------------- | ----- | --- | -------- | Original Commissionable Volume Each | Other6Each | money | 8 | NOT NULL | | ---------- | ----- | --- | -------- | Other 6 Each | Other6 | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Other 6 Each * Quantity | Other7Each | money | 8 | NOT NULL | | ---------- | ----- | --- | -------- | Other 7 Each | Other7 | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Other 7 Each * Quantity | Other8Each | money | 8 | NOT NULL | | ---------- | ----- | --- | -------- | Other 8 Each | Other8 | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Other 8 Each * Quantity | Other9Each | money | 8 | NOT NULL | | ---------- | ----- | --- | -------- | Other 9 Each | Other9 | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Other 9 Each * Quantity | Other10Each | money | 8 | NOT NULL | | ----------- | ----- | --- | -------- | Other 10 Each | Other10 | money | 8 | NOT NULL | | ------- | ----- | --- | -------- | Other 10 Each * Quantity | ParentItemID | int | 4 | NULL allowed | | ------------ | --- | --- | ------------ | Parent Item ID - Map to dbo.Items | Taxable | money | 8 | NOT NULL | | ------- | ----- | --- | -------- | Taxable Amount | FedTax | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Federal Tax Amount | StateTax | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | State Tax Amount | CityTax | money | 8 | NOT NULL | | ------- | ----- | --- | -------- | City Tax Amount
Tables > dbo.OrderDetails¶
| CityLocalTax | money | 8 | NOT NULL |
|---|---|---|---|
| City Local Tax Amount | |||
| CountyTax | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| County Tax Amount | |||
| CountyLocalTax | money | 8 | NOT NULL |
| -------------- | ----- | --- | -------- |
| County Local Tax Amount | |||
| ManualTax | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Manual Tax Amount | |||
| IsStateTaxOverride | bit | 1 | NOT NULL |
| ------------------ | --- | --- | -------- |
| Is State Tax Override? Boolean | |||
| Reference1 | nvarchar(100) | 200 | NOT NULL |
| ---------- | ------------- | --- | -------- |
| Reference Field | |||
| Indexes | |||
| Key Name | Key Columns | Unique Compression | |
| --------------- | ------------------ | --- | ------------------ |
| PK_OrderDetails | OrderID, OrderLine | True PAGE | |
| Used By |
[queue].[Refresh]¶
Tables > dbo.OrderFieldNames¶
[dbo].[OrderFieldNames]¶
MS_Description Display Names for Custom Fields in Orders Table Columns | Name | Data Type | Max Length (Bytes) | Nullability | | ------------------------- | ------------- | ------------------ | ----------- | | BusinessVolumeDisplayName | nvarchar(200) | 400 | NOT NULL | Custom Field | CommissionableVolumeDisplayName | nvarchar(200) | 400 | NOT NULL | | ------------------------------- | ------------- | --- | -------- | Custom Field | Other1DisplayName | nvarchar(200) | 400 | NOT NULL | | ----------------- | ------------- | --- | -------- | Custom Field | Other2DisplayName | nvarchar(200) | 400 | NOT NULL | | ----------------- | ------------- | --- | -------- | Custom Field | Other3DisplayName | nvarchar(200) | 400 | NOT NULL | | ----------------- | ------------- | --- | -------- | Custom Field | Other4DisplayName | nvarchar(200) | 400 | NOT NULL | | ----------------- | ------------- | --- | -------- | Custom Field | Other5DisplayName | nvarchar(200) | 400 | NOT NULL | | ----------------- | ------------- | --- | -------- | Custom Field | Other6DisplayName | nvarchar(200) | 400 | NOT NULL | | ----------------- | ------------- | --- | -------- | Custom Field | Other7DisplayName | nvarchar(200) | 400 | NOT NULL | | ----------------- | ------------- | --- | -------- | Custom Field | Other8DisplayName | nvarchar(200) | 400 | NOT NULL | | ----------------- | ------------- | --- | -------- | Custom Field | Other9DisplayName | nvarchar(200) | 400 | NOT NULL | | ----------------- | ------------- | --- | -------- | Custom Field | Other10DisplayName | nvarchar(200) | 400 | NOT NULL | | ------------------ | ------------- | --- | -------- | Custom Field | Other11DisplayName | nvarchar(200) | 400 | NOT NULL | | ------------------ | ------------- | --- | -------- | Custom Field | Other12DisplayName | nvarchar(200) | 400 | NOT NULL | | ------------------ | ------------- | --- | -------- | Custom Field | Other13DisplayName | nvarchar(200) | 400 | NOT NULL | | ------------------ | ------------- | --- | -------- | Custom Field | Other14DisplayName | nvarchar(200) | 400 | NOT NULL | | ------------------ | ------------- | --- | -------- | Custom Field | Other15DisplayName | nvarchar(200) | 400 | NOT NULL | | ------------------ | ------------- | --- | -------- | Custom Field | Other16DisplayName | nvarchar(200) | 400 | NOT NULL | | ------------------ | ------------- | --- | -------- | Custom Field | Other17DisplayName | nvarchar(200) | 400 | NOT NULL | | ------------------ | ------------- | --- | -------- | Custom Field | Other18DisplayName | nvarchar(200) | 400 | NOT NULL | | ------------------ | ------------- | --- | -------- |
Tables > dbo.OrderFieldNames¶
Custom Field | Other19DisplayName | nvarchar(200) | 400 | NOT NULL | | ------------------ | ------------- | --- | -------- | Custom Field | Other20DisplayName | nvarchar(200) | 400 | NOT NULL | | ------------------ | ------------- | --- | -------- | Custom Field
Tables > dbo.Orders¶
[dbo].[Orders]¶
MS_Description Orders Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | -------- | --------- | ------- | ----------- | | OrderID | int | 4 | NOT NULL | Order ID - Map to dbo.Orders | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | OrderStatusID | int | 4 | NOT NULL | | ------------- | --- | --- | -------- | Order Status ID - Map to dbo.OrderStatuses | OrderDate | datetime | 8 | NOT NULL | | --------- | -------- | --- | -------- | Order Date | CurrencyCode | nvarchar(3) | 6 | NOT NULL | | ------------ | ----------- | --- | -------- | Currency Code - Map to dbo.Currencies | WarehouseID | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Warehouse ID - Map to dbo.Warehouses | ShipMethodID | int | 4 | NOT NULL | | ------------ | --- | --- | -------- | Ship Method ID - Map to dbo.ShipMethods | OrderTypeID | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Order Type ID - Map to dbo.OrderTypes | PriceTypeID | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Price Type ID - Map to dbo.PriceTypes | FirstName | nvarchar(50) | 100 | NOT NULL | | --------- | ------------ | --- | -------- | Customer First Name | MiddleName | nvarchar(50) | 100 | NOT NULL | | ---------- | ------------ | --- | -------- | Customer Middle Name | LastName | nvarchar(50) | 100 | NOT NULL | | -------- | ------------ | --- | -------- | Customer Last Name | NameSuffix | nvarchar(50) | 100 | NOT NULL | | ---------- | ------------ | --- | -------- | Customer Name Suffix | Company | nvarchar(100) | 200 | NOT NULL | | ------- | ------------- | --- | -------- | Customer Company | Address1 | nvarchar(100) | 200 | NOT NULL | | -------- | ------------- | --- | -------- | Customer Address Line 1 | Address2 | nvarchar(100) | 200 | NOT NULL | | -------- | ------------- | --- | -------- | Customer Address Line 2 | Address3 | nvarchar(100) | 200 | NOT NULL | | -------- | ------------- | --- | -------- | Customer Address Line 3 | City | nvarchar(50) | 100 | NOT NULL | | ---- | ------------ | --- | -------- | Customer City | State | nvarchar(50) | 100 | NOT NULL | | ----- | ------------ | --- | -------- | Customer State
Tables > dbo.Orders¶
| Zip | nvarchar(50) | 100 | NOT NULL |
|---|---|---|---|
| Customer Zip | |||
| Country | nvarchar(50) | 100 | NOT NULL |
| ------- | ------------ | --- | -------- |
| Customer Country | |||
| County | nvarchar(50) | 100 | NOT NULL |
| ------ | ------------ | --- | -------- |
| Customer County | |||
| nvarchar(200) | 400 | NOT NULL | |
| ----- | ------------- | --- | -------- |
| Customer Email | |||
| Phone | nvarchar(50) | 100 | NOT NULL |
| ----- | ------------ | --- | -------- |
| Customer Phone | |||
| Notes | nvarchar(500) | 1000 | NOT NULL |
| ----- | ------------- | ---- | -------- |
| Order Notes | |||
| Total | money | 8 | NOT NULL |
| ----- | ----- | --- | -------- |
| Order Total | |||
| SubTotal | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Order SubTotal | |||
| TaxTotal | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Order Tax Total | |||
| ShippingTotal | money | 8 | NOT NULL |
| ------------- | ----- | --- | -------- |
| Order Shipping Total | |||
| DiscountTotal | money | 8 | NOT NULL |
| ------------- | ----- | --- | -------- |
| Order Discount Total | |||
| DiscountPercent | money | 8 | NOT NULL |
| --------------- | ----- | --- | -------- |
| Order Discount Percent | |||
| WeightTotal | money | 8 | NOT NULL |
| ----------- | ----- | --- | -------- |
| Order Weight Total (Typically in lbs) | |||
| BusinessVolumeTotal | money | 8 | NOT NULL |
| ------------------- | ----- | --- | -------- |
| Order Business Volume Total | |||
| CommissionableVolumeTotal | money | 8 | NOT NULL |
| ------------------------- | ----- | --- | -------- |
| Order Commissionable Volume Total | |||
| TrackingNumber1 | nvarchar(50) | 100 | NOT NULL |
| --------------- | ------------ | --- | -------- |
| Order Tracking Number 1 | |||
| TrackingNumber2 | nvarchar(50) | 100 | NOT NULL |
| --------------- | ------------ | --- | -------- |
| Order Tracking Number 2 | |||
| TrackingNumber3 | nvarchar(50) | 100 | NOT NULL |
| --------------- | ------------ | --- | -------- |
| Order Tracking Number 3 | |||
| TrackingNumber4 | nvarchar(50) | 100 | NOT NULL |
| --------------- | ------------ | --- | -------- |
| Order Tracking Number 4 | |||
| TrackingNumber5 | nvarchar(50) | 100 | NOT NULL |
| --------------- | ------------ | --- | -------- |
| Order Tracking Number 5 | |||
| Other1Total | money | 8 | NOT NULL |
| ----------- | ----- | --- | -------- |
| Other 1 Total | |||
| Other2Total | money | 8 | NOT NULL |
| ----------- | ----- | --- | -------- |
| Other 2 Total | |||
| Other3Total | money | 8 | NOT NULL |
| ----------- | ----- | --- | -------- |
| Other 3 Total | |||
| Other4Total | money | 8 | NOT NULL |
| ----------- | ----- | --- | -------- |
| Other 4 Total | |||
| Other5Total | money | 8 | NOT NULL |
| ----------- | ----- | --- | -------- |
| Other 5 Total | |||
| Other6Total | money | 8 | NOT NULL |
| ----------- | ----- | --- | -------- |
| Other 6 Total |
Tables > dbo.Orders¶
| Other7Total | money | 8 | NOT NULL |
|---|---|---|---|
| Other 7 Total | |||
| Other8Total | money | 8 | NOT NULL |
| ----------- | ----- | --- | -------- |
| Other 8 Total | |||
| Other9Total | money | 8 | NOT NULL |
| ----------- | ----- | --- | -------- |
| Other 9 Total | |||
| Other10Total | money | 8 | NOT NULL |
| ------------ | ----- | --- | -------- |
| Other 10 Total | |||
| ShippingTax | money | 8 | NOT NULL |
| ----------- | ----- | --- | -------- |
| Order Shipping Tax | |||
| OrderTax | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Order Tax | |||
| FedTaxTotal | money | 8 | NOT NULL |
| ----------- | ----- | --- | -------- |
| Federal Tax Total | |||
| StateTaxTotal | money | 8 | NOT NULL |
| ------------- | ----- | --- | -------- |
| State Tax Total | |||
| FedShippingTax | money | 8 | NOT NULL |
| -------------- | ----- | --- | -------- |
| Federal Shipping Tax | |||
| StateShippingTax | money | 8 | NOT NULL |
| ---------------- | ----- | --- | -------- |
| Stat Shipping Tax | |||
| CityShippingTax | money | 8 | NOT NULL |
| --------------- | ----- | --- | -------- |
| City Shipping Tax | |||
| CityLocalShippingTax | money | 8 | NOT NULL |
| -------------------- | ----- | --- | -------- |
| City Local Shipping Tax | |||
| CountyShippingTax | money | 8 | NOT NULL |
| ----------------- | ----- | --- | -------- |
| County Shipping Tax | |||
| CountyLocalShippingTax | money | 8 | NOT NULL |
| ---------------------- | ----- | --- | -------- |
| County Local Shipping Tax | |||
| Other11 | nvarchar(200) | 400 | NULL allowed |
| ------- | ------------- | --- | ------------ |
| Other 11 | |||
| Other12 | nvarchar(200) | 400 | NULL allowed |
| ------- | ------------- | --- | ------------ |
| Other 12 | |||
| Other13 | nvarchar(200) | 400 | NULL allowed |
| ------- | ------------- | --- | ------------ |
| Other 13 | |||
| Other14 | nvarchar(200) | 400 | NULL allowed |
| ------- | ------------- | --- | ------------ |
| Other 14 | |||
| Other15 | nvarchar(200) | 400 | NULL allowed |
| ------- | ------------- | --- | ------------ |
| Other 15 | |||
| Other16 | nvarchar(200) | 400 | NULL allowed |
| ------- | ------------- | --- | ------------ |
| Other 16 | |||
| Other17 | nvarchar(200) | 400 | NULL allowed |
| ------- | ------------- | --- | ------------ |
| Other 17 | |||
| Other18 | nvarchar(200) | 400 | NULL allowed |
| ------- | ------------- | --- | ------------ |
| Other 18 | |||
| Other19 | nvarchar(200) | 400 | NULL allowed |
| ------- | ------------- | --- | ------------ |
| Other 19 | |||
| Other20 | nvarchar(200) | 400 | NULL allowed |
| ------- | ------------- | --- | ------------ |
| Other 20 | |||
| IsCommissionable | bit | 1 | NOT NULL |
| ---------------- | --- | --- | -------- |
| Is Commissionable? Boolean | |||
| AutoOrderID | int | 4 | NULL allowed |
| ----------- | --- | --- | ------------ |
| Auto Order ID - Map to dbo.AutoOrders |
Tables > dbo.Orders¶
| ReturnOrderID | int | 4 | NULL allowed |
|---|---|---|---|
| Return Order ID - Map to dbo.Orders | |||
| ReplacementOrderID | int | 4 | NULL allowed |
| ------------------ | --- | --- | ------------ |
| Replacement Order ID - Map to dbo.Orders | |||
| ParentOrderID | int | 4 | NULL allowed |
| ------------- | --- | --- | ------------ |
| Parent Order ID - Map to dbo.Orders | |||
| BatchID | int | 4 | NOT NULL |
| ------- | --- | --- | -------- |
| Batch ID | |||
| DeclineCount | int | 4 | NOT NULL |
| ------------ | --- | --- | -------- |
| Decline Count | |||
| TransferToCustomerID | int | 4 | NULL allowed |
| -------------------- | --- | --- | ------------ |
| Transfer To Customer ID - Map to dbo.Customers | |||
| PartyID | int | 4 | NULL allowed |
| ------- | --- | --- | ------------ |
| Party ID - Map to dbo.Parties | |||
| WebCarrierID1 | int | 4 | NULL allowed |
| ------------- | --- | --- | ------------ |
| Web Carrier ID 1 | |||
| WebCarrierID2 | int | 4 | NULL allowed |
| ------------- | --- | --- | ------------ |
| Web Carrier ID 2 | |||
| WebCarrierID3 | int | 4 | NULL allowed |
| ------------- | --- | --- | ------------ |
| Web Carrier ID 3 | |||
| WebCarrierID4 | int | 4 | NULL allowed |
| ------------- | --- | --- | ------------ |
| Web Carrier ID 4 | |||
| WebCarrierID5 | int | 4 | NULL allowed |
| ------------- | --- | --- | ------------ |
| Web Carrier ID 5 | |||
| ShippedDate | datetime | 8 | NULL allowed |
| ----------- | -------- | --- | ------------ |
| Shipped Date | |||
| CreatedDate | datetime | 8 | NOT NULL |
| ----------- | -------- | --- | -------- |
| Created Date | |||
| LockedDate | datetime | 8 | NULL allowed |
| ---------- | -------- | --- | ------------ |
| Locked Date | |||
| ModifiedDate | datetime | 8 | NOT NULL |
| ------------ | -------- | --- | -------- |
| Record Last Modified Date | |||
| CreatedBy | nvarchar(30) | 60 | NOT NULL |
| --------- | ------------ | --- | -------- |
| Created By User | |||
| ModifiedBy | nvarchar(30) | 60 | NOT NULL |
| ---------- | ------------ | --- | -------- |
| Record Last Modified By User | |||
| SuppressPackSlipPrice | bit | 1 | NOT NULL |
| --------------------- | --- | --- | -------- |
| Suppress Packing Slip Price? Boolean | |||
| ReturnCategoryID | int | 4 | NULL allowed |
| ---------------- | --- | --- | ------------ |
| Return Category ID - Map to dbo.ReturnCategories | |||
| ReplacementCategoryID | int | 4 | NULL allowed |
| --------------------- | --- | --- | ------------ |
| Replacement Category ID - Map to dbo.Replacement- | |||
| Categories | |||
| IsRMA | bit | 1 | NOT NULL |
| ----- | --- | --- | -------- |
| Is RMA? Boolean | |||
| TaxIntegrationCalculate | nvarchar(200) | 400 | NULL allowed |
| ----------------------- | ------------- | --- | ------------ |
| Tax Integration Calculate | |||
| TaxIntegrationCommit | nvarchar(200) | 400 | NULL allowed |
| -------------------- | ------------- | --- | ------------ |
| Tax Integration Commit | |||
| HandlingFee | money | 8 | NOT NULL |
| ----------- | ----- | --- | -------- |
| Handling Fee | |||
| PickupName | nvarchar(100) | 200 | NOT NULL |
| ---------- | ------------- | --- | -------- |
Tables > dbo.Orders¶
Pickup Name | TotalTaxable | money | 8 | NOT NULL | | ------------ | ----- | --- | -------- | Total Taxable Amount | OrderSubStatusID | int | 4 | NULL allowed | | ---------------- | --- | --- | ------------ | Order Sub Status ID | OrderKey | nvarchar(50) | 100 | NULL allowed | | -------- | ------------ | --- | ------------ | Order Key (Text Version of OrderID) | ReferralId | int | 4 | NULL allowed | | ---------- | --- | --- | ------------ | Referral ID Indexes | Key Name | Key Columns | Unique | Compression | | ----------------------- | ------------- | ------ | ----------- | | PK_Orders | OrderID | True | PAGE | | IX_Orders_CurrencyCode | CurrencyCode | | PAGE | | IX_Orders_CustomerID | CustomerID | | PAGE | | IX_Orders_OrderDate | OrderDate | | PAGE | | IX_Orders_OrderStatusID | OrderStatusID | | PAGE | | IX_Orders_PartyID | PartyID | | PAGE | | IX_Orders_ReturnOrderID | ReturnOrderID | | PAGE | | IX_Orders_WarehouseID | WarehouseID | | PAGE | Used By
[dbo].[CustomerTransactions]¶
[queue].[Refresh]¶
Tables > dbo.OrderStatusChangeLog¶
[dbo].[OrderStatusChangeLog]¶
MS_Description History of Order Status Changes Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------------------- | --------- | ------------------ | ----------- | | OrderStatusChangeLogID | int | 4 | NOT NULL | Unique ID | OrderID | int | 4 | NOT NULL | | ------- | --- | --- | -------- | Order ID - Map to dbo.Orders | OrderStatusID | int | 4 | NOT NULL | | ------------- | --- | --- | -------- | Order Status ID - Map to dbo.OrderStatuses | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date | ModifiedBy | nvarchar(30) | 60 | NOT NULL | | ---------- | ------------ | --- | -------- | Record Last Modified By User Indexes | Key Name | Key Columns | Unique | Compression | | ----------------------- | ------------------ | ------ | ----------- | | PK_OrderStatusChangeLog | OrderStatusChange- | True | PAGE | LogID | IX_OrderStatusChangeLog_OrderID | OrderID | | PAGE | | ------------------------------- | ------- | --- | ---- |
Tables > dbo.OrderStatuses¶
[dbo].[OrderStatuses]¶
MS_Description Order Status Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------- | --------- | ------------------ | ----------- | | OrderStatusID | int | 4 | NOT NULL | Unique ID | OrderStatusDescription | nvarchar(50) | 100 | NULL allowed | | ---------------------- | ------------ | --- | ------------ | Description Indexes | Key Name | | Key Columns | Unique Compression | | ---------------- | --- | ------------- | ------------------ | | PK_OrderStatuses | | OrderStatusID | True PAGE |
Tables > dbo.OrderStatusOrderSubStatuses¶
[dbo].[OrderStatusOrderSubStatuses]¶
MS_Description Order Status Order Sub Status Mapping Table Columns | Name | Data Type | Max Length (Bytes) | Nullability | | --------------------------- | --------- | ------------------ | ----------- | | OrderStatusOrderSubStatusID | int | 4 | NOT NULL | Unique ID | OrderStatusID | int | 4 | NOT NULL | | ------------- | --- | --- | -------- | Order Status ID - Map to dbo.OrderStatuses | OrderSubStatusID | int | 4 | NOT NULL | | ---------------- | --- | --- | -------- | Order Sub Status ID - Map to dbo.OrderSubStatusTypes
Tables > dbo.OrderSubStatusTypes¶
[dbo].[OrderSubStatusTypes]¶
MS_Description Order Sub Status Types Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------------- | --------- | ------------------ | ----------- | | OrderSubStatusID | int | 4 | NOT NULL | Unique ID | Description | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Description | IsDeleted | bit | 1 | NULL allowed | | --------- | --- | --- | ------------ | Is Deleted? Boolean Indexes | Key Name | Key Columns | | Unique Compression | | ---------------------- | ---------------- | --- | ------------------ | | PK_OrderSubStatusTypes | OrderSubStatusID | | True PAGE |
Tables > dbo.OrderTypes¶
[dbo].[OrderTypes]¶
MS_Description Order Types Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------- | --------- | ------------------ | ----------- | | OrderTypeID | int | 4 | NOT NULL | Unique ID | OrderTypeDescription | nvarchar(50) | 100 | NOT NULL | | -------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ------------- | ----------- | ------ | ----------- | | PK_OrderTypes | OrderTypeID | True | PAGE |
Tables > dbo.Overrides¶
[dbo].[Overrides]¶
MS_Description Overrides Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | PlanID | int | 4 | NOT NULL | Plan ID - Map to dbo.CommissionRuns | OverrideID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Unique ID | OverrideDescription | nvarchar(200) | 400 | NOT NULL | | ------------------- | ------------- | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ------------ | ------------------ | ------ | ----------- | | PK_Overrides | PlanID, OverrideID | True | PAGE |
Tables > dbo.Parties¶
[dbo].[Parties]¶
MS_Description Parties Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | -------- | --------- | ------- | ----------- | | PartyID | int | 4 | NOT NULL | Unique ID | HostID | int | 4 | NOT NULL | | ------ | --- | --- | -------- | Host ID - Map to dbo.Customers.CustomerID | DistributorID | int | 4 | NOT NULL | | ------------- | --- | --- | -------- | Distributor ID - Map to dbo.Customers.CustomerID | StartDate | datetime | 8 | NOT NULL | | --------- | -------- | --- | -------- | Party Start Date | CloseDate | datetime | 8 | NULL allowed | | --------- | -------- | --- | ------------ | Party Close Date | Description | nvarchar(100) | 200 | NOT NULL | | ----------- | ------------- | --- | -------- | Party Description | EventStartDate | datetime | 8 | NULL allowed | | -------------- | -------- | --- | ------------ | Event Start Date | EventEndDate | datetime | 8 | NULL allowed | | ------------ | -------- | --- | ------------ | Event End Date | PartyTypeID | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Party Type ID - Map to dbo.PartyTypes | PartyStatusID | int | 4 | NOT NULL | | ------------- | --- | --- | -------- | Party Status ID - Map to dbo.PartyStatuses | LanguageID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Language ID - Map to dbo.Languages | Information | nvarchar(500) | 1000 | NOT NULL | | ----------- | ------------- | ---- | -------- | Party Information | Address1 | nvarchar(100) | 200 | NOT NULL | | -------- | ------------- | --- | -------- | Party Address Line 1 | Address2 | nvarchar(100) | 200 | NOT NULL | | -------- | ------------- | --- | -------- | Party Address Line 2 | City | nvarchar(100) | 200 | NOT NULL | | ---- | ------------- | --- | -------- | Party City | State | nvarchar(50) | 100 | NOT NULL | | ----- | ------------ | --- | -------- | Party State | Zip | nvarchar(50) | 100 | NOT NULL | | --- | ------------ | --- | -------- | Party Zip | Country | nvarchar(50) | 100 | NOT NULL | | ------- | ------------ | --- | -------- | Party Country | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date
Tables > dbo.Parties¶
| BookingPartyID | int | 4 | NULL allowed |
|---|---|---|---|
| Booking Party ID | |||
| Field1 | nvarchar(250) | 500 | NULL allowed |
| ------ | ------------- | --- | ------------ |
| Custom Field | |||
| Field2 | nvarchar(250) | 500 | NULL allowed |
| ------ | ------------- | --- | ------------ |
| Custom Field | |||
| Field3 | nvarchar(250) | 500 | NULL allowed |
| ------ | ------------- | --- | ------------ |
| Custom Field | |||
| Field4 | nvarchar(250) | 500 | NULL allowed |
| ------ | ------------- | --- | ------------ |
| Custom Field | |||
| Field5 | nvarchar(250) | 500 | NULL allowed |
| ------ | ------------- | --- | ------------ |
| Custom Field | |||
| CreatedDate | datetime | 8 | NULL allowed |
| ----------- | -------- | --- | ------------ |
| Party Created Date | |||
| PartyExternalID | uniqueidentifier | 16 | NULL allowed |
| --------------- | ---------------- | --- | ------------ |
| Party External ID | |||
| PartyShoppingUrl | nvarchar(4000) | 8000 | NULL allowed |
| ---------------- | -------------- | ---- | ------------ |
| Party Shopping URL | |||
| TimezoneID | nvarchar(510) | 1020 | NULL allowed |
| ---------- | ------------- | ---- | ------------ |
| Timezone ID | |||
| VirtualMeetingLink | nvarchar(1000) | 2000 | NULL allowed |
| ------------------ | -------------- | ---- | ------------ |
| Virtual Meeting Link | |||
| Indexes | |||
| Key Name | Key Columns | Unique | Compression |
| ------------------------ | ------------- | ------ | ----------- |
| PK_Parties | PartyID | True | PAGE |
| IX_Parties_DistributorID | DistributorID | PAGE | |
| IX_Parties_HostID | HostID | PAGE |
Tables > dbo.PartyGuests¶
[dbo].[PartyGuests]¶
MS_Description Party Guests Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | PartyID | int | 4 | NOT NULL | Party ID - Map to dbo.Parties | GuestID | int | 4 | NOT NULL | | ------- | --- | --- | -------- | Guest ID - Map to dbo.Guests | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date Indexes | Key Name | Key Columns | Unique | Compression | | -------------- | ---------------- | ------ | ----------- | | PK_PartyGuests | PartyID, GuestID | True | PAGE |
Tables > dbo.PartyStatuses¶
[dbo].[PartyStatuses]¶
MS_Description Party Statuses Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------- | --------- | ------------------ | ----------- | | PartyStatusID | int | 4 | NOT NULL | Unique ID | PartyStatusDescription | nvarchar(100) | 200 | NOT NULL | | ---------------------- | ------------- | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ---------------- | ------------- | ------ | ----------- | | PK_PartyStatuses | PartyStatusID | True | PAGE |
Tables > dbo.PartyTypes¶
[dbo].[PartyTypes]¶
MS_Description Party Types Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------- | --------- | ------------------ | ----------- | | PartyTypeID | int | 4 | NOT NULL | Unique ID | PartyTypeDescription | nvarchar(100) | 200 | NOT NULL | | -------------------- | ------------- | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ------------- | ----------- | ------ | ----------- | | PK_PartyTypes | PartyTypeID | True | PAGE |
Tables > dbo.PayableTypes¶
[dbo].[PayableTypes]¶
MS_Description Payable Types Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------- | --------- | ------------------ | ----------- | | PayableTypeID | int | 4 | NOT NULL | Unique ID | PayableTypeDescription | nvarchar(50) | 100 | NULL allowed | | ---------------------- | ------------ | --- | ------------ | Description Indexes | Key Name | Key Columns | | Unique Compression | | --------------- | ------------- | --- | ------------------ | | PK_PayableTypes | PayableTypeID | | True PAGE |
Tables > dbo.PaymentCards¶
[dbo].[PaymentCards]¶
MS_Description Payment Cards Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | ------------- | --------- | ------- | ----------- | | PaymentCardID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | PaymentCardTypeID | int | 4 | NOT NULL | | ----------------- | --- | --- | -------- | Payment Card Type ID - Map to dbo.PaymentCardTypes | CardNumberDisplay | nvarchar(50) | 100 | NULL allowed | | ----------------- | ------------ | --- | ------------ | Payment Card Number (Masked) | IsPrimary | bit | 1 | NOT NULL | | --------- | --- | --- | -------- | Is Primary? Boolean | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date Indexes | Key Name | Key Columns | Unique | Compression | | -------------------------- | ------------- | ------ | ----------- | | PK_PaymentCards | PaymentCardID | True | PAGE | | IX_PaymentCards_CustomerID | CustomerID | | PAGE |
Tables > dbo.PaymentCardTypes¶
[dbo].[PaymentCardTypes]¶
MS_Description Payment Card Types Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------------- | --------- | ------------------ | ----------- | | PaymentCardTypeID | int | 4 | NOT NULL | Unique ID | PaymentCardTypeDescription | nvarchar(50) | 100 | NOT NULL | | -------------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ------------------- | ----------------- | ------ | ----------- | | PK_PaymentCardTypes | PaymentCardTypeID | True | PAGE |
Tables > dbo.Payments¶
[dbo].[Payments]¶
MS_Description Payments Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | --------- | --------- | ------- | ----------- | | PaymentID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | OrderID | int | 4 | NULL allowed | | ------- | --- | --- | ------------ | Order ID - Map to dbo.Orders | PaymentTypeID | int | 4 | NOT NULL | | ------------- | --- | --- | -------- | Payment Type ID - Map to dbo.PaymentTypes | PaymentDate | datetime | 8 | NOT NULL | | ----------- | -------- | --- | -------- | Payment Date | Amount | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Payment Amount in Currency Code | CurrencyCode | nvarchar(3) | 6 | NOT NULL | | ------------ | ----------- | --- | -------- | Currency Code - Map to dbo.Currencies | WarehouseID | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Warehouse ID - Map to dbo.Warehouses | BillingName | nvarchar(50) | 100 | NULL allowed | | ----------- | ------------ | --- | ------------ | Billing Name | CreditCardTypeID | int | 4 | NOT NULL | | ---------------- | --- | --- | -------- | Credit Card Type ID - Map to dbo.CreditCardTypes | CreditCardNumber | nvarchar(50) | 100 | NULL allowed | | ---------------- | ------------ | --- | ------------ | Credit Card Number (Masked) | AuthorizationCode | nvarchar(50) | 100 | NULL allowed | | ----------------- | ------------ | --- | ------------ | Authorization Code | CheckNumber | nvarchar(50) | 100 | NULL allowed | | ----------- | ------------ | --- | ------------ | Check Number | CheckAccountNumber | nvarchar(50) | 100 | NULL allowed | | ------------------ | ------------ | --- | ------------ | Check Account Number (Masked) | CheckRoutingNumber | nvarchar(50) | 100 | NULL allowed | | ------------------ | ------------ | --- | ------------ | Check Routing Number | CheckDate | datetime | 8 | NULL allowed | | --------- | -------- | --- | ------------ | Check Date | CheckBankName | nvarchar(100) | 200 | NULL allowed | | ------------- | ------------- | --- | ------------ | Check Bank Name | CheckBankAddress | nvarchar(100) | 200 | NULL allowed | | ---------------- | ------------- | --- | ------------ | Check Bank Address | CheckBankCityAddress | nvarchar(50) | 100 | NULL allowed | | -------------------- | ------------ | --- | ------------ | Check Bank City
Tables > dbo.Payments¶
| CheckBankStateAddress | nvarchar(50) | 100 | NULL allowed |
|---|---|---|---|
| Check Bank State | |||
| CheckBankZipAddress | nvarchar(50) | 100 | NULL allowed |
| ------------------- | ------------ | --- | ------------ |
| Check Bank Zip | |||
| Memo | nvarchar(500) | 1000 | NULL allowed |
| ---- | ------------- | ---- | ------------ |
| Memo | |||
| WalletTypeID | int | 4 | NULL allowed |
| ------------ | --- | --- | ------------ |
| Wallet Type ID - Map to dbo.WalletTypes | |||
| DriversLicenseNumber | nvarchar(50) | 100 | NULL allowed |
| -------------------- | ------------ | --- | ------------ |
| Drivers License Number (Masked) | |||
| MerchantTypeID | int | 4 | NULL allowed |
| -------------- | --- | --- | ------------ |
| Merchant Type ID - Map to dbo.Merchants | |||
| MerchantTransactionKey | nvarchar(300) | 600 | NULL allowed |
| ---------------------- | ------------- | --- | ------------ |
| Merchant Transaction Key | |||
| PointAccountID | int | 4 | NULL allowed |
| -------------- | --- | --- | ------------ |
| Point Account ID - Map to dbo.PointAccounts | |||
| BillingAddress1 | nvarchar(100) | 200 | NULL allowed |
| --------------- | ------------- | --- | ------------ |
| Billing Address Line 1 | |||
| BillingAddress2 | nvarchar(50) | 100 | NULL allowed |
| --------------- | ------------ | --- | ------------ |
| Billing Address Line 2 | |||
| BillingCity | nvarchar(50) | 100 | NULL allowed |
| ----------- | ------------ | --- | ------------ |
| Billing City | |||
| BillingState | nvarchar(50) | 100 | NULL allowed |
| ------------ | ------------ | --- | ------------ |
| Billing State | |||
| BillingZipAddress | nvarchar(50) | 100 | NULL allowed |
| ----------------- | ------------ | --- | ------------ |
| Billing Zip | |||
| BillingCountry | nvarchar(50) | 100 | NULL allowed |
| -------------- | ------------ | --- | ------------ |
| Billing Country | |||
| ModifiedDate | datetime | 8 | NOT NULL |
| ------------ | -------- | --- | -------- |
| Record Last Modified Date | |||
| Indexes | |||
| Key Name | Key Columns | Unique | Compression |
| ------------------- | ----------- | ------ | ----------- |
| PK_Payments | PaymentID | True | PAGE |
| IX_Payments_OrderID | OrderID | PAGE | |
| Used By |
[dbo].[CustomerTransactions]¶
[queue].[Refresh]¶
Tables > dbo.PaymentTypes¶
[dbo].[PaymentTypes]¶
MS_Description Payment Types Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------- | --------- | ------------------ | ----------- | | PaymentTypeID | int | 4 | NOT NULL | Unique ID | PaymentTypeDescription | nvarchar(50) | 100 | NOT NULL | | ---------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | --------------- | ------------- | ------ | ----------- | | PK_PaymentTypes | PaymentTypeID | True | PAGE |
Tables > dbo.PayoutBills¶
[dbo].[PayoutBills]¶
MS_Description Bills to be Paid Out Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------- | --------- | ------------------ | ----------- | | TransactionID | int | 4 | NOT NULL | Unique ID | PayoutID | int | 4 | NULL allowed | | -------- | --- | --- | ------------ | Payout ID - Map to dbo.Payouts | BillID | int | 4 | NULL allowed | | ------ | --- | --- | ------------ | Bill ID - Map to dbo.Bills | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date Indexes | Key Name | | Key Columns | Unique Compression | | -------------- | --- | ------------- | ------------------ | | PK_PayoutBills | | TransactionID | True PAGE |
Tables > dbo.Payouts¶
[dbo].[Payouts]¶
MS_Description Payouts Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | PayoutID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | PayoutDate | datetime | 8 | NOT NULL | | ---------- | -------- | --- | -------- | Payout Date | PayoutTypeID | int | 4 | NOT NULL | | ------------ | --- | --- | -------- | Payout Type ID - Map to dbo.PayoutTypes | CurrencyCode | nvarchar(3) | 6 | NOT NULL | | ------------ | ----------- | --- | -------- | Currency Code - Map to dbo.Currencies | Amount | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Payout Amount in Currency Code | PayeeName | nvarchar(101) | 202 | NULL allowed | | --------- | ------------- | --- | ------------ | Payee Name | PayeeCompany | nvarchar(100) | 200 | NOT NULL | | ------------ | ------------- | --- | -------- | Payee Company | PayeeAddress1 | nvarchar(100) | 200 | NULL allowed | | ------------- | ------------- | --- | ------------ | Payee Address Line 1 | PayeeAddress2 | nvarchar(100) | 200 | NULL allowed | | ------------- | ------------- | --- | ------------ | Payee Address Line 2 | PayeeCity | nvarchar(50) | 100 | NULL allowed | | --------- | ------------ | --- | ------------ | Payee City | PayeeState | nvarchar(50) | 100 | NULL allowed | | ---------- | ------------ | --- | ------------ | Payee State | PayeeZip | nvarchar(50) | 100 | NULL allowed | | -------- | ------------ | --- | ------------ | Payee Zip | PayeeCountry | nvarchar(50) | 100 | NULL allowed | | ------------ | ------------ | --- | ------------ | Payee Country | CheckNumber | int | 4 | NULL allowed | | ----------- | --- | --- | ------------ | Check Number | CheckDate | datetime | 8 | NULL allowed | | --------- | -------- | --- | ------------ | Check Date | VoidedDate | datetime | 8 | NULL allowed | | ---------- | -------- | --- | ------------ | Voided Date | DepositNumber | int | 4 | NULL allowed | | ------------- | --- | --- | ------------ | Deposit Number | IsTaxable | bit | 1 | NOT NULL | | --------- | --- | --- | -------- | Is Taxable? Boolean | BankAccountID | int | 4 | NOT NULL | | ------------- | --- | --- | -------- |
Tables > dbo.Payouts¶
Bank Account ID | Reference | nvarchar(50) | 100 | NOT NULL | | --------- | ------------ | --- | -------- | Reference | CreatedDate | datetime | 8 | NOT NULL | | ----------- | -------- | --- | -------- | Payout Created Date | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date | CreatedBy | nvarchar(30) | 60 | NOT NULL | | --------- | ------------ | --- | -------- | Payout Created by User | ModifiedBy | nvarchar(30) | 60 | NOT NULL | | ---------- | ------------ | --- | -------- | Record Last Modified By User Indexes | Key Name | | Key Columns | Unique Compression | | ---------- | --- | ----------- | ------------------ | | PK_Payouts | | PayoutID | True PAGE |
Tables > dbo.PayoutTypes¶
[dbo].[PayoutTypes]¶
MS_Description Payout Types Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------ | --------- | ------------------ | ----------- | | PayoutTypeID | int | 4 | NOT NULL | Unique ID | PayoutDescription | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | -------------- | ------------ | ------ | ----------- | | PK_PayoutTypes | PayoutTypeID | True | PAGE |
Tables > dbo.PeriodRankScores¶
[dbo].[PeriodRankScores]¶
MS_Description Period Rank Scores Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------ | --------- | ------------------ | ----------- | | PeriodTypeID | int | 4 | NOT NULL | Period Type ID - Map to dbo.PeriodTypes | PeriodID | int | 4 | NOT NULL | | -------- | --- | --- | -------- | Period ID - Map to dbo.Periods | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | PaidRankID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Current Paid Rank as of Period - Map to dbo.Ranks | Score | money | 8 | NOT NULL | | ----- | ----- | --- | -------- | Indexes | Key Name | Key Columns | Unique | Compression | | ------------------- | ------------------------ | ------ | ----------- | | PK_PeriodRankScores | PeriodTypeID, PeriodID, | True | PAGE | CustomerID, PaidRankID
Tables > dbo.Periods¶
[dbo].[Periods]¶
MS_Description Periods Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------ | --------- | ------------------ | ----------- | | PeriodTypeID | int | 4 | NOT NULL | Period Type ID - Map to dbo.PeriodTypes | PeriodID | int | 4 | NOT NULL | | -------- | --- | --- | -------- | Unique ID | PeriodDescription | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Description | StartDate | datetime | 8 | NOT NULL | | --------- | -------- | --- | -------- | Period Start Date | EndDate | datetime | 8 | NOT NULL | | ------- | -------- | --- | -------- | Period End Date | AcceptedDate | datetime | 8 | NULL allowed | | ------------ | -------- | --- | ------------ | Period Accept Date Indexes | Key Name | Key Columns | | Unique Compression | | ---------- | ---------------------- | --- | ------------------ | | PK_Periods | PeriodTypeID, PeriodID | | True PAGE |
Tables > dbo.PeriodTypes¶
[dbo].[PeriodTypes]¶
MS_Description Period Types Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------ | --------- | ------------------ | ----------- | | PeriodTypeID | int | 4 | NOT NULL | Unique ID | PeriodTypeDescription | nvarchar(50) | 100 | NOT NULL | | --------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | -------------- | ------------ | ------ | ----------- | | PK_PeriodTypes | PeriodTypeID | True | PAGE |
Tables > dbo.PeriodVolumes¶
[dbo].[PeriodVolumes]¶
MS_Description Period Volumes Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------ | --------- | ------------------ | ----------- | | PeriodTypeID | int | 4 | NOT NULL | Period Type ID - Map to dbo.PeriodTypes | PeriodID | int | 4 | NOT NULL | | -------- | --- | --- | -------- | Period ID - Map to dbo.Periods | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | RankID | int | 4 | NULL allowed | | ------ | --- | --- | ------------ | Rank ID - Map to dbo.Ranks | PaidRankID | int | 4 | NULL allowed | | ---------- | --- | --- | ------------ | Current Paid Rank ID - Map to dbo.Ranks | Volume1 | money | 8 | NOT NULL | | ------- | ----- | --- | -------- | Custom Volume Amount | Volume2 | money | 8 | NOT NULL | | ------- | ----- | --- | -------- | Custom Volume Amount | Volume3 | money | 8 | NOT NULL | | ------- | ----- | --- | -------- | Custom Volume Amount | Volume4 | money | 8 | NOT NULL | | ------- | ----- | --- | -------- | Custom Volume Amount | Volume5 | money | 8 | NOT NULL | | ------- | ----- | --- | -------- | Custom Volume Amount | Volume6 | money | 8 | NOT NULL | | ------- | ----- | --- | -------- | Custom Volume Amount | Volume7 | money | 8 | NOT NULL | | ------- | ----- | --- | -------- | Custom Volume Amount | Volume8 | money | 8 | NOT NULL | | ------- | ----- | --- | -------- | Custom Volume Amount | Volume9 | money | 8 | NOT NULL | | ------- | ----- | --- | -------- | Custom Volume Amount | Volume10 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume11 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume12 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume13 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume14 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume15 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- |
Tables > dbo.PeriodVolumes¶
Custom Volume Amount | Volume16 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume17 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume18 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume19 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume20 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume21 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume22 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume23 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume24 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume25 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume26 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume27 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume28 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume29 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume30 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume31 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume32 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume33 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume34 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume35 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume36 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume37 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume38 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume39 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount | Volume40 | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Custom Volume Amount
Tables > dbo.PeriodVolumes¶
| Volume41 | money | 8 | NOT NULL |
|---|---|---|---|
| Custom Volume Amount | |||
| Volume42 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume43 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume44 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume45 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume46 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume47 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume48 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume49 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume50 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume51 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume52 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume53 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume54 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume55 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume56 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume57 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume58 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume59 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume60 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume61 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume62 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume63 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume64 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume65 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume66 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount |
Tables > dbo.PeriodVolumes¶
| Volume67 | money | 8 | NOT NULL |
|---|---|---|---|
| Custom Volume Amount | |||
| Volume68 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume69 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume70 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume71 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume72 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume73 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume74 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume75 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume76 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume77 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume78 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume79 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume80 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume81 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume82 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume83 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume84 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume85 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume86 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume87 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume88 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume89 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume90 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume91 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume92 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount |
Tables > dbo.PeriodVolumes¶
| Volume93 | money | 8 | NOT NULL |
|---|---|---|---|
| Custom Volume Amount | |||
| Volume94 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume95 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume96 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume97 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume98 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume99 | money | 8 | NOT NULL |
| -------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume100 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume101 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume102 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume103 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume104 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume105 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume106 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume107 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume108 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume109 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume110 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume111 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume112 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume113 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume114 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume115 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume116 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume117 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume118 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount |
Tables > dbo.PeriodVolumes¶
| Volume119 | money | 8 | NOT NULL |
|---|---|---|---|
| Custom Volume Amount | |||
| Volume120 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume121 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume122 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume123 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume124 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume125 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume126 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume127 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume128 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume129 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume130 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume131 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume132 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume133 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume134 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume135 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume136 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume137 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume138 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume139 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume140 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume141 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume142 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume143 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume144 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount |
Tables > dbo.PeriodVolumes¶
| Volume145 | money | 8 | NOT NULL |
|---|---|---|---|
| Custom Volume Amount | |||
| Volume146 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume147 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume148 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume149 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume150 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume151 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume152 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume153 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume154 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume155 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume156 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume157 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume158 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume159 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume160 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume161 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume162 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume163 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume164 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume165 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume166 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume167 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume168 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume169 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume170 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount |
Tables > dbo.PeriodVolumes¶
| Volume171 | money | 8 | NOT NULL |
|---|---|---|---|
| Custom Volume Amount | |||
| Volume172 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume173 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume174 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume175 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume176 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume177 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume178 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume179 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume180 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume181 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume182 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume183 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume184 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume185 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume186 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume187 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume188 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume189 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume190 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume191 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume192 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume193 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume194 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume195 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume196 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount |
Tables > dbo.PeriodVolumes¶
| Volume197 | money | 8 | NOT NULL |
|---|---|---|---|
| Custom Volume Amount | |||
| Volume198 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume199 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| Volume200 | money | 8 | NOT NULL |
| --------- | ----- | --- | -------- |
| Custom Volume Amount | |||
| ModifiedDate | datetime | 8 | NOT NULL |
| ------------ | -------- | --- | -------- |
| Record Last Modified Date | |||
| OtherData1 | nvarchar(max) | max | NULL allowed |
| ---------- | ------------- | --- | ------------ |
| Custom Field | |||
| OtherData2 | nvarchar(max) | max | NULL allowed |
| ---------- | ------------- | --- | ------------ |
| Custom Field | |||
| OtherData3 | nvarchar(max) | max | NULL allowed |
| ---------- | ------------- | --- | ------------ |
| Custom Field | |||
| OtherData4 | nvarchar(max) | max | NULL allowed |
| ---------- | ------------- | --- | ------------ |
| Custom Field | |||
| OtherData5 | nvarchar(max) | max | NULL allowed |
| ---------- | ------------- | --- | ------------ |
| Custom Field | |||
| OtherData6 | nvarchar(max) | max | NULL allowed |
| ---------- | ------------- | --- | ------------ |
| Custom Field | |||
| OtherData7 | nvarchar(max) | max | NULL allowed |
| ---------- | ------------- | --- | ------------ |
| Custom Field | |||
| Indexes | |||
| Key Name | Key Columns | Unique Compression | |
| ---------------- | ------------------------ | --- | ------------------ |
| PK_PeriodVolumes | PeriodTypeID, PeriodID, | True PAGE | |
| CustomerID |
Tables > dbo.PointAccounts¶
[dbo].[PointAccounts]¶
MS_Description Point Accounts Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------------- | --------- | ------------------ | ----------- | | PointAccountID | int | 4 | NOT NULL | Unique ID | PointAccountDescription | nvarchar(50) | 100 | NOT NULL | | ----------------------- | ------------ | --- | -------- | Description | CurrencyCode | nvarchar(3) | 6 | NOT NULL | | ------------ | ----------- | --- | -------- | Currency Code - Map to dbo.Currencies | CanPayForOrders | bit | 1 | NULL allowed | | --------------- | --- | --- | ------------ | Can Pay For Orders? Boolean | LimitPaymentToSubTotal | bit | 1 | NULL allowed | | ---------------------- | --- | --- | ------------ | Limit Payment To SubTotal? Boolean Indexes | Key Name | Key Columns | | Unique Compression | | ---------------- | -------------- | --- | ------------------ | | PK_PointAccounts | PointAccountID | | True PAGE |
Tables > dbo.PointTransactions¶
[dbo].[PointTransactions]¶
MS_Description Point Transactions Columns Max Length | Key Name | Data Type | (Bytes) | Nullability | | ------------------ | --------- | ------- | ----------- | | PointTransactionID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | PointAccountID | int | 4 | NOT NULL | | -------------- | --- | --- | -------- | Point Account ID - Map to dbo.PointAccounts | Amount | money | 8 | NOT NULL | | ------ | ----- | --- | -------- | Point Amount | PointTransactionTypeID | int | 4 | NOT NULL | | ---------------------- | --- | --- | -------- | Point Transaction Type ID - Map to dbo.PointTransaction- Types | PaymentID | int | 4 | NULL allowed | | --------- | --- | --- | ------------ | Payment ID - Map to dbo.Payments | TransactionDate | datetime | 8 | NOT NULL | | --------------- | -------- | --- | -------- | Transaction Date | OrderID | int | 4 | NULL allowed | | ------- | --- | --- | ------------ | Order ID - Map to dbo.Orders | Reference | nvarchar(100) | 200 | NOT NULL | | --------- | ------------- | --- | -------- | Reference | CreatedBy | nvarchar(30) | 60 | NOT NULL | | --------- | ------------ | --- | -------- | Created By User Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------------- | ------------------ | ------ | ----------- | | PK_PointTransactions | PointTransactionID | True | PAGE | | IX_PointTransactions_CustomerID | CustomerID | | PAGE |
Tables > dbo.PointTransactionTypes¶
[dbo].[PointTransactionTypes]¶
MS_Description Point Transaction Types Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------------------- | --------- | ------------------ | ----------- | | PointTransactionTypeID | int | 4 | NOT NULL | Unique ID | PointTransactionTypeDescription | nvarchar(50) | 100 | NOT NULL | | ------------------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------ | ---------------------- | ------ | ----------- | | PK_PointTransactionTypes | PointTransactionTypeID | True | PAGE |
Tables > dbo.PriceTypes¶
[dbo].[PriceTypes]¶
MS_Description Price Types Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------- | --------- | ------------------ | ----------- | | PriceTypeID | int | 4 | NOT NULL | Unique ID | PriceTypeDescription | nvarchar(50) | 100 | NOT NULL | | -------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ------------- | ----------- | ------ | ----------- | | PK_PriceTypes | PriceTypeID | True | PAGE |
Tables > dbo.Ranks¶
[dbo].[Ranks]¶
MS_Description Ranks Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | RankID | int | 4 | NOT NULL | Unique ID | RankDescription | nvarchar(50) | 100 | NOT NULL | | --------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | -------- | ----------- | ------ | ----------- | | PK_Ranks | RankID | True | PAGE |
Tables > dbo.ReplacementCategories¶
[dbo].[ReplacementCategories]¶
MS_Description Replacement Categories Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------------- | --------- | ------------------ | ----------- | | ReplacementCategoryID | int | 4 | NOT NULL | Unique ID | ReplacementCategoryDescription | nvarchar(100) | 200 | NOT NULL | | ------------------------------ | ------------- | --- | -------- | Description | Enabled | bit | 1 | NOT NULL | | ------- | --- | --- | -------- | Is Enabled? Boolean Indexes | Key Name | Key Columns | Unique | Compression | | ------------------------ | --------------------- | ------ | ----------- | | PK_ReplacementCategories | ReplacementCategoryID | True | PAGE |
Tables > dbo.ReturnCategories¶
[dbo].[ReturnCategories]¶
MS_Description Return Categories Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------------- | --------- | ------------------ | ----------- | | ReturnCategoryID | int | 4 | NOT NULL | Unique ID | ReturnCategoryDescription | nvarchar(100) | 200 | NOT NULL | | ------------------------- | ------------- | --- | -------- | Description | Enabled | bit | 1 | NOT NULL | | ------- | --- | --- | -------- | Is Enabled? Boolean Indexes | Key Name | Key Columns | Unique | Compression | | ------------------- | ---------------- | ------ | ----------- | | PK_ReturnCategories | ReturnCategoryID | True | PAGE |
Tables > dbo.ShipCarriers¶
[dbo].[ShipCarriers]¶
MS_Description Ship Carriers Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------- | --------- | ------------------ | ----------- | | ShipCarrierID | int | 4 | NOT NULL | Unique ID | ShipCarrierDescription | nvarchar(50) | 100 | NOT NULL | | ---------------------- | ------------ | --- | -------- | Description | TrackingUrl | nvarchar(255) | 510 | NULL allowed | | ----------- | ------------- | --- | ------------ | Tracking URL Indexes | Key Name | | Key Columns | Unique Compression | | --------------- | --- | ------------- | ------------------ | | PK_ShipCarriers | | ShipCarrierID | True PAGE |
Tables > dbo.ShipMethods¶
[dbo].[ShipMethods]¶
MS_Description Ship Methods Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------ | --------- | ------------------ | ----------- | | ShipMethodID | int | 4 | NOT NULL | Unique ID | ShipMethodDescription | nvarchar(50) | 100 | NULL allowed | | --------------------- | ------------ | --- | ------------ | Description | WarehouseID | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Warehouse ID - Map to dbo.Warehouses | ShipCarrierID | int | 4 | NOT NULL | | ------------- | --- | --- | -------- | Ship Carrier ID - Map to dbo.ShipCarriers | DisplayOnWeb | bit | 1 | NOT NULL | | ------------ | --- | --- | -------- | Display on Web? Boolean Indexes | Key Name | | Key Columns | Unique Compression | | -------------- | --- | ------------ | ------------------ | | PK_ShipMethods | | ShipMethodID | True PAGE |
Tables > dbo.ShipRates¶
[dbo].[ShipRates]¶
MS_Description Ship Rates Columns | Name | Data Type | Max Length (Bytes) | Nullability | | ------------ | --------- | ------------------ | ----------- | | ShipMethodID | int | 4 | NOT NULL | Ship Method ID - Map to dbo.ShipMethods | CurrencyCode | nvarchar(3) | 6 | NOT NULL | | ------------ | ----------- | --- | -------- | Currency Code - Map to dbo.Currencies | ChargeLineID | int | 4 | NOT NULL | | ------------ | --- | --- | -------- | Charge Line ID | MinRange | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Minimum Range | MaxRange | money | 8 | NOT NULL | | -------- | ----- | --- | -------- | Maximum Range | FlatAmount | money | 8 | NOT NULL | | ---------- | ----- | --- | -------- | Flat Amount | PercentageAmount | money | 8 | NOT NULL | | ---------------- | ----- | --- | -------- | Percentage Amount | MinCharge | money | 8 | NOT NULL | | --------- | ----- | --- | -------- | Minimum Charge | ByPrice | bit | 1 | NOT NULL | | ------- | --- | --- | -------- | By Price? Boolean | ByWeight | bit | 1 | NOT NULL | | -------- | --- | --- | -------- | By Weight? Boolean | UsePercentage | bit | 1 | NOT NULL | | ------------- | --- | --- | -------- | Use Percentage? Boolean
Tables > dbo.SmsMessages¶
[dbo].[SmsMessages]¶
MS_Description SMS Messages Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------- | ---------------- | ------------------ | ----------- | | MessageID | uniqueidentifier | 16 | NOT NULL | Unique ID | MessageDate | datetime | 8 | NOT NULL | | ----------- | -------- | --- | -------- | Message Date | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | SmsStatusID | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | SMS Status ID - Map to dbo.SmsStatuses | ParentMessageID | uniqueidentifier | 16 | NULL allowed | | --------------- | ---------------- | --- | ------------ | Parent Message ID | FromNumber | nvarchar(30) | 60 | NOT NULL | | ---------- | ------------ | --- | -------- | From Number | ToNumber | nvarchar(30) | 60 | NOT NULL | | -------- | ------------ | --- | -------- | To Number | Message | nvarchar(max) | max | NOT NULL | | ------- | ------------- | --- | -------- | Message Text | Exception | nvarchar(500) | 1000 | NULL allowed | | --------- | ------------- | ---- | ------------ | Exception | ModifiedDate | datetime | 8 | NOT NULL | | ------------ | -------- | --- | -------- | Record Last Modified Date | BroadcastID | int | 4 | NULL allowed | | ----------- | --- | --- | ------------ | Broadcast ID - Map to dbo.Broadcasts Indexes | Key Name | | Key Columns | Unique Compression | | -------------- | --- | ----------- | ------------------ | | PK_SmsMessages | | MessageID | True PAGE |
Tables > dbo.SmsStatuses¶
[dbo].[SmsStatuses]¶
MS_Description SMS Statuses Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------- | --------- | ------------------ | ----------- | | SmsStatusID | int | 4 | NOT NULL | Unique ID | SmsStatusDescription | nvarchar(50) | 100 | NOT NULL | | -------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | -------------- | ----------- | ------ | ----------- | | PK_SmsStatuses | SmsStatusID | True | PAGE |
Tables > dbo.SocialNetworks¶
[dbo].[SocialNetworks]¶
MS_Description Social Networks Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------- | --------- | ------------------ | ----------- | | SocialNetworkID | int | 4 | NOT NULL | Unique ID | SocialNetworkDescription | nvarchar(100) | 200 | NOT NULL | | ------------------------ | ------------- | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ----------------- | --------------- | ------ | ----------- | | PK_SocialNetworks | SocialNetworkID | True | PAGE |
Tables > dbo.Subscriptions¶
[dbo].[Subscriptions]¶
MS_Description Subscriptions Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------------- | --------- | ------------------ | ----------- | | SubscriptionID | int | 4 | NOT NULL | Unique ID | SubscriptionDescription | nvarchar(50) | 100 | NOT NULL | | ----------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ---------------- | -------------- | ------ | ----------- | | PK_Subscriptions | SubscriptionID | True | PAGE |
Tables > dbo.TaxAddressTypes¶
[dbo].[TaxAddressTypes]¶
MS_Description Tax Address Types Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------------- | --------- | ------------------ | ----------- | | TaxAddressTypeID | int | 4 | NOT NULL | Unique ID | TaxAddressTypeDescription | nvarchar(50) | 100 | NOT NULL | | ------------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | ------------------ | ---------------- | ------ | ----------- | | PK_TaxAddressTypes | TaxAddressTypeID | True | PAGE |
Tables > dbo.TaxCodeTypes¶
[dbo].[TaxCodeTypes]¶
MS_Description Tax Code Types Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------- | --------- | ------------------ | ----------- | | TaxCodeTypeID | int | 4 | NOT NULL | Unique ID | TaxCodeDescription | nvarchar(50) | 100 | NOT NULL | | ------------------ | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | --------------- | ------------- | ------ | ----------- | | PK_TaxCodeTypes | TaxCodeTypeID | True | PAGE |
Tables > dbo.TaxNameTypes¶
[dbo].[TaxNameTypes]¶
MS_Description Tax Name Types Reference Table Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------- | --------- | ------------------ | ----------- | | TaxNameTypeID | int | 4 | NOT NULL | Unique ID | TaxNameTypeDescription | nvarchar(50) | 100 | NOT NULL | | ---------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | --------------- | ------------- | ------ | ----------- | | PK_TaxNameTypes | TaxNameTypeID | True | PAGE |
Tables > dbo.UniLevelTree¶
[dbo].[UniLevelTree]¶
MS_Description Unilevel Tree (Memory Optimized Table) Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ---------- | --------- | ------------------ | ----------- | | CustomerID | int | 4 | NOT NULL | Customer ID - Map to dbo.Customers | SponsorID | int | 4 | NOT NULL | | --------- | --- | --- | -------- | Sponsor ID - Map to dbo.Customers | NestedLevel | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Nested Level | Placement | int | 4 | NOT NULL | | --------- | --- | --- | -------- | Placement | Lft | int | 4 | NOT NULL | | --- | --- | --- | -------- | Index Left Boundary | Rgt | int | 4 | NOT NULL | | --- | --- | --- | -------- | Index Right Boundary Indexes | Key Name | | Key Columns | Unique | | --------------- | --- | ----------- | ------ | | PK_UniLevelTree | | CustomerID | True | Used By
[dbo].[UniLevelDownline]¶
[dbo].[UniLevelUpline]¶
Tables > dbo.UnilevelTreeHistory¶
[dbo].[UnilevelTreeHistory]¶
MS_Description History of Unilievel Tree Changes Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | --------------------- | --------- | ------------------ | ----------- | | UnilevelTreeHistoryID | int | 4 | NOT NULL | Unique ID | CustomerID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Customer ID - Map to dbo.Customers | MoveDate | datetime | 8 | NOT NULL | | -------- | -------- | --- | -------- | Move Date | PreviousSponsorID | int | 4 | NOT NULL | | ----------------- | --- | --- | -------- | Previous Sponsor ID - Map to dbo.Customers | PreviousNestedLevel | int | 4 | NOT NULL | | ------------------- | --- | --- | -------- | Previous Nested Level | NewSponsorID | int | 4 | NOT NULL | | ------------ | --- | --- | -------- | New Sponsor ID - Map to dbo.Customers | NewNestedLevel | int | 4 | NOT NULL | | -------------- | --- | --- | -------- | New Nested Level | Reason | nvarchar(1000) | 2000 | NOT NULL | | ------ | -------------- | ---- | -------- | Reason for Move | PreviousPlacement | int | 4 | NOT NULL | | ----------------- | --- | --- | -------- | Previous Placement | NewPlacement | int | 4 | NOT NULL | | ------------ | --- | --- | -------- | New Placement Indexes | Key Name | Key Columns | Unique | Compression | | ---------------------- | ----------------------- | ------ | ----------- | | PK_UnilevelTreeHistory | UnilevelTreeHistoryID, | True | PAGE | CustomerID
Tables > dbo.Users¶
[dbo].[Users]¶
MS_Description Users Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | UserID | int | 4 | NOT NULL | Unique ID | LoginName | nvarchar(100) | 200 | NOT NULL | | --------- | ------------- | --- | -------- | Login Name | FirstName | nvarchar(50) | 100 | NOT NULL | | --------- | ------------ | --- | -------- | First Name | LastName | nvarchar(50) | 100 | NOT NULL | | -------- | ------------ | --- | -------- | Last Name | Email | nvarchar(50) | 100 | NOT NULL | | ----- | ------------ | --- | -------- | Email | DepartmentID | int | 4 | NOT NULL | | ------------ | --- | --- | -------- | Department ID - Map to dbo.Departments | IsActive | bit | 1 | NOT NULL | | -------- | --- | --- | -------- | Is Active? Boolean | IsDeleted | bit | 1 | NOT NULL | | --------- | --- | --- | -------- | Is Deleted? Boolean Indexes | Key Name | Key Columns | Unique | Compression | | -------- | ----------- | ------ | ----------- | | PK_Users | UserID | True | PAGE |
Tables > dbo.VolumePushCycleLogs¶
[dbo].[VolumePushCycleLogs]¶
MS_Description Volume Push Cycle Logs Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------------------- | --------- | ------------------ | ----------- | | VolumePushCycleLogID | int | 4 | NOT NULL | Unique ID | CommissionPlanID | int | 4 | NULL allowed | | ---------------- | --- | --- | ------------ | Commission Plan ID - Map to dbo.Runs | PeriodID | int | 4 | NULL allowed | | -------- | --- | --- | ------------ | Period ID - Map to dbo.Periods | PeriodTypeID | int | 4 | NULL allowed | | ------------ | --- | --- | ------------ | Period Type ID - Map to dbo.PeriodTypes | VolumePushIsTrueUp | bit | 1 | NULL allowed | | ------------------ | --- | --- | ------------ | VP Is a True Up? Boolean | VolumePushCycleStartDate | datetime | 8 | NULL allowed | | ------------------------ | -------- | --- | ------------ | VP Cycle Start Date | VolumePushCycleEndDate | datetime | 8 | NULL allowed | | ---------------------- | -------- | --- | ------------ | VP Cycle End Date | VolumePushCycleErrorDate | datetime | 8 | NULL allowed | | ------------------------ | -------- | --- | ------------ | VP Cycle Error Date Indexes | Key Name | Key Columns | | Unique Compression | | ---------------------- | -------------------- | --- | ------------------ | | PK_VolumePushCycleLogs | VolumePushCycleLogID | | True PAGE |
Tables > dbo.WalletTypes¶
[dbo].[WalletTypes]¶
MS_Description Wallet Types Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ------------ | --------- | ------------------ | ----------- | | WalletTypeID | int | 4 | NOT NULL | Unique ID | WalletTypeDescription | nvarchar(50) | 100 | NOT NULL | | --------------------- | ------------ | --- | -------- | Description Indexes | Key Name | Key Columns | Unique | Compression | | -------------- | ------------ | ------ | ----------- | | PK_WalletTypes | WalletTypeID | True | PAGE |
Tables > dbo.WarehouseCurrencies¶
[dbo].[WarehouseCurrencies]¶
MS_Description Warehouse Currencies Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------- | --------- | ------------------ | ----------- | | WarehouseID | int | 4 | NOT NULL | Warehouse ID - Map to dbo.Warehouses | CurrencyCode | nvarchar(3) | 6 | NOT NULL | | ------------ | ----------- | --- | -------- | Currency Code - Map to dbo.Currencies | Priority | int | 4 | NOT NULL | | -------- | --- | --- | -------- | Priority for Sorting Indexes | Key Name | Key Columns | Unique | Compression | | ---------------------- | ---------------------- | ------ | ----------- | | PK_WarehouseCurrencies | WarehouseID, Currency- | True | PAGE | Code
Tables > dbo.Warehouses¶
[dbo].[Warehouses]¶
MS_Description Warehouses Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | ----------- | --------- | ------------------ | ----------- | | WarehouseID | int | 4 | NOT NULL | Unique ID | WarehouseDescription | nvarchar(50) | 100 | NOT NULL | | -------------------- | ------------ | --- | -------- | Warehouse Description | WarehouseAddress1 | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Warehouse Address Line 1 | WarehouseAddress2 | nvarchar(50) | 100 | NOT NULL | | ----------------- | ------------ | --- | -------- | Warehouse Address Line 2 | WarehouseCity | nvarchar(30) | 60 | NOT NULL | | ------------- | ------------ | --- | -------- | Warehouse City | WarehouseState | nvarchar(10) | 20 | NOT NULL | | -------------- | ------------ | --- | -------- | Warehouse State | WarehouseZip | nvarchar(20) | 40 | NOT NULL | | ------------ | ------------ | --- | -------- | Warehouse Zip | WarehouseCountry | nvarchar(20) | 40 | NOT NULL | | ---------------- | ------------ | --- | -------- | Warehouse Country | TimeZoneID | int | 4 | NOT NULL | | ---------- | --- | --- | -------- | Timezone ID Indexes | Key Name | Key Columns | Unique | Compression | | ------------- | ----------- | ------ | ----------- | | PK_Warehouses | WarehouseID | True | PAGE |
Tables > dbo.WebCategories¶
[dbo].[WebCategories]¶
MS_Description Web Categories Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | WebID | int | 4 | NOT NULL | Web ID | WebCategoryID | int | 4 | NOT NULL | | ------------- | --- | --- | -------- | Unique ID | ParentID | int | 4 | NULL allowed | | -------- | --- | --- | ------------ | Parent ID | WebCategoryDescription | nvarchar(50) | 100 | NOT NULL | | ---------------------- | ------------ | --- | -------- | Description | NestedLevel | int | 4 | NOT NULL | | ----------- | --- | --- | -------- | Nested Level | SortOrder | int | 4 | NOT NULL | | --------- | --- | --- | -------- | Sort Order Indexes | Key Name | Key Columns | | Unique Compression | | ---------------- | -------------------- | --- | ------------------ | | PK_WebCategories | WebID, WebCategoryID | | True PAGE |
Tables > dbo.WebCategoryItems¶
[dbo].[WebCategoryItems]¶
MS_Description Web Category Items Columns | Key Name | Data Type | Max Length (Bytes) | Nullability | | -------- | --------- | ------------------ | ----------- | | WebID | int | 4 | NOT NULL | Web ID | WebCategoryID | int | 4 | NOT NULL | | ------------- | --- | --- | -------- | Web Category ID - Map to dbo.WebCategories | ItemID | int | 4 | NOT NULL | | ------ | --- | --- | -------- | Item ID - Map to dbo.Items | SortOrder | int | 4 | NOT NULL | | --------- | --- | --- | -------- | Sort Order Indexes | Key Name | Key Columns | Unique | Compression | | ------------------- | ---------------------- | ------ | ----------- | | PK_WebCategoryItems | WebID, WebCategoryID, | True | PAGE | ItemID
Views¶
Views
Objects¶
Name dbo.BinaryDownline Downline View for Binary Tree dbo.BinaryUpline Upline View for Binary Tree dbo.CustomerTransactions Customer Transactions dbo.EnrollerDownline Downline View for Enroller Tree dbo.EnrollerUpline Upline View for Enroller Tree dbo.UniLevelDownline Downline View for Unilevel Tree dbo.UniLevelUpline Upline View for Unllevel Tree
Views > dbo.BinaryDownline¶
[dbo].[BinaryDownline]¶
MS_Description Downline View for Binary Tree Columns | Name | Data Type | Max Length (Bytes) | | ------------------ | --------- | ------------------ | | DownlineCustomerID | int | 4 | | CustomerID | int | 4 | | ParentID | int | 4 | | Level | int | 4 | | Placement | int | 4 | | IndentedSort | int | 4 | SQL Script CREATE view [dbo].[BinaryDownline] as
Select DownlineCustomerID = tp.CustomerID,
t.CustomerID,
t.ParentID,
Level = t.NestedLevel - tp.NestedLevel,
t.Placement,
IndentedSort = t.lft
From BinaryTree tp
inner Join BinaryTree t
on t.lft between tp.lft and tp.rgt
GO EXEC sp_addextendedproperty N'MS_Description', N'Downline View for Binary Tree', 'SCHEMA', N'dbo', 'VIEW', N'BinaryDownline', NULL, NULL GO Uses
[dbo].[BinaryTree]¶
Views > dbo.BinaryUpline¶
[dbo].[BinaryUpline]¶
MS_Description Upline View for Binary Tree Columns | Name | Data Type | Max Length (Bytes) | | ---------------- | --------- | ------------------ | | UplineCustomerID | int | 4 | | CustomerID | int | 4 | | ParentID | int | 4 | | Level | int | 4 | | Placement | int | 4 | | IndentedSort | int | 4 | SQL Script CREATE view [dbo].[BinaryUpline] as
Select UplineCustomerID = tp.CustomerID,
t.CustomerID,
t.ParentID,
Level = t.NestedLevel - tp.NestedLevel,
t.Placement,
IndentedSort = t.lft
From BinaryTree tp
inner Join BinaryTree t
on t.lft <= tp.lft and t.rgt >= tp.rgt
GO EXEC sp_addextendedproperty N'MS_Description', N'Upline View for Binary Tree', 'SCHEMA', N'dbo', 'VIEW', N'BinaryUpline', NULL, NULL GO Uses
[dbo].[BinaryTree]¶
Views > dbo.CustomerTransactions¶
[dbo].[CustomerTransactions]¶
MS_Description Customer Transactions Columns | Name | Data Type | Max Length (Bytes) | | ----------------- | ----------- | ------------------ | | CustomerID | int | 4 | | TransactionTypeID | int | 4 | | OrderID | int | 4 | | PaymentID | int | 4 | | AdjustmentID | int | 4 | | TransactionDate | datetime | 8 | | CurrencyCode | nvarchar(3) | 6 | | Amount | money | 8 | SQL Script CREATE view [dbo].[CustomerTransactions] as
select CustomerID,
TransactionTypeID = 0,
OrderID,
PaymentID=null,
AdjustmentID=null,
TransactionDate=OrderDate,
CurrencyCode,
-- Cancelled Orders and AutoOrders less than accepted do not count towards the
balance Amount=case when OrderStatusID=4 or (OrderTypeID=8 and OrderStatusID < 7) then 0 else Total end from Orders o union select CustomerID, TransactionTypeID = 1, OrderID, PaymentID, null, TransactionDate = PaymentDate, CurrencyCode, Amount = -Amount from Payments p
Views > dbo.CustomerTransactions¶
union select CustomerID, ca.CustomerTransactionTypeID, null, null, TransactionID, TransactionDate, CurrencyCode, Amount from CustomerAdjustments ca GO EXEC sp_addextendedproperty N'MS_Description', N'Customer Transactions', 'SCHEMA', N'dbo', 'VIEW', N'CustomerTransactions', NULL, NULL GO Uses
[dbo].[CustomerAdjustments]¶
[dbo].[Orders]¶
[dbo].[Payments]¶
Views > dbo.EnrollerDownline¶
[dbo].[EnrollerDownline]¶
MS_Description Downline View for Enroller Tree Columns Name Data Type Max Length (Bytes) DownlineCustomerID int 4 CustomerID int 4 EnrollerID int 4 Level int 4 IndentedSort int 4 SQL Script CREATE view [dbo].[EnrollerDownline] as Select DownlineCustomerID = tp.CustomerID, t.CustomerID, t.EnrollerID, Level = t.NestedLevel - tp.NestedLevel, IndentedSort = t.lft From EnrollerTree tp inner Join EnrollerTree t on t.lft between tp.lft and tp.rgt GO EXEC sp_addextendedproperty N'MS_Description', N'Downline View for Enroller Tree', 'SCHEMA', N'dbo', 'VIEW', N'EnrollerDownline', NULL, NULL GO Uses
[dbo].[EnrollerTree]¶
Views > dbo.EnrollerUpline¶
[dbo].[EnrollerUpline]¶
MS_Description Upline View for Enroller Tree Columns Name Data Type Max Length (Bytes) UplineCustomerID int 4 CustomerID int 4 EnrollerID int 4 Level int 4 IndentedSort int 4 SQL Script CREATE view [dbo].[EnrollerUpline] as Select UplineCustomerID = tp.CustomerID, t.CustomerID, t.EnrollerID, Level = t.NestedLevel - tp.NestedLevel, IndentedSort = t.lft From EnrollerTree tp inner Join EnrollerTree t on t.lft <= tp.lft and t.rgt >= tp.rgt GO EXEC sp_addextendedproperty N'MS_Description', N'Upline View for Enroller Tree', 'SCHEMA', N'dbo', 'VIEW', N'EnrollerUpline', NULL, NULL GO Uses
[dbo].[EnrollerTree]¶
Views > dbo.UniLevelDownline¶
[dbo].[UniLevelDownline]¶
MS_Description Downline View for Unilevel Tree Columns | Name | Data Type | Max Length (Bytes) | | ------------------ | --------- | ------------------ | | DownlineCustomerID | int | 4 | | CustomerID | int | 4 | | SponsorID | int | 4 | | Level | int | 4 | | Placement | int | 4 | | IndentedSort | int | 4 | SQL Script CREATE view [dbo].[UniLevelDownline] as
Select DownlineCustomerID = tp.CustomerID,
t.CustomerID,
t.SponsorID,
Level = t.NestedLevel - tp.NestedLevel,
t.Placement,
IndentedSort = t.lft
From UniLevelTree tp
inner Join UniLevelTree t
on t.lft between tp.lft and tp.rgt
GO EXEC sp_addextendedproperty N'MS_Description', N'Downline View for Unilevel Tree', 'SCHEMA', N'dbo', 'VIEW', N'UniLevelDownline', NULL, NULL GO Uses
[dbo].[UniLevelTree]¶
Views > dbo.UniLevelUpline¶
[dbo].[UniLevelUpline]¶
MS_Description Upline View for Unllevel Tree Columns | Name | Data Type | Max Length (Bytes) | | ---------------- | --------- | ------------------ | | UplineCustomerID | int | 4 | | CustomerID | int | 4 | | SponsorID | int | 4 | | Level | int | 4 | | Placement | int | 4 | | IndentedSort | int | 4 | SQL Script CREATE view [dbo].[UniLevelUpline] as
Select UplineCustomerID = tp.CustomerID,
t.CustomerID,
t.SponsorID,
Level = t.NestedLevel - tp.NestedLevel,
t.Placement,
IndentedSort = t.lft
From UniLevelTree tp
inner Join UniLevelTree t
on t.lft <= tp.lft and t.rgt >= tp.rgt
GO EXEC sp_addextendedproperty N'MS_Description', N'Upline View for Unllevel Tree', 'SCHEMA', N'dbo', 'VIEW', N'UniLevelUpline', NULL, NULL GO Uses
[dbo].[UniLevelTree]¶
Programmability > Stored Procedures¶
Stored Procedures
Objects¶
Name cache.ExpireSessions Expire Cached Web Sessions cache.Get Get Cached Cart cache.GetSession Get Cached Web Session cache.Purge Purge Cached Carts cache.Set Insert Cart to Caching Table cache.SetSession Insert Web Session to Caching Table dbo.AuthenticateCustomer Customer Authentication for User/PasswordHash in the dbo.Customers table dbo.CommandExecute Used for Maintenance Functions dbo.IndexOptimize Index Optimization queue.Refresh Update Cached Cart
Programmability > Stored Procedures > cache.Expire-¶
Sessions
[cache].[ExpireSessions]¶
MS_Description Expire Cached Web Sessions SQL Script create procedure [cache].[ExpireSessions] WITH EXECUTE AS OWNER as BEGIN DELETE cache.Session Where ModifiedDate < DATEADD(day,-2,Getdate()) END GO EXEC sp_addextendedproperty N'MS_Description', N'Expire Cached Web Sessions', 'SCHEMA', N'cache', 'PROCEDURE', N'ExpireSessions', NULL, NULL GO Uses
[cache].[Session]¶
[cache]
Programmability > Stored Procedures > cache.Get¶
[cache].[Get]¶
MS_Description Get Cached Cart Parameters Name Data Type Max Length (Bytes) @ID nvarchar(1000) 2000 SQL Script create procedure [cache].[Get] (@ID nvarchar(1000)) as BEGIN Select ID, Data, CreatedDate, SecondsToLive, CurrentDate = GetUtcDate() From cache.Store where ID = @ID END GO EXEC sp_addextendedproperty N'MS_Description', N'Get Cached Cart', 'SCHEMA', N'cache', 'PROCEDURE', N'Get', NULL, NULL GO Uses
[cache].[Store]¶
[cache]
Programmability > Stored Procedures > cache.Get-¶
Session
[cache].[GetSession]¶
MS_Description Get Cached Web Session Parameters Name Data Type Max Length (Bytes) @SessionID uniqueidentifier 16 SQL Script create procedure [cache].[GetSession] ( @SessionID uniqueidentifier ) WITH EXECUTE AS OWNER as BEGIN Select Data From cache.session where SessionID =@SessionID END GO EXEC sp_addextendedproperty N'MS_Description', N'Get Cached Web Session', 'SCHEMA', N'cache', 'PROCEDURE', N'GetSession', NULL, NULL GO Uses
[cache].[Session]¶
[cache]
Programmability > Stored Procedures > cache.Purge¶
[cache].[Purge]¶
MS_Description Purge Cached Carts SQL Script create procedure [cache].[Purge] as BEGIN DELETE cache.Store WHERE DATEADD(ss,SecondsToLive,CreatedDate) < GetUtcDate() END GO EXEC sp_addextendedproperty N'MS_Description', N'Purge Cached Carts', 'SCHEMA', N'cache', 'PROCEDURE', N'Purge', NULL, NULL GO Uses
[cache].[Store]¶
[cache]
Programmability > Stored Procedures > cache.Set¶
[cache].[Set]¶
MS_Description Insert Cart to Caching Table Parameters Name Data Type Max Length (Bytes) @ID nvarchar(1000) 2000 @SecondsToLive bigint 8 @Data nvarchar(max) max SQL Script create procedure [cache].[Set] ( @ID nvarchar(1000), @SecondsToLive bigint, @Data nvarchar(max) ) as BEGIN Update cache.Store Set Data = @Data, SecondstoLive=@SecondsToLive, Created- Date=GetUtcDate() Where ID=@ID if @@Rowcount = 0 begin Insert [cache].Store values(@ID, @Data, GetUtcDate(), @SecondsToLive) end END GO EXEC sp_addextendedproperty N'MS_Description', N'Insert Cart to Caching Table', 'SCHEMA', N'cache', 'PROCEDURE', N'Set', NULL, NULL GO Uses
[cache].[Store]¶
[cache]
Programmability > Stored Procedures > cache.Set-¶
Session
[cache].[SetSession]¶
MS_Description Insert Web Session to Caching Table Parameters Name Data Type Max Length (Bytes) @SessionID uniqueidentifier 16 @Data nvarchar(max) max SQL Script create procedure [cache].[SetSession] ( @SessionID uniqueidentifier, @Data nvarchar(max) ) WITH EXECUTE AS OWNER as BEGIN Update cache.Session Set Data = @Data, ModifiedDate=GetDate() Where SessionID=@SessionID if @@Rowcount = 0 begin Insert [cache].Session values(@SessionID, GetDate(), @Data) end END GO EXEC sp_addextendedproperty N'MS_Description', N'Insert Web Session to Caching Table', 'SCHEMA', N'cache', 'PROCEDURE', N'SetSession', NULL, NULL GO Uses
[cache].[Session]¶
[cache]
Programmability > Stored Procedures >¶
dbo.AuthenticateCustomer
[dbo].[AuthenticateCustomer]¶
MS_Description Customer Authentication for User/PasswordHash in the dbo.Customers table Parameters Name Data Type Max Length (Bytes) @LoginName nvarchar(500) 1000 @Password nvarchar(500) 1000 SQL Script CREATE procedure [dbo].[AuthenticateCustomer] ( @LoginName nvarchar(500), @Password nvarchar(500) ) as begin SET NOCOUNT ON DECLARE @PasswordHash varbinary(50), @Salt binary(8), @TestPasswordHash varbinary(50), @CanLogin bit, @CustomerID int, @Combined varbinary(max), @IsAuthenticated bit = 0, @FirstName nvarchar(50) = '', @LastName nvarchar(50) = '' SELECT @PasswordHash = PasswordHash, @CustomerID = CustomerID, @FirstName = FirstName, @LastName = LastName, @CanLogin = CanLogin FROM Customers WHERE LoginName=@LoginName IF @PasswordHash is not null and @CanLogin = 1 BEGIN set @Salt = substring(@PasswordHash, 21, 8) set @Combined = cast(@Password as varbinary(max)) + @Salt
Programmability > Stored Procedures >¶
dbo.AuthenticateCustomer set @TestPasswordHash = hashbytes('SHA1', @combined) + @Salt set @IsAuthenticated = case when @PasswordHash = @TestPasswordHash then 1 else 0 end END IF @IsAuthenticated=1 BEGIN Select @CustomerID AS CustomerID, @FirstName AS FirstName, @LastName AS LastName END ELSE BEGIN Select CustomerID, FirstName, LastName From Customers Where 1 = 0 END END GO EXEC sp_addextendedproperty N'MS_Description', N'Customer Authentication for User/PasswordHash in the dbo.Customers table', 'SCHEMA', N'dbo', 'PROCEDURE', N'AuthenticateCustomer', NULL, NULL GO Uses
[dbo].[Customers]¶
Programmability > Stored Procedures > dbo.Command-¶
Execute
[dbo].[CommandExecute]¶
MS_Description Used for Maintenance Functions Uses
[dbo].[CommandLog]¶
Used By
[dbo].[IndexOptimize]¶
Programmability > Stored Procedures > dbo.Index-¶
Optimize
[dbo].[IndexOptimize]¶
MS_Description Index Optimization Uses
[dbo].[CommandExecute]¶
[queue]
Programmability > Stored Procedures > queue.Refresh¶
[queue].[Refresh]¶
MS_Description Update Cached Cart Parameters Name Data Type Max Length (Bytes) @ManualStartDate datetime 8 SQL Script CREATE procedure [queue].[Refresh] ( @ManualStartDate datetime = null ) as set xact_abort on begin tran /***** * If this is the first time, pull 24 hrs ****/ if @ManualStartDate is null and not exists (select * from queue.Controller) begin set @ManualStartDate = getdate()-1 end /**** * If this is a reset, let's reset *******/ if @ManualStartDate is not null begin update queue.Controller set ModifiedDate = @ManualStartDate where tablename = 'Customers' if @@rowcount = 0 insert queue.controller values('Customers', @ManualStartDate) update queue.Controller set ModifiedDate = @ManualStartDate where tablename = 'CustomerAccounts' if @@rowcount = 0
Programmability > Stored Procedures > queue.Refresh¶
insert queue.controller values('CustomerAccounts', @ManualStartDate) update queue.Controller set ModifiedDate = @ManualStartDate where tablename = 'CustomerSites' if @@rowcount = 0 insert queue.controller values('CustomerSites', @ManualStartDate) update queue.Controller set ModifiedDate = @ManualStartDate where tablename = 'Orders' if @@rowcount = 0 insert queue.controller values('Orders', @ManualStartDate) end /***** * Clear out existing tables ******/ --> Orders if object_id('queue.orders') is not null drop table queue.orders select * into queue.Orders from orders where OrderID is null alter table queue.Orders add constraint PK_Orders_1 primary key clustered (OrderID) --> OrderDetail if object_id('queue.OrderDetails') is not null drop table queue.OrderDetails select * into queue.OrderDetails from OrderDetails where OrderID is null alter table queue.OrderDetails add constraint PK_OrderDetail_1 primary key clustered (Order- ID, OrderLine) --> Payments if object_id('queue.Payments') is not null drop table queue.Payments select * into queue.Payments from Payments where PaymentID is null alter table queue.Payments add constraint PK_Payments_1 primary key clustered (PaymentID) --> Customers if object_id('queue.Customers') is not null drop table queue.Customers select * into queue.Customers from Customers where CustomerID is null alter table queue.Customers add constraint PK_Customers_1 primary key clustered (CustomerID) --> CustomerAccounts if object_id('queue.CustomerAccounts') is not null drop table queue.CustomerAccounts select * into queue.CustomerAccounts from CustomerAccounts where CustomerID is null alter table queue.CustomerAccounts add constraint PK_CustomerAccounts_1 primary key clustered (CustomerID) --> CustomerAccounts if object_id('queue.CustomerSites') is not null drop table queue.CustomerSites select * into queue.CustomerSites from CustomerSites where CustomerID is null alter table queue.CustomerSites add constraint PK_CustomerSites_1 primary key clustered (CustomerID)
Programmability > Stored Procedures > queue.Refresh¶
/***** * Pull in new data ****/ exec sp_executesql N' insert queue.orders select * from dbo.orders where ModifiedDate > (select modifieddate from queue.Controller where tablename = ''orders'') insert queue.OrderDetails select * from dbo.orderdetails where orderid in (select orderid from queue.orders) insert queue.Payments select * from dbo.Payments where orderid in (select orderid from queue.orders) insert queue.Customers select * from dbo.Customers where ModifiedDate > (select modifieddate from queue.Controller where tablename = ''customers'') --> Now pull in any customers for orders not in the set already insert queue.Customers select * from dbo.Customers where CustomerID in (select CustomerID from queue.orders) and CustomerID not in (select customerid from queue.Customers) insert queue.CustomerAccounts select * from dbo.CustomerAccounts where ModifiedDate > (select modifieddate from queue.Controller where tablename = ''customeraccounts'') insert queue.CustomerSites select * from dbo.CustomerSites where ModifiedDate > (select modifieddate from queue.Controller where tablename = ''customersites'') ' /**** * Update modified dates *******/ declare @maxModified datetime select @maxModified = max(modifieddate) from queue.orders if @maxModified is not null begin update queue.Controller set ModifiedDate = @maxModified where tablename = 'Orders' if @@rowcount = 0 insert queue.controller values('Orders', @maxModified) end set @maxModified = null select @maxModified = max(modifieddate) from queue.customers if @maxModified is not null begin update queue.Controller set ModifiedDate = @maxModified where tablename = 'Customers' if @@rowcount = 0 insert queue.controller values('Customers', @maxModified)
Programmability > Stored Procedures > queue.Refresh¶
end set @maxModified = null select @maxModified = max(modifieddate) from queue.customeraccounts if @maxModified is not null begin update queue.Controller set ModifiedDate = @maxModified where tablename = 'CustomerAccounts' if @@rowcount = 0 insert queue.controller values('CustomerAccounts', @maxModified) end set @maxModified = null select @maxModified = max(modifieddate) from queue.customersites if @maxModified is not null begin update queue.Controller set ModifiedDate = @maxModified where tablename = 'CustomerSites' if @@rowcount = 0 insert queue.controller values('CustomerSites', @maxModified) end commit tran /***** * Add cache.Store ******/ GO EXEC sp_addextendedproperty N'MS_Description', N'Update Cached Cart', 'SCHEMA', N'queue', 'PROCEDURE', N'Refresh', NULL, NULL GO Uses
[dbo].[CustomerAccounts]¶
[dbo].[Customers]¶
[dbo].[CustomerSites]¶
[dbo].[OrderDetails]¶
[dbo].[Orders]¶
[dbo].[Payments]¶
[queue]
[queue].[Controller]¶
Programmability > Functions > Scalar-valued Functions¶
Scalar-valued Functions
Objects¶
Name dbo.GetLocalDate Returns Date in Central US Time dbo.VerifyCustomerTempAuthHash Verifies Customer Password Hash
Programmability > Functions > Scalar-valued Functions¶
dbo.GetLocalDate
[dbo].[GetLocalDate]¶
MS_Description Returns Date in Central US Time SQL Script CREATE FUNCTION [dbo].[GetLocalDate] () returns DATETIME as begin Declare @gd as DATETIME = getUTCdate() DECLARE @D AS datetimeoffset SET @D = CONVERT(datetimeoffset, @gd) AT TIME ZONE 'Central Standard Time' RETURN CONVERT(datetime, @D); end GO EXEC sp_addextendedproperty N'MS_Description', N'Returns Date in Central US Time', 'SCHEMA', N'dbo', 'FUNCTION', N'GetLocalDate', NULL, NULL GO Used By
[sync].[CommissionRunSyncState]¶
[upload].[OrderTrackingQueue]¶
Programmability > Functions > Scalar-valued Functions¶
dbo.VerifyCustomerTempAuthHash
[dbo].[VerifyCustomerTempAuthHash]¶
MS_Description Verifies Customer Password Hash Parameters Name Data Type Max Length (Bytes) @PlainText nvarchar(max) max @Hash varbinary(80) 80 SQL Script CREATE FUNCTION [dbo].[VerifyCustomerTempAuthHash] ( @PlainText NVARCHAR(MAX), @Hash VARBINARY(80) ) RETURNS BIT AS BEGIN DECLARE @salt BINARY(8) SET @salt = substring(@hash, 65, 8) DECLARE @combined VARBINARY(MAX) SET @combined = CAST(@PlainText AS VARBINARY(MAX)) + @salt IF @Hash = hashbytes('SHA2_512', @combined) + @Salt RETURN 1 RETURN 0 END GO EXEC sp_addextendedproperty N'MS_Description', N'Verifies Customer Password Hash', 'SCHEMA', N'dbo', 'FUNCTION', N'VerifyCustomerTempAuthHash', NULL, NULL GO