[AccountNumber] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_AccountNumber]  DEFAULT (''),
	[AccountTypeID] [int] NOT NULL CONSTRAINT [DF_Customer_AccountTypeID]  DEFAULT (1),
	[Address2] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_Address2]  DEFAULT (''),
	[AssessFinanceCharges] [bit] NOT NULL CONSTRAINT [DF_Customer_AssessFinanceCharges]  DEFAULT (0),
	[Company] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_Company]  DEFAULT (''),
	[Country] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_Country]  DEFAULT (''),
	[CustomDate1] [datetime] NULL,
	[CustomDate2] [datetime] NULL,
	[CustomDate3] [datetime] NULL,
	[CustomDate4] [datetime] NULL,
	[CustomDate5] [datetime] NULL,
	[CustomNumber1] [float] NOT NULL CONSTRAINT [DF_Customer_CustomNumber1]  DEFAULT (0),
	[CustomNumber2] [float] NOT NULL CONSTRAINT [DF_Customer_CustomNumber2]  DEFAULT (0),
	[CustomNumber3] [float] NOT NULL CONSTRAINT [DF_Customer_CustomNumber3]  DEFAULT (0),
	[CustomNumber4] [float] NOT NULL CONSTRAINT [DF_Customer_CustomNumber4]  DEFAULT (0),
	[CustomNumber5] [float] NOT NULL CONSTRAINT [DF_Customer_CustomNumber5]  DEFAULT (0),
	[CustomText1] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_CustomText1]  DEFAULT (''),
	[CustomText2] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_CustomText2]  DEFAULT (''),
	[CustomText3] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_CustomText3]  DEFAULT (''),
	[CustomText4] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_CustomText4]  DEFAULT (''),
	[CustomText5] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_CustomText5]  DEFAULT (''),
	[GlobalCustomer] [bit] NOT NULL CONSTRAINT [DF_Customer_GlobalCustomer]  DEFAULT (0),
	[HQID] [int] NOT NULL CONSTRAINT [DF_Customer_HQID]  DEFAULT (0),
	[LastStartingDate] [datetime] NULL,
	[LastClosingDate] [datetime] NULL,
	[LastUpdated] [datetime] NOT NULL CONSTRAINT [DF_Customer_LastUpdated]  DEFAULT (getdate()),
	[LimitPurchase] [bit] NOT NULL CONSTRAINT [DF_Customer_LimitPurchase]  DEFAULT (0),
	[LastClosingBalance] [money] NOT NULL CONSTRAINT [DF_Customer_PreviousBalance]  DEFAULT (0),
	[PrimaryShipToID] [int] NOT NULL CONSTRAINT [DF_Customer_PrimaryShipToID]  DEFAULT (0),
	[State] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_State]  DEFAULT (''),
	[StoreID] [int] NOT NULL CONSTRAINT [DF_Customer_StoreID]  DEFAULT (0),
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[LayawayCustomer] [bit] NOT NULL CONSTRAINT [DF_Customer_LayawayCustomer]  DEFAULT (0),
	[Employee] [bit] NOT NULL CONSTRAINT [DF_Customer_Employee]  DEFAULT (0),
	[FirstName] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_FirstName]  DEFAULT (''),
	[LastName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_LastName]  DEFAULT (''),
	[Address] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_Address]  DEFAULT (''),
	[City] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_City]  DEFAULT (''),
	[Zip] [nvarchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_Zip]  DEFAULT (''),
	[AccountBalance] [money] NOT NULL CONSTRAINT [DF_Customer_Balance]  DEFAULT (0),
	[CreditLimit] [money] NOT NULL CONSTRAINT [DF_Customer_CreditLimit]  DEFAULT (0),
	[TotalSales] [money] NOT NULL CONSTRAINT [DF_Customer_TotalSales]  DEFAULT (0),
	[AccountOpened] [datetime] NOT NULL CONSTRAINT [DF_Customer_AccountOpened]  DEFAULT (getdate()),
	[LastVisit] [datetime] NOT NULL CONSTRAINT [DF_Customer_LastVisit]  DEFAULT (getdate()),
	[TotalVisits] [int] NOT NULL CONSTRAINT [DF_Customer_TotalVisits]  DEFAULT (0),
	[TotalSavings] [money] NOT NULL CONSTRAINT [DF_Customer_TotalSavings]  DEFAULT (0),
	[CurrentDiscount] [real] NOT NULL CONSTRAINT [DF_Customer_CurrentDiscount]  DEFAULT (0),
	[PriceLevel] [smallint] NOT NULL CONSTRAINT [DF_Customer_PriceLevel]  DEFAULT (0),
	[TaxExempt] [bit] NOT NULL CONSTRAINT [DF_Customer_TaxExempt]  DEFAULT (0),
	[Notes] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF_Customer_Notes]  DEFAULT (''),
	[Title] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [Df_Customer_Title]  DEFAULT (''),
	[EmailAddress] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_EmailAddress]  DEFAULT (''),
	[DBTimeStamp] [timestamp] NULL,
	[TaxNumber] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_TaxNumber]  DEFAULT (''),
	[PictureName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Customer_PictureName]  DEFAULT (''),
	[DefaultShippingServiceID] [int] NOT NULL CONSTRAINT [DF_Customer_DefaultShippingServiceID]  DEFAULT (0),
	[PhoneNumber] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [Df_Customer_PhoneNumber]  DEFAULT (''),
	[FaxNumber] [nvarchar](30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [Df_Customer_FaxNumber]  DEFAULT (''),
	[CashierID] [int] NOT NULL CONSTRAINT [Df_Customer_CashierID]  DEFAULT (0),
	[SalesRepID] [int] NOT NULL CONSTRAINT [Df_Customer_SalesRepID]  DEFAULT (0)