Tables [dbo].[PlasticProvider]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
Row Count (~)0
Created4:09:40 PM Thursday, December 6, 2018
Last Modified7:36:13 PM Thursday, August 29, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsIdentityDefault
Cluster Primary Key PK_PlasticProvider: ProviderIDProviderIDint4
No
1 - 1
Indexes IX_PlasticProvider_Provider: ProviderProvidervarchar(50)50
No
Foreign Keys FK_PlasticProvider_ProviderTypeFID: [dbo].[PlasticProviderType].ProviderTypeFIDIndexes IX_PlasticProvider_ProviderType: ProviderTypeFIDProviderTypeFIDint4
No
StatementDescriptorvarchar(25)25
Yes
UserNamevarchar(1000)1000
No
Credentialsvarchar(1000)1000
No
AccountCodevarchar(50)50
No
HppBaseUrlvarchar(255)255
No
DateModifieddatetime8
No
(getdate())
Foreign Keys FK_PlasticProvider_ModifiedBySysUserFID: [dbo].[Sysuser].ModifiedBySysUserFIDIndexes IX_PlasticProvider_ModifiedBySysUserFID: ModifiedBySysUserFIDModifiedBySysUserFIDint4
No
Inactivebit1
No
((0))
CanHandleCardsbit1
No
((1))
CanHandleCheckingbit1
No
((1))
CanHandleSavingsbit1
No
((1))
Foreign Keys FK_PlasticProvider_NoteTypeFID: [dbo].[NoteType].PaymentNoteTypeFIDIndexes IX_PlasticProvider_PaymentNoteType: PaymentNoteTypeFIDPaymentNoteTypeFIDsmallint2
Yes
UseMoversConnectCredentialsbit1
No
((0))
ClientIdvarchar(1000)1000
No
('')
DisableNewInstrumentsbit1
No
((0))
DisableNewSalesbit1
No
((0))
PreferenceOrderint4
Yes
CurrencyCodevarchar(3)3
No
('USD')
UseProductionUrlbit1
No
((1))
CalculateBestGuessDepositDatebit1
No
((0))
AdjustmentDaysint4
No
((0))
CutoffTimedatetime8
No
('1899-12-30 18:00:00')
IsSaturdayBusinessDaybit1
No
((0))
IsSundayBusinessDaybit1
No
((0))
AdjustForHolidaysbit1
No
((0))
AllowAuthorizationsbit1
No
((0))
WarningCaptureDaysint4
Yes
MaxCaptureDaysint4
Yes
Indexes Indexes
NameColumnsUnique
Cluster Primary Key PK_PlasticProvider: ProviderIDPK_PlasticProviderProviderID
Yes
IX_PlasticProvider_ProviderProvider
Yes
IX_PlasticProvider_ModifiedBySysUserFIDModifiedBySysUserFID
IX_PlasticProvider_PaymentNoteTypePaymentNoteTypeFID
IX_PlasticProvider_ProviderTypeProviderTypeFID
Foreign Keys Foreign Keys
NameColumns
FK_PlasticProvider_ModifiedBySysUserFIDModifiedBySysUserFID->[dbo].[Sysuser].[SysUserID]
FK_PlasticProvider_NoteTypeFIDPaymentNoteTypeFID->[dbo].[NoteType].[NoteTypeID]
FK_PlasticProvider_ProviderTypeFIDProviderTypeFID->[dbo].[PlasticProviderType].[ProviderTypeID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[PlasticProvider]
(
[ProviderID] [int] NOT NULL IDENTITY(1, 1),
[Provider] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ProviderTypeFID] [int] NOT NULL,
[StatementDescriptor] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[UserName] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Credentials] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[AccountCode] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[HppBaseUrl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[DateModified] [datetime] NOT NULL CONSTRAINT [DF_PlasticProvider_DateModified] DEFAULT (getdate()),
[ModifiedBySysUserFID] [int] NOT NULL,
[Inactive] [bit] NOT NULL CONSTRAINT [DF_PlasticProvider_Inactive] DEFAULT ((0)),
[CanHandleCards] [bit] NOT NULL CONSTRAINT [DF_PlasticProvider_CanHandleCards] DEFAULT ((1)),
[CanHandleChecking] [bit] NOT NULL CONSTRAINT [DF_PlasticProvider_CanHandleChecking] DEFAULT ((1)),
[CanHandleSavings] [bit] NOT NULL CONSTRAINT [DF_PlasticProvider_CanHandleSavings] DEFAULT ((1)),
[PaymentNoteTypeFID] [smallint] NULL,
[UseMoversConnectCredentials] [bit] NOT NULL CONSTRAINT [DF_PlasticProvider_UseMoversConnectCredentials] DEFAULT ((0)),
[ClientId] [varchar] (1000) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PlasticProvider_ClientId] DEFAULT (''),
[DisableNewInstruments] [bit] NOT NULL CONSTRAINT [DF_PlasticProvider_DisableNewInstruments] DEFAULT ((0)),
[DisableNewSales] [bit] NOT NULL CONSTRAINT [DF_PlasticProvider_DisableNewSales] DEFAULT ((0)),
[PreferenceOrder] [int] NULL,
[CurrencyCode] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_PlasticProvider_CurrencyCode] DEFAULT ('USD'),
[UseProductionUrl] [bit] NOT NULL CONSTRAINT [DF_PlasticProvider_UseProductionUrl] DEFAULT ((1)),
[CalculateBestGuessDepositDate] [bit] NOT NULL CONSTRAINT [DF_PlasticProvider_CalculateBestGuessDepositDate] DEFAULT ((0)),
[AdjustmentDays] [int] NOT NULL CONSTRAINT [DF_PlasticProvider_AdjustmentDays] DEFAULT ((0)),
[CutoffTime] [datetime] NOT NULL CONSTRAINT [DF_PlasticProvider_CutoffTime] DEFAULT ('1899-12-30 18:00:00'),
[IsSaturdayBusinessDay] [bit] NOT NULL CONSTRAINT [DF_PlasticProvider_IsSaturdayBusinessDay] DEFAULT ((0)),
[IsSundayBusinessDay] [bit] NOT NULL CONSTRAINT [DF_PlasticProvider_IsSundayBusinessDay] DEFAULT ((0)),
[AdjustForHolidays] [bit] NOT NULL CONSTRAINT [DF_PlasticProvider_AdjustForHolidays] DEFAULT ((0)),
[AllowAuthorizations] [bit] NOT NULL CONSTRAINT [DF_PlasticProvider_AllowAuthorizations] DEFAULT ((0)),
[WarningCaptureDays] [int] NULL,
[MaxCaptureDays] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticProvider] ADD CONSTRAINT [PK_PlasticProvider] PRIMARY KEY CLUSTERED  ([ProviderID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticProvider] ADD CONSTRAINT [IX_PlasticProvider_Provider] UNIQUE NONCLUSTERED  ([Provider]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PlasticProvider_ModifiedBySysUserFID] ON [dbo].[PlasticProvider] ([ModifiedBySysUserFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PlasticProvider_PaymentNoteType] ON [dbo].[PlasticProvider] ([PaymentNoteTypeFID]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_PlasticProvider_ProviderType] ON [dbo].[PlasticProvider] ([ProviderTypeFID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[PlasticProvider] ADD CONSTRAINT [FK_PlasticProvider_ModifiedBySysUserFID] FOREIGN KEY ([ModifiedBySysUserFID]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
ALTER TABLE [dbo].[PlasticProvider] ADD CONSTRAINT [FK_PlasticProvider_NoteTypeFID] FOREIGN KEY ([PaymentNoteTypeFID]) REFERENCES [dbo].[NoteType] ([NoteTypeID])
GO
ALTER TABLE [dbo].[PlasticProvider] ADD CONSTRAINT [FK_PlasticProvider_ProviderTypeFID] FOREIGN KEY ([ProviderTypeFID]) REFERENCES [dbo].[PlasticProviderType] ([ProviderTypeID])
GO
GRANT SELECT ON  [dbo].[PlasticProvider] TO [MssExec]
GRANT INSERT ON  [dbo].[PlasticProvider] TO [MssExec]
GRANT DELETE ON  [dbo].[PlasticProvider] TO [MssExec]
GRANT UPDATE ON  [dbo].[PlasticProvider] TO [MssExec]
GO
Uses
Used By