Generated using SQL Data Dictionary demo version.
(Last updated on Fri, Jul 15th, 2016 at 10:54 AM)
| Application.Cities
(37,940 rows)
Cities that are part of any address (including geographic location) |
Sales.CustomerCategories
(8 rows)
Categories for customers (ie restaurants, cafes, supermarkets, etc.) |
| Application.Cities_Archive (28 rows) | Sales.CustomerCategories_Archive (1 row) |
| Application.Countries
(190 rows)
Countries that contain the states or provinces (including geographic boundaries) |
Sales.Customers
(663 rows)
Main entity tables for customers (organizations or individuals) |
| Application.Countries_Archive (36 rows) | Sales.Customers_Archive (51 rows) |
| Application.DeliveryMethods
(10 rows)
Ways that stock items can be delivered (ie: truck/van, post, pickup, courier, etc. |
Sales.CustomerTransactions
(97,147 rows)
All financial transactions that are customer-related |
| Application.DeliveryMethods_Archive (1 row) | Sales.InvoiceLines
(228,265 rows)
Detail lines from customer invoices |
| Application.PaymentMethods
(4 rows)
Ways that payments can be made (ie: cash, check, EFT, etc. |
Sales.Invoices
(70,510 rows)
Details of customer invoices |
| Application.PaymentMethods_Archive (1 row) | Sales.OrderLines
(231,412 rows)
Detail lines from customer orders |
| Application.People
(1,111 rows)
People known to the application (staff, customer contacts, supplier contacts) |
Sales.Orders
(73,595 rows)
Detail of customer orders |
| Application.People_Archive (2,072 rows) | Sales.SpecialDeals
(2 rows)
Special pricing (can include fixed prices, discount $ or discount %) |
| Application.StateProvinces
(53 rows)
States or provinces that contain cities (including geographic location) |
Warehouse.ColdRoomTemperatures (4 rows) |
| Application.StateProvinces_Archive (104 rows) | Warehouse.ColdRoomTemperatures_Archive (3,654,736 rows) |
| Application.SystemParameters
(1 row)
Any configurable parameters for the whole system |
Warehouse.Colors
(36 rows)
Stock items can (optionally) have colors |
| Application.TransactionTypes
(13 rows)
Types of customer, supplier, or stock transactions (ie: invoice, credit note, etc.) |
Warehouse.Colors_Archive (1 row) |
| Application.TransactionTypes_Archive (1 row) | Warehouse.PackageTypes
(14 rows)
Ways that stock items can be packaged (ie: each, box, carton, pallet, kg, etc. |
| Purchasing.PurchaseOrderLines
(8,367 rows)
Detail lines from supplier purchase orders |
Warehouse.PackageTypes_Archive (0 rows) |
| Purchasing.PurchaseOrders
(2,074 rows)
Details of supplier purchase orders |
Warehouse.StockGroups
(10 rows)
Groups for categorizing stock items (ie: novelties, toys, edible novelties, etc.) |
| Purchasing.SupplierCategories
(9 rows)
Categories for suppliers (ie novelties, toys, clothing, packaging, etc.) |
Warehouse.StockGroups_Archive (1 row) |
| Purchasing.SupplierCategories_Archive (1 row) | Warehouse.StockItemHoldings
(227 rows)
Non-temporal attributes for stock items |
| Purchasing.Suppliers
(13 rows)
Main entity table for suppliers (organizations) |
Warehouse.StockItems
(227 rows)
Main entity table for stock items |
| Purchasing.Suppliers_Archive (13 rows) | Warehouse.StockItems_Archive (444 rows) |
| Purchasing.SupplierTransactions
(2,438 rows)
All financial transactions that are supplier-related |
Warehouse.StockItemStockGroups
(442 rows)
Which stock items are in which stock groups |
| Sales.BuyingGroups
(2 rows)
Customer organizations can be part of groups that exert greater buying power |
Warehouse.StockItemTransactions
(236,667 rows)
Transactions covering all movements of all stock items |
| Sales.BuyingGroups_Archive (0 rows) | Warehouse.VehicleTemperatures (65,998 rows) |
| Website.Customers | Website.VehicleTemperatures |
| Website.Suppliers |
| Application.DetermineCustomerAccess | Website.CalculateCustomerPrice |