Table: dbo.Quick_Books_Account_GL_Account
This table stores a quick book account gl account data
Columns
NameTypeConstraintsDescription
quick_books_account_KEYint (4)NOT NULLPrimary key.
gl_account_KEYint (4)NOT NULLThe GL Account for this quick book account.
gl_account_type_KEYint (4)NOT NULLThe GL Account Type for this quick book account. Not required to match the type of the GL Account.
is_core_accountbit (1)NOT NULLIndicates that this quick books account can be considered a core account.
quick_books_account_integration_direction_KEYtinyint (1)NOT NULLTells if the given GL Account was a result of an Import, or is for Export or if it pulls double duty.
Primary key
NameColumnsDescription
PK_Quick_Books_Account_GL_Account$quick_books_account_KEYquick_books_account_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Quick_Books_Account_GL_Account__Quick_Books_Account_Integration_Direction__quick_books_account_integration_direction_KEYquick_books_account_integration_direction_KEYQuick_Books_Account_Integration_Direction (quick_books_account_integration_direction_KEY)Foreign key constraint to the Quick_Books_Account_Integration_Direction table.
FK_Quick_Books_Account_GL_Account__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)
FK_Quick_Books_Account_GL_Account__GL_Account_Type__gl_account_type_KEYgl_account_type_KEYGL_Account_Type (gl_account_type_KEY)
FK_Quick_Books_Account_GL_Account__Quick_Books_Account__quick_books_account_KEYquick_books_account_KEYQuick_Books_Account (quick_books_account_KEY)

Schema diagram