CREATE TABLE [dbo].[CoExportHistoryARInvoices]
(
[ExportHistoryARInvoiceID] [int] NOT NULL IDENTITY(1, 1),
[ExportHistoryID] [int] NOT NULL,
[InvoiceID] [int] NOT NULL,
[ExternalReferenceID] [int] NULL,
[ExternalReference] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CoExportHistoryARInvoices] ADD CONSTRAINT [PK__CoExport__38F1704A114C77B8] PRIMARY KEY CLUSTERED ([ExportHistoryARInvoiceID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CoExportHistoryARInvoices] ADD CONSTRAINT [FK_CoExportHistoryARInvoices_ExportHistoryID_CoExportHistory] FOREIGN KEY ([ExportHistoryID]) REFERENCES [dbo].[CoExportHistory] ([ExportHistoryID])
GO
ALTER TABLE [dbo].[CoExportHistoryARInvoices] ADD CONSTRAINT [FK_CoExportHistoryARInvoices_InvoiceID_ARInvoices] FOREIGN KEY ([InvoiceID]) REFERENCES [dbo].[ARInvoices] ([InvoiceID])
GO