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
;