INSERT INTO tfaVk (VkIDP,VkID,VkOpis,VkStatus,Program,VdIDP,VdID,KlavzulaIDP,KlavzulaID,Klavzula2ID,SestavilIDP,SestavilID,PodpisnikIDP,PodpisnikID,ValutaIDP,ValutaID,TecajnicaIDP,TecajnicaID,PopustProcent,DavekIDP,DavekID,SmIDP,SmID,NosilIDP,NosilID,KontoIDP,JeDrzavaNaRpt,JePartnerDSvNaslovu,StKopij,StKopijBeta,RacunKraj,KlavzulaIDPlacano,KajvOpisKnjizbe,VdIDKnj,DatVaIzDat,KajvNamen,ObstojaPk,PoSeNanasa,IzracunIzTxt,IzpFzpNaKonRac,TecajIzDat,VbOsnova,VbPredplaciloPrejeto,VbvZnesku,VbOdTegaDDV,VbRacunZaPredplacilo,VbZnesekDDV,VbDdvOpis,VbOsnovaSIT,VbZnesekDDVSIT,VbRekapitulacijaSkupaj,ZaStorno,VkAktiven,VezaEnabled,ZaDobropis,FormulaDDV,Izravnava,CenaNetoDec,VkIDosnovni,PodjetjeGlavaIDP,VbStran,PredlagajKonto,DovoliDatVnaprej,OzoIzracun,OzoNacinSt,OzoNacinKonto,OzoNacinSm,OzoIzpisNaRacunu,OzoSamodejno,StDniDec,ReportIme,KolicinaDec,TabelaDDVPozicija,VbVrednostPredPopravkom,VbVrednostPopravka,VbZmanjsanaVrednost,DetailAlterVrsticaBarva,NsCeManjPostavkKot,KodaNamenaID,SklicText,SklicTip,UpnBankaNasaID,UpnIzjava,PopustSumJePrikazan,StevilciPozicijePostavk,PreracunIzBruto,EmailRacunovSend,EmailRacunovEnIzvodManj,ZakleniNatisnjenega) SELECT N'01' AS VkIDP, N'IFAUPN' AS VkID, N'Izdan račun - UPN' AS VkOpis, N'IFA' AS VkStatus, N'Fa' AS Program, N'01' AS VdIDP, N'IFA' AS VdID, N'01' AS KlavzulaIDP, N'00' AS KlavzulaID, N'00' AS Klavzula2ID, N'01' AS SestavilIDP, N'01' AS SestavilID, N'01' AS PodpisnikIDP, N'01' AS PodpisnikID, N'01' AS ValutaIDP, N'978' AS ValutaID, N'01' AS TecajnicaIDP, N'S' AS TecajnicaID, 0 AS PopustProcent, N'01' AS DavekIDP, N'00' AS DavekID, N'01' AS SmIDP, N'000' AS SmID, N'01' AS NosilIDP, N'000' AS NosilID, N'01' AS KontoIDP, 0 AS JeDrzavaNaRpt, 0 AS JePartnerDSvNaslovu, 1 AS StKopij, 0 AS StKopijBeta, N'Ljubljana:' AS RacunKraj, N'00' AS KlavzulaIDPlacano, N'4' AS KajvOpisKnjizbe, N'IFA' AS VdIDKnj, 1 AS DatVaIzDat, N'2' AS KajvNamen, N'GA' AS ObstojaPk, 0 AS PoSeNanasa, N'0' AS IzracunIzTxt, N'1' AS IzpFzpNaKonRac, 0 AS TecajIzDat, N'Osnova [ValutaID]' AS VbOsnova, N'Predplačilo je bilo prejeto:' AS VbPredplaciloPrejeto, N'v znesku' AS VbvZnesku, N'od tega DDV' AS VbOdTegaDDV, N'Račun za predplačilo:' AS VbRacunZaPredplacilo, N'Znesek DDV [ValutaID]' AS VbZnesekDDV, N'Rekapitulacija DDV' AS VbDdvOpis, N'Osnova EUR' AS VbOsnovaSIT, N'Znesek DDV EUR' AS VbZnesekDDVSIT, N'Skupaj' AS VbRekapitulacijaSkupaj, 0 AS ZaStorno, 1 AS VkAktiven, -1 AS VezaEnabled, 0 AS ZaDobropis, 0 AS FormulaDDV, 0 AS Izravnava, 4 AS CenaNetoDec, N'IFA1' AS VkIDosnovni, N'01' AS PodjetjeGlavaIDP, N'Stran:' AS VbStran, N'PSV' AS PredlagajKonto, 0 AS DovoliDatVnaprej, 1 AS OzoIzracun, 2 AS OzoNacinSt, 2 AS OzoNacinKonto, 2 AS OzoNacinSm, 1 AS OzoIzpisNaRacunu, 1 AS OzoSamodejno, 2 AS StDniDec, N'rfaFakturaCelaUPN' AS ReportIme, 2 AS KolicinaDec, 0 AS TabelaDDVPozicija, N'Vrednost pred popravkom (Št. dok.: [StDok])' AS VbVrednostPredPopravkom, N'Vrednost popravka (Št. dok.: [StDok])' AS VbVrednostPopravka, N'Zmanjšana vrednost' AS VbZmanjsanaVrednost, 16777215 AS DetailAlterVrsticaBarva, -1 AS NsCeManjPostavkKot, N'SUPP' AS KodaNamenaID, N'Pri plačilu uporabite sklic na številko' AS SklicText, N'SI00 PartnerID-StDok' AS SklicTip, N'01' AS UpnBankaNasaID, 0 AS UpnIzjava, 0 AS PopustSumJePrikazan, 0 AS StevilciPozicijePostavk, 0 AS PreracunIzBruto, 0 AS EmailRacunovSend, 0 AS EmailRacunovEnIzvodManj, 0 AS ZakleniNatisnjenega