Supporting Databases and Tables
Supporting Databases and Tables
The following tables and their schemas within the PurchaseOrders database are utilized by this solution. These tables are representative of the customer and product information a typical corporation would maintain; however, most corporations will have existing databases and CRM systems containing this data. To customize this solution, these tables and the Web services used to access them will have to be modified:
Table 1. Dbo.ContactInfo
| Column | Type |
| ContactID | Int |
| CustomerID | Int |
| ContactName | Varchar(50) |
| ContactTitle | Varchar(50) |
| ContactE-mail | Varchar(50) |
| PhoneExtension | Varchar(15) |
| LeadType | Int |
Table 2. Dbo.CustomerInfo
| Column | Type |
| CustomerID | Int |
| CustomerName | Varchar(50) |
| CustomerType | Int |
| Address | Varchar(50) |
| City | Varchar(50) |
| State | Varchar(50) |
| ZipCode | Varchar(50) |
| PhoneNumber | Varchar(15) |
| FaxNumber | Varchar(15) |
| Discount | Int |
| CustomerStatus | Int |
Table 3. Dbo.CustomerStatusTypes
| Column | Type |
| CustomerStatusID | Int |
| CustomerStatusText | Varchar(50) |
Table 4. Dbo.CustomerTypes
| Column | Type |
| CustomerTypeID | Int |
| CustomerTypeText | Varchar(50) |
Table 5. Dbo.CustomerLeadTypes
| Column | Type |
| LeadID | Int |
| LeadText | Varchar(50) |
Table 6. Dbo.OrderLineItems
| Column | Type |
| OrderID | Int |
| ProductID | Int |
| ProductType | Int |
| Quantity | |
| Price | Decimal(18,0) |
Table 7. Dbo.Orders
| Column | Type |
| OrderID | Int |
| OrderDate | Datetime |
| CustomerID | Int |
| ContactID | Int |
| OrderStatus | Int |
| Notes | Varchar(150) |
Table 8. Dbo.OrderPrivateNotes
| Column | Type |
| OrderID | Int |
| PrivateNotes | Varchar(150) |
Table 9. Dbo.OrderSpecialOffers
| Column | Type |
| OrderID | Int |
| SpecialOfferID | Int |
| Notes | Varchar(50) |
Table 10. Dbo.OrderStatusTypes
| Column | Type |
| OrderStatusID | Int |
| OrderStatusText | Varchar(50) |
Table 11. Dbo.ProductCatalog
| Column | Type |
| ProductID | Int |
| ProductTypeID | Int |
| MinPrice | Decimal(18,0) |
| MaxPrice | Decimal(18,0) |
| Price | Decimal(18,0) |
| Inventory | int |
Table 12. Dbo.Products
| Column | Type |
| ProductID | Int |
| ProductText | Varchar(50) |
Table 13. Dbo.ProductTypes
| Column | Type |
| ProductTypeID | Int |
| ProductTypeText | Varchar(50) |
Table 14. Dbo.SpecialOffers
| Column | Type |
| SpecialOfferID | Int |
| Title | Varchar(50) |
| Description | Varchar(50) |