CREATE TABLE [dbo].[ARHInvoices]
(
[HInvoiceID] [int] NOT NULL,
[HInvoiceNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Type] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerID] [int] NULL,
[CustomerName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BillToID] [int] NULL,
[BillToName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HApplyToID] [int] NULL,
[HApplyToInvoiceNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[HMasterInvoiceID] [int] NULL,
[HMasterInvoiceNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Date] [datetime] NULL,
[DatePeriod] [int] NULL,
[Period] [int] NULL,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PONumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TermID] [int] NULL,
[Term] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TermDiscountRate] [float] NULL,
[TermDiscountDate] [datetime] NULL,
[TermDiscount] [money] NULL,
[DueDate] [datetime] NULL,
[SalesRepID] [int] NULL,
[SalesRep] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[MailToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToAttn] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToName] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToAddress] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToCity] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToState] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToZip] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ShipToCountry] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DiscountRate] [float] NULL,
[Discount] [money] NULL,
[Freight] [money] NULL,
[TaxCodeID] [int] NULL,
[TaxCode] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Tax] [money] NULL,
[Total] [money] NULL,
[AdjTotal] [money] NULL,
[Due] [money] NULL,
[HVoidID] [int] NULL,
[HVoidInvoiceNumber] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Module] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Source] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Reference] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[LocationID] [int] NULL,
[LocationName] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TransactionTypeID] [int] NULL,
[TransactionType] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[BranchID] [int] NULL,
[BranchName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ARBranchID] [int] NULL,
[ARBranchName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ChargeMethodID] [int] NULL,
[ChargeMethod] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ChargeAccountInfo] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Taxable] [bit] NULL,
[Consolidate] [bit] NULL,
[ConsolidatedBillingID] [int] NULL,
[BillingNumber] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Void] [bit] NULL,
[Sent] [bit] NULL,
[OrderedByContactID] [int] NULL,
[OrderedByContact] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [PK_ARHInvoices] PRIMARY KEY CLUSTERED ([HInvoiceID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_ARBranchID_GLBranches] FOREIGN KEY ([ARBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_ChargeMethodID_ARChargeMethods] FOREIGN KEY ([ChargeMethodID]) REFERENCES [dbo].[ARChargeMethods] ([ChargeMethodID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_HApplyToID_ARHInvoices] FOREIGN KEY ([HApplyToID]) REFERENCES [dbo].[ARHInvoices] ([HInvoiceID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_HMasterInvoiceID_ARHInvoices] FOREIGN KEY ([HMasterInvoiceID]) REFERENCES [dbo].[ARHInvoices] ([HInvoiceID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_HVoidID_ARHInvoices] FOREIGN KEY ([HVoidID]) REFERENCES [dbo].[ARHInvoices] ([HInvoiceID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_OrderedByContactID_CMContacts] FOREIGN KEY ([OrderedByContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_SalesRepID_ARSalesReps] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ARSalesReps] ([SalesRepID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO
ALTER TABLE [dbo].[ARHInvoices] ADD CONSTRAINT [FK_ARHInvoices_TransactionTypeID_SHTransactionTypes] FOREIGN KEY ([TransactionTypeID]) REFERENCES [dbo].[ShTransactionTypes] ([TransactionTypeID])
GO