CREATE TABLE [dbo].[SAConfigQuoteShipTos]
(
[ConfigQuoteShipToID] [int] NOT NULL IDENTITY(1, 1),
[ConfigQuoteDetailID] [int] NOT NULL,
[ConfigQuoteID] [int] NOT NULL,
[DefaultShipTo] [bit] NOT NULL CONSTRAINT [DF_SAConfigQuoteShipTos_DefaultShipTo] DEFAULT ((0)),
[CustomerShipToID] [int] NULL,
[ShipToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeliveryContact] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeliveryContactID] [int] NULL,
[DeliveryMethodID] [int] NULL CONSTRAINT [DF_SAConfigQuoteShipTos_DeliveryMethodID] DEFAULT ((1)),
[DeliveryTypeID] [int] NULL CONSTRAINT [DF_SAConfigQuoteShipTos_DeliveryTypeID] DEFAULT ((1)),
[Note] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AdvancedText] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipmentContact] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[EquipmentContactID] [int] NULL,
[DecisionContact] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DecisionContactID] [int] NULL,
[MeterContact] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MeterContactID] [int] NULL,
[EquipmentBillTo] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AdvancedOption1] [bit] NULL,
[AdvancedOption2] [bit] NULL,
[AdvancedOption3] [bit] NULL,
[EquipmentNote] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SAConfigQuoteShipTos_CreatorID] DEFAULT ('Admin'),
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SAConfigQuoteShipTos_UpdatorID] DEFAULT ('Admin'),
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SAConfigQuoteShipTos_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SAConfigQuoteShipTos_LastUpdate] DEFAULT (getdate()),
[ShipToCounty] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigQuoteShipTos] ADD CONSTRAINT [PK_SAConfigQuoteShipTos] PRIMARY KEY CLUSTERED ([ConfigQuoteShipToID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SAConfigQuoteShipTos] ADD CONSTRAINT [FK_SAConfigQuoteShipTos_ConfigQuoteID_SAConfigQuotes] FOREIGN KEY ([ConfigQuoteID]) REFERENCES [dbo].[SAConfigQuotes] ([ConfigQuoteID])
GO