CREATE TABLE [dbo].[SCContractDetails]
(
[ContractID] [int] NOT NULL,
[EquipmentID] [int] NULL,
[BaseRate] [money] NULL,
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BillCodeID] [int] NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SCContractDetails_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCContractDetails_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[UseContractLease] [bit] NOT NULL CONSTRAINT [DF_SCContractDetails_UseContractLease] DEFAULT ((0)),
[ContractDetailID] [int] NOT NULL IDENTITY(1, 1),
[StartMeterReadingGroupID] [int] NULL,
[StartDate] [datetime] NULL,
[EndDate] [datetime] NULL,
[StartMeterReadingDate] [datetime] NULL,
[EndMeterReadingDate] [datetime] NULL,
[BaseBilledThruDate] [datetime] NULL,
[OverageBilledThruDate] [datetime] NULL,
[BaseAccruedThruDate] [datetime] NULL,
[ProrateStart] [bit] NOT NULL CONSTRAINT [DF_SCContractDetails_ProrateStart] DEFAULT ((0)),
[ProrateStartAmount] [money] NOT NULL CONSTRAINT [DF_SCContractDetails_ProrateStartAmount] DEFAULT ((0)),
[ProrateStartBillNow] [bit] NOT NULL CONSTRAINT [DF_SCContractDetails_ProrateStartBillNow] DEFAULT ((0)),
[ProrateEnd] [bit] NOT NULL CONSTRAINT [DF_SCContractDetails_ProrateEnd] DEFAULT ((0)),
[ProrateEndAmount] [money] NOT NULL CONSTRAINT [DF_SCContractDetails_ProrateEndAmount] DEFAULT ((0)),
[ProrateEndBillNow] [bit] NOT NULL CONSTRAINT [DF_SCContractDetails_ProrateEndBillNow] DEFAULT ((0)),
[EndMeterReadingGroupID] [int] NULL,
[LocationID] [int] NOT NULL,
[SyncLocationAddress] [bit] NOT NULL CONSTRAINT [DF_SCContractDetails_SyncLocationAddress] DEFAULT ((0)),
[Address] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContractDetails_Address] DEFAULT (''),
[City] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContractDetails_City] DEFAULT (''),
[State] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContractDetails_State] DEFAULT (''),
[Zip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContractDetails_Zip] DEFAULT (''),
[Country] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContractDetails_Country] DEFAULT (''),
[NextBaseIncreaseDate] [datetime] NULL,
[NextBaseScheduleDetailID] [int] NULL,
[UnEarnedBalance] [money] NOT NULL CONSTRAINT [DF_SCContractDetails_UnEarnedBalance] DEFAULT ((0)),
[ProrateStartAutoCalc] [bit] NOT NULL CONSTRAINT [DF_SCContractDetails_ProrateStartAutoCalc] DEFAULT ((1)),
[ProrateEndAutoCalc] [bit] NOT NULL CONSTRAINT [DF_SCContractDetails_ProrateEndAutoCalc] DEFAULT ((1)),
[BaseRateScheduleStartDateType] [int] NULL,
[BaseRateScheduleStartDate] [datetime] NULL,
[BaseRateScheduleIsRenewalType] [bit] NULL CONSTRAINT [DF_SCContractDetails_BaseRateScheduleIsRenewalType] DEFAULT ((0)),
[TaxCodeID] [int] NULL,
[TerminationCodeID] [int] NULL,
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_SCContractDetails_NoteFlag] DEFAULT ((0)),
[Quantity] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCContractDetails_Quantity] DEFAULT ((1)),
[UnitBaseRate] [money] NOT NULL CONSTRAINT [DF_SCContractDetails_UnitBaseRate] DEFAULT ((0)),
[BaseDistributionCodeID] [int] NULL,
[NoteCount] [int] NOT NULL CONSTRAINT [DF_SCContractDetails_NoteCount] DEFAULT ((0)),
[DivisionID] [int] NOT NULL,
[BranchID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[LeaseBalanceSheetGroupID] [int] NULL,
[BillStartDate] [datetime] NULL,
[BillEndDate] [datetime] NULL,
[BaseBillingCycledThruDate] [datetime] NULL,
[BaseAccrualCycledThruDate] [datetime] NULL,
[BaseBilledThruDateInitial] [datetime] NULL,
[OverageBilledThruDateInitial] [datetime] NULL,
[BaseAccruedThruDateInitial] [datetime] NULL,
[ParentContractDetailID] [int] NULL,
[ContractDetailTypeID] [int] NOT NULL CONSTRAINT [DF_SCContractDetails_ContractDetailTypeID] DEFAULT ((1)),
[SubLeaseNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SubLeaseMajor] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SubLeaseMinor] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LeaseTerm] [int] NULL,
[LeasePaymentStartDate] [datetime] NULL,
[LeasePaymentEndDate] [datetime] NULL,
[LeaseRate] [money] NULL,
[LeaseRateFactor] [decimal] (18, 6) NULL,
[LeaseInterestRate] [decimal] (18, 6) NULL,
[LeaseFinancedAmount] [money] NULL,
[LeasePaymentAmount] [money] NULL,
[LeasePrincipalBalance] [money] NULL,
[CombineWithParentBaseAmount] [bit] NOT NULL CONSTRAINT [DF_SCContractDetails_CombineWithParentBaseAmount] DEFAULT ((0)),
[UnearnedInterestBalance] [money] NOT NULL CONSTRAINT [DF_SCContractDetails_UnearnedInterestBalance] DEFAULT ((0)),
[UnearnedLeaseBalance] [money] NOT NULL CONSTRAINT [DF_SCContractDetails_UnearnedLeaseBalance] DEFAULT ((0)),
[UnearnedLeasePostTermBalance] [money] NOT NULL CONSTRAINT [DF_SCContractDetails_UnearnedLeasePostTermBalance] DEFAULT ((0)),
[DetailInstance] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCContractDetails_DetailInstance] DEFAULT ((0)),
[LeaseTerminationCodeID] [int] NULL,
[AssetNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContractDetails_AssetNumber] DEFAULT (''),
[TaxExemptCodeID] [int] NULL,
[Taxable] [bit] NOT NULL CONSTRAINT [DF_SCContractDetails_Taxable] DEFAULT ((0)),
[OverrideTaxable] [bit] NOT NULL CONSTRAINT [DF_SCContractDetails_OverrideTaxable] DEFAULT ((0)),
[ItemID] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContractDetails_Description] DEFAULT (''),
[LocationRemarks] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContractDetails_LocationRemarks] DEFAULT (''),
[ContractLeaseDetailID] [int] NULL,
[SLACodeID] [int] NULL,
[ShTrackingConfigID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [PK_SCContractDetails] PRIMARY KEY CLUSTERED ([ContractDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_BaseDistributionCodeID_SCContractBaseDistCodes] FOREIGN KEY ([BaseDistributionCodeID]) REFERENCES [dbo].[SCContractBaseDistCodes] ([BaseDistributionCodeID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_BillCodeID_SCBillCodes] FOREIGN KEY ([BillCodeID]) REFERENCES [dbo].[SCBillCodes] ([BillCodeID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_ContractDetailTypeID_SCContractDetailTypes] FOREIGN KEY ([ContractDetailTypeID]) REFERENCES [dbo].[SCContractDetailTypes] ([ContractDetailTypeID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_ContractLeaseDetailID_SCContractLeaseDetails] FOREIGN KEY ([ContractLeaseDetailID]) REFERENCES [dbo].[SCContractLeaseDetails] ([ContractLeaseDetailID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_EndMeterReadingGroupID_MTMeterReadingGroups] FOREIGN KEY ([EndMeterReadingGroupID]) REFERENCES [dbo].[MTMeterReadingGroups] ([MeterReadingGroupID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_EquipmentID_SCEquipments] FOREIGN KEY ([EquipmentID]) REFERENCES [dbo].[SCEquipments] ([EquipmentID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_ItemID_ICItems] FOREIGN KEY ([ItemID]) REFERENCES [dbo].[ICItems] ([ItemID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_LeaseBalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([LeaseBalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_LeaseTerminationCodeID_SCLeaseTerminationCodes] FOREIGN KEY ([LeaseTerminationCodeID]) REFERENCES [dbo].[SCLeaseTerminationCodes] ([LeaseTerminationCodeID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_NoteID_SCContractDetailNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[SCContractDetailNotes] ([NoteID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_ParentContractDetailID_SCContractDetails] FOREIGN KEY ([ParentContractDetailID]) REFERENCES [dbo].[SCContractDetails] ([ContractDetailID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_SLACodeID_SCSLACodes] FOREIGN KEY ([SLACodeID]) REFERENCES [dbo].[SCSLACodes] ([SLACodeID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_StartMeterReadingGroupID_MTMeterReadingGroups] FOREIGN KEY ([StartMeterReadingGroupID]) REFERENCES [dbo].[MTMeterReadingGroups] ([MeterReadingGroupID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_TaxExemptCodeID_SHTaxExemptCodes] FOREIGN KEY ([TaxExemptCodeID]) REFERENCES [dbo].[SHTaxExemptCodes] ([TaxExemptCodeID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [FK_SCContractDetails_TerminationCodeID_SCTerminationCodes] FOREIGN KEY ([TerminationCodeID]) REFERENCES [dbo].[SCTerminationCodes] ([TerminationCodeID])
GO
ALTER TABLE [dbo].[SCContractDetails] ADD CONSTRAINT [SCContractDetails_FKC_ShTrackingConfigID_SHTrackingConfigs] FOREIGN KEY ([ShTrackingConfigID]) REFERENCES [dbo].[ShTrackingConfigs] ([ShTrackingConfigID])
GO