Tables [dbo].[ICConfigQuoteDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:57:26 AM Thursday, March 21, 2019
Last Modified12:57:26 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsIdentity
ConfigQuoteDetailsIDint4
False
1 - 1
ConfigQuoteIDint4
False
commentsvarchar(256)256
True
requesteddeliverdatedatetime8
True
submitdatedatetime8
True
businesstypeint4
True
ShipViavarchar(50)50
True
installtypevarchar(50)50
True
ShipToAddressvarchar(64)64
True
ShipToCityvarchar(32)32
True
ShipToStatevarchar(16)16
True
ShipToZipvarchar(16)16
True
ShipToCountryvarchar(16)16
True
BillToAddressvarchar(64)64
True
BillToCityvarchar(32)32
True
BillToStatevarchar(16)16
True
BillToZipvarchar(16)16
True
BillToCountryvarchar(16)16
True
DeliveryContactvarchar(64)64
True
DeliveryPhonevarchar(30)30
True
DeliveryEMailvarchar(50)50
True
MeterContactvarchar(64)64
True
MeterPhonevarchar(30)30
True
MeterEMailvarchar(50)50
True
ConnectedContactvarchar(64)64
True
ConnectedPhonevarchar(30)30
True
ConnectedEMailvarchar(50)50
True
DocMGTContactvarchar(64)64
True
DocMGTPhonevarchar(30)30
True
DocMGTEMailvarchar(50)50
True
ISStairsbit1
True
ISPowerbit1
True
ISResidentialbit1
True
NodeExpirationDatedatetime8
True
CreateDatedatetime8
True
CreateUserchar(8)8
True
LastUpdatedatetime8
True
UpdatorIDchar(8)8
True
CustomerIDint4
True
LocationIDint4
True
BilltoIDint4
True
CREATE TABLE [dbo].[ICConfigQuoteDetails]
(
[ConfigQuoteDetailsID] [int] NOT NULL IDENTITY(1, 1),
[ConfigQuoteID] [int] NOT NULL,
[comments] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[requesteddeliverdate] [datetime] NULL,
[submitdate] [datetime] NULL,
[businesstype] [int] NULL,
[ShipVia] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[installtype] [varchar] (50) 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,
[BillToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeliveryContact] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeliveryPhone] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DeliveryEMail] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MeterContact] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MeterPhone] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MeterEMail] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ConnectedContact] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ConnectedPhone] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ConnectedEMail] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DocMGTContact] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DocMGTPhone] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DocMGTEMail] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ISStairs] [bit] NULL,
[ISPower] [bit] NULL,
[ISResidential] [bit] NULL,
[NodeExpirationDate] [datetime] NULL,
[CreateDate] [datetime] NULL,
[CreateUser] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LastUpdate] [datetime] NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerID] [int] NULL,
[LocationID] [int] NULL,
[BilltoID] [int] NULL
) ON [PRIMARY]
GO