DECLARE
\n@ERP_DBNAME VARCHAR(30),
\n@ERP_FIRMNR CHAR(3),
\n@ERP_PERNR CHAR(2),
\n@CONNECT_DBNAME CHAR(30),
\n@CONNECT_CALAN CHAR(3)
\n— BU B\u00d6L\u00dcME ERP F\u0130RMA B\u0130LG\u0130LER\u0130 G\u0130R\u0130LMEL\u0130
\nSET @ERP_DBNAME =’LOGODB’ — ERP Database ismi yaz\u0131lmal\u0131
\nSET @ERP_FIRMNR = ‘014’ — ERP Firma numaras\u0131 yaz\u0131lmal\u0131
\nSET @ERP_PERNR = ’01’ — ERP D\u00f6nem numaras\u0131 yaz\u0131lmal\u0131
\n— BU B\u00d6L\u00dcME CONNECT \u00c7ALI\u015eMA ALANI B\u0130LG\u0130LER\u0130 G\u0130R\u0130LMEL\u0130
\nSET @CONNECT_DBNAME = ‘CONNECT’ — Connect database ismi yaz\u0131lmal\u0131
\nSET @CONNECT_CALAN = ‘001’ — Connect \u00c7al\u0131\u015fma alan\u0131 numaras\u0131 yaz\u0131lmal\u0131<\/p>\n
EXEC (‘INSERT INTO ‘+ @ERP_DBNAME +’..LG_’+@ERP_FIRMNR+’_’+@ERP_PERNR+’_FICHEOBJECT (FICHEREF,FICHETYPE,OBJECTTYPE,LDATA)
\nSELECT INV.LOGICALREF,0,0,APLINE.LDATA
\nFROM ‘+@CONNECT_DBNAME+’..LG_’+@CONNECT_CALAN+’_APPROVAL AP,’+@CONNECT_DBNAME+’..LG_’+@CONNECT_CALAN+’_APPROVALLINE APLINE,’+@ERP_DBNAME+’..LG_’+@ERP_FIRMNR+’_’+@ERP_PERNR+’_INVOICE INV
\nWHERE AP.TRCODE = INV.TRCODE AND APLINE.APPRREF= AP.LOGICALREF AND AP.FILENAME=INV.GUID AND AP.FILENAME IN
\n(SELECT GUID FROM ‘+@ERP_DBNAME+’..LG_’+@ERP_FIRMNR+’_’+@ERP_PERNR+’_INVOICE WHERE EINVOICE = 1 AND LOGICALREF NOT IN
\n(SELECT FICHEREF FROM ‘+@ERP_DBNAME+’..LG_’+@ERP_FIRMNR+’_’+@ERP_PERNR+’_FICHEOBJECT))’)<\/p>\n","protected":false},"excerpt":{"rendered":"
DECLARE @ERP_DBNAME VARCHAR(30), @ERP_FIRMNR CHAR(3), @ERP_PERNR CHAR(2), @CONNECT_DBNAME CHAR(30), @CONNECT_CALAN CHAR(3) — BU B\u00d6L\u00dcME ERP F\u0130RMA B\u0130LG\u0130LER\u0130 G\u0130R\u0130LMEL\u0130 SET @ERP_DBNAME =’LOGODB’ — ERP Database ismi yaz\u0131lmal\u0131 SET @ERP_FIRMNR = ‘014’ — ERP Firma numaras\u0131 yaz\u0131lmal\u0131 SET @ERP_PERNR = ’01’ — ERP D\u00f6nem numaras\u0131 yaz\u0131lmal\u0131 — BU B\u00d6L\u00dcME CONNECT \u00c7ALI\u015eMA ALANI B\u0130LG\u0130LER\u0130 G\u0130R\u0130LMEL\u0130 SET @CONNECT_DBNAME = […]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-1177","post","type-post","status-publish","format-standard","hentry","category-e-fatura"],"_links":{"self":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1177","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/comments?post=1177"}],"version-history":[{"count":1,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1177\/revisions"}],"predecessor-version":[{"id":1178,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/posts\/1177\/revisions\/1178"}],"wp:attachment":[{"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/media?parent=1177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/categories?post=1177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ozgurguler.net\/blog\/wp-json\/wp\/v2\/tags?post=1177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}