Tables [dbo].[RPPres_GLAccountsToRPPresAccounts]
PropertyValue
HeapTrue
Row Count (~)0
Created12:58:43 AM Thursday, March 21, 2019
Last Modified1:13:58 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
MapIDint4
False
1 - 1
Foreign Keys FK_RPPres_GLAccountsToRPPresAccounts_GLAccountID_GLAccounts: [dbo].[GLAccounts].GLAccountIDGLAccountIDint4
True
Foreign Keys FK_RPPres_GLAccountsToRPPresAccounts_DeptID_GLDepts: [dbo].[GLDepts].DeptIDDeptIDint4
True
Foreign Keys FK_RPPres_GLAccountsToRPPresAccounts_RPPresAccountID_RPPres_Accounts: [dbo].[RPPres_Accounts].RPPresAccountIDRPPresAccountIDint4
True
Percentagedecimal(6,4)5
True
Amountdecimal(14,4)9
True
DaysInRangeint4
True
ModelTypeAllocationIDint4
True
NameColumns
FK_RPPres_GLAccountsToRPPresAccounts_DeptID_GLDeptsDeptID->[dbo].[GLDepts].[DeptID]
FK_RPPres_GLAccountsToRPPresAccounts_GLAccountID_GLAccountsGLAccountID->[dbo].[GLAccounts].[AccountID]
FK_RPPres_GLAccountsToRPPresAccounts_RPPresAccountID_RPPres_AccountsRPPresAccountID->[dbo].[RPPres_Accounts].[AccountID]
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