Tables [dbo].[ARSalesRepQuotas]
PropertyValue
HeapTrue
Row Count (~)0
Created12:57:01 AM Thursday, March 21, 2019
Last Modified1:01:47 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
AgentIDint4
False
MgrIDint4
True
Monthsmallint2
False
Yearsmallint2
False
SVCAmountmoney8
False
HWAmountmoney8
False
SUPAmountmoney8
False
OTHAmountmoney8
False
ReportPeriodint4
True
PeriodLockedbit1
True
((0))
SRQuotaIDbigint8
False
1 - 1
CREATE TABLE [dbo].[ARSalesRepQuotas]
(
[AgentID] [int] NOT NULL,
[MgrID] [int] NULL,
[Month] [smallint] NOT NULL,
[Year] [smallint] NOT NULL,
[SVCAmount] [money] NOT NULL,
[HWAmount] [money] NOT NULL,
[SUPAmount] [money] NOT NULL,
[OTHAmount] [money] NOT NULL,
[ReportPeriod] [int] NULL,
[PeriodLocked] [bit] NULL CONSTRAINT [DF_ARSalesRepQuotas_PeriodLocked] DEFAULT ((0)),
[SRQuotaID] [bigint] NOT NULL IDENTITY(1, 1)
) ON [PRIMARY]
GO