| 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 | 8 | 0 | | | | Allow NULL? |
| 7 | U_NAME | User Name | nvarchar | 30 | 0 | | | | Allow NULL? |
| 8 | GROUPS | User Group | int | 6 | 0 | | 0 | 0=Regular, 99=Deleted | 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 | | H | H, N=No, 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 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 | Defaults | 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 Locked | 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 | 6 | 0 | | | | Allow NULL? |
| 38 | Charset | Font Language | int | 6 | 0 | | | | Allow NULL? |
| 39 | OpenCdt | Open Window for Credit ReferencÌOpenCdt | 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 Rate Table on start up | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 42 | AuImpRates | Import Currency Rates AutomaticÌAuImpRates | 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 Transactions Scheduled | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 45 | CheckFiles | File Check | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 46 | OpenCredit | Open Postdated Credit Vouchers | char | 1 | 0 | | N | D=By Date, N=No, Y=Always | Allow NULL? |
| 47 | CreditDay1 | Credit Handling Day 1 | int | 6 | 0 | | 1 | | Allow NULL? |
| 48 | CreditDay2 | Credit Handling 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=Partial, O=Without, 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 | int | 6 | 0 | | 5 | | Allow NULL? |
| 55 | ScreenLock | Screen Lock Delay | int | 6 | 0 | | 30 | | Allow NULL? |
| 56 | ShowNewMsg | Open Message 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 | Birthday | date | 8 | 0 | | | | |
| 65 | EnbMenuFlt | Enable Forbidden Menu Items | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 66 | objType | Object Type - History | nvarchar | 20 | 0 | | 12 | | Allow NULL? |
| 67 | logInstanc | Log Instance - History | int | 6 | 0 | | | | Allow NULL? |
| 68 | userSign | Creating User - History | int | 6 | 0 | OUSR | | | Allow NULL? |
| 69 | createDate | Creation Date - History | date | 8 | 0 | | | | |
| 70 | userSign2 | Updating User - History | int | 6 | 0 | OUSR | | | Allow NULL? |
| 71 | updateDate | Date of Update - History | date | 8 | 0 | | | | |
| 72 | OneLogPwd | At first logon change password | char | 1 | 0 | | N | N=Password should not be changed at first login, Y=Password should be changed at first login | Allow NULL? |
| 73 | lastLogin | Last Logon Date | date | 8 | 0 | | | | |
| 74 | LastPwds | Last Passwords 1 | nvarchar | 254 | 0 | | 0 | | Allow NULL? |
| 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 | MobileUser | Mobile User | char | 1 | 0 | | N | N=No, Y=Yes | Allow NULL? |
| 82 | MobileIMEI | Mobile IMEI | nvarchar | 64 | 0 | | | | Allow NULL? |
