Table: dbo.Journal
Columns
Name | Type | Constraints | Description
journal_KEY | int (4) | NOT NULL | Primary key for this table
client_KEY | int (4) | NOT NULL | Key of client that owns the journal
description | nvarchar (60) | NOT NULL | Journal description
gl_report_code | nvarchar (10) |  | The GL report code associated with each transaction
bank_transaction_type_KEY | int (4) |  | The type of bank transaction

Primary key
Name | Columns | Description
PK_Journal | journal_KEY |
Unique constraints
Name | Columns | Description
UK_Journal$description$client_KEY | description, client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Journal__Bank_Transaction_Type__bank_transaction_type_KEY | bank_transaction_type_KEY | Bank_Transaction_Type (bank_transaction_type_KEY) |
FK_Journal__Client__client_KEY | client_KEY | Client (client_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Trial_Balance_Split_Screen_Grid_Option__Journal__journal_KEY | journal_KEY | Trial_Balance_Split_Screen_Grid_Option |
FK_Bank_Feeds_Transaction_Option__Journal__journal_KEY | journal_KEY | Bank_Feeds_Transaction_Option |
FK_Apply_Customer_Payment_Option__Journal__journal_KEY | journal_KEY | Apply_Customer_Payment_Option |
FK_Payroll_Journal_Entry_Option__Journal__journal_KEY | journal_KEY | Payroll_Journal_Entry_Option |
FK_Transaction_Template__Journal__journal_KEY | journal_KEY | Transaction_Template |
FK_GL_Transaction__Journal__journal_KEY | journal_KEY | GL_Transaction |
FK_Manage_AP_Payment_User_Preference__Journal__default__journal_KEY | default__journal_KEY | Manage_AP_Payment_User_Preference |
FK_AR_Enter_Invoice_Option__Journal__default__journal_KEY | default__journal_KEY | AR_Enter_Invoice_Option |
FK_Client_GL_Setup__Journal__account_activity__journal_KEY | account_activity__journal_KEY | Client_GL_Setup |
FK_Client_GL_Setup__Journal__firm_vendor_liability__journal_KEY | firm_vendor_liability__journal_KEY | Client_GL_Setup |
FK_Client_GL_Setup__Journal__fixed_asset_cs_integration__journal_KEY | fixed_asset_cs_integration__journal_KEY | Client_GL_Setup |
FK_Client_GL_Setup__Journal__impound_withdrawal__journal_KEY | impound_withdrawal__journal_KEY | Client_GL_Setup |
FK_Client_GL_Setup__Journal__payroll_check__journal_KEY | payroll_check__journal_KEY | Client_GL_Setup |
FK_Client_GL_Setup__Journal__practice_cs_integration__journal_KEY | practice_cs_integration__journal_KEY | Client_GL_Setup |
FK_Client_GL_Setup__Journal__unprinted_check_accrual__journal_KEY | unprinted_check_accrual__journal_KEY | Client_GL_Setup |
FK_Client_GL_Setup__Journal__vendor_payment__journal_KEY | vendor_payment__journal_KEY | Client_GL_Setup |
FK_Checkbook__Journal__bank_reconciliation__journal_KEY | bank_reconciliation__journal_KEY | Checkbook |
FK_AP_Enter_Transaction_List_View_Column_Option__Journal__default__journal_KEY | default__journal_KEY | AP_Enter_Transaction_List_View_Column_Option |
FK_Pending_AP_Payment__Journal__journal_KEY | journal_KEY | Pending_AP_Payment |
FK_Journal_N_Checkbook__Journal__journal_KEY | journal_KEY | Journal_N_Checkbook |
FK_Manage_AP_Payment_Option__Journal__default_application__journal_KEY | default_application__journal_KEY | Manage_AP_Payment_Option |
FK_Manage_AP_Payment_Option__Journal__default_payment__journal_KEY | default_payment__journal_KEY | Manage_AP_Payment_Option |
FK_Enter_Transaction_User_Preference__Journal__default__journal_KEY | default__journal_KEY | Enter_Transaction_User_Preference |
FK_AR_Customer_Payment_Option__Journal__default__journal_KEY | default__journal_KEY | AR_Customer_Payment_Option |