Tables [dbo].[SCContractMRIDetailExtended]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:13 AM Thursday, March 21, 2019
Last Modified12:59:13 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK_SCContractMRIDetailExtended: ContractMRIDetailIDContractMRIDetailIDint4
False
1 - 1
ContractMRISummaryIDint4
False
CodeIDint4
True
MetCodevarchar(10)10
False
MetDescvarchar(128)128
True
ContractNumbervarchar(35)35
True
CustomerNumbervarchar(32)32
True
CustomerNamevarchar(128)128
True
Contactvarchar(50)50
True
Phonevarchar(30)30
True
Billbit1
True
GroupInvoicesbit1
True
ContractCodeDescvarchar(50)50
True
BillCodeDescvarchar(50)50
True
StartDatedatetime8
True
ExpDatedatetime8
True
ExpCopiesint4
True
Reneweddatetime8
True
Activebit1
True
ContractStatusvarchar(32)32
True
PONumbervarchar(15)15
True
LeaseSchedulevarchar(20)20
True
UnearnedBalancemoney8
True
BaseRatemoney8
True
BaseBillingDatedatetime8
True
OvgNextBillingDatedatetime8
True
HasBaseBillingDatebit1
True
HasOvgNextBillingDatebit1
True
LastUpdatedatetime8
False
DateRangeFilterIDint4
False
DateRangeFilterDescvarchar(50)50
False
EquipmentIDint4
True
EquipmentNumbervarchar(35)35
True
SerialNumbervarchar(35)35
True
Modelvarchar(35)35
True
Makevarchar(35)35
True
TotalBaseRevenuemoney8
True
ContractBaseRevenuemoney8
True
EquipmentBaseRevenuemoney8
True
TotalMiscRevenuemoney8
True
ContractMiscRevenuemoney8
True
EquipmentMiscRevenuemoney8
True
TotalOverageRevenuemoney8
True
ContractOverageRevenuemoney8
True
EquipmentOverageRevenuemoney8
True
TotalPartsRevenuemoney8
True
ContractPartsRevenuemoney8
True
EquipmentPartsRevenuemoney8
True
TotalPartsCostmoney8
True
ContractPartsCostmoney8
True
EquipmentPartsCostmoney8
True
TotalOtherRevenuemoney8
True
ContractOtherRevenuemoney8
True
EquipmentOtherRevenuemoney8
True
TotalOtherCostmoney8
True
ContractOtherCostmoney8
True
EquipmentOtherCostmoney8
True
TotalSuppliesRevenuemoney8
True
ContractSuppliesRevenuemoney8
True
EquipmentSuppliesRevenuemoney8
True
TotalSuppliesCostmoney8
True
ContractSuppliesCostmoney8
True
EquipmentSuppliesCostmoney8
True
TotalLaborRevenuemoney8
True
ContractLaborRevenuemoney8
True
EquipmentLaborRevenuemoney8
True
TotalLaborCostmoney8
True
ContractLaborCostmoney8
True
EquipmentLaborCostmoney8
True
TotalTravelRevenuemoney8
True
ContractTravelRevenuemoney8
True
EquipmentTravelRevenuemoney8
True
TotalTravelCostmoney8
True
ContractTravelCostmoney8
True
EquipmentTravelCostmoney8
True
TotalTotalMeterUsagedecimal(18,4)9
True
ContractTotalMeterUsagedecimal(18,4)9
True
EquipmentTotalMeterUsagedecimal(18,4)9
True
TotalTotalBilledOveragesMeterUsagedecimal(18,4)9
True
ContractTotalBilledOveragesMeterUsagedecimal(18,4)9
True
EquipmentTotalBilledOveragesMeterUsagedecimal(18,4)9
True
TotalTotalBilledMeterUsagedecimal(18,4)9
True
ContractTotalBilledMeterUsagedecimal(18,4)9
True
EquipmentTotalBilledMeterUsagedecimal(18,4)9
True
TotalTotalCostmoney8
True
ContractTotalCostmoney8
True
EquipmentTotalCostmoney8
True
TotalTotalRevenuemoney8
True
ContractTotalRevenuemoney8
True
EquipmentTotalRevenuemoney8
True
TotalTotalMarginmoney8
True
ContractTotalMarginmoney8
True
EquipmentTotalMarginmoney8
True
TotalTotalMarginPercentagedecimal(22,4)13
True
ContractTotalMarginPercentagedecimal(22,4)13
True
EquipmentTotalMarginPercentagedecimal(22,4)13
True
Messagevarchar(50)50
True
BaseNextAccrualDatedatetime8
True
GLIDint4
True
AccountNumbervarchar(255)255
True
AccountNamevarchar(255)255
True
AccountTypevarchar(255)255
True
AccountClassvarchar(50)50
True
Sortint4
True
TypeBSvarchar(255)255
True
TransactionTypevarchar(255)255
True
Datedatetime8
True
Periodint4
True
JournalIDint4
True
Descriptionvarchar(255)255
True
DetailDescvarchar(255)255
True
Numbervarchar(255)255
True
CreateDatedatetime8
True
CreatorIDvarchar(255)255
True
Amountmoney8
True
EqSidevarchar(50)50
True
ALCvarchar(50)50
True
NIConsvarchar(50)50
True
DistinctItemCountint4
True
TotalItemCountint4
True
TotalItemYieldint4
True
TotalCountedCopiesint4
True
CopiesToUsageExcessint4
True
SONumbervarchar(15)15
True
Itemvarchar(255)255
True
ItemDescvarchar(255)255
True
UMvarchar(255)255
True
Quantitydecimal(18,6)9
True
Shippeddecimal(18,6)9
True
UnFulFilleddecimal(20,6)13
True
UnBilleddecimal(20,6)13
True
Pricemoney8
True
Discountdecimal(18,6)9
True
Canceleddecimal(18,6)9
True
Billeddecimal(18,6)9
True
BillToNumbervarchar(32)32
True
NewOrTerminatedvarchar(10)10
True
Activateddatetime8
True
Terminateddatetime8
True
BillCodevarchar(20)20
True
ContractCodevarchar(15)15
True
Accrualbit1
True
EquipmentCountint4
True
TerminationCodevarchar(15)15
True
TerminationCodeDescvarchar(50)50
True
TotalCoveredCopiesint4
True
TotalCopiesint4
True
TotalOverageBilledCopiesint4
True
TotalUnusedCoveredCopiesint4
True
RCOvarchar(2)2
True
Modulevarchar(24)24
True
TotalRevenuesmoney8
True
TotalCostsmoney8
True
GrossMarginmoney8
True
GrossMarginPercdecimal(16,4)9
True
DontShowMebit1
True
Revenuemoney8
True
Costmoney8
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCContractMRIDetailExtended: ContractMRIDetailIDPK_SCContractMRIDetailExtendedContractMRIDetailID
True
80
CREATE TABLE [dbo].[SCContractMRIDetailExtended]
(
[ContractMRIDetailID] [int] NOT NULL IDENTITY(1, 1),
[ContractMRISummaryID] [int] NOT NULL,
[CodeID] [int] NULL,
[MetCode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MetDesc] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContractNumber] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Contact] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Phone] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Bill] [bit] NULL,
[GroupInvoices] [bit] NULL,
[ContractCodeDesc] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillCodeDesc] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StartDate] [datetime] NULL,
[ExpDate] [datetime] NULL,
[ExpCopies] [int] NULL,
[Renewed] [datetime] NULL,
[Active] [bit] NULL,
[ContractStatus] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PONumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LeaseSchedule] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UnearnedBalance] [money] NULL,
[BaseRate] [money] NULL,
[BaseBillingDate] [datetime] NULL,
[OvgNextBillingDate] [datetime] NULL,
[HasBaseBillingDate] [bit] NULL,
[HasOvgNextBillingDate] [bit] NULL,
[LastUpdate] [datetime] NOT NULL,
[DateRangeFilterID] [int] NOT NULL,
[DateRangeFilterDesc] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[EquipmentID] [int] NULL,
[EquipmentNumber] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SerialNumber] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Model] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Make] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TotalBaseRevenue] [money] NULL,
[ContractBaseRevenue] [money] NULL,
[EquipmentBaseRevenue] [money] NULL,
[TotalMiscRevenue] [money] NULL,
[ContractMiscRevenue] [money] NULL,
[EquipmentMiscRevenue] [money] NULL,
[TotalOverageRevenue] [money] NULL,
[ContractOverageRevenue] [money] NULL,
[EquipmentOverageRevenue] [money] NULL,
[TotalPartsRevenue] [money] NULL,
[ContractPartsRevenue] [money] NULL,
[EquipmentPartsRevenue] [money] NULL,
[TotalPartsCost] [money] NULL,
[ContractPartsCost] [money] NULL,
[EquipmentPartsCost] [money] NULL,
[TotalOtherRevenue] [money] NULL,
[ContractOtherRevenue] [money] NULL,
[EquipmentOtherRevenue] [money] NULL,
[TotalOtherCost] [money] NULL,
[ContractOtherCost] [money] NULL,
[EquipmentOtherCost] [money] NULL,
[TotalSuppliesRevenue] [money] NULL,
[ContractSuppliesRevenue] [money] NULL,
[EquipmentSuppliesRevenue] [money] NULL,
[TotalSuppliesCost] [money] NULL,
[ContractSuppliesCost] [money] NULL,
[EquipmentSuppliesCost] [money] NULL,
[TotalLaborRevenue] [money] NULL,
[ContractLaborRevenue] [money] NULL,
[EquipmentLaborRevenue] [money] NULL,
[TotalLaborCost] [money] NULL,
[ContractLaborCost] [money] NULL,
[EquipmentLaborCost] [money] NULL,
[TotalTravelRevenue] [money] NULL,
[ContractTravelRevenue] [money] NULL,
[EquipmentTravelRevenue] [money] NULL,
[TotalTravelCost] [money] NULL,
[ContractTravelCost] [money] NULL,
[EquipmentTravelCost] [money] NULL,
[TotalTotalMeterUsage] [decimal] (18, 4) NULL,
[ContractTotalMeterUsage] [decimal] (18, 4) NULL,
[EquipmentTotalMeterUsage] [decimal] (18, 4) NULL,
[TotalTotalBilledOveragesMeterUsage] [decimal] (18, 4) NULL,
[ContractTotalBilledOveragesMeterUsage] [decimal] (18, 4) NULL,
[EquipmentTotalBilledOveragesMeterUsage] [decimal] (18, 4) NULL,
[TotalTotalBilledMeterUsage] [decimal] (18, 4) NULL,
[ContractTotalBilledMeterUsage] [decimal] (18, 4) NULL,
[EquipmentTotalBilledMeterUsage] [decimal] (18, 4) NULL,
[TotalTotalCost] [money] NULL,
[ContractTotalCost] [money] NULL,
[EquipmentTotalCost] [money] NULL,
[TotalTotalRevenue] [money] NULL,
[ContractTotalRevenue] [money] NULL,
[EquipmentTotalRevenue] [money] NULL,
[TotalTotalMargin] [money] NULL,
[ContractTotalMargin] [money] NULL,
[EquipmentTotalMargin] [money] NULL,
[TotalTotalMarginPercentage] [decimal] (22, 4) NULL,
[ContractTotalMarginPercentage] [decimal] (22, 4) NULL,
[EquipmentTotalMarginPercentage] [decimal] (22, 4) NULL,
[Message] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BaseNextAccrualDate] [datetime] NULL,
[GLID] [int] NULL,
[AccountNumber] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AccountClass] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Sort] [int] NULL,
[TypeBS] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TransactionType] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Date] [datetime] NULL,
[Period] [int] NULL,
[JournalID] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DetailDesc] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Number] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreateDate] [datetime] NULL,
[CreatorID] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Amount] [money] NULL,
[EqSide] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ALC] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NICons] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DistinctItemCount] [int] NULL,
[TotalItemCount] [int] NULL,
[TotalItemYield] [int] NULL,
[TotalCountedCopies] [int] NULL,
[CopiesToUsageExcess] [int] NULL,
[SONumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Item] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ItemDesc] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UM] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Quantity] [decimal] (18, 6) NULL,
[Shipped] [decimal] (18, 6) NULL,
[UnFulFilled] [decimal] (20, 6) NULL,
[UnBilled] [decimal] (20, 6) NULL,
[Price] [money] NULL,
[Discount] [decimal] (18, 6) NULL,
[Canceled] [decimal] (18, 6) NULL,
[Billed] [decimal] (18, 6) NULL,
[BillToNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NewOrTerminated] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Activated] [datetime] NULL,
[Terminated] [datetime] NULL,
[BillCode] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ContractCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Accrual] [bit] NULL,
[EquipmentCount] [int] NULL,
[TerminationCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TerminationCodeDesc] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TotalCoveredCopies] [int] NULL,
[TotalCopies] [int] NULL,
[TotalOverageBilledCopies] [int] NULL,
[TotalUnusedCoveredCopies] [int] NULL,
[RCO] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Module] [varchar] (24) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TotalRevenues] [money] NULL,
[TotalCosts] [money] NULL,
[GrossMargin] [money] NULL,
[GrossMarginPerc] [decimal] (16, 4) NULL,
[DontShowMe] [bit] NULL,
[Revenue] [money] NULL,
[Cost] [money] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractMRIDetailExtended] ADD CONSTRAINT [PK_SCContractMRIDetailExtended] PRIMARY KEY CLUSTERED  ([ContractMRIDetailID]) ON [PRIMARY]
GO