Tables [dbo].[CoExportMappingGLAccounts]
PropertyValue
Row Count (~)0
Created12:57:05 AM Thursday, March 21, 2019
Last Modified1:01:56 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK__CoExport__9DD52E292EA5EF61: ExportMappingGLAccountIDExportMappingGLAccountIDint4
False
1 - 1
AccountIDint4
False
ExternalAccountIDint4
False
DestinationApplicationIDint4
True
CreateDatedatetime8
False
(getdate())
KeyNameKey ColumnsUnique
Cluster Primary Key PK__CoExport__9DD52E292EA5EF61: ExportMappingGLAccountIDPK__CoExport__9DD52E292EA5EF61ExportMappingGLAccountID
True
CREATE TABLE [dbo].[CoExportMappingGLAccounts]
(
[ExportMappingGLAccountID] [int] NOT NULL IDENTITY(1, 1),
[AccountID] [int] NOT NULL,
[ExternalAccountID] [int] NOT NULL,
[DestinationApplicationID] [int] NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_CoExportMappingGLAccounts_CreateDate] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CoExportMappingGLAccounts] ADD CONSTRAINT [PK__CoExport__9DD52E292EA5EF61] PRIMARY KEY CLUSTERED  ([ExportMappingGLAccountID]) ON [PRIMARY]
GO