Tables [dbo].[SCBillingContracts]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:41 AM Thursday, March 21, 2019
Last Modified1:14:43 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SCBillingContracts: InvoiceID\ContractDetailIDForeign Keys FK_SCBillingContracts_InvoiceID_SCBillings: [dbo].[SCBillings].InvoiceIDInvoiceIDint4
False
Cluster Primary Key PK_SCBillingContracts: InvoiceID\ContractDetailIDContractDetailIDint4
False
Foreign Keys FK_SCBillingContracts_ContractID_SCContracts: [dbo].[SCContracts].ContractIDContractIDint4
False
BaseFromDatedatetime8
True
BaseToDatedatetime8
True
SumIndividualBaseRatesbit1
False
BaseAmountmoney8
False
OverageFromDatedatetime8
True
OverageToDatedatetime8
True
Copiesint4
False
OverageAmountmoney8
True
BillForServicesbit1
False
MinimumBalancemoney8
True
MinimumBillingmoney8
True
UnearnedBalancemoney8
True
MiscChargeAmountmoney8
False
MiscChargeTaxFlagint4
False
MiscChargeDescriptionvarchar(255)255
False
Foreign Keys FK_SCBillingContracts_MiscChargeGLID_GLAccounts5: [dbo].[GLAccounts5].MiscChargeGLIDMiscChargeGLIDint4
True
Foreign Keys FK_SCBillingContracts_MiscChargeDeptID_GLDepts5: [dbo].[GLDepts5].MiscChargeDeptIDMiscChargeDeptIDint4
True
MiscContinuousbit1
False
Amountmoney8
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
LeaseAmountmoney8
True
LeaseTaxFlagint4
True
LeaseGLIDint4
True
LeaseDeptIDint4
True
Foreign Keys FK_SCBillingContracts_SalesRepID_ShAgents: [dbo].[ShAgents].SalesRepIDSalesRepIDint4
True
Foreign Keys FK_SCBillingContracts_JobID_ICJobs: [dbo].[ICJobs].JobIDJobIDint4
True
AccumulatedCopiesint4
True
Voidbit1
False
((0))
ProrateBillNowbit1
False
((0))
NextBaseAmountmoney8
True
CurNonAdjustedBaseAmountmoney8
True
NextBaseUpdatedbit1
True
NextOvgUpdatedbit1
True
Foreign Keys FK_SCBillingContracts_BaseBillingCycleID_SCBillingCycles: [dbo].[SCBillingCycles].BaseBillingCycleIDBaseBillingCycleIDint4
True
Foreign Keys FK_SCBillingContracts_OverageBillingCycleID_SCBillingCycles: [dbo].[SCBillingCycles].OverageBillingCycleIDOverageBillingCycleIDint4
True
ContractAdjDescriptionvarchar(50)50
False
('')
ContractAdjBaseAmountmoney8
False
((0))
ContractAdjBaseGLIDint4
True
ContractAdjBaseDeptIDint4
True
ContractAdjBaseTaxFlagint4
False
((0))
ContractAdjOverageAmountmoney8
False
((0))
ContractAdjOverageGLIDint4
True
ContractAdjOverageDeptIDint4
True
ContractAdjOverageTaxFlagint4
False
((0))
UseIndividualTaxCodesbit1
False
((0))
Foreign Keys FK_SCBillingContracts_TaxCodeID_ShTaxCodes: [dbo].[ShTaxCodes].TaxCodeIDTaxCodeIDint4
True
DiscAmountmoney8
False
((0))
Foreign Keys FK_SCBillingContracts_PrevContractStatusID_SCContractStatuses: [dbo].[SCContractStatuses].PrevContractStatusIDPrevContractStatusIDint4
False
((6))
Foreign Keys FK_SCBillingContracts_ContractStatusID_SCContractStatuses: [dbo].[SCContractStatuses].ContractStatusIDContractStatusIDint4
False
((6))
Remarksvarchar(1024)1024
False
('')
MiscChargeBillCycleFlagint4
False
((3))
LeaseUseIndividualTaxCodesbit1
False
((0))
LeaseSumIndividualAmountsbit1
False
((0))
PONumbervarchar(64)64
False
('')
VoidFlagint4
False
((0))
NextMGBaseUpdatedbit1
True
MGBaseAmountmoney8
True
NonAdjustedBaseLastBillingDatedatetime8
True
NonAdjustedBaseNextBillingDatedatetime8
True
NonAdjustedOverageLastBillingDatedatetime8
True
NonAdjustedOverageNextBillingDatedatetime8
True
BaseCyclesBilledint4
False
OverageCyclesBilledint4
False
BaseBillingTypeIDint4
False
((1))
Foreign Keys FK_SCBillingContracts_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_SCBillingContracts_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
Foreign Keys FK_SCBillingContracts_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
Foreign Keys FK_SCBillingContracts_LeaseDivisionID_GLDivisions: [dbo].[GLDivisions].LeaseDivisionIDLeaseDivisionIDint4
False
Foreign Keys FK_SCBillingContracts_LeaseBalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].LeaseBalanceSheetGroupIDLeaseBalanceSheetGroupIDint4
False
Accrualbit1
False
ExpCopiesdecimal(18,0)9
True
((0))
BaseRatePeriodint4
True
NonAdjustedBaseBillingStartDatedatetime8
True
NonAdjustedOverageBillingStartDatedatetime8
True
BaseRatePeriodTypeint4
False
((1))
Foreign Keys FK_SCBillingContracts_ExtendedTypeID_SCExtendedContractTypes: [dbo].[SCExtendedContractTypes].ExtendedTypeIDExtendedTypeIDint4
True
ProrateBillNowOveragesbit1
False
((0))
Foreign Keys FK_SCBillingContracts_TaxExemptCodeID_SHTaxExemptCodes: [dbo].[SHTaxExemptCodes].TaxExemptCodeIDTaxExemptCodeIDint4
True
Taxablebit1
False
((0))
BaseEarnedAmountmoney8
False
((0))
DiscountEarnedAmountmoney8
False
((0))
Foreign Keys FK_SCBillingContracts_MiscChargeTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].MiscChargeTaxFlagIDMiscChargeTaxFlagIDint4
False
Foreign Keys FK_SCBillingContracts_ContractAdjBaseTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].ContractAdjBaseTaxFlagIDContractAdjBaseTaxFlagIDint4
False
((1))
Foreign Keys FK_SCBillingContracts_ContractAdjOverageTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].ContractAdjOverageTaxFlagIDContractAdjOverageTaxFlagIDint4
False
((1))
Foreign Keys FK_SCBillingContracts_LeaseTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].LeaseTaxFlagIDLeaseTaxFlagIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCBillingContracts: InvoiceID\ContractDetailIDPK_SCBillingContractsInvoiceID, ContractDetailID
True
80
NameColumns
FK_SCBillingContracts_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCBillingContracts_BaseBillingCycleID_SCBillingCyclesBaseBillingCycleID->[dbo].[SCBillingCycles].[BillingCycleID]
FK_SCBillingContracts_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SCBillingContracts_ContractAdjBaseTaxFlagID_ShTaxFlagsContractAdjBaseTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCBillingContracts_ContractAdjOverageTaxFlagID_ShTaxFlagsContractAdjOverageTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCBillingContracts_ContractID_SCContractsContractID->[dbo].[SCContracts].[ContractID]
FK_SCBillingContracts_ContractStatusID_SCContractStatusesContractStatusID->[dbo].[SCContractStatuses].[ContractStatusID]
FK_SCBillingContracts_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCBillingContracts_ExtendedTypeID_SCExtendedContractTypesExtendedTypeID->[dbo].[SCExtendedContractTypes].[ExtendedContractTypeID]
FK_SCBillingContracts_InvoiceID_SCBillingsInvoiceID->[dbo].[SCBillings].[InvoiceID]
FK_SCBillingContracts_JobID_ICJobsJobID->[dbo].[ICJobs].[JobID]
FK_SCBillingContracts_LeaseBalanceSheetGroupID_GLBalanceSheetGroupsLeaseBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCBillingContracts_LeaseDivisionID_GLDivisionsLeaseDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCBillingContracts_LeaseTaxFlagID_ShTaxFlagsLeaseTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCBillingContracts_MiscChargeDeptID_GLDepts5MiscChargeDeptID->[dbo].[GLDepts5].[DeptID]
FK_SCBillingContracts_MiscChargeGLID_GLAccounts5MiscChargeGLID->[dbo].[GLAccounts5].[AccountID]
FK_SCBillingContracts_MiscChargeTaxFlagID_ShTaxFlagsMiscChargeTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCBillingContracts_OverageBillingCycleID_SCBillingCyclesOverageBillingCycleID->[dbo].[SCBillingCycles].[BillingCycleID]
FK_SCBillingContracts_PrevContractStatusID_SCContractStatusesPrevContractStatusID->[dbo].[SCContractStatuses].[ContractStatusID]
FK_SCBillingContracts_SalesRepID_ShAgentsSalesRepID->[dbo].[ShAgents].[AgentID]
FK_SCBillingContracts_TaxCodeID_ShTaxCodesTaxCodeID->[dbo].[ShTaxCodes].[TaxCodeID]
FK_SCBillingContracts_TaxExemptCodeID_SHTaxExemptCodesTaxExemptCodeID->[dbo].[SHTaxExemptCodes].[TaxExemptCodeID]
CREATE TABLE [dbo].[SCBillingContracts]
(
[InvoiceID] [int] NOT NULL,
[ContractDetailID] [int] NOT NULL,
[ContractID] [int] NOT NULL,
[BaseFromDate] [datetime] NULL,
[BaseToDate] [datetime] NULL,
[SumIndividualBaseRates] [bit] NOT NULL,
[BaseAmount] [money] NOT NULL,
[OverageFromDate] [datetime] NULL,
[OverageToDate] [datetime] NULL,
[Copies] [int] NOT NULL,
[OverageAmount] [money] NULL,
[BillForServices] [bit] NOT NULL,
[MinimumBalance] [money] NULL,
[MinimumBilling] [money] NULL,
[UnearnedBalance] [money] 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,
[Amount] [money] NOT 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_SCBillingContracts_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCBillingContracts_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[LeaseAmount] [money] NULL,
[LeaseTaxFlag] [int] NULL,
[LeaseGLID] [int] NULL,
[LeaseDeptID] [int] NULL,
[SalesRepID] [int] NULL,
[JobID] [int] NULL,
[AccumulatedCopies] [int] NULL,
[Void] [bit] NOT NULL CONSTRAINT [DF_SCBillingContracts_Void] DEFAULT ((0)),
[ProrateBillNow] [bit] NOT NULL CONSTRAINT [DF_SCBillingContracts_ProrateBillNow] DEFAULT ((0)),
[NextBaseAmount] [money] NULL,
[CurNonAdjustedBaseAmount] [money] NULL,
[NextBaseUpdated] [bit] NULL,
[NextOvgUpdated] [bit] NULL,
[BaseBillingCycleID] [int] NULL,
[OverageBillingCycleID] [int] NULL,
[ContractAdjDescription] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCBillingContracts_ContractAdjDescription] DEFAULT (''),
[ContractAdjBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingContracts_ContractAdjBaseAmount] DEFAULT ((0)),
[ContractAdjBaseGLID] [int] NULL,
[ContractAdjBaseDeptID] [int] NULL,
[ContractAdjBaseTaxFlag] [int] NOT NULL CONSTRAINT [DF_SCBillingContracts_ContractAdjBaseTaxFlag] DEFAULT ((0)),
[ContractAdjOverageAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingContracts_ContractAdjOverageAmount] DEFAULT ((0)),
[ContractAdjOverageGLID] [int] NULL,
[ContractAdjOverageDeptID] [int] NULL,
[ContractAdjOverageTaxFlag] [int] NOT NULL CONSTRAINT [DF_SCBillingContracts_ContractAdjOverageTaxFlag] DEFAULT ((0)),
[UseIndividualTaxCodes] [bit] NOT NULL CONSTRAINT [DF_SCBillingContracts_UseIndividualTaxCodes] DEFAULT ((0)),
[TaxCodeID] [int] NULL,
[DiscAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingContracts_DiscAmount] DEFAULT ((0)),
[PrevContractStatusID] [int] NOT NULL CONSTRAINT [DF_SCBillingContracts_PrevContractStatusID] DEFAULT ((6)),
[ContractStatusID] [int] NOT NULL CONSTRAINT [DF_SCBillingContracts_ContractStatusID] DEFAULT ((6)),
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCBillingContracts_Remarks] DEFAULT (''),
[MiscChargeBillCycleFlag] [int] NOT NULL CONSTRAINT [DF_SCBillingContracts_MiscChargeBillCycleFlag] DEFAULT ((3)),
[LeaseUseIndividualTaxCodes] [bit] NOT NULL CONSTRAINT [DF_SCBillingContracts_LeaseUseIndividualTaxCodes] DEFAULT ((0)),
[LeaseSumIndividualAmounts] [bit] NOT NULL CONSTRAINT [DF_SCBillingContracts_LeaseSumIndividualAmounts] DEFAULT ((0)),
[PONumber] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCBillingContracts_PONumber] DEFAULT (''),
[VoidFlag] [int] NOT NULL CONSTRAINT [DF_SCBillingContracts_VoidFlag] DEFAULT ((0)),
[NextMGBaseUpdated] [bit] NULL,
[MGBaseAmount] [money] NULL,
[NonAdjustedBaseLastBillingDate] [datetime] NULL,
[NonAdjustedBaseNextBillingDate] [datetime] NULL,
[NonAdjustedOverageLastBillingDate] [datetime] NULL,
[NonAdjustedOverageNextBillingDate] [datetime] NULL,
[BaseCyclesBilled] [int] NOT NULL,
[OverageCyclesBilled] [int] NOT NULL,
[BaseBillingTypeID] [int] NOT NULL CONSTRAINT [DF_SCBillingContracts_BaseBillingTypeID] DEFAULT ((1)),
[BranchID] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[LeaseDivisionID] [int] NOT NULL,
[LeaseBalanceSheetGroupID] [int] NOT NULL,
[Accrual] [bit] NOT NULL,
[ExpCopies] [decimal] (18, 0) NULL CONSTRAINT [DF_SCBillingContracts_ExpCopies] DEFAULT ((0)),
[BaseRatePeriod] [int] NULL,
[NonAdjustedBaseBillingStartDate] [datetime] NULL,
[NonAdjustedOverageBillingStartDate] [datetime] NULL,
[BaseRatePeriodType] [int] NOT NULL CONSTRAINT [DF_SCBillingContracts_BaseRatePeriodType] DEFAULT ((1)),
[ExtendedTypeID] [int] NULL,
[ProrateBillNowOverages] [bit] NOT NULL CONSTRAINT [DF_SCBillingContracts_ProrateBillNowOverages] DEFAULT ((0)),
[TaxExemptCodeID] [int] NULL,
[Taxable] [bit] NOT NULL CONSTRAINT [DF_SCBillingContracts_Taxable] DEFAULT ((0)),
[BaseEarnedAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingContracts_BaseEarnedAmount] DEFAULT ((0)),
[DiscountEarnedAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingContracts_DiscountEarnedAmount] DEFAULT ((0)),
[MiscChargeTaxFlagID] [int] NOT NULL,
[ContractAdjBaseTaxFlagID] [int] NOT NULL CONSTRAINT [DF_SCBillingContracts_ContractAdjBaseTaxFlagID] DEFAULT ((1)),
[ContractAdjOverageTaxFlagID] [int] NOT NULL CONSTRAINT [DF_SCBillingContracts_ContractAdjOverageTaxFlagID] DEFAULT ((1)),
[LeaseTaxFlagID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [PK_SCBillingContracts] PRIMARY KEY CLUSTERED  ([InvoiceID], [ContractDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_BaseBillingCycleID_SCBillingCycles] FOREIGN KEY ([BaseBillingCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_ContractAdjBaseTaxFlagID_ShTaxFlags] FOREIGN KEY ([ContractAdjBaseTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_ContractAdjOverageTaxFlagID_ShTaxFlags] FOREIGN KEY ([ContractAdjOverageTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_ContractStatusID_SCContractStatuses] FOREIGN KEY ([ContractStatusID]) REFERENCES [dbo].[SCContractStatuses] ([ContractStatusID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_ExtendedTypeID_SCExtendedContractTypes] FOREIGN KEY ([ExtendedTypeID]) REFERENCES [dbo].[SCExtendedContractTypes] ([ExtendedContractTypeID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_InvoiceID_SCBillings] FOREIGN KEY ([InvoiceID]) REFERENCES [dbo].[SCBillings] ([InvoiceID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_JobID_ICJobs] FOREIGN KEY ([JobID]) REFERENCES [dbo].[ICJobs] ([JobID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_LeaseBalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([LeaseBalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_LeaseDivisionID_GLDivisions] FOREIGN KEY ([LeaseDivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_LeaseTaxFlagID_ShTaxFlags] FOREIGN KEY ([LeaseTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_MiscChargeDeptID_GLDepts5] FOREIGN KEY ([MiscChargeDeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_MiscChargeGLID_GLAccounts5] FOREIGN KEY ([MiscChargeGLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_MiscChargeTaxFlagID_ShTaxFlags] FOREIGN KEY ([MiscChargeTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_OverageBillingCycleID_SCBillingCycles] FOREIGN KEY ([OverageBillingCycleID]) REFERENCES [dbo].[SCBillingCycles] ([BillingCycleID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_PrevContractStatusID_SCContractStatuses] FOREIGN KEY ([PrevContractStatusID]) REFERENCES [dbo].[SCContractStatuses] ([ContractStatusID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_SalesRepID_ShAgents] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SCBillingContracts] ADD CONSTRAINT [FK_SCBillingContracts_TaxExemptCodeID_SHTaxExemptCodes] FOREIGN KEY ([TaxExemptCodeID]) REFERENCES [dbo].[SHTaxExemptCodes] ([TaxExemptCodeID])
GO