Tables [dbo].[SCBillingBases]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:59:06 AM Thursday, March 21, 2019
Last Modified1:14:36 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Cluster Primary Key PK_SCBillingBases: InvoiceID\ContractDetailID\DetailIDForeign Keys FK_SCBillingBases_InvoiceID_SCBillingContracts: [dbo].[SCBillingContracts].InvoiceID\ContractDetailIDInvoiceIDint4
False
Cluster Primary Key PK_SCBillingBases: InvoiceID\ContractDetailID\DetailIDForeign Keys FK_SCBillingBases_InvoiceID_SCBillingContracts: [dbo].[SCBillingContracts].InvoiceID\ContractDetailIDContractDetailIDint4
False
Cluster Primary Key PK_SCBillingBases: InvoiceID\ContractDetailID\DetailIDDetailIDint4
False
Foreign Keys FK_SCBillingBases_GLID_GLAccounts5: [dbo].[GLAccounts5].GLIDGLIDint4
False
Foreign Keys FK_SCBillingBases_DeptID_GLDepts5: [dbo].[GLDepts5].DeptIDDeptIDint4
True
Amountmoney8
False
TaxFlagint4
False
CreatorIDchar(8)8
False
UpdatorIDchar(8)8
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
timestamptimestamp8
True
TaxCodeIDint4
True
DiscAmountmoney8
False
((0))
DiscGLIDint4
True
Distributiondecimal(18,6)9
False
((0))
Foreign Keys FK_SCBillingBases_BillingGLID_GLAccounts: [dbo].[GLAccounts].BillingGLIDBillingGLIDint4
True
Foreign Keys FK_SCBillingBases_BillingDeptID_GLDepts: [dbo].[GLDepts].BillingDeptIDBillingDeptIDint4
True
BaseLevelint4
False
((1))
DistCodeIDint4
False
((0))
Foreign Keys FK_SCBillingBases_BranchID_GLBranches: [dbo].[GLBranches].BranchIDBranchIDint4
False
Foreign Keys FK_SCBillingBases_DivisionID_GLDivisions: [dbo].[GLDivisions].DivisionIDDivisionIDint4
False
Foreign Keys FK_SCBillingBases_BalanceSheetGroupID_GLBalanceSheetGroups: [dbo].[GLBalanceSheetGroups].BalanceSheetGroupIDBalanceSheetGroupIDint4
False
Accrualbit1
False
Foreign Keys FK_SCBillingBases_TaxExemptCodeID_SHTaxExemptCodes: [dbo].[SHTaxExemptCodes].TaxExemptCodeIDTaxExemptCodeIDint4
True
Taxablebit1
False
((0))
Foreign Keys FK_SCBillingBases_TaxFlagID_ShTaxFlags: [dbo].[ShTaxFlags].TaxFlagIDTaxFlagIDint4
False
Foreign Keys FK_SCBillingBases_LocationID_ARCustomers: [dbo].[ARCustomers].LocationIDLocationIDint4
True
Addressvarchar(64)64
False
('')
Cityvarchar(32)32
False
('')
Statevarchar(16)16
False
('')
Zipvarchar(16)16
False
('')
Countyvarchar(32)32
False
('')
Countryvarchar(32)32
False
('')
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK_SCBillingBases: InvoiceID\ContractDetailID\DetailIDPK_SCBillingBasesInvoiceID, ContractDetailID, DetailID
True
80
NameColumns
FK_SCBillingBases_BalanceSheetGroupID_GLBalanceSheetGroupsBalanceSheetGroupID->[dbo].[GLBalanceSheetGroups].[BalanceSheetGroupID]
FK_SCBillingBases_BillingDeptID_GLDeptsBillingDeptID->[dbo].[GLDepts].[DeptID]
FK_SCBillingBases_BillingGLID_GLAccountsBillingGLID->[dbo].[GLAccounts].[AccountID]
FK_SCBillingBases_BranchID_GLBranchesBranchID->[dbo].[GLBranches].[BranchID]
FK_SCBillingBases_DeptID_GLDepts5DeptID->[dbo].[GLDepts5].[DeptID]
FK_SCBillingBases_DivisionID_GLDivisionsDivisionID->[dbo].[GLDivisions].[DivisionID]
FK_SCBillingBases_GLID_GLAccounts5GLID->[dbo].[GLAccounts5].[AccountID]
FK_SCBillingBases_InvoiceID_SCBillingContractsInvoiceID->[dbo].[SCBillingContracts].[InvoiceID]
ContractDetailID->[dbo].[SCBillingContracts].[ContractDetailID]
FK_SCBillingBases_LocationID_ARCustomersLocationID->[dbo].[ARCustomers].[CustomerID]
FK_SCBillingBases_TaxExemptCodeID_SHTaxExemptCodesTaxExemptCodeID->[dbo].[SHTaxExemptCodes].[TaxExemptCodeID]
FK_SCBillingBases_TaxFlagID_ShTaxFlagsTaxFlagID->[dbo].[ShTaxFlags].[TaxFlagID]
CREATE TABLE [dbo].[SCBillingBases]
(
[InvoiceID] [int] NOT NULL,
[ContractDetailID] [int] NOT NULL,
[DetailID] [int] NOT NULL,
[GLID] [int] NOT NULL,
[DeptID] [int] NULL,
[Amount] [money] NOT NULL,
[TaxFlag] [int] 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_SCBillingBases_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCBillingBases_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[TaxCodeID] [int] NULL,
[DiscAmount] [money] NOT NULL CONSTRAINT [DF_SCBillingBases_DiscAmount] DEFAULT ((0)),
[DiscGLID] [int] NULL,
[Distribution] [decimal] (18, 6) NOT NULL CONSTRAINT [DF_SCBillingBases_Distribution] DEFAULT ((0)),
[BillingGLID] [int] NULL,
[BillingDeptID] [int] NULL,
[BaseLevel] [int] NOT NULL CONSTRAINT [DF_SCBillingBases_BaseLevel] DEFAULT ((1)),
[DistCodeID] [int] NOT NULL CONSTRAINT [DF_SCBillingBases_DistcodeID] DEFAULT ((0)),
[BranchID] [int] NOT NULL,
[DivisionID] [int] NOT NULL,
[BalanceSheetGroupID] [int] NOT NULL,
[Accrual] [bit] NOT NULL,
[TaxExemptCodeID] [int] NULL,
[Taxable] [bit] NOT NULL CONSTRAINT [DF_SCBillingBases_Taxable] DEFAULT ((0)),
[TaxFlagID] [int] NOT NULL,
[LocationID] [int] NULL,
[Address] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCBillingBases_Address] DEFAULT (''),
[City] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCBillingBases_City] DEFAULT (''),
[State] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCBillingBases_State] DEFAULT (''),
[Zip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCBillingBases_Zip] DEFAULT (''),
[County] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCBillingBases_County] DEFAULT (''),
[Country] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCBillingBases_Country] DEFAULT ('')
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingBases] ADD CONSTRAINT [PK_SCBillingBases] PRIMARY KEY CLUSTERED  ([InvoiceID], [ContractDetailID], [DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCBillingBases] ADD CONSTRAINT [FK_SCBillingBases_BalanceSheetGroupID_GLBalanceSheetGroups] FOREIGN KEY ([BalanceSheetGroupID]) REFERENCES [dbo].[GLBalanceSheetGroups] ([BalanceSheetGroupID])
GO
ALTER TABLE [dbo].[SCBillingBases] ADD CONSTRAINT [FK_SCBillingBases_BillingDeptID_GLDepts] FOREIGN KEY ([BillingDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[SCBillingBases] ADD CONSTRAINT [FK_SCBillingBases_BillingGLID_GLAccounts] FOREIGN KEY ([BillingGLID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[SCBillingBases] ADD CONSTRAINT [FK_SCBillingBases_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCBillingBases] ADD CONSTRAINT [FK_SCBillingBases_DeptID_GLDepts5] FOREIGN KEY ([DeptID]) REFERENCES [dbo].[GLDepts5] ([DeptID])
GO
ALTER TABLE [dbo].[SCBillingBases] ADD CONSTRAINT [FK_SCBillingBases_DivisionID_GLDivisions] FOREIGN KEY ([DivisionID]) REFERENCES [dbo].[GLDivisions] ([DivisionID])
GO
ALTER TABLE [dbo].[SCBillingBases] ADD CONSTRAINT [FK_SCBillingBases_GLID_GLAccounts5] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts5] ([AccountID])
GO
ALTER TABLE [dbo].[SCBillingBases] ADD CONSTRAINT [FK_SCBillingBases_InvoiceID_SCBillingContracts] FOREIGN KEY ([InvoiceID], [ContractDetailID]) REFERENCES [dbo].[SCBillingContracts] ([InvoiceID], [ContractDetailID])
GO
ALTER TABLE [dbo].[SCBillingBases] ADD CONSTRAINT [FK_SCBillingBases_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCBillingBases] ADD CONSTRAINT [FK_SCBillingBases_TaxExemptCodeID_SHTaxExemptCodes] FOREIGN KEY ([TaxExemptCodeID]) REFERENCES [dbo].[SHTaxExemptCodes] ([TaxExemptCodeID])
GO
ALTER TABLE [dbo].[SCBillingBases] ADD CONSTRAINT [FK_SCBillingBases_TaxFlagID_ShTaxFlags] FOREIGN KEY ([TaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO