Tables [dbo].[cspayslipdetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:57:08 AM Thursday, March 21, 2019
Last Modified12:57:08 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsIdentity
PaySlipDetailsIDint4
False
1 - 1
PaySlipIDint4
True
ExtID1char(12)12
True
ExtID2char(12)12
True
SOIDint4
True
UserIDint4
True
ManagerIDint4
True
SalesRepchar(24)24
True
Periodint4
True
CommissionRateint4
True
InvoiceNumberchar(10)10
True
BoardPeriodint4
True
BoardDatedatetime8
True
BoardAmountmoney8
True
CommissionAmountmoney8
True
CommissionTypechar(64)64
True
TotalCmoney8
True
TotalBmoney8
True
Duemoney8
True
Descriptionchar(256)256
True
CreatorIDint4
False
CreateDatedatetime8
False
UpdatorIDint4
False
LastUpdatedatetime8
False
QuoteIDint4
True
CREATE TABLE [dbo].[cspayslipdetails]
(
[PaySlipDetailsID] [int] NOT NULL IDENTITY(1, 1),
[PaySlipID] [int] NULL,
[ExtID1] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExtID2] [char] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SOID] [int] NULL,
[UserID] [int] NULL,
[ManagerID] [int] NULL,
[SalesRep] [char] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Period] [int] NULL,
[CommissionRate] [int] NULL,
[InvoiceNumber] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BoardPeriod] [int] NULL,
[BoardDate] [datetime] NULL,
[BoardAmount] [money] NULL,
[CommissionAmount] [money] NULL,
[CommissionType] [char] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TotalC] [money] NULL,
[TotalB] [money] NULL,
[Due] [money] 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