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