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,
[XLedgerJournalHeaderFid] [int] NULL,
[RequestGroupIdentifier] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) 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 UNIQUE NONCLUSTERED INDEX [IX_XLedgerJournalEntryBatchItem_XLedgerDbId] ON [dbo].[XLedgerJournalEntryBatchItem] ([XLedgerDbId]) WHERE ([XLedgerDbId] IS NOT NULL) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_XLedgerJournalEntryBatchItem_XLedgerJournalHeaderFid] ON [dbo].[XLedgerJournalEntryBatchItem] ([XLedgerJournalHeaderFid]) WHERE ([XLedgerJournalHeaderFid] 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_XLedgerJournalEntryBatch] FOREIGN KEY ([XLedgerJournalEntryBatchFid]) REFERENCES [dbo].[XLedgerJournalEntryBatch] ([XLedgerJournalEntryBatchId])
GO
ALTER TABLE [dbo].[XLedgerJournalEntryBatchItem] ADD CONSTRAINT [FK_XLedgerJournalEntryBatchItem_XLedgerJournalHeader] FOREIGN KEY ([XLedgerJournalHeaderFid]) REFERENCES [dbo].[XLedgerJournalHeader] ([XLedgerJournalHeaderId])
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