CREATE TABLE [dbo].[SCQBillings]
(
[BillingID] [int] NOT NULL,
[CustomerID] [int] NOT NULL,
[BillToID] [int] NOT NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[PONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TermID] [int] NULL,
[SalesRepID] [int] NULL,
[MailToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MailToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MailToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MailToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MailToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MailToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[MailToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ShipToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TaxCodeID] [int] NULL,
[Tax] [money] NOT NULL CONSTRAINT [DF_SCQBillings_Tax] DEFAULT ((0)),
[GLID] [int] NOT NULL,
[Total] [money] NOT NULL CONSTRAINT [DF_SCQBillings_Total] 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_SCQBillings_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCQBillings_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[BranchID] [int] NOT NULL,
[ARBranchID] [int] NOT NULL,
[Taxable] [bit] NOT NULL CONSTRAINT [DF_SCQBillings_Taxable] DEFAULT ((1)),
[ChargeMethodID] [int] NULL,
[ChargeAccountID] [int] NULL,
[ProposalID] [int] NULL,
[BillingQueueModeID] [int] NOT NULL CONSTRAINT [DF_SCQBillings_BillingQueueModeID] DEFAULT ((0)),
[UserSessionLeaseID] [int] NULL,
[ReportDefinitionGroupID] [int] NOT NULL,
[SendContactID] [int] NULL,
[SendMethodID] [int] NOT NULL,
[TaxTempTaxCodeID] [int] NULL,
[TaxTempTransRefNumber] [varchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TaxCompanyCode] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TaxTotalAmount] [money] NULL,
[TaxTotalTax] [money] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQBillings] ADD CONSTRAINT [PK_SCQBillings] PRIMARY KEY CLUSTERED ([BillingID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQBillings] ADD CONSTRAINT [FK_SCQBillings_ARBranchID_GLBranches] FOREIGN KEY ([ARBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCQBillings] WITH NOCHECK ADD CONSTRAINT [FK_SCQBillings_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCQBillings] ADD CONSTRAINT [FK_SCQBillings_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCQBillings] ADD CONSTRAINT [FK_SCQBillings_ChargeAccountID_ARChargeAccounts] FOREIGN KEY ([ChargeAccountID]) REFERENCES [dbo].[ARChargeAccounts] ([ChargeAccountID])
GO
ALTER TABLE [dbo].[SCQBillings] ADD CONSTRAINT [FK_SCQBillings_ChargeMethodID_ARChargeMethods] FOREIGN KEY ([ChargeMethodID]) REFERENCES [dbo].[ARChargeMethods] ([ChargeMethodID])
GO
ALTER TABLE [dbo].[SCQBillings] WITH NOCHECK ADD CONSTRAINT [FK_SCQBillings_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCQBillings] ADD CONSTRAINT [FK_SCQBillings_GLID_GLAccounts1] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts1] ([AccountID])
GO
ALTER TABLE [dbo].[SCQBillings] ADD CONSTRAINT [FK_SCQBillings_ProposalID_SCProposals] FOREIGN KEY ([ProposalID]) REFERENCES [dbo].[SCProposals] ([ProposalID])
GO
ALTER TABLE [dbo].[SCQBillings] ADD CONSTRAINT [FK_SCQBillings_ReportDefinitionGroupID_RPReportDefinitionGroups] FOREIGN KEY ([ReportDefinitionGroupID]) REFERENCES [dbo].[RPReportDefinitionGroups] ([ReportDefinitionGroupID])
GO
ALTER TABLE [dbo].[SCQBillings] ADD CONSTRAINT [FK_SCQBillings_SalesRepID_ARSalesReps] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ARSalesReps] ([SalesRepID])
GO
ALTER TABLE [dbo].[SCQBillings] ADD CONSTRAINT [FK_SCQBillings_SendContactID_CMContacts] FOREIGN KEY ([SendContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[SCQBillings] ADD CONSTRAINT [FK_SCQBillings_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SCQBillings] ADD CONSTRAINT [FK_SCQBillings_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO