CREATE TABLE [dbo].[SCContracts]
(
[ContractID] [int] NOT NULL,
[ContractNumber] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ContractMajor] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ContractMinor] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CustomerID] [int] NOT NULL,
[Contact] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Phone] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Fax] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BillToID] [int] NOT NULL,
[ContractCodeID] [int] NOT NULL,
[BillCodeID] [int] NOT NULL,
[BillGroupID] [int] NULL,
[StartDate] [datetime] NOT NULL,
[ExpDate] [datetime] NULL,
[ExpCopies] [int] NULL,
[BaseNextBillingDate] [datetime] NULL,
[BaseLastBillingDate] [datetime] NULL,
[BaseBillingCycleID] [int] NULL,
[BaseArrears] [bit] NOT NULL,
[BaseNextAccrualDate] [datetime] NULL,
[BaseLastAccrualDate] [datetime] NULL,
[BaseAccrualCycleID] [int] NULL,
[SumIndividualBaseRates] [bit] NOT NULL,
[BaseRate] [money] NOT NULL,
[BaseRatePeriod] [int] NOT NULL,
[OverageNextBillingDate] [datetime] NULL,
[OverageLastBillingDate] [datetime] NULL,
[OverageBillingCycleID] [int] NULL,
[BSABillForServices] [bit] NOT NULL,
[BSALaborDiscount] [float] NULL,
[BSAMaterialsDiscount] [float] NULL,
[BSAMinimumBalance] [money] NOT NULL CONSTRAINT [DF_SCContracts_BSAMinimumBalance] DEFAULT ((0)),
[BSAMinimumBilling] [money] NOT NULL CONSTRAINT [DF_SCContracts_BSAMinimumBilling] DEFAULT ((0)),
[CoveredCopies] [int] NULL,
[LeaseSchedule] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[GroupInvoices] [bit] NOT NULL,
[PONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MiscChargeAmount] [money] NOT NULL,
[MiscChargeTaxFlag] [int] NOT NULL,
[MiscChargeDescription] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MiscChargeGLID] [int] NULL,
[MiscChargeDeptID] [int] NULL,
[MiscContinuous] [bit] NOT NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UnearnedBalance] [money] NOT NULL CONSTRAINT [DF_SCContracts_UnearnedBalance] DEFAULT ((0)),
[Bill] [bit] NOT NULL CONSTRAINT [DF_SCContracts_Bill] DEFAULT ((0)),
[Activated] [datetime] NULL,
[Terminated] [datetime] NULL,
[Renewed] [datetime] NULL,
[RenewedID] [int] NULL,
[Active] [bit] NOT NULL,
[Locks] [int] NOT NULL CONSTRAINT [DF_SCContracts_Locks] DEFAULT ((0)),
[CreatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatorID] [char] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SCContracts_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCContracts_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[TaxCodeID] [int] NULL,
[BranchID] [int] NOT NULL,
[ContractLeaseID] [int] NULL,
[ExtendedTypeID] [int] NOT NULL CONSTRAINT [DF_SCContracts_ExtendedTypeID] DEFAULT ((1)),
[ShTrackingConfigID] [int] NULL,
[UseLeaseOnAllEquipment] [bit] NOT NULL CONSTRAINT [DF_SCContracts_UseLeaseOnAllEquipment] DEFAULT ((0)),
[RemarksInternal] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContracts_RemarksInternal] DEFAULT (''),
[TermID] [int] NULL,
[SalesRepID] [int] NULL,
[JobID] [int] NULL,
[AccumCopies] [decimal] (18, 6) NULL,
[ExpCopyExpDate] [datetime] NULL,
[ContactID] [int] NULL,
[DBFileHeaderID] [int] NOT NULL CONSTRAINT [DF_SCContracts_DBFileHeaderID] DEFAULT ((1)),
[ChargeMethodID] [int] NULL,
[ChargeAccountID] [int] NULL,
[SyncBillToAddress] [bit] NOT NULL CONSTRAINT [DF_SCContracts_SyncBillToAddress] DEFAULT ((0)),
[BillToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContracts_BillToAttn] DEFAULT (''),
[BillToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContracts_BillToAddress] DEFAULT (''),
[BillToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContracts_BillToCity] DEFAULT (''),
[BillToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContracts_BillToState] DEFAULT (''),
[BillToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContracts_BillToZip] DEFAULT (''),
[BillToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContracts_BillToCountry] DEFAULT (''),
[BaseBilledThruDate] [datetime] NULL,
[OverageBilledThruDate] [datetime] NULL,
[BaseAccruedThruDate] [datetime] NULL,
[EnableAgentUsageAlert] [bit] NOT NULL CONSTRAINT [DF_SCContracts_EnableAgentUsageAlert] DEFAULT ((1)),
[PooledUsageLimit] [bit] NOT NULL CONSTRAINT [DF_SCContracts_PooledUsageLimit] DEFAULT ((0)),
[Renewable] [bit] NOT NULL CONSTRAINT [DF_SCContracts_Renewable] DEFAULT ((1)),
[BaseRateScheduleStartDate] [datetime] NULL,
[OvgRateScheduleStartDate] [datetime] NULL,
[RenewalCycleID] [int] NULL,
[NextBaseIncreaseDate] [datetime] NULL,
[NextOvgIncreaseDate] [datetime] NULL,
[NextBaseScheduleDetailID] [int] NULL,
[NextOvgScheduleDetailID] [int] NULL,
[Taxable] [bit] NOT NULL CONSTRAINT [DF_SCContracts_Taxable] DEFAULT ((1)),
[OvgRateScheduleStartDateType] [int] NOT NULL CONSTRAINT [DF_SCContracts_OvgRateScheduleStartDateType] DEFAULT ((0)),
[BaseRateScheduleStartDateType] [int] NOT NULL CONSTRAINT [DF_SCContracts_BaseRateScheduleStartDateType] DEFAULT ((0)),
[BaseRateScheduleIsRenewalType] [bit] NULL CONSTRAINT [DF_SCContracts_BaseRateScheduleIsRenewalType] DEFAULT ((0)),
[OvgRateScheduleIsRenewalType] [bit] NULL CONSTRAINT [DF_SCContracts_OvgRateScheduleIsRenewalType] DEFAULT ((0)),
[BaseBillingStartDate] [datetime] NULL,
[BaseAccrualStartDate] [datetime] NULL,
[OverageBillingStartDate] [datetime] NULL,
[BasePreBillingNoDays] [int] NOT NULL CONSTRAINT [DF_SCContracts_BasePreBillingNoDays] DEFAULT ((0)),
[UseAlternateOvgBillTo] [bit] NOT NULL CONSTRAINT [DF_SCContracts_UseAlternateOvgBillTo] DEFAULT ((0)),
[OvgBillToID] [int] NULL,
[OvgBillToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContracts_OvgBillToAttn] DEFAULT (''),
[OvgBillToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContracts_OvgBillToAddress] DEFAULT (''),
[OvgBillToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContracts_OvgBillToCity] DEFAULT (''),
[OvgBillToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContracts_OvgBillToState] DEFAULT (''),
[OvgBillToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContracts_OvgBillToZip] DEFAULT (''),
[OvgBillToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContracts_OvgBillToCountry] DEFAULT (''),
[SyncOvgBillToAddress] [bit] NOT NULL CONSTRAINT [DF_SCContracts_SyncOvgBillToAddress] DEFAULT ((0)),
[OvgBillToTermID] [int] NULL,
[OvgBillToChargeMethodID] [int] NULL,
[OvgBillToChargeAccountID] [int] NULL,
[ContractAdjCodeID] [int] NULL,
[BasePreBillingNoMonths] [int] NOT NULL CONSTRAINT [DF_SCContracts_BasePreBillingNoMonths] DEFAULT ((0)),
[UseIndividualTaxCodes] [bit] NOT NULL CONSTRAINT [DF_SCContracts_UseIndividualTaxCodes] DEFAULT ((0)),
[BSABillingDiscount] [decimal] (8, 4) NULL,
[BSABillingDiscountBalance] [money] NOT NULL CONSTRAINT [DF_SCContracts_BSABillingDiscountBalance] DEFAULT ((0)),
[BSABillingDiscountMode] [bit] NOT NULL CONSTRAINT [DF_SCContracts_BSABillingDiscountMode] DEFAULT ((0)),
[Accrual] [bit] NOT NULL CONSTRAINT [DF_SCContracts_Accrual] DEFAULT ((0)),
[AccrualAccountsLock] [bit] NOT NULL CONSTRAINT [DF_SCContracts_AccrualAccountsLock] DEFAULT ((0)),
[Billed] [bit] NOT NULL CONSTRAINT [DF_SCContracts_Billed] DEFAULT ((0)),
[LockBillCode] [bit] NOT NULL CONSTRAINT [DF_SCContracts_LockBillCode] DEFAULT ((0)),
[UseBillCodeRevOnRenewal] [bit] NOT NULL CONSTRAINT [DF_SCContracts_UseBillCodeRevOnRenewal] DEFAULT ((0)),
[BSARebillType] [int] NOT NULL CONSTRAINT [DF_SCContracts_BSARebillType] DEFAULT ((0)),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_SCContracts_NoteFlag] DEFAULT ((0)),
[TerminationCodeID] [int] NULL,
[ContractStatusID] [int] NOT NULL CONSTRAINT [DF_SCContracts_ContractStatusID] DEFAULT ((1)),
[OneTimeRemark] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContracts_OneTimeRemark] DEFAULT (''),
[PrintOneTimeRemark] [bit] NOT NULL CONSTRAINT [DF_SCContracts_PrintOneTimeRemark] DEFAULT ((0)),
[OvgBillToTaxable] [bit] NOT NULL CONSTRAINT [DF_SCContracts_OvgBillToTaxable] DEFAULT ((0)),
[OvgBillToTaxCodeID] [int] NULL,
[OvgBillToUseIndividualTaxCodes] [bit] NOT NULL CONSTRAINT [DF_SCContracts_OvgBillToUseIndividualTaxCodes] DEFAULT ((0)),
[MiscChargeBillCycleFlag] [int] NOT NULL CONSTRAINT [DF_SCContracts_MiscChargeBillCycleFlag] DEFAULT ((3)),
[AllowMeterEstimation] [bit] NOT NULL CONSTRAINT [DF_SCContracts_AllowMeterEstimation] DEFAULT ((1)),
[ExpCopiesBase] [int] NOT NULL CONSTRAINT [DF_SCContracts_ExpCopiesBase] DEFAULT ((0)),
[ExpAdjCopies] [int] NOT NULL CONSTRAINT [DF_SCContracts_ExpAdjCopies] DEFAULT ((0)),
[ExpCopiesActualExpDate] [datetime] NULL,
[ExpDateInitial] [datetime] NULL,
[ExpCopiesBillOverages] [bit] NOT NULL CONSTRAINT [DF_SCContracts_ExpCopiesBillOverages] DEFAULT ((0)),
[ExpCopiesRollOverages] [bit] NOT NULL CONSTRAINT [DF_SCContracts_ExpCopiesRollOverages] DEFAULT ((0)),
[ExpCopiesMaxOveragesToRoll] [int] NOT NULL CONSTRAINT [DF_SCContracts_ExpCopiesMaxOveragesToRoll] DEFAULT ((0)),
[ExpCopiesActualOveragesToRoll] [int] NOT NULL CONSTRAINT [DF_SCContracts_ExpCopiesActualOveragesToRoll] DEFAULT ((0)),
[CPPMinimumPages] [int] NOT NULL CONSTRAINT [DF_SCContracts_CPPMinimumPages] DEFAULT ((0)),
[CPPRate] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCContracts_CPPRate] DEFAULT ((0)),
[CPPHardwareAmount] [money] NOT NULL CONSTRAINT [DF_SCContracts_CPPHardwareAmount] DEFAULT ((0)),
[CPPServiceRate] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCContracts_CPPServiceRate] DEFAULT ((0)),
[CombineLeaseAndBase] [bit] NOT NULL CONSTRAINT [DF_SCContracts_CombineLeaseAndBase] DEFAULT ((0)),
[TimeBlockBased] [bit] NOT NULL CONSTRAINT [DF_SCContracts_TimeBlockBased] DEFAULT ((0)),
[MGBaseRateScheduleIsRenewalType] [bit] NULL CONSTRAINT [DF_SCContracts_MGBaseRateScheduleIsRenewalType] DEFAULT ((0)),
[MGBaseRateScheduleStartDate] [datetime] NULL,
[MGBaseRateScheduleStartDateType] [int] NULL CONSTRAINT [DF_SCContracts_MGBaseRateScheduleStartDateType] DEFAULT ((0)),
[NextMGBaseIncreaseDate] [datetime] NULL,
[NextMGBaseScheduleDetailID] [int] NULL,
[ReportDefinitionGroupID] [int] NOT NULL,
[ReportDefinitionContactID] [int] NULL,
[ReportDefinitionDocSendMethodID] [tinyint] NULL,
[ReportDefinitionUseContactWithServiceInvoices] [bit] NOT NULL CONSTRAINT [DF_SCContracts_ReportDefinitionUseContactWithServiceInvoices] DEFAULT ((0)),
[OvgBillToReportDefinitionGroupID] [int] NULL,
[OvgBillToReportDefinitionContactID] [int] NULL,
[OvgBillToReportDefinitionDocSendMethodID] [tinyint] NULL,
[OvgBillToReportDefinitionUseContactWithServiceInvoices] [bit] NOT NULL CONSTRAINT [DF_SCContracts_OvgBillToReportDefinitionUseContactWithServiceInvoices] DEFAULT ((0)),
[NoteCount] [int] NOT NULL CONSTRAINT [DF_SCContracts_NoteCount] DEFAULT ((0)),
[IssueCredit] [bit] NOT NULL CONSTRAINT [DF_SCContracts_IssueCredit] DEFAULT ((0)),
[EnableBaseCycleConsolidation] [bit] NOT NULL CONSTRAINT [DF_SCContracts_EnableBaseCycleConsolidation] DEFAULT ((0)),
[EnableOverageCycleConsolidation] [bit] NOT NULL CONSTRAINT [DF_SCContracts_EnableOverageCycleConsolidation] DEFAULT ((0)),
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[LeaseDivisionID] [int] NULL,
[LeaseBalanceSheetGroupID] [int] NULL,
[BaseBilledThruDateInitial] [datetime] NULL,
[OverageBilledThruDateInitial] [datetime] NULL,
[BaseAccruedThruDateInitial] [datetime] NULL,
[BaseRatePeriodType] [int] NOT NULL CONSTRAINT [DF_SCContracts_BaseRatePeriodType] DEFAULT ((1)),
[UnearnedInterestBalance] [money] NOT NULL CONSTRAINT [DF_SCContracts_UnearnedInterestBalance] DEFAULT ((0)),
[UnearnedLeaseBalance] [money] NOT NULL CONSTRAINT [DF_SCContracts_UnearnedLeaseBalance] DEFAULT ((0)),
[UnearnedLeasePostTermBalance] [money] NOT NULL CONSTRAINT [DF_SCContracts_UnearnedLeasePostTermBalance] DEFAULT ((0)),
[Message] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCContracts_Message] DEFAULT (''),
[MessReqAcknowledgment] [bit] NOT NULL CONSTRAINT [DF_SCContracts_MessReqAcknowledgment] DEFAULT ((1)),
[TaxExemptCodeID] [int] NULL,
[OvgBillToTaxExemptCodeID] [int] NULL,
[SLACodeID] [int] NULL,
[BaseDistributionCodeID] [int] NOT NULL,
[MiscChargeTaxFlagID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [PK_SCContracts] PRIMARY KEY CLUSTERED ([ContractID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_BaseAccrualCycleID_SCBillingCycles] FOREIGN KEY ([BaseAccrualCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_BaseBillingCycleID_SCBillingCycles] FOREIGN KEY ([BaseBillingCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_BaseDistributionCodeID_SCContractBaseDistCodes] FOREIGN KEY ([BaseDistributionCodeID]) REFERENCES [dbo].[SCContractBaseDistCodes] ([BaseDistributionCodeID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_BillCodeID_SCBillCodes] FOREIGN KEY ([BillCodeID]) REFERENCES [dbo].[SCBillCodes] ([BillCodeID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_BillGroupID_SCContractBillGroups] FOREIGN KEY ([BillGroupID]) REFERENCES [dbo].[SCContractBillGroups] ([GroupID])
GO
ALTER TABLE [dbo].[SCContracts] WITH NOCHECK ADD CONSTRAINT [FK_SCContracts_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_ChargeAccountID_ARChargeAccounts] FOREIGN KEY ([ChargeAccountID]) REFERENCES [dbo].[ARChargeAccounts] ([ChargeAccountID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_ChargeMethodID_ARChargeMethods] FOREIGN KEY ([ChargeMethodID]) REFERENCES [dbo].[ARChargeMethods] ([ChargeMethodID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_ContactID_CMContacts] FOREIGN KEY ([ContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_ContractCodeID_SCContractCodes] FOREIGN KEY ([ContractCodeID]) REFERENCES [dbo].[SCContractCodes] ([ContractCodeID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_ContractLeaseID_SCContractLeases] FOREIGN KEY ([ContractLeaseID]) REFERENCES [dbo].[SCContractLeases] ([ContractLeaseID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_ContractStatusID_SCContractStatuses] FOREIGN KEY ([ContractStatusID]) REFERENCES [dbo].[SCContractStatuses] ([ContractStatusID])
GO
ALTER TABLE [dbo].[SCContracts] WITH NOCHECK ADD CONSTRAINT [FK_SCContracts_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_DBFileHeaderID_DBFileHeader] FOREIGN KEY ([DBFileHeaderID]) REFERENCES [dbo].[DBFileHeader] ([DBFileHeaderID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_ExtendedTypeID_SCExtendedContractTypes] FOREIGN KEY ([ExtendedTypeID]) REFERENCES [dbo].[SCExtendedContractTypes] ([ExtendedContractTypeID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_LeaseBalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([LeaseBalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_LeaseDivisionID_GLDivisions] FOREIGN KEY ([LeaseDivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_MiscChargeDeptID_GLDepts5] FOREIGN KEY ([MiscChargeDeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_MiscChargeGLID_GLAccounts5] FOREIGN KEY ([MiscChargeGLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_MiscChargeTaxFlagID_ShTaxFlags] FOREIGN KEY ([MiscChargeTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_NoteID_SCContractNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[SCContractNotes] ([NoteID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_OverageBillingCycleID_SCBillingCycles] FOREIGN KEY ([OverageBillingCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_OvgBillToChargeAccountID_ARChargeAccounts] FOREIGN KEY ([OvgBillToChargeAccountID]) REFERENCES [dbo].[ARChargeAccounts] ([ChargeAccountID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_OvgBillToChargeMethodID_ARChargeMethods] FOREIGN KEY ([OvgBillToChargeMethodID]) REFERENCES [dbo].[ARChargeMethods] ([ChargeMethodID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_OvgBillToID_ARCustomers] FOREIGN KEY ([OvgBillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_OvgBillToReportDefinitionContactID_CMContacts] FOREIGN KEY ([OvgBillToReportDefinitionContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_OvgBillToReportDefinitionDocSendMethodID_SHDocSendMethods] FOREIGN KEY ([OvgBillToReportDefinitionDocSendMethodID]) REFERENCES [dbo].[SHDocSendMethods] ([DocSendMethodID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_OvgBillToReportDefinitionGroupID_RPReportDefinitionGroups] FOREIGN KEY ([OvgBillToReportDefinitionGroupID]) REFERENCES [dbo].[RPReportDefinitionGroups] ([ReportDefinitionGroupID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_OvgBillToTaxCodeID_ShTaxCodes] FOREIGN KEY ([OvgBillToTaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_OvgBillToTaxExemptCodeID_SHTaxExemptCodes] FOREIGN KEY ([OvgBillToTaxExemptCodeID]) REFERENCES [dbo].[SHTaxExemptCodes] ([TaxExemptCodeID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_OvgBillToTermID_ShTerms] FOREIGN KEY ([OvgBillToTermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_RenewalCycleID_SCBillingCycles] FOREIGN KEY ([RenewalCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_ReportDefinitionContactID_CMContacts] FOREIGN KEY ([ReportDefinitionContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_ReportDefinitionDocSendMethodID_SHDocSendMethods] FOREIGN KEY ([ReportDefinitionDocSendMethodID]) REFERENCES [dbo].[SHDocSendMethods] ([DocSendMethodID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_ReportDefinitionGroupID_RPReportDefinitionGroups] FOREIGN KEY ([ReportDefinitionGroupID]) REFERENCES [dbo].[RPReportDefinitionGroups] ([ReportDefinitionGroupID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_SalesRepID_ARSalesReps] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ARSalesReps] ([SalesRepID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_ShTrackingConfigID_ShTrackingConfigs] FOREIGN KEY ([ShTrackingConfigID]) REFERENCES [dbo].[ShTrackingConfigs] ([ShTrackingConfigID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_SLACodeID_SCSLACodes] FOREIGN KEY ([SLACodeID]) REFERENCES [dbo].[SCSLACodes] ([SLACodeID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_TaxExemptCodeID_SHTaxExemptCodes] FOREIGN KEY ([TaxExemptCodeID]) REFERENCES [dbo].[SHTaxExemptCodes] ([TaxExemptCodeID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO
ALTER TABLE [dbo].[SCContracts] ADD CONSTRAINT [FK_SCContracts_TerminationCodeID_SCTerminationCodes] FOREIGN KEY ([TerminationCodeID]) REFERENCES [dbo].[SCTerminationCodes] ([TerminationCodeID])
GO