dbo.Invoices
Column | Type and Size |
ShipName | nvarchar(40) NULL |
ShipAddress | nvarchar(60) NULL |
ShipCity | nvarchar(15) NULL |
ShipRegion | nvarchar(15) NULL |
ShipPostalCode | nvarchar(10) NULL |
ShipCountry | nvarchar(15) NULL |
CustomerID | nchar(5) NULL |
CustomerName | nvarchar(40) NOT NULL |
Address | nvarchar(60) NULL |
City | nvarchar(15) NULL |
Region | nvarchar(15) NULL |
PostalCode | nvarchar(10) NULL |
Country | nvarchar(15) NULL |
Salesperson | nvarchar(31) NOT NULL |
OrderID | int NOT NULL |
OrderDate | datetime NULL |
RequiredDate | datetime NULL |
ShippedDate | datetime NULL |
ShipperName | nvarchar(40) NOT NULL |
ProductID | int NOT NULL |
ProductName | nvarchar(40) NOT NULL |
UnitPrice | money(19.4) NOT NULL |
Quantity | smallint NOT NULL |
Discount | real NOT NULL |
ExtendedPrice | money(19.4) NULL |
Freight | money(19.4) NULL |