PREFS – This table is used to store database-wide application preferences.
Ÿ TRACKBY – Reserved for future use.
Ÿ NEWPROJECT – "T" if the software creates a new project for each new client, "F" otherwise.
Ÿ SHORTNAME – "T" if the client acronym is to be included in Track-IT light projects, "F" otherwise.
Ÿ ASSIGN – "E" if assigning by employee, "T" if assigning by team.
Ÿ GLOBAL – "T" if tasks are global by default, "F" otherwise.
Ÿ APPROVE – "T" if transactions are automatically approved, "F" otherwise.
Ÿ IMPEXP – "T" if software checks Track-IT light for expense information, "F" otherwise.
Ÿ ITEEMP – Custom terminology for "Employee".
Ÿ ITEEMPS – Custom terminology for "Employees".
Ÿ ITETEA – Custom terminology for "Team".
Ÿ ITETEAS – Custom terminology for "Teams".
Ÿ ITETAS – Custom terminology for "Task".
Ÿ ITETASS – Custom terminology for "Tasks".
Ÿ ITEPRO - Custom terminology for "Project".
Ÿ ITEPROS – Custom terminology for "Projects".
Ÿ ITECLI – Custom terminology for "Client".
Ÿ ITECLIS – Custom terminology for "Clients".
Ÿ ITEREC – Custom terminology for "Receivable".
Ÿ ITERECS – Custom terminology for "Receivables".
Ÿ ITEEXP – Custom terminology for "Expense".
Ÿ ITEEXPS – Custom terminology for "Expenses".
Ÿ ITEREG – Custom terminology for "Region".
Ÿ ITEREGS – Custom terminology for "Regions".
Ÿ ITERAT – Custom terminology for "Rate".
Ÿ ITERATS – Custom terminology for "Rates".
Ÿ ITEVAT – Custom terminology for "Value Added Tax"
Ÿ ITEVATCOL1 - Custom terminology for "Value Added Tax 1"
Ÿ ITEVATCOL2 - Custom terminology for "Value Added Tax 2"
Ÿ STAEST – Custom terminology for project status "Estimate".
Ÿ STAQUO – Custom terminology for project status "Quotation".
Ÿ STAACT – Custom terminology for project status "Active".
Ÿ STAREJ – Custom terminology for project status "Rejected".
Ÿ STATER – Custom terminology for project status "Terminated".
Ÿ STAFIN – Custom terminology for project status "Finished".
Ÿ BBYFIX – Custom terminology for project billing "Fixed Cost".
Ÿ BBYACT – Custom terminology for project billing "Actual Hours".
Ÿ BBYEST - Custom terminology for project billing "Estimated Hours".
Ÿ APPSEC – "T" if Track-IT light has password protection on its files.
Ÿ APPEXP – Reserved for future use.
Ÿ SMTPSERVER – The Default SMTP Server.
Ÿ SMTPPORT – The Default SMTP Port.
Ÿ AUDLEVEL – Reserved for future use.
Ÿ MPSURL – The Microsoft Project Server URL.
Ÿ MPSUSERID – The UserID for Microsoft Project Server.
Ÿ MPSPASSWORD – The Password for Microsoft Project Server.
Ÿ MPSAUTHENTICATION – The Microsoft Project Server Authentication type. ( 1 = Microsoft Project Server Authentication, 2 = Windows Authentication)
Ÿ APPDISALL – Display all entries in Approval View.