Table: dbo.GL_Transaction | |||
This table contains all additional GL transaction specific details that the originating source transaction (bank transaction, payable transaction, journal entry transaction, etc) does not contain. | |||
Columns | |||
Name | Type | Constraints | Description |
gl_transaction_KEY | int (4) | NOT NULL | Primary key. |
journal_KEY | int (4) | NOT NULL | Foreign key to Journal table. |
gl_period_KEY | int (4) | NOT NULL | Foreigh key to GL_Period table. |
override_source_type_to_display_as_journal_entry | bit (1) | NOT NULL | Normally, the source of a GL transaction determines how said transaction is displayed in Enter Transactions. For example, a check is entered and displayed as a check, a deposit as a deposit, a journal entry as a journal entry. For the case of payment type and addition type bank transactions, however, the user can choose to enter and display them, not as a bank transaction, but as a raw journal entry. For example, a payment entered as a journal entry would need to display as a journal entry, not a payment, when revisited in ET. In exactly this situation, this boolean column will be set to 1 indicating the transaction should be displayed in ET as a journal entry, not as it's native type. |
is_posting_period_overridden | bit (1) | NOT NULL | Most data entry points for transactions supply a default GL period, usually either the current period or a period based on the transaction?s date. False indicates this default value was used; true means the user overrode the default and selected another period. If this is true, the use_transaction_date_to_default_posting_period flag is ignored when deciding if the posting period needs to be updated to match the transaction date. |
Primary key | |||
Name | Columns | Description | |
PK_GL_Transaction | gl_transaction_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_GL_Transaction__GL_Period__gl_period_KEY | gl_period_KEY | GL_Period (gl_period_KEY) | |
FK_GL_Transaction__Journal__journal_KEY | journal_KEY | Journal (journal_KEY) |