Tofu - Baza

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


Naziv	Tip	Null	Privzeto	Opis
KLASIF	char(8)	1	('')
NAZIV	char(40)	1	('')
TS	char(2)	1	('')
TSZNIZANA	char(2)	1	('')
SERIALNO	char(1)	1	('N')
GARANCIJA	smallint	0	(0)
NAZIVTL	char(10)	1	('')
VRSTAMS	char(3)	1	('')
VALUTA	char(3)	1	('SIT')
EM	char(3)	1	('')
EMTOEM2	float	1	(1)
EM2	char(3)	1	('')
MINZALOGA	decimal(19,6)	0	(0)
POPUST	decimal(8,4)	0	(0)
FORMULA	char(3)	1	('')
CARTARIFA	char(12)	1	('')
POSKOLICINA	decimal(19,6)	0	(1)
RABAT	decimal(8,4)	0	(0)
TRANSPORT	decimal(6,3)	0	(0)
DAJATVE	decimal(6,3)	0	(0)
NEPSTR	decimal(6,3)	0	(0)
VRDAVEK	decimal(6,3)	0	(0)
MPCENAP	decimal(6,3)	0	(0)
VPCENAP	decimal(6,3)	0	(0)
VPCENA2P	decimal(6,3)	0	(0)
SESTAVNICAP	decimal(6,3)	0	(0)
IZRACUNKALK	char(1)	1	('C')
NACIZRCENE	char(1)	1	('M')
RRABAT	char(1)	1	('T')
RTRANSPORT	char(1)	1	('T')
RDAJATVE	char(1)	1	('T')
RNEPSTR	char(1)	1	('T')
RVRDAVEK	char(1)	1	('T')
RMPCENAP	char(1)	1	('T')
RVPCENAP	char(1)	1	('T')
RVPCENA2P	char(1)	1	('T')
RSESTAVNICAP	char(1)	1	('T')
NACPOLKLASIF	char(1)	1	('T')
VALUTADOB	char(3)	1	('SIT')
KONTO	char(8)	1	('')
MAXZALOGA	decimal(19,6)	0	(0)
OPTZALOGA	decimal(19,6)	0	(0)
FIELDSA	varchar(255)	1	('')
FIELDSB	varchar(255)	1	('')
FIELDSC	varchar(255)	1	('')
FIELDSD	varchar(255)	1	('')
FIELDSE	varchar(255)	1	('')
FIELDNA	decimal(19,6)	0	(0)
FIELDNB	decimal(19,6)	0	(0)
FIELDNC	decimal(19,6)	0	(0)
FIELDND	decimal(19,6)	0	(0)
FIELDNE	decimal(19,6)	0	(0)
SHOWATENA	char(1)	1	('F')
SHOWATENAOPIS	char(1)	1	('F')
ATENAOPISPOS	char(1)	1	('B')
ATENAORDER	char(1)	1	('')
KONTOPRIH	char(8)	1	('')
FIELDSF	varchar(255)	1	('')
FIELDSG	varchar(255)	1	('')
FIELDNF	decimal(19,6)	0	(0)
FIELDNG	decimal(19,6)	0	(0)
FIELDSH	varchar(255)	1	('')
FIELDSI	varchar(255)	1	('')
FIELDSJ	varchar(255)	1	('')
FIELDNH	decimal(19,6)	0	(0)
FIELDNI	decimal(19,6)	0	(0)
FIELDNJ	decimal(19,6)	0	(0)
ROKDOBAVE	smallint	0	(0)
STOLPEC	char(3)	1	('')
DATUMZAP	datetime	1	(getdate())
DATUMSPRE	datetime	1	(getdate())
USERZAP	char(2)	1	('')
USERSPRE	char(2)	1	('')
TIP	char(1)	1	('O')
HFKOSMALTERNATIVAPOD	tinyint	1	(253)
HFKOSMVRED1	float	1	(0)
HFKOSMSTEVILO	float	1	(1)
HFKOSMPOT	smallint	1	(0)
ACPRSTMATQTYFORMULA	char(3)	1	('')
HFKOSMEM	char(3)	1	('')
HFKOSMMODPADEK	char(16)	1	('')
HFKOSMNODPADEK	float	1	(0)
HFKOSMPODPADEK	float	1	(0)
HFKOSMNODGOREK	float	1	(0)
HFKOSMPODGOREK	float	1	(0)
HFKOSOVRED1	float	1	(0)
HFKOSOVRED2	float	1	(0)
HFKOSOSTEVILO	float	1	(1)
HFKOSOPOT	smallint	1	(0)
ACPRSTOPRQTYFORMULA	char(3)	1	('')
HFKOSOEM	char(3)	1	('')
HFKOSOEMCAS	char(3)	1	('')
HFKOSOVRED3	float	1	(0)
HFKOSOPOT3	smallint	1	(0)
HFKOSOEM3	char(3)	1	('')
HFKOSORESURS	char(16)	1	('')
HFKOSOKONTNI_PREDPIS	char(16)	1	('')
HFKOSOPLAC_RAZ	char(6)	1	('')
HFKOSOVZDODATEK	char(3)	1	('')
HFKOSOST_DELAVCEV	smallint	1	(0)
HFKOSOVRSTA_OP	char(1)	1	('')
HFKOSOTIP_ZAMIKA	char(1)	1	('')
HFKOSOOPTIMALNA_KOL	float	1	(0)
HFKOSDC1	char(30)	1	('')
HFKOSDC2	char(30)	1	('')
HFKOSDC3	char(30)	1	('')
HFKOSDC4	char(30)	1	('')
HFKOSDC5	float	1	(0)
HFKOSDC6	float	1	(0)
HFKOSDC7	float	1	(0)
HFKOSDC8	varchar(2048)	1	('')
OPIS	varchar(4096)	1	('')
SLIKA	image	1

Select All, None, Invert

Uporabniki

Login
Ime
Geslo
Zapomni si me