| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| USERID |
User Signature |
Int |
6 |
- |
|
|
|
| PASSWORD |
User Password |
nVarChar |
254 |
- |
0 |
|
|
| PASSWORD1 |
User Password |
nVarChar |
8 |
- |
|
|
|
| PASSWORD2 |
User Password |
nVarChar |
8 |
- |
|
|
|
| INTERNAL_K |
Internal Number |
Int |
6 |
- |
|
|
|
| USER_CODE |
User Code |
nVarChar |
25 |
- |
|
|
|
| U_NAME |
User Name |
nVarChar |
155 |
- |
|
|
|
| GROUPS |
User Group |
Int |
6 |
- |
0 |
0 |
Regular |
| |
|
|
|
|
|
99 |
Deleted |
| PASSWORD4 |
Password |
nVarChar |
254 |
- |
|
|
|
| ALLOWENCES |
User Confirmation |
Text |
16 |
- |
|
|
|
| SUPERUSER |
Superuser |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DISCOUNT |
Max. Discount |
Num |
19.6 |
- |
|
|
|
| PASSWORD3 |
User Password |
nVarChar |
8 |
- |
|
|
|
| Info1File |
Info1File |
nVarChar |
4 |
- |
|
|
|
| Info1Field |
Info1Field |
Int |
6 |
- |
|
|
|
| Info2File |
Info2File |
nVarChar |
4 |
- |
|
|
|
| Info2Field |
Info2Field |
Int |
6 |
- |
|
|
|
| Info3File |
Info3File |
nVarChar |
4 |
- |
|
|
|
| Info3Field |
Info3Field |
Int |
6 |
- |
|
|
|
| Info4File |
Info4File |
nVarChar |
4 |
- |
|
|
|
| Info4Field |
Info4Field |
Int |
6 |
- |
|
|
|
| dType |
dType |
VarChar |
1 |
- |
S |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| |
|
|
|
|
|
X |
|
| |
|
|
|
|
|
H |
SHA1 |
| |
|
|
|
|
|
S |
SHA256 |
| E_Mail |
E-Mail |
nVarChar |
100 |
- |
|
|
|
| PortNum |
Mobile Phone Number |
nVarChar |
50 |
- |
|
|
|
| OutOfOffic |
Out of Office |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SendEMail |
Send E-Mail |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SendSMS |
Send SMS |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DfltsGroup |
Defaults |
nVarChar |
8 |
OUDG |
|
|
|
| CashLimit |
Cash Amount Limit |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| MaxCashSum |
Max. Cash Total |
Num |
19.6 |
- |
|
|
|
| Fax |
Fax Number |
nVarChar |
50 |
- |
|
|
|
| SendFax |
Send Fax |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Locked |
User Locked |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Department |
Department |
Int |
6 |
OUDP |
-2 |
|
|
| Branch |
Branch |
Int |
6 |
OUBR |
-2 |
|
|
| UserPrefs |
User Preferences |
Text |
16 |
- |
|
|
|
| Language |
Language |
Int |
11 |
- |
|
|
|
| Charset |
Font Language |
Int |
6 |
- |
|
|
|
| OpenCdt |
Open Window for Credit Reference |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CdtPrvDays |
Vouchers from Last Days |
Int |
11 |
- |
1 |
|
|
| DsplyRates |
Display Rate Table on start up |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AuImpRates |
Import Currency Rates Automatically |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| OpenDps |
Open Postdated Checks Window |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RcrFlag |
Display Transactions Scheduled for Today |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CheckFiles |
File Check |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| OpenCredit |
Open Postdated Credit Vouchers Window |
VarChar |
1 |
- |
|
Y |
Always |
| |
|
|
|
|
|
N |
No |
| |
|
|
|
|
|
D |
By Date |
| CreditDay1 |
Credit Handling Day 1 |
Int |
6 |
- |
1 |
|
|
| CreditDay2 |
Credit Handling Day 2 |
Int |
6 |
- |
15 |
|
|
| WallPaper |
Wallpaper |
Text |
16 |
- |
|
|
|
| WllPprDsp |
Wallpaper Display |
Int |
6 |
- |
|
1 |
Centralized |
| |
|
|
|
|
|
2 |
Full Screen |
| |
|
|
|
|
|
3 |
Tile |
| AdvImagePr |
Extended Image Processing |
VarChar |
1 |
- |
|
N |
Partial |
| |
|
|
|
|
|
O |
Without |
| |
|
|
|
|
|
Y |
Full |
| ContactLog |
Today's Activity Alert |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| LastWarned |
Last Warned Date |
Date |
8 |
- |
|
|
|
| AlertPolFr |
Message Check Frequency |
Int |
6 |
- |
5 |
|
|
| ScreenLock |
Screen Lock Delay |
Int |
6 |
- |
30 |
|
|
| ShowNewMsg |
Open Message on Arrival |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Picture |
Picture |
nVarChar |
200 |
- |
|
|
|
| Position |
Position |
nVarChar |
90 |
- |
|
|
|
| Address |
Address |
nVarChar |
254 |
- |
|
|
|
| Country |
Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| Tel1 |
Telephone 1 |
nVarChar |
50 |
- |
|
|
|
| Tel2 |
Telephone 2 |
nVarChar |
50 |
- |
|
|
|
| GENDER |
Gender |
VarChar |
1 |
- |
F |
F |
Female |
| |
|
|
|
|
|
M |
Male |
| Birthday |
Birthday |
Date |
8 |
- |
|
|
|
| EnbMenuFlt |
Enable Forbidden Menu Items |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| objType |
Object Type - History |
nVarChar |
20 |
- |
12 |
|
|
| logInstanc |
Log Instance - History |
Int |
11 |
- |
|
|
|
| userSign |
Creating User - History |
Int |
6 |
OUSR |
|
|
|
| createDate |
Creation Date - History |
Date |
8 |
- |
|
|
|
| userSign2 |
Updating User - History |
Int |
6 |
OUSR |
|
|
|
| updateDate |
Date of Update - History |
Date |
8 |
- |
|
|
|
| OneLogPwd |
At first logon change password |
VarChar |
1 |
- |
Y |
N |
Password should not be changed at first login |
| |
|
|
|
|
|
Y |
Password should be changed at first login |
| lastLogin |
Last Logon Date |
Date |
8 |
- |
|
|
|
| LastPwds |
Last Passwords 1 |
Text |
16 |
- |
|
|
|
| LastPwds2 |
Last Passwords 2 |
nVarChar |
254 |
- |
0 |
|
|
| LastPwdSet |
Last Password Change |
Date |
8 |
- |
|
|
|
| FailedLog |
Failed Login Count |
Int |
11 |
- |
0 |
|
|
| PwdNeverEx |
Password Never Expires |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SalesDisc |
Max. Sales Discount |
Num |
19.6 |
- |
|
|
|
| PurchDisc |
Max. Purchase Discount |
Num |
19.6 |
- |
|
|
|
| LstLogoutD |
Last Logoff Date |
Date |
8 |
- |
|
|
|
| LstLoginT |
Last Logon Time |
Int |
11 |
- |
|
|
|
| LstLogoutT |
Last Logoff Time |
Int |
11 |
- |
|
|
|
| LstPwdChT |
Last Password Change Time |
Int |
11 |
- |
|
|
|
| LstPwdChB |
Last Password Changed By |
nVarChar |
25 |
- |
|
|
|
| RclFlag |
Display Recurring Transactions |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| MobileUser |
Mobile User |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| MobileIMEI |
Mobile IMEI |
nVarChar |
64 |
- |
|
|
|
| PrsWkCntEb |
Personal Work Center Enable |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SnapShotId |
Snapshot ID |
Int |
11 |
- |
0 |
|
|
| STData |
User Password Salt |
nVarChar |
40 |
- |
|
|
|
| SupportUsr |
Support User |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| NoSTPwdNum |
Password encrypted w/o Salt (cryptography) |
Int |
6 |
- |
0 |
|
|
| DomainUser |
Domain user name bound in SLD |
nVarChar |
50 |
- |
|
|
|
| CUSAgree |
CUS Agreement |
VarChar |
1 |
- |
|
|
|
| |
|
|
|
|
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| EmailSig |
E-Mail Signature |
Text |
16 |
- |
|
|
|
| TPLId |
Template ID |
Int |
6 |
UICU |
|
|
|
| DigCrtPath |
Digital Certificate Path |
Text |
16 |
- |
|
|
|
| ShowNewTsk |
Open Worklist on Task Arrival |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| IntgrtEb |
Enable Setting Integration |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AllBrnchF |
Allow Viewing of All (Including Unassigned To) Branches in Financial Reports |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| EvtNotify |
Allow Event Notification |
VarChar |
1 |
- |
Y |
|
|
| IgnDtOwn |
Ignore Data Ownership for this user |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| EnterAsTab |
Use Numeric Keypad Enter Key as Tab Key |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DotAsSep |
Use Del Key As Separator |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| MouseOnly |
Document Operation by Mouse Only |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Color |
Company Color |
Int |
6 |
- |
|
0 |
Combined |
| |
|
|
|
|
|
1 |
Classic |
| |
|
|
|
|
|
2 |
Gray |
| |
|
|
|
|
|
3 |
Violet |
| |
|
|
|
|
|
4 |
Blue |
| |
|
|
|
|
|
5 |
Green |
| |
|
|
|
|
|
6 |
Yellow |
| |
|
|
|
|
|
7 |
Orange |
| |
|
|
|
|
|
8 |
Red |
| |
|
|
|
|
|
9 |
Brown |
| SkinType |
Skin Type |
nVarChar |
254 |
- |
|
|
|
| Font |
Font |
nVarChar |
50 |
- |
|
|
|
| FontSize |
Font Size |
Int |
11 |
- |
|
|
|
| NaturalPer |
Natural Person |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| DPPStatus |
Data Protection Status |
VarChar |
1 |
- |
N |
N |
None |
| |
|
|
|
|
|
D |
Erased |
| |
|
|
|
|
|
B |
Blocked |
| |
|
|
|
|
|
U |
Unblocked |
| AutoAsnBPL |
Auto. Assign Branches |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|
| HandleEDoc |
Can Process Electronic Documents |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ShowLicBal |
Show License Balloon |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| LicBaHDate |
License Balloon Hiding Date |
Date |
8 |
- |
|
|
|
| ShowFstMsg |
Show Only Part of Message |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ShowMsgNum |
The Number of Message to Show |
Int |
11 |
- |
100 |
|
|
| LastClean |
Last Cleanup Date |
Date |
8 |
- |
|
|
|
| CleanChb |
Checkbox of Message Cleanup |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CleanIbx |
Checkbox of Cleanup Inbox |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CleanObx |
Checkbox of Cleanup Outbox |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CleanSnt |
Checkbox of Cleanup Sent |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |