View: dbo.GL_Transaction_Detail__Journal_Entry__View | |||
View definition | |||
-- SUMMARY -- This view produces ledger entries from journal entries. -- DROP VIEW dbo.GL_Transaction_Journal_Entry_Detail_View CREATE VIEW dbo.GL_Transaction_Detail__Journal_Entry__View AS SELECT _T002."auto_reversing", NULL AS "bank_transaction_distribution_KEY", NULL AS "bank_transaction_KEY", NULL AS "checkbook_KEY", _T002."client_KEY", _T003."workpaper_reference" AS "distribution_workpaper_reference", NULL AS "first__w2_1099_box_type_KEY", _T003."gl_account_KEY", CASE WHEN ((_T003."amount" < 0)) THEN 2 /* Credit */ ELSE 1 /* Debit */ END AS gl_balance_effect_KEY, NULL AS "gl_balancing_entry_KEY", _T001."gl_period_KEY", CASE WHEN ((_T003."amount" < 0)) THEN - _T003."amount" ELSE _T003."amount" END AS "gl_transaction_amount", _T002."transaction_date" AS "gl_transaction_date", _T002."description" AS "gl_transaction_description", _T003."description" AS "gl_transaction_detail_description", _T001."gl_transaction_KEY", _T002."reference_number" AS "gl_transaction_reference_number", _T002."reference_number_sortable" AS "gl_transaction_reference_number_sortable", CAST(7 AS TINYINT) AS gl_transaction_source_expression_KEY, -- GLTransactionSourceExpression.JournalEntry 1 as gl_transaction_source_KEY, -- GLTransactionSource.JournalEntry _T002.journal_entry_type_KEY as gl_transaction_type_KEY, _T002."is_activity_journal_entry", _T003."journal_entry_distribution_KEY", nje.journal_entry_KEY, _T002."journal_entry_misstatement_type_KEY", _T002."journal_entry_type_KEY", _T001."journal_KEY", _T002."schedule_m3_tax_code_attribute_KEY", NULL AS "second__w2_1099_box_type_KEY", 1 AS "source_was_a_distribution", _T002."transaction_status_KEY", NULL AS "vendor_KEY", _T002."workpaper_reference", _T003."sequence_number" FROM dbo.GL_Transaction AS _T001 inner join dbo.GL_Transaction_N_Journal_Entry as nje on _T001.gl_transaction_KEY = nje.gl_transaction_KEY INNER JOIN dbo.Journal_Entry AS _T002 ON nje.journal_entry_KEY = _T002."journal_entry_KEY" INNER JOIN dbo.Journal_Entry_Distribution AS _T003 ON nje.journal_entry_KEY = _T003."journal_entry_KEY" ; | |||