CREATE TABLE [dbo].[BcTransactionUploadResult]
(
[BcTransactionUploadResultId] [int] NOT NULL IDENTITY(1, 1),
[JournalBcId] [uniqueidentifier] NULL,
[BcJournalTypeFid] [int] NOT NULL,
[FailedDuringPhaseFid] [int] NULL,
[Exception] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Resolved] [bit] NOT NULL CONSTRAINT [DF_BcTransactionUploadResult_Resolved] DEFAULT ((0)),
[CompletedAt] [datetimeoffset] NOT NULL CONSTRAINT [DF_BcTransactionUploadResult_CompletedAt] DEFAULT (sysdatetimeoffset()),
[JournalJson] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DocumentNumber] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[BcTransactionUploadResult] ADD CONSTRAINT [PK_BcTransactionUploadResult] PRIMARY KEY CLUSTERED  ([BcTransactionUploadResultId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[BcTransactionUploadResult] ADD CONSTRAINT [IX_BcTransactionUploadResult_JournalBcId] UNIQUE NONCLUSTERED  ([JournalBcId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[BcTransactionUploadResult] ADD CONSTRAINT [FK_BcTransactionUploadResult_BcJournalType] FOREIGN KEY ([BcJournalTypeFid]) REFERENCES [dbo].[BcJournalType] ([BcJournalTypeId])
GO
ALTER TABLE [dbo].[BcTransactionUploadResult] ADD CONSTRAINT [FK_BcTransactionUploadResult_BcTransactionUploadPhase] FOREIGN KEY ([FailedDuringPhaseFid]) REFERENCES [dbo].[BcTransactionUploadPhase] ([BcTransactionUploadPhaseId])
GO
GRANT SELECT ON  [dbo].[BcTransactionUploadResult] TO [MssExec]
GRANT INSERT ON  [dbo].[BcTransactionUploadResult] TO [MssExec]
GRANT DELETE ON  [dbo].[BcTransactionUploadResult] TO [MssExec]
GRANT UPDATE ON  [dbo].[BcTransactionUploadResult] TO [MssExec]
GO