| PROMET |
| |
Naziv |
Tip |
Null |
Privzeto |
Opis |
| KLJUC | char(11) | 1 | ('') | |
| POSLDOG | char(3) | 1 | ('') | |
| DATUM | smalldatetime | 1 | (substring(convert(char,getdate(),102),1,10)) | |
| PREJEMNIK | char(30) | 1 | ('') | |
| IZDAJATELJ | char(30) | 1 | ('') | |
| PREJEMNIKZAL | char(1) | 1 | ('N') | |
| IZDAJATELJZAL | char(1) | 1 | ('N') | |
| OSEBA3 | char(30) | 1 | ('') | |
| KONTOSEBA | char(30) | 1 | ('') | |
| DOKUMENT1 | char(20) | 1 | ('') | |
| DATDOKUM1 | smalldatetime | 1 | | |
| DOKUMENT2 | char(20) | 1 | ('') | |
| DATDOKUM2 | smalldatetime | 1 | | |
| IZJAVA | char(2) | 1 | ('') | |
| NACPRODAJE | char(1) | 1 | ('K') | |
| CENRAZRED | char(1) | 1 | ('1') | |
| NACINPLAC | char(3) | 1 | ('') | |
| DOSTAVA | char(2) | 1 | ('') | |
| OBLIKA | char(3) | 1 | ('') | |
| OBLIKAFAK | char(3) | 1 | ('') | |
| DNIZAPLAC | smallint | 0 | (0) | |
| DATUMVAL | smalldatetime | 1 | (substring(convert(char,getdate(),102),1,10)) | |
| VREDNOST | money | 0 | (0) | |
| DAVEK | money | 0 | (0) | |
| POPUST | money | 0 | (0) | |
| ZAPLACILO | money | 0 | (0) | |
| MEJNACARINA | char(8) | 1 | ('') | |
| REFERENT | char(2) | 1 | ('') | |
| POTRJENECENE | char(1) | 1 | ('F') | |
| VALUTA | char(3) | 1 | ('SIT') | |
| VREDVALUTA | money | 0 | (0) | |
| TECAJ | decimal(12,6) | 0 | (1) | |
| SIFRA1 | char(2) | 1 | ('') | |
| SIFRA2 | char(2) | 1 | ('') | |
| SIFRA3 | char(2) | 1 | ('') | |
| NAMENNAK1 | char(25) | 1 | ('') | |
| NAMENNAK2 | char(30) | 1 | ('') | |
| NAMENNAK3 | char(30) | 1 | ('') | |
| SKLICNASTEV1 | char(20) | 1 | ('') | |
| SKLICNASTEV2 | char(35) | 1 | ('') | |
| ODDELEK | char(30) | 1 | ('') | |
| KONTOSEBA3 | char(30) | 1 | ('') | |
| RABAT | money | 0 | (0) | |
| TRANSPORT | money | 0 | (0) | |
| DAJATVE | money | 0 | (0) | |
| NEPSTR | money | 0 | (0) | |
| VRDAVEK | money | 0 | (0) | |
| KNJIZEN | char(1) | 1 | ('F') | |
| OBLIKATL | char(3) | 1 | ('') | |
| DAVEKDDV | money | 0 | (0) | |
| DATUMDDV | smalldatetime | 1 | (substring(convert(char,getdate(),102),1,10)) | |
| PARITETA | char(3) | 1 | ('') | |
| PARITETAPOSTA | char(11) | 1 | ('') | |
| OSNOVADDV | money | 0 | (0) | |
| BANKARACUN | smallint | 0 | (1) | |
| KREIZDN | char(1) | 1 | ('F') | |
| DATUMPREDDDV | smalldatetime | 1 | (substring(convert(char,getdate(),102),1,10)) | |
| DATUMZAP | datetime | 1 | (getdate()) | |
| USERZAP | char(2) | 1 | ('') | |
| DATUMSPRE | datetime | 1 | (getdate()) | |
| USERSPRE | char(2) | 1 | ('') | |
| OPOMBA | varchar(4096) | 1 | ('') | |
| DATUMRAC | smalldatetime | 1 | (substring(convert(char,getdate(),102),1,10)) | |
| ISODRZAVA | char(3) | 1 | ('') | |
| TRIPARTPOSEL | char(1) | 1 | ('0') | |
| KONTOTEROBV | char(8) | 1 | ('') | |
| PRILOGADDVTIP | char(1) | 1 | ('0') | |
| PRILOGADDVDATUM | smalldatetime | 1 | | |
| KREVIR | char(1) | 1 | ('T') | |
| ODDELEKIZD | char(30) | 1 | ('') | |
| STRNIZD | char(16) | 1 | ('') | |
| REFERENTZAP | char(2) | 1 | ('') | |