ÿþCREATE TABLE [dbo].[BLSALDO] ( [SIFRADOK] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [DATUM] [datetime] NULL , [KOLICINA] [float] NULL , [CENA] [float] NULL , [ZNESEK] [float] NULL , [SIFPLA] [nvarchar] (6) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[BLZSALDO] ( [IDENT] [int] IDENTITY (1, 1) NOT NULL , [SIFRADOK] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [DATUM] [datetime] NULL , [VSOTA] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CARtarife] ( [Tarifa] [nvarchar] (50) COLLATE Slovenian_CI_AS NOT NULL , [Opis] [nvarchar] (250) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[CEKI] ( [SIFRADOK] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [STEVDOK] [int] NULL , [SIFPLACILA] [nvarchar] (6) COLLATE Slovenian_CI_AS NULL , [ZNESEK] [float] NULL , [opis] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [datumdok] [datetime] NULL , [status] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [placilaproc] [int] NULL , [IDEPA] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL , [VALUTA] [datetime] NULL , [VVNOVCITEV] [datetime] NULL , [REALIZIRAN] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [NAZIV] [nvarchar] (150) COLLATE Slovenian_CI_AS NULL , [IZVOR] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DENAR] ( [SIFRA] [nvarchar] (6) COLLATE Slovenian_CI_AS NULL , [OPIS] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [BANKA] [nvarchar] (20) COLLATE Slovenian_CI_AS NULL , [PROVIZIJA] [float] NULL , [TRR] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [TIP] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[DNprostoritve] ( [Opisnar] [ntext] COLLATE Slovenian_CI_AS NULL , [OpisDela] [ntext] COLLATE Slovenian_CI_AS NULL , [Opombe] [ntext] COLLATE Slovenian_CI_AS NULL , [klavzula] [ntext] COLLATE Slovenian_CI_AS NULL , [nalog] [nvarchar] (12) COLLATE Slovenian_CI_AS NOT NULL , [Konos] [nvarchar] (200) COLLATE Slovenian_CI_AS NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[DnproEtikete] ( [Etiketa] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [Stroj] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Barve] [nvarchar] (90) COLLATE Slovenian_CI_AS NULL , [Opomba] [nvarchar] (255) COLLATE Slovenian_CI_AS NULL , [Stanca] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Kosov] [int] NULL , [Sirina] [float] NULL , [Premerjedra] [float] NULL , [MaxPremer] [float] NULL , [StevVzorcev] [int] NULL , [Zaponatis] [int] NULL , [Navitje1] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Navitje2] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [nalog] [nvarchar] (12) COLLATE Slovenian_CI_AS NOT NULL , [pak1] [bit] NOT NULL , [pak2] [bit] NOT NULL , [pak3] [bit] NOT NULL , [PakUR] [money] NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Dnpronormativi] ( [IDPAKETA] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [IDARTIKLA] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [KOLICINA] [float] NULL , [SERIJA] [int] NULL , [CENA] [money] NULL , [SKL] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [STRM] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [POZICIJA] [int] NOT NULL , [kljuc] [int] IDENTITY (1, 1) NOT NULL , [OP] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [KOLICINAS] [float] NULL , [Nalog] [nvarchar] (12) COLLATE Slovenian_CI_AS NOT NULL , [Rabat] [money] NULL , [Pozizd] [int] NULL , [Stevizd] [int] NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Dnprooperacije] ( [IDPAKETA] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [OP] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [NORMAUR] [float] NULL , [PRETOCNOUR] [float] NULL , [CENA] [money] NULL , [SERIJA] [int] NULL , [DM] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [STRM] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [POZICIJA] [int] NOT NULL , [kljuc] [int] IDENTITY (1, 1) NOT NULL , [naziv] [nvarchar] (250) COLLATE Slovenian_CI_AS NULL , [opis] [ntext] COLLATE Slovenian_CI_AS NULL , [Nalog] [nvarchar] (12) COLLATE Slovenian_CI_AS NOT NULL , [delavec] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [cenaP] [money] NULL , [tocka] [money] NULL , [Datum] [datetime] NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[Dnpropribitki] ( [IDPAKETA] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [SIFRA] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [TIP] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [OSNOVA] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [PROCENT] [float] NULL , [ZNESEK] [money] NULL , [ZNFAKTOR] [float] NULL , [ZNEM] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [SERIJA] [int] NULL , [STRM] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [POZICIJA] [int] NOT NULL , [kljuc] [int] IDENTITY (1, 1) NOT NULL , [OPIS] [nvarchar] (250) COLLATE Slovenian_CI_AS NULL , [Nalog] [nvarchar] (12) COLLATE Slovenian_CI_AS NOT NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[EDIEan] ( [EAN] [nvarchar] (35) COLLATE Slovenian_CI_AS NOT NULL , [Naziv] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Ident] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[EDIOsnovaN] ( [ST_IZMENJA] [nvarchar] (14) COLLATE Slovenian_CI_AS NULL , [EAN_LOK_ME] [nvarchar] (35) COLLATE Slovenian_CI_AS NOT NULL , [ST_DOKUMEN] [nvarchar] (35) COLLATE Slovenian_CI_AS NOT NULL , [ZAP_ST_NAR] [nvarchar] (14) COLLATE Slovenian_CI_AS NULL , [FUNK_DOK] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [DAT_CAS_N] [datetime] NULL , [DAT_CAS_D] [datetime] NULL , [EAN_KUP] [nvarchar] (35) COLLATE Slovenian_CI_AS NULL , [NAZ_KUP] [nvarchar] (35) COLLATE Slovenian_CI_AS NULL , [EAN_MD] [nvarchar] (35) COLLATE Slovenian_CI_AS NULL , [NAZ_MD] [nvarchar] (35) COLLATE Slovenian_CI_AS NULL , [EAN_OE_D] [nvarchar] (35) COLLATE Slovenian_CI_AS NULL , [NAZ_OE_D] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [STEV_POST] [int] NULL , [OPOMBA] [nvarchar] (70) COLLATE Slovenian_CI_AS NULL , [ST_PROM] [nvarchar] (35) COLLATE Slovenian_CI_AS NULL , [EAN_NAR] [nvarchar] (35) COLLATE Slovenian_CI_AS NULL , [NAZ_NAR] [nvarchar] (35) COLLATE Slovenian_CI_AS NULL , [NAC_DOST] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [EAN_SF] [nvarchar] (35) COLLATE Slovenian_CI_AS NULL , [NAZ_SF] [nvarchar] (35) COLLATE Slovenian_CI_AS NULL , [TIP_NAR] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[EDIPostavkeN] ( [ST_IZMENJA] [nvarchar] (14) COLLATE Slovenian_CI_AS NULL , [EAN_LOK_ME] [nvarchar] (35) COLLATE Slovenian_CI_AS NOT NULL , [ST_DOKUMEN] [nvarchar] (35) COLLATE Slovenian_CI_AS NOT NULL , [ZAP_ST_POS] [int] NOT NULL , [EAN_UPC_A] [nvarchar] (35) COLLATE Slovenian_CI_AS NULL , [V_ST_KODE] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [D_ID_ART] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [DOB_SIF_A] [nvarchar] (35) COLLATE Slovenian_CI_AS NULL , [INT_SIF_A] [nvarchar] (35) COLLATE Slovenian_CI_AS NULL , [NAZ_ART_1] [nvarchar] (35) COLLATE Slovenian_CI_AS NULL , [NAZ_ART_2] [nvarchar] (35) COLLATE Slovenian_CI_AS NULL , [KOLICINA] [decimal](15, 0) NULL , [E_MERE] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [DAT_UPORA] [datetime] NULL , [CENA_ART] [money] NULL , [OPOMBA] [nvarchar] (70) COLLATE Slovenian_CI_AS NULL , [PAK_ZAH1] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [PAK_ZAH2] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [PAK_ZAH3] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [DOD_SIF_A1] [nvarchar] (35) COLLATE Slovenian_CI_AS NULL , [DOD_SIF_A2] [nvarchar] (35) COLLATE Slovenian_CI_AS NULL , [CENA2_OZN] [money] NULL , [CENA2_OSN] [money] NULL , [CENA2_MER] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [CENA3] [money] NULL , [DAVEK] [nvarchar] (6) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Embalaze] ( [Sifra] [nvarchar] (12) COLLATE Slovenian_CI_AS NOT NULL , [Opis] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [Cena] [money] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Gladok] ( [Sifradok] [nvarchar] (3) COLLATE Slovenian_CI_AS NOT NULL , [Stevdok] [int] NOT NULL , [Kljuc] [int] IDENTITY (1, 1) NOT NULL , [Skl] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Datumdok] [datetime] NULL , [Datumknj] [datetime] NULL , [Idepa] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL , [Prevoznik] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL , [Kupec] [nvarchar] (120) COLLATE Slovenian_CI_AS NULL , [Status] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Poraba] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Uporabnik] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Narocilo] [nvarchar] (24) COLLATE Slovenian_CI_AS NULL , [nalog] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Valuta] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Tecaj] [money] NULL , [Racun] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [VrednostN] [money] NULL , [Vrednostvp] [money] NULL , [VrednostMP] [money] NULL , [Postavke] [bit] NOT NULL , [Klavzula] [ntext] COLLATE Slovenian_CI_AS NULL , [Vstevdok] [int] NULL , [Vsifradok] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Vstorno] [bit] NOT NULL , [Vskl] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Davcna] [nvarchar] (25) COLLATE Slovenian_CI_AS NULL , [Miza] [smallint] NULL , [oddelek] [nvarchar] (250) COLLATE Slovenian_CI_AS NULL , [Intra_porocanje] [bit] NOT NULL , [Intra_faktvr] [money] NULL , [Intra_statvr] [money] NULL , [Intra_drzavaN] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Intra_drzavaP] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Intra_Pogoji] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Intra_Lega] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Intra_VrstaPosla] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Intra_Prevoz] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[IDembalaze] ( [Ident] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [SifraE] [nvarchar] (12) COLLATE Slovenian_CI_AS NOT NULL , [Teza] [money] NULL , [Cena] [money] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[INTRAglave] ( [ZaporednaStevilka] [nvarchar] (6) COLLATE Slovenian_CI_AS NULL , [VrstaStavka] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [ZaporednaStevilkaObrazca] [nvarchar] (6) COLLATE Slovenian_CI_AS NULL , [ZaporednaStevilkaPostavke] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [PO] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [EvidencnaStevilka] [nvarchar] (20) COLLATE Slovenian_CI_AS NOT NULL , [OznakaDrzavePE] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [DavcnaPE] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL , [OEPE] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [ObdobjePorocanja] [nvarchar] (6) COLLATE Slovenian_CI_AS NULL , [SteviloPostavk] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [ZadnjiDok] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Oznakadrzave] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [DavcnaDeklaranta] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [OEdeklaranta] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [VlogaDokumenta] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Valuta] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Polnilo] [nvarchar] (67) COLLATE Slovenian_CI_AS NULL , [Posilka] [nvarchar] (10) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[INTRAkonst] ( [Davcna] [nvarchar] (12) COLLATE Slovenian_CI_AS NOT NULL , [OE] [nvarchar] (3) COLLATE Slovenian_CI_AS NOT NULL , [Deklarant_davcna] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Deklarant_OE] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Drzava] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Pogoji] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Pogoj2] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [VP1] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [VP2] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Transport] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [DavcnaCarine] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [OEcarine] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [VP] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [DrzavaP] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[INTRApostavke] ( [ZaporednaStevilka] [nvarchar] (6) COLLATE Slovenian_CI_AS NULL , [VrstaStavka] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [ZaporednaStevilkaObrazca] [nvarchar] (6) COLLATE Slovenian_CI_AS NULL , [ZaporednaStevilkaPostavke] [nvarchar] (3) COLLATE Slovenian_CI_AS NOT NULL , [PO] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [EvidencnaStevilka] [nvarchar] (20) COLLATE Slovenian_CI_AS NOT NULL , [DrzavaNamena] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [PogojiDobave] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [PogojiDobave2_LEGA] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [VrstaPosla] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [VrstaPosla2] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [VrstaTransporta] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Tarifa] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL , [KNSI] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [DrzavaPorekla] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [NetoMasa] [float] NULL , [Kolicina] [float] NULL , [FakturnaVrednost] [money] NULL , [StatisticnaVr] [money] NULL , [Regija] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Pristanisce] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Polnilo] [nvarchar] (27) COLLATE Slovenian_CI_AS NULL , [Opis] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [ident] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Sifradok] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Stevdok] [int] NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[INTRAvodilni] ( [ZaporednaStevilka] [nvarchar] (6) COLLATE Slovenian_CI_AS NULL , [VrstaStavka] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [ZaporednaStevilkaObrazca] [nvarchar] (6) COLLATE Slovenian_CI_AS NULL , [ZaporednaStevilkaPostavke] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [VrstaSporocila] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Leto] [nvarchar] (4) COLLATE Slovenian_CI_AS NOT NULL , [ZaporednaPosilka] [nvarchar] (6) COLLATE Slovenian_CI_AS NOT NULL , [SteviloStavkov] [nvarchar] (6) COLLATE Slovenian_CI_AS NULL , [SteviloDokumentov] [nvarchar] (6) COLLATE Slovenian_CI_AS NULL , [SteviloPostavk] [nvarchar] (6) COLLATE Slovenian_CI_AS NULL , [OznakaDrzave] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [DavcnaStevilka] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [OE] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [OznakaNaslovnika] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [DavcnaNaslovnika] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL , [OENaslovnika] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Datumsporocila] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL , [CasSporocila] [nvarchar] (6) COLLATE Slovenian_CI_AS NULL , [Verzija] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Zastavice] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Polnilo] [nvarchar] (41) COLLATE Slovenian_CI_AS NULL , [Datumknj] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[IntraDrzave] ( [Oznaka] [nvarchar] (3) COLLATE Slovenian_CI_AS NOT NULL , [Ime] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[IntraLega] ( [Oznaka] [nvarchar] (1) COLLATE Slovenian_CI_AS NOT NULL , [Opis] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[IntraPogoji] ( [Oznaka] [nvarchar] (3) COLLATE Slovenian_CI_AS NOT NULL , [Pomen] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Opis] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[IntraTransport] ( [Oznaka] [nvarchar] (1) COLLATE Slovenian_CI_AS NOT NULL , [Opis] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Kupcenik] ( [Idepa] [nvarchar] (8) COLLATE Slovenian_CI_AS NOT NULL , [Ident] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [Klas] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Vpcena] [money] NULL , [Rabat] [money] NULL , [Rabat1] [money] NULL , [DK] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Mpcena] [money] NULL , [Valcena] [money] NULL , [Valuta] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Koda] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Naziv] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Strm] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [faktorkol] [float] NULL , [faktorcene] [float] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Kupstrm] ( [Idepa] [nvarchar] (8) COLLATE Slovenian_CI_AS NOT NULL , [Ident] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [Klas] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Vpcena] [money] NULL , [Rabat] [money] NULL , [Rabat1] [money] NULL , [DK] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Mpcena] [money] NULL , [Valcena] [money] NULL , [Valuta] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Prevoznik] [nvarchar] (8) COLLATE Slovenian_CI_AS NOT NULL , [SKl] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Strm] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Naziv] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[LCD] ( [ident] [int] IDENTITY (1, 1) NOT NULL , [OZNAKA] [nvarchar] (10) COLLATE Slovenian_CI_AS NULL , [OPIS] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [A] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [B] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [T1A] [nvarchar] (20) COLLATE Slovenian_CI_AS NULL , [T1B] [nvarchar] (20) COLLATE Slovenian_CI_AS NULL , [T2A] [nvarchar] (20) COLLATE Slovenian_CI_AS NULL , [T2B] [nvarchar] (20) COLLATE Slovenian_CI_AS NULL , [T3A] [nvarchar] (20) COLLATE Slovenian_CI_AS NULL , [T3B] [nvarchar] (20) COLLATE Slovenian_CI_AS NULL , [T4A] [nvarchar] (20) COLLATE Slovenian_CI_AS NULL , [T4B] [nvarchar] (20) COLLATE Slovenian_CI_AS NULL , [PORT] [nvarchar] (4) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Lokacije] ( [Lokacija] [nvarchar] (25) COLLATE Slovenian_CI_AS NOT NULL , [Opis] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[NORMATIVI] ( [IDPAKETA] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [IDARTIKLA] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [KOLICINA] [float] NULL , [CENA] [money] NULL , [DELEZCENE] [float] NULL , [POZICIJA] [int] NULL , [kljuc] [int] IDENTITY (1, 1) NOT NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Nabave] ( [Sifra] [nvarchar] (2) COLLATE Slovenian_CI_AS NOT NULL , [Opis] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [Tip] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Davek] [money] NULL , [Konto] [nvarchar] (7) COLLATE Slovenian_CI_AS NULL , [dok] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [OSNDDV] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Zadnji] [int] NULL , [VPstevilci] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [SKl] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Tipkalk] [smallint] NULL , [VPZ] [smallint] NULL , [MPZ] [smallint] NULL , [Serstev] [bit] NOT NULL , [Klavzula] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Nargladok] ( [Sifradok] [nvarchar] (3) COLLATE Slovenian_CI_AS NOT NULL , [Stevdok] [int] NOT NULL , [Kljuc] [int] IDENTITY (1, 1) NOT NULL , [Skl] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Datumdok] [datetime] NULL , [Datumknj] [datetime] NULL , [Idepa] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL , [Prevoznik] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL , [Kupec] [nvarchar] (120) COLLATE Slovenian_CI_AS NULL , [Status] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Poraba] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Uporabnik] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Narocilo] [nvarchar] (24) COLLATE Slovenian_CI_AS NULL , [nalog] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Valuta] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Tecaj] [money] NULL , [Racun] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [VrednostN] [money] NULL , [Vrednostvp] [money] NULL , [VrednostMP] [money] NULL , [Postavke] [bit] NOT NULL , [Klavzula] [ntext] COLLATE Slovenian_CI_AS NULL , [Vstevdok] [int] NULL , [Vsifradok] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Vstorno] [bit] NOT NULL , [Vskl] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Davcna] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL , [Miza] [smallint] NULL , [Datumrok] [datetime] NULL , [Opomba] [nvarchar] (255) COLLATE Slovenian_CI_AS NULL , [Konos] [nvarchar] (255) COLLATE Slovenian_CI_AS NULL , [Datump] [datetime] NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[Narpromet] ( [Ident] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [Naziv] [nvarchar] (250) COLLATE Slovenian_CI_AS NULL , [Skl] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Datumdok] [datetime] NULL , [Sifradok] [nvarchar] (3) COLLATE Slovenian_CI_AS NOT NULL , [Stevdok] [int] NOT NULL , [Pozicija] [smallint] NOT NULL , [Kolicina] [money] NULL , [Vrstaprom] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [status] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Opomba] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [Fakcena] [money] NULL , [Dobcena] [money] NULL , [Dobddv] [money] NULL , [dobFaktor] [float] NULL , [Odvisni] [money] NULL , [odvproc] [money] NULL , [Cena] [money] NULL , [Vpcena] [float] NULL , [Mposnova] [float] NULL , [Mpcena] [float] NULL , [Provizija] [money] NULL , [Nalog] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Rabat] [money] NULL , [Rabat1] [money] NULL , [Serstev] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Valcena] [float] NULL , [Em] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [fifocena] [money] NULL , [popcena] [money] NULL , [Mpzalcena] [money] NULL , [Mpniv] [money] NULL , [Kumkol] [money] NULL , [Normpoz] [int] NOT NULL , [Davekproc] [money] NULL , [Datumrok] [datetime] NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[OpomnikiDEF] ( [Ident] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Naziv] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Tip] [nvarchar] (10) COLLATE Slovenian_CI_AS NULL , [Idepa] [nvarchar] (10) COLLATE Slovenian_CI_AS NULL , [Datumod] [datetime] NULL , [Interval] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Ponovitev] [int] NULL , [kljuc] [int] IDENTITY (1, 1) NOT NULL , [opis] [nvarchar] (250) COLLATE Slovenian_CI_AS NULL , [Ninterval] [float] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[OpomnikiP] ( [kljuc] [int] IDENTITY (1, 1) NOT NULL , [datumop] [nvarchar] (25) COLLATE Slovenian_CI_AS NULL , [opombe] [nvarchar] (150) COLLATE Slovenian_CI_AS NULL , [racun] [nvarchar] (25) COLLATE Slovenian_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Optima] ( [Blagajna] [nvarchar] (2) COLLATE Slovenian_CI_AS NOT NULL , [SKl] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Comport] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Modem] [bit] NOT NULL , [Telefon] [nvarchar] (24) COLLATE Slovenian_CI_AS NULL , [Datumv] [datetime] NULL , [Datumiz] [datetime] NULL , [VP] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Zadnja] [int] NULL , [Tip] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [R1] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [r2] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [R3] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[PLACILA] ( [SIFRADOK] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [STEVDOK] [int] NULL , [SIFPLACILA] [nvarchar] (6) COLLATE Slovenian_CI_AS NULL , [ZNESEK] [float] NULL , [opis] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [datumdok] [datetime] NULL , [status] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [placilaproc] [int] NULL , [IDEPA] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL , [VALUTA] [datetime] NULL , [VVNOVCITEV] [datetime] NULL , [REALIZIRAN] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[PRODM] ( [DM] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [OPIS] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [CENA] [money] NULL , [STRM] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [CENAP] [money] NULL , [CENAN] [money] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[PROEtikete] ( [Etiketa] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [Stroj] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Barve] [nvarchar] (90) COLLATE Slovenian_CI_AS NULL , [Opomba] [nvarchar] (255) COLLATE Slovenian_CI_AS NULL , [Stanca] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Kosov] [int] NULL , [Sirina] [float] NULL , [Premerjedra] [float] NULL , [MaxPremer] [float] NULL , [StevVzorcev] [int] NULL , [Zaponatis] [int] NULL , [Navitje1] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Navitje2] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[PRONORMATIVI] ( [IDPAKETA] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [IDARTIKLA] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [KOLICINA] [float] NULL , [SERIJA] [int] NULL , [CENA] [money] NULL , [SKL] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [STRM] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [POZICIJA] [int] NOT NULL , [kljuc] [int] IDENTITY (1, 1) NOT NULL , [OP] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [PROCENT] [money] NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[PROOPERACIJE] ( [IDPAKETA] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [OP] [nvarchar] (50) COLLATE Slovenian_CI_AS NOT NULL , [NORMAUR] [float] NULL , [PRETOCNOUR] [float] NULL , [CENA] [money] NULL , [SERIJA] [int] NULL , [DM] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [STRM] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [POZICIJA] [int] NOT NULL , [kljuc] [int] IDENTITY (1, 1) NOT NULL , [naziv] [nvarchar] (250) COLLATE Slovenian_CI_AS NULL , [opis] [ntext] COLLATE Slovenian_CI_AS NULL , [tocka] [money] NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[PROPRIBITKI] ( [IDPAKETA] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [SIFRA] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [TIP] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [OSNOVA] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [PROCENT] [float] NULL , [ZNESEK] [money] NULL , [ZNFAKTOR] [float] NULL , [ZNEM] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [SERIJA] [int] NULL , [STRM] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [POZICIJA] [int] NOT NULL , [kljuc] [int] IDENTITY (1, 1) NOT NULL , [OPIS] [nvarchar] (250) COLLATE Slovenian_CI_AS NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[PROSIFOP] ( [OP] [nvarchar] (50) COLLATE Slovenian_CI_AS NOT NULL , [NORMAUR] [float] NULL , [PRETOCNOUR] [float] NULL , [CENA] [money] NULL , [DM] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [STRM] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [naziv] [nvarchar] (250) COLLATE Slovenian_CI_AS NULL , [opis] [ntext] COLLATE Slovenian_CI_AS NULL , [tocka] [money] NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[PROSIFPRIB] ( [SIFRA] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [TIP] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [OSNOVA] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [PROCENT] [float] NULL , [ZNESEK] [money] NULL , [ZNFAKTOR] [float] NULL , [ZNEM] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [STRM] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [OPIS] [nvarchar] (250) COLLATE Slovenian_CI_AS NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[PROTIPNAL] ( [Sifra] [nvarchar] (6) COLLATE Slovenian_CI_AS NOT NULL , [Opis] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [Tip] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Davek] [money] NULL , [Konto] [nvarchar] (7) COLLATE Slovenian_CI_AS NULL , [dok] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [OSNDDV] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Zadnji] [int] NULL , [VPstevilci] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Skl] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [tipkalk] [smallint] NULL , [VPZ] [smallint] NULL , [MPZ] [smallint] NULL , [Serstev] [bit] NOT NULL , [Ratip] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Klavzula] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Popust] [money] NULL , [SklMAT] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [IZDtip] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[PROstance] ( [IDstance] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [narocnik] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [posebnost] [nvarchar] (255) COLLATE Slovenian_CI_AS NULL , [visina_trak] [float] NULL , [dolzina_tek] [float] NULL , [povisini] [float] NULL , [poteku] [float] NULL , [raz_vis] [float] NULL , [raz_dol] [float] NULL , [zaoblj] [float] NULL , [datoteka] [nvarchar] (255) COLLATE Slovenian_CI_AS NULL , [datum] [datetime] NULL , [mat_izs] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [inch N] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [inch R] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Opombe] [nvarchar] (255) COLLATE Slovenian_CI_AS NULL , [Dolzina_pomika_N] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Dolzina_pomika_R] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Rotacija] [bit] NOT NULL , [id] [int] IDENTITY (1, 1) NOT NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[PROstroji] ( [Stroj] [nvarchar] (150) COLLATE Slovenian_CI_AS NOT NULL , [OPIS] [nvarchar] (250) COLLATE Slovenian_CI_AS NULL , [CENA] [money] NULL , [STRM] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Predal] ( [PORT] [nvarchar] (4) COLLATE Slovenian_CI_AS NULL , [KODA] [nvarchar] (10) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Promet] ( [Ident] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [Naziv] [nvarchar] (250) COLLATE Slovenian_CI_AS NULL , [Skl] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Datumdok] [datetime] NULL , [Sifradok] [nvarchar] (3) COLLATE Slovenian_CI_AS NOT NULL , [Stevdok] [int] NOT NULL , [Pozicija] [smallint] NOT NULL , [Kolicina] [money] NULL , [Vrstaprom] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [status] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Opomba] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [Fakcena] [money] NULL , [Dobcena] [money] NULL , [Dobddv] [money] NULL , [dobFaktor] [float] NULL , [Odvisni] [money] NULL , [odvproc] [money] NULL , [Cena] [money] NULL , [Vpcena] [float] NULL , [Mposnova] [float] NULL , [Mpcena] [float] NULL , [Provizija] [money] NULL , [Nalog] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Rabat] [money] NULL , [Rabat1] [money] NULL , [Serstev] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Valcena] [float] NULL , [Em] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [fifocena] [money] NULL , [popcena] [money] NULL , [Mpzalcena] [money] NULL , [Mpniv] [money] NULL , [Kumkol] [money] NULL , [Normpoz] [int] NOT NULL , [Davekproc] [money] NULL , [Datump] [datetime] NULL , [Stevnar] [int] NULL , [Poznar] [smallint] NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Prt] ( [ident] [int] IDENTITY (1, 1) NOT NULL , [IME] [nvarchar] (100) COLLATE Slovenian_CI_AS NULL , [OPIS] [nvarchar] (100) COLLATE Slovenian_CI_AS NULL , [VRSTIC] [smallint] NULL , [KOLON] [smallint] NULL , [KODAVKLOP] [nvarchar] (100) COLLATE Slovenian_CI_AS NULL , [KODAIZKLOP] [nvarchar] (100) COLLATE Slovenian_CI_AS NULL , [IZBRAN] [bit] NOT NULL , [RDECE] [nvarchar] (100) COLLATE Slovenian_CI_AS NULL , [CRNO] [nvarchar] (100) COLLATE Slovenian_CI_AS NULL , [PORT] [nvarchar] (5) COLLATE Slovenian_CI_AS NULL , [SLIPVKLOP] [nvarchar] (100) COLLATE Slovenian_CI_AS NULL , [SLIPIZKLOP] [nvarchar] (100) COLLATE Slovenian_CI_AS NULL , [KOPVKLOP] [nvarchar] (100) COLLATE Slovenian_CI_AS NULL , [KOPIZKLOP] [nvarchar] (100) COLLATE Slovenian_CI_AS NULL , [kodnastran] [nvarchar] (5) COLLATE Slovenian_CI_AS NULL , [dostisk] [bit] NOT NULL , [predal] [nvarchar] (100) COLLATE Slovenian_CI_AS NULL , [klavzula] [nvarchar] (100) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Racdavki] ( [STrac] [nvarchar] (12) COLLATE Slovenian_CI_AS NOT NULL , [Tarifa] [nvarchar] (5) COLLATE Slovenian_CI_AS NOT NULL , [Procent] [money] NULL , [Znesek] [money] NULL , [Osnova] [money] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Racdob] ( [Sifradok] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Stevdok] [int] NULL , [Vr] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Dobavitelj] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL , [Stevrac] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Valznesek] [money] NULL , [Znesek] [money] NULL , [Interna] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL , [Tip] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Osnova] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Valuta] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Tecaj] [money] NULL , [Opis] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[SERTIPI] ( [TIP] [nvarchar] (2) COLLATE Slovenian_CI_AS NOT NULL , [opis] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [zadnji] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [neto] [bit] NOT NULL , [bruto] [bit] NOT NULL , [tdol] [nvarchar] (20) COLLATE Slovenian_CI_AS NULL , [tsir] [nvarchar] (20) COLLATE Slovenian_CI_AS NULL , [tdeb] [nvarchar] (20) COLLATE Slovenian_CI_AS NULL , [defdol] [float] NULL , [defdeb] [float] NULL , [defsir] [float] NULL , [Faktor] [float] NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[SOLA_RAZREDI] ( [Razred] [nvarchar] (6) COLLATE Slovenian_CI_AS NOT NULL , [naziv] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [razrednik] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [ucilnica] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[SOLA_UARTIKLI] ( [Ucenec] [nvarchar] (8) COLLATE Slovenian_CI_AS NOT NULL , [Ident] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [Naziv] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Kolicina] [money] NULL , [Cena] [money] NULL , [Tip] [nvarchar] (10) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[SOLA_UCENCI] ( [Ucenec] [nvarchar] (8) COLLATE Slovenian_CI_AS NOT NULL , [Ime] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Priimek] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [razred] [nvarchar] (6) COLLATE Slovenian_CI_AS NULL , [placnik] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL , [spol] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [rojen] [datetime] NULL , [aktiven] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Stevrac] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [datumrac] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[SOLA_URARTIKLI] ( [Ucenec] [nvarchar] (8) COLLATE Slovenian_CI_AS NOT NULL , [Ident] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [Naziv] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Kolicina] [money] NULL , [Cena] [money] NULL , [Tip] [nvarchar] (10) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Serije] ( [Kljuc] [int] IDENTITY (1, 1) NOT NULL , [Serija] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Skadenca] [datetime] NULL , [lokacija] [nvarchar] (25) COLLATE Slovenian_CI_AS NULL , [Zaloga] [money] NULL , [Ident] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Skl] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Serstev] ( [serstev] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [ident] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [opis] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [kosov] [money] NULL , [dolzina] [float] NULL , [sirina] [float] NULL , [debelina] [float] NULL , [m3] [float] NULL , [tip] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [dolzinaB] [float] NULL , [sirinaB] [float] NULL , [debelinaB] [float] NULL , [M3B] [float] NULL , [Faktor] [float] NULL , [status] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [dokdob] [int] NULL , [dokizd] [int] NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Sifsklad] ( [Skl] [nvarchar] (3) COLLATE Slovenian_CI_AS NOT NULL , [Opis] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [tip] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [tipcene] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [ObolVSP] [nvarchar] (7) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Sklad] ( [Skl] [nvarchar] (3) COLLATE Slovenian_CI_AS NOT NULL , [Ident] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [Kolicina] [money] NULL , [Datumzs] [datetime] NULL , [Cena] [money] NULL , [Vpcena] [money] NULL , [Mposnova] [money] NULL , [Mpcena] [money] NULL , [sprememba] [bit] NOT NULL , [Valcena] [money] NULL , [Minkol] [money] NULL , [Maxkol] [money] NULL , [Optkol] [money] NULL , [letniplan] [money] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Specifikacija] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [Serstev] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Paket] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Opis] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Kosov] [money] NULL , [Dolzina] [float] NULL , [Sirina] [float] NULL , [Debelina] [float] NULL , [dolzinaB] [float] NULL , [sirinaB] [float] NULL , [debelinaB] [float] NULL , [m3] [float] NULL , [m3b] [float] NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TIPNAR] ( [Sifra] [nvarchar] (2) COLLATE Slovenian_CI_AS NOT NULL , [Opis] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [Tip] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Davek] [money] NULL , [Konto] [nvarchar] (7) COLLATE Slovenian_CI_AS NULL , [dok] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [OSNDDV] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Zadnji] [int] NULL , [VPstevilci] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Skl] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [tipkalk] [smallint] NULL , [VPZ] [smallint] NULL , [MPZ] [smallint] NULL , [Serstev] [bit] NOT NULL , [Ratip] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [klavzula] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[TipINV] ( [Sifra] [nvarchar] (2) COLLATE Slovenian_CI_AS NOT NULL , [Opis] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [Tip] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Davek] [money] NULL , [Konto] [nvarchar] (7) COLLATE Slovenian_CI_AS NULL , [dok] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [OSNDDV] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Zadnji] [int] NULL , [VPstevilci] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Skl] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [tipkalk] [smallint] NULL , [VPZ] [smallint] NULL , [MPZ] [smallint] NULL , [Serstev] [bit] NOT NULL , [Ratip] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Tipracuna] ( [Sifra] [nvarchar] (4) COLLATE Slovenian_CI_AS NOT NULL , [Opis] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [Tip] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Davek] [money] NULL , [Konto] [nvarchar] (7) COLLATE Slovenian_CI_AS NULL , [dok] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [OSNDDV] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Zadnji] [int] NULL , [VPstevilci] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [VPZ] [smallint] NULL , [MPZ] [smallint] NULL , [RAZ] [smallint] NULL , [Naslov] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Klavzula] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Dni] [int] NULL , [Skl] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Strm] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[UNstevilke] ( [stevilka] [nvarchar] (50) COLLATE Slovenian_CI_AS NOT NULL , [Opis] [nvarchar] (250) COLLATE Slovenian_CI_AS NULL , [Razred] [nvarchar] (5) COLLATE Slovenian_CI_AS NULL , [Skupina] [nvarchar] (5) COLLATE Slovenian_CI_AS NULL , [Faktor] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Valcenik] ( [Ident] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [Naziv] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Cena] [money] NULL , [Valuta] [nvarchar] (3) COLLATE Slovenian_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[blagajne] ( [blagajna] [nvarchar] (2) COLLATE Slovenian_CI_AS NOT NULL , [vp] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [zadnji] [int] NULL , [klavzula] [nvarchar] (20) COLLATE Slovenian_CI_AS NULL , [skl] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [tiskalnik] [int] NULL , [lcd] [bit] NOT NULL , [dostisk] [bit] NOT NULL , [kodnastran] [nvarchar] (4) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[blobrac] ( [SIFRADOK] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [DATUM] [datetime] NULL , [ZS] [float] NULL , [PROMET] [float] NULL , [GOT] [float] NULL , [NEGOT] [float] NULL , [SALDO] [float] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[davki] ( [Tarifa] [nvarchar] (5) COLLATE Slovenian_CI_AS NOT NULL , [Opis] [nvarchar] (100) COLLATE Slovenian_CI_AS NULL , [Davek] [money] NULL , [Konto] [nvarchar] (7) COLLATE Slovenian_CI_AS NULL , [Aop] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Faktor] [money] NULL , [Trosarina] [money] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[enote] ( [Emer] [nvarchar] (3) COLLATE Slovenian_CI_AS NOT NULL , [Opis] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[katalog] ( [Ident] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [Opis] [ntext] COLLATE Slovenian_CI_AS NULL , [Emer] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Klas] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Koda] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Cena] [money] NULL , [Mpcena] [money] NULL , [Vpcena] [money] NULL , [DDVTAR] [nvarchar] (5) COLLATE Slovenian_CI_AS NULL , [Akcija] [bit] NOT NULL , [Slika] [image] NULL , [Proizvaja] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [Tip] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [Teza] [money] NULL , [Tezab] [money] NULL , [Poreklo] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [Uvoznik] [nvarchar] (60) COLLATE Slovenian_CI_AS NULL , [LetoU] [nvarchar] (4) COLLATE Slovenian_CI_AS NULL , [Naziv] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Provizija] [money] NULL , [Provskup] [nvarchar] (5) COLLATE Slovenian_CI_AS NULL , [Normativ] [bit] NOT NULL , [KSkl] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Flag1] [bit] NOT NULL , [Flag2] [bit] NOT NULL , [Plu] [int] NULL , [Plu1] [int] NULL , [MINKOL] [money] NULL , [Serija] [bit] NOT NULL , [Lit] [money] NULL , [Alkohol] [money] NULL , [Lokacija] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [cartarifa] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [UNstevilka] [nvarchar] (150) COLLATE Slovenian_CI_AS NULL , [Potslike] [nvarchar] (150) COLLATE Slovenian_CI_AS NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[katdvojnik] ( [Ident] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Koda] [nvarchar] (15) COLLATE Slovenian_CI_AS NOT NULL , [Naziv] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[klasif] ( [Klas] [nvarchar] (12) COLLATE Slovenian_CI_AS NOT NULL , [Opis] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [Rabat] [money] NULL , [Rabat1] [money] NULL , [Akcija] [bit] NOT NULL , [ZadnjiID] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [KlasID] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [PRENOSID] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [PRENOSFAKTOR] [money] NULL , [Konto] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[maxdok] ( [Dok] [nvarchar] (3) COLLATE Slovenian_CI_AS NOT NULL , [Zadnji] [int] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[obdobje] ( [datumod] [datetime] NULL , [datumdo] [datetime] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[porabe] ( [Sifra] [nvarchar] (2) COLLATE Slovenian_CI_AS NOT NULL , [Opis] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [Tip] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Davek] [money] NULL , [Konto] [nvarchar] (7) COLLATE Slovenian_CI_AS NULL , [dok] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [OSNDDV] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Zadnji] [int] NULL , [VPstevilci] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Skl] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [tipkalk] [smallint] NULL , [VPZ] [smallint] NULL , [MPZ] [smallint] NULL , [Serstev] [bit] NOT NULL , [Ratip] [nvarchar] (2) COLLATE Slovenian_CI_AS NULL , [Klavzula] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Popust] [money] NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[racpost] ( [Ident] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Naziv] [nvarchar] (250) COLLATE Slovenian_CI_AS NULL , [Kolicina] [money] NULL , [Vpcena] [float] NULL , [Cena] [money] NULL , [Valcena] [float] NULL , [Mposnova] [float] NULL , [Mpcena] [float] NULL , [Rabat] [money] NULL , [Rabat1] [money] NULL , [Tarifa] [nvarchar] (5) COLLATE Slovenian_CI_AS NULL , [Emer] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Tip] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Strm] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Pkonto] [nvarchar] (7) COLLATE Slovenian_CI_AS NULL , [Val] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Tecaj] [money] NULL , [Nalog] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Strac] [nvarchar] (12) COLLATE Slovenian_CI_AS NOT NULL , [Tekst] [ntext] COLLATE Slovenian_CI_AS NULL , [Pozicija] [int] NOT NULL , [Davekproc] [money] NULL , [Stevdob] [int] NULL , [Pozdob] [int] NULL , [Vrkol] [money] NULL , [ZCENA] [money] NULL , [upsize_ts] [timestamp] NULL , [rok] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[racuni] ( [Kljuc] [int] IDENTITY (1, 1) NOT NULL , [Narocilo] [nvarchar] (24) COLLATE Slovenian_CI_AS NULL , [Datnar] [datetime] NULL , [Nacnar] [nvarchar] (15) COLLATE Slovenian_CI_AS NULL , [Nacodpreme] [nvarchar] (255) COLLATE Slovenian_CI_AS NULL , [Referent] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL , [Datumdok] [datetime] NULL , [Dur] [datetime] NULL , [Valuta] [datetime] NULL , [Prockasa] [money] NULL , [Rabat] [money] NULL , [Nabvred] [money] NULL , [Vpvred] [money] NULL , [Mposnova] [money] NULL , [Mpvred] [money] NULL , [Znesek] [money] NULL , [Placano] [money] NULL , [Datumdob] [datetime] NULL , [Status] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Poraba] [nvarchar] (4) COLLATE Slovenian_CI_AS NULL , [Gk] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Konto] [nvarchar] (7) COLLATE Slovenian_CI_AS NULL , [Stm] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Pkonto] [nvarchar] (7) COLLATE Slovenian_CI_AS NULL , [Tip] [nvarchar] (1) COLLATE Slovenian_CI_AS NULL , [Placanoval] [money] NULL , [Znesekval] [money] NULL , [Racun] [ntext] COLLATE Slovenian_CI_AS NULL , [Val] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Tecaj] [money] NULL , [Procprib] [money] NULL , [Pnaslovnik] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL , [Pnaslov] [nvarchar] (250) COLLATE Slovenian_CI_AS NULL , [Pposta] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Pkraj] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [Nalog] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Vrstadok] [nvarchar] (3) COLLATE Slovenian_CI_AS NULL , [Strac] [nvarchar] (12) COLLATE Slovenian_CI_AS NOT NULL , [Nazivkupca] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [Dobavnica] [nvarchar] (255) COLLATE Slovenian_CI_AS NULL , [Kupec] [nvarchar] (8) COLLATE Slovenian_CI_AS NULL , [Klavzula] [ntext] COLLATE Slovenian_CI_AS NULL , [Datumknj] [datetime] NULL , [Zakleni] [bit] NOT NULL , [Naslovnik] [bit] NOT NULL , [Avracun] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Pracun] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Vracun] [nvarchar] (12) COLLATE Slovenian_CI_AS NULL , [Zaokrozi] [smallint] NULL , [KOLI] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [BRUTO] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [NETO] [nvarchar] (30) COLLATE Slovenian_CI_AS NULL , [PARITETA] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [REGSTEV] [nvarchar] (50) COLLATE Slovenian_CI_AS NULL , [DOBAVNICA1] [ntext] COLLATE Slovenian_CI_AS NULL , [UPORABNIK] [nvarchar] (20) COLLATE Slovenian_CI_AS NULL , [upsize_ts] [timestamp] NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO ALTER TABLE [dbo].[Gladok] WITH NOCHECK ADD CONSTRAINT [aaaaaGladok_PK] PRIMARY KEY CLUSTERED ( [Sifradok], [Stevdok] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Nargladok] WITH NOCHECK ADD CONSTRAINT [aaaaaNargladok_PK] PRIMARY KEY CLUSTERED ( [Sifradok], [Stevdok] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Narpromet] WITH NOCHECK ADD CONSTRAINT [aaaaaNarpromet_PK] PRIMARY KEY CLUSTERED ( [Sifradok], [Stevdok], [Pozicija], [Normpoz] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Promet] WITH NOCHECK ADD CONSTRAINT [aaaaaPromet_PK] PRIMARY KEY CLUSTERED ( [Sifradok], [Stevdok], [Pozicija], [Normpoz] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Sklad] WITH NOCHECK ADD CONSTRAINT [aaaaaSklad_PK] PRIMARY KEY CLUSTERED ( [Skl], [Ident] ) ON [PRIMARY] GO ALTER TABLE [dbo].[katalog] WITH NOCHECK ADD CONSTRAINT [aaaaakatalog_PK] PRIMARY KEY CLUSTERED ( [Ident] ) ON [PRIMARY] GO ALTER TABLE [dbo].[racpost] WITH NOCHECK ADD CONSTRAINT [aaaaaracpost_PK] PRIMARY KEY CLUSTERED ( [Strac], [Pozicija] ) ON [PRIMARY] GO ALTER TABLE [dbo].[racuni] WITH NOCHECK ADD CONSTRAINT [aaaaaracuni_PK] PRIMARY KEY CLUSTERED ( [Strac] ) ON [PRIMARY] GO CREATE INDEX [SIFRADOK] ON [dbo].[BLSALDO]([SIFRADOK]) ON [PRIMARY] GO ALTER TABLE [dbo].[BLZSALDO] ADD CONSTRAINT [DF__BLZSALDO__VSOTA__282DF8C2] DEFAULT (0) FOR [VSOTA], CONSTRAINT [aaaaaBLZSALDO_PK] PRIMARY KEY NONCLUSTERED ( [IDENT] ) ON [PRIMARY] GO ALTER TABLE [dbo].[CARtarife] ADD CONSTRAINT [aaaaaCARtarife_PK] PRIMARY KEY NONCLUSTERED ( [Tarifa] ) ON [PRIMARY] GO CREATE INDEX [IDEPA] ON [dbo].[CEKI]([IDEPA]) ON [PRIMARY] GO CREATE INDEX [opis] ON [dbo].[CEKI]([opis]) ON [PRIMARY] GO CREATE INDEX [placila] ON [dbo].[CEKI]([SIFRADOK], [STEVDOK]) ON [PRIMARY] GO ALTER TABLE [dbo].[DNprostoritve] ADD CONSTRAINT [aaaaaDNprostoritve_PK] PRIMARY KEY NONCLUSTERED ( [nalog] ) ON [PRIMARY] GO ALTER TABLE [dbo].[DnproEtikete] ADD CONSTRAINT [DF__DnproEtike__pak1__1FCDBCEB] DEFAULT (0) FOR [pak1], CONSTRAINT [DF__DnproEtike__pak2__20C1E124] DEFAULT (0) FOR [pak2], CONSTRAINT [DF__DnproEtike__pak3__21B6055D] DEFAULT (0) FOR [pak3], CONSTRAINT [aaaaaDnproEtikete_PK] PRIMARY KEY NONCLUSTERED ( [nalog], [Etiketa] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Dnpronormativi] ADD CONSTRAINT [aaaaaDnpronormativi_PK] PRIMARY KEY NONCLUSTERED ( [Nalog], [POZICIJA], [IDARTIKLA] ) ON [PRIMARY] GO CREATE INDEX [IDARTIKLA] ON [dbo].[Dnpronormativi]([IDARTIKLA]) ON [PRIMARY] GO CREATE INDEX [IDPAKETA] ON [dbo].[Dnpronormativi]([IDPAKETA], [IDARTIKLA], [Nalog]) ON [PRIMARY] GO ALTER TABLE [dbo].[Dnprooperacije] ADD CONSTRAINT [aaaaaDnprooperacije_PK] PRIMARY KEY NONCLUSTERED ( [IDPAKETA], [Nalog], [POZICIJA] ) ON [PRIMARY] GO CREATE INDEX [nalog] ON [dbo].[Dnprooperacije]([Nalog], [POZICIJA]) ON [PRIMARY] GO ALTER TABLE [dbo].[Dnpropribitki] ADD CONSTRAINT [aaaaaDnpropribitki_PK] PRIMARY KEY NONCLUSTERED ( [IDPAKETA], [Nalog], [POZICIJA] ) ON [PRIMARY] GO CREATE INDEX [nalog] ON [dbo].[Dnpropribitki]([Nalog], [POZICIJA]) ON [PRIMARY] GO ALTER TABLE [dbo].[EDIEan] ADD CONSTRAINT [aaaaaEDIEan_PK] PRIMARY KEY NONCLUSTERED ( [EAN] ) ON [PRIMARY] GO CREATE INDEX [Ident] ON [dbo].[EDIEan]([Ident]) ON [PRIMARY] GO ALTER TABLE [dbo].[EDIOsnovaN] ADD CONSTRAINT [aaaaaEDIOsnovaN_PK] PRIMARY KEY NONCLUSTERED ( [EAN_LOK_ME], [ST_DOKUMEN] ) ON [PRIMARY] GO ALTER TABLE [dbo].[EDIPostavkeN] ADD CONSTRAINT [DF__EDIPostav__CENA2__060DEAE8] DEFAULT (0) FOR [CENA2_OZN], CONSTRAINT [DF__EDIPostav__CENA2__07020F21] DEFAULT (0) FOR [CENA2_OSN], CONSTRAINT [DF__EDIPostav__CENA3__07F6335A] DEFAULT (0) FOR [CENA3], CONSTRAINT [aaaaaEDIPostavkeN_PK] PRIMARY KEY NONCLUSTERED ( [EAN_LOK_ME], [ST_DOKUMEN], [ZAP_ST_POS] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Embalaze] ADD CONSTRAINT [aaaaaEmbalaze_PK] PRIMARY KEY NONCLUSTERED ( [Sifra] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Gladok] ADD CONSTRAINT [DF__Gladok__Postavke__3E52440B] DEFAULT (0) FOR [Postavke], CONSTRAINT [DF__Gladok__Vstorno__3F466844] DEFAULT (0) FOR [Vstorno], CONSTRAINT [DF__Gladok__Intra_po__403A8C7D] DEFAULT (0) FOR [Intra_porocanje] GO CREATE INDEX [Kljuc] ON [dbo].[Gladok]([Kljuc]) ON [PRIMARY] GO CREATE INDEX [Miza] ON [dbo].[Gladok]([Miza], [Sifradok], [Datumdok], [Status]) ON [PRIMARY] GO ALTER TABLE [dbo].[IDembalaze] ADD CONSTRAINT [aaaaaIDembalaze_PK] PRIMARY KEY NONCLUSTERED ( [Ident], [SifraE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[INTRAglave] ADD CONSTRAINT [aaaaaINTRAglave_PK] PRIMARY KEY NONCLUSTERED ( [EvidencnaStevilka] ) ON [PRIMARY] GO CREATE INDEX [Posilka] ON [dbo].[INTRAglave]([Posilka]) ON [PRIMARY] GO ALTER TABLE [dbo].[INTRAkonst] ADD CONSTRAINT [aaaaaINTRAkonst_PK] PRIMARY KEY NONCLUSTERED ( [Davcna], [OE] ) ON [PRIMARY] GO ALTER TABLE [dbo].[INTRApostavke] ADD CONSTRAINT [DF__INTRApost__Faktu__108B795B] DEFAULT (0) FOR [FakturnaVrednost], CONSTRAINT [DF__INTRApost__Stati__117F9D94] DEFAULT (0) FOR [StatisticnaVr], CONSTRAINT [aaaaaINTRApostavke_PK] PRIMARY KEY NONCLUSTERED ( [EvidencnaStevilka], [ZaporednaStevilkaPostavke] ) ON [PRIMARY] GO CREATE INDEX [Tarifa] ON [dbo].[INTRApostavke]([EvidencnaStevilka], [Tarifa]) ON [PRIMARY] GO ALTER TABLE [dbo].[INTRAvodilni] ADD CONSTRAINT [aaaaaINTRAvodilni_PK] PRIMARY KEY NONCLUSTERED ( [Leto], [ZaporednaPosilka] ) ON [PRIMARY] GO ALTER TABLE [dbo].[IntraDrzave] ADD CONSTRAINT [aaaaaIntraDrzave_PK] PRIMARY KEY NONCLUSTERED ( [Oznaka] ) ON [PRIMARY] GO ALTER TABLE [dbo].[IntraLega] ADD CONSTRAINT [aaaaaIntraLega_PK] PRIMARY KEY NONCLUSTERED ( [Oznaka] ) ON [PRIMARY] GO ALTER TABLE [dbo].[IntraPogoji] ADD CONSTRAINT [aaaaaIntraPogoji_PK] PRIMARY KEY NONCLUSTERED ( [Oznaka] ) ON [PRIMARY] GO ALTER TABLE [dbo].[IntraTransport] ADD CONSTRAINT [aaaaaIntraTransport_PK] PRIMARY KEY NONCLUSTERED ( [Oznaka] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Kupcenik] ADD CONSTRAINT [DF__Kupcenik__Valcen__5441852A] DEFAULT (0) FOR [Valcena], CONSTRAINT [aaaaaKupcenik_PK] PRIMARY KEY NONCLUSTERED ( [Idepa], [Ident] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Kupstrm] ADD CONSTRAINT [DF__Kupstrm__Valcena__5FB337D6] DEFAULT (0) FOR [Valcena], CONSTRAINT [aaaaaKupstrm_PK] PRIMARY KEY NONCLUSTERED ( [Idepa], [Ident], [Prevoznik] ) ON [PRIMARY] GO CREATE UNIQUE INDEX [ident] ON [dbo].[LCD]([ident]) ON [PRIMARY] GO ALTER TABLE [dbo].[Lokacije] ADD CONSTRAINT [aaaaaLokacije_PK] PRIMARY KEY NONCLUSTERED ( [Lokacija] ) ON [PRIMARY] GO ALTER TABLE [dbo].[NORMATIVI] ADD CONSTRAINT [aaaaaNORMATIVI_PK] PRIMARY KEY NONCLUSTERED ( [kljuc] ) ON [PRIMARY] GO CREATE INDEX [IDARTIKLA] ON [dbo].[NORMATIVI]([IDARTIKLA]) ON [PRIMARY] GO CREATE INDEX [IDPAKETA] ON [dbo].[NORMATIVI]([IDPAKETA]) ON [PRIMARY] GO ALTER TABLE [dbo].[Nabave] ADD CONSTRAINT [DF__Nabave__Tip__07C12930] DEFAULT ('VP') FOR [Tip], CONSTRAINT [DF__Nabave__Tipkalk__08B54D69] DEFAULT (4) FOR [Tipkalk], CONSTRAINT [DF__Nabave__VPZ__09A971A2] DEFAULT (2) FOR [VPZ], CONSTRAINT [DF__Nabave__MPZ__0A9D95DB] DEFAULT (2) FOR [MPZ], CONSTRAINT [DF__Nabave__Serstev__0B91BA14] DEFAULT (0) FOR [Serstev], CONSTRAINT [aaaaaNabave_PK] PRIMARY KEY NONCLUSTERED ( [Sifra] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Nargladok] ADD CONSTRAINT [DF__Nargladok__Tecaj__1BC821DD] DEFAULT (0) FOR [Tecaj], CONSTRAINT [DF__Nargladok__Vredn__1CBC4616] DEFAULT (0) FOR [VrednostN], CONSTRAINT [DF__Nargladok__Vredn__1DB06A4F] DEFAULT (0) FOR [Vrednostvp], CONSTRAINT [DF__Nargladok__Vredn__1EA48E88] DEFAULT (0) FOR [VrednostMP], CONSTRAINT [DF__Nargladok__Posta__1F98B2C1] DEFAULT (0) FOR [Postavke], CONSTRAINT [DF__Nargladok__Vstor__208CD6FA] DEFAULT (0) FOR [Vstorno], CONSTRAINT [DF__Nargladok__Miza__2180FB33] DEFAULT (0) FOR [Miza] GO CREATE INDEX [Kljuc] ON [dbo].[Nargladok]([Kljuc]) ON [PRIMARY] GO CREATE INDEX [Miza] ON [dbo].[Nargladok]([Miza], [Sifradok], [Datumdok], [Status]) ON [PRIMARY] GO ALTER TABLE [dbo].[Narpromet] ADD CONSTRAINT [DF__Narpromet__Kolic__55009F39] DEFAULT (0) FOR [Kolicina], CONSTRAINT [DF__Narpromet__statu__55F4C372] DEFAULT ('S') FOR [status], CONSTRAINT [DF__Narpromet__Fakce__56E8E7AB] DEFAULT (0) FOR [Fakcena], CONSTRAINT [DF__Narpromet__Normp__57DD0BE4] DEFAULT (0) FOR [Normpoz], CONSTRAINT [DF__Narpromet__Davek__58D1301D] DEFAULT (0) FOR [Davekproc] GO CREATE INDEX [Datumdok] ON [dbo].[Narpromet]([Datumdok], [Skl], [Ident]) ON [PRIMARY] GO CREATE INDEX [Ident] ON [dbo].[Narpromet]([Skl], [Ident], [Datumdok], [Vrstaprom] DESC ) ON [PRIMARY] GO ALTER TABLE [dbo].[OpomnikiDEF] ADD CONSTRAINT [aaaaaOpomnikiDEF_PK] PRIMARY KEY NONCLUSTERED ( [kljuc] ) ON [PRIMARY] GO CREATE INDEX [Ident] ON [dbo].[OpomnikiDEF]([Ident]) ON [PRIMARY] GO CREATE INDEX [Idepa] ON [dbo].[OpomnikiDEF]([Idepa]) ON [PRIMARY] GO ALTER TABLE [dbo].[OpomnikiP] ADD CONSTRAINT [aaaaaOpomnikiP_PK] PRIMARY KEY NONCLUSTERED ( [kljuc], [racun] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Optima] ADD CONSTRAINT [DF__Optima__Modem__571DF1D5] DEFAULT (0) FOR [Modem], CONSTRAINT [DF__Optima__Zadnja__5812160E] DEFAULT (0) FOR [Zadnja], CONSTRAINT [aaaaaOptima_PK] PRIMARY KEY NONCLUSTERED ( [Blagajna] ) ON [PRIMARY] GO CREATE INDEX [IDEPA] ON [dbo].[PLACILA]([IDEPA]) ON [PRIMARY] GO ALTER TABLE [dbo].[PRODM] ADD CONSTRAINT [aaaaaPRODM_PK] PRIMARY KEY NONCLUSTERED ( [DM] ) ON [PRIMARY] GO ALTER TABLE [dbo].[PROEtikete] ADD CONSTRAINT [aaaaaPROEtikete_PK] PRIMARY KEY NONCLUSTERED ( [Etiketa] ) ON [PRIMARY] GO ALTER TABLE [dbo].[PRONORMATIVI] ADD CONSTRAINT [aaaaaPRONORMATIVI_PK] PRIMARY KEY NONCLUSTERED ( [IDPAKETA], [IDARTIKLA], [POZICIJA] ) ON [PRIMARY] GO CREATE INDEX [IDARTIKLA] ON [dbo].[PRONORMATIVI]([IDARTIKLA]) ON [PRIMARY] GO ALTER TABLE [dbo].[PROOPERACIJE] ADD CONSTRAINT [aaaaaPROOPERACIJE_PK] PRIMARY KEY NONCLUSTERED ( [IDPAKETA], [POZICIJA], [OP] ) ON [PRIMARY] GO ALTER TABLE [dbo].[PROPRIBITKI] ADD CONSTRAINT [aaaaaPROPRIBITKI_PK] PRIMARY KEY NONCLUSTERED ( [IDPAKETA], [TIP], [POZICIJA] ) ON [PRIMARY] GO ALTER TABLE [dbo].[PROSIFOP] ADD CONSTRAINT [aaaaaPROSIFOP_PK] PRIMARY KEY NONCLUSTERED ( [OP] ) ON [PRIMARY] GO ALTER TABLE [dbo].[PROSIFPRIB] ADD CONSTRAINT [aaaaaPROSIFPRIB_PK] PRIMARY KEY NONCLUSTERED ( [SIFRA] ) ON [PRIMARY] GO ALTER TABLE [dbo].[PROTIPNAL] ADD CONSTRAINT [DF__PROTIPNAL__tipka__32AB8735] DEFAULT (1) FOR [tipkalk], CONSTRAINT [DF__PROTIPNAL__VPZ__339FAB6E] DEFAULT (2) FOR [VPZ], CONSTRAINT [DF__PROTIPNAL__MPZ__3493CFA7] DEFAULT (2) FOR [MPZ], CONSTRAINT [DF__PROTIPNAL__Serst__3587F3E0] DEFAULT (0) FOR [Serstev], CONSTRAINT [aaaaaPROTIPNAL_PK] PRIMARY KEY NONCLUSTERED ( [Sifra] ) ON [PRIMARY] GO ALTER TABLE [dbo].[PROstance] ADD CONSTRAINT [DF__PROstance__Rotac__41EDCAC5] DEFAULT (0) FOR [Rotacija], CONSTRAINT [aaaaaPROstance_PK] PRIMARY KEY NONCLUSTERED ( [IDstance] ) ON [PRIMARY] GO ALTER TABLE [dbo].[PROstroji] ADD CONSTRAINT [aaaaaPROstroji_PK] PRIMARY KEY NONCLUSTERED ( [Stroj] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Promet] ADD CONSTRAINT [DF__Promet__Kolicina__35BCFE0A] DEFAULT (0) FOR [Kolicina], CONSTRAINT [DF__Promet__status__36B12243] DEFAULT ('S') FOR [status], CONSTRAINT [DF__Promet__Fakcena__37A5467C] DEFAULT (0) FOR [Fakcena], CONSTRAINT [DF__Promet__Normpoz__38996AB5] DEFAULT (0) FOR [Normpoz], CONSTRAINT [DF__Promet__Davekpro__398D8EEE] DEFAULT (0) FOR [Davekproc] GO CREATE INDEX [Datumdok] ON [dbo].[Promet]([Datumdok], [Skl], [Ident]) ON [PRIMARY] GO CREATE INDEX [Ident] ON [dbo].[Promet]([Skl], [Ident], [Datumdok], [Vrstaprom] DESC ) ON [PRIMARY] GO ALTER TABLE [dbo].[Prt] ADD CONSTRAINT [DF__Prt__IZBRAN__17F790F9] DEFAULT (0) FOR [IZBRAN], CONSTRAINT [DF__Prt__dostisk__18EBB532] DEFAULT (0) FOR [dostisk] GO CREATE UNIQUE INDEX [ident] ON [dbo].[Prt]([ident]) ON [PRIMARY] GO ALTER TABLE [dbo].[Racdavki] ADD CONSTRAINT [aaaaaRacdavki_PK] PRIMARY KEY NONCLUSTERED ( [STrac], [Tarifa] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Racdob] ADD CONSTRAINT [DF__Racdob__Znesek__32E0915F] DEFAULT (0) FOR [Znesek] GO CREATE INDEX [Stevdok] ON [dbo].[Racdob]([Sifradok], [Stevdok]) ON [PRIMARY] GO ALTER TABLE [dbo].[SERTIPI] ADD CONSTRAINT [DF__SERTIPI__neto__7D439ABD] DEFAULT (1) FOR [neto], CONSTRAINT [DF__SERTIPI__bruto__7E37BEF6] DEFAULT (0) FOR [bruto], CONSTRAINT [DF__SERTIPI__tdol__7F2BE32F] DEFAULT ('Dol?ina:') FOR [tdol], CONSTRAINT [DF__SERTIPI__tsir__00200768] DEFAULT ('?irina:') FOR [tsir], CONSTRAINT [DF__SERTIPI__tdeb__01142BA1] DEFAULT ('Debelina:') FOR [tdeb], CONSTRAINT [DF__SERTIPI__defdol__02084FDA] DEFAULT (0) FOR [defdol], CONSTRAINT [DF__SERTIPI__defdeb__02FC7413] DEFAULT (0) FOR [defdeb], CONSTRAINT [DF__SERTIPI__defsir__03F0984C] DEFAULT (0) FOR [defsir], CONSTRAINT [DF__SERTIPI__Faktor__04E4BC85] DEFAULT (1) FOR [Faktor], CONSTRAINT [aaaaaSERTIPI_PK] PRIMARY KEY NONCLUSTERED ( [TIP] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SOLA_RAZREDI] ADD CONSTRAINT [aaaaaSOLA_RAZREDI_PK] PRIMARY KEY NONCLUSTERED ( [Razred] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SOLA_UARTIKLI] ADD CONSTRAINT [aaaaaSOLA_UARTIKLI_PK] PRIMARY KEY NONCLUSTERED ( [Ucenec], [Ident] ) ON [PRIMARY] GO ALTER TABLE [dbo].[SOLA_UCENCI] ADD CONSTRAINT [aaaaaSOLA_UCENCI_PK] PRIMARY KEY NONCLUSTERED ( [Ucenec] ) ON [PRIMARY] GO CREATE INDEX [razred] ON [dbo].[SOLA_UCENCI]([razred], [Ucenec]) ON [PRIMARY] GO ALTER TABLE [dbo].[SOLA_URARTIKLI] ADD CONSTRAINT [aaaaaSOLA_URARTIKLI_PK] PRIMARY KEY NONCLUSTERED ( [Ucenec], [Ident] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Serije] ADD CONSTRAINT [DF__Serije__Zaloga__5AEE82B9] DEFAULT (0) FOR [Zaloga], CONSTRAINT [aaaaaSerije_PK] PRIMARY KEY NONCLUSTERED ( [Kljuc] ) ON [PRIMARY] GO CREATE INDEX [Serija] ON [dbo].[Serije]([Serija], [Ident], [Skl]) ON [PRIMARY] GO CREATE INDEX [skadenca] ON [dbo].[Serije]([Ident], [Skadenca], [Skl]) ON [PRIMARY] GO ALTER TABLE [dbo].[Serstev] ADD CONSTRAINT [DF__Serstev__kosov__619B8048] DEFAULT (1) FOR [kosov], CONSTRAINT [DF__Serstev__dolzina__628FA481] DEFAULT (0) FOR [dolzina], CONSTRAINT [DF__Serstev__sirina__6383C8BA] DEFAULT (0) FOR [sirina], CONSTRAINT [DF__Serstev__debelin__6477ECF3] DEFAULT (0) FOR [debelina], CONSTRAINT [DF__Serstev__m3__656C112C] DEFAULT (0) FOR [m3], CONSTRAINT [DF__Serstev__dolzina__66603565] DEFAULT (0) FOR [dolzinaB], CONSTRAINT [DF__Serstev__sirinaB__6754599E] DEFAULT (0) FOR [sirinaB], CONSTRAINT [DF__Serstev__debelin__68487DD7] DEFAULT (0) FOR [debelinaB], CONSTRAINT [DF__Serstev__M3B__693CA210] DEFAULT (0) FOR [M3B], CONSTRAINT [DF__Serstev__Faktor__6A30C649] DEFAULT (1) FOR [Faktor], CONSTRAINT [DF__Serstev__dokdob__6B24EA82] DEFAULT (0) FOR [dokdob], CONSTRAINT [DF__Serstev__dokizd__6C190EBB] DEFAULT (0) FOR [dokizd] GO ALTER TABLE [dbo].[Sifsklad] ADD CONSTRAINT [aaaaaSifsklad_PK] PRIMARY KEY NONCLUSTERED ( [Skl] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Sklad] ADD CONSTRAINT [DF__Sklad__sprememba__30F848ED] DEFAULT (0) FOR [sprememba] GO ALTER TABLE [dbo].[Specifikacija] ADD CONSTRAINT [DF__Specifika__Kosov__4A8310C6] DEFAULT (0) FOR [Kosov], CONSTRAINT [DF__Specifika__Dolzi__4B7734FF] DEFAULT (1) FOR [Dolzina], CONSTRAINT [DF__Specifika__Sirin__4C6B5938] DEFAULT (1) FOR [Sirina], CONSTRAINT [DF__Specifika__Debel__4D5F7D71] DEFAULT (1) FOR [Debelina], CONSTRAINT [DF__Specifika__dolzi__4E53A1AA] DEFAULT (0) FOR [dolzinaB], CONSTRAINT [DF__Specifika__sirin__4F47C5E3] DEFAULT (0) FOR [sirinaB], CONSTRAINT [DF__Specifika__debel__503BEA1C] DEFAULT (0) FOR [debelinaB], CONSTRAINT [DF__Specifikacij__m3__51300E55] DEFAULT (0) FOR [m3], CONSTRAINT [DF__Specifikaci__m3b__5224328E] DEFAULT (0) FOR [m3b], CONSTRAINT [aaaaaSpecifikacija_PK] PRIMARY KEY NONCLUSTERED ( [ID] ) ON [PRIMARY] GO CREATE INDEX [serstev] ON [dbo].[Specifikacija]([Serstev], [Paket]) ON [PRIMARY] GO ALTER TABLE [dbo].[TIPNAR] ADD CONSTRAINT [DF__TIPNAR__Tip__7F60ED59] DEFAULT ('DOB') FOR [Tip], CONSTRAINT [DF__TIPNAR__tipkalk__00551192] DEFAULT (1) FOR [tipkalk], CONSTRAINT [DF__TIPNAR__VPZ__014935CB] DEFAULT (2) FOR [VPZ], CONSTRAINT [DF__TIPNAR__MPZ__023D5A04] DEFAULT (2) FOR [MPZ], CONSTRAINT [DF__TIPNAR__Serstev__03317E3D] DEFAULT (0) FOR [Serstev], CONSTRAINT [aaaaaTIPNAR_PK] PRIMARY KEY NONCLUSTERED ( [Sifra] ) ON [PRIMARY] GO ALTER TABLE [dbo].[TipINV] ADD CONSTRAINT [DF__TipINV__Tip__690797E6] DEFAULT ('VP') FOR [Tip], CONSTRAINT [DF__TipINV__tipkalk__69FBBC1F] DEFAULT (1) FOR [tipkalk], CONSTRAINT [DF__TipINV__VPZ__6AEFE058] DEFAULT (2) FOR [VPZ], CONSTRAINT [DF__TipINV__MPZ__6BE40491] DEFAULT (2) FOR [MPZ], CONSTRAINT [DF__TipINV__Serstev__6CD828CA] DEFAULT (0) FOR [Serstev], CONSTRAINT [aaaaaTipINV_PK] PRIMARY KEY NONCLUSTERED ( [Sifra] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Tipracuna] ADD CONSTRAINT [DF__Tipracuna__Davek__145C0A3F] DEFAULT (1) FOR [Davek], CONSTRAINT [DF__Tipracuna__dok__15502E78] DEFAULT ('RAC') FOR [dok], CONSTRAINT [DF__Tipracuna__VPZ__164452B1] DEFAULT (2) FOR [VPZ], CONSTRAINT [DF__Tipracuna__MPZ__173876EA] DEFAULT (2) FOR [MPZ], CONSTRAINT [DF__Tipracuna__RAZ__182C9B23] DEFAULT (2) FOR [RAZ], CONSTRAINT [DF__Tipracuna__Naslo__1920BF5C] DEFAULT ('Ra?un') FOR [Naslov], CONSTRAINT [aaaaaTipracuna_PK] PRIMARY KEY NONCLUSTERED ( [Sifra] ) ON [PRIMARY] GO ALTER TABLE [dbo].[UNstevilke] ADD CONSTRAINT [aaaaaUNstevilke_PK] PRIMARY KEY NONCLUSTERED ( [stevilka] ) ON [PRIMARY] GO ALTER TABLE [dbo].[Valcenik] ADD CONSTRAINT [aaaaaValcenik_PK] PRIMARY KEY NONCLUSTERED ( [Valuta], [Ident] ) ON [PRIMARY] GO ALTER TABLE [dbo].[blagajne] ADD CONSTRAINT [DF__blagajne__zadnji__6166761E] DEFAULT (0) FOR [zadnji], CONSTRAINT [DF__blagajne__tiskal__625A9A57] DEFAULT (0) FOR [tiskalnik], CONSTRAINT [DF__blagajne__lcd__634EBE90] DEFAULT (0) FOR [lcd], CONSTRAINT [DF__blagajne__dostis__6442E2C9] DEFAULT (0) FOR [dostisk], CONSTRAINT [aaaaablagajne_PK] PRIMARY KEY NONCLUSTERED ( [blagajna] ) ON [PRIMARY] GO ALTER TABLE [dbo].[davki] ADD CONSTRAINT [aaaaadavki_PK] PRIMARY KEY NONCLUSTERED ( [Tarifa] ) ON [PRIMARY] GO ALTER TABLE [dbo].[enote] ADD CONSTRAINT [aaaaaenote_PK] PRIMARY KEY NONCLUSTERED ( [Emer] ) ON [PRIMARY] GO ALTER TABLE [dbo].[katalog] ADD CONSTRAINT [DF__katalog__Akcija__2A4B4B5E] DEFAULT (0) FOR [Akcija], CONSTRAINT [DF__katalog__Normati__2B3F6F97] DEFAULT (0) FOR [Normativ], CONSTRAINT [DF__katalog__Flag1__2C3393D0] DEFAULT (0) FOR [Flag1], CONSTRAINT [DF__katalog__Flag2__2D27B809] DEFAULT (0) FOR [Flag2], CONSTRAINT [DF__katalog__Serija__2E1BDC42] DEFAULT (0) FOR [Serija] GO CREATE INDEX [Klas] ON [dbo].[katalog]([Klas], [Naziv]) ON [PRIMARY] GO CREATE INDEX [Naziv] ON [dbo].[katalog]([Naziv]) ON [PRIMARY] GO CREATE INDEX [Plu] ON [dbo].[katalog]([Plu]) ON [PRIMARY] GO CREATE INDEX [Plu1] ON [dbo].[katalog]([Plu1]) ON [PRIMARY] GO CREATE INDEX [sifdob] ON [dbo].[katalog]([Koda]) ON [PRIMARY] GO ALTER TABLE [dbo].[katdvojnik] ADD CONSTRAINT [aaaaakatdvojnik_PK] PRIMARY KEY NONCLUSTERED ( [Koda] ) ON [PRIMARY] GO ALTER TABLE [dbo].[klasif] ADD CONSTRAINT [DF__klasif__Akcija__4CA06362] DEFAULT (0) FOR [Akcija], CONSTRAINT [aaaaaklasif_PK] PRIMARY KEY NONCLUSTERED ( [Klas] ) ON [PRIMARY] GO CREATE INDEX [IDPRENOS] ON [dbo].[klasif]([PRENOSID]) ON [PRIMARY] GO CREATE INDEX [KlasID] ON [dbo].[klasif]([KlasID]) ON [PRIMARY] GO CREATE INDEX [ZadnjiID] ON [dbo].[klasif]([ZadnjiID]) ON [PRIMARY] GO ALTER TABLE [dbo].[maxdok] ADD CONSTRAINT [aaaaamaxdok_PK] PRIMARY KEY NONCLUSTERED ( [Dok] ) ON [PRIMARY] GO ALTER TABLE [dbo].[porabe] ADD CONSTRAINT [DF__porabe__Tip__74AE54BC] DEFAULT ('VP') FOR [Tip], CONSTRAINT [DF__porabe__tipkalk__75A278F5] DEFAULT (1) FOR [tipkalk], CONSTRAINT [DF__porabe__VPZ__76969D2E] DEFAULT (2) FOR [VPZ], CONSTRAINT [DF__porabe__MPZ__778AC167] DEFAULT (2) FOR [MPZ], CONSTRAINT [DF__porabe__Serstev__787EE5A0] DEFAULT (0) FOR [Serstev], CONSTRAINT [aaaaaporabe_PK] PRIMARY KEY NONCLUSTERED ( [Sifra] ) ON [PRIMARY] GO CREATE INDEX [Stevdob] ON [dbo].[racpost]([Stevdob], [Pozdob]) ON [PRIMARY] GO ALTER TABLE [dbo].[racuni] ADD CONSTRAINT [DF__racuni__Nabvred__4316F928] DEFAULT (0) FOR [Nabvred], CONSTRAINT [DF__racuni__Vpvred__440B1D61] DEFAULT (0) FOR [Vpvred], CONSTRAINT [DF__racuni__Mposnova__44FF419A] DEFAULT (0) FOR [Mposnova], CONSTRAINT [DF__racuni__Mpvred__45F365D3] DEFAULT (0) FOR [Mpvred], CONSTRAINT [DF__racuni__Zakleni__46E78A0C] DEFAULT (0) FOR [Zakleni], CONSTRAINT [DF__racuni__Naslovni__47DBAE45] DEFAULT (0) FOR [Naslovnik] GO CREATE UNIQUE INDEX [Kljuc] ON [dbo].[racuni]([Kljuc]) ON [PRIMARY] GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE VIEW dbo.Partner AS SELECT * FROM PARTNER08.dbo.partner GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO