Tables [dbo].[SAConfigQuoteShipTos]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:58:58 AM Thursday, March 21, 2019
Last Modified1:14:14 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_SAConfigQuoteShipTos: ConfigQuoteShipToIDConfigQuoteShipToIDint4
False
1 - 1
ConfigQuoteDetailIDint4
False
Foreign Keys FK_SAConfigQuoteShipTos_ConfigQuoteID_SAConfigQuotes: [dbo].[SAConfigQuotes].ConfigQuoteIDConfigQuoteIDint4
False
DefaultShipTobit1
False
((0))
CustomerShipToIDint4
True
ShipToNamevarchar(128)128
True
ShipToAttnvarchar(64)64
True
ShipToAddressvarchar(64)64
True
ShipToCityvarchar(32)32
True
ShipToStatevarchar(16)16
True
ShipToZipvarchar(16)16
True
ShipToCountryvarchar(16)16
True
DeliveryContactvarchar(255)255
True
DeliveryContactIDint4
True
DeliveryMethodIDint4
True
((1))
DeliveryTypeIDint4
True
((1))
Notevarchar(1024)1024
True
AdvancedTextvarchar(32)32
True
EquipmentContactvarchar(255)255
True
EquipmentContactIDint4
True
DecisionContactvarchar(255)255
True
DecisionContactIDint4
True
MeterContactvarchar(255)255
True
MeterContactIDint4
True
EquipmentBillTovarchar(255)255
True
AdvancedOption1bit1
True
AdvancedOption2bit1
True
AdvancedOption3bit1
True
EquipmentNotevarchar(1024)1024
True
CreatorIDchar(8)8
False
('Admin')
UpdatorIDchar(8)8
False
('Admin')
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
ShipToCountyvarchar(32)32
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SAConfigQuoteShipTos: ConfigQuoteShipToIDPK_SAConfigQuoteShipTosConfigQuoteShipToID
True
80
NameColumns
FK_SAConfigQuoteShipTos_ConfigQuoteID_SAConfigQuotesConfigQuoteID->[dbo].[SAConfigQuotes].[ConfigQuoteID]
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