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
;