Tables [dbo].[SALeasing]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created12:59:01 AM Thursday, March 21, 2019
Last Modified1:06:26 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
idint4
False
1 - 1
namevarchar(50)50
False
companyvarchar(50)50
False
termtinyint1
False
factordecimal(10,5)9
False
purchaseOptionvarchar(50)50
False
ratedecimal(5,2)5
True
allowOverridesbit1
False
((0))
leaseLowmoney8
False
leaseHighmoney8
True
CREATE TABLE [dbo].[SALeasing]
(
[id] [int] NOT NULL IDENTITY(1, 1),
[name] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[company] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[term] [tinyint] NOT NULL,
[factor] [decimal] (10, 5) NOT NULL,
[purchaseOption] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[rate] [decimal] (5, 2) NULL,
[allowOverrides] [bit] NOT NULL CONSTRAINT [DF_SALeasing_allowOverrides] DEFAULT ((0)),
[leaseLow] [money] NOT NULL,
[leaseHigh] [money] NULL
) ON [PRIMARY]
GO