Tables [dbo].[QuickBooksSetup]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CI_AS
HeapYes
Row Count (~)0
Created3:49:51 PM Thursday, December 6, 2018
Last Modified9:07:55 AM Thursday, May 23, 2024
Columns
NameData TypeMax Length (Bytes)Allow NullsDefault
Primary Key PK_QuickBooksSetup: QuickBooksSetupIDCheck Constraints CK_QuickBooksSetupID : ([QuickBooksSetupID]=(1))QuickBooksSetupIDint4
No
AppNamevarchar(64)64
No
QuickBooksUrlvarchar(255)255
No
CompanyIDvarchar(200)200
Yes
CustomerRefreshDatedatetime8
Yes
VendorRefreshDatedatetime8
Yes
RevenueItemRefreshDatedatetime8
Yes
ExpenseAccountRefreshDatedatetime8
Yes
DateModifieddatetime8
No
Foreign Keys FK_QuickBooksSetup_Sysuser: [dbo].[Sysuser].ModifiedBySysUserFIDModifiedBySysUserFIDint4
No
ClientIDvarchar(500)500
Yes
ClientSecretvarchar(500)500
Yes
CsrfKeyvarchar(128)128
Yes
AuthorizationCodevarchar(512)512
Yes
AuthorizationObtaineddatetime8
Yes
OAuth2RefreshTokenvarchar(512)512
Yes
OAuth2RefreshUtcExpirydatetime8
Yes
IsSandboxQbDbbit1
No
((0))
ConnectionDisconnectedDatedatetime8
Yes
Indexes Indexes
NameColumnsUnique
Primary Key PK_QuickBooksSetup: QuickBooksSetupIDPK_QuickBooksSetupQuickBooksSetupID
Yes
Check Constraints Check Constraints
NameOn ColumnConstraint
CK_QuickBooksSetupIDQuickBooksSetupID([QuickBooksSetupID]=(1))
Foreign Keys Foreign Keys
NameColumns
FK_QuickBooksSetup_SysuserModifiedBySysUserFID->[dbo].[Sysuser].[SysUserID]
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE TABLE [dbo].[QuickBooksSetup]
(
[QuickBooksSetupID] [int] NOT NULL,
[AppName] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[QuickBooksUrl] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CompanyID] [varchar] (200) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CustomerRefreshDate] [datetime] NULL,
[VendorRefreshDate] [datetime] NULL,
[RevenueItemRefreshDate] [datetime] NULL,
[ExpenseAccountRefreshDate] [datetime] NULL,
[DateModified] [datetime] NOT NULL,
[ModifiedBySysUserFID] [int] NOT NULL,
[ClientID] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ClientSecret] [varchar] (500) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CsrfKey] [varchar] (128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AuthorizationCode] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[AuthorizationObtained] [datetime] NULL,
[OAuth2RefreshToken] [varchar] (512) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[OAuth2RefreshUtcExpiry] [datetime] NULL,
[IsSandboxQbDb] [bit] NOT NULL CONSTRAINT [DF_QuickBooksSetup_IsSandboxQbDb] DEFAULT ((0)),
[ConnectionDisconnectedDate] [datetime] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[QuickBooksSetup] ADD CONSTRAINT [CK_QuickBooksSetupID] CHECK (([QuickBooksSetupID]=(1)))
GO
ALTER TABLE [dbo].[QuickBooksSetup] ADD CONSTRAINT [PK_QuickBooksSetup] PRIMARY KEY NONCLUSTERED  ([QuickBooksSetupID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[QuickBooksSetup] ADD CONSTRAINT [FK_QuickBooksSetup_Sysuser] FOREIGN KEY ([ModifiedBySysUserFID]) REFERENCES [dbo].[Sysuser] ([SysUserID])
GO
GRANT SELECT ON  [dbo].[QuickBooksSetup] TO [MssExec]
GRANT INSERT ON  [dbo].[QuickBooksSetup] TO [MssExec]
GRANT DELETE ON  [dbo].[QuickBooksSetup] TO [MssExec]
GRANT UPDATE ON  [dbo].[QuickBooksSetup] TO [MssExec]
GO
Uses