Prenos Pantheon-Pos

if object_id('tempdb..#d') is not null

 drop table #d

select distinct d.acDocType

into #d

from [zuins.ddns.me,1433].ZUINS.dbo.tHE_Move g

inner join [zuins.ddns.me,1433].ZUINS.dbo.tPA_SetDocType d on g.acDocType = d.acDocType

where (g.acIssuer like '%544%' or g.acReceiver like '%544%') 

and d.acDocType not in ('1200','3204','1PS0','3205','3208') and d.acType not in ('P', 'E', 'C')

insert into rGlava (kljuc,godina,blagajna,rb,datum,mpv,korisnik,nacinplacanja,napomena,kupac,pdv,osnova,nato,pot,syn,b,adTimeChg,s,acFiskNo,fTip,Tip,Bod,adTimeIns,Isporuka,anClerk,acDelivery)

select left(g.acKey,2)+'-'+g.acDocType+'-'+replace(str(cast(right(g.acKey,6) as int), 6), ' ', ''),

left(g.acKey,2), g.acDocType, cast(right(g.acKey,6) as int), g.adDate, g.anForPay, 'a', 'Gotovina', g.acNote, g.acReceiver, g.anVAT,g.anValue, 'F', 'T', 'T', 0, g.adTimeIns, 0, '', '', '', 0, g.adTimeIns, g.acPrsn3, g.anClerk, ''

from [zuins.ddns.me,1433].ZUINS.dbo.tHE_Move g

inner join #d t on g.acDocType = t.acDocType and g.acKey like '23%'

insert into rGlavaBlg (kljuc,poz,nacinplacanja,iznos,adTimeChg)

select left(g.acKey,2)+'-'+g.acDocType+'-'+replace(str(cast(right(g.acKey,6) as int), 6), ' ', ''),

p.anNo, p.acPayMethod, p.anAmount, p.adTimeIns

from [zuins.ddns.me,1433].ZUINS.dbo.tHE_Move g

inner join [zuins.ddns.me,1433].ZUINS.dbo.tHE_MoveCash p on g.acKey = p.acKey

inner join [zuins.ddns.me,1433].ZUINS.dbo.tPA_SetDocType d on g.acDocType = d.acDocType

inner join #d t on g.acDocType = t.acDocType and g.acKey like '23%'

insert into rPozicije (kljuc,poz,ident,naziv,kolicina,mpc,rabat,mpv,rMpc,adTimeChg,s,realMPC,acTarSt)

select left(g.acKey,2)+'-'+g.acDocType+'-'+replace(str(cast(right(g.acKey,6) as int), 6), ' ', ''),

p.anNo, p.acIdent, p.acName, p.anQty, case when g.acDocType like '3%' then p.anRTPrice else p.anSalePrice end, p.anRebate, 

(case when g.acDocType like '3%' then p.anRTPrice else p.anSalePrice end) / (p.anRebate/100+1) * p.anQty,

(case when g.acDocType like '3%' then p.anRTPrice else p.anSalePrice end) / (p.anRebate/100+1), 

p.adTimeIns, 0, p.anSalePrice, p.acVATCode

from [zuins.ddns.me,1433].ZUINS.dbo.tHE_Move g

inner join [zuins.ddns.me,1433].ZUINS.dbo.tHE_MoveItem p on g.acKey = p.acKey

inner join [zuins.ddns.me,1433].ZUINS.dbo.tPA_SetDocType d on g.acDocType = d.acDocType

inner join #d t on g.acDocType = t.acDocType and g.acKey like '23%'