Tofu - Baza

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


Naziv	Tip	Null	Privzeto	Opis
NAZIV	char(30)	1	('')
KUPEC	char(1)	1	('T')
DOBAVITELJ	char(1)	1	('T')
BANKA	char(1)	1	('F')
OBCINA	char(1)	1	('F')
KRAJSKUP	char(1)	1	('F')
SKLADISCE	char(1)	1	('F')
DELAVEC	char(1)	1	('F')
UPORABNIK	char(1)	1	('F')
ODDELEK	char(1)	1	('F')
SOLA	char(1)	1	('F')
USTANOVA	char(1)	1	('F')
NASLOV	varchar(60)	1	('')
NAZIV2	varchar(255)	1	('')
NAZIV3	varchar(255)	1	('')
POSTA	char(11)	1	('')
DRZAVA	char(20)	1	('')
KM	smallint	0	(0)
SIFRA	char(20)	1	('')
TEL	char(20)	1	('')
FAX	char(20)	1	('')
CENRAZRED	char(1)	1	('1')
DNIZAPLAC	smallint	0	(0)
LETNAIZJAVA	char(10)	1	('')
DATUMIZJ	smalldatetime	1
IZJAVA	char(2)	1	('')
LIMIT	money	0	(0)
DATUMLIM	smalldatetime	1
TIPPARTNERJAI	char(8)	1	('')
TIPPARTNERJAO	char(8)	1	('')
VODZALOGE	char(1)	1	('0')
VREDZALOGE	char(1)	1	('0')
ZALVMINUS	char(1)	1	('F')
DATUMINVENT	smalldatetime	1
REFERENT	char(2)	1	('')
RABAT	decimal(8,4)	0	(0)
NACPRODAJE	char(1)	1	('Z')
VALUTA	char(3)	1	('EUR')
NACIZRCENE	char(1)	1	('0')
NACINPLAC	char(3)	1	('')
DOSTAVA	char(2)	1	('')
MATICNASTEV	char(13)	1	('')
PLACNIK	char(30)	1	('')
SIFDEJAVNOST	char(15)	1	('')
DOBNACIZRCENE	char(1)	1	('0')
DOBRABAT	decimal(19,6)	0	(0)
DOBNACPRODAJE	char(1)	1	('D')
DOBLETNAIZJAVA	char(10)	1	('')
DOBDATUMIZJ	smalldatetime	1
DOBDNIZAPLAC	smallint	0	(0)
DOBNACINPLAC	char(3)	1	('')
DOBIZJAVA	char(2)	1	('')
DOBLIMIT	money	0	(0)
DOBDATUMLIM	smalldatetime	1
DOBDOSTAVA	char(2)	1	('')
DOBVALUTA	char(3)	1	('EUR')
DOBREFERENT	char(2)	1	('')
VIRPRTY	char(1)	1	('9')
SWIFTKODA	char(12)	1	('')
ATSKLADISCE	char(1)	1	('F')
SIFRAOBCINE	char(4)	1	('')
ODPREMNALISTA	char(1)	1	('F')
OBRMERAVRSTA	char(2)	1	('')
VREDZALOGEMP	char(1)	1	('0')
PARITETA	char(3)	1	('')
PARITETAPOSTA	char(11)	1	('')
DOBPARITETA	char(3)	1	('')
DOBPARITETAPOSTA	char(11)	1	('')
DATUMZAP	datetime	1	(getdate())
USERZAP	char(2)	1	('')
DATUMSPRE	datetime	1	(getdate())
USERSPRE	char(2)	1	('')
OPOMBA	varchar(4096)	1
FIELDSA	varchar(40)	1	('')
FIELDSB	varchar(40)	1	('')
FIELDSC	varchar(40)	1	('')
FIELDSD	varchar(40)	1	('')
FIELDSE	varchar(40)	1	('')
FIELDSF	varchar(40)	1	('')
FIELDSG	varchar(40)	1	('')
FIELDSH	varchar(40)	1	('')
FIELDSI	varchar(40)	1	('')
FIELDSJ	varchar(40)	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)
FIELDNF	decimal(19,6)	0	(0)
FIELDNG	decimal(19,6)	0	(0)
FIELDNH	decimal(19,6)	0	(0)
FIELDNI	decimal(19,6)	0	(0)
FIELDNJ	decimal(19,6)	0	(0)
FIELDDA	datetime	1
FIELDDB	datetime	1
FIELDDC	datetime	1
FIELDDD	datetime	1
SKIS	char(7)	1	('')
_S56RSV_BHT_ASORTIMAN	char(5)	1
_S56RSV_BHT_SIFRA_AMB	char(6)	1
_S56RSV_BHT_BON_AMB	char(1)	1
_S56RSV_BHT_DEKADNO	char(1)	1
_S56RSV_BHT_POPR_CENE	char(1)	1
_S56RSV_BHT_TIPIZPISA	char(1)	1
SIFRAISO	char(3)	1	('')
VRSTAPOSDOK	char(1)	1	('P')
LOCENAPRODKALK	char(1)	1	('F')
OBMOCJE	char(1)	1	('F')
NADOBCINA	char(30)	1	('')
PODENOTA	char(1)	1	('F')
VRSTAPOSDOKKRIPT	char(1)	1	('F')
VRSTAPOSDOKSIGN	char(1)	1	('F')
KREVIR	char(1)	1	('T')
VRSTAPOSDOKGLN	varchar(35)	1	('')
ACINTRSTSBUYER	char(1)	1	('T')
ACINTRSTSSUPPLIER	char(1)	1	('T')
ACRSBAINDISTRIKT	char(1)	1	('K')

Select All, None, Invert

Uporabniki

Login
Ime
Geslo
Zapomni si me