Tables [dbo].[ICConfigQuotes]
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
ConfigQuoteIDint4
False
1 - 1
hostidint4
True
extID1varchar(50)50
True
extID2varchar(50)50
True
itemidint4
True
modelvarchar(32)32
True
descriptionvarchar(128)128
True
qtyint4
True
activebit1
True
costmoney8
True
msrpmoney8
True
callIDint4
True
EquipmentIDint4
True
SONumberchar(10)10
True
SOIDint4
True
SODetailIDint4
True
NodeExpirationDatedatetime8
True
CreateDatedatetime8
True
CreateUserchar(8)8
True
LastUpdatedatetime8
True
UpdatorIDchar(8)8
True
ISHostbit1
True
confignodeidint4
True
configidint4
True
shiptoaddresschar(128)128
True
installtypechar(32)32
True
serialnumbervarchar(50)50
True
CREATE TABLE [dbo].[ICConfigQuotes]
(
[ConfigQuoteID] [int] NOT NULL IDENTITY(1, 1),
[hostid] [int] NULL,
[extID1] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[extID2] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[itemid] [int] NULL,
[model] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[description] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[qty] [int] NULL,
[active] [bit] NULL,
[cost] [money] NULL,
[msrp] [money] NULL,
[callID] [int] NULL,
[EquipmentID] [int] NULL,
[SONumber] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SOID] [int] NULL,
[SODetailID] [int] 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,
[ISHost] [bit] NULL,
[confignodeid] [int] NULL,
[configid] [int] NULL,
[shiptoaddress] [char] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[installtype] [char] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[serialnumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO