Tables [dbo].[CoExportHistoryAPVouchers]
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created12:57:04 AM Thursday, March 21, 2019
Last Modified1:10:34 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK__CoExport__251072AE85C6019B: ExportHistoryAPVoucherIDExportHistoryAPVoucherIDint4
False
1 - 1
Foreign Keys FK_CoExportHistoryAPVouchers_ExportHistoryID_CoExportHistory: [dbo].[CoExportHistory].ExportHistoryIDExportHistoryIDint4
False
Foreign Keys FK_CoExportHistoryAPVouchers_VoucherID_APVouchers: [dbo].[APVouchers].VoucherIDVoucherIDint4
False
ExternalReferenceIDint4
True
ExternalReferencevarchar(64)64
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK__CoExport__251072AE85C6019B: ExportHistoryAPVoucherIDPK__CoExport__251072AE85C6019BExportHistoryAPVoucherID
True
NameColumns
FK_CoExportHistoryAPVouchers_ExportHistoryID_CoExportHistoryExportHistoryID->[dbo].[CoExportHistory].[ExportHistoryID]
FK_CoExportHistoryAPVouchers_VoucherID_APVouchersVoucherID->[dbo].[APVouchers].[VoucherID]
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