Uvoz šifarnika artikala [Razvojna dokumentacija MST]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

~~COMPLEX_TABLES~~


====== Uvoz šifarnika artikala ======


===== Mandatorna polja tabele Elementi =====


Polja bez kojih zapisi u tabeli Elementi ne mogu biti ispravno istumačeni: \\ 
ElID,Artikal,Naziv,PCena,TCena,CCena,Tip,KatID,TarBr,ValID,CValID,Jed,Model,Boja,Jed1,Jed2,Descript,JedPak,ElTip,ElPodTip,PodKatID,NDS,TaksJed,ManID,FskSif


~~COMPLEX_TABLES~~


~~COMPLEX_TABLES~~


~~COMPLEX_TABLES~~


~~COMPLEX_TABLES~~


~~COMPLEX_TABLES~~

==== Upiti za popunjavanje mandatornih polja ====


=== NULL vrednosti polja Tip,Boja,Model,Jed1,Jed2,JedPak,JedDSV,JedTez,JedZap,CCode,CName,CKorID,CDTStamp,TaksJed ===


<code>
UPDATE Elementi SET tip='' WHERE tip IS NULL
UPDATE Elementi SET boja='' WHERE boja IS NULL
UPDATE Elementi SET model='' WHERE model IS NULL
UPDATE Elementi SET jed1=jed, jed2=jed WHERE jed1 IS NULL
UPDATE Elementi SET jedpak='' WHERE jedpak IS NULL
UPDATE Elementi SET JedDSV='m',JedTez='g',JedZap='m3' WHERE JedTez IS NULL
UPDATE Elementi SET CCode='',CName='' WHERE CCode IS NULL
UPDATE Elementi SET CKorID=1 WHERE CKorID=0
UPDATE Elementi SET CDTStamp=NOW WHERE CDTStamp=0
UPDATE Elementi SET TaksJed='' WHERE TaksJed IS NULL
</code>