| ZEPROMETDATUM |
| |
Naziv |
Tip |
Null |
Privzeto |
Opis |
| KLJUC | char(11) | 1 | ('') | |
| POSLDOG | char(3) | 1 | ('') | |
| DATUM | datetime | 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 | datetime | 1 | | |
| DOKUMENT2 | char(20) | 1 | ('') | |
| DATDOKUM2 | datetime | 1 | | |
| IZJAVA | char(1) | 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 | ('') | |
| STARDATUMDUR | datetime | 1 | | |
| DNIZAPLAC | smallint | 1 | (0) | |
| DATUMVAL | datetime | 1 | (substring(convert(char,getdate(),102),1,10)) | |
| VREDNOST | money | 1 | (0) | |
| DAVEK | money | 1 | (0) | |
| POPUST | money | 1 | (0) | |
| ZAPLACILO | money | 1 | (0) | |
| KONTODB | char(8) | 1 | ('') | |
| REFERENT | char(2) | 1 | ('') | |
| POTRJENECENE | char(1) | 1 | ('F') | |
| DATUMZAP | datetime | 1 | (getdate()) | |
| USERZAP | char(2) | 1 | ('') | |
| DATUMSPRE | datetime | 1 | (getdate()) | |
| USERSPRE | char(2) | 1 | ('') | |
| VALUTA | char(3) | 1 | ('EUR') | |
| VREDVALUTA | money | 1 | (0) | |
| TECAJ | decimal(12,6) | 1 | (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 | 1 | (0) | |
| TRANSPORT | money | 1 | (0) | |
| DAJATVE | money | 1 | (0) | |
| NEPSTR | money | 1 | (0) | |
| VRDAVEK | money | 1 | (0) | |
| KNJIZEN | char(1) | 1 | ('F') | |
| OBLIKATL | char(3) | 1 | ('') | |
| DAVEKDDV | money | 1 | (0) | |
| STARDATUMPREJEMA | datetime | 1 | | |
| DATUMDDV | datetime | 1 | (substring(convert(char,getdate(),102),1,10)) | |
| PARITETA | char(3) | 1 | ('') | |
| PARITETAPOSTA | char(11) | 1 | ('') | |
| OSNOVADDV | money | 1 | (0) | |
| OPOMBA | text | 1 | | |