SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Order Details Status](
	[Status ID] [int] NOT NULL,
	[Status Name] [nvarchar](50) NULL,
 CONSTRAINT [aaaaaOrder Details Status_PK] PRIMARY KEY NONCLUSTERED 
(
	[Status ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Customers](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Company] [nvarchar](50) NULL,
	[Last Name] [nvarchar](50) NULL,
	[First Name] [nvarchar](50) NULL,
	[E-mail Address] [nvarchar](50) NULL,
	[Job Title] [nvarchar](50) NULL,
	[Business Phone] [nvarchar](25) NULL,
	[Home Phone] [nvarchar](25) NULL,
	[Mobile Phone] [nvarchar](25) NULL,
	[Fax Number] [nvarchar](25) NULL,
	[Address] [ntext] NULL,
	[City] [nvarchar](50) NULL,
	[State/Province] [nvarchar](50) NULL,
	[ZIP/Postal Code] [nvarchar](15) NULL,
	[Country/Region] [nvarchar](50) NULL,
	[Web Page] [ntext] NULL,
	[Notes] [ntext] NULL,
	[Attachments] [ntext] NULL,
 CONSTRAINT [aaaaaCustomers_PK] PRIMARY KEY NONCLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Orders Status](
	[Status ID] [smallint] NOT NULL,
	[Status Name] [nvarchar](50) NULL,
 CONSTRAINT [aaaaaOrders Status_PK] PRIMARY KEY NONCLUSTERED 
(
	[Status ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Suppliers](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Company] [nvarchar](50) NULL,
	[Last Name] [nvarchar](50) NULL,
	[First Name] [nvarchar](50) NULL,
	[E-mail Address] [nvarchar](50) NULL,
	[Job Title] [nvarchar](50) NULL,
	[Business Phone] [nvarchar](25) NULL,
	[Home Phone] [nvarchar](25) NULL,
	[Mobile Phone] [nvarchar](25) NULL,
	[Fax Number] [nvarchar](25) NULL,
	[Address] [ntext] NULL,
	[City] [nvarchar](50) NULL,
	[State/Province] [nvarchar](50) NULL,
	[ZIP/Postal Code] [nvarchar](15) NULL,
	[Country/Region] [nvarchar](50) NULL,
	[Web Page] [ntext] NULL,
	[Notes] [ntext] NULL,
	[Attachments] [ntext] NULL,
 CONSTRAINT [aaaaaSuppliers_PK] PRIMARY KEY NONCLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Privileges](
	[Privilege ID] [int] IDENTITY(1,1) NOT NULL,
	[Privilege Name] [nvarchar](50) NULL,
 CONSTRAINT [aaaaaPrivileges_PK] PRIMARY KEY NONCLUSTERED 
(
	[Privilege ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Products](
	[Supplier IDs] [ntext] NULL,
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Product Code] [nvarchar](25) NULL,
	[Product Name] [nvarchar](50) NULL,
	[Description] [ntext] NULL,
	[Standard Cost] [money] NULL,
	[List Price] [money] NULL,
	[Reorder Level] [smallint] NULL,
	[Target Level] [int] NULL,
	[Quantity Per Unit] [nvarchar](50) NULL,
	[Discontinued] [bit] NULL DEFAULT ((0)),
	[Minimum Reorder Quantity] [smallint] NULL,
	[Category] [nvarchar](50) NULL,
	[Attachments] [ntext] NULL,
 CONSTRAINT [aaaaaProducts_PK] PRIMARY KEY NONCLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Employees](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Company] [nvarchar](50) NULL,
	[Last Name] [nvarchar](50) NULL,
	[First Name] [nvarchar](50) NULL,
	[E-mail Address] [nvarchar](50) NULL,
	[Job Title] [nvarchar](50) NULL,
	[Business Phone] [nvarchar](25) NULL,
	[Home Phone] [nvarchar](25) NULL,
	[Mobile Phone] [nvarchar](25) NULL,
	[Fax Number] [nvarchar](25) NULL,
	[Address] [ntext] NULL,
	[City] [nvarchar](50) NULL,
	[State/Province] [nvarchar](50) NULL,
	[ZIP/Postal Code] [nvarchar](15) NULL,
	[Country/Region] [nvarchar](50) NULL,
	[Web Page] [ntext] NULL,
	[Notes] [ntext] NULL,
	[Attachments] [ntext] NULL,
 CONSTRAINT [aaaaaEmployees_PK] PRIMARY KEY NONCLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Inventory Transaction Types](
	[ID] [smallint] NOT NULL,
	[Type Name] [nvarchar](50) NULL,
 CONSTRAINT [aaaaaInventory Transaction Types_PK] PRIMARY KEY NONCLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Purchase Order Status](
	[Status ID] [int] NOT NULL,
	[Status] [nvarchar](50) NULL,
 CONSTRAINT [aaaaaPurchase Order Status_PK] PRIMARY KEY NONCLUSTERED 
(
	[Status ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Sales Reports](
	[Group By] [nvarchar](50) NOT NULL,
	[Display] [nvarchar](50) NULL,
	[Title] [nvarchar](50) NULL,
	[Filter Row Source] [ntext] NULL,
	[Default] [bit] NULL DEFAULT ((0)),
 CONSTRAINT [aaaaaSales Reports_PK] PRIMARY KEY NONCLUSTERED 
(
	[Group By] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Shippers](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Company] [nvarchar](50) NULL,
	[Last Name] [nvarchar](50) NULL,
	[First Name] [nvarchar](50) NULL,
	[E-mail Address] [nvarchar](50) NULL,
	[Job Title] [nvarchar](50) NULL,
	[Business Phone] [nvarchar](25) NULL,
	[Home Phone] [nvarchar](25) NULL,
	[Mobile Phone] [nvarchar](25) NULL,
	[Fax Number] [nvarchar](25) NULL,
	[Address] [ntext] NULL,
	[City] [nvarchar](50) NULL,
	[State/Province] [nvarchar](50) NULL,
	[ZIP/Postal Code] [nvarchar](15) NULL,
	[Country/Region] [nvarchar](50) NULL,
	[Web Page] [ntext] NULL,
	[Notes] [ntext] NULL,
	[Attachments] [ntext] NULL,
 CONSTRAINT [aaaaaShippers_PK] PRIMARY KEY NONCLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Strings](
	[String ID] [int] IDENTITY(1,1) NOT NULL,
	[String Data] [nvarchar](255) NULL,
 CONSTRAINT [aaaaaStrings_PK] PRIMARY KEY NONCLUSTERED 
(
	[String ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Orders Tax Status](
	[ID] [smallint] NOT NULL,
	[Tax Status Name] [nvarchar](50) NULL,
 CONSTRAINT [aaaaaOrders Tax Status_PK] PRIMARY KEY NONCLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Employee Privileges](
	[Employee ID] [int] NOT NULL,
	[Privilege ID] [int] NOT NULL,
 CONSTRAINT [aaaaaEmployee Privileges_PK] PRIMARY KEY NONCLUSTERED 
(
	[Employee ID] ASC,
	[Privilege ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Orders](
	[Order ID] [int] IDENTITY(1,1) NOT NULL,
	[Employee ID] [int] NULL,
	[Customer ID] [int] NULL,
	[Order Date] [datetime] NULL,
	[Shipped Date] [datetime] NULL,
	[Shipper ID] [int] NULL,
	[Ship Name] [nvarchar](50) NULL,
	[Ship Address] [ntext] NULL,
	[Ship City] [nvarchar](50) NULL,
	[Ship State/Province] [nvarchar](50) NULL,
	[Ship ZIP/Postal Code] [nvarchar](50) NULL,
	[Ship Country/Region] [nvarchar](50) NULL,
	[Shipping Fee] [money] NULL,
	[Taxes] [money] NULL,
	[Payment Type] [nvarchar](50) NULL,
	[Paid Date] [datetime] NULL,
	[Notes] [ntext] NULL,
	[Tax Rate] [float] NULL,
	[Tax Status] [smallint] NULL,
	[Status ID] [smallint] NULL,
 CONSTRAINT [aaaaaOrders_PK] PRIMARY KEY NONCLUSTERED 
(
	[Order ID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Purchase Orders](
	[Purchase Order ID] [int] IDENTITY(1,1) NOT NULL,
	[Supplier ID] [int] NULL,
	[Created By] [int] NULL,
	[Submitted Date] [datetime] NULL,
	[Creation Date] [datetime] NULL,
	[Status ID] [int] NULL,
	[Expected Date] [datetime] NULL,
	[Shipping Fee] [money] NULL,
	[Taxes] [money] NULL,
	[Payment Date] [datetime] NULL,
	[Payment Amount] [money] NULL,
	[Payment Method] [nvarchar](50) NULL,
	[Notes] [ntext] NULL,
	[Approved By] [int] NULL,
	[Approved Date] [datetime] NULL,
	[Submitted By] [int] NULL,
 CONSTRAINT [aaaaaPurchase Orders_PK] PRIMARY KEY NONCLUSTERED 
(
	[Purchase Order ID] ASC
) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Inventory Transactions](
	[Transaction ID] [int] IDENTITY(1,1) NOT NULL,
	[Transaction Type] [smallint] NULL,
	[Transaction Created Date] [datetime] NULL,
	[Transaction Modified Date] [datetime] NULL,
	[Product ID] [int] NULL,
	[Quantity] [int] NULL,
	[Purchase Order ID] [int] NULL,
	[Customer Order ID] [int] NULL,
	[Comments] [nvarchar](255) NULL,
 CONSTRAINT [aaaaaInventory Transactions_PK] PRIMARY KEY NONCLUSTERED 
(
	[Transaction ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Purchase Order Details](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Purchase Order ID] [int] NULL,
	[Product ID] [int] NULL,
	[Quantity] [decimal](18, 4) NULL,
	[Unit Cost] [money] NULL,
	[Date Received] [datetime] NULL,
	[Posted To Inventory] [bit] NULL DEFAULT ((0)),
	[Inventory ID] [int] NULL,
 CONSTRAINT [aaaaaPurchase Order Details_PK] PRIMARY KEY NONCLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Order Details](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[Order ID] [int] NULL,
	[Product ID] [int] NULL,
	[Quantity] [decimal](18, 4) NULL,
	[Unit Price] [money] NULL,
	[Discount] [float] NULL,
	[Status ID] [int] NULL,
	[Date Allocated] [datetime] NULL,
	[Purchase Order ID] [int] NULL,
	[Inventory ID] [int] NULL,
 CONSTRAINT [aaaaaOrder Details_PK] PRIMARY KEY NONCLUSTERED 
(
	[ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[L8-Invoices](
	[Invoice ID] [int] IDENTITY(1,1) NOT NULL,
	[Order ID] [int] NULL,
	[Invoice Date] [datetime] NULL,
	[Due Date] [datetime] NULL,
	[Tax] [money] NULL,
	[Shipping] [money] NULL,
	[Amount Due] [money] NULL,
 CONSTRAINT [aaaaaInvoices_PK] PRIMARY KEY NONCLUSTERED 
(
	[Invoice ID] ASC
) ON [PRIMARY]
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[L8-Invoices]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Invoices]
GO
/****** Object:  Table [dbo].[L8-Order Details]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Order Details]
GO
/****** Object:  Table [dbo].[L8-Purchase Order Details]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Purchase Order Details]
GO
/****** Object:  Table [dbo].[L8-Inventory Transactions]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Inventory Transactions]
GO
/****** Object:  Table [dbo].[L8-Purchase Orders]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Purchase Orders]
GO
/****** Object:  Table [dbo].[L8-Orders]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Orders]
GO
/****** Object:  Table [dbo].[L8-Employee Privileges]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Employee Privileges]
GO
/****** Object:  Table [dbo].[L8-Orders Tax Status]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Orders Tax Status]
GO
/****** Object:  Table [dbo].[L8-Strings]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Strings]
GO
/****** Object:  Table [dbo].[L8-Shippers]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Shippers]
GO
/****** Object:  Table [dbo].[L8-Sales Reports]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Sales Reports]
GO
/****** Object:  Table [dbo].[L8-Purchase Order Status]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Purchase Order Status]
GO
/****** Object:  Table [dbo].[L8-Inventory Transaction Types]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Inventory Transaction Types]
GO
/****** Object:  Table [dbo].[L8-Employees]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Employees]
GO
/****** Object:  Table [dbo].[L8-Products]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Products]
GO
/****** Object:  Table [dbo].[L8-Privileges]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Privileges]
GO
/****** Object:  Table [dbo].[L8-Suppliers]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Suppliers]
GO
/****** Object:  Table [dbo].[L8-Orders Status]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Orders Status]
GO
/****** Object:  Table [dbo].[L8-Customers]    Script Date: 10/26/2009 11:47:18 ******/
DELETE FROM [dbo].[L8-Customers]
GO
/****** Object:  Table [dbo].[L8-Order Details Status]    Script Date: 10/26/2009 11:47:19 ******/
DELETE FROM [dbo].[L8-Order Details Status]
GO
/****** Object:  Table [dbo].[L8-Order Details Status]    Script Date: 10/26/2009 11:47:19 ******/
INSERT [dbo].[L8-Order Details Status] ([Status ID], [Status Name]) VALUES (0, N'None')
INSERT [dbo].[L8-Order Details Status] ([Status ID], [Status Name]) VALUES (1, N'Allocated')
INSERT [dbo].[L8-Order Details Status] ([Status ID], [Status Name]) VALUES (2, N'Invoiced')
INSERT [dbo].[L8-Order Details Status] ([Status ID], [Status Name]) VALUES (3, N'Shipped')
INSERT [dbo].[L8-Order Details Status] ([Status ID], [Status Name]) VALUES (4, N'On Order')
INSERT [dbo].[L8-Order Details Status] ([Status ID], [Status Name]) VALUES (5, N'No Stock')
/****** Object:  Table [dbo].[L8-Customers]    Script Date: 10/26/2009 11:47:18 ******/
SET IDENTITY_INSERT [dbo].[L8-Customers] ON
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (1, N'Company A', N'Bedecs', N'Anna', NULL, N'Owner', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'123 1st Street', N'Seattle', N'WA', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (2, N'Company B', N'Gratacos Solsona', N'Antonio', NULL, N'Owner', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'123 2nd Street', N'Boston', N'MA', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (3, N'Company C', N'Axen', N'Thomas', NULL, N'Purchasing Representative', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'123 3rd Street', N'Los Angelas', N'CA', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (4, N'Company D', N'Lee', N'Christina', NULL, N'Purchasing Manager', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'123 4th Street', N'New York', N'NY', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (5, N'Company E', N'O’Donnell', N'Martin', NULL, N'Owner', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'123 5th Street', N'Minneapolis', N'MN', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (6, N'Company F', N'Pérez-Olaeta', N'Francisco', NULL, N'Purchasing Manager', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'123 6th Street', N'Milwaukee', N'WI', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (7, N'Company G', N'Xie', N'Ming-Yang', NULL, N'Owner', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'123 7th Street', N'Boise', N'ID', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (8, N'Company H', N'Andersen', N'Elizabeth', NULL, N'Purchasing Representative', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'123 8th Street', N'Portland', N'OR', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (9, N'Company I', N'Mortensen', N'Sven', NULL, N'Purchasing Manager', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'123 9th Street', N'Salt Lake City', N'UT', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (10, N'Company J', N'Wacker', N'Roland', NULL, N'Purchasing Manager', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'123 10th Street', N'Chicago', N'IL', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (11, N'Company K', N'Krschne', N'Peter', NULL, N'Purchasing Manager', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'123 11th Street', N'Miami', N'FL', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (12, N'Company L', N'Edwards', N'John', NULL, N'Purchasing Manager', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'123 12th Street', N'Las Vegas', N'NV', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (13, N'Company M', N'Ludick', N'Andre', NULL, N'Purchasing Representative', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'456 13th Street', N'Memphis', N'TN', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (14, N'Company N', N'Grilo', N'Carlos', NULL, N'Purchasing Representative', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'456 14th Street', N'Denver', N'CO', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (15, N'Company O', N'Kupkova', N'Helena', NULL, N'Purchasing Manager', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'456 15th Street', N'Honolulu', N'HI', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (16, N'Company P', N'Goldschmidt', N'Daniel', NULL, N'Purchasing Representative', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'456 16th Street', N'San Francisco', N'CA', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (17, N'Company Q', N'Bagel', N'Jean Philippe', NULL, N'Owner', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'456 17th Street', N'Seattle', N'WA', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (18, N'Company R', N'Autier Miconi', N'Catherine', NULL, N'Purchasing Representative', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'456 18th Street', N'Boston', N'MA', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (19, N'Company S', N'Eggerer', N'Alexander', NULL, N'Accounting Assistant', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'789 19th Street', N'Los Angelas', N'CA', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (20, N'Company T', N'Li', N'George', NULL, N'Purchasing Manager', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'789 20th Street', N'New York', N'NY', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (21, N'Company U', N'Tham', N'Bernard', NULL, N'Accounting Manager', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'789 21th Street', N'Minneapolis', N'MN', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (22, N'Company V', N'Ramos', N'Luciana', NULL, N'Purchasing Assistant', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'789 22th Street', N'Milwaukee', N'WI', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (23, N'Company W', N'Entin', N'Michael', NULL, N'Purchasing Manager', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'789 23th Street', N'Portland', N'OR', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (24, N'Company X', N'Hasselberg', N'Jonas', NULL, N'Owner', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'789 24th Street', N'Salt Lake City', N'UT', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (25, N'Company Y', N'Rodman', N'John', NULL, N'Purchasing Manager', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'789 25th Street', N'Chicago', N'IL', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (26, N'Company Z', N'Liu', N'Run', NULL, N'Accounting Assistant', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'789 26th Street', N'Miami', N'FL', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (27, N'Company AA', N'Toh', N'Karen', NULL, N'Purchasing Manager', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'789 27th Street', N'Las Vegas', N'NV', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (28, N'Company BB', N'Raghav', N'Amritansh', NULL, N'Purchasing Manager', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'789 28th Street', N'Memphis', N'TN', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Customers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (29, N'Company CC', N'Lee', N'Soo Jung', NULL, N'Purchasing Manager', N'(123)555-0100', NULL, NULL, N'(123)555-0101', N'789 29th Street', N'Denver', N'CO', N'99999', N'USA', NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[L8-Customers] OFF
/****** Object:  Table [dbo].[L8-Orders Status]    Script Date: 10/26/2009 11:47:19 ******/
INSERT [dbo].[L8-Orders Status] ([Status ID], [Status Name]) VALUES (0, N'New')
INSERT [dbo].[L8-Orders Status] ([Status ID], [Status Name]) VALUES (1, N'Invoiced')
INSERT [dbo].[L8-Orders Status] ([Status ID], [Status Name]) VALUES (2, N'Shipped')
INSERT [dbo].[L8-Orders Status] ([Status ID], [Status Name]) VALUES (3, N'Closed')
/****** Object:  Table [dbo].[L8-Suppliers]    Script Date: 10/26/2009 11:47:19 ******/
SET IDENTITY_INSERT [dbo].[L8-Suppliers] ON
INSERT [dbo].[L8-Suppliers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (1, N'Supplier A', N'Andersen', N'Elizabeth A.', NULL, N'Sales Manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[L8-Suppliers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (2, N'Supplier B', N'Weiler', N'Cornelia', NULL, N'Sales Manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[L8-Suppliers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (3, N'Supplier C', N'Kelley', N'Madeleine', NULL, N'Sales Representative', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[L8-Suppliers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (4, N'Supplier D', N'Sato', N'Naoki', NULL, N'Marketing Manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[L8-Suppliers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (5, N'Supplier E', N'Hernandez-Echevarria', N'Amaya', NULL, N'Sales Manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[L8-Suppliers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (6, N'Supplier F', N'Hayakawa', N'Satomi', NULL, N'Marketing Assistant', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[L8-Suppliers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (7, N'Supplier G', N'Glasson', N'Stuart', NULL, N'Marketing Manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[L8-Suppliers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (8, N'Supplier H', N'Dunton', N'Bryn Paul', NULL, N'Sales Representative', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[L8-Suppliers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (9, N'Supplier I', N'Sandberg', N'Mikael', NULL, N'Sales Manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[L8-Suppliers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (10, N'Supplier J', N'Sousa', N'Luis', NULL, N'Sales Manager', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[L8-Suppliers] OFF
/****** Object:  Table [dbo].[L8-Privileges]    Script Date: 10/26/2009 11:47:19 ******/
SET IDENTITY_INSERT [dbo].[L8-Privileges] ON
INSERT [dbo].[L8-Privileges] ([Privilege ID], [Privilege Name]) VALUES (2, N'Purchase Approvals')
SET IDENTITY_INSERT [dbo].[L8-Privileges] OFF
/****** Object:  Table [dbo].[L8-Products]    Script Date: 10/26/2009 11:47:19 ******/
SET IDENTITY_INSERT [dbo].[L8-Products] ON
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'4', 1, N'NWTB-1', N'Northwind Traders Chai', NULL, 13.5000, 18.0000, 10, 40, N'10 boxes x 20 bags', 0, 10, N'Beverages', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'10', 3, N'NWTCO-3', N'Northwind Traders Syrup', NULL, 7.5000, 10.0000, 25, 100, N'12 - 550 ml bottles', 0, 25, N'Condiments', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'10', 4, N'NWTCO-4', N'Northwind Traders Cajun Seasoning', NULL, 16.5000, 22.0000, 10, 40, N'48 - 6 oz jars', 0, 10, N'Condiments', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'10', 5, N'NWTO-5', N'Northwind Traders Olive Oil', NULL, 16.0125, 21.3500, 10, 40, N'36 boxes', 0, 10, N'Oil', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'2;6', 6, N'NWTJP-6', N'Northwind Traders Boysenberry Spread', NULL, 18.7500, 25.0000, 25, 100, N'12 - 8 oz jars', 0, 25, N'Jams, Preserves', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'2', 7, N'NWTDFN-7', N'Northwind Traders Dried Pears', NULL, 22.5000, 30.0000, 10, 40, N'12 - 1 lb pkgs.', 0, 10, N'Dried Fruit & Nuts', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'8', 8, N'NWTS-8', N'Northwind Traders Curry Sauce', NULL, 30.0000, 40.0000, 10, 40, N'12 - 12 oz jars', 0, 10, N'Sauces', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'2;6', 14, N'NWTDFN-14', N'Northwind Traders Walnuts', NULL, 17.4375, 23.2500, 10, 40, N'40 - 100 g pkgs.', 0, 10, N'Dried Fruit & Nuts', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'6', 17, N'NWTCFV-17', N'Northwind Traders Fruit Cocktail', NULL, 29.2500, 39.0000, 10, 40, N'15.25 OZ', 0, 10, N'Canned Fruit & Vegetables', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'1', 19, N'NWTBGM-19', N'Northwind Traders Chocolate Biscuits Mix', NULL, 6.9000, 9.2000, 5, 20, N'10 boxes x 12 pieces', 0, 5, N'Baked Goods & Mixes', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'2;6', 20, N'NWTJP-6', N'Northwind Traders Marmalade', NULL, 60.7500, 81.0000, 10, 40, N'30 gift boxes', 0, 10, N'Jams, Preserves', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'1', 21, N'NWTBGM-21', N'Northwind Traders Scones', NULL, 7.5000, 10.0000, 5, 20, N'24 pkgs. x 4 pieces', 0, 5, N'Baked Goods & Mixes', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'4', 34, N'NWTB-34', N'Northwind Traders Beer', NULL, 10.5000, 14.0000, 15, 60, N'24 - 12 oz bottles', 0, 15, N'Beverages', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'7', 40, N'NWTCM-40', N'Northwind Traders Crab Meat', NULL, 13.8000, 18.4000, 30, 120, N'24 - 4 oz tins', 0, 30, N'Canned Meat', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'6', 41, N'NWTSO-41', N'Northwind Traders Clam Chowder', NULL, 7.2375, 9.6500, 10, 40, N'12 - 12 oz cans', 0, 10, N'Soups', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'3;4', 43, N'NWTB-43', N'Northwind Traders Coffee', NULL, 34.5000, 46.0000, 25, 100, N'16 - 500 g tins', 0, 25, N'Beverages', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'10', 48, N'NWTCA-48', N'Northwind Traders Chocolate', NULL, 9.5625, 12.7500, 25, 100, N'10 pkgs', 0, 25, N'Candy', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'2', 51, N'NWTDFN-51', N'Northwind Traders Dried Apples', NULL, 39.7500, 53.0000, 10, 40, N'50 - 300 g pkgs.', 0, 10, N'Dried Fruit & Nuts', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'1', 52, N'NWTG-52', N'Northwind Traders Long Grain Rice', NULL, 5.2500, 7.0000, 25, 100, N'16 - 2 kg boxes', 0, 25, N'Grains', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'1', 56, N'NWTP-56', N'Northwind Traders Gnocchi', NULL, 28.5000, 38.0000, 30, 120, N'24 - 250 g pkgs.', 0, 30, N'Pasta', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'1', 57, N'NWTP-57', N'Northwind Traders Ravioli', NULL, 14.6250, 19.5000, 20, 80, N'24 - 250 g pkgs.', 0, 20, N'Pasta', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'8', 65, N'NWTS-65', N'Northwind Traders Hot Pepper Sauce', NULL, 15.7875, 21.0500, 10, 40, N'32 - 8 oz bottles', 0, 10, N'Sauces', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'8', 66, N'NWTS-66', N'Northwind Traders Tomato Sauce', NULL, 12.7500, 17.0000, 20, 80, N'24 - 8 oz jars', 0, 20, N'Sauces', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'5', 72, N'NWTD-72', N'Northwind Traders Mozzarella', NULL, 26.1000, 34.8000, 10, 40, N'24 - 200 g pkgs.', 0, 10, N'Dairy Products', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'2;6', 74, N'NWTDFN-74', N'Northwind Traders Almonds', NULL, 7.5000, 10.0000, 5, 20, N'5 kg pkg.', 0, 5, N'Dried Fruit & Nuts', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'10', 77, N'NWTCO-77', N'Northwind Traders Mustard', NULL, 9.7500, 13.0000, 15, 60, N'12 boxes', 0, 15, N'Condiments', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'2', 80, N'NWTDFN-80', N'Northwind Traders Dried Plums', NULL, 3.0000, 3.5000, 50, 75, N'1 lb bag', 0, 25, N'Dried Fruit & Nuts', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'3', 81, N'NWTB-81', N'Northwind Traders Green Tea', NULL, 2.0000, 2.9900, 100, 125, N'20 bags per box', 0, 25, N'Beverages', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'1', 82, N'NWTC-82', N'Northwind Traders Granola', NULL, 2.0000, 4.0000, 20, 100, NULL, 0, NULL, N'Cereal', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'9', 83, N'NWTCS-83', N'Northwind Traders Potato Chips', NULL, 0.5000, 1.8000, 30, 200, NULL, 0, NULL, N'Chips, Snacks', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'1', 85, N'NWTBGM-85', N'Northwind Traders Brownie Mix', NULL, 9.0000, 12.4900, 10, 20, N'3 boxes', 0, 5, N'Baked Goods & Mixes', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'1', 86, N'NWTBGM-86', N'Northwind Traders Cake Mix', NULL, 10.5000, 15.9900, 10, 20, N'4 boxes', 0, 5, N'Baked Goods & Mixes', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'7', 87, N'NWTB-87', N'Northwind Traders Tea', NULL, 2.0000, 4.0000, 20, 50, N'100 count per box', 0, NULL, N'Beverages', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'6', 88, N'NWTCFV-88', N'Northwind Traders Pears', NULL, 1.0000, 1.3000, 10, 40, N'15.25 OZ', 0, NULL, N'Canned Fruit & Vegetables', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'6', 89, N'NWTCFV-89', N'Northwind Traders Peaches', NULL, 1.0000, 1.5000, 10, 40, N'15.25 OZ', 0, NULL, N'Canned Fruit & Vegetables', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'6', 90, N'NWTCFV-90', N'Northwind Traders Pineapple', NULL, 1.0000, 1.8000, 10, 40, N'15.25 OZ', 0, NULL, N'Canned Fruit & Vegetables', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'6', 91, N'NWTCFV-91', N'Northwind Traders Cherry Pie Filling', NULL, 1.0000, 2.0000, 10, 40, N'15.25 OZ', 0, NULL, N'Canned Fruit & Vegetables', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'6', 92, N'NWTCFV-92', N'Northwind Traders Green Beans', NULL, 1.0000, 1.2000, 10, 40, N'14.5 OZ', 0, NULL, N'Canned Fruit & Vegetables', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'6', 93, N'NWTCFV-93', N'Northwind Traders Corn', NULL, 1.0000, 1.2000, 10, 40, N'14.5 OZ', 0, NULL, N'Canned Fruit & Vegetables', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'6', 94, N'NWTCFV-94', N'Northwind Traders Peas', NULL, 1.0000, 1.5000, 10, 40, N'14.5 OZ', 0, NULL, N'Canned Fruit & Vegetables', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'7', 95, N'NWTCM-95', N'Northwind Traders Tuna Fish', NULL, 0.5000, 2.0000, 30, 50, N'5 oz', 0, NULL, N'Canned Meat', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'7', 96, N'NWTCM-96', N'Northwind Traders Smoked Salmon', NULL, 2.0000, 4.0000, 30, 50, N'5 oz', 0, NULL, N'Canned Meat', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'1', 97, N'NWTC-82', N'Northwind Traders Hot Cereal', NULL, 3.0000, 5.0000, 50, 200, NULL, 0, NULL, N'Cereal', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'6', 98, N'NWTSO-98', N'Northwind Traders Vegetable Soup', NULL, 1.0000, 1.8900, 100, 200, NULL, 0, NULL, N'Soups', NULL)
INSERT [dbo].[L8-Products] ([Supplier IDs], [ID], [Product Code], [Product Name], [Description], [Standard Cost], [List Price], [Reorder Level], [Target Level], [Quantity Per Unit], [Discontinued], [Minimum Reorder Quantity], [Category], [Attachments]) VALUES (N'6', 99, N'NWTSO-99', N'Northwind Traders Chicken Soup', NULL, 1.0000, 1.9500, 100, 200, NULL, 0, NULL, N'Soups', NULL)
SET IDENTITY_INSERT [dbo].[L8-Products] OFF
/****** Object:  Table [dbo].[L8-Employees]    Script Date: 10/26/2009 11:47:19 ******/
SET IDENTITY_INSERT [dbo].[L8-Employees] ON
INSERT [dbo].[L8-Employees] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (1, N'Northwind Traders', N'Freehafer', N'Nancy', N'nancy@northwindtraders.com', N'Sales Representative', N'(123)555-0100', N'(123)555-0102', NULL, N'(123)555-0103', N'123 1st Avenue', N'Seattle', N'WA', N'99999', N'USA', N'#http://northwindtraders.com#', NULL, NULL)
INSERT [dbo].[L8-Employees] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (2, N'Northwind Traders', N'Cencini', N'Andrew', N'andrew@northwindtraders.com', N'Vice President, Sales', N'(123)555-0100', N'(123)555-0102', NULL, N'(123)555-0103', N'123 2nd Avenue', N'Bellevue', N'WA', N'99999', N'USA', N'http://northwindtraders.com#http://northwindtraders.com/#', N'Joined the company as a sales representative, was promoted to sales manager and was then named vice president of sales.', NULL)
INSERT [dbo].[L8-Employees] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (3, N'Northwind Traders', N'Kotas', N'Jan', N'jan@northwindtraders.com', N'Sales Representative', N'(123)555-0100', N'(123)555-0102', NULL, N'(123)555-0103', N'123 3rd Avenue', N'Redmond', N'WA', N'99999', N'USA', N'http://northwindtraders.com#http://northwindtraders.com/#', N'Was hired as a sales associate and was promoted to sales representative.', NULL)
INSERT [dbo].[L8-Employees] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (4, N'Northwind Traders', N'Sergienko', N'Mariya', N'mariya@northwindtraders.com', N'Sales Representative', N'(123)555-0100', N'(123)555-0102', NULL, N'(123)555-0103', N'123 4th Avenue', N'Kirkland', N'WA', N'99999', N'USA', N'http://northwindtraders.com#http://northwindtraders.com/#', NULL, NULL)
INSERT [dbo].[L8-Employees] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (5, N'Northwind Traders', N'Thorpe', N'Steven', N'steven@northwindtraders.com', N'Sales Manager', N'(123)555-0100', N'(123)555-0102', NULL, N'(123)555-0103', N'123 5th Avenue', N'Seattle', N'WA', N'99999', N'USA', N'http://northwindtraders.com#http://northwindtraders.com/#', N'Joined the company as a sales representative and was promoted to sales manager.  Fluent in French.', NULL)
INSERT [dbo].[L8-Employees] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (6, N'Northwind Traders', N'Neipper', N'Michael', N'michael@northwindtraders.com', N'Sales Representative', N'(123)555-0100', N'(123)555-0102', NULL, N'(123)555-0103', N'123 6th Avenue', N'Redmond', N'WA', N'99999', N'USA', N'http://northwindtraders.com#http://northwindtraders.com/#', N'Fluent in Japanese and can read and write French, Portuguese, and Spanish.', NULL)
INSERT [dbo].[L8-Employees] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (7, N'Northwind Traders', N'Zare', N'Robert', N'robert@northwindtraders.com', N'Sales Representative', N'(123)555-0100', N'(123)555-0102', NULL, N'(123)555-0103', N'123 7th Avenue', N'Seattle', N'WA', N'99999', N'USA', N'http://northwindtraders.com#http://northwindtraders.com/#', NULL, NULL)
INSERT [dbo].[L8-Employees] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (8, N'Northwind Traders', N'Giussani', N'Laura', N'laura@northwindtraders.com', N'Sales Coordinator', N'(123)555-0100', N'(123)555-0102', NULL, N'(123)555-0103', N'123 8th Avenue', N'Redmond', N'WA', N'99999', N'USA', N'http://northwindtraders.com#http://northwindtraders.com/#', N'Reads and writes French.', NULL)
INSERT [dbo].[L8-Employees] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (9, N'Northwind Traders', N'Hellung-Larsen', N'Anne', N'anne@northwindtraders.com', N'Sales Representative', N'(123)555-0100', N'(123)555-0102', NULL, N'(123)555-0103', N'123 9th Avenue', N'Seattle', N'WA', N'99999', N'USA', N'http://northwindtraders.com#http://northwindtraders.com/#', N'Fluent in French and German.', NULL)
SET IDENTITY_INSERT [dbo].[L8-Employees] OFF
/****** Object:  Table [dbo].[L8-Inventory Transaction Types]    Script Date: 10/26/2009 11:47:19 ******/
INSERT [dbo].[L8-Inventory Transaction Types] ([ID], [Type Name]) VALUES (1, N'Purchased')
INSERT [dbo].[L8-Inventory Transaction Types] ([ID], [Type Name]) VALUES (2, N'Sold')
INSERT [dbo].[L8-Inventory Transaction Types] ([ID], [Type Name]) VALUES (3, N'On Hold')
INSERT [dbo].[L8-Inventory Transaction Types] ([ID], [Type Name]) VALUES (4, N'Waste')
/****** Object:  Table [dbo].[L8-Purchase Order Status]    Script Date: 10/26/2009 11:47:19 ******/
INSERT [dbo].[L8-Purchase Order Status] ([Status ID], [Status]) VALUES (0, N'New')
INSERT [dbo].[L8-Purchase Order Status] ([Status ID], [Status]) VALUES (1, N'Submitted')
INSERT [dbo].[L8-Purchase Order Status] ([Status ID], [Status]) VALUES (2, N'Approved')
INSERT [dbo].[L8-Purchase Order Status] ([Status ID], [Status]) VALUES (3, N'Closed')
/****** Object:  Table [dbo].[L8-Sales Reports]    Script Date: 10/26/2009 11:47:19 ******/
INSERT [dbo].[L8-Sales Reports] ([Group By], [Display], [Title], [Filter Row Source], [Default]) VALUES (N'Category', N'Category', N'Sales By Category', N'SELECT DISTINCT [Category] FROM [L8-Products] ORDER BY [Category];', 0)
INSERT [dbo].[L8-Sales Reports] ([Group By], [Display], [Title], [Filter Row Source], [Default]) VALUES (N'Country/Region', N'Country/Region', N'Sales By Country', N'SELECT DISTINCT [Country/Region] FROM [Customers Extended] ORDER BY [Country/Region];', 0)
INSERT [dbo].[L8-Sales Reports] ([Group By], [Display], [Title], [Filter Row Source], [Default]) VALUES (N'Customer ID', N'Customer', N'Sales By Customer', N'SELECT DISTINCT [Company] FROM [Customers Extended] ORDER BY [Company];', 0)
INSERT [dbo].[L8-Sales Reports] ([Group By], [Display], [Title], [Filter Row Source], [Default]) VALUES (N'Employee ID', N'Employee', N'Sales By Employee', N'SELECT DISTINCT [Employee Name] FROM [Employees Extended] ORDER BY [Employee Name];', 0)
INSERT [dbo].[L8-Sales Reports] ([Group By], [Display], [Title], [Filter Row Source], [Default]) VALUES (N'Product ID', N'Product', N'Sales by Product', N'SELECT DISTINCT [Product Name] FROM [L8-Products] ORDER BY [Product Name];', 1)
/****** Object:  Table [dbo].[L8-Shippers]    Script Date: 10/26/2009 11:47:19 ******/
SET IDENTITY_INSERT [dbo].[L8-Shippers] ON
INSERT [dbo].[L8-Shippers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (1, N'Shipping Company A', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'123 Any Street', N'Memphis', N'TN', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Shippers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (2, N'Shipping Company B', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'123 Any Street', N'Memphis', N'TN', N'99999', N'USA', NULL, NULL, NULL)
INSERT [dbo].[L8-Shippers] ([ID], [Company], [Last Name], [First Name], [E-mail Address], [Job Title], [Business Phone], [Home Phone], [Mobile Phone], [Fax Number], [Address], [City], [State/Province], [ZIP/Postal Code], [Country/Region], [Web Page], [Notes], [Attachments]) VALUES (3, N'Shipping Company C', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, N'123 Any Street', N'Memphis', N'TN', N'99999', N'USA', NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[L8-Shippers] OFF
/****** Object:  Table [dbo].[L8-Strings]    Script Date: 10/26/2009 11:47:19 ******/
SET IDENTITY_INSERT [dbo].[L8-Strings] ON
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (2, N'Northwind Traders')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (3, N'Cannot remove posted inventory!')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (4, N'Back ordered product filled for Order #|')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (5, N'Discounted price below cost!')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (6, N'Insufficient inventory.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (7, N'Insufficient inventory. Do you want to create a purchase order?')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (8, N'Purchase orders were successfully created for | products')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (9, N'There are no products below their respective reorder levels')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (10, N'Must specify customer name!')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (11, N'Restocking will generate purchase orders for all products below desired inventory levels.  Do you want to continue?')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (12, N'Cannot create purchase order.  No suppliers listed for specified product')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (13, N'Discounted price is below cost!')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (14, N'Do you want to continue?')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (15, N'Order is already invoiced. Do you want to print the invoice?')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (16, N'Order does not contain any line items')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (17, N'Cannot create invoice!  Inventory has not been allocated for each specified product.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (18, N'Sorry, there are no sales in the specified time period')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (19, N'Product successfully restocked.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (21, N'Product does not need restocking! Product is already at desired inventory level.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (22, N'Product restocking failed!')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (23, N'Invalid login specified!')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (24, N'Must first select reported!')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (25, N'Changing supplier will remove purchase line items, continue?')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (26, N'Purchase orders were successfully submitted for | products.  Do you want to view the restocking report?')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (27, N'There was an error attempting to restock inventory levels.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (28, N'| product(s) were successfully restocked.  Do you want to view the restocking report?')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (29, N'You cannot remove purchase line items already posted to inventory!')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (30, N'There was an error removing one or more purchase line items.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (31, N'You cannot modify quantity for purchased product already received or posted to inventory.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (32, N'You cannot modify price for purchased product already received or posted to inventory.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (33, N'Product has been successfully posted to inventory.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (34, N'Sorry, product cannot be successfully posted to inventory.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (35, N'There are orders with this product on back order.  Would you like to fill them now?')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (36, N'Cannot post product to inventory without specifying received date!')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (37, N'Do you want to post received product to inventory?')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (38, N'Initialize purchase, orders, and inventory data?')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (39, N'Must first specify employee name!')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (40, N'Specified user must be logged in to approve purchase!')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (41, N'Purchase order must contain completed line items before it can be approved')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (42, N'Sorry, you do not have permission to approve purchases.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (43, N'Purchase successfully approved')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (44, N'Purchase cannot be approved')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (45, N'Purchase successfully submitted for approval')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (46, N'Purchase cannot be submitted for approval')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (47, N'Sorry, purchase order does not contain line items')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (48, N'Do you want to cancel this order?')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (49, N'Canceling an order will permanently delete the order.  Are you sure you want to cancel?')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (100, N'Your order was successfully canceled.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (101, N'Cannot cancel an order that has items received and posted to inventory.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (102, N'There was an error trying to cancel this order.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (103, N'The invoice for this order has not yet been created.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (104, N'Shipping information is not complete.  Please specify all shipping information and try again.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (105, N'Cannot mark as shipped.  Order must first be invoiced!')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (106, N'Cannot cancel an order that has already shipped!')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (107, N'Must first specify salesperson!')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (108, N'Order is now marked closed.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (109, N'Order must first be marked shipped before closing.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (110, N'Must first specify payment information!')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (111, N'There was an error attempting to restock inventory levels.  | product(s) were successfully restocked.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (112, N'You must supply a Unit Cost.')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (113, N'Fill back ordered product, Order #|')
INSERT [dbo].[L8-Strings] ([String ID], [String Data]) VALUES (114, N'Purchase generated based on Order #|')
SET IDENTITY_INSERT [dbo].[L8-Strings] OFF
/****** Object:  Table [dbo].[L8-Orders Tax Status]    Script Date: 10/26/2009 11:47:19 ******/
INSERT [dbo].[L8-Orders Tax Status] ([ID], [Tax Status Name]) VALUES (0, N'Tax Exempt')
INSERT [dbo].[L8-Orders Tax Status] ([ID], [Tax Status Name]) VALUES (1, N'Taxable')
/****** Object:  Table [dbo].[L8-Employee Privileges]    Script Date: 10/26/2009 11:47:19 ******/
INSERT [dbo].[L8-Employee Privileges] ([Employee ID], [Privilege ID]) VALUES (2, 2)
/****** Object:  Table [dbo].[L8-Orders]    Script Date: 10/26/2009 11:47:19 ******/
SET IDENTITY_INSERT [dbo].[L8-Orders] ON
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (30, 9, 27, CAST(0x0000974A00000000 AS DateTime), CAST(0x0000975100000000 AS DateTime), 2, N'Karen Toh', N'789 27th Street', N'Las Vegas', N'NV', N'99999', N'USA', 200.0000, 0.0000, N'Check', CAST(0x0000974A00000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (31, 3, 4, CAST(0x0000974F00000000 AS DateTime), CAST(0x0000975100000000 AS DateTime), 1, N'Christina Lee', N'123 4th Street', N'New York', N'NY', N'99999', N'USA', 5.0000, 0.0000, N'Credit Card', CAST(0x0000974F00000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (32, 4, 12, CAST(0x0000975100000000 AS DateTime), CAST(0x0000975100000000 AS DateTime), 2, N'John Edwards', N'123 12th Street', N'Las Vegas', N'NV', N'99999', N'USA', 5.0000, 0.0000, N'Credit Card', CAST(0x0000975100000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (33, 6, 8, CAST(0x0000975900000000 AS DateTime), CAST(0x0000975A00000000 AS DateTime), 3, N'Elizabeth Andersen', N'123 8th Street', N'Portland', N'OR', N'99999', N'USA', 50.0000, 0.0000, N'Credit Card', CAST(0x0000975900000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (34, 9, 4, CAST(0x0000976000000000 AS DateTime), CAST(0x0000976100000000 AS DateTime), 3, N'Christina Lee', N'123 4th Street', N'New York', N'NY', N'99999', N'USA', 4.0000, 0.0000, N'Check', CAST(0x0000976000000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (35, 3, 29, CAST(0x0000976400000000 AS DateTime), CAST(0x0000976600000000 AS DateTime), 2, N'Soo Jung Lee', N'789 29th Street', N'Denver', N'CO', N'99999', N'USA', 7.0000, 0.0000, N'Check', CAST(0x0000976400000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (36, 4, 3, CAST(0x0000977100000000 AS DateTime), CAST(0x0000977300000000 AS DateTime), 2, N'Thomas Axen', N'123 3rd Street', N'Los Angelas', N'CA', N'99999', N'USA', 7.0000, 0.0000, N'Cash', CAST(0x0000977100000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (37, 8, 6, CAST(0x0000977C00000000 AS DateTime), CAST(0x0000977F00000000 AS DateTime), 2, N'Francisco Pérez-Olaeta', N'123 6th Street', N'Milwaukee', N'WI', N'99999', N'USA', 12.0000, 0.0000, N'Credit Card', CAST(0x0000977C00000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (38, 9, 28, CAST(0x0000978000000000 AS DateTime), CAST(0x0000978100000000 AS DateTime), 3, N'Amritansh Raghav', N'789 28th Street', N'Memphis', N'TN', N'99999', N'USA', 10.0000, 0.0000, N'Check', CAST(0x0000978000000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (39, 3, 8, CAST(0x0000978C00000000 AS DateTime), CAST(0x0000978E00000000 AS DateTime), 3, N'Elizabeth Andersen', N'123 8th Street', N'Portland', N'OR', N'99999', N'USA', 5.0000, 0.0000, N'Check', CAST(0x0000978C00000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (40, 4, 10, CAST(0x0000978E00000000 AS DateTime), CAST(0x0000978E00000000 AS DateTime), 2, N'Roland Wacker', N'123 10th Street', N'Chicago', N'IL', N'99999', N'USA', 9.0000, 0.0000, N'Credit Card', CAST(0x0000978E00000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (41, 1, 7, CAST(0x0000978E00000000 AS DateTime), NULL, NULL, N'Ming-Yang Xie', N'123 7th Street', N'Boise', N'ID', N'99999', N'USA', 0.0000, 0.0000, NULL, NULL, NULL, 0, NULL, 0)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (42, 1, 10, CAST(0x0000978E00000000 AS DateTime), CAST(0x0000979C00000000 AS DateTime), 1, N'Roland Wacker', N'123 10th Street', N'Chicago', N'IL', N'99999', N'USA', 0.0000, 0.0000, NULL, NULL, NULL, 0, NULL, 2)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (43, 1, 11, CAST(0x0000978E00000000 AS DateTime), NULL, 3, N'Peter Krschne', N'123 11th Street', N'Miami', N'FL', N'99999', N'USA', 0.0000, 0.0000, NULL, NULL, NULL, 0, NULL, 0)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (44, 1, 1, CAST(0x0000978E00000000 AS DateTime), NULL, NULL, N'Anna Bedecs', N'123 1st Street', N'Seattle', N'WA', N'99999', N'USA', 0.0000, 0.0000, NULL, NULL, NULL, 0, NULL, 0)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (45, 1, 28, CAST(0x0000979C00000000 AS DateTime), CAST(0x0000979C00000000 AS DateTime), 3, N'Amritansh Raghav', N'789 28th Street', N'Memphis', N'TN', N'99999', N'USA', 40.0000, 0.0000, N'Credit Card', CAST(0x0000979C00000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (46, 7, 9, CAST(0x0000979A00000000 AS DateTime), CAST(0x0000979A00000000 AS DateTime), 1, N'Sven Mortensen', N'123 9th Street', N'Salt Lake City', N'UT', N'99999', N'USA', 100.0000, 0.0000, N'Check', CAST(0x0000979A00000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (47, 6, 6, CAST(0x0000979D00000000 AS DateTime), CAST(0x0000979D00000000 AS DateTime), 2, N'Francisco Pérez-Olaeta', N'123 6th Street', N'Milwaukee', N'WI', N'99999', N'USA', 300.0000, 0.0000, N'Credit Card', CAST(0x0000979D00000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (48, 4, 8, CAST(0x0000979A00000000 AS DateTime), CAST(0x0000979A00000000 AS DateTime), 2, N'Elizabeth Andersen', N'123 8th Street', N'Portland', N'OR', N'99999', N'USA', 50.0000, 0.0000, N'Check', CAST(0x0000979A00000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (50, 9, 25, CAST(0x0000979A00000000 AS DateTime), CAST(0x0000979A00000000 AS DateTime), 1, N'John Rodman', N'789 25th Street', N'Chicago', N'IL', N'99999', N'USA', 5.0000, 0.0000, N'Cash', CAST(0x0000979A00000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (51, 9, 26, CAST(0x0000979A00000000 AS DateTime), CAST(0x0000979A00000000 AS DateTime), 3, N'Run Liu', N'789 26th Street', N'Miami', N'FL', N'99999', N'USA', 60.0000, 0.0000, N'Credit Card', CAST(0x0000979A00000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (55, 1, 29, CAST(0x0000979A00000000 AS DateTime), CAST(0x0000979A00000000 AS DateTime), 2, N'Soo Jung Lee', N'789 29th Street', N'Denver', N'CO', N'99999', N'USA', 200.0000, 0.0000, N'Check', CAST(0x0000979A00000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (56, 2, 6, CAST(0x0000979800000000 AS DateTime), CAST(0x0000979800000000 AS DateTime), 3, N'Francisco Pérez-Olaeta', N'123 6th Street', N'Milwaukee', N'WI', N'99999', N'USA', 0.0000, 0.0000, N'Check', CAST(0x0000979800000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (57, 9, 27, CAST(0x000097AB00000000 AS DateTime), CAST(0x000097AB00000000 AS DateTime), 2, N'Karen Toh', N'789 27th Street', N'Las Vegas', N'NV', N'99999', N'USA', 200.0000, 0.0000, N'Check', CAST(0x000097AB00000000 AS DateTime), NULL, 0, NULL, 0)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (58, 3, 4, CAST(0x000097AB00000000 AS DateTime), CAST(0x000097AB00000000 AS DateTime), 1, N'Christina Lee', N'123 4th Street', N'New York', N'NY', N'99999', N'USA', 5.0000, 0.0000, N'Credit Card', CAST(0x000097AB00000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (59, 4, 12, CAST(0x000097AB00000000 AS DateTime), CAST(0x000097AB00000000 AS DateTime), 2, N'John Edwards', N'123 12th Street', N'Las Vegas', N'NV', N'99999', N'USA', 5.0000, 0.0000, N'Credit Card', CAST(0x000097AB00000000 AS DateTime), NULL, 0, NULL, 0)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (60, 6, 8, CAST(0x000097B300000000 AS DateTime), CAST(0x000097B300000000 AS DateTime), 3, N'Elizabeth Andersen', N'123 8th Street', N'Portland', N'OR', N'99999', N'USA', 50.0000, 0.0000, N'Credit Card', CAST(0x000097B300000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (61, 9, 4, CAST(0x0000979C00000000 AS DateTime), CAST(0x0000979C00000000 AS DateTime), 3, N'Christina Lee', N'123 4th Street', N'New York', N'NY', N'99999', N'USA', 4.0000, 0.0000, N'Check', CAST(0x0000979C00000000 AS DateTime), NULL, 0, NULL, 0)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (62, 3, 29, CAST(0x000097A100000000 AS DateTime), CAST(0x000097A100000000 AS DateTime), 2, N'Soo Jung Lee', N'789 29th Street', N'Denver', N'CO', N'99999', N'USA', 7.0000, 0.0000, N'Check', CAST(0x000097A100000000 AS DateTime), NULL, 0, NULL, 0)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (63, 4, 3, CAST(0x000097AE00000000 AS DateTime), CAST(0x000097AE00000000 AS DateTime), 2, N'Thomas Axen', N'123 3rd Street', N'Los Angelas', N'CA', N'99999', N'USA', 7.0000, 0.0000, N'Cash', CAST(0x000097AE00000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (64, 8, 6, CAST(0x000097BC00000000 AS DateTime), CAST(0x000097BC00000000 AS DateTime), 2, N'Francisco Pérez-Olaeta', N'123 6th Street', N'Milwaukee', N'WI', N'99999', N'USA', 12.0000, 0.0000, N'Credit Card', CAST(0x000097BC00000000 AS DateTime), NULL, 0, NULL, 0)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (65, 9, 28, CAST(0x000097BE00000000 AS DateTime), CAST(0x000097BE00000000 AS DateTime), 3, N'Amritansh Raghav', N'789 28th Street', N'Memphis', N'TN', N'99999', N'USA', 10.0000, 0.0000, N'Check', CAST(0x000097BE00000000 AS DateTime), NULL, 0, NULL, 0)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (66, 3, 8, CAST(0x000097CB00000000 AS DateTime), CAST(0x000097CB00000000 AS DateTime), 3, N'Elizabeth Andersen', N'123 8th Street', N'Portland', N'OR', N'99999', N'USA', 5.0000, 0.0000, N'Check', CAST(0x000097CB00000000 AS DateTime), NULL, 0, NULL, 0)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (67, 4, 10, CAST(0x000097CB00000000 AS DateTime), CAST(0x000097CB00000000 AS DateTime), 2, N'Roland Wacker', N'123 10th Street', N'Chicago', N'IL', N'99999', N'USA', 9.0000, 0.0000, N'Credit Card', CAST(0x000097CB00000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (68, 1, 7, CAST(0x000097CB00000000 AS DateTime), NULL, NULL, N'Ming-Yang Xie', N'123 7th Street', N'Boise', N'ID', N'99999', N'USA', 0.0000, 0.0000, NULL, NULL, NULL, 0, NULL, 0)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (69, 1, 10, CAST(0x000097CB00000000 AS DateTime), NULL, 1, N'Roland Wacker', N'123 10th Street', N'Chicago', N'IL', N'99999', N'USA', 0.0000, 0.0000, NULL, NULL, NULL, 0, NULL, 0)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (70, 1, 11, CAST(0x000097CB00000000 AS DateTime), NULL, 3, N'Peter Krschne', N'123 11th Street', N'Miami', N'FL', N'99999', N'USA', 0.0000, 0.0000, NULL, NULL, NULL, 0, NULL, 0)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (71, 1, 1, CAST(0x000097CB00000000 AS DateTime), NULL, 3, N'Anna Bedecs', N'123 1st Street', N'Seattle', N'WA', N'99999', N'USA', 0.0000, 0.0000, NULL, NULL, NULL, 0, NULL, 0)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (72, 1, 28, CAST(0x000097D900000000 AS DateTime), CAST(0x000097D900000000 AS DateTime), 3, N'Amritansh Raghav', N'789 28th Street', N'Memphis', N'TN', N'99999', N'USA', 40.0000, 0.0000, N'Credit Card', CAST(0x000097D900000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (73, 7, 9, CAST(0x000097D700000000 AS DateTime), CAST(0x000097D700000000 AS DateTime), 1, N'Sven Mortensen', N'123 9th Street', N'Salt Lake City', N'UT', N'99999', N'USA', 100.0000, 0.0000, N'Check', CAST(0x000097D700000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (74, 6, 6, CAST(0x000097DA00000000 AS DateTime), CAST(0x000097DA00000000 AS DateTime), 2, N'Francisco Pérez-Olaeta', N'123 6th Street', N'Milwaukee', N'WI', N'99999', N'USA', 300.0000, 0.0000, N'Credit Card', CAST(0x000097DA00000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (75, 4, 8, CAST(0x000097D700000000 AS DateTime), CAST(0x000097D700000000 AS DateTime), 2, N'Elizabeth Andersen', N'123 8th Street', N'Portland', N'OR', N'99999', N'USA', 50.0000, 0.0000, N'Check', CAST(0x000097D700000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (76, 9, 25, CAST(0x000097D700000000 AS DateTime), CAST(0x000097D700000000 AS DateTime), 1, N'John Rodman', N'789 25th Street', N'Chicago', N'IL', N'99999', N'USA', 5.0000, 0.0000, N'Cash', CAST(0x000097D700000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (77, 9, 26, CAST(0x000097D700000000 AS DateTime), CAST(0x000097D700000000 AS DateTime), 3, N'Run Liu', N'789 26th Street', N'Miami', N'FL', N'99999', N'USA', 60.0000, 0.0000, N'Credit Card', CAST(0x000097D700000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (78, 1, 29, CAST(0x000097D700000000 AS DateTime), CAST(0x000097D700000000 AS DateTime), 2, N'Soo Jung Lee', N'789 29th Street', N'Denver', N'CO', N'99999', N'USA', 200.0000, 0.0000, N'Check', CAST(0x000097D700000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (79, 2, 6, CAST(0x000097E900000000 AS DateTime), CAST(0x000097E900000000 AS DateTime), 3, N'Francisco Pérez-Olaeta', N'123 6th Street', N'Milwaukee', N'WI', N'99999', N'USA', 0.0000, 0.0000, N'Check', CAST(0x000097E900000000 AS DateTime), NULL, 0, NULL, 3)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (80, 2, 4, CAST(0x000097AE01193A24 AS DateTime), NULL, NULL, N'Christina Lee', N'123 4th Street', N'New York', N'NY', N'99999', N'USA', 0.0000, 0.0000, NULL, NULL, NULL, 0, NULL, 0)
INSERT [dbo].[L8-Orders] ([Order ID], [Employee ID], [Customer ID], [Order Date], [Shipped Date], [Shipper ID], [Ship Name], [Ship Address], [Ship City], [Ship State/Province], [Ship ZIP/Postal Code], [Ship Country/Region], [Shipping Fee], [Taxes], [Payment Type], [Paid Date], [Notes], [Tax Rate], [Tax Status], [Status ID]) VALUES (81, 2, 3, CAST(0x000097AE011F88FC AS DateTime), NULL, NULL, N'Thomas Axen', N'123 3rd Street', N'Los Angelas', N'CA', N'99999', N'USA', 0.0000, 0.0000, NULL, NULL, NULL, 0, NULL, 0)
SET IDENTITY_INSERT [dbo].[L8-Orders] OFF
/****** Object:  Table [dbo].[L8-Purchase Orders]    Script Date: 10/26/2009 11:47:19 ******/
SET IDENTITY_INSERT [dbo].[L8-Purchase Orders] ON
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (90, 1, 2, CAST(0x0000974900000000 AS DateTime), CAST(0x0000975100000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, NULL, 2, CAST(0x0000975100000000 AS DateTime), 2)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (91, 3, 2, CAST(0x0000974900000000 AS DateTime), CAST(0x0000975100000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, NULL, 2, CAST(0x0000975100000000 AS DateTime), 2)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (92, 2, 2, CAST(0x0000974900000000 AS DateTime), CAST(0x0000975100000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, NULL, 2, CAST(0x0000975100000000 AS DateTime), 2)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (93, 5, 2, CAST(0x0000974900000000 AS DateTime), CAST(0x0000975100000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, NULL, 2, CAST(0x0000975100000000 AS DateTime), 2)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (94, 6, 2, CAST(0x0000974900000000 AS DateTime), CAST(0x0000975100000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, NULL, 2, CAST(0x0000975100000000 AS DateTime), 2)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (95, 4, 2, CAST(0x0000974900000000 AS DateTime), CAST(0x0000975100000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, NULL, 2, CAST(0x0000975100000000 AS DateTime), 2)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (96, 1, 5, CAST(0x0000974900000000 AS DateTime), CAST(0x0000975100000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, N'Purchase generated based on Order #30', 2, CAST(0x0000975100000000 AS DateTime), 5)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (97, 2, 7, CAST(0x0000974900000000 AS DateTime), CAST(0x0000975100000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, N'Purchase generated based on Order #33', 2, CAST(0x0000975100000000 AS DateTime), 7)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (98, 2, 4, CAST(0x0000974900000000 AS DateTime), CAST(0x0000975100000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, N'Purchase generated based on Order #36', 2, CAST(0x0000975100000000 AS DateTime), 4)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (99, 1, 3, CAST(0x0000974900000000 AS DateTime), CAST(0x0000975100000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, N'Purchase generated based on Order #38', 2, CAST(0x0000975100000000 AS DateTime), 3)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (100, 2, 9, CAST(0x0000974900000000 AS DateTime), CAST(0x0000975100000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, N'Purchase generated based on Order #39', 2, CAST(0x0000975100000000 AS DateTime), 9)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (101, 1, 2, CAST(0x0000974900000000 AS DateTime), CAST(0x0000975100000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, N'Purchase generated based on Order #40', 2, CAST(0x0000975100000000 AS DateTime), 2)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (102, 1, 1, CAST(0x0000978E00000000 AS DateTime), CAST(0x0000978E00000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, N'Purchase generated based on Order #41', 2, CAST(0x0000979900000000 AS DateTime), 1)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (103, 2, 1, CAST(0x0000978E00000000 AS DateTime), CAST(0x0000978E00000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, N'Purchase generated based on Order #42', 2, CAST(0x0000979900000000 AS DateTime), 1)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (104, 2, 1, CAST(0x0000978E00000000 AS DateTime), CAST(0x0000978E00000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, N'Purchase generated based on Order #45', 2, CAST(0x0000979900000000 AS DateTime), 1)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (105, 5, 7, CAST(0x0000978E00000000 AS DateTime), CAST(0x0000978E00000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, N'Check', N'Purchase generated based on Order #46', 2, CAST(0x0000979900000000 AS DateTime), 7)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (106, 6, 7, CAST(0x0000978E00000000 AS DateTime), CAST(0x0000978E00000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, N'Purchase generated based on Order #46', 2, CAST(0x0000979900000000 AS DateTime), 7)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (107, 1, 6, CAST(0x0000978E00000000 AS DateTime), CAST(0x0000978E00000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, N'Purchase generated based on Order #47', 2, CAST(0x0000979900000000 AS DateTime), 6)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (108, 2, 4, CAST(0x0000978E00000000 AS DateTime), CAST(0x0000978E00000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, N'Purchase generated based on Order #48', 2, CAST(0x0000979900000000 AS DateTime), 4)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (109, 2, 4, CAST(0x0000978E00000000 AS DateTime), CAST(0x0000978E00000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, N'Purchase generated based on Order #48', 2, CAST(0x0000979900000000 AS DateTime), 4)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (110, 1, 3, CAST(0x0000978E00000000 AS DateTime), CAST(0x0000978E00000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, N'Purchase generated based on Order #49', 2, CAST(0x0000979900000000 AS DateTime), 3)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (111, 1, 2, CAST(0x0000979500000000 AS DateTime), CAST(0x0000979500000000 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, N'Purchase generated based on Order #56', 2, CAST(0x0000979900000000 AS DateTime), 2)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (140, 6, NULL, CAST(0x000097AE00000000 AS DateTime), CAST(0x000097AE0112E444 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, NULL, 2, CAST(0x000097AE0113157C AS DateTime), 2)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (141, 8, NULL, CAST(0x000097AE00000000 AS DateTime), CAST(0x000097AE011B0EE4 AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, NULL, 2, CAST(0x000097AE011B2654 AS DateTime), 2)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (142, 8, NULL, CAST(0x000097AE00000000 AS DateTime), CAST(0x000097AE011D3A5C AS DateTime), 2, NULL, 0.0000, 0.0000, NULL, 0.0000, N'Check', NULL, 2, CAST(0x000097AE011D5424 AS DateTime), 2)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (146, 2, 2, CAST(0x000097AF012FF0FC AS DateTime), CAST(0x000097AF012FF0FC AS DateTime), 1, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, NULL, NULL, NULL, 2)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (147, 7, 2, CAST(0x000097AF0131D2A0 AS DateTime), CAST(0x000097AF0131D2A0 AS DateTime), 1, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, NULL, NULL, NULL, 2)
INSERT [dbo].[L8-Purchase Orders] ([Purchase Order ID], [Supplier ID], [Created By], [Submitted Date], [Creation Date], [Status ID], [Expected Date], [Shipping Fee], [Taxes], [Payment Date], [Payment Amount], [Payment Method], [Notes], [Approved By], [Approved Date], [Submitted By]) VALUES (148, 5, 2, CAST(0x000097AF0131EEC0 AS DateTime), CAST(0x000097AF0131EEC0 AS DateTime), 1, NULL, 0.0000, 0.0000, NULL, 0.0000, NULL, NULL, NULL, NULL, 2)
SET IDENTITY_INSERT [dbo].[L8-Purchase Orders] OFF
/****** Object:  Table [dbo].[L8-Inventory Transactions]    Script Date: 10/26/2009 11:47:19 ******/
SET IDENTITY_INSERT [dbo].[L8-Inventory Transactions] ON
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (35, 1, CAST(0x0000978C01085970 AS DateTime), CAST(0x0000978C01085970 AS DateTime), 80, 75, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (36, 1, CAST(0x0000978C010870E0 AS DateTime), CAST(0x0000978C010870E0 AS DateTime), 72, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (37, 1, CAST(0x0000978C010883A0 AS DateTime), CAST(0x0000978C010883A0 AS DateTime), 52, 100, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (38, 1, CAST(0x0000978C0108897C AS DateTime), CAST(0x0000978C0108897C AS DateTime), 56, 120, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (39, 1, CAST(0x0000978C01088F58 AS DateTime), CAST(0x0000978C01088F58 AS DateTime), 57, 80, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (40, 1, CAST(0x0000978C0108ADD0 AS DateTime), CAST(0x0000978C0108ADD0 AS DateTime), 6, 100, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (41, 1, CAST(0x0000978C0108B604 AS DateTime), CAST(0x0000978C0108B604 AS DateTime), 7, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (42, 1, CAST(0x0000978C0108BE38 AS DateTime), CAST(0x0000978C0108BE38 AS DateTime), 8, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (43, 1, CAST(0x0000978C0108C798 AS DateTime), CAST(0x0000978C0108C798 AS DateTime), 14, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (44, 1, CAST(0x0000978C0108CD74 AS DateTime), CAST(0x0000978C0108CD74 AS DateTime), 17, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (45, 1, CAST(0x0000978C0108D350 AS DateTime), CAST(0x0000978C0108D350 AS DateTime), 19, 20, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (46, 1, CAST(0x0000978C0108D92C AS DateTime), CAST(0x0000978C0108D92C AS DateTime), 20, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (47, 1, CAST(0x0000978C0108DCB0 AS DateTime), CAST(0x0000978C0108DCB0 AS DateTime), 21, 20, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (48, 1, CAST(0x0000978C0108E160 AS DateTime), CAST(0x0000978C0108E160 AS DateTime), 40, 120, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (49, 1, CAST(0x0000978C0108E610 AS DateTime), CAST(0x0000978C0108E610 AS DateTime), 41, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (50, 1, CAST(0x0000978C0108E994 AS DateTime), CAST(0x0000978C0108E994 AS DateTime), 48, 100, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (51, 1, CAST(0x0000978C0108F1C8 AS DateTime), CAST(0x0000978C0108F1C8 AS DateTime), 51, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (52, 1, CAST(0x0000978C0108F54C AS DateTime), CAST(0x0000978C0108F54C AS DateTime), 74, 20, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (53, 1, CAST(0x0000978C0108F9FC AS DateTime), CAST(0x0000978C0108F9FC AS DateTime), 77, 60, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (54, 1, CAST(0x0000978C010913C4 AS DateTime), CAST(0x0000978C010913C4 AS DateTime), 3, 100, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (55, 1, CAST(0x0000978C01091874 AS DateTime), CAST(0x0000978C01091874 AS DateTime), 4, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (56, 1, CAST(0x0000978C01091BF8 AS DateTime), CAST(0x0000978C01091BF8 AS DateTime), 5, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (57, 1, CAST(0x0000978C01092A08 AS DateTime), CAST(0x0000978C01092A08 AS DateTime), 65, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (58, 1, CAST(0x0000978C01093110 AS DateTime), CAST(0x0000978C01093110 AS DateTime), 66, 80, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (59, 1, CAST(0x0000978C010942A4 AS DateTime), CAST(0x0000978C010942A4 AS DateTime), 1, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (60, 1, CAST(0x0000978C01094754 AS DateTime), CAST(0x0000978C01094754 AS DateTime), 34, 60, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (61, 1, CAST(0x0000978C010951E0 AS DateTime), CAST(0x0000978C010951E0 AS DateTime), 43, 100, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (62, 1, CAST(0x0000978C01095564 AS DateTime), CAST(0x0000978C01095564 AS DateTime), 81, 125, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (63, 2, CAST(0x0000978C0109D9D0 AS DateTime), CAST(0x0000978E00B61930 AS DateTime), 80, 30, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (64, 2, CAST(0x0000978C0109F4C4 AS DateTime), CAST(0x0000978C010A23A4 AS DateTime), 7, 10, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (65, 2, CAST(0x0000978C010A007C AS DateTime), CAST(0x0000978C010A23A4 AS DateTime), 51, 10, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (66, 2, CAST(0x0000978C010A09DC AS DateTime), CAST(0x0000978C010A23A4 AS DateTime), 80, 10, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (67, 2, CAST(0x0000978C010A5AB8 AS DateTime), CAST(0x0000978C010A8AC4 AS DateTime), 1, 15, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (68, 2, CAST(0x0000978C010A7228 AS DateTime), CAST(0x0000978C010A8AC4 AS DateTime), 43, 20, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (69, 2, CAST(0x0000978C010ADF24 AS DateTime), CAST(0x0000978E00B586B4 AS DateTime), 19, 20, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (70, 2, CAST(0x0000978C010AF310 AS DateTime), CAST(0x0000978E00B52FFC AS DateTime), 48, 10, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (71, 2, CAST(0x0000978C010B19BC AS DateTime), CAST(0x0000978E00B49FD8 AS DateTime), 8, 17, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (72, 1, CAST(0x0000978E00B03178 AS DateTime), CAST(0x0000978E00B03178 AS DateTime), 81, 200, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (73, 2, CAST(0x0000978E00B034FC AS DateTime), CAST(0x0000978E00B03F88 AS DateTime), 81, 200, NULL, NULL, N'Fill Back Ordered product, Order #40')
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (74, 1, CAST(0x0000978E00B3694C AS DateTime), CAST(0x0000978E00B3694C AS DateTime), 48, 100, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (75, 2, CAST(0x0000978E00B36CD0 AS DateTime), CAST(0x0000978E00B41C98 AS DateTime), 48, 100, NULL, NULL, N'Fill Back Ordered product, Order #39')
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (76, 1, CAST(0x0000978E00B38440 AS DateTime), CAST(0x0000978E00B38440 AS DateTime), 43, 300, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (77, 2, CAST(0x0000978E00B387C4 AS DateTime), CAST(0x0000978E00B46FCC AS DateTime), 43, 300, NULL, NULL, N'Fill Back Ordered product, Order #38')
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (78, 1, CAST(0x0000978E00B3A510 AS DateTime), CAST(0x0000978E00B3A510 AS DateTime), 41, 200, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (79, 2, CAST(0x0000978E00B3A894 AS DateTime), CAST(0x0000978E00B4E880 AS DateTime), 41, 200, NULL, NULL, N'Fill Back Ordered product, Order #36')
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (80, 1, CAST(0x0000978E00B3C70C AS DateTime), CAST(0x0000978E00B3C70C AS DateTime), 19, 30, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (81, 2, CAST(0x0000978E00B3C964 AS DateTime), CAST(0x0000978E00B5D538 AS DateTime), 19, 30, NULL, NULL, N'Fill Back Ordered product, Order #33')
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (82, 1, CAST(0x0000978E00B3E458 AS DateTime), CAST(0x0000978E00B3E458 AS DateTime), 34, 100, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (83, 2, CAST(0x0000978E00B3E908 AS DateTime), CAST(0x0000978E00B61930 AS DateTime), 34, 100, NULL, NULL, N'Fill Back Ordered product, Order #30')
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (84, 2, CAST(0x0000978E00F3F714 AS DateTime), CAST(0x0000979900C09978 AS DateTime), 6, 10, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (85, 2, CAST(0x0000978E00F40074 AS DateTime), CAST(0x0000979900C09978 AS DateTime), 4, 10, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (86, 3, CAST(0x0000978E00F43E90 AS DateTime), CAST(0x0000978E00F43E90 AS DateTime), 80, 20, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (87, 3, CAST(0x0000978E00F44340 AS DateTime), CAST(0x0000978E00F44340 AS DateTime), 81, 50, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (88, 3, CAST(0x0000978E00F47CAC AS DateTime), CAST(0x0000978E00F47CAC AS DateTime), 1, 25, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (89, 3, CAST(0x0000978E00F48288 AS DateTime), CAST(0x0000978E00F48288 AS DateTime), 43, 25, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (90, 3, CAST(0x0000978E00F48738 AS DateTime), CAST(0x0000978E00F48738 AS DateTime), 81, 25, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (91, 2, CAST(0x0000978E00F4BBF4 AS DateTime), CAST(0x0000979900B7DB30 AS DateTime), 40, 50, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (92, 2, CAST(0x0000978E00F5D534 AS DateTime), CAST(0x0000979900B72DC0 AS DateTime), 21, 20, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (93, 2, CAST(0x0000978E00F5FF64 AS DateTime), CAST(0x0000979900B6FB5C AS DateTime), 5, 25, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (94, 2, CAST(0x0000978E00F60EA0 AS DateTime), CAST(0x0000979900B6FB5C AS DateTime), 41, 30, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (95, 2, CAST(0x0000978E00F6228C AS DateTime), CAST(0x0000979900B6FB5C AS DateTime), 40, 30, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (96, 3, CAST(0x0000979401147638 AS DateTime), CAST(0x0000979401147638 AS DateTime), 34, 12, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (97, 3, CAST(0x00009794011E9794 AS DateTime), CAST(0x00009794011E9794 AS DateTime), 34, 10, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (98, 3, CAST(0x00009794011EE4EC AS DateTime), CAST(0x00009794011EE4EC AS DateTime), 34, 1, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (99, 2, CAST(0x0000979800E400C0 AS DateTime), CAST(0x0000979800E408F4 AS DateTime), 48, 10, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (100, 1, CAST(0x0000979900B58588 AS DateTime), CAST(0x0000979900B58588 AS DateTime), 57, 100, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (101, 2, CAST(0x0000979900B587E0 AS DateTime), CAST(0x0000979900B7B22C AS DateTime), 57, 100, NULL, NULL, N'Fill Back Ordered product, Order #46')
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (102, 1, CAST(0x0000979900B59CF8 AS DateTime), CAST(0x0000979900B59CF8 AS DateTime), 34, 50, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (103, 1, CAST(0x0000979900B5B594 AS DateTime), CAST(0x0000979900B5B594 AS DateTime), 43, 250, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (104, 3, CAST(0x0000979900B5B7EC AS DateTime), CAST(0x0000979900B5B7EC AS DateTime), 43, 300, NULL, NULL, N'Fill Back Ordered product, Order #41')
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (105, 1, CAST(0x0000979900B5CD04 AS DateTime), CAST(0x0000979900B5CD04 AS DateTime), 8, 25, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (106, 2, CAST(0x0000979900B5D088 AS DateTime), CAST(0x0000979900B75DCC AS DateTime), 8, 25, NULL, NULL, N'Fill Back Ordered product, Order #48')
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (107, 1, CAST(0x0000979900B5E6CC AS DateTime), CAST(0x0000979900B5E6CC AS DateTime), 34, 300, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (108, 2, CAST(0x0000979900B5E924 AS DateTime), CAST(0x0000979900B78928 AS DateTime), 34, 300, NULL, NULL, N'Fill Back Ordered product, Order #47')
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (109, 1, CAST(0x0000979900B5FE3C AS DateTime), CAST(0x0000979900B5FE3C AS DateTime), 19, 25, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (110, 2, CAST(0x0000979900B60094 AS DateTime), CAST(0x0000979900C09978 AS DateTime), 19, 10, NULL, NULL, N'Fill Back Ordered product, Order #42')
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (111, 1, CAST(0x0000979900B61480 AS DateTime), CAST(0x0000979900B61480 AS DateTime), 19, 10, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (112, 2, CAST(0x0000979900B616D8 AS DateTime), CAST(0x0000979900B75DCC AS DateTime), 19, 25, NULL, NULL, N'Fill Back Ordered product, Order #48')
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (113, 1, CAST(0x0000979900B62740 AS DateTime), CAST(0x0000979900B62740 AS DateTime), 72, 50, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (114, 2, CAST(0x0000979900B62998 AS DateTime), CAST(0x0000979900B7B22C AS DateTime), 72, 50, NULL, NULL, N'Fill Back Ordered product, Order #46')
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (115, 1, CAST(0x0000979900B645B8 AS DateTime), CAST(0x0000979900B645B8 AS DateTime), 41, 50, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (116, 2, CAST(0x0000979900B646E4 AS DateTime), CAST(0x0000979900B7DB30 AS DateTime), 41, 50, NULL, NULL, N'Fill Back Ordered product, Order #45')
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (117, 2, CAST(0x0000979900B69FF4 AS DateTime), CAST(0x0000979900B6AA80 AS DateTime), 34, 87, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (118, 2, CAST(0x0000979900BF1DC8 AS DateTime), CAST(0x0000979900BF2278 AS DateTime), 51, 30, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (119, 2, CAST(0x0000979900BF1EF4 AS DateTime), CAST(0x0000979900BF2278 AS DateTime), 7, 30, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (120, 2, CAST(0x0000979900BF3B14 AS DateTime), CAST(0x0000979900BF421C AS DateTime), 17, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (121, 2, CAST(0x0000979900BF5734 AS DateTime), CAST(0x0000979900BF6094 AS DateTime), 6, 90, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (122, 2, CAST(0x0000979900BF76D8 AS DateTime), CAST(0x0000979900BF7A5C AS DateTime), 4, 30, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (123, 2, CAST(0x0000979900BFA48C AS DateTime), CAST(0x0000979900BFA93C AS DateTime), 48, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (124, 2, CAST(0x0000979900BFBE54 AS DateTime), CAST(0x0000979900BFC304 AS DateTime), 48, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (125, 2, CAST(0x0000979900BFD5C4 AS DateTime), CAST(0x0000979900BFDBA0 AS DateTime), 41, 10, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (126, 2, CAST(0x0000979900BFEE60 AS DateTime), CAST(0x0000979900BFF43C AS DateTime), 43, 5, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (127, 2, CAST(0x0000979900C00A80 AS DateTime), CAST(0x0000979900C01E6C AS DateTime), 40, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (128, 2, CAST(0x0000979900C03708 AS DateTime), CAST(0x0000979900C03A8C AS DateTime), 8, 20, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (129, 2, CAST(0x0000979900C051FC AS DateTime), CAST(0x0000979900C05580 AS DateTime), 80, 15, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (130, 2, CAST(0x0000979900C06840 AS DateTime), CAST(0x0000979900C06F48 AS DateTime), 74, 20, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (131, 2, CAST(0x0000979900C0B6C4 AS DateTime), CAST(0x0000979900C0BDCC AS DateTime), 72, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (132, 2, CAST(0x0000979900C0E34C AS DateTime), CAST(0x0000979900C0EDD8 AS DateTime), 3, 50, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (133, 2, CAST(0x0000979900C0EB80 AS DateTime), CAST(0x0000979900C0EDD8 AS DateTime), 8, 3, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (134, 2, CAST(0x0000979900C107A0 AS DateTime), CAST(0x0000979900C11F10 AS DateTime), 20, 40, NULL, NULL, NULL)
GO
print 'Processed 100 total records'
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (135, 2, CAST(0x0000979900C11B8C AS DateTime), CAST(0x0000979900C11F10 AS DateTime), 52, 40, NULL, NULL, NULL)
INSERT [dbo].[L8-Inventory Transactions] ([Transaction ID], [Transaction Type], [Transaction Created Date], [Transaction Modified Date], [Product ID], [Quantity], [Purchase Order ID], [Customer Order ID], [Comments]) VALUES (136, 3, CAST(0x000097AE011945DC AS DateTime), CAST(0x000097AE011982CC AS DateTime), 56, 110, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[L8-Inventory Transactions] OFF
/****** Object:  Table [dbo].[L8-Purchase Order Details]    Script Date: 10/26/2009 11:47:19 ******/
SET IDENTITY_INSERT [dbo].[L8-Purchase Order Details] ON
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (238, 90, 1, CAST(40.0000 AS Decimal(18, 4)), 14.0000, CAST(0x0000975100000000 AS DateTime), 1, 59)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (239, 91, 3, CAST(100.0000 AS Decimal(18, 4)), 8.0000, CAST(0x0000975100000000 AS DateTime), 1, 54)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (240, 91, 4, CAST(40.0000 AS Decimal(18, 4)), 16.0000, CAST(0x0000975100000000 AS DateTime), 1, 55)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (241, 91, 5, CAST(40.0000 AS Decimal(18, 4)), 16.0000, CAST(0x0000975100000000 AS DateTime), 1, 56)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (242, 92, 6, CAST(100.0000 AS Decimal(18, 4)), 19.0000, CAST(0x0000975100000000 AS DateTime), 1, 40)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (243, 92, 7, CAST(40.0000 AS Decimal(18, 4)), 22.0000, CAST(0x0000975100000000 AS DateTime), 1, 41)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (244, 92, 8, CAST(40.0000 AS Decimal(18, 4)), 30.0000, CAST(0x0000975100000000 AS DateTime), 1, 42)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (245, 92, 14, CAST(40.0000 AS Decimal(18, 4)), 17.0000, CAST(0x0000975100000000 AS DateTime), 1, 43)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (246, 92, 17, CAST(40.0000 AS Decimal(18, 4)), 29.0000, CAST(0x0000975100000000 AS DateTime), 1, 44)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (247, 92, 19, CAST(20.0000 AS Decimal(18, 4)), 7.0000, CAST(0x0000975100000000 AS DateTime), 1, 45)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (248, 92, 20, CAST(40.0000 AS Decimal(18, 4)), 61.0000, CAST(0x0000975100000000 AS DateTime), 1, 46)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (249, 92, 21, CAST(20.0000 AS Decimal(18, 4)), 8.0000, CAST(0x0000975100000000 AS DateTime), 1, 47)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (250, 90, 34, CAST(60.0000 AS Decimal(18, 4)), 10.0000, CAST(0x0000975100000000 AS DateTime), 1, 60)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (251, 92, 40, CAST(120.0000 AS Decimal(18, 4)), 14.0000, CAST(0x0000975100000000 AS DateTime), 1, 48)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (252, 92, 41, CAST(40.0000 AS Decimal(18, 4)), 7.0000, CAST(0x0000975100000000 AS DateTime), 1, 49)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (253, 90, 43, CAST(100.0000 AS Decimal(18, 4)), 34.0000, CAST(0x0000975100000000 AS DateTime), 1, 61)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (254, 92, 48, CAST(100.0000 AS Decimal(18, 4)), 10.0000, CAST(0x0000975100000000 AS DateTime), 1, 50)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (255, 92, 51, CAST(40.0000 AS Decimal(18, 4)), 40.0000, CAST(0x0000975100000000 AS DateTime), 1, 51)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (256, 93, 52, CAST(100.0000 AS Decimal(18, 4)), 5.0000, CAST(0x0000975100000000 AS DateTime), 1, 37)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (257, 93, 56, CAST(120.0000 AS Decimal(18, 4)), 28.0000, CAST(0x0000975100000000 AS DateTime), 1, 38)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (258, 93, 57, CAST(80.0000 AS Decimal(18, 4)), 15.0000, CAST(0x0000975100000000 AS DateTime), 1, 39)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (259, 91, 65, CAST(40.0000 AS Decimal(18, 4)), 16.0000, CAST(0x0000975100000000 AS DateTime), 1, 57)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (260, 91, 66, CAST(80.0000 AS Decimal(18, 4)), 13.0000, CAST(0x0000975100000000 AS DateTime), 1, 58)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (261, 94, 72, CAST(40.0000 AS Decimal(18, 4)), 26.0000, CAST(0x0000975100000000 AS DateTime), 1, 36)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (262, 92, 74, CAST(20.0000 AS Decimal(18, 4)), 8.0000, CAST(0x0000975100000000 AS DateTime), 1, 52)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (263, 92, 77, CAST(60.0000 AS Decimal(18, 4)), 10.0000, CAST(0x0000975100000000 AS DateTime), 1, 53)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (264, 95, 80, CAST(75.0000 AS Decimal(18, 4)), 3.0000, CAST(0x0000975100000000 AS DateTime), 1, 35)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (265, 90, 81, CAST(125.0000 AS Decimal(18, 4)), 2.0000, CAST(0x0000975100000000 AS DateTime), 1, 62)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (266, 96, 34, CAST(100.0000 AS Decimal(18, 4)), 10.0000, CAST(0x0000975100000000 AS DateTime), 1, 82)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (267, 97, 19, CAST(30.0000 AS Decimal(18, 4)), 7.0000, CAST(0x0000975100000000 AS DateTime), 1, 80)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (268, 98, 41, CAST(200.0000 AS Decimal(18, 4)), 7.0000, CAST(0x0000975100000000 AS DateTime), 1, 78)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (269, 99, 43, CAST(300.0000 AS Decimal(18, 4)), 34.0000, CAST(0x0000975100000000 AS DateTime), 1, 76)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (270, 100, 48, CAST(100.0000 AS Decimal(18, 4)), 10.0000, CAST(0x0000975100000000 AS DateTime), 1, 74)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (271, 101, 81, CAST(200.0000 AS Decimal(18, 4)), 2.0000, CAST(0x0000975100000000 AS DateTime), 1, 72)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (272, 102, 43, CAST(300.0000 AS Decimal(18, 4)), 34.0000, NULL, 0, NULL)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (273, 103, 19, CAST(10.0000 AS Decimal(18, 4)), 7.0000, CAST(0x000097A600000000 AS DateTime), 1, 111)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (274, 104, 41, CAST(50.0000 AS Decimal(18, 4)), 7.0000, CAST(0x0000979B00000000 AS DateTime), 1, 115)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (275, 105, 57, CAST(100.0000 AS Decimal(18, 4)), 15.0000, CAST(0x0000979A00000000 AS DateTime), 1, 100)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (276, 106, 72, CAST(50.0000 AS Decimal(18, 4)), 26.0000, CAST(0x0000979A00000000 AS DateTime), 1, 113)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (277, 107, 34, CAST(300.0000 AS Decimal(18, 4)), 10.0000, CAST(0x0000979A00000000 AS DateTime), 1, 107)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (278, 108, 8, CAST(25.0000 AS Decimal(18, 4)), 30.0000, CAST(0x0000979A00000000 AS DateTime), 1, 105)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (279, 109, 19, CAST(25.0000 AS Decimal(18, 4)), 7.0000, CAST(0x0000979A00000000 AS DateTime), 1, 109)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (280, 110, 43, CAST(250.0000 AS Decimal(18, 4)), 34.0000, CAST(0x0000979F00000000 AS DateTime), 1, 103)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (281, 90, 1, CAST(40.0000 AS Decimal(18, 4)), 14.0000, NULL, 0, NULL)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (282, 92, 19, CAST(20.0000 AS Decimal(18, 4)), 7.0000, NULL, 0, NULL)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (283, 111, 34, CAST(50.0000 AS Decimal(18, 4)), 10.0000, CAST(0x0000979900000000 AS DateTime), 1, 102)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (285, 91, 3, CAST(50.0000 AS Decimal(18, 4)), 8.0000, NULL, 0, NULL)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (286, 91, 4, CAST(40.0000 AS Decimal(18, 4)), 16.0000, NULL, 0, NULL)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (288, 140, 85, CAST(10.0000 AS Decimal(18, 4)), 9.0000, NULL, 0, NULL)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (289, 141, 6, CAST(10.0000 AS Decimal(18, 4)), 18.7500, NULL, 0, NULL)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (290, 142, 1, CAST(1.0000 AS Decimal(18, 4)), 13.5000, NULL, 0, NULL)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (292, 146, 20, CAST(40.0000 AS Decimal(18, 4)), 60.0000, NULL, 0, NULL)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (293, 146, 51, CAST(40.0000 AS Decimal(18, 4)), 39.0000, NULL, 0, NULL)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (294, 147, 40, CAST(120.0000 AS Decimal(18, 4)), 13.0000, NULL, 0, NULL)
INSERT [dbo].[L8-Purchase Order Details] ([ID], [Purchase Order ID], [Product ID], [Quantity], [Unit Cost], [Date Received], [Posted To Inventory], [Inventory ID]) VALUES (295, 148, 72, CAST(40.0000 AS Decimal(18, 4)), 26.0000, NULL, 0, NULL)
SET IDENTITY_INSERT [dbo].[L8-Purchase Order Details] OFF
/****** Object:  Table [dbo].[L8-Order Details]    Script Date: 10/26/2009 11:47:19 ******/
SET IDENTITY_INSERT [dbo].[L8-Order Details] ON
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (27, 30, 34, CAST(100.0000 AS Decimal(18, 4)), 14.0000, 0, 2, NULL, 96, 83)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (28, 30, 80, CAST(30.0000 AS Decimal(18, 4)), 3.5000, 0, 2, NULL, NULL, 63)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (29, 31, 7, CAST(10.0000 AS Decimal(18, 4)), 30.0000, 0, 2, NULL, NULL, 64)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (30, 31, 51, CAST(10.0000 AS Decimal(18, 4)), 53.0000, 0, 2, NULL, NULL, 65)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (31, 31, 80, CAST(10.0000 AS Decimal(18, 4)), 3.5000, 0, 2, NULL, NULL, 66)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (32, 32, 1, CAST(15.0000 AS Decimal(18, 4)), 18.0000, 0, 2, NULL, NULL, 67)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (33, 32, 43, CAST(20.0000 AS Decimal(18, 4)), 46.0000, 0, 2, NULL, NULL, 68)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (34, 33, 19, CAST(30.0000 AS Decimal(18, 4)), 9.2000, 0, 2, NULL, 97, 81)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (35, 34, 19, CAST(20.0000 AS Decimal(18, 4)), 9.2000, 0, 2, NULL, NULL, 69)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (36, 35, 48, CAST(10.0000 AS Decimal(18, 4)), 12.7500, 0, 2, NULL, NULL, 70)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (37, 36, 41, CAST(200.0000 AS Decimal(18, 4)), 9.6500, 0, 2, NULL, 98, 79)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (38, 37, 8, CAST(17.0000 AS Decimal(18, 4)), 40.0000, 0, 2, NULL, NULL, 71)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (39, 38, 43, CAST(300.0000 AS Decimal(18, 4)), 46.0000, 0, 2, NULL, 99, 77)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (40, 39, 48, CAST(100.0000 AS Decimal(18, 4)), 12.7500, 0, 2, NULL, 100, 75)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (41, 40, 81, CAST(200.0000 AS Decimal(18, 4)), 2.9900, 0, 2, NULL, 101, 73)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (42, 41, 43, CAST(300.0000 AS Decimal(18, 4)), 46.0000, 0, 1, NULL, 102, 104)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (43, 42, 6, CAST(10.0000 AS Decimal(18, 4)), 25.0000, 0, 2, NULL, NULL, 84)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (44, 42, 4, CAST(10.0000 AS Decimal(18, 4)), 22.0000, 0, 2, NULL, NULL, 85)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (45, 42, 19, CAST(10.0000 AS Decimal(18, 4)), 9.2000, 0, 2, NULL, 103, 110)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (46, 43, 80, CAST(20.0000 AS Decimal(18, 4)), 3.5000, 0, 1, NULL, NULL, 86)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (47, 43, 81, CAST(50.0000 AS Decimal(18, 4)), 2.9900, 0, 1, NULL, NULL, 87)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (48, 44, 1, CAST(25.0000 AS Decimal(18, 4)), 18.0000, 0, 1, NULL, NULL, 88)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (49, 44, 43, CAST(25.0000 AS Decimal(18, 4)), 46.0000, 0, 1, NULL, NULL, 89)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (50, 44, 81, CAST(25.0000 AS Decimal(18, 4)), 2.9900, 0, 1, NULL, NULL, 90)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (51, 45, 41, CAST(50.0000 AS Decimal(18, 4)), 9.6500, 0, 2, NULL, 104, 116)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (52, 45, 40, CAST(50.0000 AS Decimal(18, 4)), 18.4000, 0, 2, NULL, NULL, 91)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (53, 46, 57, CAST(100.0000 AS Decimal(18, 4)), 19.5000, 0, 2, NULL, 105, 101)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (54, 46, 72, CAST(50.0000 AS Decimal(18, 4)), 34.8000, 0, 2, NULL, 106, 114)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (55, 47, 34, CAST(300.0000 AS Decimal(18, 4)), 14.0000, 0, 2, NULL, 107, 108)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (56, 48, 8, CAST(25.0000 AS Decimal(18, 4)), 40.0000, 0, 2, NULL, 108, 106)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (57, 48, 19, CAST(25.0000 AS Decimal(18, 4)), 9.2000, 0, 2, NULL, 109, 112)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (59, 50, 21, CAST(20.0000 AS Decimal(18, 4)), 10.0000, 0, 2, NULL, NULL, 92)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (60, 51, 5, CAST(25.0000 AS Decimal(18, 4)), 21.3500, 0, 2, NULL, NULL, 93)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (61, 51, 41, CAST(30.0000 AS Decimal(18, 4)), 9.6500, 0, 2, NULL, NULL, 94)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (62, 51, 40, CAST(30.0000 AS Decimal(18, 4)), 18.4000, 0, 2, NULL, NULL, 95)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (66, 56, 48, CAST(10.0000 AS Decimal(18, 4)), 12.7500, 0, 2, NULL, 111, 99)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (67, 55, 34, CAST(87.0000 AS Decimal(18, 4)), 14.0000, 0, 2, NULL, NULL, 117)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (68, 79, 7, CAST(30.0000 AS Decimal(18, 4)), 30.0000, 0, 2, NULL, NULL, 119)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (69, 79, 51, CAST(30.0000 AS Decimal(18, 4)), 53.0000, 0, 2, NULL, NULL, 118)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (70, 78, 17, CAST(40.0000 AS Decimal(18, 4)), 39.0000, 0, 2, NULL, NULL, 120)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (71, 77, 6, CAST(90.0000 AS Decimal(18, 4)), 25.0000, 0, 2, NULL, NULL, 121)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (72, 76, 4, CAST(30.0000 AS Decimal(18, 4)), 22.0000, 0, 2, NULL, NULL, 122)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (73, 75, 48, CAST(40.0000 AS Decimal(18, 4)), 12.7500, 0, 2, NULL, NULL, 123)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (74, 74, 48, CAST(40.0000 AS Decimal(18, 4)), 12.7500, 0, 2, NULL, NULL, 124)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (75, 73, 41, CAST(10.0000 AS Decimal(18, 4)), 9.6500, 0, 2, NULL, NULL, 125)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (76, 72, 43, CAST(5.0000 AS Decimal(18, 4)), 46.0000, 0, 2, NULL, NULL, 126)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (77, 71, 40, CAST(40.0000 AS Decimal(18, 4)), 18.4000, 0, 2, NULL, NULL, 127)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (78, 70, 8, CAST(20.0000 AS Decimal(18, 4)), 40.0000, 0, 2, NULL, NULL, 128)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (79, 69, 80, CAST(15.0000 AS Decimal(18, 4)), 3.5000, 0, 2, NULL, NULL, 129)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (80, 67, 74, CAST(20.0000 AS Decimal(18, 4)), 10.0000, 0, 2, NULL, NULL, 130)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (81, 60, 72, CAST(40.0000 AS Decimal(18, 4)), 34.8000, 0, 2, NULL, NULL, 131)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (82, 63, 3, CAST(50.0000 AS Decimal(18, 4)), 10.0000, 0, 2, NULL, NULL, 132)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (83, 63, 8, CAST(3.0000 AS Decimal(18, 4)), 40.0000, 0, 2, NULL, NULL, 133)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (84, 58, 20, CAST(40.0000 AS Decimal(18, 4)), 81.0000, 0, 2, NULL, NULL, 134)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (85, 58, 52, CAST(40.0000 AS Decimal(18, 4)), 7.0000, 0, 2, NULL, NULL, 135)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (86, 80, 56, CAST(10.0000 AS Decimal(18, 4)), 38.0000, 0, 1, NULL, NULL, 136)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (90, 81, 81, CAST(0.0000 AS Decimal(18, 4)), 2.9900, 0, 5, NULL, NULL, NULL)
INSERT [dbo].[L8-Order Details] ([ID], [Order ID], [Product ID], [Quantity], [Unit Price], [Discount], [Status ID], [Date Allocated], [Purchase Order ID], [Inventory ID]) VALUES (91, 81, 56, CAST(0.0000 AS Decimal(18, 4)), 38.0000, 0, 0, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[L8-Order Details] OFF
/****** Object:  Table [dbo].[L8-Invoices]    Script Date: 10/26/2009 11:47:19 ******/
SET IDENTITY_INSERT [dbo].[L8-Invoices] ON
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (5, 31, CAST(0x0000978C010A23A4 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (6, 32, CAST(0x0000978C010A8AC4 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (7, 40, CAST(0x0000978E00B03E5C AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (8, 39, CAST(0x0000978E00B41C98 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (9, 38, CAST(0x0000978E00B46FCC AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (10, 37, CAST(0x0000978E00B49FD8 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (11, 36, CAST(0x0000978E00B4E880 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (12, 35, CAST(0x0000978E00B52FFC AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (13, 34, CAST(0x0000978E00B586B4 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (14, 33, CAST(0x0000978E00B5D538 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (15, 30, CAST(0x0000978E00B61930 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (16, 56, CAST(0x0000979800E408F4 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (17, 55, CAST(0x0000979900B6AA80 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (18, 51, CAST(0x0000979900B6FB5C AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (19, 50, CAST(0x0000979900B72DC0 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (20, 48, CAST(0x0000979900B75DCC AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (21, 47, CAST(0x0000979900B78928 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (22, 46, CAST(0x0000979900B7B22C AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (23, 45, CAST(0x0000979900B7DB30 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (24, 79, CAST(0x0000979900BF2278 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (25, 78, CAST(0x0000979900BF421C AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (26, 77, CAST(0x0000979900BF6094 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (27, 76, CAST(0x0000979900BF7A5C AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (28, 75, CAST(0x0000979900BFA93C AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (29, 74, CAST(0x0000979900BFC304 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (30, 73, CAST(0x0000979900BFDBA0 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (31, 72, CAST(0x0000979900BFF43C AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (32, 71, CAST(0x0000979900C01E6C AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (33, 70, CAST(0x0000979900C03A8C AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (34, 69, CAST(0x0000979900C05580 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (35, 67, CAST(0x0000979900C06F48 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (36, 42, CAST(0x0000979900C09978 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (37, 60, CAST(0x0000979900C0BDCC AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (38, 63, CAST(0x0000979900C0EDD8 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
INSERT [dbo].[L8-Invoices] ([Invoice ID], [Order ID], [Invoice Date], [Due Date], [Tax], [Shipping], [Amount Due]) VALUES (39, 58, CAST(0x0000979900C11F10 AS DateTime), NULL, 0.0000, 0.0000, 0.0000)
SET IDENTITY_INSERT [dbo].[L8-Invoices] OFF



ALTER TABLE [dbo].[L8-Employee Privileges]  WITH CHECK ADD  CONSTRAINT [Employee Privileges_FK00] FOREIGN KEY([Employee ID])
REFERENCES [dbo].[L8-Employees] ([ID])
GO
ALTER TABLE [dbo].[L8-Employee Privileges] CHECK CONSTRAINT [Employee Privileges_FK00]
GO
ALTER TABLE [dbo].[L8-Employee Privileges]  WITH CHECK ADD  CONSTRAINT [Employee Privileges_FK01] FOREIGN KEY([Privilege ID])
REFERENCES [dbo].[L8-Privileges] ([Privilege ID])
GO
ALTER TABLE [dbo].[L8-Employee Privileges] CHECK CONSTRAINT [Employee Privileges_FK01]
GO
ALTER TABLE [dbo].[L8-Inventory Transactions]  WITH CHECK ADD  CONSTRAINT [Inventory Transactions_FK00] FOREIGN KEY([Customer Order ID])
REFERENCES [dbo].[L8-Orders] ([Order ID])
GO
ALTER TABLE [dbo].[L8-Inventory Transactions] CHECK CONSTRAINT [Inventory Transactions_FK00]
GO
ALTER TABLE [dbo].[L8-Inventory Transactions]  WITH CHECK ADD  CONSTRAINT [Inventory Transactions_FK01] FOREIGN KEY([Product ID])
REFERENCES [dbo].[L8-Products] ([ID])
GO
ALTER TABLE [dbo].[L8-Inventory Transactions] CHECK CONSTRAINT [Inventory Transactions_FK01]
GO
ALTER TABLE [dbo].[L8-Inventory Transactions]  WITH CHECK ADD  CONSTRAINT [Inventory Transactions_FK02] FOREIGN KEY([Purchase Order ID])
REFERENCES [dbo].[L8-Purchase Orders] ([Purchase Order ID])
GO
ALTER TABLE [dbo].[L8-Inventory Transactions] CHECK CONSTRAINT [Inventory Transactions_FK02]
GO
ALTER TABLE [dbo].[L8-Inventory Transactions]  WITH CHECK ADD  CONSTRAINT [Inventory Transactions_FK03] FOREIGN KEY([Transaction Type])
REFERENCES [dbo].[L8-Inventory Transaction Types] ([ID])
GO
ALTER TABLE [dbo].[L8-Inventory Transactions] CHECK CONSTRAINT [Inventory Transactions_FK03]
GO
ALTER TABLE [dbo].[L8-Invoices]  WITH CHECK ADD  CONSTRAINT [Invoices_FK00] FOREIGN KEY([Order ID])
REFERENCES [dbo].[L8-Orders] ([Order ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[L8-Invoices] CHECK CONSTRAINT [Invoices_FK00]
GO
ALTER TABLE [dbo].[L8-Order Details]  WITH CHECK ADD  CONSTRAINT [Order Details_FK00] FOREIGN KEY([Order ID])
REFERENCES [dbo].[L8-Orders] ([Order ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[L8-Order Details] CHECK CONSTRAINT [Order Details_FK00]
GO
ALTER TABLE [dbo].[L8-Order Details]  WITH CHECK ADD  CONSTRAINT [Order Details_FK01] FOREIGN KEY([Status ID])
REFERENCES [dbo].[L8-Order Details Status] ([Status ID])
GO
ALTER TABLE [dbo].[L8-Order Details] CHECK CONSTRAINT [Order Details_FK01]
GO
ALTER TABLE [dbo].[L8-Order Details]  WITH CHECK ADD  CONSTRAINT [Order Details_FK02] FOREIGN KEY([Product ID])
REFERENCES [dbo].[L8-Products] ([ID])
GO
ALTER TABLE [dbo].[L8-Order Details] CHECK CONSTRAINT [Order Details_FK02]
GO
ALTER TABLE [dbo].[L8-Orders]  WITH CHECK ADD  CONSTRAINT [Orders_FK00] FOREIGN KEY([Customer ID])
REFERENCES [dbo].[L8-Customers] ([ID])
GO
ALTER TABLE [dbo].[L8-Orders] CHECK CONSTRAINT [Orders_FK00]
GO
ALTER TABLE [dbo].[L8-Orders]  WITH CHECK ADD  CONSTRAINT [Orders_FK01] FOREIGN KEY([Employee ID])
REFERENCES [dbo].[L8-Employees] ([ID])
GO
ALTER TABLE [dbo].[L8-Orders] CHECK CONSTRAINT [Orders_FK01]
GO
ALTER TABLE [dbo].[L8-Orders]  WITH CHECK ADD  CONSTRAINT [Orders_FK02] FOREIGN KEY([Status ID])
REFERENCES [dbo].[L8-Orders Status] ([Status ID])
GO
ALTER TABLE [dbo].[L8-Orders] CHECK CONSTRAINT [Orders_FK02]
GO
ALTER TABLE [dbo].[L8-Orders]  WITH CHECK ADD  CONSTRAINT [Orders_FK03] FOREIGN KEY([Shipper ID])
REFERENCES [dbo].[L8-Shippers] ([ID])
GO
ALTER TABLE [dbo].[L8-Orders] CHECK CONSTRAINT [Orders_FK03]
GO
ALTER TABLE [dbo].[L8-Orders]  WITH CHECK ADD  CONSTRAINT [Orders_FK04] FOREIGN KEY([Tax Status])
REFERENCES [dbo].[L8-Orders Tax Status] ([ID])
GO
ALTER TABLE [dbo].[L8-Orders] CHECK CONSTRAINT [Orders_FK04]
GO
ALTER TABLE [dbo].[L8-Purchase Order Details]  WITH CHECK ADD  CONSTRAINT [Purchase Order Details_FK00] FOREIGN KEY([Inventory ID])
REFERENCES [dbo].[L8-Inventory Transactions] ([Transaction ID])
GO
ALTER TABLE [dbo].[L8-Purchase Order Details] CHECK CONSTRAINT [Purchase Order Details_FK00]
GO
ALTER TABLE [dbo].[L8-Purchase Order Details]  WITH CHECK ADD  CONSTRAINT [Purchase Order Details_FK01] FOREIGN KEY([Product ID])
REFERENCES [dbo].[L8-Products] ([ID])
GO
ALTER TABLE [dbo].[L8-Purchase Order Details] CHECK CONSTRAINT [Purchase Order Details_FK01]
GO
ALTER TABLE [dbo].[L8-Purchase Order Details]  WITH CHECK ADD  CONSTRAINT [Purchase Order Details_FK02] FOREIGN KEY([Purchase Order ID])
REFERENCES [dbo].[L8-Purchase Orders] ([Purchase Order ID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[L8-Purchase Order Details] CHECK CONSTRAINT [Purchase Order Details_FK02]
GO
ALTER TABLE [dbo].[L8-Purchase Orders]  WITH CHECK ADD  CONSTRAINT [Purchase Orders_FK00] FOREIGN KEY([Created By])
REFERENCES [dbo].[L8-Employees] ([ID])
GO
ALTER TABLE [dbo].[L8-Purchase Orders] CHECK CONSTRAINT [Purchase Orders_FK00]
GO
ALTER TABLE [dbo].[L8-Purchase Orders]  WITH CHECK ADD  CONSTRAINT [Purchase Orders_FK01] FOREIGN KEY([Status ID])
REFERENCES [dbo].[L8-Purchase Order Status] ([Status ID])
GO
ALTER TABLE [dbo].[L8-Purchase Orders] CHECK CONSTRAINT [Purchase Orders_FK01]
GO
ALTER TABLE [dbo].[L8-Purchase Orders]  WITH CHECK ADD  CONSTRAINT [Purchase Orders_FK02] FOREIGN KEY([Supplier ID])
REFERENCES [dbo].[L8-Suppliers] ([ID])
GO
ALTER TABLE [dbo].[L8-Purchase Orders] CHECK CONSTRAINT [Purchase Orders_FK02]
GO