Table: dbo.Journal_Entry
Table for journal entries
Columns
Name | Type | Constraints | Description
journal_entry_KEY | int (4) | NOT NULL | Primary key
transaction_date | smalldatetime (4) |  | Date of the journal entry
journal_entry_type_KEY | int (4) | NOT NULL | The type of journal entry
reference_number | nvarchar (32) | NOT NULL | Reference number
memo | nvarchar (480) | NOT NULL | A memo associated with the journal entry
description | nvarchar (240) | NOT NULL | The journal entry description
client_KEY | int (4) | NOT NULL |
transaction_status_KEY | int (4) | NOT NULL |
data_origin_KEY | int (4) | NOT NULL | The origin of each journal entry. For example, Data Entry or CSA Conversion.
schedule_m3_tax_code_attribute_KEY | int (4) |  | For Tax Journal Entries, this column contains an attribute required for Schedule M-3 Code mapping. For all other Journal Entry types, this column is null.
auto_reversing | bit (1) | NOT NULL | Flag indicating the journal entry should be automatically reversed.
workpaper_reference | nvarchar (50) | NOT NULL | Related workpaper for this journal entry
journal_entry_misstatement_type_KEY | int (4) |  | The optional Misstatement type to apply to a Potential type Journal Entry
is_activity_journal_entry | bit (1) | NOT NULL | A boolean value to tell if a regular JE is an Activity JE or not. The Activity Journal Entry is a regular journal entry that ["BR"] is used to support balances that are not directly created from existing GL transactions such as checks, deposits, transfers or regular journal entries.
is_dirty | bit (1) | NOT NULL | Flag indicating the journal entry needs to be recalculated. Used for journal entries generated from Automatic JE Templates.
reference_number_sortable | nvarchar (160) | NOT NULL | A representation of the reference_number column that sorts in natural order. A trigger keeps this field synchronized with the content of reference_number.
origin__accounting_application_KEY | int (4) |  | The application that was running when the journal entry was created.
tax_reconciliation_schedule_line_KEY | int (4) |  | A foreign key to Tax_Reconciliation_Schedule_Line table. Data is required for Tax Adjustment Tax Code type journal entries and is null for all other types.
exported_to_quick_books | bit (1) | NOT NULL | This flag should be true if the transaction has been exported to quickbooks. It should be false otherwise.
workpaper_KEY | int (4) |  | Column that specifies the referenced workpaper key in the workpaper_reference column of the same table. ["BR"] Since there can be workpapers with the same reference value in different binders, we use the key value to eliminate the redundancy.

Primary key
Name | Columns | Description
PK_Journal_Entry | journal_entry_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Journal_Entry__Accounting_Application__origin__accounting_application_KEY | origin__accounting_application_KEY | Accounting_Application (accounting_application_KEY) |
FK_Journal_Entry__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Journal_Entry__Data_Origin__data_origin_KEY | data_origin_KEY | Data_Origin (data_origin_KEY) |
FK_Journal_Entry__Journal_Entry_Misstatement_Type__journal_entry_misstatement_type_KEY | journal_entry_misstatement_type_KEY | Journal_Entry_Misstatement_Type (journal_entry_misstatement_type_KEY) |
FK_Journal_Entry__Journal_Entry_Type__journal_entry_type_KEY | journal_entry_type_KEY | Journal_Entry_Type (journal_entry_type_KEY) |
FK_Journal_Entry__Schedule_M3_Tax_Code_Attribute__schedule_m3_tax_code_attribute_KEY | schedule_m3_tax_code_attribute_KEY | Schedule_M3_Tax_Code_Attribute (schedule_m3_tax_code_attribute_KEY) |
FK_Journal_Entry__Tax_Reconciliation_Schedule_Line__tax_reconciliation_schedule_line_KEY | tax_reconciliation_schedule_line_KEY | Tax_Reconciliation_Schedule_Line (tax_reconciliation_schedule_line_KEY) |
FK_Journal_Entry__Transaction_Status__transaction_status_KEY | transaction_status_KEY | Transaction_Status (transaction_status_KEY) |
FK_Journal_Entry__workpaper_KEY | workpaper_KEY | Workpaper (workpaper_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Transaction_Template_N_Journal_Entry__Journal_Entry__journal_entry_KEY | journal_entry_KEY | Transaction_Template_N_Journal_Entry |
FK_Journal_Entry_Template__Journal_Entry__journal_entry_KEY | journal_entry_KEY | Journal_Entry_Template |
FK_GL_Transaction_N_Journal_Entry__Journal_Entry__journal_entry_KEY | journal_entry_KEY | GL_Transaction_N_Journal_Entry |
FK_Journal_Entry_Event__Journal_Entry__journal_entry_KEY | journal_entry_KEY | Journal_Entry_Event |
FK_Journal_Entry_Reversal__Journal_Entry__reversal__journal_entry_KEY | reversal__journal_entry_KEY | Journal_Entry_Reversal |
FK_Journal_Entry_Reversal__Journal_Entry__reversed__journal_entry_KEY | reversed__journal_entry_KEY | Journal_Entry_Reversal |
FK_Journal_Entry_Distribution__Journal_Entry__journal_entry_KEY | journal_entry_KEY | Journal_Entry_Distribution |