DECLARE @ERP_DBNAME VARCHAR(30), @ERP_FIRMNR CHAR(3), @ERP_PERNR CHAR(2), @CONNECT_DBNAME CHAR(30), @CONNECT_CALAN CHAR(3) -- BU BÖLÜME ERP FİRMA BİLGİLERİ GİRİLMELİ SET @ERP_DBNAME ='SERDART' -- ERP Database ismi yazılmalı SET @ERP_FIRMNR = '500' -- ERP Firma numarası yazılmalı SET @ERP_PERNR = '02' -- ERP Dönem numarası yazılmalı -- BU BÖLÜME CONNECT ÇALIŞMA ALANI BİLGİLERİ GİRİLMELİ SET @CONNECT_DBNAME = 'CON_SERDART' -- Connect database ismi yazılmalı SET @CONNECT_CALAN = '500' -- Connect Çalışma alanı numarası yazılmalı EXEC ('INSERT INTO '+ @ERP_DBNAME +'..LG_'+@ERP_FIRMNR+'_'+@ERP_PERNR+'_FICHEOBJECT (FICHEREF,FICHETYPE,OBJECTTYPE,LDATA) SELECT INV.LOGICALREF,0,0,APLINE.LDATA FROM '+@CONNECT_DBNAME+'..LG_'+@CONNECT_CALAN+'_APPROVAL AP,'+@CONNECT_DBNAME+'..LG_'+@CONNECT_CALAN+'_APPROVALLINE APLINE,'+@ERP_DBNAME+'..LG_'+@ERP_FIRMNR+'_'+@ERP_PERNR+'_INVOICE INV WHERE AP.TRCODE = INV.TRCODE AND APLINE.APPRREF= AP.LOGICALREF AND AP.FILENAME COLLATE DATABASE_DEFAULT=INV.GUID COLLATE DATABASE_DEFAULT AND AP.FILENAME COLLATE DATABASE_DEFAULT IN (SELECT GUID COLLATE DATABASE_DEFAULT FROM '+@ERP_DBNAME+'..LG_'+@ERP_FIRMNR+'_'+@ERP_PERNR+'_INVOICE WHERE EINVOICE = 1 AND LOGICALREF NOT IN (SELECT FICHEREF FROM '+@ERP_DBNAME+'..LG_'+@ERP_FIRMNR+'_'+@ERP_PERNR+'_FICHEOBJECT))')