Düzenle: EKSIK_SIPARISLER

İlgili Uygulama

Nesne Türü

Nesne Adı

Bu nesne dönem devrinden etkileniyor mu? (Örn: İçinde _01_ gibi sabit dönem kodu var mı?)

Genel Kullanım Amacı ve Notlar

Tam SQL Kodu

CREATE PROC [dbo].[EKSIK_SIPARISLER]
(@OLD_AMOUNT INT, @NEW_AMOUNT INT, @LOGREF INT, @FICHEREF INT)
AS
BEGIN
--DECLARE @ORAN FLOAT 
DECLARE @NETT FLOAT
DECLARE @GROS FLOAT
DECLARE @VATT FLOAT
DECLARE @TOTD FLOAT
DECLARE @TTED FLOAT
DECLARE @DPER FLOAT
--DECLARE @DDSC FLOAT
DECLARE @LNNO INT
DECLARE @SON INT

SET @SON = @OLD_AMOUNT - @NEW_AMOUNT
--EXEC dbo.sp_Funct @NEW_AMOUNT, @OLD_AMOUNT, @ORAN output
IF @NEW_AMOUNT = 0
BEGIN
--SET @DDSC = ISNULL((SELECT DISTDISC FROM LG_011_07_ORFLINE WHERE LINETYPE=0 AND LOGICALREF=@LOGREF AND ORDFICHEREF=@FICHEREF),0)
SET @LNNO = ISNULL((SELECT PARENTLNREF FROM LG_011_07_ORFLINE WHERE LINETYPE=0 AND LOGICALREF=@LOGREF AND ORDFICHEREF=@FICHEREF),0)
DELETE FROM LG_011_07_ORFLINE WHERE LINETYPE=0 AND LOGICALREF=@LOGREF AND ORDFICHEREF=@FICHEREF
IF @LNNO<>0 
BEGIN
DELETE FROM LG_011_07_ORFLINE WHERE LINETYPE=2 AND LOGICALREF=@LNNO AND ORDFICHEREF=@FICHEREF
END
--UPDATE LG_011_07_ORFLINE SET TOTAL= TOTAL-@DDSC WHERE LINETYPE=2 AND PARENTLNREF=0 AND ORDFICHEREF=@FICHEREF
END
ELSE
BEGIN
UPDATE LG_011_07_ORFLINE SET AMOUNT=AMOUNT-(@SON), TOTAL=((TOTAL*@NEW_AMOUNT)/@OLD_AMOUNT), DISTCOST=((DISTCOST*@NEW_AMOUNT)/@OLD_AMOUNT), DISTDISC=((DISTDISC*@NEW_AMOUNT)/@OLD_AMOUNT), VATAMNT=((VATAMNT*@NEW_AMOUNT)/@OLD_AMOUNT), VATMATRAH=((VATMATRAH*@NEW_AMOUNT)/@OLD_AMOUNT), LINENET=((LINENET*@NEW_AMOUNT)/@OLD_AMOUNT) WHERE LINETYPE=0 AND LOGICALREF=@LOGREF AND ORDFICHEREF=@FICHEREF
UPDATE LG_011_07_ORFLINE SET TOTAL=((TOTAL*@NEW_AMOUNT)/@OLD_AMOUNT) WHERE LINETYPE=2 AND PARENTLNREF=@LOGREF AND ORDFICHEREF=@FICHEREF
END
-- NETTOTAL
SET @NETT = ISNULL((SELECT ((SUM(TOTAL)-SUM(DISTCOST))+SUM(VATAMNT)) FROM LG_011_07_ORFLINE WHERE LINETYPE=0 AND ORDFICHEREF=@FICHEREF),0)
-- NETTOTAL

-- GROSSTOTAL
SET @GROS = ISNULL((SELECT SUM(TOTAL) FROM LG_011_07_ORFLINE WHERE LINETYPE=0 AND ORDFICHEREF=@FICHEREF),0)
-- GROSSTOTAL

-- TOTALVAT
SET @VATT = ISNULL((SELECT SUM(VATAMNT) FROM LG_011_07_ORFLINE WHERE LINETYPE=0 AND ORDFICHEREF=@FICHEREF),0)
-- TOTALVAT

-- TOTALDISCOUNTS
SET @TOTD = ISNULL((SELECT SUM(DISTCOST) FROM LG_011_07_ORFLINE WHERE LINETYPE=0 AND ORDFICHEREF=@FICHEREF),0)
-- TOTALDISCOUNTS

-- TOTALDISCOUNTED
SET @TTED = ISNULL((SELECT (SELECT SUM(TOTAL) FROM LG_011_07_ORFLINE WHERE LINETYPE=0 AND ORDFICHEREF=@FICHEREF) - (SELECT SUM(TOTAL) FROM LG_011_07_ORFLINE WHERE LINETYPE=2 AND PARENTLNREF<>0 AND ORDFICHEREF=@FICHEREF)),0)
-- TOTALDISCOUNTED
SET @DPER = ISNULL((SELECT DISCPER FROM LG_011_07_ORFLINE WHERE LINETYPE=2 AND PARENTLNREF=0 AND ORDFICHEREF=@FICHEREF),0)
UPDATE LG_011_07_ORFICHE SET TOTALDISCOUNTS=@TOTD, TOTALDISCOUNTED=@TTED,TOTALVAT=@VATT,GROSSTOTAL=@GROS, NETTOTAL=@NETT WHERE LOGICALREF=@FICHEREF
UPDATE LG_011_07_ORFLINE SET TOTAL=@TTED*(@DPER/100) WHERE LINETYPE=2 AND PARENTLNREF=0 AND ORDFICHEREF=@FICHEREF
END

Oluşturulma: 23.12.2025 07:15 Son Güncelleme: 23.12.2025 17:28

İptal Nesneyi Sil