CREATE TABLE [dbo].[RPPres_GLAccountsToRPPresAccounts]
(
[MapID] [int] NOT NULL IDENTITY(1, 1),
[GLAccountID] [int] NULL,
[DeptID] [int] NULL,
[RPPresAccountID] [int] NULL,
[Percentage] [decimal] (6, 4) NULL,
[Amount] [decimal] (14, 4) NULL,
[DaysInRange] [int] NULL,
[ModelTypeAllocationID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RPPres_GLAccountsToRPPresAccounts] ADD CONSTRAINT [FK_RPPres_GLAccountsToRPPresAccounts_DeptID_GLDepts] FOREIGN KEY ([DeptID]) REFERENCES [dbo].[GLDepts] ([DeptID])
GO
ALTER TABLE [dbo].[RPPres_GLAccountsToRPPresAccounts] ADD CONSTRAINT [FK_RPPres_GLAccountsToRPPresAccounts_GLAccountID_GLAccounts] FOREIGN KEY ([GLAccountID]) REFERENCES [dbo].[GLAccounts] ([AccountID])
GO
ALTER TABLE [dbo].[RPPres_GLAccountsToRPPresAccounts] ADD CONSTRAINT [FK_RPPres_GLAccountsToRPPresAccounts_RPPresAccountID_RPPres_Accounts] FOREIGN KEY ([RPPresAccountID]) REFERENCES [dbo].[RPPres_Accounts] ([AccountID])
GO