View: dbo.Etl_Helper_Ledger_Entry_Ap_Payment_Application_Discount_Taken_Cr_View | |||
View definition | |||
CREATE VIEW dbo.Etl_Helper_Ledger_Entry_Ap_Payment_Application_Discount_Taken_Cr_View AS SELECT -- Unique key ppa.gl_transaction_KEY, ledger_entry_type_KEY = 15, /*AP Payment Application Discount Taken Cr*/ -- Ledger entry payload ppa.client_KEY, ppa.journal_KEY, ppa.gl_period_KEY, gl_account_KEY = pt.ap_discount__gl_account_KEY, gl_accounting_method_KEY = CASE WHEN cm_gltnpt.gl_transaction_KEY IS NULL -- A cash payment; not a credit memo. THEN NULL /*Accrual and Cash Basis*/ ELSE 1 /*Accrual*/ END, gl_balance_effect_KEY = 2, /*Credit*/ gl_transaction_type_KEY = 401, /*PayablePaymentApplication*/ transaction_status_KEY = 1, /*Live*/ gl_transaction_date = ppa.application_date, gl_transaction_amount = ppa.discount_taken_amount, gl_transaction_description = ppa.description, gl_transaction_detail_description = ppa.description, gl_transaction_reference_number = ppa.reference_number, gl_transaction_reference_number_sortable = ppa.reference_number_sortable, -- Standard supplemental information gl_transaction_source_expression_KEY = CAST(4 AS TINYINT), -- GLTransactionSourceExpression.PayablePaymentApplication gl_transaction_source_KEY = 5, /*PayablePaymentApplication*/ is_activity_journal_entry = CAST(0 AS BIT), journal_entry_type_KEY = 101, /*Journal entry*/ source_was_a_distribution = CAST(0 AS BIT), sequence_number = 0, workpaper_reference = N'' COLLATE Latin1_General_CI_AS, distribution_workpaper_reference = N'' COLLATE Latin1_General_CI_AS, -- Custom supplemental information pt.vendor_KEY, ppa.payable_transaction_KEY, ppa.payment__gl_transaction_KEY FROM dbo.Payable_Payment_Application_Full_View AS ppa INNER JOIN dbo.Payable_Transaction AS pt ON ppa.payable_transaction_KEY = pt.payable_transaction_KEY LEFT JOIN dbo.GL_Transaction_N_Payable_Transaction AS cm_gltnpt ON ppa.payment__gl_transaction_KEY = cm_gltnpt.gl_transaction_KEY WHERE pt.ap_discount__gl_account_KEY IS NOT NULL ; | |||