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) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_GL_Transaction_Note__GL_Transaction__gl_transaction_KEY | gl_transaction_KEY | GL_Transaction_Note |
FK_Quick_Books_Transaction_N_GL_Transaction__GL_Transaction__gl_transaction_KEY | gl_transaction_KEY | Quick_Books_Transaction_N_GL_Transaction |
FK_Enter_Transaction_Data_Entry_Session_Element__GL_Transaction__gl_transaction_KEY | gl_transaction_KEY | Enter_Transaction_Data_Entry_Session_Element |
FK_GL_Transaction_N_GL_Balancing_Entry__GL_Transaction__gl_transaction_KEY | gl_transaction_KEY | GL_Transaction_N_GL_Balancing_Entry |
FK_Transaction_Template_N_GL_Transaction__GL_Transaction__gl_transaction_KEY | gl_transaction_KEY | Transaction_Template_N_GL_Transaction |
FK_GL_Transaction_N_Journal_Entry__GL_Transaction__gl_transaction_KEY | gl_transaction_KEY | GL_Transaction_N_Journal_Entry |
FK_GL_Transaction_N_Bank_Transaction__GL_Transaction__gl_transaction_KEY | gl_transaction_KEY | GL_Transaction_N_Bank_Transaction |
FK_AR_Transaction__GL_Transaction__gl_transaction_KEY | gl_transaction_KEY | AR_Transaction |
FK_Apply_Customer_Payment_Transaction__GL_Transaction__gl_transaction_KEY | gl_transaction_KEY | Apply_Customer_Payment_Transaction |
FK_AR_Payment__GL_Transaction__gl_transaction_KEY | gl_transaction_KEY | AR_Payment |
FK_AR_Payment_Application__GL_Transaction__gl_transaction_KEY | gl_transaction_KEY | AR_Payment_Application |
FK_AR_Payment_Application__GL_Transaction__payment__gl_transaction_KEY | payment__gl_transaction_KEY | AR_Payment_Application |
FK_GL_Transaction_N_Payable_Transaction__GL_Transaction__gl_transaction_KEY | gl_transaction_KEY | GL_Transaction_N_Payable_Transaction |
FK_Pending_AP_Payment_Application__GL_Transaction__payment__gl_transaction_KEY | payment__gl_transaction_KEY | Pending_AP_Payment_Application |
FK_Payable_Payment_Application__GL_Transaction__gl_transaction_KEY | gl_transaction_KEY | Payable_Payment_Application |
FK_Payable_Payment_Application__GL_Transaction__payment__gl_transaction_KEY | payment__gl_transaction_KEY | Payable_Payment_Application |