CREATE TABLE [dbo].[XLedgerApplyToJournalDetailMap]
(
[XLedgerApplyToJournalDetailMapId] [int] NOT NULL IDENTITY(1, 1),
[XLedgerApplyToJournalDetailFid] [int] NOT NULL,
[AcctTransactionsApplyToInfoFid] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerApplyToJournalDetailMap] ADD CONSTRAINT [PK_XLedgerApplyToJournalDetailMap] PRIMARY KEY NONCLUSTERED  ([XLedgerApplyToJournalDetailMapId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerApplyToJournalDetailMap] ADD CONSTRAINT [IX_XLedgerApplyToJournalDetailMap_AcctTransactionsApplyToInfoFid] UNIQUE CLUSTERED  ([AcctTransactionsApplyToInfoFid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_XLedgerApplyToJournalDetailMap_XLedgerApplyToJournalDetailFid] ON [dbo].[XLedgerApplyToJournalDetailMap] ([XLedgerApplyToJournalDetailFid]) INCLUDE ([AcctTransactionsApplyToInfoFid]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerApplyToJournalDetailMap] ADD CONSTRAINT [FK_XLedgerApplyToJournalDetailMap_AcctTransactionsApplyToInfo] FOREIGN KEY ([AcctTransactionsApplyToInfoFid]) REFERENCES [dbo].[AcctTransactionsApplyToInfo] ([AcctTransactionsApplyToInfoID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[XLedgerApplyToJournalDetailMap] ADD CONSTRAINT [FK_XLedgerApplyToJournalDetailMap_XLedgerApplyToJournalDetail] FOREIGN KEY ([XLedgerApplyToJournalDetailFid]) REFERENCES [dbo].[XLedgerApplyToJournalDetail] ([XLedgerApplyToJournalDetailId]) ON DELETE CASCADE
GO
GRANT SELECT ON  [dbo].[XLedgerApplyToJournalDetailMap] TO [MssExec]
GRANT INSERT ON  [dbo].[XLedgerApplyToJournalDetailMap] TO [MssExec]
GRANT DELETE ON  [dbo].[XLedgerApplyToJournalDetailMap] TO [MssExec]
GRANT UPDATE ON  [dbo].[XLedgerApplyToJournalDetailMap] TO [MssExec]
GO