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 =’LOGODB’ — ERP Database ismi yazılmalı
SET @ERP_FIRMNR = ‘014’ — ERP Firma numarası yazılmalı
SET @ERP_PERNR = ’01’ — ERP Dönem numarası yazılmalı
— BU BÖLÜME CONNECT ÇALIŞMA ALANI BİLGİLERİ GİRİLMELİ
SET @CONNECT_DBNAME = ‘CONNECT’ — Connect database ismi yazılmalı
SET @CONNECT_CALAN = ‘001’ — 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=INV.GUID AND AP.FILENAME IN
(SELECT GUID 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))’)