CREATE TABLE [dbo].[ARInvoices]
(
[InvoiceID] [int] NOT NULL,
[InvoiceNumber] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Type] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CustomerID] [int] NOT NULL,
[BillToID] [int] NOT NULL,
[LocationID] [int] NULL,
[ApplyToID] [int] NULL,
[MasterInvoiceID] [int] NULL,
[Date] [datetime] NOT NULL,
[DatePeriod] [int] NOT NULL,
[Period] [int] NOT NULL,
[Description] [varchar] (1020) 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,
[TermDiscount] [money] NOT NULL CONSTRAINT [DF_ARInvoices_TermDiscount] DEFAULT ((0)),
[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,
[Remarks] [varchar] (1024) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DiscountRate] [float] NOT NULL,
[DiscountGLID] [int] NULL,
[Discount] [money] NOT NULL CONSTRAINT [DF_ARInvoices_Discount] DEFAULT ((0)),
[FreightGLID] [int] NULL,
[Freight] [money] NOT NULL,
[TaxCodeID] [int] NULL,
[Tax] [money] NOT NULL CONSTRAINT [DF_ARInvoices_Tax] DEFAULT ((0)),
[GLID] [int] NOT NULL,
[Total] [money] NOT NULL CONSTRAINT [DF_ARInvoices_Total] DEFAULT ((0)),
[AdjTotal] [money] NOT NULL CONSTRAINT [DF_ARInvoices_AdjTotal] DEFAULT ((0)),
[Due] [money] NOT NULL CONSTRAINT [DF_ARInvoices_Due] DEFAULT ((0)),
[VoidID] [int] NULL,
[Module] [char] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Source] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Reference] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TransactionTypeID] [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_ARInvoices_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_ARInvoices_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_ARInvoices_ChargeAccountInfo] DEFAULT (''),
[Taxable] [bit] NOT NULL CONSTRAINT [DF_ARInvoices_Taxable] DEFAULT ((1)),
[FreightDeptID] [int] NULL,
[DiscountDeptID] [int] NULL,
[Consolidate] [bit] NOT NULL CONSTRAINT [DF_ARInvoices_Consolidate] DEFAULT ((0)),
[ConsolidatedBillingID] [int] NULL,
[BillingNumber] [varchar] (35) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARInvoices_BillingNumber] DEFAULT (''),
[Void] [bit] NOT NULL CONSTRAINT [DF_ARInvoices_Void] DEFAULT ((0)),
[Sent] [bit] NOT NULL CONSTRAINT [DF_ARInvoices_Sent] DEFAULT ((0)),
[NoteID] [int] NULL,
[NoteFlag] [int] NOT NULL CONSTRAINT [DF_ARInvoices_NoteFlag] DEFAULT ((0)),
[OrderedByContactID] [int] NULL,
[CommissionRepID] [int] NULL,
[SendContactID] [int] NULL,
[SendMethodID] [int] NOT NULL,
[ReceivablePayableID] [int] NOT NULL,
[PrimaryReportDefinitionID] [int] NULL,
[NoteCount] [int] NOT NULL CONSTRAINT [DF_ARInvoices_NoteCount] DEFAULT ((0)),
[ExtReferenceNumber] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_ARInvoices_ExtReferenceNumber] DEFAULT (''),
[TaxExemptCodeID] [int] NULL,
[FreightTaxFlag] [int] NOT NULL CONSTRAINT [DF_ARInvoices_FreightTaxFlag] DEFAULT ((0)),
[FreightTaxFlagID] [int] NOT NULL CONSTRAINT [DF_ARInvoices_FreightTaxFlagID] DEFAULT ((1))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARInvoices] ADD CONSTRAINT [PK_ARInvoices] PRIMARY KEY CLUSTERED ([InvoiceID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ARInvoices] WITH NOCHECK ADD CONSTRAINT [FK_ARInvoices_ApplyToID_ARInvoices] FOREIGN KEY ([ApplyToID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO
ALTER TABLE [dbo].[ARInvoices] WITH NOCHECK ADD CONSTRAINT [FK_ARInvoices_ARBranchID_GLBranches] FOREIGN KEY ([ARBranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ARInvoices] WITH NOCHECK ADD CONSTRAINT [FK_ARInvoices_BillToID_ARCustomers] FOREIGN KEY ([BillToID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ARInvoices] WITH NOCHECK ADD CONSTRAINT [FK_ARInvoices_BranchID_GLBranches] FOREIGN KEY ([BranchID]) REFERENCES [dbo].[GLBranches] ([BranchID])
GO
ALTER TABLE [dbo].[ARInvoices] ADD CONSTRAINT [FK_ARInvoices_ChargeMethodID_ARChargeMethods] FOREIGN KEY ([ChargeMethodID]) REFERENCES [dbo].[ARChargeMethods] ([ChargeMethodID])
GO
ALTER TABLE [dbo].[ARInvoices] ADD CONSTRAINT [FK_ARInvoices_CommissionRepID_SHAgents] FOREIGN KEY ([CommissionRepID]) REFERENCES [dbo].[ShAgents] ([AgentID])
GO
ALTER TABLE [dbo].[ARInvoices] ADD CONSTRAINT [FK_ARInvoices_ConsolidatedBillingID_ARConsolidatedBillings] FOREIGN KEY ([ConsolidatedBillingID]) REFERENCES [dbo].[ARConsolidatedBillings] ([ConsolidatedBillingID])
GO
ALTER TABLE [dbo].[ARInvoices] WITH NOCHECK ADD CONSTRAINT [FK_ARInvoices_CustomerID_ARCustomers] FOREIGN KEY ([CustomerID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ARInvoices] ADD CONSTRAINT [FK_ARInvoices_DiscountDeptID_GLDepts] FOREIGN KEY ([DiscountDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[ARInvoices] WITH NOCHECK ADD CONSTRAINT [FK_ARInvoices_DiscountGLID_GLAccounts1] FOREIGN KEY ([DiscountGLID]) REFERENCES [dbo].[GLAccounts1] ([AccountID])
GO
ALTER TABLE [dbo].[ARInvoices] ADD CONSTRAINT [FK_ARInvoices_FreightDeptID_GLDepts] FOREIGN KEY ([FreightDeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[ARInvoices] WITH NOCHECK ADD CONSTRAINT [FK_ARInvoices_FreightGLID_GLAccounts1] FOREIGN KEY ([FreightGLID]) REFERENCES [dbo].[GLAccounts1] ([AccountID])
GO
ALTER TABLE [dbo].[ARInvoices] ADD CONSTRAINT [FK_ARInvoices_FreightTaxFlagID_ShTaxFlags] FOREIGN KEY ([FreightTaxFlagID]) REFERENCES [dbo].[ShTaxFlags] ([TaxFlagID])
GO
ALTER TABLE [dbo].[ARInvoices] WITH NOCHECK ADD CONSTRAINT [FK_ARInvoices_GLID_GLAccounts1] FOREIGN KEY ([GLID]) REFERENCES [dbo].[GLAccounts1] ([AccountID])
GO
ALTER TABLE [dbo].[ARInvoices] WITH NOCHECK ADD CONSTRAINT [FK_ARInvoices_LocationID_ARCustomers] FOREIGN KEY ([LocationID]) REFERENCES [dbo].[ARCustomers] ([CustomerID])
GO
ALTER TABLE [dbo].[ARInvoices] WITH NOCHECK ADD CONSTRAINT [FK_ARInvoices_MasterInvoiceID_ARInvoices] FOREIGN KEY ([MasterInvoiceID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO
ALTER TABLE [dbo].[ARInvoices] ADD CONSTRAINT [FK_ARInvoices_NoteID_ARInvoiceNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[ARInvoiceNotes] ([NoteID])
GO
ALTER TABLE [dbo].[ARInvoices] ADD CONSTRAINT [FK_ARInvoices_OrderedByContactID_CMContacts] FOREIGN KEY ([OrderedByContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[ARInvoices] ADD CONSTRAINT [FK_ARInvoices_PrimaryReportDefinitionID_RPReportDefinitions] FOREIGN KEY ([PrimaryReportDefinitionID]) REFERENCES [dbo].[RPReportDefinitions] ([ReportDefinitionID])
GO
ALTER TABLE [dbo].[ARInvoices] ADD CONSTRAINT [FK_ARInvoices_ReceivablePayableID_ARAPReceivablePayables] FOREIGN KEY ([ReceivablePayableID]) REFERENCES [dbo].[ARAPReceivablePayables] ([ReceivablePayableID])
GO
ALTER TABLE [dbo].[ARInvoices] WITH NOCHECK ADD CONSTRAINT [FK_ARInvoices_SalesRepID_ARSalesReps] FOREIGN KEY ([SalesRepID]) REFERENCES [dbo].[ARSalesReps] ([SalesRepID])
GO
ALTER TABLE [dbo].[ARInvoices] ADD CONSTRAINT [FK_ARInvoices_SendContactID_CMContacts] FOREIGN KEY ([SendContactID]) REFERENCES [dbo].[CMContacts] ([ContactID])
GO
ALTER TABLE [dbo].[ARInvoices] WITH NOCHECK ADD CONSTRAINT [FK_ARInvoices_TaxCodeID_ShTaxCodes] FOREIGN KEY ([TaxCodeID]) REFERENCES [dbo].[ShTaxCodes] ([TaxCodeID])
GO
ALTER TABLE [dbo].[ARInvoices] ADD CONSTRAINT [FK_ARInvoices_TaxExemptCodeID_SHTaxExemptCodes] FOREIGN KEY ([TaxExemptCodeID]) REFERENCES [dbo].[SHTaxExemptCodes] ([TaxExemptCodeID])
GO
ALTER TABLE [dbo].[ARInvoices] WITH NOCHECK ADD CONSTRAINT [FK_ARInvoices_TermID_ShTerms] FOREIGN KEY ([TermID]) REFERENCES [dbo].[ShTerms] ([TermID])
GO
ALTER TABLE [dbo].[ARInvoices] ADD CONSTRAINT [FK_ARInvoices_TransactionTypeID_SHTransactionTypes] FOREIGN KEY ([TransactionTypeID]) REFERENCES [dbo].[ShTransactionTypes] ([TransactionTypeID])
GO
ALTER TABLE [dbo].[ARInvoices] WITH NOCHECK ADD CONSTRAINT [FK_ARInvoices_VoidID_ARInvoices] FOREIGN KEY ([VoidID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO