| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | USERID | User Signature | int | 6 | 0 | | | | Allow NULL? |
| 2 | PASSWORD | User Password | nvarchar | 254 | 0 | | 0 | | Allow NULL? |
| 3 | PASSWORD1 | User Password | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | PASSWORD2 | User Password | nvarchar | 8 | 0 | | | | Allow NULL? |
| 5 | INTERNAL_K | Internal Number | int | 6 | 0 | | | | Allow NULL? |
| 6 | USER_CODE | User Code | nvarchar | 25 | 0 | | | | Allow NULL? |
| 7 | U_NAME | User Name | nvarchar | 155 | 0 | | | | Allow NULL? |
| 8 | GROUPS | Authorization Group | int | 6 | 0 | | 0 | | Allow NULL? |
| 9 | PASSWORD4 | Password | nvarchar | 254 | 0 | | | | Allow NULL? |
| 10 | ALLOWENCES | User Confirmation | text | 16 | 0 | | | | |
| 11 | SUPERUSER | Superuser | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 12 | DISCOUNT | Max. Discount | num | 19 | 6 | | | | Allow NULL? |
| 13 | PASSWORD3 | User Password | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | Info1File | Info1File | nvarchar | 4 | 0 | | | | Allow NULL? |
| 15 | Info1Field | Info1Field | int | 6 | 0 | | | | Allow NULL? |
| 16 | Info2File | Info2File | nvarchar | 4 | 0 | | | | Allow NULL? |
| 17 | Info2Field | Info2Field | int | 6 | 0 | | | | Allow NULL? |
| 18 | Info3File | Info3File | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | Info3Field | Info3Field | int | 6 | 0 | | | | Allow NULL? |
| 20 | Info4File | Info4File | nvarchar | 4 | 0 | | | | Allow NULL? |
| 21 | Info4Field | Info4Field | int | 6 | 0 | | | | Allow NULL? |
| 22 | dType | dType | char | 1 | 0 | | S | H=SHA1, N=No, S=SHA256, X, Y=Yes | Allow NULL? |
| 23 | E_Mail | E-Mail | nvarchar | 100 | 0 | | | | Allow NULL? |
| 24 | PortNum | Mobile Phone Number | nvarchar | 50 | 0 | | | | Allow NULL? |
| 25 | OutOfOffic | Out of the Office | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 26 | SendEMail | Send E-Mail | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 27 | SendSMS | Send SMS | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 28 | DfltsGroup | Default | nvarchar | 8 | 0 | OUDG | | | Allow NULL? |
| 29 | CashLimit | Cash Amount Limit | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 30 | MaxCashSum | Max. Cash Total | num | 19 | 6 | | | | Allow NULL? |
| 31 | Fax | Fax Number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 32 | SendFax | Send Fax | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 33 | Locked | User Confirmation | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 34 | Department | Department | int | 6 | 0 | OUDP | -2 | | Allow NULL? |
| 35 | Branch | Branch | int | 6 | 0 | OUBR | -2 | | Allow NULL? |
| 36 | UserPrefs | User Preferences | text | 16 | 0 | | | | |
| 37 | Language | Language | int | 11 | 0 | | | | Allow NULL? |
| 38 | Charset | Font Language | int | 6 | 0 | | | | Allow NULL? |
| 39 | OpenCdt | Open Window for Credit Vouchers Ref. Update | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 40 | CdtPrvDays | Vouchers from Last Days | int | 11 | 0 | | 1 | | Allow NULL? |
| 41 | DsplyRates | Display Rates Table on Startup | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 42 | AuImpRates | Import Currency Exchange Rates Automatically | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 43 | OpenDps | Open Postdated Checks Window | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 44 | RcrFlag | Display Scheduled Recurring Postings | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 45 | CheckFiles | Perform Data Check | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 46 | OpenCredit | Open Window for Postdated Credit Vouchers | char | 1 | 0 | | N | D=By Date, N=No, Y=Always | Allow NULL? |
| 47 | CreditDay1 | Handle Postdated Credit Day 1 | int | 6 | 0 | | 1 | | Allow NULL? |
| 48 | CreditDay2 | Handle Postdated Credit Day 2 | int | 6 | 0 | | 15 | | Allow NULL? |
| 49 | WallPaper | Wallpaper | text | 16 | 0 | | | | |
| 50 | WllPprDsp | Wallpaper Display | int | 6 | 0 | | 1 | 1=Centralized, 2=Full Screen, 3=Tile | Allow NULL? |
| 51 | AdvImagePr | Extended Image Processing | char | 1 | 0 | | N | N=Yes, O=No, Y=Full | Allow NULL? |
| 52 | ContactLog | Today's Activity Alert | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 53 | LastWarned | Last Warned Date | date | 8 | 0 | | | | |
| 54 | AlertPolFr | Message Check Frequency (Min.) | int | 6 | 0 | | 5 | | Allow NULL? |
| 55 | ScreenLock | Screen Lock Delay | int | 6 | 0 | | 30 | | Allow NULL? |
| 56 | ShowNewMsg | Display Message/Alert on Arrival | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 57 | Picture | Picture | nvarchar | 200 | 0 | | | | Allow NULL? |
| 58 | Position | Position | nvarchar | 90 | 0 | | | | Allow NULL? |
| 59 | Address | Address | nvarchar | 100 | 0 | | | | Allow NULL? |
| 60 | Country | Country | nvarchar | 3 | 0 | OCRY | | | Allow NULL? |
| 61 | Tel1 | Telephone 1 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 62 | Tel2 | Telephone 2 | nvarchar | 20 | 0 | | | | Allow NULL? |
| 63 | GENDER | Gender | char | 1 | 0 | | F | F=Female, M=Male | Allow NULL? |
| 64 | Birthday | Date of Birth | date | 8 | 0 | | | | |
| 65 | EnbMenuFlt | Enable Forbidden Menu Items | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 66 | objType | Object Type | nvarchar | 20 | 0 | | 12 | | Allow NULL? |
| 67 | logInstanc | Log Instance | int | 11 | 0 | | | | Allow NULL? |
| 68 | userSign | Creating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 69 | createDate | Creation Date | date | 8 | 0 | | | | |
| 70 | userSign2 | Updating User | int | 6 | 0 | OUSR | | | Allow NULL? |
| 71 | updateDate | Update Date | date | 8 | 0 | | | | |
| 72 | OneLogPwd | At first logon change password | char | 1 | 0 | | N | N=Do not change password at first login, Y=At first logon change password | Allow NULL? |
| 73 | lastLogin | Last Logon Date | date | 8 | 0 | | | | |
| 74 | LastPwds | Last Passwords 1 | text | 16 | 0 | | | | |
| 75 | LastPwds2 | Last Passwords 2 | nvarchar | 254 | 0 | | 0 | | Allow NULL? |
| 76 | LastPwdSet | Last Password Change | date | 8 | 0 | | | | |
| 77 | FailedLog | Failed Login Count | int | 11 | 0 | | 0 | | Allow NULL? |
| 78 | PwdNeverEx | Password Never Expires | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 79 | SalesDisc | Max. Sales Discount | num | 19 | 6 | | | | Allow NULL? |
| 80 | PurchDisc | Max. Purchase Discount | num | 19 | 6 | | | | Allow NULL? |
| 81 | LstLogoutD | Last Logoff Date | date | 8 | 0 | | | | |
| 82 | LstLoginT | Last Logon Time | int | 11 | 0 | | | | Allow NULL? |
| 83 | LstLogoutT | Last Logoff Time | int | 11 | 0 | | | | Allow NULL? |
| 84 | LstPwdChT | Last Password Change Time | int | 11 | 0 | | | | Allow NULL? |
| 85 | LstPwdChB | Last Password Changed By | nvarchar | 8 | 0 | | | | Allow NULL? |
| 86 | RclFlag | Display Recurring Transactions | char | 1 | 0 | | | N=No, Y=Yes | Allow NULL? |
| 87 | MobileUser | Mobile User | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 88 | MobileIMEI | Mobile IMEI | nvarchar | 64 | 0 | | | | Allow NULL? |
| 89 | PrsWkCntEb | Personal Work Center Enable | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 90 | SnapShotId | Snapshot ID | int | 11 | 0 | | 0 | | Allow NULL? |
| 91 | STData | User Password Salt | nvarchar | 40 | 0 | | | | Allow NULL? |
| 92 | SupportUsr | Support User | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 93 | NoSTPwdNum | Password encrypted w/o Salt (cryptography) | int | 6 | 0 | | 0 | | Allow NULL? |
| 94 | DomainUser | Domain user name bound in SLD | nvarchar | 50 | 0 | | | | Allow NULL? |
| 95 | CUSAgree | CUS Agreement | char | 1 | 0 | | | N=No, Y=Yes | Allow NULL? |
| 96 | EmailSig | E-Mail Signature | text | 16 | 0 | | | | |
| 97 | TPLId | Template ID | int | 6 | 0 | UICU | | | Allow NULL? |
| 98 | DigCrtPath | Digital Certificate Path | text | 16 | 0 | | | | |
| 99 | ShowNewTsk | Open Worklist on Task Arrival | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 100 | IntgrtEb | Enable Setting Integration | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 101 | AllBrnchF | Allow Viewing of All (Including Unassigned To) Branches in Financial Reports | char | 1 | 0 | | Y | N=No, Y=Yes | Allow NULL? |
| 102 | EvtNotify | Allow Event Notification | char | 1 | 0 | | Y | | Allow NULL? |
| 103 | IgnDtOwn | Ignore Data Ownership for this user | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 104 | EnterAsTab | Use Numeric Keypad Enter Key as Tab Key | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 105 | DotAsSep | Use Del Key As Separator | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 106 | MouseOnly | Document Operation by Mouse Only | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 107 | Color | Company Color | int | 6 | 0 | | | 0=Combined, 1=Classic, 2=Gray, 3=Violet, 4=Blue, 5=Green, 6=Yellow, 7=Orange, 8=Red, 9=Brown | Allow NULL? |
| 108 | SkinType | Skin Type | nvarchar | 254 | 0 | | | | Allow NULL? |
| 109 | Font | Font | nvarchar | 50 | 0 | | | | Allow NULL? |
| 110 | FontSize | Font Size | int | 11 | 0 | | | | Allow NULL? |
| 111 | NaturalPer | Natural Person | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 112 | DPPStatus | Data Protection Status | char | 1 | 0 | | N | B=Blocked, D=Erased, N=None, U=Unblocked | Allow NULL? |
| 113 | AutoAsnBPL | Auto. Assign Branches | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
