[dbo].[QuickBooksSetup]

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Heap
Row Count (~)	0
Created	3:49:51 PM Thursday, December 6, 2018
Last Modified	9:11:18 AM Friday, November 8, 2024

Name	Data Type	Max Length (Bytes)	Default
QuickBooksSetupID	int	4
AppName	varchar(64)	64
QuickBooksUrl	varchar(255)	255
CompanyID	varchar(200)	200
CustomerRefreshDate	datetime	8
VendorRefreshDate	datetime	8
RevenueItemRefreshDate	datetime	8
ExpenseAccountRefreshDate	datetime	8
DateModified	datetime	8
ModifiedBySysUserFID	int	4
ClientID	varchar(500)	500
ClientSecret	varchar(500)	500
CsrfKey	varchar(128)	128
AuthorizationCode	varchar(512)	512
AuthorizationObtained	datetime	8
OAuth2RefreshToken	varchar(512)	512
OAuth2RefreshUtcExpiry	datetime	8
IsSandboxQbDb	bit	1	((0))
ConnectionDisconnectedDate	datetime	8

	Name	Columns	Unique
	PK_QuickBooksSetup	QuickBooksSetupID

Name	On Column	Constraint
CK_QuickBooksSetupID	QuickBooksSetupID	([QuickBooksSetupID]=(1))

Name	Columns
FK_QuickBooksSetup_Sysuser	ModifiedBySysUserFID->[dbo].[Sysuser].[SysUserID]

Type	Action	Owning Principal
Grant	Delete	MssExec
Grant	Insert	MssExec
Grant	Select	MssExec
Grant	Update	MssExec

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