Tables [dbo].[SCProposalContracts]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:21 AM Thursday, March 21, 2019
Last Modified1:15:08 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SCProposalContracts: ProposalID\ContractDetailIDForeign Keys FK_SCProposalContracts_ProposalID_SCProposals: [dbo].[SCProposals].ProposalIDProposalIDint4
False
Cluster Primary Key PK_SCProposalContracts: ProposalID\ContractDetailIDContractDetailIDint4
False
Foreign Keys FK_SCProposalContracts_ContractID_SCContracts: [dbo].[SCContracts].ContractIDContractIDint4
False
BaseFromDatedatetime8
True
BaseToDatedatetime8
True
BaseBillingCycleIDint4
True
UseIndividualTaxCodesbit1
False
((0))
SumIndividualBaseRatesbit1
False
BaseAmountmoney8
False
OverageFromDatedatetime8
True
OverageToDatedatetime8
True
OverageBillingCycleIDint4
True
Copiesint4
False
OverageAmountmoney8
True
BillForServicesbit1
False
MinimumBalancemoney8
True
MinimumBillingmoney8
True
UnearnedBalancemoney8
True
MiscChargeAmountmoney8
False
MiscChargeTaxFlagint4
False
MiscChargeDescriptionvarchar(255)255
False
Foreign Keys FK_SCProposalContracts_MiscChargeGLID_GLAccounts5: [dbo].[GLAccounts5].MiscChargeGLIDMiscChargeGLIDint4
True
Foreign Keys FK_SCProposalContracts_MiscChargeDeptID_GLDepts5: [dbo].[GLDepts5].MiscChargeDeptIDMiscChargeDeptIDint4
True
MiscContinuousbit1
False
ContractAdjDescriptionvarchar(50)50
False
('')
ContractAdjBaseAmountmoney8
False
((0))
ContractAdjBaseGLIDint4
True
ContractAdjBaseDeptIDint4
True
ContractAdjBaseTaxFlagint4
True
ContractAdjOverageAmountmoney8
False
((0))
ContractAdjOverageGLIDint4
True
ContractAdjOverageDeptIDint4
True
ContractAdjOverageTaxFlagint4
True
Amountmoney8
False
DiscAmountmoney8
False
((0))
LeaseAmountmoney8
True
LeaseTaxFlagint4
True
LeaseGLIDint4
True
LeaseDeptIDint4
True
SalesRepIDint4
True
JobIDint4
True
AccumulatedCopiesint4
True
TaxCodeIDint4
True
ProrateBillNowbit1
False
((0))
NextBaseAmountmoney8
True
CurNonAdjustedBaseAmountmoney8
True
NextBaseUpdatedbit1
True
NextOvgUpdatedbit1
True
Voidbit1
False
((0))
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
False
MiscChargeBillCycleFlagint4
False
((3))
LeaseUseIndividualTaxCodesbit1
False
((0))
LeaseSumIndividualAmountsbit1
False
((0))
PONumbervarchar(64)64
False
('')
MGBaseAmountmoney8
True
NextMGBaseUpdatedbit1
True
NonAdjustedBaseLastBillingDatedatetime8
True
NonAdjustedBaseNextBillingDatedatetime8
True
NonAdjustedOverageLastBillingDatedatetime8
True
NonAdjustedOverageNextBillingDatedatetime8
True
BaseCyclesBilledint4
False
OverageCyclesBilledint4
False
BaseBillingTypeIDint4
False
((1))
BaseRatePeriodint4
True
NonAdjustedBaseBillingStartDatedatetime8
True
NonAdjustedOverageBillingStartDatedatetime8
True
BaseRatePeriodTypeint4
False
((1))
Foreign Keys FK_SCProposalContracts_ExtendedTypeID_SCExtendedContractTypes: [dbo].[SCExtendedContractTypes].ExtendedTypeIDExtendedTypeIDint4
True
ProrateBillNowOveragesbit1
False
((0))
Foreign Keys FK_SCProposalContracts_MiscChargeTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].MiscChargeTaxFlagIDMiscChargeTaxFlagIDint4
False
Foreign Keys FK_SCProposalContracts_ContractAdjBaseTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].ContractAdjBaseTaxFlagIDContractAdjBaseTaxFlagIDint4
False
Foreign Keys FK_SCProposalContracts_ContractAdjOverageTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].ContractAdjOverageTaxFlagIDContractAdjOverageTaxFlagIDint4
False
Foreign Keys FK_SCProposalContracts_LeaseTaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].LeaseTaxFlagIDLeaseTaxFlagIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCProposalContracts: ProposalID\ContractDetailIDPK_SCProposalContractsProposalID, ContractDetailID
True
80
NameColumns
FK_SCProposalContracts_ContractAdjBaseTaxFlagID_ShTaxFlagsContractAdjBaseTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCProposalContracts_ContractAdjOverageTaxFlagID_ShTaxFlagsContractAdjOverageTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCProposalContracts_ContractID_SCContractsContractID->[dbo].[SCContracts].[ContractID]
FK_SCProposalContracts_ExtendedTypeID_SCExtendedContractTypesExtendedTypeID->[dbo].[SCExtendedContractTypes].[ExtendedContractTypeID]
FK_SCProposalContracts_LeaseTaxFlagID_ShTaxFlagsLeaseTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCProposalContracts_MiscChargeDeptID_GLDepts5MiscChargeDeptID->[dbo].[GLDepts5].[DeptID]
FK_SCProposalContracts_MiscChargeGLID_GLAccounts5MiscChargeGLID->[dbo].[GLAccounts5].[AccountID]
FK_SCProposalContracts_MiscChargeTaxFlagID_ShTaxFlagsMiscChargeTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
FK_SCProposalContracts_ProposalID_SCProposalsProposalID->[dbo].[SCProposals].[ProposalID]
CREATE TABLE [dbo].[SCProposalContracts]
(
[ProposalID] [int] NOT NULL,
[ContractDetailID] [int] NOT NULL,
[ContractID] [int] NOT NULL,
[BaseFromDate] [datetime] NULL,
[BaseToDate] [datetime] NULL,
[BaseBillingCycleID] [int] NULL,
[UseIndividualTaxCodes] [bit] NOT NULL CONSTRAINT [DF_SCProposalContracts_UseIndividualTaxCodes] DEFAULT ((0)),
[SumIndividualBaseRates] [bit] NOT NULL,
[BaseAmount] [money] NOT NULL,
[OverageFromDate] [datetime] NULL,
[OverageToDate] [datetime] NULL,
[OverageBillingCycleID] [int] 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,
[ContractAdjDescription] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCProposalContracts_ContractAdjDescription] DEFAULT (''),
[ContractAdjBaseAmount] [money] NOT NULL CONSTRAINT [DF_SCProposalContracts_ContractAdjBaseAmount] DEFAULT ((0)),
[ContractAdjBaseGLID] [int] NULL,
[ContractAdjBaseDeptID] [int] NULL,
[ContractAdjBaseTaxFlag] [int] NULL,
[ContractAdjOverageAmount] [money] NOT NULL CONSTRAINT [DF_SCProposalContracts_ContractAdjOverageAmount] DEFAULT ((0)),
[ContractAdjOverageGLID] [int] NULL,
[ContractAdjOverageDeptID] [int] NULL,
[ContractAdjOverageTaxFlag] [int] NULL,
[Amount] [money] NOT NULL,
[DiscAmount] [money] NOT NULL CONSTRAINT [DF_SCProposalContracts_DiscAmount] DEFAULT ((0)),
[LeaseAmount] [money] NULL,
[LeaseTaxFlag] [int] NULL,
[LeaseGLID] [int] NULL,
[LeaseDeptID] [int] NULL,
[SalesRepID] [int] NULL,
[JobID] [int] NULL,
[AccumulatedCopies] [int] NULL,
[TaxCodeID] [int] NULL,
[ProrateBillNow] [bit] NOT NULL CONSTRAINT [DF_SCProposalContracts_ProrateBillNow] DEFAULT ((0)),
[NextBaseAmount] [money] NULL,
[CurNonAdjustedBaseAmount] [money] NULL,
[NextBaseUpdated] [bit] NULL,
[NextOvgUpdated] [bit] NULL,
[Void] [bit] NOT NULL CONSTRAINT [DF_SCProposalContracts_Void] 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_SCProposalContracts_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCProposalContracts_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NOT NULL,
[MiscChargeBillCycleFlag] [int] NOT NULL CONSTRAINT [DF_SCProposalContracts_MiscChargeBillCycleFlag] DEFAULT ((3)),
[LeaseUseIndividualTaxCodes] [bit] NOT NULL CONSTRAINT [DF_SCProposalContracts_LeaseUseIndividualTaxCodes] DEFAULT ((0)),
[LeaseSumIndividualAmounts] [bit] NOT NULL CONSTRAINT [DF_SCProposalContracts_LeaseSumIndividualAmounts] DEFAULT ((0)),
[PONumber] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCProposalContracts_PONumber] DEFAULT (''),
[MGBaseAmount] [money] NULL,
[NextMGBaseUpdated] [bit] 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_SCProposalContracts_BaseBillingTypeID] DEFAULT ((1)),
[BaseRatePeriod] [int] NULL,
[NonAdjustedBaseBillingStartDate] [datetime] NULL,
[NonAdjustedOverageBillingStartDate] [datetime] NULL,
[BaseRatePeriodType] [int] NOT NULL CONSTRAINT [DF_SCProposalContracts_BaseRatePeriodType] DEFAULT ((1)),
[ExtendedTypeID] [int] NULL,
[ProrateBillNowOverages] [bit] NOT NULL CONSTRAINT [DF_SCProposalContracts_ProrateBillNowOverages] DEFAULT ((0)),
[MiscChargeTaxFlagID] [int] NOT NULL,
[ContractAdjBaseTaxFlagID] [int] NOT NULL,
[ContractAdjOverageTaxFlagID] [int] NOT NULL,
[LeaseTaxFlagID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCProposalContracts] ADD CONSTRAINT [PK_SCProposalContracts] PRIMARY KEY CLUSTERED  ([ProposalID], [ContractDetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCProposalContracts] ADD CONSTRAINT [FK_SCProposalContracts_ContractAdjBaseTaxFlagID_ShTaxFlags] FOREIGN KEY ([ContractAdjBaseTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCProposalContracts] ADD CONSTRAINT [FK_SCProposalContracts_ContractAdjOverageTaxFlagID_ShTaxFlags] FOREIGN KEY ([ContractAdjOverageTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCProposalContracts] ADD CONSTRAINT [FK_SCProposalContracts_ContractID_SCContracts] FOREIGN KEY ([ContractID]) REFERENCES [dbo].[SCContracts] ([ContractID])
GO
ALTER TABLE [dbo].[SCProposalContracts] ADD CONSTRAINT [FK_SCProposalContracts_ExtendedTypeID_SCExtendedContractTypes] FOREIGN KEY ([ExtendedTypeID]) REFERENCES [dbo].[SCExtendedContractTypes] ([ExtendedContractTypeID])
GO
ALTER TABLE [dbo].[SCProposalContracts] ADD CONSTRAINT [FK_SCProposalContracts_LeaseTaxFlagID_ShTaxFlags] FOREIGN KEY ([LeaseTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCProposalContracts] ADD CONSTRAINT [FK_SCProposalContracts_MiscChargeDeptID_GLDepts5] FOREIGN KEY ([MiscChargeDeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SCProposalContracts] ADD CONSTRAINT [FK_SCProposalContracts_MiscChargeGLID_GLAccounts5] FOREIGN KEY ([MiscChargeGLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
ALTER TABLE [dbo].[SCProposalContracts] ADD CONSTRAINT [FK_SCProposalContracts_MiscChargeTaxFlagID_ShTaxFlags] FOREIGN KEY ([MiscChargeTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[SCProposalContracts] ADD CONSTRAINT [FK_SCProposalContracts_ProposalID_SCProposals] FOREIGN KEY ([ProposalID]) REFERENCES [dbo].[SCProposals] ([ProposalID])
GO