Tables [dbo].[CSCommissionCalc]
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_CSCommissionCalc: CommissionCalcIDCommissionCalcIDint4
False
1 - 1
ExtID1char(12)12
True
ExtID2char(12)12
True
UserIDint4
True
ManagerIDint4
True
PaySlipDetailsIDint4
True
CommissiondetailsIDint4
True
SalesRepchar(24)24
True
InvoiceNumberchar(10)10
True
BoardPeriodint4
True
BoardAmountmoney8
False
CommissionAmountmoney8
False
CommissionTypechar(64)64
True
Descriptionchar(256)256
True
CreatorIDint4
False
CreateDatedatetime8
False
UpdatorIDint4
False
LastUpdatedatetime8
False
QuoteIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_CSCommissionCalc: CommissionCalcIDPK_CSCommissionCalcCommissionCalcID
True
80
CREATE TABLE [dbo].[CSCommissionCalc]
(
[CommissionCalcID] [int] NOT NULL IDENTITY(1, 1),
[ExtID1] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExtID2] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserID] [int] NULL,
[ManagerID] [int] NULL,
[PaySlipDetailsID] [int] NULL,
[CommissiondetailsID] [int] NULL,
[SalesRep] [char] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[InvoiceNumber] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BoardPeriod] [int] NULL,
[BoardAmount] [money] NOT NULL,
[CommissionAmount] [money] NOT NULL,
[CommissionType] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Description] [char] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreatorID] [int] NOT NULL,
[CreateDate] [datetime] NOT NULL,
[UpdatorID] [int] NOT NULL,
[LastUpdate] [datetime] NOT NULL,
[QuoteID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CSCommissionCalc] ADD CONSTRAINT [PK_CSCommissionCalc] PRIMARY KEY CLUSTERED  ([CommissionCalcID]) ON [PRIMARY]
GO