Tables [dbo].[cspayslips_temp]
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
PaySlipIDint4
False
1 - 1
Amountmoney8
True
Periodint4
True
SubPerioddatetime8
True
UserIDint4
True
Payablebit1
True
PayableDatedatetime8
True
Paidbit1
True
PaidDatedatetime8
True
PaidCheckNochar(10)10
True
CreatorIDint4
False
CreateDatedatetime8
False
UpdatorIDint4
False
LastUpdatedatetime8
False
CREATE TABLE [dbo].[cspayslips_temp]
(
[PaySlipID] [int] NOT NULL IDENTITY(1, 1),
[Amount] [money] NULL,
[Period] [int] NULL,
[SubPeriod] [datetime] NULL,
[UserID] [int] NULL,
[Payable] [bit] NULL,
[PayableDate] [datetime] NULL,
[Paid] [bit] NULL,
[PaidDate] [datetime] NULL,
[PaidCheckNo] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreatorID] [int] NOT NULL,
[CreateDate] [datetime] NOT NULL,
[UpdatorID] [int] NOT NULL,
[LastUpdate] [datetime] NOT NULL
) ON [PRIMARY]
GO