CREATE TABLE [dbo].[CoExportHistoryAPVouchers]
(
[ExportHistoryAPVoucherID] [int] NOT NULL IDENTITY(1, 1),
[ExportHistoryID] [int] NOT NULL,
[VoucherID] [int] NOT NULL,
[ExternalReferenceID] [int] NULL,
[ExternalReference] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CoExportHistoryAPVouchers] ADD CONSTRAINT [PK__CoExport__251072AE85C6019B] PRIMARY KEY CLUSTERED ([ExportHistoryAPVoucherID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CoExportHistoryAPVouchers] ADD CONSTRAINT [FK_CoExportHistoryAPVouchers_ExportHistoryID_CoExportHistory] FOREIGN KEY ([ExportHistoryID]) REFERENCES [dbo].[CoExportHistory] ([ExportHistoryID])
GO
ALTER TABLE [dbo].[CoExportHistoryAPVouchers] ADD CONSTRAINT [FK_CoExportHistoryAPVouchers_VoucherID_APVouchers] FOREIGN KEY ([VoucherID]) REFERENCES [dbo].[APVouchers] ([VoucherID])
GO