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