CREATE TABLE [dbo].[XLedgerAuthorityTypeObjectValueMap]
(
[XLedgerAuthorityTypeObjectValueMapId] [int] NOT NULL IDENTITY(1, 1),
[AuthorityTypeFID] [int] NOT NULL,
[XLedgerAuthorityTypeObjectValueFID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerAuthorityTypeObjectValueMap] ADD CONSTRAINT [PK_XLedgerAuthorityTypeObjectValueMap] PRIMARY KEY CLUSTERED  ([XLedgerAuthorityTypeObjectValueMapId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerAuthorityTypeObjectValueMap] ADD CONSTRAINT [IX_XLedgerAuthorityTypeObjectValueMap_MoveGroupFID_XLedgerAuthorityTypeObjectValueFID] UNIQUE NONCLUSTERED  ([AuthorityTypeFID], [XLedgerAuthorityTypeObjectValueFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_XLedgerAuthorityTypeObjectValueMap_XLedgerAuthorityTypeObjectValueFID] ON [dbo].[XLedgerAuthorityTypeObjectValueMap] ([XLedgerAuthorityTypeObjectValueFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerAuthorityTypeObjectValueMap] ADD CONSTRAINT [FK_XLedgerAuthorityTypeObjectValueMap_AuthorityTypes] FOREIGN KEY ([AuthorityTypeFID]) REFERENCES [dbo].[AuthorityTypes] ([AuthPriKey])
GO
ALTER TABLE [dbo].[XLedgerAuthorityTypeObjectValueMap] ADD CONSTRAINT [FK_XLedgerAuthorityTypeObjectValueMap_XLedgerAuthorityTypeObjectValue] FOREIGN KEY ([XLedgerAuthorityTypeObjectValueFID]) REFERENCES [dbo].[XLedgerAuthorityTypeObjectValue] ([XLedgerAuthorityTypeObjectValueId])
GO
GRANT SELECT ON  [dbo].[XLedgerAuthorityTypeObjectValueMap] TO [MssExec]
GRANT INSERT ON  [dbo].[XLedgerAuthorityTypeObjectValueMap] TO [MssExec]
GRANT DELETE ON  [dbo].[XLedgerAuthorityTypeObjectValueMap] TO [MssExec]
GRANT UPDATE ON  [dbo].[XLedgerAuthorityTypeObjectValueMap] TO [MssExec]
GO