Tables [dbo].[SCContractDetails]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:53 AM Thursday, March 21, 2019
Last Modified1:15:59 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Foreign Keys FK_SCContractDetails_ContractID_SCContracts: [dbo].[SCContracts].ContractIDContractIDint4
False
Foreign Keys FK_SCContractDetails_EquipmentID_SCEquipments: [dbo].[SCEquipments].EquipmentIDEquipmentIDint4
True
BaseRatemoney8
True
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
Foreign Keys FK_SCContractDetails_BillCodeID_SCBillCodes: [dbo].[SCBillCodes].BillCodeIDBillCodeIDint4
True
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
UseContractLeasebit1
False
((0))
Cluster Primary Key PK_SCContractDetails: ContractDetailIDContractDetailIDint4
False
1 - 1
Foreign Keys FK_SCContractDetails_StartMeterReadingGroupID_MTMeterReadingGroups: [dbo].[MTMeterReadingGroups].StartMeterReadingGroupIDStartMeterReadingGroupIDint4
True
StartDatedatetime8
True
EndDatedatetime8
True
StartMeterReadingDatedatetime8
True
EndMeterReadingDatedatetime8
True
BaseBilledThruDatedatetime8
True
OverageBilledThruDatedatetime8
True
BaseAccruedThruDatedatetime8
True
ProrateStartbit1
False
((0))
ProrateStartAmountmoney8
False
((0))
ProrateStartBillNowbit1
False
((0))
ProrateEndbit1
False
((0))
ProrateEndAmountmoney8
False
((0))
ProrateEndBillNowbit1
False
((0))
Foreign Keys FK_SCContractDetails_EndMeterReadingGroupID_MTMeterReadingGroups: [dbo].[MTMeterReadingGroups].EndMeterReadingGroupIDEndMeterReadingGroupIDint4
True
Foreign Keys FK_SCContractDetails_LocationID_ARCustomers: [dbo].[ARCustomers].LocationIDLocationIDint4
False
SyncLocationAddressbit1
False
((0))
Addressvarchar(64)64
False
('')
Cityvarchar(32)32
False
('')
Statevarchar(16)16
False
('')
Zipvarchar(16)16
False
('')
Countryvarchar(16)16
False
('')
NextBaseIncreaseDatedatetime8
True
NextBaseScheduleDetailIDint4
True
UnEarnedBalancemoney8
False
((0))
ProrateStartAutoCalcbit1
False
((1))
ProrateEndAutoCalcbit1
False
((1))
BaseRateScheduleStartDateTypeint4
True
BaseRateScheduleStartDatedatetime8
True
BaseRateScheduleIsRenewalTypebit1
True
((0))
Foreign Keys FK_SCContractDetails_TaxCodeID_ShTaxCodes: [dbo].[ShTaxCodes].TaxCodeIDTaxCodeIDint4
True
Foreign Keys FK_SCContractDetails_TerminationCodeID_SCTerminationCodes: [dbo].[SCTerminationCodes].TerminationCodeIDTerminationCodeIDint4
True
Foreign Keys FK_SCContractDetails_NoteID_SCContractDetailNotes: [dbo].[SCContractDetailNotes].NoteIDNoteIDint4
True
NoteFlagint4
False
((0))
Quantitydecimal(18,6)9
False
((1))
UnitBaseRatemoney8
False
((0))
Foreign Keys FK_SCContractDetails_BaseDistributionCodeID_SCContractBaseDistCodes: [dbo].[SCContractBaseDistCodes].BaseDistributionCodeIDBaseDistributionCodeIDint4
True
NoteCountint4
False
((0))
Foreign Keys FK_SCContractDetails_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
Foreign Keys FK_SCContractDetails_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_SCContractDetails_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
Foreign Keys FK_SCContractDetails_LeaseBalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].LeaseBalanceSheetGroupIDLeaseBalanceSheetGroupIDint4
True
BillStartDatedatetime8
True
BillEndDatedatetime8
True
BaseBillingCycledThruDatedatetime8
True
BaseAccrualCycledThruDatedatetime8
True
BaseBilledThruDateInitialdatetime8
True
OverageBilledThruDateInitialdatetime8
True
BaseAccruedThruDateInitialdatetime8
True
Foreign Keys FK_SCContractDetails_ParentContractDetailID_SCContractDetails: [dbo].[SCContractDetails].ParentContractDetailIDParentContractDetailIDint4
True
Foreign Keys FK_SCContractDetails_ContractDetailTypeID_SCContractDetailTypes: [dbo].[SCContractDetailTypes].ContractDetailTypeIDContractDetailTypeIDint4
False
((1))
SubLeaseNumbervarchar(15)15
True
SubLeaseMajorvarchar(10)10
True
SubLeaseMinorvarchar(4)4
True
LeaseTermint4
True
LeasePaymentStartDatedatetime8
True
LeasePaymentEndDatedatetime8
True
LeaseRatemoney8
True
LeaseRateFactordecimal(18,6)9
True
LeaseInterestRatedecimal(18,6)9
True
LeaseFinancedAmountmoney8
True
LeasePaymentAmountmoney8
True
LeasePrincipalBalancemoney8
True
CombineWithParentBaseAmountbit1
False
((0))
UnearnedInterestBalancemoney8
False
((0))
UnearnedLeaseBalancemoney8
False
((0))
UnearnedLeasePostTermBalancemoney8
False
((0))
DetailInstancedecimal(18,6)9
False
((0))
Foreign Keys FK_SCContractDetails_LeaseTerminationCodeID_SCLeaseTerminationCodes: [dbo].[SCLeaseTerminationCodes].LeaseTerminationCodeIDLeaseTerminationCodeIDint4
True
AssetNumbervarchar(32)32
False
('')
Foreign Keys FK_SCContractDetails_TaxExemptCodeID_SHTaxExemptCodes: [dbo].[SHTaxExemptCodes].TaxExemptCodeIDTaxExemptCodeIDint4
True
Taxablebit1
False
((0))
OverrideTaxablebit1
False
((0))
Foreign Keys FK_SCContractDetails_ItemID_ICItems: [dbo].[ICItems].ItemIDItemIDint4
True
Descriptionvarchar(255)255
False
('')
LocationRemarksvarchar(255)255
False
('')
Foreign Keys FK_SCContractDetails_ContractLeaseDetailID_SCContractLeaseDetails: [dbo].[SCContractLeaseDetails].ContractLeaseDetailIDContractLeaseDetailIDint4
True
Foreign Keys FK_SCContractDetails_SLACodeID_SCSLACodes: [dbo].[SCSLACodes].SLACodeIDSLACodeIDint4
True
Foreign Keys SCContractDetails_FKC_ShTrackingConfigID_SHTrackingConfigs: [dbo].[ShTrackingConfigs].ShTrackingConfigIDShTrackingConfigIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCContractDetails: ContractDetailIDPK_SCContractDetailsContractDetailID
True
80
NameColumns
FK_SCContractDetails_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCContractDetails_BaseDistributionCodeID_SCContractBaseDistCodesBaseDistributionCodeID->[dbo].[SCContractBaseDistCodes].[BaseDistributionCodeID]
FK_SCContractDetails_BillCodeID_SCBillCodesBillCodeID->[dbo].[SCBillCodes].[BillCodeID]
FK_SCContractDetails_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SCContractDetails_ContractDetailTypeID_SCContractDetailTypesContractDetailTypeID->[dbo].[SCContractDetailTypes].[ContractDetailTypeID]
FK_SCContractDetails_ContractID_SCContractsContractID->[dbo].[SCContracts].[ContractID]
FK_SCContractDetails_ContractLeaseDetailID_SCContractLeaseDetailsContractLeaseDetailID->[dbo].[SCContractLeaseDetails].[ContractLeaseDetailID]
FK_SCContractDetails_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCContractDetails_EndMeterReadingGroupID_MTMeterReadingGroupsEndMeterReadingGroupID->[dbo].[MTMeterReadingGroups].[MeterReadingGroupID]
FK_SCContractDetails_EquipmentID_SCEquipmentsEquipmentID->[dbo].[SCEquipments].[EquipmentID]
FK_SCContractDetails_ItemID_ICItemsItemID->[dbo].[ICItems].[ItemID]
FK_SCContractDetails_LeaseBalanceSheetGroupID_GLBalanceSheetGroupsLeaseBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCContractDetails_LeaseTerminationCodeID_SCLeaseTerminationCodesLeaseTerminationCodeID->[dbo].[SCLeaseTerminationCodes].[LeaseTerminationCodeID]
FK_SCContractDetails_LocationID_ARCustomersLocationID->[dbo].[ARCustomers].[CustomerID]
FK_SCContractDetails_NoteID_SCContractDetailNotesNoteID->[dbo].[SCContractDetailNotes].[NoteID]
FK_SCContractDetails_ParentContractDetailID_SCContractDetailsParentContractDetailID->[dbo].[SCContractDetails].[ContractDetailID]
FK_SCContractDetails_SLACodeID_SCSLACodesSLACodeID->[dbo].[SCSLACodes].[SLACodeID]
FK_SCContractDetails_StartMeterReadingGroupID_MTMeterReadingGroupsStartMeterReadingGroupID->[dbo].[MTMeterReadingGroups].[MeterReadingGroupID]
FK_SCContractDetails_TaxCodeID_ShTaxCodesTaxCodeID->[dbo].[ShTaxCodes].[TaxCodeID]
FK_SCContractDetails_TaxExemptCodeID_SHTaxExemptCodesTaxExemptCodeID->[dbo].[SHTaxExemptCodes].[TaxExemptCodeID]
FK_SCContractDetails_TerminationCodeID_SCTerminationCodesTerminationCodeID->[dbo].[SCTerminationCodes].[TerminationCodeID]
SCContractDetails_FKC_ShTrackingConfigID_SHTrackingConfigsShTrackingConfigID->[dbo].[ShTrackingConfigs].[ShTrackingConfigID]
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