USE [LONGEVITY]
GO

/****** Object:  View [dbo].[v_INFOLAN_DOCS]    Script Date: 22/01/2026 13:36:09 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO








  CREATE view [dbo].[v_INFOLAN_DOCS] AS

SELECT do11_numdoc,DO11_NUMDOCORIG, DO11_NOTEDOCUM, CG16_RAGSOANAG, CG16_NOME,CG16_COGNOME, DO11_CLIFOR_CG44,DO11_DOCUM_MG36,DO11_CODDEP, MG58_DESCRDEP,

CASE WHEN MG58_DESCRDEP='ISTANBUL' THEN  DO13_TOTDOCUMENTO   * 0.020
ELSE DO13_TOTDOCUMENTO   END DO13_TOTDOCUMENTO 



--select * 
,YEAR(CAST(DO11_DATADOC AS DATE))*100+   MONTH(CAST(DO11_DATADOC AS DATE)) YMONTH, DO11_DATADOC, DO13_TOTIMPONIBILE , DO11_NUMREG_CO99,
(SELECT COUNT(*) FROM CATA_SYNC..INFOLAN_WEBAPI_Incassi WHERE DO11_NUMDOCORIG=ID) Infolan
FROM DO11_DOCTESTATA 


inner join DO13_DOCTOTALI ON DO13_DITTA_CG18=DO11_DITTA_CG18 AND DO11_NUMREG_CO99 =DO13_NUMREG_CO99
inner join CG44_CLIFOR on DO11_DITTA_CG18=CG44_DITTA_CG18 and DO11_CLIFOR_CG44=CG44_CLIFOR and DO11_TIPOCF_CG44=CG44_TIPOCF
inner join CG16_ANAGGEN on CG44_CODICE_CG16=CG16_CODICE
inner join MG58_DEPOSITI on MG58_CODDEP= DO11_CODDEP and MG58_DITTA_CG18=DO11_DITTA_CG18

--WHERE --DO11_NUMDOC = 427666 AND 
--DO11_DOCUM_MG36 like 'TSC-VEN%'
-- DO11_DOCUM_MG36 like 'TSC-SCT%'
--DO11_DOCUM_MG36 like 'TSC-ESE%'
--DO11_DOCUM_MG36 like 'TSC-INC%'
-- YEAR(CAST(DO11_DATADOC AS DATE)) *100+   MONTH(CAST(DO11_DATADOC AS DATE)) >=202401

GO