Tofu - Baza

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


Naziv	Tip	Null	Privzeto	Opis
acWorker	char(30)	0	('')
acRegNo	char(13)	1	('')
acSex	char(1)	1	('')
acUCN	char(13)	1	('')
acTaxId	char(10)	1	('')
acEmploymentType	char(30)	1	('')
acMunicipality	char(30)	1	('')
acKS	char(30)	1	('')
acDept	char(30)	1	('')
acActive	char(1)	1	('T')
adDateBirth	smalldatetime	1
adDateEnter	smalldatetime	1
adDateExit	smalldatetime	1
acLOSBefore	char(8)	1	('00-00-00')
acSalaryCalc	char(1)	1	('')
anUserIns	smallint	1
adTimeIns	datetime	1
anUserChg	smallint	1
adTimeChg	datetime	1
acMunicipalityWork	char(30)	1	('')
acJob	char(30)	1	('')
acCarRegNo	char(20)	1	('')
acAgencySignedBy	char(30)	1	('')
acWorkPermitNo	char(20)	1	('')
acSurname	char(16)	1	('')
acName	char(16)	1	('')
acMotherName	char(20)	1	('')
acTaxOffice	char(4)	1	('')
acPost	char(13)	1	('')
acFatherName	char(20)	1	('')
acBirthSurname	char(20)	1	('')
acMaritalStatus	char(16)	1	('')
acCitizenship	char(16)	1	('')
acStatus	char(16)	1	('')
acOccup	char(10)	1	('')
acFinishedSchool	char(3)	1	('')
acProfQual	char(1)	1	('')
acEducation	char(1)	1	('')
acCityBirth	char(30)	1	('')
acMunicipalityBirth	char(30)	1	('')
acCountryBirth	char(20)	1	('')
acIGroup	char(6)	1	('')
acStreet	varchar(60)	1	('')
acPhone	char(30)	1	('')
acCity	char(30)	1	('')
acCountry	char(20)	1	('')
acTempStreet	varchar(60)	1	('')
acTempPhone	char(30)	1	('')
acTempCity	char(30)	1	('')
acTempMunicip	char(30)	1	('')
acTempKS	char(30)	1	('')
acTempPost	char(13)	1	('')
acTempCounty	char(20)	1	('')
acLOSBeforeCompany	char(8)	1	('00-00-00')
acBeneBefore	char(8)	1	('00-00-00')
acBeneBeforeCompany	char(8)	1	('00-00-00')
acLOSBuy	char(8)	1	('00-00-00')
acBeneBuy	char(8)	1	('00-00-00')
acBeneLOSInc	char(1)	1	('')
acBeneLOS	char(4)	1	('')
acWorkingSaturday	char(1)	1	('F')
acWorkingSunday	char(1)	1	('F')
acCompanyCar	char(1)	1	('F')
acWorkPerIssu	char(3)	1	('')
adWorkPerFrom	smalldatetime	1
adWorkPerTo	smalldatetime	1
adVisaTo	smalldatetime	1
adEmployedTo	smalldatetime	1
acProfEduc	char(1)	1	('')
acSchoolEducation	char(2)	1	('')
acCeaseCause	varchar(40)	1	('')
acBirthPost	char(13)	1	('')
acEmail	varchar(200)	1	('')
acHealthCardRegOff	char(3)	1	('')
acHealthCardHZZO	char(8)	1	('')
acFormulaVacationAdd	money	1	(0)
acFormulaVacation	char(20)	1	('')
acVacationCalcType	char(1)	1	('V')
acSingleParent	char(1)	1	('F')
anCardNo	smallint	1	(0)
acWorkHourCode	char(4)	1	('')
adDateBeginHourWork	smalldatetime	1
acWorkPerToUnLtd	char(1)	1	('F')
acVSPIPolicyNo	char(10)	1	('')
adVSPIEntryDate	smalldatetime	1
adVSPIExitDate	smalldatetime	1
anVSPIWorkerPercent	money	1	(0)
anVSPIAmount	money	1	(0)
anVSPIBnkAcctNo	smallint	1	(0)
acMSPIPolicyNo	char(10)	1	('')
adMSPIEntryDate	smalldatetime	1
anMSPIPercent	money	1	(0)
adMSPIExitDate	smalldatetime	1
acForeignTaxDeduct	char(1)	1	('F')
anClothingNo	int	1	(0)
anShoeNo	int	1	(0)
acPrefix	char(10)	1	('')
acMiddleName	char(16)	1	('')
anTreineeYr	tinyint	1	(0)
acVSPIBnk	char(30)	1	('')
acVSPIEntryType	char(1)	1	('')
acJobCriteria	char(1)	1	('F')
acOverTime	char(1)	1	('F')
anReduction	money	1	(0)
acCountryResidency	char(20)	1	('')
acCountrySend	char(20)	1	('')
acPayCurrency	char(3)	1	('')
acNew	char(1)	1	('F')
acColumn2	char(1)	1	('F')
acNoPI	char(12)	1	('')
acDisableQuota	char(1)	1	('F')
acDisabilityType	char(2)	1	('')
acFormPPOPJ	char(1)	1	('')
acVisaUnLtd	char(1)	1	('F')
acBaseContrib	char(1)	1	('')
adMaritalDate	datetime	1
adStartAbsence	smalldatetime	1
acOwnerPrivComp	char(1)	1	('F')
acIsSpecReduction	char(1)	1	('F')
anWorkingHours	tinyint	1
acText01	varchar(40)	1	('')
acText02	varchar(40)	1	('')
acText03	varchar(40)	1	('')
acText04	varchar(40)	1	('')
acText05	varchar(40)	1	('')
acText06	varchar(40)	1	('')
acText07	varchar(40)	1	('')
acText08	varchar(40)	1	('')
acText09	varchar(40)	1	('')
acText10	varchar(40)	1	('')
acSufix	char(10)	1	('')
acPicture	image	1

Select All, None, Invert

Uporabniki

Login
Ime
Geslo
Zapomni si me