View: dbo.Payable_Payment_Application_Full_View
View definition
CREATE VIEW dbo.Payable_Payment_Application_Full_View
AS
(
SELECT
PPA.gl_transaction_KEY,
PPA.payable_transaction_KEY,
PPA.payment__gl_transaction_KEY,
PPA.application_date,
PPA.paid_amount,
PPA.discount_taken_amount,
ISNULL(LEFT(
(PPA.payment__reference_number
+ CASE WHEN PPA.payment__reference_number = N'' then N'' else N'-' end
+ ISNULL(MAPPO.reference_number_suffix, N'PMTAPP')) collate Latin1_General_CI_AS
, 16), N'') AS reference_number,
ISNULL(LEFT(dbo.sf_Generate_Sortable_Reference_Number(
PPA.payment__reference_number
+ CASE WHEN PPA.payment__reference_number = N'' then N'' else N'-' end
+ ISNULL(MAPPO.reference_number_suffix, N'PMTAPP')) collate Latin1_General_CI_AS
, 80), N'') AS reference_number_sortable,
ISNULL(LEFT(
(PPA.description
+ CASE WHEN PPA.description = N'' then N'' else N' - ' end
+ N'Payment Application') collate Latin1_General_CI_AS
, 120), N'') AS description,
PPA.origin__accounting_application_KEY,
PPA.data_origin_KEY,
J.client_KEY,
GLT.gl_period_KEY,
GLT.journal_KEY
FROM
dbo.Payable_Payment_Application_View PPA
-- Grab the client key.
INNER JOIN dbo.GL_Transaction GLT
ON PPA.gl_transaction_KEY = GLT.gl_transaction_KEY
INNER JOIN dbo.Journal J
ON GLT.journal_KEY = J.journal_KEY
-- Grab the client's payment application reference number suffix. If not set yet, use default ''.
LEFT JOIN dbo.Manage_AP_Payment_Option MAPPO
ON J.client_KEY = MAPPO.client_KEY
)