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