Tofu - Baza

Create Declare Cursor Hungarian
Select Update Insert Fancy
Tabela		Suffix
Select	All, None, Invert


Naziv	Tip	Null	Privzeto	Opis
RESKONTNI_PREDPISI	char(1)	1	('D')
RESKOLEDAR	char(1)	1	('D')
DELAVCI	char(1)	1	('0')
RESNAZIV1	char(30)	1	('')
RESZAP1	smallint	1	(0)
RESNAZIV2	char(30)	1	('')
RESZAP2	smallint	1	(0)
RESNAZIV3	char(30)	1	('')
RESZAP3	smallint	1	(0)
RESNAZIV4	char(30)	1	('')
RESZAP4	smallint	1	(0)
RESNAZIV5	char(30)	1	('')
RESZAP5	smallint	1	(0)
RESNAZIV6	char(30)	1	('')
RESZAP6	smallint	1	(0)
RESNAZIV7	char(30)	1	('')
RESZAP7	smallint	1	(0)
RESNAZIV8	char(30)	1	('')
RESZAP8	smallint	1	(0)
TEHNAZIV1	char(30)	1	('')
TEHZAP1	smallint	1	(0)
TEHNAZIV2	char(30)	1	('')
TEHZAP2	smallint	1	(0)
TEHNAZIV3	char(30)	1	('')
TEHZAP3	smallint	1	(0)
TEHNAZIV4	char(30)	1	('')
TEHZAP4	smallint	1	(0)
TEHNAZIV5	char(30)	1	('')
TEHZAP5	smallint	1	(0)
TEHNAZIV6	char(30)	1	('')
TEHZAP6	smallint	1	(0)
TEHNAZIV7	char(30)	1	('')
TEHZAP7	smallint	1	(0)
TEHNAZIV8	char(30)	1	('')
TEHZAP8	smallint	1	(0)
TEHMODPADEK	char(30)	1	('')
TEHNODPADEK	char(30)	1	('Odpadek')
TEHPODPADEK	char(30)	1	('')
TEHNODGOREK	char(30)	1	('Odgorek')
TEHPODGOREK	char(30)	1	('')
TEHODPADEK	char(1)	1	('N')
TEHODGOREK	char(1)	1	('N')
TEHKONTNI_PREDPISI	char(1)	1	('N')
TEHBRUTONETO	char(1)	1	('N')
TEHAVTOMATSKOSTEVILCENJE	char(1)	1	('D')
TEHKORAK	smallint	1	(5)
TEHODPODGDELKOLICINE	char(1)	1	('N')
KPNAZIV1	char(30)	1	('')
KPZAP1	smallint	1	(0)
KPNAZIV2	char(30)	1	('')
KPZAP2	smallint	1	(0)
KPNAZIV3	char(30)	1	('')
KPZAP3	smallint	1	(0)
KPNAZIV4	char(30)	1	('')
KPZAP4	smallint	1	(0)
KPNAZIV5	char(30)	1	('')
KPZAP5	smallint	1	(0)
KPNAZIV6	char(30)	1	('')
KPZAP6	smallint	1	(0)
KPNAZIV7	char(30)	1	('')
KPZAP7	smallint	1	(0)
KOLAUTOGEN	char(1)	1	('D')
KOLDELOVNESOBOTE	char(1)	1	('N')
KOLSIZMENE	smallint	1	(0)
KOLSURE	smallint	1	(0)
KOLIZMENE	smallint	1	(0)
KOLURE	smallint	1	(0)
TERMINIRANJE	char(1)	1	('N')
USERSPRE	char(2)	1	('')
DATUMSPRE	datetime	1	(getdate())
OBDTERMINI	char(1)	1	('N')
OBDDOBRISLABI	char(1)	1	('N')
OBDZASTOJ	char(1)	1	('N')
OBDVRSTAZASL	char(1)	1	('N')
OBDTIPCASA	char(1)	1	('N')
KOSRESURS	char(1)	1	('D')
KOSKOLICINA	char(1)	1	('N')
KOSSTEVILO	char(1)	1	('N')
KOSVZDODATEK	char(3)	1	('')
USERZAP	char(2)	1	('')
DATUMZAP	datetime	1	(getdate())
OBDCASUREMINSEK	char(1)	1	('N')
OBDZADNJIDN	char(1)	1	('N')
OBDDNPOTRDIIZDAJE	char(1)	1	('N')
OBDDNPOTRDIPREVZEME	char(1)	1	('N')
OBDTPZTN	char(1)	1	('N')
OBDPRIZNANICAS	char(1)	1	('N')
OBDPRIZNANIKOS	char(1)	1	('N')
OBDDELOVREDNOST	char(1)	1	('N')
RESSTROSEKTPZ1	char(30)	1	('')
RESSTROSEKTPZ2	char(30)	1	('')
RESSTROSEKTPZ3	char(30)	1	('')
RESSTROSEKTPZ4	char(30)	1	('')
RESSTROSEKTPZ5	char(30)	1	('')
RESSTROSEKTN1	char(30)	1	('')
RESSTROSEKTN2	char(30)	1	('')
RESSTROSEKTN3	char(30)	1	('')
RESSTROSEKTN4	char(30)	1	('')
RESSTROSEKTN5	char(30)	1	('')
RESSTROSEKTPZ1ZAP	tinyint	1	(0)
RESSTROSEKTPZ2ZAP	tinyint	1	(0)
RESSTROSEKTPZ3ZAP	tinyint	1	(0)
RESSTROSEKTPZ4ZAP	tinyint	1	(0)
RESSTROSEKTPZ5ZAP	tinyint	1	(0)
RESSTROSEKTN1ZAP	tinyint	1	(0)
RESSTROSEKTN2ZAP	tinyint	1	(0)
RESSTROSEKTN3ZAP	tinyint	1	(0)
RESSTROSEKTN4ZAP	tinyint	1	(0)
RESSTROSEKTN5ZAP	tinyint	1	(0)
TEHMSMATERIAL	char(1)	1	('D')
TEHMSOPERACIJA	char(1)	1	('D')
PROPOSLDOGDNMS	char(1)	1	('N')
RESSQL1	varchar(255)	1	('')
RESSQL2	varchar(255)	1	('')
RESSQL3	varchar(255)	1	('')
RESSQL4	varchar(255)	1	('')
RESSQL5	varchar(255)	1	('')
RESSQL6	varchar(255)	1	('')
RESSQL7	varchar(255)	1	('')
TEHSQL1	varchar(255)	1	('')
TEHSQL2	varchar(255)	1	('')
TEHSQL3	varchar(255)	1	('')
TEHSQL4	varchar(255)	1	('')
TEHSQL5	varchar(255)	1	('')
TEHSQL6	varchar(255)	1	('')
TEHSQL7	varchar(255)	1	('')
KPSQL1	varchar(255)	1	('')
KPSQL2	varchar(255)	1	('')
KPSQL3	varchar(255)	1	('')
KPSQL4	varchar(255)	1	('')
KPSQL5	varchar(255)	1	('')
KPSQL6	varchar(255)	1	('')
KOSNOMATE	char(1)	1	('0')
KOSNOOPER	char(1)	1	('0')
KOSEMCAS	char(1)	1	('H')
KOSEMSEK	char(3)	1	('')
KOSEMMIN	char(3)	1	('')
KOSEMURA	char(3)	1	('')
KOSEMDAN	char(3)	1	('')
KOSEMTED	char(3)	1	('')
KOSEMMES	char(3)	1	('')
PROFANTOM	char(1)	1	('N')
RESKOLEDAROSNOVA	char(3)	1	('')
RESDELODO	smalldatetime	1
RESDELOOD	smalldatetime	1
RESKAPSTDELAVCEV	bit	1	(1)
RESPLACRAZR	bit	1	(1)
TERDNOPERCAS	bit	1	(0)
KOSDECMESTIZDELAVA	tinyint	1	(2)
KOSDECMESTORODJA	tinyint	1	(2)
KOSDECMESTKOLICINA	tinyint	1	(4)
TEHSTRUKTURATEST	bit	1	(1)
KOSOPTIMALNAKOLICINA	decimal(19,6)	1	(1)
TERKOLEDARNABAVE	char(3)	1	('')
TERKOLEDARPROIZVODNJE	char(3)	1	('')
TERROKDOBAVE	smallint	1	(0)
TERNACIN	char(1)	1	('D')
TERNACINFORMULA	char(3)	1	('')
OBDDECMESTIZD	tinyint	1	(2)
OBDDECMESTMATE	tinyint	1	(2)
OBDDECMESTDELO	tinyint	1	(2)
TERROKZDRUZIZD	smallint	1	(0)
TERROKZDRUZMATE	smallint	1	(0)
PLANDECMESTMATPLAN	smallint	1	(2)
OBDAKTIZPSAM	bit	1	(1)
OBDAZUKOLSAM	bit	1	(0)
OBDAZUCASSAM	bit	1	(0)
TERPRIMTERM	bit	1	(1)
TERUPOSTTPZ	bit	1	(1)
PLANNAROCDOBKRE	char(1)	1	('1')
KRMIROBOTPREFIX	char(30)	1	('')
PLANMAT2NIVO1	bit	1	(1)
KOSPODNIVO	bit	1	(1)
OBDSTATUSO2RIZP	bit	1	(1)
KOSMSAKTPOZ	bit	1	(0)
OBDSTATDN2RAZPDOKU	bit	1	(0)
PLANMAT2SAMZAPOP	bit	1	(0)
OBDAZUCASSAMCAS	bit	1	(0)
OBDTERMINIDATUM	char(1)	1	('N')
KOSALTERP	bit	1	(0)
PSCOOPUM	bit	1	(0)
OBDDELAVEC	char(30)	1	('')
KOSMATDEF	char(1)	1	('N')
KOSOPERDEF	char(1)	1	('N')
OBDDNREZERVACIJE	bit	1	(0)
OBDVMSSTROS	char(3)	1	('')
PSEXCLUSIVE	bit	1	(0)
OBDVRSTAZASLDEF	char(3)	1	('')
OBDAZUDNKOLSAM	bit	1	(0)
OBDDNCLRSTATUSO	int	1	(0)
OBDDNCLRSTATUSZ	int	1	(0)
OBDDNCLRSTATUSD	int	1	(0)
OBDDNCLRSTATUSR	int	1	(0)
OBDDNCLRSTATUSI	int	1	(0)
OBDDNCLRSTATUSE	int	1	(0)
OBDDNCLRSTATUSP	int	1	(0)
WOEXCLUSIVE	bit	1	(0)
OBDDNKREDESC	bit	1	(0)
OBDDNDATUMNAR	char(1)	1	('D')
ANWOEXLNKDOCSGNEQL	bit	1	(0)
DNADNORMADOSFOR	char(3)	1	('')
DNADNORMAPRIFOR	char(3)	1	('')
ACWOEXUNFINISHOP	char(1)	1	('P')

Select All, None, Invert

Uporabniki

Login
Ime
Geslo
Zapomni si me