Tables [dbo].[SLX_ExportContracts]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapTrue
Row Count (~)0
Created1:00:45 AM Thursday, March 21, 2019
Last Modified1:00:45 AM Thursday, March 21, 2019
NameData TypeMax Length (Bytes)Allow Nulls
EquipmentNumbervarchar(30)30
True
SerialNumbervarchar(50)50
True
Modelvarchar(50)50
True
Equipmentidint4
True
Contractidint4
True
ContractNumbervarchar(35)35
True
ContractCodevarchar(15)15
True
ContractCodeDescvarchar(50)50
True
StartDatedatetime8
True
ExpDatedatetime8
True
ContractCustomeridint4
True
ContractBillToIdint4
True
ContractBranchIdint4
True
ContractBillToNamevarchar(128)128
True
ExpCopiesint4
True
AccumCopiesint4
True
AccumCopiesCurrentint4
True
PercentCompleteByCopiesdecimal(18,0)9
True
PercentCompleteByDatedecimal(18,0)9
True
CurrentAndActivebit1
True
Activebit1
True
BillCodevarchar(30)30
True
BillCodeDescvarchar(50)50
True
PONumbervarchar(50)50
True
Expiredbit1
True
EquipStartDatedatetime8
True
EquipRemoveDatedatetime8
True
EquipCustomerIdint4
True
EquipParentCustomerIdint4
True
Metertypevarchar(50)50
True
MeterRatedecimal(14,6)9
True
MeterCoveredCopiesint4
True
MeterCountint4
True
BaseRatemoney8
True
BaseBillingCyclevarchar(15)15
True
BaseNextBillingDatedatetime8
True
BaseLastBillingDatedatetime8
True
BaseSumIndividualbit1
True
OvgBillingCyclevarchar(15)15
True
OvgNextBillingDatedatetime8
True
OvgLastBillingDatedatetime8
True
MeterGroupidint4
True
CREATE TABLE [dbo].[SLX_ExportContracts]
(
[EquipmentNumber] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SerialNumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Model] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Equipmentid] [int] NULL,
[Contractid] [int] NULL,
[ContractNumber] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContractCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContractCodeDesc] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StartDate] [datetime] NULL,
[ExpDate] [datetime] NULL,
[ContractCustomerid] [int] NULL,
[ContractBillToId] [int] NULL,
[ContractBranchId] [int] NULL,
[ContractBillToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ExpCopies] [int] NULL,
[AccumCopies] [int] NULL,
[AccumCopiesCurrent] [int] NULL,
[PercentCompleteByCopies] [decimal] (18, 0) NULL,
[PercentCompleteByDate] [decimal] (18, 0) NULL,
[CurrentAndActive] [bit] NULL,
[Active] [bit] NULL,
[BillCode] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillCodeDesc] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PONumber] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Expired] [bit] NULL,
[EquipStartDate] [datetime] NULL,
[EquipRemoveDate] [datetime] NULL,
[EquipCustomerId] [int] NULL,
[EquipParentCustomerId] [int] NULL,
[Metertype] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MeterRate] [decimal] (14, 6) NULL,
[MeterCoveredCopies] [int] NULL,
[MeterCount] [int] NULL,
[BaseRate] [money] NULL,
[BaseBillingCycle] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BaseNextBillingDate] [datetime] NULL,
[BaseLastBillingDate] [datetime] NULL,
[BaseSumIndividual] [bit] NULL,
[OvgBillingCycle] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OvgNextBillingDate] [datetime] NULL,
[OvgLastBillingDate] [datetime] NULL,
[MeterGroupid] [int] NULL
) ON [PRIMARY]
GO