Table: dbo.Journal
Columns
NameTypeConstraintsDescription
journal_KEYint (4)NOT NULLPrimary key for this table
client_KEYint (4)NOT NULLKey of client that owns the journal
descriptionnvarchar (60)NOT NULLJournal description
gl_report_codenvarchar (10)The GL report code associated with each transaction
bank_transaction_type_KEYint (4)The type of bank transaction
Primary key
NameColumnsDescription
PK_Journaljournal_KEY
Unique constraints
NameColumnsDescription
UK_Journal$description$client_KEYdescription, client_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Journal__Bank_Transaction_Type__bank_transaction_type_KEYbank_transaction_type_KEYBank_Transaction_Type (bank_transaction_type_KEY)
FK_Journal__Client__client_KEYclient_KEYClient (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Trial_Balance_Split_Screen_Grid_Option__Journal__journal_KEYjournal_KEYTrial_Balance_Split_Screen_Grid_Option
FK_Bank_Feeds_Transaction_Option__Journal__journal_KEYjournal_KEYBank_Feeds_Transaction_Option
FK_Apply_Customer_Payment_Option__Journal__journal_KEYjournal_KEYApply_Customer_Payment_Option
FK_Payroll_Journal_Entry_Option__Journal__journal_KEYjournal_KEYPayroll_Journal_Entry_Option
FK_Transaction_Template__Journal__journal_KEYjournal_KEYTransaction_Template
FK_GL_Transaction__Journal__journal_KEYjournal_KEYGL_Transaction
FK_Manage_AP_Payment_User_Preference__Journal__default__journal_KEYdefault__journal_KEYManage_AP_Payment_User_Preference
FK_AR_Enter_Invoice_Option__Journal__default__journal_KEYdefault__journal_KEYAR_Enter_Invoice_Option
FK_Client_GL_Setup__Journal__account_activity__journal_KEYaccount_activity__journal_KEYClient_GL_Setup
FK_Client_GL_Setup__Journal__firm_vendor_liability__journal_KEYfirm_vendor_liability__journal_KEYClient_GL_Setup
FK_Client_GL_Setup__Journal__fixed_asset_cs_integration__journal_KEYfixed_asset_cs_integration__journal_KEYClient_GL_Setup
FK_Client_GL_Setup__Journal__impound_withdrawal__journal_KEYimpound_withdrawal__journal_KEYClient_GL_Setup
FK_Client_GL_Setup__Journal__payroll_check__journal_KEYpayroll_check__journal_KEYClient_GL_Setup
FK_Client_GL_Setup__Journal__practice_cs_integration__journal_KEYpractice_cs_integration__journal_KEYClient_GL_Setup
FK_Client_GL_Setup__Journal__unprinted_check_accrual__journal_KEYunprinted_check_accrual__journal_KEYClient_GL_Setup
FK_Client_GL_Setup__Journal__vendor_payment__journal_KEYvendor_payment__journal_KEYClient_GL_Setup
FK_Checkbook__Journal__bank_reconciliation__journal_KEYbank_reconciliation__journal_KEYCheckbook
FK_AP_Enter_Transaction_List_View_Column_Option__Journal__default__journal_KEYdefault__journal_KEYAP_Enter_Transaction_List_View_Column_Option
FK_Pending_AP_Payment__Journal__journal_KEYjournal_KEYPending_AP_Payment
FK_Journal_N_Checkbook__Journal__journal_KEYjournal_KEYJournal_N_Checkbook
FK_Manage_AP_Payment_Option__Journal__default_application__journal_KEYdefault_application__journal_KEYManage_AP_Payment_Option
FK_Manage_AP_Payment_Option__Journal__default_payment__journal_KEYdefault_payment__journal_KEYManage_AP_Payment_Option
FK_Enter_Transaction_User_Preference__Journal__default__journal_KEYdefault__journal_KEYEnter_Transaction_User_Preference
FK_AR_Customer_Payment_Option__Journal__default__journal_KEYdefault__journal_KEYAR_Customer_Payment_Option

Schema diagram