Tables [dbo].[CTCommissionPayablesHistory]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:57:09 AM Thursday, March 21, 2019
Last Modified1:10:36 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_CTCommissionPayablesHistory: HistoryIDHistoryIDint4
False
1 - 1
Foreign Keys FK_CTCommissionPayablesHistory_PayableID_CTCommissionPayables: [dbo].[CTCommissionPayables].PayableIDPayableIDint4
False
StateIDint4
False
ActualPeriodint4
False
BaseDataIDint4
True
CommissionPeriodint4
False
InvoiceIDint4
True
SourceID1int4
True
SourceID2int4
True
CommissionTypeIDint4
True
SalesRepIDint4
True
RateIDint4
True
PayableTypeIDint4
False
CommissionCategoryIDint4
False
Descriptionvarchar(255)255
False
PrimaryRatedecimal(18,6)9
True
BaseSecondaryRatedecimal(18,6)9
True
SecondaryRatedecimal(18,6)9
True
PayableAmountmoney8
True
UserEnteredbit1
False
RuleIDint4
True
Activebit1
False
CreatorIDchar(8)8
False
UpdaterIDchar(8)8
False
CreateDatedatetime8
False
LastUpdatedatetime8
False
timestamptimestamp8
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_CTCommissionPayablesHistory: HistoryIDPK_CTCommissionPayablesHistoryHistoryID
True
80
NameColumns
FK_CTCommissionPayablesHistory_PayableID_CTCommissionPayablesPayableID->[dbo].[CTCommissionPayables].[PayableID]
CREATE TABLE [dbo].[CTCommissionPayablesHistory]
(
[HistoryID] [int] NOT NULL IDENTITY(1, 1),
[PayableID] [int] NOT NULL,
[StateID] [int] NOT NULL,
[ActualPeriod] [int] NOT NULL,
[BaseDataID] [int] NULL,
[CommissionPeriod] [int] NOT NULL,
[InvoiceID] [int] NULL,
[SourceID1] [int] NULL,
[SourceID2] [int] NULL,
[CommissionTypeID] [int] NULL,
[SalesRepID] [int] NULL,
[RateID] [int] NULL,
[PayableTypeID] [int] NOT NULL,
[CommissionCategoryID] [int] NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PrimaryRate] [decimal] (18, 6) NULL,
[BaseSecondaryRate] [decimal] (18, 6) NULL,
[SecondaryRate] [decimal] (18, 6) NULL,
[PayableAmount] [money] NULL,
[UserEntered] [bit] NOT NULL,
[RuleID] [int] NULL,
[Active] [bit] NOT NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdaterID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL,
[LastUpdate] [datetime] NOT NULL,
[timestamp] [timestamp] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CTCommissionPayablesHistory] ADD CONSTRAINT [PK_CTCommissionPayablesHistory] PRIMARY KEY CLUSTERED  ([HistoryID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CTCommissionPayablesHistory] ADD CONSTRAINT [FK_CTCommissionPayablesHistory_PayableID_CTCommissionPayables] FOREIGN KEY ([PayableID]) REFERENCES [dbo].[CTCommissionPayables] ([PayableID])
GO