CREATE TABLE [dbo].[SCReportBillGroups]
(
[ReportBillGroupID] [int] NOT NULL,
[ReportBillGroupNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CustomerID] [int] NOT NULL,
[BillToID] [int] NOT NULL,
[Date] [datetime] NOT NULL,
[DatePeriod] [int] NOT NULL,
[PostPeriod] [int] NULL,
[VoidPeriod] [int] 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,
[TermDiscountRate] [float] NOT NULL,
[TermDiscountDate] [datetime] NULL,
[DueDate] [datetime] NOT 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,
[GLID] [int] NOT NULL,
[PostID] [int] NULL,
[VoidID] [int] 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_SCReportBillGroups_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCReportBillGroups_LastUpdate] DEFAULT (getdate()),
[timestamp] [timestamp] NULL,
[BranchID] [int] NOT NULL,
[ARBranchID] [int] NOT NULL,
[ChargeMethodID] [int] NULL,
[ChargeAccountInfo] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_SCReportBillGroups_ChargeAccountInfo] DEFAULT (''),
[PartnerID] [int] NULL,
[PartnerReference] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToID] [int] NULL,
[Taxable] [bit] NOT NULL CONSTRAINT [DF_SCReportBillGroups_Taxable] DEFAULT ((1)),
[Consolidate] [bit] NOT NULL CONSTRAINT [DF_SCReportBillGroups_Consolidate] DEFAULT ((0)),
[SendContactID] [int] NULL,
[SendMethodID] [int] NOT NULL,
[Amount] [money] NOT NULL CONSTRAINT [DF_SCReportBillGroups_Amount] DEFAULT ((0)),
[Tax] [money] NOT NULL CONSTRAINT [DF_SCReportBillGroups_Tax] DEFAULT ((0)),
[TaxExemptCodeID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCReportBillGroups] ADD CONSTRAINT [PK_SCReportBillGroups] PRIMARY KEY CLUSTERED ([ReportBillGroupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCReportBillGroups] ADD CONSTRAINT [FK_SCReportBillGroups_ARBranchID_GLBranches] FOREIGN KEY ([ARBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCReportBillGroups] WITH NOCHECK ADD CONSTRAINT [FK_SCReportBillGroups_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCReportBillGroups] ADD CONSTRAINT [FK_SCReportBillGroups_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[SCReportBillGroups] ADD CONSTRAINT [FK_SCReportBillGroups_ChargeMethodID_ARChargeMethods] FOREIGN KEY ([ChargeMethodID]) REFERENCES [dbo].[ARChargeMethods] ([ChargeMethodID])
GO
ALTER TABLE [dbo].[SCReportBillGroups] WITH NOCHECK ADD CONSTRAINT [FK_SCReportBillGroups_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCReportBillGroups] ADD CONSTRAINT [FK_SCReportBillGroups_PartnerID_ShServicePartners] FOREIGN KEY ([PartnerID]) REFERENCES [dbo].[ShServicePartners] ([PartnerID])
GO
ALTER TABLE [dbo].[SCReportBillGroups] WITH NOCHECK ADD CONSTRAINT [FK_SCReportBillGroups_PostID_ARInvoices] FOREIGN KEY ([PostID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO
ALTER TABLE [dbo].[SCReportBillGroups] ADD CONSTRAINT [FK_SCReportBillGroups_SalesRepID_ARSalesReps] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ARSalesReps] ([SalesRepID])
GO
ALTER TABLE [dbo].[SCReportBillGroups] ADD CONSTRAINT [FK_SCReportBillGroups_SendContactID_CMContacts] FOREIGN KEY ([SendContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[SCReportBillGroups] ADD CONSTRAINT [FK_SCReportBillGroups_ShipToID_ARCustomers] FOREIGN KEY ([ShipToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[SCReportBillGroups] ADD CONSTRAINT [FK_SCReportBillGroups_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[SCReportBillGroups] ADD CONSTRAINT [FK_SCReportBillGroups_TaxExemptCodeID_SHTaxExemptCodes] FOREIGN KEY ([TaxExemptCodeID]) REFERENCES [dbo].[SHTaxExemptCodes] ([TaxExemptCodeID])
GO
ALTER TABLE [dbo].[SCReportBillGroups] ADD CONSTRAINT [FK_SCReportBillGroups_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO
ALTER TABLE [dbo].[SCReportBillGroups] WITH NOCHECK ADD CONSTRAINT [FK_SCReportBillGroups_VoidID_ARInvoices] FOREIGN KEY ([VoidID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO