Tables [dbo].[SCQContracts]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created1:00:04 AM Thursday, March 21, 2019
Last Modified1:15:22 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_SCQContracts: QContractIDQContractIDint4
False
1 - 1
Foreign Keys FK_SCQContracts_CustomerID_ARCustomers: [dbo].[ARCustomers].CustomerIDCustomerIDint4
False
Foreign Keys FK_SCQContracts_QContractStatusID_SCQContractStatuses: [dbo].[SCQContractStatuses].QContractStatusIDQContractStatusIDint4
False
Foreign Keys FK_SCQContracts_ContactID_CMContacts: [dbo].[CMContacts].ContactIDContactIDint4
True
Contactvarchar(50)50
False
Phonevarchar(30)30
False
Faxvarchar(30)30
False
Foreign Keys FK_SCQContracts_BillToID_ARCustomers: [dbo].[ARCustomers].BillToIDBillToIDint4
True
Foreign Keys FK_SCQContracts_ContractCodeID_SCContractCodes: [dbo].[SCContractCodes].ContractCodeIDContractCodeIDint4
True
Descriptionvarchar(255)255
False
Foreign Keys FK_SCQContracts_BillCodeID_SCBillCodes: [dbo].[SCBillCodes].BillCodeIDBillCodeIDint4
True
Foreign Keys FK_SCQContracts_BillGroupID_SCContractBillGroups: [dbo].[SCContractBillGroups].BillGroupIDBillGroupIDint4
True
Foreign Keys FK_SCQContracts_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
True
StartDatedatetime8
False
ExpDatedatetime8
True
BaseStartBillingDatedatetime8
True
Foreign Keys FK_SCQContracts_BaseBillingCycleID_SCBillingCycles: [dbo].[SCBillingCycles].BaseBillingCycleIDBaseBillingCycleIDint4
True
BaseArrearsbit1
False
Billbit1
False
SumIndividualBaseRatesbit1
False
BaseRatemoney8
False
BaseRatePeriodint4
False
BasePreBillingNoDaysint4
False
BasePreBillingNoMonthsint4
False
OverageStartBillingDatedatetime8
True
Foreign Keys FK_SCQContracts_OverageBillingCycleID_SCBillingCycles: [dbo].[SCBillingCycles].OverageBillingCycleIDOverageBillingCycleIDint4
True
GroupInvoicesbit1
False
PONumbervarchar(32)32
False
MiscChargeTaxFlagint4
False
MiscChargeDescriptionvarchar(255)255
False
MiscChargeGLIDint4
True
MiscChargeDeptIDint4
True
MiscContinuousbit1
False
MiscChargeBillCycleFlagint4
False
((3))
Remarksvarchar(1024)1024
False
OneTimeRemarkvarchar(1024)1024
False
('')
Notesvarchar(2048)2048
False
('')
Foreign Keys FK_SCQContracts_TermID_ShTerms: [dbo].[ShTerms].TermIDTermIDint4
True
Foreign Keys FK_SCQContracts_SalesRepID_ARSalesReps: [dbo].[ARSalesReps].SalesRepIDSalesRepIDint4
True
Foreign Keys FK_SCQContracts_JobID_ICJobs: [dbo].[ICJobs].JobIDJobIDint4
True
Foreign Keys FK_SCQContracts_ChargeMethodID_ARChargeMethods: [dbo].[ARChargeMethods].ChargeMethodIDChargeMethodIDint4
True
Foreign Keys FK_SCQContracts_ChargeAccountID_ARChargeAccounts: [dbo].[ARChargeAccounts].ChargeAccountIDChargeAccountIDint4
True
Foreign Keys FK_SCQContracts_ServiceHourCodeID_SHServiceHourCodes: [dbo].[SHServiceHourCodes].ServiceHourCodeIDServiceHourCodeIDint4
True
Renewablebit1
False
Foreign Keys FK_SCQContracts_RenewalCycleID_SCBillingCycles: [dbo].[SCBillingCycles].RenewalCycleIDRenewalCycleIDint4
True
Foreign Keys FK_SCQContracts_TaxCodeID_ShTaxCodes: [dbo].[ShTaxCodes].TaxCodeIDTaxCodeIDint4
True
Taxablebit1
False
UseIndividualTaxCodesbit1
False
LeaseSchedulevarchar(20)20
True
SyncBillToAddressbit1
False
((0))
BillToAttnvarchar(64)64
False
('')
BillToAddressvarchar(64)64
False
('')
BillToCityvarchar(32)32
False
('')
BillToStatevarchar(16)16
False
('')
BillToZipvarchar(16)16
False
('')
BillToCountryvarchar(16)16
False
('')
EnableAgentUsageAlertbit1
False
((1))
PooledUsageLimitbit1
False
((0))
Foreign Keys FK_SCQContracts_ContractAdjCodeID_SCContractAdjustmentCodes: [dbo].[SCContractAdjustmentCodes].ContractAdjCodeIDContractAdjCodeIDint4
True
AllowMeterEstimationbit1
False
((1))
UseAlternateOvgBillTobit1
False
((0))
Foreign Keys FK_SCQContracts_OvgBillToID_ARCustomers: [dbo].[ARCustomers].OvgBillToIDOvgBillToIDint4
True
OvgBillToAttnvarchar(64)64
False
('')
OvgBillToAddressvarchar(64)64
False
('')
OvgBillToCityvarchar(32)32
False
('')
OvgBillToStatevarchar(16)16
False
('')
OvgBillToZipvarchar(16)16
False
('')
OvgBillToCountryvarchar(16)16
False
('')
SyncOvgBillToAddressbit1
False
((0))
Foreign Keys FK_SCQContracts_OvgBillToTermID_ShTerms: [dbo].[ShTerms].OvgBillToTermIDOvgBillToTermIDint4
True
Foreign Keys FK_SCQContracts_OvgBillToChargeMethodID_ARChargeMethods: [dbo].[ARChargeMethods].OvgBillToChargeMethodIDOvgBillToChargeMethodIDint4
True
Foreign Keys FK_SCQContracts_OvgBillToChargeAccountID_ARChargeAccounts: [dbo].[ARChargeAccounts].OvgBillToChargeAccountIDOvgBillToChargeAccountIDint4
True
OvgBillToTaxablebit1
False
((0))
Foreign Keys FK_SCQContracts_OvgBillToTaxCodeID_ShTaxCodes: [dbo].[ShTaxCodes].OvgBillToTaxCodeIDOvgBillToTaxCodeIDint4
True
OvgBillToUseIndividualTaxCodesbit1
False
((0))
Foreign Keys FK_SCQContracts_ContractID_SCContracts: [dbo].[SCContracts].ContractIDContractIDint4
True
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
Foreign Keys FK_SCQContracts_MiscChargeCodeID_SCContractMiscChargeCodes: [dbo].[SCContractMiscChargeCodes].MiscChargeCodeIDMiscChargeCodeIDint4
True
MiscChargeQuantitydecimal(18,6)9
True
MiscChargeRatedecimal(18,6)9
True
BillingEnabledbit1
True
BillFrequencyIDint4
True
Foreign Keys FK_SCQContracts_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
True
Foreign Keys FK_SCQContracts_ReportDefinitionGroupID_RPReportDefinitionGroups: [dbo].[RPReportDefinitionGroups].ReportDefinitionGroupIDReportDefinitionGroupIDint4
True
Foreign Keys FK_SCQContracts_OvgBillToReportDefinitionGroupID_RPReportDefinitionGroups: [dbo].[RPReportDefinitionGroups].OvgBillToReportDefinitionGroupIDOvgBillToReportDefinitionGroupIDint4
True
BaseRatePeriodTypeint4
False
((1))
Foreign Keys FK_SCQContracts_TaxExemptCodeID_SHTaxExemptCodes: [dbo].[SHTaxExemptCodes].TaxExemptCodeIDTaxExemptCodeIDint4
True
Foreign Keys FK_SCQContracts_OvgBillToTaxExemptCodeID_SHTaxExemptCodes: [dbo].[SHTaxExemptCodes].OvgBillToTaxExemptCodeIDOvgBillToTaxExemptCodeIDint4
True
ContractNumbervarchar(35)35
True
Foreign Keys FK_SCQContracts_QContractErrorStatusID_SCQContractErrorStatuses: [dbo].[SCQContractErrorStatuses].QContractErrorStatusIDQContractErrorStatusIDint4
True
((15))
Foreign Keys FK_SCQContracts_QContractWarningStatusID_SCQContractWarningStatuses: [dbo].[SCQContractWarningStatuses].QContractWarningStatusIDQContractWarningStatusIDint4
True
((15))
Foreign Keys FK_SCQContracts_MiscChargeTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].MiscChargeTaxFlagIDMiscChargeTaxFlagIDint4
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCQContracts: QContractIDPK_SCQContractsQContractID
True
80
NameColumns
FK_SCQContracts_BaseBillingCycleID_SCBillingCyclesBaseBillingCycleID->[dbo].[SCBillingCycles].[BillingCycleID]
FK_SCQContracts_BillCodeID_SCBillCodesBillCodeID->[dbo].[SCBillCodes].[BillCodeID]
FK_SCQContracts_BillGroupID_SCContractBillGroupsBillGroupID->[dbo].[SCContractBillGroups].[GroupID]
FK_SCQContracts_BillToID_ARCustomersBillToID->[dbo].[ARCustomers].[CustomerID]
FK_SCQContracts_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SCQContracts_ChargeAccountID_ARChargeAccountsChargeAccountID->[dbo].[ARChargeAccounts].[ChargeAccountID]
FK_SCQContracts_ChargeMethodID_ARChargeMethodsChargeMethodID->[dbo].[ARChargeMethods].[ChargeMethodID]
FK_SCQContracts_ContactID_CMContactsContactID->[dbo].[CMContacts].[ContactID]
FK_SCQContracts_ContractAdjCodeID_SCContractAdjustmentCodesContractAdjCodeID->[dbo].[SCContractAdjustmentCodes].[ContractAdjCodeID]
FK_SCQContracts_ContractCodeID_SCContractCodesContractCodeID->[dbo].[SCContractCodes].[ContractCodeID]
FK_SCQContracts_ContractID_SCContractsContractID->[dbo].[SCContracts].[ContractID]
FK_SCQContracts_CustomerID_ARCustomersCustomerID->[dbo].[ARCustomers].[CustomerID]
FK_SCQContracts_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCQContracts_JobID_ICJobsJobID->[dbo].[ICJobs].[JobID]
FK_SCQContracts_MiscChargeCodeID_SCContractMiscChargeCodesMiscChargeCodeID->[dbo].[SCContractMiscChargeCodes].[MiscChargeCodeID]
FK_SCQContracts_MiscChargeTaxFlagID_ShTaxFlagsMiscChargeTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCQContracts_OverageBillingCycleID_SCBillingCyclesOverageBillingCycleID->[dbo].[SCBillingCycles].[BillingCycleID]
FK_SCQContracts_OvgBillToChargeAccountID_ARChargeAccountsOvgBillToChargeAccountID->[dbo].[ARChargeAccounts].[ChargeAccountID]
FK_SCQContracts_OvgBillToChargeMethodID_ARChargeMethodsOvgBillToChargeMethodID->[dbo].[ARChargeMethods].[ChargeMethodID]
FK_SCQContracts_OvgBillToID_ARCustomersOvgBillToID->[dbo].[ARCustomers].[CustomerID]
FK_SCQContracts_OvgBillToReportDefinitionGroupID_RPReportDefinitionGroupsOvgBillToReportDefinitionGroupID->[dbo].[RPReportDefinitionGroups].[ReportDefinitionGroupID]
FK_SCQContracts_OvgBillToTaxCodeID_ShTaxCodesOvgBillToTaxCodeID->[dbo].[ShTaxCodes].[TaxCodeID]
FK_SCQContracts_OvgBillToTaxExemptCodeID_SHTaxExemptCodesOvgBillToTaxExemptCodeID->[dbo].[SHTaxExemptCodes].[TaxExemptCodeID]
FK_SCQContracts_OvgBillToTermID_ShTermsOvgBillToTermID->[dbo].[ShTerms].[TermID]
FK_SCQContracts_QContractErrorStatusID_SCQContractErrorStatusesQContractErrorStatusID->[dbo].[SCQContractErrorStatuses].[QContractErrorStatusID]
FK_SCQContracts_QContractStatusID_SCQContractStatusesQContractStatusID->[dbo].[SCQContractStatuses].[QContractStatusID]
FK_SCQContracts_QContractWarningStatusID_SCQContractWarningStatusesQContractWarningStatusID->[dbo].[SCQContractWarningStatuses].[QContractWarningStatusID]
FK_SCQContracts_RenewalCycleID_SCBillingCyclesRenewalCycleID->[dbo].[SCBillingCycles].[BillingCycleID]
FK_SCQContracts_ReportDefinitionGroupID_RPReportDefinitionGroupsReportDefinitionGroupID->[dbo].[RPReportDefinitionGroups].[ReportDefinitionGroupID]
FK_SCQContracts_SalesRepID_ARSalesRepsSalesRepID->[dbo].[ARSalesReps].[SalesRepID]
FK_SCQContracts_ServiceHourCodeID_SHServiceHourCodesServiceHourCodeID->[dbo].[SHServiceHourCodes].[ServiceHourCodeID]
FK_SCQContracts_TaxCodeID_ShTaxCodesTaxCodeID->[dbo].[ShTaxCodes].[TaxCodeID]
FK_SCQContracts_TaxExemptCodeID_SHTaxExemptCodesTaxExemptCodeID->[dbo].[SHTaxExemptCodes].[TaxExemptCodeID]
FK_SCQContracts_TermID_ShTermsTermID->[dbo].[ShTerms].[TermID]
CREATE TABLE [dbo].[SCQContracts]
(
[QContractID] [int] NOT NULL IDENTITY(1, 1),
[CustomerID] [int] NOT NULL,
[QContractStatusID] [int] NOT NULL,
[ContactID] [int] 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] NULL,
[ContractCodeID] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[BillCodeID] [int] NULL,
[BillGroupID] [int] NULL,
[BranchID] [int] NULL,
[StartDate] [datetime] NOT NULL,
[ExpDate] [datetime] NULL,
[BaseStartBillingDate] [datetime] NULL,
[BaseBillingCycleID] [int] NULL,
[BaseArrears] [bit] NOT NULL,
[Bill] [bit] NOT NULL,
[SumIndividualBaseRates] [bit] NOT NULL,
[BaseRate] [money] NOT NULL,
[BaseRatePeriod] [int] NOT NULL,
[BasePreBillingNoDays] [int] NOT NULL,
[BasePreBillingNoMonths] [int] NOT NULL,
[OverageStartBillingDate] [datetime] NULL,
[OverageBillingCycleID] [int] NULL,
[GroupInvoices] [bit] NOT NULL,
[PONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS 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,
[MiscChargeBillCycleFlag] [int] NOT NULL CONSTRAINT [DF_SCQContracts_MiscChargeBillCycleFlag] DEFAULT ((3)),
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[OneTimeRemark] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContracts_OneTimeRemark] DEFAULT (''),
[Notes] [varchar] (2048) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContracts_Notes] DEFAULT (''),
[TermID] [int] NULL,
[SalesRepID] [int] NULL,
[JobID] [int] NULL,
[ChargeMethodID] [int] NULL,
[ChargeAccountID] [int] NULL,
[ServiceHourCodeID] [int] NULL,
[Renewable] [bit] NOT NULL,
[RenewalCycleID] [int] NULL,
[TaxCodeID] [int] NULL,
[Taxable] [bit] NOT NULL,
[UseIndividualTaxCodes] [bit] NOT NULL,
[LeaseSchedule] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SyncBillToAddress] [bit] NOT NULL CONSTRAINT [DF_SCQContracts_SyncBillToAddress] DEFAULT ((0)),
[BillToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContracts_BillToAttn] DEFAULT (''),
[BillToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContracts_BillToAddress] DEFAULT (''),
[BillToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContracts_BillToCity] DEFAULT (''),
[BillToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContracts_BillToState] DEFAULT (''),
[BillToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContracts_BillToZip] DEFAULT (''),
[BillToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContracts_BillToCountry] DEFAULT (''),
[EnableAgentUsageAlert] [bit] NOT NULL CONSTRAINT [DF_SCQContracts_EnableAgentUsageAlert] DEFAULT ((1)),
[PooledUsageLimit] [bit] NOT NULL CONSTRAINT [DF_SCQContracts_PooledUsageLimit] DEFAULT ((0)),
[ContractAdjCodeID] [int] NULL,
[AllowMeterEstimation] [bit] NOT NULL CONSTRAINT [DF_SCQContracts_AllowMeterEstimation] DEFAULT ((1)),
[UseAlternateOvgBillTo] [bit] NOT NULL CONSTRAINT [DF_SCQContracts_UseAlternateOvgBillTo] DEFAULT ((0)),
[OvgBillToID] [int] NULL,
[OvgBillToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContracts_OvgBillToAttn] DEFAULT (''),
[OvgBillToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContracts_OvgBillToAddress] DEFAULT (''),
[OvgBillToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContracts_OvgBillToCity] DEFAULT (''),
[OvgBillToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContracts_OvgBillToState] DEFAULT (''),
[OvgBillToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContracts_OvgBillToZip] DEFAULT (''),
[OvgBillToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQContracts_OvgBillToCountry] DEFAULT (''),
[SyncOvgBillToAddress] [bit] NOT NULL CONSTRAINT [DF_SCQContracts_SyncOvgBillToAddress] DEFAULT ((0)),
[OvgBillToTermID] [int] NULL,
[OvgBillToChargeMethodID] [int] NULL,
[OvgBillToChargeAccountID] [int] NULL,
[OvgBillToTaxable] [bit] NOT NULL CONSTRAINT [DF_SCQContracts_OvgBillToTaxable] DEFAULT ((0)),
[OvgBillToTaxCodeID] [int] NULL,
[OvgBillToUseIndividualTaxCodes] [bit] NOT NULL CONSTRAINT [DF_SCQContracts_OvgBillToUseIndividualTaxCodes] DEFAULT ((0)),
[ContractID] [int] 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,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SCQContracts_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCQContracts_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[MiscChargeCodeID] [int] NULL,
[MiscChargeQuantity] [decimal] (18, 6) NULL,
[MiscChargeRate] [decimal] (18, 6) NULL,
[BillingEnabled] [bit] NULL,
[BillFrequencyID] [int] NULL,
[DivisionID] [int] NULL,
[ReportDefinitionGroupID] [int] NULL,
[OvgBillToReportDefinitionGroupID] [int] NULL,
[BaseRatePeriodType] [int] NOT NULL CONSTRAINT [DF_SCQContracts_BaseRatePeriodType] DEFAULT ((1)),
[TaxExemptCodeID] [int] NULL,
[OvgBillToTaxExemptCodeID] [int] NULL,
[ContractNumber] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[QContractErrorStatusID] [int] NULL CONSTRAINT [DF_SCQContracts_QContractErrorStatusID] DEFAULT ((15)),
[QContractWarningStatusID] [int] NULL CONSTRAINT [DF_SCQContracts_QContractWarningStatusID] DEFAULT ((15)),
[MiscChargeTaxFlagID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [PK_SCQContracts] PRIMARY KEY CLUSTERED  ([QContractID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_BaseBillingCycleID_SCBillingCycles] FOREIGN KEY ([BaseBillingCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_BillCodeID_SCBillCodes] FOREIGN KEY ([BillCodeID]) REFERENCES [dbo].[SCBillCodes] ([BillCodeID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_BillGroupID_SCContractBillGroups] FOREIGN KEY ([BillGroupID]) REFERENCES [dbo].[SCContractBillGroups] ([GroupID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_ChargeAccountID_ARChargeAccounts] FOREIGN KEY ([ChargeAccountID]) REFERENCES [dbo].[ARChargeAccounts] ([ChargeAccountID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_ChargeMethodID_ARChargeMethods] FOREIGN KEY ([ChargeMethodID]) REFERENCES [dbo].[ARChargeMethods] ([ChargeMethodID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_ContactID_CMContacts] FOREIGN KEY ([ContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_ContractAdjCodeID_SCContractAdjustmentCodes] FOREIGN KEY ([ContractAdjCodeID]) REFERENCES [dbo].[SCContractAdjustmentCodes] ([ContractAdjCodeID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_ContractCodeID_SCContractCodes] FOREIGN KEY ([ContractCodeID]) REFERENCES [dbo].[SCContractCodes] ([ContractCodeID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_MiscChargeCodeID_SCContractMiscChargeCodes] FOREIGN KEY ([MiscChargeCodeID]) REFERENCES [dbo].[SCContractMiscChargeCodes] ([MiscChargeCodeID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_MiscChargeTaxFlagID_ShTaxFlags] FOREIGN KEY ([MiscChargeTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_OverageBillingCycleID_SCBillingCycles] FOREIGN KEY ([OverageBillingCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_OvgBillToChargeAccountID_ARChargeAccounts] FOREIGN KEY ([OvgBillToChargeAccountID]) REFERENCES [dbo].[ARChargeAccounts] ([ChargeAccountID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_OvgBillToChargeMethodID_ARChargeMethods] FOREIGN KEY ([OvgBillToChargeMethodID]) REFERENCES [dbo].[ARChargeMethods] ([ChargeMethodID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_OvgBillToID_ARCustomers] FOREIGN KEY ([OvgBillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_OvgBillToReportDefinitionGroupID_RPReportDefinitionGroups] FOREIGN KEY ([OvgBillToReportDefinitionGroupID]) REFERENCES [dbo].[RPReportDefinitionGroups] ([ReportDefinitionGroupID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_OvgBillToTaxCodeID_ShTaxCodes] FOREIGN KEY ([OvgBillToTaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_OvgBillToTaxExemptCodeID_SHTaxExemptCodes] FOREIGN KEY ([OvgBillToTaxExemptCodeID]) REFERENCES [dbo].[SHTaxExemptCodes] ([TaxExemptCodeID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_OvgBillToTermID_ShTerms] FOREIGN KEY ([OvgBillToTermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_QContractErrorStatusID_SCQContractErrorStatuses] FOREIGN KEY ([QContractErrorStatusID]) REFERENCES [dbo].[SCQContractErrorStatuses] ([QContractErrorStatusID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_QContractStatusID_SCQContractStatuses] FOREIGN KEY ([QContractStatusID]) REFERENCES [dbo].[SCQContractStatuses] ([QContractStatusID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_QContractWarningStatusID_SCQContractWarningStatuses] FOREIGN KEY ([QContractWarningStatusID]) REFERENCES [dbo].[SCQContractWarningStatuses] ([QContractWarningStatusID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_RenewalCycleID_SCBillingCycles] FOREIGN KEY ([RenewalCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_ReportDefinitionGroupID_RPReportDefinitionGroups] FOREIGN KEY ([ReportDefinitionGroupID]) REFERENCES [dbo].[RPReportDefinitionGroups] ([ReportDefinitionGroupID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_SalesRepID_ARSalesReps] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ARSalesReps] ([SalesRepID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_ServiceHourCodeID_SHServiceHourCodes] FOREIGN KEY ([ServiceHourCodeID]) REFERENCES [dbo].[SHServiceHourCodes] ([ServiceHourCodeID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_TaxExemptCodeID_SHTaxExemptCodes] FOREIGN KEY ([TaxExemptCodeID]) REFERENCES [dbo].[SHTaxExemptCodes] ([TaxExemptCodeID])
GO
ALTER TABLE [dbo].[SCQContracts] ADD CONSTRAINT [FK_SCQContracts_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO