Table: dbo.Quick_Books_Transaction
This table contains information about transactions that we have imported from quickbooks.
Columns
NameTypeConstraintsDescription
quick_books_transaction_KEYint (4)NOT NULLThe primary key.
client_KEYint (4)NOT NULLForeign key to Client table. Client for whom this transaction was imported.
quick_books_transaction_idnvarchar (76)NOT NULLUnique identifier of the transaction in quickbooks, according to Intuit documentation.
Primary key
NameColumnsDescription
PK_Quick_Books_Transactionquick_books_transaction_KEY
Unique constraints
NameColumnsDescription
UK_Quick_Books_Transaction$quick_books_transaction_id$client_KEYquick_books_transaction_id, client_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Quick_Books_Transaction__Client__client_KEYclient_KEYClient (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Quick_Books_Transaction_N_GL_Transaction__Quick_Books_Transaction__quick_books_transaction_KEYquick_books_transaction_KEYQuick_Books_Transaction_N_GL_Transaction
FK_Quick_Books_Transaction_Distribution__Quick_Books_Transaction__quick_books_transaction_KEYquick_books_transaction_KEYQuick_Books_Transaction_Distribution

Schema diagram