Table: dbo.Quick_Books_Account_GL_Account
This table stores a quick book account gl account data
Columns
Name | Type | Constraints | Description
quick_books_account_KEY | int (4) | NOT NULL | Primary key.
gl_account_KEY | int (4) | NOT NULL | The GL Account for this quick book account.
gl_account_type_KEY | int (4) | NOT NULL | The GL Account Type for this quick book account. Not required to match the type of the GL Account.
is_core_account | bit (1) | NOT NULL | Indicates that this quick books account can be considered a core account.
quick_books_account_integration_direction_KEY | tinyint (1) | NOT NULL | Tells if the given GL Account was a result of an Import, or is for Export or if it pulls double duty.

Primary key
Name | Columns | Description
PK_Quick_Books_Account_GL_Account$quick_books_account_KEY | quick_books_account_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Quick_Books_Account_GL_Account__Quick_Books_Account_Integration_Direction__quick_books_account_integration_direction_KEY | quick_books_account_integration_direction_KEY | Quick_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_KEY | gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Quick_Books_Account_GL_Account__GL_Account_Type__gl_account_type_KEY | gl_account_type_KEY | GL_Account_Type (gl_account_type_KEY) |
FK_Quick_Books_Account_GL_Account__Quick_Books_Account__quick_books_account_KEY | quick_books_account_KEY | Quick_Books_Account (quick_books_account_KEY) |