Tables [dbo].[SCQBillingContracts]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:44 AM Thursday, March 21, 2019
Last Modified1:15:18 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_SCQBillingContracts: BillingID\ContractDetailIDForeign Keys FK_SCQBillingContracts_BillingID_SCQBillings: [dbo].[SCQBillings].BillingIDBillingIDint4
False
Cluster Primary Key PK_SCQBillingContracts: BillingID\ContractDetailIDContractDetailIDint4
False
Foreign Keys FK_SCQBillingContracts_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_SCQBillingContracts_MiscChargeGLID_GLAccounts5: [dbo].[GLAccounts5].MiscChargeGLIDMiscChargeGLIDint4
True
Foreign Keys FK_SCQBillingContracts_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
AccumulatedCopiesint4
True
Statuschar(1)1
True
StatusMsgvarchar(1024)1024
True
ProrateBillNowbit1
False
((0))
NextBaseAmountmoney8
True
CurNonAdjustedBaseAmountmoney8
True
NextBaseMethodint4
True
NextBaseRateIncreaseValuedecimal(16,6)9
True
NextBaseRoundNoDigitsint4
True
NextOvgMethodint4
True
NextOvgRateIncreaseValuedecimal(16,6)9
True
NextOvgRoundNoDigitsint4
True
BillingContractIDint4
False
1 - 1
ContractAdjCodeIDint4
True
ContractAdjDescriptionvarchar(50)50
False
('')
ContractAdjBaseAmountmoney8
False
((0))
ContractAdjBaseTaxFlagint4
False
((0))
ContractAdjOverageAmountmoney8
False
((0))
ContractAdjOverageTaxFlagint4
False
((0))
OverrideWarningsbit1
False
((0))
UseIndividualTaxCodesbit1
False
((0))
Foreign Keys FK_SCQBillingContracts_TaxCodeID_ShTaxCodes: [dbo].[ShTaxCodes].TaxCodeIDTaxCodeIDint4
True
DiscAmountmoney8
False
((0))
Foreign Keys FK_SCQBillingContracts_ContractStatusID_SCContractStatuses: [dbo].[SCContractStatuses].ContractStatusIDContractStatusIDint4
False
((6))
MiscChargeBillCycleFlagint4
False
((3))
LeaseUseIndividualTaxCodesbit1
False
((0))
LeaseSumIndividualAmountsbit1
False
((0))
PONumbervarchar(64)64
False
('')
NextMGBaseMethodint4
True
NextMGBaseRateIncreaseValuedecimal(16,6)9
True
NextMGBaseRoundNoDigitsint4
True
MGBaseAmountmoney8
True
NextMGBaseAmountmoney8
True
NonAdjustedBaseLastBillingDatedatetime8
True
NonAdjustedBaseNextBillingDatedatetime8
True
NonAdjustedOverageLastBillingDatedatetime8
True
NonAdjustedOverageNextBillingDatedatetime8
True
BaseCyclesBilledint4
False
OverageCyclesBilledint4
False
BaseDistCodeIDint4
True
NextBaseIncreaseDatedatetime8
True
NextBaseScheduleDetailIDint4
True
NextMGBaseIncreaseDatedatetime8
True
NextMGBaseScheduleDetailIDint4
True
NextOvgIncreaseDatedatetime8
True
NextOvgScheduleDetailIDint4
True
BaseBillingTypeIDint4
False
((1))
MiscChargeDescriptionBaseOnlyvarchar(255)255
False
('')
Foreign Keys FK_SCQBillingContracts_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_SCQBillingContracts_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
Foreign Keys FK_SCQBillingContracts_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
Foreign Keys FK_SCQBillingContracts_LeaseDivisionID_GLDivisions: [dbo].[GLDivisions].LeaseDivisionIDLeaseDivisionIDint4
False
Foreign Keys FK_SCQBillingContracts_LeaseBalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].LeaseBalanceSheetGroupIDLeaseBalanceSheetGroupIDint4
False
Foreign Keys FK_SCQBillingContracts_ContractAdjBaseGLID_GLAccounts: [dbo].[GLAccounts].ContractAdjBaseGLIDContractAdjBaseGLIDint4
True
Foreign Keys FK_SCQBillingContracts_ContractAdjBaseDeptID_GLDepts: [dbo].[GLDepts].ContractAdjBaseDeptIDContractAdjBaseDeptIDint4
True
Foreign Keys FK_SCQBillingContracts_ContractAdjOverageGLID_GLAccounts: [dbo].[GLAccounts].ContractAdjOverageGLIDContractAdjOverageGLIDint4
True
Foreign Keys FK_SCQBillingContracts_ContractAdjOverageDeptID_GLDepts: [dbo].[GLDepts].ContractAdjOverageDeptIDContractAdjOverageDeptIDint4
True
Accrualbit1
False
ExpCopiesdecimal(18,0)9
True
((0))
OuterMinCutoffDatedatetime8
True
BaseRatePeriodint4
True
NonAdjustedBaseBillingStartDatedatetime8
True
NonAdjustedOverageBillingStartDatedatetime8
True
BaseRatePeriodTypeint4
False
((1))
AllBaseCyclesBilleddecimal(18,6)9
False
((0))
Foreign Keys FK_SCQBillingContracts_ExtendedTypeID_SCExtendedContractTypes: [dbo].[SCExtendedContractTypes].ExtendedTypeIDExtendedTypeIDint4
True
ProrateBillNowOveragesbit1
False
((0))
Messagevarchar(255)255
False
('')
MessageAcknowledgeFlagint4
False
((0))
Foreign Keys FK_SCQBillingContracts_TaxExemptCodeID_SHTaxExemptCodes: [dbo].[SHTaxExemptCodes].TaxExemptCodeIDTaxExemptCodeIDint4
True
Taxablebit1
False
((0))
BaseEarnedAmountmoney8
False
((0))
DiscountEarnedAmountmoney8
False
((0))
Foreign Keys FK_SCQBillingContracts_MiscChargeTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].MiscChargeTaxFlagIDMiscChargeTaxFlagIDint4
False
Foreign Keys FK_SCQBillingContracts_ContractAdjBaseTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].ContractAdjBaseTaxFlagIDContractAdjBaseTaxFlagIDint4
False
((1))
Foreign Keys FK_SCQBillingContracts_ContractAdjOverageTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].ContractAdjOverageTaxFlagIDContractAdjOverageTaxFlagIDint4
False
((1))
Foreign Keys FK_SCQBillingContracts_LeaseTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].LeaseTaxFlagIDLeaseTaxFlagIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCQBillingContracts: BillingID\ContractDetailIDPK_SCQBillingContractsBillingID, ContractDetailID
True
80
NameColumns
FK_SCQBillingContracts_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCQBillingContracts_BillingID_SCQBillingsBillingID->[dbo].[SCQBillings].[BillingID]
FK_SCQBillingContracts_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SCQBillingContracts_ContractAdjBaseDeptID_GLDeptsContractAdjBaseDeptID->[dbo].[GLDepts].[DeptID]
FK_SCQBillingContracts_ContractAdjBaseGLID_GLAccountsContractAdjBaseGLID->[dbo].[GLAccounts].[AccountID]
FK_SCQBillingContracts_ContractAdjBaseTaxFlagID_ShTaxFlagsContractAdjBaseTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCQBillingContracts_ContractAdjOverageDeptID_GLDeptsContractAdjOverageDeptID->[dbo].[GLDepts].[DeptID]
FK_SCQBillingContracts_ContractAdjOverageGLID_GLAccountsContractAdjOverageGLID->[dbo].[GLAccounts].[AccountID]
FK_SCQBillingContracts_ContractAdjOverageTaxFlagID_ShTaxFlagsContractAdjOverageTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCQBillingContracts_ContractID_SCContractsContractID->[dbo].[SCContracts].[ContractID]
FK_SCQBillingContracts_ContractStatusID_SCContractStatusesContractStatusID->[dbo].[SCContractStatuses].[ContractStatusID]
FK_SCQBillingContracts_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCQBillingContracts_ExtendedTypeID_SCExtendedContractTypesExtendedTypeID->[dbo].[SCExtendedContractTypes].[ExtendedContractTypeID]
FK_SCQBillingContracts_LeaseBalanceSheetGroupID_GLBalanceSheetGroupsLeaseBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCQBillingContracts_LeaseDivisionID_GLDivisionsLeaseDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCQBillingContracts_LeaseTaxFlagID_ShTaxFlagsLeaseTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCQBillingContracts_MiscChargeDeptID_GLDepts5MiscChargeDeptID->[dbo].[GLDepts5].[DeptID]
FK_SCQBillingContracts_MiscChargeGLID_GLAccounts5MiscChargeGLID->[dbo].[GLAccounts5].[AccountID]
FK_SCQBillingContracts_MiscChargeTaxFlagID_ShTaxFlagsMiscChargeTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCQBillingContracts_TaxCodeID_ShTaxCodesTaxCodeID->[dbo].[ShTaxCodes].[TaxCodeID]
FK_SCQBillingContracts_TaxExemptCodeID_SHTaxExemptCodesTaxExemptCodeID->[dbo].[SHTaxExemptCodes].[TaxExemptCodeID]
CREATE TABLE [dbo].[SCQBillingContracts]
(
[BillingID] [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_SCQBillingContracts_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCQBillingContracts_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[LeaseAmount] [money] NULL,
[LeaseTaxFlag] [int] NULL,
[LeaseGLID] [int] NULL,
[LeaseDeptID] [int] NULL,
[AccumulatedCopies] [int] NULL,
[Status] [char] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[StatusMsg] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ProrateBillNow] [bit] NOT NULL CONSTRAINT [DF_SCQBillingContracts_ProrateBillNow] DEFAULT ((0)),
[NextBaseAmount] [money] NULL,
[CurNonAdjustedBaseAmount] [money] NULL,
[NextBaseMethod] [int] NULL,
[NextBaseRateIncreaseValue] [decimal] (16, 6) NULL,
[NextBaseRoundNoDigits] [int] NULL,
[NextOvgMethod] [int] NULL,
[NextOvgRateIncreaseValue] [decimal] (16, 6) NULL,
[NextOvgRoundNoDigits] [int] NULL,
[BillingContractID] [int] NOT NULL IDENTITY(1, 1),
[ContractAdjCodeID] [int] NULL,
[ContractAdjDescription] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQBillingContracts_ContractAdjDescription] DEFAULT (''),
[ContractAdjBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingContracts_ContractAdjBaseAmount] DEFAULT ((0)),
[ContractAdjBaseTaxFlag] [int] NOT NULL CONSTRAINT [DF_SCQBillingContracts_ContractAdjBaseTaxFlag] DEFAULT ((0)),
[ContractAdjOverageAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingContracts_ContractAdjOverageAmount] DEFAULT ((0)),
[ContractAdjOverageTaxFlag] [int] NOT NULL CONSTRAINT [DF_SCQBillingContracts_ContractAdjOverageTaxFlag] DEFAULT ((0)),
[OverrideWarnings] [bit] NOT NULL CONSTRAINT [DF_SCQBillingContracts_OverrideWarnings] DEFAULT ((0)),
[UseIndividualTaxCodes] [bit] NOT NULL CONSTRAINT [DF_SCQBillingContracts_UseIndividualTaxCodes] DEFAULT ((0)),
[TaxCodeID] [int] NULL,
[DiscAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingContracts_DiscAmount] DEFAULT ((0)),
[ContractStatusID] [int] NOT NULL CONSTRAINT [DF_SCQBillingContracts_ContractStatusID] DEFAULT ((6)),
[MiscChargeBillCycleFlag] [int] NOT NULL CONSTRAINT [DF_SCQBillingContracts_MiscChargeBillCycleFlag] DEFAULT ((3)),
[LeaseUseIndividualTaxCodes] [bit] NOT NULL CONSTRAINT [DF_SCQBillingContracts_LeaseUseIndividualTaxCodes] DEFAULT ((0)),
[LeaseSumIndividualAmounts] [bit] NOT NULL CONSTRAINT [DF_SCQBillingContracts_LeaseSumIndividualAmounts] DEFAULT ((0)),
[PONumber] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQBillingContracts_PONumber] DEFAULT (''),
[NextMGBaseMethod] [int] NULL,
[NextMGBaseRateIncreaseValue] [decimal] (16, 6) NULL,
[NextMGBaseRoundNoDigits] [int] NULL,
[MGBaseAmount] [money] NULL,
[NextMGBaseAmount] [money] NULL,
[NonAdjustedBaseLastBillingDate] [datetime] NULL,
[NonAdjustedBaseNextBillingDate] [datetime] NULL,
[NonAdjustedOverageLastBillingDate] [datetime] NULL,
[NonAdjustedOverageNextBillingDate] [datetime] NULL,
[BaseCyclesBilled] [int] NOT NULL,
[OverageCyclesBilled] [int] NOT NULL,
[BaseDistCodeID] [int] NULL,
[NextBaseIncreaseDate] [datetime] NULL,
[NextBaseScheduleDetailID] [int] NULL,
[NextMGBaseIncreaseDate] [datetime] NULL,
[NextMGBaseScheduleDetailID] [int] NULL,
[NextOvgIncreaseDate] [datetime] NULL,
[NextOvgScheduleDetailID] [int] NULL,
[BaseBillingTypeID] [int] NOT NULL CONSTRAINT [DF_SCQBillingContracts_BaseBillingTypeID] DEFAULT ((1)),
[MiscChargeDescriptionBaseOnly] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQBillingContracts_MiscChargeDescriptionBaseOnly] DEFAULT (''),
[BranchID] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[LeaseDivisionID] [int] NOT NULL,
[LeaseBalanceSheetGroupID] [int] NOT NULL,
[ContractAdjBaseGLID] [int] NULL,
[ContractAdjBaseDeptID] [int] NULL,
[ContractAdjOverageGLID] [int] NULL,
[ContractAdjOverageDeptID] [int] NULL,
[Accrual] [bit] NOT NULL,
[ExpCopies] [decimal] (18, 0) NULL CONSTRAINT [DF_SCQBillingContracts_ExpCopies] DEFAULT ((0)),
[OuterMinCutoffDate] [datetime] NULL,
[BaseRatePeriod] [int] NULL,
[NonAdjustedBaseBillingStartDate] [datetime] NULL,
[NonAdjustedOverageBillingStartDate] [datetime] NULL,
[BaseRatePeriodType] [int] NOT NULL CONSTRAINT [DF_SCQBillingContracts_BaseRatePeriodType] DEFAULT ((1)),
[AllBaseCyclesBilled] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCQBillingContracts_AllBaseCyclesBilled] DEFAULT ((0)),
[ExtendedTypeID] [int] NULL,
[ProrateBillNowOverages] [bit] NOT NULL CONSTRAINT [DF_SCQBillingContracts_ProrateBillNowOverages] DEFAULT ((0)),
[Message] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCQBillingcontracts_Message] DEFAULT (''),
[MessageAcknowledgeFlag] [int] NOT NULL CONSTRAINT [DF_SCQBillingcontracts_MessageAcknowledgeFlag] DEFAULT ((0)),
[TaxExemptCodeID] [int] NULL,
[Taxable] [bit] NOT NULL CONSTRAINT [DF_SCQBillingContracts_Taxable] DEFAULT ((0)),
[BaseEarnedAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingContracts_BaseEarnedAmount] DEFAULT ((0)),
[DiscountEarnedAmount] [money] NOT NULL CONSTRAINT [DF_SCQBillingContracts_DiscountEarnedAmount] DEFAULT ((0)),
[MiscChargeTaxFlagID] [int] NOT NULL,
[ContractAdjBaseTaxFlagID] [int] NOT NULL CONSTRAINT [DF_SCQBillingContracts_ContractAdjBaseTaxFlagID] DEFAULT ((1)),
[ContractAdjOverageTaxFlagID] [int] NOT NULL CONSTRAINT [DF_SCQBillingContracts_ContractAdjOverageTaxFlagID] DEFAULT ((1)),
[LeaseTaxFlagID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [PK_SCQBillingContracts] PRIMARY KEY CLUSTERED  ([BillingID], [ContractDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_BillingID_SCQBillings] FOREIGN KEY ([BillingID]) REFERENCES [dbo].[SCQBillings] ([BillingID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_ContractAdjBaseDeptID_GLDepts] FOREIGN KEY ([ContractAdjBaseDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_ContractAdjBaseGLID_GLAccounts] FOREIGN KEY ([ContractAdjBaseGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_ContractAdjBaseTaxFlagID_ShTaxFlags] FOREIGN KEY ([ContractAdjBaseTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_ContractAdjOverageDeptID_GLDepts] FOREIGN KEY ([ContractAdjOverageDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_ContractAdjOverageGLID_GLAccounts] FOREIGN KEY ([ContractAdjOverageGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_ContractAdjOverageTaxFlagID_ShTaxFlags] FOREIGN KEY ([ContractAdjOverageTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_ContractStatusID_SCContractStatuses] FOREIGN KEY ([ContractStatusID]) REFERENCES [dbo].[SCContractStatuses] ([ContractStatusID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_ExtendedTypeID_SCExtendedContractTypes] FOREIGN KEY ([ExtendedTypeID]) REFERENCES [dbo].[SCExtendedContractTypes] ([ExtendedContractTypeID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_LeaseBalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([LeaseBalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_LeaseDivisionID_GLDivisions] FOREIGN KEY ([LeaseDivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_LeaseTaxFlagID_ShTaxFlags] FOREIGN KEY ([LeaseTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_MiscChargeDeptID_GLDepts5] FOREIGN KEY ([MiscChargeDeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_MiscChargeGLID_GLAccounts5] FOREIGN KEY ([MiscChargeGLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_MiscChargeTaxFlagID_ShTaxFlags] FOREIGN KEY ([MiscChargeTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SCQBillingContracts] ADD CONSTRAINT [FK_SCQBillingContracts_TaxExemptCodeID_SHTaxExemptCodes] FOREIGN KEY ([TaxExemptCodeID]) REFERENCES [dbo].[SHTaxExemptCodes] ([TaxExemptCodeID])
GO