CREATE PROC [dbo].[SP_FATURA_IPTAL]
(@FATNO VARCHAR(32))
AS
BEGIN
DECLARE @LOGREF INT
SET @LOGREF=ISNULL((SELECT LOGICALREF FROM LG_011_08_INVOICE WHERE FICHENO=@FATNO),-1)
--SELECT CANCELLED,* FROM LG_011_08_STLINE WHERE ORDFICHEREF=1016
UPDATE LG_011_08_INVOICE SET CANCELLED=1 WHERE LOGICALREF=@LOGREF
UPDATE LG_011_08_CLFLINE SET CANCELLED=1 WHERE SOURCEFREF=@LOGREF
UPDATE LG_011_08_STLINE SET CANCELLED=1 WHERE INVOICEREF=@LOGREF
UPDATE LG_011_08_STFICHE SET CANCELLED=1 WHERE INVOICEREF=@LOGREF
DELETE FROM LG_011_08_ORFICHE WHERE LOGICALREF=(SELECT DISTINCT ORDFICHEREF FROM LG_011_08_STLINE WHERE INVOICEREF=@LOGREF)
END