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
NameTypeConstraintsDescription
gl_transaction_KEYint (4)NOT NULLPrimary key.
journal_KEYint (4)NOT NULLForeign key to Journal table.
gl_period_KEYint (4)NOT NULLForeigh key to GL_Period table.
override_source_type_to_display_as_journal_entrybit (1)NOT NULLNormally, 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_overriddenbit (1)NOT NULLMost 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
NameColumnsDescription
PK_GL_Transactiongl_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_GL_Transaction__GL_Period__gl_period_KEYgl_period_KEYGL_Period (gl_period_KEY)
FK_GL_Transaction__Journal__journal_KEYjournal_KEYJournal (journal_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_GL_Transaction_Note__GL_Transaction__gl_transaction_KEYgl_transaction_KEYGL_Transaction_Note
FK_Quick_Books_Transaction_N_GL_Transaction__GL_Transaction__gl_transaction_KEYgl_transaction_KEYQuick_Books_Transaction_N_GL_Transaction
FK_Enter_Transaction_Data_Entry_Session_Element__GL_Transaction__gl_transaction_KEYgl_transaction_KEYEnter_Transaction_Data_Entry_Session_Element
FK_GL_Transaction_N_GL_Balancing_Entry__GL_Transaction__gl_transaction_KEYgl_transaction_KEYGL_Transaction_N_GL_Balancing_Entry
FK_Transaction_Template_N_GL_Transaction__GL_Transaction__gl_transaction_KEYgl_transaction_KEYTransaction_Template_N_GL_Transaction
FK_GL_Transaction_N_Journal_Entry__GL_Transaction__gl_transaction_KEYgl_transaction_KEYGL_Transaction_N_Journal_Entry
FK_GL_Transaction_N_Bank_Transaction__GL_Transaction__gl_transaction_KEYgl_transaction_KEYGL_Transaction_N_Bank_Transaction
FK_AR_Transaction__GL_Transaction__gl_transaction_KEYgl_transaction_KEYAR_Transaction
FK_Apply_Customer_Payment_Transaction__GL_Transaction__gl_transaction_KEYgl_transaction_KEYApply_Customer_Payment_Transaction
FK_AR_Payment__GL_Transaction__gl_transaction_KEYgl_transaction_KEYAR_Payment
FK_AR_Payment_Application__GL_Transaction__gl_transaction_KEYgl_transaction_KEYAR_Payment_Application
FK_AR_Payment_Application__GL_Transaction__payment__gl_transaction_KEYpayment__gl_transaction_KEYAR_Payment_Application
FK_GL_Transaction_N_Payable_Transaction__GL_Transaction__gl_transaction_KEYgl_transaction_KEYGL_Transaction_N_Payable_Transaction
FK_Pending_AP_Payment_Application__GL_Transaction__payment__gl_transaction_KEYpayment__gl_transaction_KEYPending_AP_Payment_Application
FK_Payable_Payment_Application__GL_Transaction__gl_transaction_KEYgl_transaction_KEYPayable_Payment_Application
FK_Payable_Payment_Application__GL_Transaction__payment__gl_transaction_KEYpayment__gl_transaction_KEYPayable_Payment_Application

Schema diagram