View: dbo.Ledger_Entry_View | |||
View definition | |||
CREATE VIEW dbo.Ledger_Entry_View AS SELECT --!!WARNING: Do not delete this view as it may be directly referenced in stored report filters (WI 869454). --This view returns all columns of the underlying table. --Post-2016.1.0 we will look into a better solution for this directly referenced view issue. -- Unique keys... -- ...surrogate ledger_entry_KEY, -- ...natural gl_transaction_KEY, ledger_entry_type_KEY, bank_transaction_distribution_KEY, payroll_check_payroll_item_distribution_KEY, payroll_check_tax_item_distribution_KEY, payroll_bank_transaction_worker_compensation_item_distribution_KEY, journal_entry_distribution_KEY, payable_transaction_distribution_KEY, payable_payment_application_payment_distribution_KEY, payable_payment_application_payable_distribution_KEY, ar_transaction_item_gl_account_KEY, ar_payment_application_distribution_KEY, -- Ledger entry payload client_KEY, journal_KEY, gl_period_KEY, gl_account_KEY, gl_accounting_method_KEY, gl_balance_effect_KEY, gl_transaction_type_KEY, transaction_status_KEY, gl_transaction_date, gl_transaction_amount, gl_transaction_description, gl_transaction_detail_description, gl_transaction_reference_number, gl_transaction_reference_number_sortable, -- Standard supplemental information gl_transaction_source_expression_KEY, gl_transaction_source_KEY, is_activity_journal_entry, journal_entry_type_KEY, source_was_a_distribution, sequence_number, workpaper_reference, distribution_workpaper_reference, -- Custom supplemental information checkbook_KEY, vendor_KEY, bank_transaction_KEY, first__w2_1099_box_type_KEY, second__w2_1099_box_type_KEY, journal_entry_KEY, auto_reversing, journal_entry_misstatement_type_KEY, schedule_m3_tax_code_attribute_KEY, gl_balancing_entry_KEY, payable_transaction_KEY, payment__gl_transaction_KEY, customer_KEY, ar_transaction_item_KEY, ledger_row_version FROM dbo.Ledger_Entry ; | |||