USP_REPORT_PREPOSTREFERENCE

CREATE procedure [dbo].[USP_REPORT_PREPOSTREFERENCE](@ID nvarchar(36))
as
begin 
    set nocount on;

  select case dbo.UFN_INSTALLEDPRODUCTS_PRODUCTIS('133F9BCA-00F1-4007-9792-586B931340C6') when 1 then ' for ' + PS.NAME else '' end as NAME, REVENUEREFERENCE, CASHREFERENCE, CASHPOSTMETHODCODE, ARREFERENCE, REVALUATIONGAINLOSSREFERENCE, REVENUEPOSTMETHODCODE
    from POSTTOGLPROCESS as PP 
    inner join POSTTOGLPROCESSDETAIL as PD on PP.ID= PD.ID 
    left outer join PDACCOUNTSYSTEM as PS on PS.ID = PP.PDACCOUNTSYSTEMID 
    where PP.ID = @ID 

end