Table: dbo.Journal_Entry
Table for journal entries
Columns
NameTypeConstraintsDescription
journal_entry_KEYint (4)NOT NULLPrimary key
transaction_datesmalldatetime (4)Date of the journal entry
journal_entry_type_KEYint (4)NOT NULLThe type of journal entry
reference_numbernvarchar (32)NOT NULLReference number
memonvarchar (480)NOT NULLA memo associated with the journal entry
descriptionnvarchar (240)NOT NULLThe journal entry description
client_KEYint (4)NOT NULL
transaction_status_KEYint (4)NOT NULL
data_origin_KEYint (4)NOT NULLThe origin of each journal entry. For example, Data Entry or CSA Conversion.
schedule_m3_tax_code_attribute_KEYint (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_reversingbit (1)NOT NULLFlag indicating the journal entry should be automatically reversed.
workpaper_referencenvarchar (50)NOT NULLRelated workpaper for this journal entry
journal_entry_misstatement_type_KEYint (4)The optional Misstatement type to apply to a Potential type Journal Entry
is_activity_journal_entrybit (1)NOT NULLA 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_dirtybit (1)NOT NULLFlag indicating the journal entry needs to be recalculated. Used for journal entries generated from Automatic JE Templates.
reference_number_sortablenvarchar (160)NOT NULLA 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_KEYint (4)The application that was running when the journal entry was created.
tax_reconciliation_schedule_line_KEYint (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_booksbit (1)NOT NULLThis flag should be true if the transaction has been exported to quickbooks. It should be false otherwise.
workpaper_KEYint (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
NameColumnsDescription
PK_Journal_Entryjournal_entry_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Journal_Entry__Accounting_Application__origin__accounting_application_KEYorigin__accounting_application_KEYAccounting_Application (accounting_application_KEY)
FK_Journal_Entry__Client__client_KEYclient_KEYClient (client_KEY)
FK_Journal_Entry__Data_Origin__data_origin_KEYdata_origin_KEYData_Origin (data_origin_KEY)
FK_Journal_Entry__Journal_Entry_Misstatement_Type__journal_entry_misstatement_type_KEYjournal_entry_misstatement_type_KEYJournal_Entry_Misstatement_Type (journal_entry_misstatement_type_KEY)
FK_Journal_Entry__Journal_Entry_Type__journal_entry_type_KEYjournal_entry_type_KEYJournal_Entry_Type (journal_entry_type_KEY)
FK_Journal_Entry__Schedule_M3_Tax_Code_Attribute__schedule_m3_tax_code_attribute_KEYschedule_m3_tax_code_attribute_KEYSchedule_M3_Tax_Code_Attribute (schedule_m3_tax_code_attribute_KEY)
FK_Journal_Entry__Tax_Reconciliation_Schedule_Line__tax_reconciliation_schedule_line_KEYtax_reconciliation_schedule_line_KEYTax_Reconciliation_Schedule_Line (tax_reconciliation_schedule_line_KEY)
FK_Journal_Entry__Transaction_Status__transaction_status_KEYtransaction_status_KEYTransaction_Status (transaction_status_KEY)
FK_Journal_Entry__workpaper_KEYworkpaper_KEYWorkpaper (workpaper_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Transaction_Template_N_Journal_Entry__Journal_Entry__journal_entry_KEYjournal_entry_KEYTransaction_Template_N_Journal_Entry
FK_Journal_Entry_Template__Journal_Entry__journal_entry_KEYjournal_entry_KEYJournal_Entry_Template
FK_Journal_Entry_Event__Journal_Entry__journal_entry_KEYjournal_entry_KEYJournal_Entry_Event
FK_GL_Transaction_N_Journal_Entry__Journal_Entry__journal_entry_KEYjournal_entry_KEYGL_Transaction_N_Journal_Entry
FK_Journal_Entry_Reversal__Journal_Entry__reversal__journal_entry_KEYreversal__journal_entry_KEYJournal_Entry_Reversal
FK_Journal_Entry_Reversal__Journal_Entry__reversed__journal_entry_KEYreversed__journal_entry_KEYJournal_Entry_Reversal
FK_Journal_Entry_Distribution__Journal_Entry__journal_entry_KEYjournal_entry_KEYJournal_Entry_Distribution

Schema diagram