CREATE TABLE [dbo].[ARCustomers]
(
[CustomerID] [int] NOT NULL IDENTITY(1, 1),
[BillToID] [int] NULL,
[LocationID] [int] NULL,
[CustomerNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CustomerName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Attn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Address] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[City] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[State] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Zip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Country] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Longitude] [decimal] (18, 15) NULL,
[Latitude] [decimal] (18, 15) NULL,
[Phone1] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Phone2] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Fax] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Email] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[WebSite] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Prospect] [bit] NOT NULL,
[TermID] [int] NULL,
[ShipMethodID] [int] NULL,
[EIN] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[SalesRepID] [int] NULL,
[CreditLimit] [money] NOT NULL,
[PriceLevelID] [int] NOT NULL,
[DoFinCharges] [bit] NOT NULL,
[AdjustmentID] [int] NULL,
[TaxCodeID] [int] NOT NULL,
[TaxNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CustomerTypeID] [int] NULL,
[BlanketPO] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Hold] [bit] NOT NULL CONSTRAINT [DF_ARCustomers_Hold] DEFAULT ((0)),
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Invoices] [money] NOT NULL CONSTRAINT [DF_ARCustomers_Invoices] DEFAULT ((0)),
[Unapplied] [money] NOT NULL CONSTRAINT [DF_ARCustomers_Unapplied] DEFAULT ((0)),
[Orders] [money] NOT NULL CONSTRAINT [DF_ARCustomers_Orders] DEFAULT ((0)),
[Active] [bit] NOT NULL,
[ShipTo] [bit] NOT NULL CONSTRAINT [DF_ARCustomers_ShipTo] DEFAULT ((0)),
[BranchID] [int] NOT NULL,
[Locks] [int] NOT NULL CONSTRAINT [DF_ARCustomers_Locks] DEFAULT ((0)),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_ARCustomers_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ARCustomers_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[TechnicianID] [int] NULL,
[TerritoryID] [int] NULL,
[CompanyCustomer] [bit] NOT NULL CONSTRAINT [DF_ARCustomers_CompanyCustomer] DEFAULT ((0)),
[AllowAutoOnHoldUpdates] [bit] NOT NULL CONSTRAINT [DF_ARCustomers_AllowAutoOnHoldUpdates] DEFAULT ((1)),
[MailToID] [int] NULL,
[ShTrackingConfigID] [int] NULL,
[CustomPriceLevelID] [int] NULL,
[EnableCustomPricing] [bit] NOT NULL CONSTRAINT [DF_ARCustomers_EnableCustomPricing] DEFAULT ((0)),
[RequirePONum] [bit] NOT NULL CONSTRAINT [DF_ARCustomers_RequirePONum] DEFAULT ((0)),
[EquipmentContactID] [int] NULL,
[DecisionContactID] [int] NULL,
[AllowAutoMeterRequests] [bit] NOT NULL CONSTRAINT [DF_ARCustomers_AllowAutoMeterRequests] DEFAULT ((0)),
[ChargeMethodID] [int] NULL,
[DBFileHeaderID] [int] NOT NULL CONSTRAINT [DF_ARCustomers_DBFileHeaderID] DEFAULT ((1)),
[County] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARCustomers_County] DEFAULT (''),
[Taxable] [bit] NOT NULL CONSTRAINT [DF_ARCustomers_Taxable] DEFAULT ((0)),
[HideBillToOrdersEinfo] [bit] NOT NULL CONSTRAINT [DF_ARCustomers_HideBillToOrdersEinfo] DEFAULT ((0)),
[OnHoldCodeID] [int] NULL,
[TimeZoneCodeID] [int] NULL,
[OnSiteWarehouseID] [int] NULL,
[ARContactID] [int] NULL,
[ConsolidatedBillingEnabled] [bit] NOT NULL CONSTRAINT [DF_ARCustomers_ConsolidatedBillingEnabled] DEFAULT ((0)),
[ConsolidatedBillingMinBillingAmount] [money] NOT NULL CONSTRAINT [DF_ARCustomers_ConsolidatedBillingMinBillingAmount] DEFAULT ((0)),
[ConsolidatedBillingFlag] [int] NOT NULL CONSTRAINT [DF_ARCustomers_ConsolidatedBillingFlag] DEFAULT ((0)),
[ConsolidatedBillingDefaultMin] [int] NOT NULL CONSTRAINT [DF_ARCustomers_ConsolidatedBillingDefaultMin] DEFAULT ((0)),
[ConsolidatedBillingCycleID] [int] NULL,
[ConsolidatedBillingNextBillingDate] [datetime] NULL,
[InheritParentCustomPrices] [bit] NOT NULL CONSTRAINT [DF_ARCustomers_InheritParentCustomPrices] DEFAULT ((0)),
[SendStatements] [bit] NOT NULL CONSTRAINT [DF_ARCustomers_SendStatements] DEFAULT ((1)),
[UseBillToAddress] [bit] NOT NULL CONSTRAINT [DF_ARCustomers_UseBillToAddress] DEFAULT ((0)),
[BillToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARCustomers_BillToAttn] DEFAULT (''),
[BillToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARCustomers_BillToAddress] DEFAULT (''),
[BillToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARCustomers_BillToCity] DEFAULT (''),
[BillToCounty] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARCustomers_BillToCounty] DEFAULT (''),
[BillToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARCustomers_BillToState] DEFAULT (''),
[BillToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARCustomers_BillToZip] DEFAULT (''),
[BillToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARCustomers_BillToCountry] DEFAULT (''),
[UseMapAddress] [bit] NOT NULL CONSTRAINT [DF_ARCustomers_UseMapAddress] DEFAULT ((0)),
[MapAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARCustomers_MapAddress] DEFAULT (''),
[MapCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARCustomers_MapCity] DEFAULT (''),
[MapState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARCustomers_MapState] DEFAULT (''),
[MapZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARCustomers_MapZip] DEFAULT (''),
[MapCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARCustomers_MapCountry] DEFAULT (''),
[Miles] [decimal] (16, 4) NOT NULL CONSTRAINT [DF_ARCustomers_Miles] DEFAULT ((0)),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_ARCustomers_NoteFlag] DEFAULT ((0)),
[WarnOnPODuplicate] [bit] NOT NULL CONSTRAINT [DF_ARCustomers_WarnOnPODuplicate] DEFAULT ((0)),
[MeterContactID] [int] NULL,
[ShowInAllBranches] [bit] NOT NULL CONSTRAINT [DF_ARCustomers_ShowInAllBranches] DEFAULT ((0)),
[InvoiceMethod] [tinyint] NOT NULL CONSTRAINT [DF_ARCustomers_InvoiceMethod] DEFAULT ((1)),
[ARRepID] [int] NULL,
[NoteCount] [int] NOT NULL CONSTRAINT [DF_ARCustomers_NoteCount] DEFAULT ((0)),
[EquipmentShipToContactID] [int] NULL,
[TaxExemptCodeID] [int] NULL,
[SLACodeID] [int] NULL,
[WebCustomLinkID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [PK_ARCustomers] PRIMARY KEY CLUSTERED ([CustomerID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARCustomers] WITH NOCHECK ADD CONSTRAINT [FK_ARCustomers_AdjustmentID_SCAdjustment] FOREIGN KEY ([AdjustmentID]) REFERENCES [dbo].[SCAdjustment] ([AdjustmentID])
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [FK_ARCustomers_ARContactID_CMContacts] FOREIGN KEY ([ARContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [FK_ARCustomers_ARRepID_SHAgents] FOREIGN KEY ([ARRepID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO
ALTER TABLE [dbo].[ARCustomers] WITH NOCHECK ADD CONSTRAINT [FK_ARCustomers_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [FK_ARCustomers_ChargeMethodID_ARChargeMethods] FOREIGN KEY ([ChargeMethodID]) REFERENCES [dbo].[ARChargeMethods] ([ChargeMethodID])
GO
ALTER TABLE [dbo].[ARCustomers] WITH NOCHECK ADD CONSTRAINT [FK_ARCustomers_CustomerTypeID_ARCustomerTypes] FOREIGN KEY ([CustomerTypeID]) REFERENCES [dbo].[ARCustomerTypes] ([CustomerTypeID])
GO
ALTER TABLE [dbo].[ARCustomers] WITH NOCHECK ADD CONSTRAINT [FK_ARCustomers_CustomPriceLevelID_ARPriceLevels] FOREIGN KEY ([CustomPriceLevelID]) REFERENCES [dbo].[ARPriceLevels] ([PriceLevelID])
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [FK_ARCustomers_DBFileHeaderID_DBFileHeader] FOREIGN KEY ([DBFileHeaderID]) REFERENCES [dbo].[DBFileHeader] ([DBFileHeaderID])
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [FK_ARCustomers_DecisionContactID_CMContacts] FOREIGN KEY ([DecisionContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [FK_ARCustomers_EquipmentContactID_CMContacts] FOREIGN KEY ([EquipmentContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [FK_ARCustomers_EquipmentShipToContactID_CMContacts] FOREIGN KEY ([EquipmentShipToContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [FK_ARCustomers_InvoiceMethod_SHDocSendMethods] FOREIGN KEY ([InvoiceMethod]) REFERENCES [dbo].[SHDocSendMethods] ([DocSendMethodID])
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [FK_ARCustomers_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ARCustomers] WITH NOCHECK ADD CONSTRAINT [FK_ARCustomers_MailToID_ARCustomers] FOREIGN KEY ([MailToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [FK_ARCustomers_MeterContactID_CMContacts] FOREIGN KEY ([MeterContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [FK_ARCustomers_NoteID_ARCustomerNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[ARCustomerNotes] ([NoteID])
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [FK_ARCustomers_OnHoldCodeID_SHOnHoldCodes] FOREIGN KEY ([OnHoldCodeID]) REFERENCES [dbo].[ShOnHoldCodes] ([OnHoldCodeID])
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [FK_ARCustomers_OnSiteWarehouseID_ICWarehouses] FOREIGN KEY ([OnSiteWarehouseID]) REFERENCES [dbo].[ICWarehouses] ([WarehouseID])
GO
ALTER TABLE [dbo].[ARCustomers] WITH NOCHECK ADD CONSTRAINT [FK_ARCustomers_PriceLevelID_ARPriceLevels] FOREIGN KEY ([PriceLevelID]) REFERENCES [dbo].[ARPriceLevels] ([PriceLevelID])
GO
ALTER TABLE [dbo].[ARCustomers] WITH NOCHECK ADD CONSTRAINT [FK_ARCustomers_SalesRepID_ARSalesReps] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ARSalesReps] ([SalesRepID])
GO
ALTER TABLE [dbo].[ARCustomers] WITH NOCHECK ADD CONSTRAINT [FK_ARCustomers_ShipMethodID_ShShipMethods] FOREIGN KEY ([ShipMethodID]) REFERENCES [dbo].[ShShipMethods] ([ShipMethodID])
GO
ALTER TABLE [dbo].[ARCustomers] WITH NOCHECK ADD CONSTRAINT [FK_ARCustomers_ShTrackingConfigID_ShTrackingConfigs] FOREIGN KEY ([ShTrackingConfigID]) REFERENCES [dbo].[ShTrackingConfigs] ([ShTrackingConfigID])
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [FK_ARCustomers_SLACodeID_SCSLACodes] FOREIGN KEY ([SLACodeID]) REFERENCES [dbo].[SCSLACodes] ([SLACodeID])
GO
ALTER TABLE [dbo].[ARCustomers] WITH NOCHECK ADD CONSTRAINT [FK_ARCustomers_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [FK_ARCustomers_TaxExemptCodeID_SHTaxExemptCodes] FOREIGN KEY ([TaxExemptCodeID]) REFERENCES [dbo].[SHTaxExemptCodes] ([TaxExemptCodeID])
GO
ALTER TABLE [dbo].[ARCustomers] WITH NOCHECK ADD CONSTRAINT [FK_ARCustomers_TechnicianID_SCTechnicians] FOREIGN KEY ([TechnicianID]) REFERENCES [dbo].[SCTechnicians] ([TechnicianID])
GO
ALTER TABLE [dbo].[ARCustomers] WITH NOCHECK ADD CONSTRAINT [FK_ARCustomers_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO
ALTER TABLE [dbo].[ARCustomers] WITH NOCHECK ADD CONSTRAINT [FK_ARCustomers_TerritoryID_SCTerritories] FOREIGN KEY ([TerritoryID]) REFERENCES [dbo].[SCTerritories] ([TerritoryID])
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [FK_ARCustomers_TimeZoneCodeID_SHTimeZoneCodes] FOREIGN KEY ([TimeZoneCodeID]) REFERENCES [dbo].[SHTimeZoneCodes] ([TimeZoneCodeID])
GO
ALTER TABLE [dbo].[ARCustomers] ADD CONSTRAINT [FK_ARCustomers_WebCustomLinkID_WebCustomLinks] FOREIGN KEY ([WebCustomLinkID]) REFERENCES [dbo].[WebCustomLinks] ([WebCustomLinkID])
GO