Tables [dbo].[CSCommissions]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:57:07 AM Thursday, March 21, 2019
Last Modified12:57:07 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_CSCommissions: CommissionIDCommissionIDint4
False
1 - 1
CommissionTypeIDint4
False
SalesRepIDint4
False
ManagerIDint4
True
SalesRepchar(64)64
False
Managerchar(64)64
True
BoardPeriodchar(24)24
False
InvoiceIDint4
True
SOIDint4
True
InvoiceNumberchar(24)24
True
InvoiceDatedatetime8
True
SONumberchar(24)24
True
CustomerIDint4
True
Customerchar(64)64
True
Categorychar(64)64
False
Descriptionchar(256)256
True
BoardAmountmoney8
True
CommissionAmountmoney8
True
PaySlipIDint4
True
CreatorIDchar(10)10
True
UpdatorIDchar(10)10
True
CreateDatedatetime8
True
LastUpdatedatetime8
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_CSCommissions: CommissionIDPK_CSCommissionsCommissionID
True
80
CREATE TABLE [dbo].[CSCommissions]
(
[CommissionID] [int] NOT NULL IDENTITY(1, 1),
[CommissionTypeID] [int] NOT NULL,
[SalesRepID] [int] NOT NULL,
[ManagerID] [int] NULL,
[SalesRep] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Manager] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BoardPeriod] [char] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[InvoiceID] [int] NULL,
[SOID] [int] NULL,
[InvoiceNumber] [char] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InvoiceDate] [datetime] NULL,
[SONumber] [char] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerID] [int] NULL,
[Customer] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Category] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [char] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BoardAmount] [money] NULL,
[CommissionAmount] [money] NULL,
[PaySlipID] [int] NULL,
[CreatorID] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UpdatorID] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreateDate] [datetime] NULL,
[LastUpdate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CSCommissions] ADD CONSTRAINT [PK_CSCommissions] PRIMARY KEY CLUSTERED  ([CommissionID]) ON [PRIMARY]
GO