SAP B1-PTN Müşteri faturalarına bağlı yevmiye kaydı açıklamalarının otomatik güncellenmesi

IF :object_type = '13'
	AND (
		:transaction_type = 'A'
		OR :transaction_type = 'U'
		) then
	UPDATE t0
	SET "Memo" = CONCAT (
			CONCAT (
				"NumAtCard"
				,' NL.FT. '
				)
			,"CardName"
			)
	FROM ojdt t0
	JOIN OINV t1 ON t0."TransId" = t1."TransId"
	WHERE "DocEntry" = :list_of_cols_val_tab_del;

UPDATE t0
SET "LineMemo" = CONCAT (
		CONCAT (
			"NumAtCard"
			,' NL.FT. '
			)
		,"CardName"
		)
FROM jdt1 t0
JOIN OINV t1 ON t0."TransId" = t1."TransId"
WHERE t1."DocEntry" = :list_of_cols_val_tab_del;

UPDATE t0
SET "LineMemo" = CONCAT (
		CONCAT (
			"NumAtCard"
			,' NL.FT. TERS KAYIT '
			)
		,"CardName"
		)
FROM jdt1 t0
JOIN OINV t1 ON t0."TransId" = t1."TransId"
WHERE t1."DocEntry" = :list_of_cols_val_tab_del
	AND "CANCELED" = 'C';END

IF ;