CREATE TABLE [dbo].[XLedgerGLARAP]
(
[XLedgerGLARAPId] [int] NOT NULL IDENTITY(1, 1),
[TypeName] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AccountingAccountFid] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerGLARAP] ADD CONSTRAINT [CK_XLedgerGLARAP_TypeName] CHECK (([TypeName]='SD' OR [TypeName]='PM' OR [TypeName]='AR' OR [TypeName]='AP'))
GO
ALTER TABLE [dbo].[XLedgerGLARAP] ADD CONSTRAINT [PK_XLedgerGLARAP] PRIMARY KEY NONCLUSTERED  ([XLedgerGLARAPId]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerGLARAP] ADD CONSTRAINT [IX_XLedgerGLARAP_TypeName] UNIQUE CLUSTERED  ([TypeName]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[XLedgerGLARAP] ADD CONSTRAINT [FK_XLedgerGLARAP_AccountingAccount] FOREIGN KEY ([AccountingAccountFid]) REFERENCES [dbo].[AccountingAccount] ([AccountingAccountId])
GO
GRANT SELECT ON  [dbo].[XLedgerGLARAP] TO [MssExec]
GRANT INSERT ON  [dbo].[XLedgerGLARAP] TO [MssExec]
GRANT DELETE ON  [dbo].[XLedgerGLARAP] TO [MssExec]
GRANT UPDATE ON  [dbo].[XLedgerGLARAP] TO [MssExec]
GO