SELECT
	*,
	(UNKANDDOCADJ + OSV) AS Adjustment,
	(
		Amount - OSV - UNKANDDOCADJ - Payment
	) AS Outstanding
FROM
	(
		SELECT
			t4060r001 AS RecordID,
			t4060r002 AS RecordTimestamp,
			t4060r003 AS RecordStatus,
			'SLIV-L' AS DocumentType,
			t4060f002 AS DocumentNo,
			t4060f003 AS DocumentDate,
			t4060f005 AS AgreementNo,
			t4060f006 AS HirerID,
			t4060f007 AS HirerName,
			sum(t4061f009) AS Amount,
			IFNULL(
				(
					SELECT
						sum(vAmount)
					FROM
						vpaymenttrans
					WHERE
						vInv = t4060f002
					AND vHA = t4060f005
					AND vDate <= '2019-06-30 23:59:59'
					AND vTipe IN (
						'DOCUMENT ADJUSTMENT',
						'SALES CREDIT NOTE'
					)
				),
				0
			) AS UNKANDDOCADJ,
			IFNULL(
				(
					SELECT
						sum(t4075f005)
					FROM
						t4075
					LEFT JOIN t4074 ON t4074.t4074r001 = t4075.t4075f001
					WHERE
						t4074r003 = 1
					and t4075f003 = t4060f002
					AND t4074f006 = t4060f006
					and t4074f003 <= '2019-06-30 23:59:59'
				),
				0
			) AS OSV,
			IFNULL(
				(
					SELECT
						sum(t4081f006)
					FROM
						t4081
					LEFT JOIN t4080 ON t4080.t4080r001 = t4081.t4081f001
					WHERE
						t4080r003 = 1
					and t4081f003 = t4060f002
					AND t4080f006 = t4060f006
					and t4080f003 <= '2019-06-30 23:59:59'
				),
				0
			) AS Payment
		from
			t4060
		LEFT JOIN t4061 on t4061f001 = t4060r001
		WHERE
			t4060r003 = 1
		AND t4060f003 BETWEEN '0001-01-01 00:00:00'
		AND '2019-06-30 23:59:59'
		AND t4060f012 != 0
		AND t4060f001 = 'SLIV-L'
		Group By
			t4060r001
	) as X
Having
	Outstanding > 0