dbo.Invoices

View: 'dbo.Invoices'

ColumnType and Size
ShipNamenvarchar(40) NULL
ShipAddressnvarchar(60) NULL
ShipCitynvarchar(15) NULL
ShipRegionnvarchar(15) NULL
ShipPostalCodenvarchar(10) NULL
ShipCountrynvarchar(15) NULL
CustomerIDnchar(5) NULL
CustomerNamenvarchar(40) NOT NULL
Addressnvarchar(60) NULL
Citynvarchar(15) NULL
Regionnvarchar(15) NULL
PostalCodenvarchar(10) NULL
Countrynvarchar(15) NULL
Salespersonnvarchar(31) NOT NULL
OrderIDint NOT NULL
OrderDatedatetime NULL
RequiredDatedatetime NULL
ShippedDatedatetime NULL
ShipperNamenvarchar(40) NOT NULL
ProductIDint NOT NULL
ProductNamenvarchar(40) NOT NULL
UnitPricemoney(19.4) NOT NULL
Quantitysmallint NOT NULL
Discountreal NOT NULL
ExtendedPricemoney(19.4) NULL
Freightmoney(19.4) NULL