CREATE TABLE [dbo].[XLedgerJournalEntryBatchItem]
(
[XLedgerJournalEntryBatchItemId] [int] NOT NULL IDENTITY(1, 1),
[XLedgerJournalEntryBatchFid] [int] NOT NULL,
[AcctTransactionFid] [int] NOT NULL,
[XglFid] [int] NOT NULL,
[NominalBranchObjectValueXLedgerDbId] [bigint] NOT NULL,
[OpposingBranchObjectValueXLedgerDbId] [bigint] NOT NULL,
[NominalXLedgerCompanyXLedgerDbId] [bigint] NOT NULL,
[OpposingXLedgerCompanyXLedgerDbId] [bigint] NOT NULL,
[NominalAccountingAccountFid] [int] NOT NULL,
[OpposingAccountingAccountFid] [int] NOT NULL,
[XLedgerCustomerXLedgerDbId] [bigint] NULL,
[XLedgerSupplierXLedgerDbId] [bigint] NULL,
[XLedgerDbId] [bigint] NULL,
[XLedgerTransactionHeaderFid] [int] NULL,
[RequestGroupIdentifier] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[XLedgerTransactionUploadFailureFid] [int] NULL,
[Resolved] [bit] NOT NULL CONSTRAINT [DF_XLedgerJournalEntryBatchItem_Resolved] DEFAULT ((0)),
[XLedgerBankAccountFid] [int] NULL,
[ExternalIdentifier] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[PlaceOnHold] [bit] NOT NULL CONSTRAINT [DF_XLedgerJournalEntryBatchItem_PlaceOnHold] DEFAULT ((0))
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [PK_XLedgerJournalEntryBatchItem] PRIMARY KEY CLUSTERED  ([XLedgerJournalEntryBatchItemId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [IX_XLedgerJournalEntryBatchItem_XLedgerJournalEntryBatchFid_AcctTransactionFid] UNIQUE NONCLUSTERED  ([XLedgerJournalEntryBatchFid], [AcctTransactionFid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_XLedgerJournalEntryBatchItem_AcctTransactionFid_XLedgerTransactionHeaderFid] ON [dbo].[XLedgerJournalEntryBatchItem] ([AcctTransactionFid], [XLedgerTransactionHeaderFid]) WHERE ([XLedgerTransactionHeaderFid] IS NOT NULL) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [IX_XLedgerJournalEntryBatchItem_XLedgerDbId] ON [dbo].[XLedgerJournalEntryBatchItem] ([XLedgerDbId]) INCLUDE ([Resolved]) WHERE ([XLedgerDbId] IS NOT NULL) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_XLedgerJournalEntryBatchItem_XLedgerTransactionHeaderFid] ON [dbo].[XLedgerJournalEntryBatchItem] ([XLedgerTransactionHeaderFid]) WHERE ([XLedgerTransactionHeaderFid] IS NOT NULL) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_XLedgerJournalEntryBatchItem_XLedgerTransactionUploadFailureFid] ON [dbo].[XLedgerJournalEntryBatchItem] ([XLedgerTransactionUploadFailureFid]) WHERE ([XLedgerTransactionUploadFailureFid] IS NOT NULL) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [FK_XLedgerJournalEntryBatchItem_AcctTransactions] FOREIGN KEY ([AcctTransactionFid]) REFERENCES [dbo].[AcctTransactions] ([ATPriKey])
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [FK_XLedgerJournalEntryBatchItem_NominalAccountingAccount] FOREIGN KEY ([NominalAccountingAccountFid]) REFERENCES [dbo].[AccountingAccount] ([AccountingAccountId])
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [FK_XLedgerJournalEntryBatchItem_XLedgerBranchObjectValue_Nominal] FOREIGN KEY ([NominalBranchObjectValueXLedgerDbId]) REFERENCES [dbo].[XLedgerBranchObjectValue] ([XLedgerDbId])
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [FK_XLedgerJournalEntryBatchItem_OpposingAccountingAccount] FOREIGN KEY ([OpposingAccountingAccountFid]) REFERENCES [dbo].[AccountingAccount] ([AccountingAccountId])
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [FK_XLedgerJournalEntryBatchItem_XLedgerBranchObjectValue_Opposing] FOREIGN KEY ([OpposingBranchObjectValueXLedgerDbId]) REFERENCES [dbo].[XLedgerBranchObjectValue] ([XLedgerDbId])
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [FK_XLedgerJournalEntryBatchItem_Xgl] FOREIGN KEY ([XglFid]) REFERENCES [dbo].[Xgl] ([XglId])
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [FK_XLedgerJournalEntryBatchItem_XLedgerBankAccountFid] FOREIGN KEY ([XLedgerBankAccountFid]) REFERENCES [dbo].[XLedgerBankAccount] ([XLedgerBankAccountId])
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [FK_XLedgerJournalEntryBatchItem_XLedgerJournalEntryBatch] FOREIGN KEY ([XLedgerJournalEntryBatchFid]) REFERENCES [dbo].[XLedgerJournalEntryBatch] ([XLedgerJournalEntryBatchId])
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [FK_XLedgerJournalEntryBatchItem_XLedgerTransactionHeader] FOREIGN KEY ([XLedgerTransactionHeaderFid]) REFERENCES [dbo].[XLedgerTransactionHeader] ([XLedgerTransactionHeaderId])
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [FK_XLedgerJournalEntryBatchItem_XLedgerTransactionUploadFailure] FOREIGN KEY ([XLedgerTransactionUploadFailureFid]) REFERENCES [dbo].[XLedgerTransactionUploadFailure] ([XLedgerTransactionUploadFailureId])
GO
GRANT SELECT ON  [dbo].[XLedgerJournalEntryBatchItem] TO [MssExec]
GRANT INSERT ON  [dbo].[XLedgerJournalEntryBatchItem] TO [MssExec]
GRANT DELETE ON  [dbo].[XLedgerJournalEntryBatchItem] TO [MssExec]
GRANT UPDATE ON  [dbo].[XLedgerJournalEntryBatchItem] TO [MssExec]
GO