| PARAM |
| |
Naziv |
Tip |
Null |
Privzeto |
Opis |
| GKZACSTANJE | smalldatetime | 1 | | |
| GKKONTOKUP | varchar(255) | 1 | ('1200') | |
| GKKONTODOB | varchar(255) | 1 | ('2200') | |
| BANKASLOVENIJE | char(30) | 1 | ('') | |
| ROUNDT | decimal(9,4) | 0 | (1) | |
| NASAVALUTA | char(3) | 1 | ('EUR') | |
| DRZAVA | char(20) | 1 | ('') | |
| TSBREZDAVKA | char(2) | 1 | ('') | |
| TSBREZDAVKAIZD | char(2) | 1 | ('') | |
| NAROCDNIZAVELJ | smallint | 0 | (0) | |
| DATUMSPRE | datetime | 1 | (getdate()) | |
| USERSPRE | char(2) | 1 | ('') | |
| NASEPODJETJE | char(30) | 1 | ('') | |
| NEPSTR | money | 0 | (0) | |
| BANKACENIK | char(30) | 1 | ('') | |
| IZRACUNKALK | char(1) | 1 | ('C') | |
| PRIKKALKOBSPRC | char(1) | 1 | ('F') | |
| NARCALCKOSOL | char(1) | 1 | ('F') | |
| MSCALCKOSOL | char(1) | 1 | ('F') | |
| PROCRAZVCENI | decimal(6,2) | 0 | (0) | |
| MODEL | char(5) | 1 | ('') | |
| KONSIG | char(5) | 1 | ('') | |
| CENA0 | varchar(16) | 1 | ('Maloprod.cena') | |
| CENA1 | varchar(16) | 1 | ('Prodajna cena') | |
| CENA2 | varchar(16) | 1 | ('Veleprod. cena 1') | |
| CENA3 | varchar(16) | 1 | ('Veleprod. cena 2') | |
| CENA4 | varchar(16) | 1 | ('Sestavnica') | |
| FORMULAKOSOVNICA | varchar(255) | 1 | ('[#CenRazred#=1:#Sestavnica# * #MpCena# / #VpCena2#] [#CenRazred#=2:#Sestavnica# * #VpCena1# / #VpCena2#] #Sestavnica#') | |
| FORMULACENRAZRED | varchar(255) | 1 | ('[#CenRazred#=1:#MpCena#] [#CenRazred#=2:#VpCena1#] #VpCena2#') | |
| FORMULANABACENA | varchar(255) | 1 | ('#NabaCena#') | |
| SPREMREFERENTA | char(1) | 1 | ('') | |
| SKLADSESTBLAGO | varchar(30) | 1 | ('') | |
| OSNZAIZRPRODCENE | char(1) | 1 | ('P') | |
| AVTODATUMVSTOPA | smalldatetime | 1 | | |
| AVTOKONTROLADAT | char(1) | 1 | ('F') | |
| POLNIREFIZSUBJ | char(1) | 1 | ('F') | |
| NACIZRRABATA | char(1) | 1 | ('S') | |
| POSLDOGPROIZ | char(3) | 1 | ('') | |
| VRSTAMS | char(3) | 1 | ('') | |
| BANKACARINA | char(30) | 1 | ('') | |
| FIELDSA | varchar(20) | 1 | ('') | |
| FIELDSB | varchar(20) | 1 | ('') | |
| FIELDSC | varchar(20) | 1 | ('') | |
| FIELDNA | varchar(20) | 1 | ('') | |
| FIELDNB | varchar(20) | 1 | ('') | |
| POLNAMENNAK1 | varchar(30) | 1 | ('') | |
| POLNAMENNAK2 | varchar(40) | 1 | ('') | |
| POLNAMENNAK3 | varchar(40) | 1 | ('') | |
| POLVDOBRO1 | varchar(30) | 1 | ('') | |
| POLVDOBRO2 | varchar(40) | 1 | ('') | |
| POLSIFRA1 | char(2) | 1 | ('') | |
| POLSIFRA2 | char(2) | 1 | ('') | |
| POLSIFRA3 | char(2) | 1 | ('') | |
| POLZIRODOBRO1 | varchar(22) | 1 | ('') | |
| POLZIRODOBRO2 | char(2) | 1 | ('') | |
| POLZIRODOBRO3 | varchar(25) | 1 | ('') | |
| POLPRTPOSTA | char(1) | 1 | ('F') | |
| POLPOLNIINTDOK | char(1) | 1 | ('F') | |
| LOCENAPRODKALK | char(1) | 1 | ('F') | |
| DECMESTVRED | smallint | 1 | (2) | |
| KOLICVKODIDOL | smallint | 0 | (0) | |
| KOLICVKODIKONTROLA | char(1) | 1 | ('N') | |
| REPORTIZPISSUBJ | varchar(255) | 1 | ('KontOs;Naziv;Naziv2;Naslov;;Posta') | |
| MSCALCKOSCENA | char(3) | 1 | ('0') | |
| MSISCIPARTKODO | char(1) | 1 | ('N') | |
| CARINASERIALNO | char(1) | 1 | ('S') | |
| DECMESTCENA | smallint | 0 | (2) | |
| DECMESTKOLICINA | smallint | 0 | (2) | |
| MSKONTMNOGO | char(1) | 1 | ('N') | |
| NACIZRRABSUM | char(1) | 1 | ('T') | |
| MSNACIZRKOLI | char(1) | 1 | ('2') | |
| MSIZRKOLIROUND | char(1) | 1 | ('F') | |
| GKAVTOKNJBLGPREPOT | char(1) | 1 | ('T') | |
| GKAVTOKNJBLGIZDPOT | char(1) | 1 | ('F') | |
| MSIZPISIPARTKODO | char(1) | 1 | ('P') | |
| GKKONTOAVANS | char(8) | 1 | ('') | |
| ROUNDOS | decimal(9,4) | 0 | (1) | |
| ROUNDVR | decimal(9,4) | 0 | (1) | |
| ROUNDKOLI | decimal(9,4) | 0 | (1) | |
| ROUNDCEN | decimal(9,4) | 0 | (0) | |
| MINDOLZINAGESLA | smallint | 0 | (0) | |
| FIELDSD | varchar(20) | 1 | ('') | |
| FIELDSE | varchar(20) | 1 | ('') | |
| FIELDNC | varchar(20) | 1 | ('') | |
| FIELDND | varchar(20) | 1 | ('') | |
| FIELDNE | varchar(20) | 1 | ('') | |
| MSAVTOINCLEN | smallint | 0 | (0) | |
| MSAVTOINCCONST | varchar(16) | 1 | ('') | |
| MSAVTOINCFIELD | varchar(30) | 1 | ('') | |
| MSAVTOINCFIELDLEN | smallint | 0 | (0) | |
| SUBJAVTOINCLEN | smallint | 0 | (0) | |
| SUBJAVTOINCCONST | varchar(30) | 1 | ('') | |
| SUBJAVTOINCFIELD | varchar(30) | 1 | ('') | |
| SUBJAVTOINCFIELDLEN | smallint | 0 | (0) | |
| IZRZAPPRE | char(1) | 1 | ('R') | |
| IZRZAPIZD | char(1) | 1 | ('R') | |
| AVTOKNJDATDOKIZD | char(1) | 1 | ('R') | |
| AVTOKNJDATDOKPRE | char(1) | 1 | ('R') | |
| ZADNJAKOMPENZACIJA | smallint | 0 | (0) | |
| SPRKOSPOSPRIDENT | char(1) | 1 | ('F') | |
| NACKALKDAJATVE | char(1) | 1 | ('P') | |
| ROUNDDIM | decimal(9,4) | 0 | (1) | |
| MSEANFIELD | varchar(30) | 1 | ('') | |
| MSEANCONST | varchar(13) | 1 | ('') | |
| MSEANCHECK | char(1) | 1 | ('F') | |
| MSEANTIP | smallint | 0 | (0) | |
| MSKODAEANCONST | varchar(13) | 1 | ('') | |
| MSKODAEANFIELD | varchar(30) | 1 | ('') | |
| MSKODAEANCHECK | char(1) | 1 | ('F') | |
| MSKODAEANTIP | smallint | 0 | (0) | |
| NAROCKOSISROUND | char(1) | 1 | ('T') | |
| IZRPRETECAJ | char(1) | 1 | ('D') | |
| NAROCDODAJREFERENT | char(1) | 1 | ('F') | |
| NAROCDODAJDOK1 | char(1) | 1 | ('F') | |
| NAROCDODAJDOK2 | char(1) | 1 | ('F') | |
| MATZACSTANJE | smalldatetime | 1 | | |
| GKZAKLJUCEK | smalldatetime | 1 | | |
| KOMENTAR | char(1) | 1 | ('') | |
| NAROCKONTPROSTZAL | char(1) | 1 | ('F') | |
| PROIZIZRLASTNECENE | char(1) | 1 | ('S') | |
| KONTMINMARZE | decimal(6,3) | 0 | ((-1)) | |
| ODPREPODHFHEDATABASE | varchar(30) | 1 | ('') | |
| GKPOSLDOGZAK | char(3) | 1 | ('') | |
| GKPOSLDOGOTV | char(3) | 1 | ('') | |
| MAXMINKLJUC | smallint | 0 | ((-1)) | |
| KONTODPSTANJA | char(1) | 1 | ('D') | |
| PROMPOSPOTZAK | char(1) | 1 | ('F') | |
| RMAISCIKUPPOSN | char(1) | 1 | ('F') | |
| FIELDSF | varchar(20) | 1 | ('') | |
| FIELDSG | varchar(20) | 1 | ('') | |
| FIELDNF | varchar(20) | 1 | ('') | |
| FIELDNG | varchar(20) | 1 | ('') | |
| IDENTPOLJUBNOSELECTISCI | varchar(255) | 1 | ('SELECT Ident, Koda, EM, Aktivno, Klasif, Naziv, VrstaMS FROM MS ORDER BY Ident') | |
| IDENTLOOKUPSELECTIDENT | varchar(255) | 1 | ('SELECT Ident, Aktivno, Naziv, MPCena, VPCena, VPCena2, Sestavnica FROM MS ORDER BY Ident') | |
| IDENTLOOKUPSELECTNAZIV | varchar(255) | 1 | ('SELECT Ident, Aktivno, Naziv, MPCena, VPCena, VPCena2, Sestavnica FROM MS ORDER BY Naziv') | |
| FIELDSALOOKUP | varchar(255) | 1 | ('') | |
| FIELDSBLOOKUP | varchar(255) | 1 | ('') | |
| FIELDSCLOOKUP | varchar(255) | 1 | ('') | |
| FIELDSDLOOKUP | varchar(255) | 1 | ('') | |
| FIELDSELOOKUP | varchar(255) | 1 | ('') | |
| FIELDSFLOOKUP | varchar(255) | 1 | ('') | |
| FIELDSGLOOKUP | varchar(255) | 1 | ('') | |
| GKIZTERJAVAVRSTA | char(3) | 1 | ('') | |
| GKIZTERJAVANEVRSTA | char(3) | 1 | ('') | |
| GKIZTERJAVADOKVRSTA | char(3) | 1 | ('') | |
| FIELDPNA | decimal(19,6) | 0 | (0) | |
| KNJSTANJEKUPDNIZAP | smallint | 0 | (0) | |
| FIELDPNB | decimal(19,6) | 0 | (0) | |
| FIELDNH | varchar(20) | 1 | ('') | |
| FIELDNI | varchar(20) | 1 | ('') | |
| FIELDNJ | varchar(20) | 1 | ('') | |
| FIELDSI | varchar(20) | 1 | ('') | |
| FIELDSH | varchar(20) | 1 | ('') | |
| FIELDSJ | varchar(20) | 1 | ('') | |
| FIELDSHLOOKUP | varchar(255) | 1 | ('') | |
| FIELDSILOOKUP | varchar(255) | 1 | ('') | |
| FIELDSJLOOKUP | varchar(255) | 1 | ('') | |
| OBROKMAXSTEV | smallint | 0 | ((-1)) | |
| OBROKPRIVZAMIK | smallint | 0 | (0) | |
| OBROKPRIVTIP | smallint | 0 | (0) | |
| NAROCOLSTATUSIZ | varchar(50) | 1 | ('') | |
| NAROCOLSTATUSNA | char(2) | 1 | ('') | |
| GKAVTOKNJPOTNALPOT | char(1) | 1 | ('F') | |
| TSDEFAULT | char(2) | 1 | ('') | |
| PROMETVNOSBREZPC | char(1) | 1 | ('N') | |
| PROMETVNOSBREZPCDATUM | smalldatetime | 1 | | |
| AVTOKNJODDSTRNIZD | char(1) | 1 | ('0') | |
| AVTOKNJODDSTRNPRE | char(1) | 1 | ('0') | |
| SIFMSSPRMPCENA | char(1) | 1 | ('T') | |
| PRENOSNAROCPROIZ | char(1) | 1 | ('1') | |
| PROMETPOSCENAPOCR | char(1) | 1 | ('F') | |
| IZRIZDTECAJ | char(1) | 1 | ('I') | |
| ROUNDPOS | decimal(9,4) | 0 | (1) | |
| PRTPOSTADELDRZAVA | char(1) | 1 | ('-') | |
| PRTPOSTADELZAP | char(1) | 1 | ('') | |
| PRTPOSTATIP | char(1) | 1 | ('V') | |
| GKZAPPOODDSTRN | char(1) | 1 | ('F') | |
| GKAVTOKNJMATPOTPOT | char(1) | 1 | ('F') | |
| NAROCREZERVACIJE | bit | 1 | (0) | |
| POLNIPRODPOG | char(1) | 1 | ('1') | |
| AVTOKNJODDSTRNOS | char(1) | 1 | ('0') | |
| FIELDSNA | varchar(20) | 1 | ('') | |
| FIELDSNB | varchar(20) | 1 | ('') | |
| FIELDSNC | varchar(20) | 1 | ('') | |
| FIELDSND | varchar(20) | 1 | ('') | |
| FIELDSNE | varchar(20) | 1 | ('') | |
| FIELDSNF | varchar(20) | 1 | ('') | |
| FIELDSNG | varchar(20) | 1 | ('') | |
| FIELDSNH | varchar(20) | 1 | ('') | |
| FIELDSNI | varchar(20) | 1 | ('') | |
| FIELDSNJ | varchar(20) | 1 | ('') | |
| FIELDSSA | varchar(20) | 1 | ('') | |
| FIELDSSALOOKUP | varchar(255) | 1 | ('') | |
| FIELDSSB | varchar(20) | 1 | ('') | |
| FIELDSSBLOOKUP | varchar(255) | 1 | ('') | |
| FIELDSSC | varchar(20) | 1 | ('') | |
| FIELDSSCLOOKUP | varchar(255) | 1 | ('') | |
| FIELDSSD | varchar(20) | 1 | ('') | |
| FIELDSSDLOOKUP | varchar(255) | 1 | ('') | |
| FIELDSSE | varchar(20) | 1 | ('') | |
| FIELDSSELOOKUP | varchar(255) | 1 | ('') | |
| FIELDSSF | varchar(20) | 1 | ('') | |
| FIELDSSFLOOKUP | varchar(255) | 1 | ('') | |
| FIELDSSG | varchar(20) | 1 | ('') | |
| FIELDSSGLOOKUP | varchar(255) | 1 | ('') | |
| FIELDSSH | varchar(20) | 1 | ('') | |
| FIELDSSHLOOKUP | varchar(255) | 1 | ('') | |
| FIELDSSI | varchar(20) | 1 | ('') | |
| FIELDSSILOOKUP | varchar(255) | 1 | ('') | |
| FIELDSSJ | varchar(20) | 1 | ('') | |
| FIELDSSJLOOKUP | varchar(255) | 1 | ('') | |
| FIELDSDA | varchar(20) | 1 | ('') | |
| FIELDSDB | varchar(20) | 1 | ('') | |
| FIELDSDC | varchar(20) | 1 | ('') | |
| FIELDSDD | varchar(20) | 1 | ('') | |
| GLAVA | image | 1 | | |
| IDENTLOOKUPNAZIV | text | 1 | | |
| IDENTLOOKUPIDENT | text | 1 | | |
| IDENTPOLJUBNOISCI | text | 1 | | |
| DOKUMENTOPOMBAB | text | 1 | | |
| DOKUMENTOPOMBAA | text | 1 | | |