Tables [dbo].[SCContracts]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:55:41 AM Thursday, March 21, 2019
Last Modified1:16:12 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SCContracts: ContractIDContractIDint4
False
ContractNumbervarchar(35)35
False
ContractMajorvarchar(30)30
False
ContractMinorvarchar(4)4
False
Foreign Keys FK_SCContracts_CustomerID_ARCustomers: [dbo].[ARCustomers].CustomerIDCustomerIDint4
False
Contactvarchar(50)50
False
Phonevarchar(30)30
False
Faxvarchar(30)30
False
Foreign Keys FK_SCContracts_BillToID_ARCustomers: [dbo].[ARCustomers].BillToIDBillToIDint4
False
Foreign Keys FK_SCContracts_ContractCodeID_SCContractCodes: [dbo].[SCContractCodes].ContractCodeIDContractCodeIDint4
False
Foreign Keys FK_SCContracts_BillCodeID_SCBillCodes: [dbo].[SCBillCodes].BillCodeIDBillCodeIDint4
False
Foreign Keys FK_SCContracts_BillGroupID_SCContractBillGroups: [dbo].[SCContractBillGroups].BillGroupIDBillGroupIDint4
True
StartDatedatetime8
False
ExpDatedatetime8
True
ExpCopiesint4
True
BaseNextBillingDatedatetime8
True
BaseLastBillingDatedatetime8
True
Foreign Keys FK_SCContracts_BaseBillingCycleID_SCBillingCycles: [dbo].[SCBillingCycles].BaseBillingCycleIDBaseBillingCycleIDint4
True
BaseArrearsbit1
False
BaseNextAccrualDatedatetime8
True
BaseLastAccrualDatedatetime8
True
Foreign Keys FK_SCContracts_BaseAccrualCycleID_SCBillingCycles: [dbo].[SCBillingCycles].BaseAccrualCycleIDBaseAccrualCycleIDint4
True
SumIndividualBaseRatesbit1
False
BaseRatemoney8
False
BaseRatePeriodint4
False
OverageNextBillingDatedatetime8
True
OverageLastBillingDatedatetime8
True
Foreign Keys FK_SCContracts_OverageBillingCycleID_SCBillingCycles: [dbo].[SCBillingCycles].OverageBillingCycleIDOverageBillingCycleIDint4
True
BSABillForServicesbit1
False
BSALaborDiscountfloat8
True
BSAMaterialsDiscountfloat8
True
BSAMinimumBalancemoney8
False
((0))
BSAMinimumBillingmoney8
False
((0))
CoveredCopiesint4
True
LeaseSchedulevarchar(20)20
True
GroupInvoicesbit1
False
PONumbervarchar(32)32
False
MiscChargeAmountmoney8
False
MiscChargeTaxFlagint4
False
MiscChargeDescriptionvarchar(255)255
False
Foreign Keys FK_SCContracts_MiscChargeGLID_GLAccounts5: [dbo].[GLAccounts5].MiscChargeGLIDMiscChargeGLIDint4
True
Foreign Keys FK_SCContracts_MiscChargeDeptID_GLDepts5: [dbo].[GLDepts5].MiscChargeDeptIDMiscChargeDeptIDint4
True
MiscContinuousbit1
False
Remarksvarchar(1024)1024
False
UnearnedBalancemoney8
False
((0))
Billbit1
False
((0))
Activateddatetime8
True
Terminateddatetime8
True
Reneweddatetime8
True
RenewedIDint4
True
Activebit1
False
Locksint4
False
((0))
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
Foreign Keys FK_SCContracts_TaxCodeID_ShTaxCodes: [dbo].[ShTaxCodes].TaxCodeIDTaxCodeIDint4
True
Foreign Keys FK_SCContracts_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_SCContracts_ContractLeaseID_SCContractLeases: [dbo].[SCContractLeases].ContractLeaseIDContractLeaseIDint4
True
Foreign Keys FK_SCContracts_ExtendedTypeID_SCExtendedContractTypes: [dbo].[SCExtendedContractTypes].ExtendedTypeIDExtendedTypeIDint4
False
((1))
Foreign Keys FK_SCContracts_ShTrackingConfigID_ShTrackingConfigs: [dbo].[ShTrackingConfigs].ShTrackingConfigIDShTrackingConfigIDint4
True
UseLeaseOnAllEquipmentbit1
False
((0))
RemarksInternalvarchar(1024)1024
False
('')
Foreign Keys FK_SCContracts_TermID_ShTerms: [dbo].[ShTerms].TermIDTermIDint4
True
Foreign Keys FK_SCContracts_SalesRepID_ARSalesReps: [dbo].[ARSalesReps].SalesRepIDSalesRepIDint4
True
Foreign Keys FK_SCContracts_JobID_ICJobs: [dbo].[ICJobs].JobIDJobIDint4
True
AccumCopiesdecimal(18,6)9
True
ExpCopyExpDatedatetime8
True
Foreign Keys FK_SCContracts_ContactID_CMContacts: [dbo].[CMContacts].ContactIDContactIDint4
True
Foreign Keys FK_SCContracts_DBFileHeaderID_DBFileHeader: [dbo].[DBFileHeader].DBFileHeaderIDDBFileHeaderIDint4
False
((1))
Foreign Keys FK_SCContracts_ChargeMethodID_ARChargeMethods: [dbo].[ARChargeMethods].ChargeMethodIDChargeMethodIDint4
True
Foreign Keys FK_SCContracts_ChargeAccountID_ARChargeAccounts: [dbo].[ARChargeAccounts].ChargeAccountIDChargeAccountIDint4
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
('')
BaseBilledThruDatedatetime8
True
OverageBilledThruDatedatetime8
True
BaseAccruedThruDatedatetime8
True
EnableAgentUsageAlertbit1
False
((1))
PooledUsageLimitbit1
False
((0))
Renewablebit1
False
((1))
BaseRateScheduleStartDatedatetime8
True
OvgRateScheduleStartDatedatetime8
True
Foreign Keys FK_SCContracts_RenewalCycleID_SCBillingCycles: [dbo].[SCBillingCycles].RenewalCycleIDRenewalCycleIDint4
True
NextBaseIncreaseDatedatetime8
True
NextOvgIncreaseDatedatetime8
True
NextBaseScheduleDetailIDint4
True
NextOvgScheduleDetailIDint4
True
Taxablebit1
False
((1))
OvgRateScheduleStartDateTypeint4
False
((0))
BaseRateScheduleStartDateTypeint4
False
((0))
BaseRateScheduleIsRenewalTypebit1
True
((0))
OvgRateScheduleIsRenewalTypebit1
True
((0))
BaseBillingStartDatedatetime8
True
BaseAccrualStartDatedatetime8
True
OverageBillingStartDatedatetime8
True
BasePreBillingNoDaysint4
False
((0))
UseAlternateOvgBillTobit1
False
((0))
Foreign Keys FK_SCContracts_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_SCContracts_OvgBillToTermID_ShTerms: [dbo].[ShTerms].OvgBillToTermIDOvgBillToTermIDint4
True
Foreign Keys FK_SCContracts_OvgBillToChargeMethodID_ARChargeMethods: [dbo].[ARChargeMethods].OvgBillToChargeMethodIDOvgBillToChargeMethodIDint4
True
Foreign Keys FK_SCContracts_OvgBillToChargeAccountID_ARChargeAccounts: [dbo].[ARChargeAccounts].OvgBillToChargeAccountIDOvgBillToChargeAccountIDint4
True
ContractAdjCodeIDint4
True
BasePreBillingNoMonthsint4
False
((0))
UseIndividualTaxCodesbit1
False
((0))
BSABillingDiscountdecimal(8,4)5
True
BSABillingDiscountBalancemoney8
False
((0))
BSABillingDiscountModebit1
False
((0))
Accrualbit1
False
((0))
AccrualAccountsLockbit1
False
((0))
Billedbit1
False
((0))
LockBillCodebit1
False
((0))
UseBillCodeRevOnRenewalbit1
False
((0))
BSARebillTypeint4
False
((0))
Foreign Keys FK_SCContracts_NoteID_SCContractNotes: [dbo].[SCContractNotes].NoteIDNoteIDint4
True
NoteFlagint4
False
((0))
Foreign Keys FK_SCContracts_TerminationCodeID_SCTerminationCodes: [dbo].[SCTerminationCodes].TerminationCodeIDTerminationCodeIDint4
True
Foreign Keys FK_SCContracts_ContractStatusID_SCContractStatuses: [dbo].[SCContractStatuses].ContractStatusIDContractStatusIDint4
False
((1))
OneTimeRemarkvarchar(1024)1024
False
('')
PrintOneTimeRemarkbit1
False
((0))
OvgBillToTaxablebit1
False
((0))
Foreign Keys FK_SCContracts_OvgBillToTaxCodeID_ShTaxCodes: [dbo].[ShTaxCodes].OvgBillToTaxCodeIDOvgBillToTaxCodeIDint4
True
OvgBillToUseIndividualTaxCodesbit1
False
((0))
MiscChargeBillCycleFlagint4
False
((3))
AllowMeterEstimationbit1
False
((1))
ExpCopiesBaseint4
False
((0))
ExpAdjCopiesint4
False
((0))
ExpCopiesActualExpDatedatetime8
True
ExpDateInitialdatetime8
True
ExpCopiesBillOveragesbit1
False
((0))
ExpCopiesRollOveragesbit1
False
((0))
ExpCopiesMaxOveragesToRollint4
False
((0))
ExpCopiesActualOveragesToRollint4
False
((0))
CPPMinimumPagesint4
False
((0))
CPPRatedecimal(18,6)9
False
((0))
CPPHardwareAmountmoney8
False
((0))
CPPServiceRatedecimal(18,6)9
False
((0))
CombineLeaseAndBasebit1
False
((0))
TimeBlockBasedbit1
False
((0))
MGBaseRateScheduleIsRenewalTypebit1
True
((0))
MGBaseRateScheduleStartDatedatetime8
True
MGBaseRateScheduleStartDateTypeint4
True
((0))
NextMGBaseIncreaseDatedatetime8
True
NextMGBaseScheduleDetailIDint4
True
Foreign Keys FK_SCContracts_ReportDefinitionGroupID_RPReportDefinitionGroups: [dbo].[RPReportDefinitionGroups].ReportDefinitionGroupIDReportDefinitionGroupIDint4
False
Foreign Keys FK_SCContracts_ReportDefinitionContactID_CMContacts: [dbo].[CMContacts].ReportDefinitionContactIDReportDefinitionContactIDint4
True
Foreign Keys FK_SCContracts_ReportDefinitionDocSendMethodID_SHDocSendMethods: [dbo].[SHDocSendMethods].ReportDefinitionDocSendMethodIDReportDefinitionDocSendMethodIDtinyint1
True
ReportDefinitionUseContactWithServiceInvoicesbit1
False
((0))
Foreign Keys FK_SCContracts_OvgBillToReportDefinitionGroupID_RPReportDefinitionGroups: [dbo].[RPReportDefinitionGroups].OvgBillToReportDefinitionGroupIDOvgBillToReportDefinitionGroupIDint4
True
Foreign Keys FK_SCContracts_OvgBillToReportDefinitionContactID_CMContacts: [dbo].[CMContacts].OvgBillToReportDefinitionContactIDOvgBillToReportDefinitionContactIDint4
True
Foreign Keys FK_SCContracts_OvgBillToReportDefinitionDocSendMethodID_SHDocSendMethods: [dbo].[SHDocSendMethods].OvgBillToReportDefinitionDocSendMethodIDOvgBillToReportDefinitionDocSendMethodIDtinyint1
True
OvgBillToReportDefinitionUseContactWithServiceInvoicesbit1
False
((0))
NoteCountint4
False
((0))
IssueCreditbit1
False
((0))
EnableBaseCycleConsolidationbit1
False
((0))
EnableOverageCycleConsolidationbit1
False
((0))
Foreign Keys FK_SCContracts_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
BalanceSheetGroupIDint4
False
Foreign Keys FK_SCContracts_LeaseDivisionID_GLDivisions: [dbo].[GLDivisions].LeaseDivisionIDLeaseDivisionIDint4
True
Foreign Keys FK_SCContracts_LeaseBalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].LeaseBalanceSheetGroupIDLeaseBalanceSheetGroupIDint4
True
BaseBilledThruDateInitialdatetime8
True
OverageBilledThruDateInitialdatetime8
True
BaseAccruedThruDateInitialdatetime8
True
BaseRatePeriodTypeint4
False
((1))
UnearnedInterestBalancemoney8
False
((0))
UnearnedLeaseBalancemoney8
False
((0))
UnearnedLeasePostTermBalancemoney8
False
((0))
Messagevarchar(255)255
False
('')
MessReqAcknowledgmentbit1
False
((1))
Foreign Keys FK_SCContracts_TaxExemptCodeID_SHTaxExemptCodes: [dbo].[SHTaxExemptCodes].TaxExemptCodeIDTaxExemptCodeIDint4
True
Foreign Keys FK_SCContracts_OvgBillToTaxExemptCodeID_SHTaxExemptCodes: [dbo].[SHTaxExemptCodes].OvgBillToTaxExemptCodeIDOvgBillToTaxExemptCodeIDint4
True
Foreign Keys FK_SCContracts_SLACodeID_SCSLACodes: [dbo].[SCSLACodes].SLACodeIDSLACodeIDint4
True
Foreign Keys FK_SCContracts_BaseDistributionCodeID_SCContractBaseDistCodes: [dbo].[SCContractBaseDistCodes].BaseDistributionCodeIDBaseDistributionCodeIDint4
False
Foreign Keys FK_SCContracts_MiscChargeTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].MiscChargeTaxFlagIDMiscChargeTaxFlagIDint4
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCContracts: ContractIDPK_SCContractsContractID
True
80
NameNo CheckColumns
FK_SCContracts_BaseAccrualCycleID_SCBillingCyclesBaseAccrualCycleID->[dbo].[SCBillingCycles].[BillingCycleID]
FK_SCContracts_BaseBillingCycleID_SCBillingCyclesBaseBillingCycleID->[dbo].[SCBillingCycles].[BillingCycleID]
FK_SCContracts_BaseDistributionCodeID_SCContractBaseDistCodesBaseDistributionCodeID->[dbo].[SCContractBaseDistCodes].[BaseDistributionCodeID]
FK_SCContracts_BillCodeID_SCBillCodesBillCodeID->[dbo].[SCBillCodes].[BillCodeID]
FK_SCContracts_BillGroupID_SCContractBillGroupsBillGroupID->[dbo].[SCContractBillGroups].[GroupID]
FK_SCContracts_BillToID_ARCustomers
True
BillToID->[dbo].[ARCustomers].[CustomerID]
FK_SCContracts_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SCContracts_ChargeAccountID_ARChargeAccountsChargeAccountID->[dbo].[ARChargeAccounts].[ChargeAccountID]
FK_SCContracts_ChargeMethodID_ARChargeMethodsChargeMethodID->[dbo].[ARChargeMethods].[ChargeMethodID]
FK_SCContracts_ContactID_CMContactsContactID->[dbo].[CMContacts].[ContactID]
FK_SCContracts_ContractCodeID_SCContractCodesContractCodeID->[dbo].[SCContractCodes].[ContractCodeID]
FK_SCContracts_ContractLeaseID_SCContractLeasesContractLeaseID->[dbo].[SCContractLeases].[ContractLeaseID]
FK_SCContracts_ContractStatusID_SCContractStatusesContractStatusID->[dbo].[SCContractStatuses].[ContractStatusID]
FK_SCContracts_CustomerID_ARCustomers
True
CustomerID->[dbo].[ARCustomers].[CustomerID]
FK_SCContracts_DBFileHeaderID_DBFileHeaderDBFileHeaderID->[dbo].[DBFileHeader].[DBFileHeaderID]
FK_SCContracts_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCContracts_ExtendedTypeID_SCExtendedContractTypesExtendedTypeID->[dbo].[SCExtendedContractTypes].[ExtendedContractTypeID]
FK_SCContracts_JobID_ICJobsJobID->[dbo].[ICJobs].[JobID]
FK_SCContracts_LeaseBalanceSheetGroupID_GLBalanceSheetGroupsLeaseBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCContracts_LeaseDivisionID_GLDivisionsLeaseDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCContracts_MiscChargeDeptID_GLDepts5MiscChargeDeptID->[dbo].[GLDepts5].[DeptID]
FK_SCContracts_MiscChargeGLID_GLAccounts5MiscChargeGLID->[dbo].[GLAccounts5].[AccountID]
FK_SCContracts_MiscChargeTaxFlagID_ShTaxFlagsMiscChargeTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCContracts_NoteID_SCContractNotesNoteID->[dbo].[SCContractNotes].[NoteID]
FK_SCContracts_OverageBillingCycleID_SCBillingCyclesOverageBillingCycleID->[dbo].[SCBillingCycles].[BillingCycleID]
FK_SCContracts_OvgBillToChargeAccountID_ARChargeAccountsOvgBillToChargeAccountID->[dbo].[ARChargeAccounts].[ChargeAccountID]
FK_SCContracts_OvgBillToChargeMethodID_ARChargeMethodsOvgBillToChargeMethodID->[dbo].[ARChargeMethods].[ChargeMethodID]
FK_SCContracts_OvgBillToID_ARCustomersOvgBillToID->[dbo].[ARCustomers].[CustomerID]
FK_SCContracts_OvgBillToReportDefinitionContactID_CMContactsOvgBillToReportDefinitionContactID->[dbo].[CMContacts].[ContactID]
FK_SCContracts_OvgBillToReportDefinitionDocSendMethodID_SHDocSendMethodsOvgBillToReportDefinitionDocSendMethodID->[dbo].[SHDocSendMethods].[DocSendMethodID]
FK_SCContracts_OvgBillToReportDefinitionGroupID_RPReportDefinitionGroupsOvgBillToReportDefinitionGroupID->[dbo].[RPReportDefinitionGroups].[ReportDefinitionGroupID]
FK_SCContracts_OvgBillToTaxCodeID_ShTaxCodesOvgBillToTaxCodeID->[dbo].[ShTaxCodes].[TaxCodeID]
FK_SCContracts_OvgBillToTaxExemptCodeID_SHTaxExemptCodesOvgBillToTaxExemptCodeID->[dbo].[SHTaxExemptCodes].[TaxExemptCodeID]
FK_SCContracts_OvgBillToTermID_ShTermsOvgBillToTermID->[dbo].[ShTerms].[TermID]
FK_SCContracts_RenewalCycleID_SCBillingCyclesRenewalCycleID->[dbo].[SCBillingCycles].[BillingCycleID]
FK_SCContracts_ReportDefinitionContactID_CMContactsReportDefinitionContactID->[dbo].[CMContacts].[ContactID]
FK_SCContracts_ReportDefinitionDocSendMethodID_SHDocSendMethodsReportDefinitionDocSendMethodID->[dbo].[SHDocSendMethods].[DocSendMethodID]
FK_SCContracts_ReportDefinitionGroupID_RPReportDefinitionGroupsReportDefinitionGroupID->[dbo].[RPReportDefinitionGroups].[ReportDefinitionGroupID]
FK_SCContracts_SalesRepID_ARSalesRepsSalesRepID->[dbo].[ARSalesReps].[SalesRepID]
FK_SCContracts_ShTrackingConfigID_ShTrackingConfigsShTrackingConfigID->[dbo].[ShTrackingConfigs].[ShTrackingConfigID]
FK_SCContracts_SLACodeID_SCSLACodesSLACodeID->[dbo].[SCSLACodes].[SLACodeID]
FK_SCContracts_TaxCodeID_ShTaxCodesTaxCodeID->[dbo].[ShTaxCodes].[TaxCodeID]
FK_SCContracts_TaxExemptCodeID_SHTaxExemptCodesTaxExemptCodeID->[dbo].[SHTaxExemptCodes].[TaxExemptCodeID]
FK_SCContracts_TermID_ShTermsTermID->[dbo].[ShTerms].[TermID]
FK_SCContracts_TerminationCodeID_SCTerminationCodesTerminationCodeID->[dbo].[SCTerminationCodes].[TerminationCodeID]
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