Table for journal entries |
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. |