40 lines
1.0 KiB
Transact-SQL
40 lines
1.0 KiB
Transact-SQL
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
-- FNCUST_TF_GET_PAYMENT_LOCK
|
|
-- =================================================================
|
|
-- Die Funktion liefert die Auswahl für die Zahlungssperren
|
|
--
|
|
-- =================================================================
|
|
-- Copyright (c) 2025 by Digital Data GmbH
|
|
--
|
|
-- Digital Data GmbH • Ludwig-Rinn-Strasse 16 • D-35452 Heuchelheim
|
|
-- Tel.: 0641/202360 • E-Mail: info-flow@digitaldata.works
|
|
-- =================================================================
|
|
-- Creation Date / Author: 05.08.2025 / MP/MK
|
|
-- =================================================================
|
|
-- History:
|
|
-- 05.08.2025 / MP/MK - Prozedur erstellt
|
|
|
|
CREATE OR ALTER FUNCTION [dbo].[FNCUST_TF_GET_PAYMENT_LOCK] (
|
|
@pLANGUAGE VARCHAR(5)
|
|
)
|
|
RETURNS
|
|
@Table TABLE ([FLAG] NVARCHAR(1),
|
|
[DESCRIPTION] NVARCHAR(25))
|
|
AS
|
|
BEGIN
|
|
|
|
INSERT INTO @Table(FLAG,DESCRIPTION)
|
|
|
|
SELECT '-' as [FLAG],'zur Zahlung frei' as [DESCRIPTION]
|
|
UNION ALL
|
|
SELECT 'A' as [FLAG],'zur Zahlung gesperrt' as [DESCRIPTION];
|
|
|
|
RETURN;
|
|
|
|
END
|
|
GO |