Tables [dbo].[CoExportHistoryARInvoices]
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__38F1704A114C77B8: ExportHistoryARInvoiceIDExportHistoryARInvoiceIDint4
False
1 - 1
Foreign Keys FK_CoExportHistoryARInvoices_ExportHistoryID_CoExportHistory: [dbo].[CoExportHistory].ExportHistoryIDExportHistoryIDint4
False
Foreign Keys FK_CoExportHistoryARInvoices_InvoiceID_ARInvoices: [dbo].[ARInvoices].InvoiceIDInvoiceIDint4
False
ExternalReferenceIDint4
True
ExternalReferencevarchar(64)64
True
KeyNameKey ColumnsUnique
Cluster Primary Key PK__CoExport__38F1704A114C77B8: ExportHistoryARInvoiceIDPK__CoExport__38F1704A114C77B8ExportHistoryARInvoiceID
True
NameColumns
FK_CoExportHistoryARInvoices_ExportHistoryID_CoExportHistoryExportHistoryID->[dbo].[CoExportHistory].[ExportHistoryID]
FK_CoExportHistoryARInvoices_InvoiceID_ARInvoicesInvoiceID->[dbo].[ARInvoices].[InvoiceID]
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