Tables [dbo].[SHAgentDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created1:00:40 AM Thursday, March 21, 2019
Last Modified1:00:40 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsIdentity
AgentDetailIDint4
False
1 - 1
AgentIDint4
False
HireDatedatetime8
False
Terminateddatetime8
True
TerminationIDint4
True
Descriptionvarchar(255)255
False
CreateDatedatetime8
False
LastUpdatedatetime8
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
timestamptimestamp8
True
ManagerIDint4
True
Titlevarchar(50)50
True
ClassIDint4
False
AllocateServicedecimal(16,5)9
False
AllocateSalesdecimal(16,5)9
False
AllocateSupplydecimal(16,5)9
False
AllocateAdmindecimal(16,5)9
False
AllocateOtherdecimal(16,5)9
False
CREATE TABLE [dbo].[SHAgentDetails]
(
[AgentDetailID] [int] NOT NULL IDENTITY(1, 1),
[AgentID] [int] NOT NULL,
[HireDate] [datetime] NOT NULL,
[Terminated] [datetime] NULL,
[TerminationID] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL,
[LastUpdate] [datetime] NOT NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[timestamp] [timestamp] NULL,
[ManagerID] [int] NULL,
[Title] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ClassID] [int] NOT NULL,
[AllocateService] [decimal] (16, 5) NOT NULL,
[AllocateSales] [decimal] (16, 5) NOT NULL,
[AllocateSupply] [decimal] (16, 5) NOT NULL,
[AllocateAdmin] [decimal] (16, 5) NOT NULL,
[AllocateOther] [decimal] (16, 5) NOT NULL
) ON [PRIMARY]
GO