Annotation: transactions.is_purchase

Information: transactions.is_purchase

Implementation: transactions.is_purchase

CREATE OR REPLACE FUNCTION transactions.is_purchase(_transaction_master_id bigint)
 RETURNS boolean
 LANGUAGE plpgsql
AS $function$
BEGIN
        IF EXISTS
        (
                SELECT * FROM transactions.transaction_master
                WHERE transactions.transaction_master.transaction_master_id = $1
                AND book IN ('Purchase.Direct', 'Purchase.Receipt')
        ) THEN
                RETURN true;
        END IF;

        RETURN false;
END
$function$