CREATE OR REPLACE VIEW kupivip_for_nav_log_noncash_view AS

SELECT l.id
, l.transaction_id
, l.customers_id
, l.orders_id
, IFNULL(l.payment_system_id, 0) AS payment_system_id
, IFNULL(l.payment_system, 'to_orders')  AS payment_system
, l.date_added
, IF(l.payment_system IS NULL, -1, 1) * l.amount AS 'sum'
FROM log_noncash AS l
WHERE l.date_added >= '2020-10-01'
AND l.contractors_id = 265;