|
|
SQL 
Administration / 
Users
DTW Administration / Setup / General / Users
API OUSR / Users
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | USERID KEY UNIQUE | User Signature | Int | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| PASSWORD KEY | User Password | nVarChar | 127 | 0 | PASSWORD | No | ||
| PASSWORD1 | User Password | nVarChar | 8 | |||||
| PASSWORD2 | User Password | nVarChar | 8 | |||||
| INTERNAL_K KEY UNIQUE | Internal Number | Int | 6 | INTERNAL | Yes | |||
| USER_CODE KEY UNIQUE | User Code | nVarChar | 8 | USER_CODE | Yes | |||
| U_NAME | User Name | nVarChar | 127 | |||||
| GROUPS | User Group | Int | 0 99) Deleted | 6 | 0 | |||
| PASSWORD4 | Password | nVarChar | 127 | |||||
| ALLOWENCES | User Confirmation | Text | 16 | |||||
| SUPERUSER | Superuser | VarChar | Y) Yes N) No | 1 | N | |||
| DISCOUNT | Max. Discount | Num | 20 | |||||
| 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 | Y) Yes N) No X) H) | 1 | H | |||
| E_Mail | nVarChar | 100 | ||||||
| PortNum | Mobile Phone Number | nVarChar | 50 | |||||
| OutOfOffic | Out of Office | VarChar | Y) Yes N) No | 1 | N | |||
| SendEMail | Send E-Mail | VarChar | Y) Yes N) No | 1 | N | |||
| SendSMS | Send SMS | VarChar | Y) Yes N) No | 1 | N | |||
| DfltsGroup | Defaults | nVarChar | 8 | OUDG User Defaults | ||||
| CashLimit | Cash Amount Limit | VarChar | Y) Yes N) No | 1 | N | |||
| MaxCashSum | Max. Cash Total | Num | 20 | |||||
| Fax | Fax Number | nVarChar | 20 | |||||
| SendFax | Send Fax | VarChar | Y) Yes N) No | 1 | N | |||
| Locked | User Locked | VarChar | Y) Yes N) No | 1 | N | |||
| Department | Department | Int | 6 | OUDP Departments | -2 | |||
| Branch | Branch | Int | 6 | OUBR Branches | -2 | |||
| UserPrefs | User Preferences | Text | 16 | |||||
| Language | Language | Int | 6 | |||||
| Charset | Font Language | Int | 6 | |||||
| OpenCdt | Open Window for Credit Reference | VarChar | Y) Yes N) No | 1 | N | |||
| CdtPrvDays | Vouchers from Last Days | Int | 11 | 1 | ||||
| DsplyRates | Display Rate Table on start up | VarChar | Y) Yes N) No | 1 | N | |||
| AuImpRates | Import Currency Rates Automatically | VarChar | Y) Yes N) No | 1 | N | |||
| OpenDps | Open Postdated Checks Window | VarChar | Y) Yes N) No | 1 | N | |||
| RcrFlag | Display Transactions Scheduled for Today | VarChar | Y) Yes N) No | 1 | N | |||
| CheckFiles | File Check | VarChar | Y) Yes N) No | 1 | N | |||
| OpenCredit | Open Postdated Credit Vouchers Window | VarChar | Y) Always N) No D) By Date | 1 | N | |||
| CreditDay1 | Credit Handling Day 1 | Int | 6 | 1 | ||||
| CreditDay2 | Credit Handling Day 2 | Int | 6 | 15 | ||||
| WallPaper | Wallpaper | Text | 16 | |||||
| WllPprDsp | Wallpaper Display | Int | 1) Centralized 2) Full Screen 3) Tile | 6 | 1 | |||
| AdvImagePr | Extended Image Processing | VarChar | N) Partial O) Without Y) Full | 1 | N | |||
| ContactLog | Today's Activity Alert | VarChar | Y) Yes N) No | 1 | N | |||
| 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 | Y) Yes N) No | 1 | Y | |||
| Picture | Picture | nVarChar | 127 | |||||
| Position | Position | nVarChar | 90 | |||||
| Address | Address | nVarChar | 100 | |||||
| Country | Country | nVarChar | 3 | OCRY Countries | ||||
| Tel1 | Telephone 1 | nVarChar | 20 | |||||
| Tel2 | Telephone 2 | nVarChar | 20 | |||||
| GENDER | Gender | VarChar | F) Female M) Male | 1 | F | |||
| Birthday | Birthday | Date | 8 | |||||
| EnbMenuFlt | Enable Forbidden Menu Items | VarChar | N) No Y) Yes | 1 | N | |||
| objType | Object Type - History | nVarChar | 20 | 12 | ||||
| logInstanc | Log Instance - History | Int | 11 | |||||
| userSign | Creating User - History | Int | 6 | OUSR Users | ||||
| createDate | Creation Date - History | Date | 8 | |||||
| userSign2 | Updating User - History | Int | 6 | OUSR Users | ||||
| updateDate | Date of Update - History | Date | 8 | |||||
| OneLogPwd | At first logon change password | VarChar | N) Password should not be changed at first login Y) Password should be changed at first login | 1 | Y | |||
| lastLogin | Last Logon Date | Date | 8 | |||||
| LastPwds | Last Passwords 1 | nVarChar | 127 | 0 | ||||
| LastPwds2 | Last Passwords 2 | nVarChar | 127 | 0 | ||||
| LastPwdSet | Last Password Change | Date | 8 | |||||
| FailedLog | Failed Login Count | Int | 11 | 0 | ||||
| PwdNeverEx | Password Never Expires | VarChar | Y) Yes N) No | 1 | N | |||
| SalesDisc | Max. Sales Discount | Num | 20 | |||||
| PurchDisc | Max. Purchase Discount | Num | 20 | |||||
| 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 | 8 | |||||
| RclFlag | Display Recurring Transactions | VarChar | Y) Yes N) No | 1 | N | |||
| MobileUser | Mobile User | VarChar | Y) Yes N) No | 1 | N | |||
| MobileIMEI | Mobile IMEI | nVarChar | 64 | |||||
| PrsWkCntEb | Personal Work Center Enable | VarChar | Y) Yes N) No | 1 | N | |||
| SnapShotId | Snapshot ID | Int | 11 | 0 | ||||
| STData | User Password Salt | nVarChar | 40 | |||||
| SupportUsr | Support User | VarChar | N) No Y) Yes | 1 | N | |||
| NoSTPwdNum | Password encrypted w/o Salt (cryptograph | Int | 6 | 0 | ||||
| DomainUser | Domain user name bound in SLD | nVarChar | 50 | |||||
| CUSAgree | CUS Agreement | VarChar | 1 | |||||
| EmailSig | E-Mail Signature | Text | 16 | |||||
| TPLId | Template ID | Int | 6 | UICU Customized Template | ||||
| DigCrtPath | Digital Certificate Path | Text | 16 | |||||
| ShowNewTsk | Open Worklist on Task Arrival | VarChar | N) No Y) Yes | 1 | Y | |||
| IntgrtEb | Enable Setting Integration | VarChar | Y) Yes N) No | 1 | N | |||
| AllBrnchF | Allow Viewing of All (Including Unassign | VarChar | Y) Yes N) No | 1 | Y |
Table relationship map
SELECT statement
SELECT
OUSR.USERID AS 'User Signature',
OUSR.PASSWORD AS 'User Password',
OUSR.PASSWORD1 AS 'User Password',
OUSR.PASSWORD2 AS 'User Password',
OUSR.INTERNAL_K AS 'Internal Number',
OUSR.USER_CODE AS 'User Code',
OUSR.U_NAME AS 'User Name',
OUSR.GROUPS AS 'User Group',
OUSR.PASSWORD4 AS 'Password',
OUSR.ALLOWENCES AS 'User Confirmation',
OUSR.SUPERUSER AS 'Superuser',
OUSR.DISCOUNT AS 'Max. Discount',
OUSR.PASSWORD3 AS 'User Password',
OUSR.Info1File AS 'Info1File',
OUSR.Info1Field AS 'Info1Field',
OUSR.Info2File AS 'Info2File',
OUSR.Info2Field AS 'Info2Field',
OUSR.Info3File AS 'Info3File',
OUSR.Info3Field AS 'Info3Field',
OUSR.Info4File AS 'Info4File',
OUSR.Info4Field AS 'Info4Field',
OUSR.dType AS 'dType',
OUSR.E_Mail AS 'E-Mail',
OUSR.PortNum AS 'Mobile Phone Number',
OUSR.OutOfOffic AS 'Out of Office',
OUSR.SendEMail AS 'Send E-Mail',
OUSR.SendSMS AS 'Send SMS',
OUSR.DfltsGroup AS 'Defaults',
OUSR.CashLimit AS 'Cash Amount Limit',
OUSR.MaxCashSum AS 'Max. Cash Total',
OUSR.Fax AS 'Fax Number',
OUSR.SendFax AS 'Send Fax',
OUSR.Locked AS 'User Locked',
OUSR.Department AS 'Department',
OUSR.Branch AS 'Branch',
OUSR.UserPrefs AS 'User Preferences',
OUSR.Language AS 'Language',
OUSR.Charset AS 'Font Language',
OUSR.OpenCdt AS 'Open Window for Credit Reference',
OUSR.CdtPrvDays AS 'Vouchers from Last Days',
OUSR.DsplyRates AS 'Display Rate Table on start up',
OUSR.AuImpRates AS 'Import Currency Rates Automatically',
OUSR.OpenDps AS 'Open Postdated Checks Window',
OUSR.RcrFlag AS 'Display Transactions Scheduled for Today',
OUSR.CheckFiles AS 'File Check',
OUSR.OpenCredit AS 'Open Postdated Credit Vouchers Window',
OUSR.CreditDay1 AS 'Credit Handling Day 1',
OUSR.CreditDay2 AS 'Credit Handling Day 2',
OUSR.WallPaper AS 'Wallpaper',
OUSR.WllPprDsp AS 'Wallpaper Display',
OUSR.AdvImagePr AS 'Extended Image Processing',
OUSR.ContactLog AS 'Today's Activity Alert',
OUSR.LastWarned AS 'Last Warned Date',
OUSR.AlertPolFr AS 'Message Check Frequency',
OUSR.ScreenLock AS 'Screen Lock Delay',
OUSR.ShowNewMsg AS 'Open Message on Arrival',
OUSR.Picture AS 'Picture',
OUSR.Position AS 'Position',
OUSR.Address AS 'Address',
OUSR.Country AS 'Country',
OUSR.Tel1 AS 'Telephone 1',
OUSR.Tel2 AS 'Telephone 2',
OUSR.GENDER AS 'Gender',
OUSR.Birthday AS 'Birthday',
OUSR.EnbMenuFlt AS 'Enable Forbidden Menu Items',
OUSR.objType AS 'Object Type - History',
OUSR.logInstanc AS 'Log Instance - History',
OUSR.userSign AS 'Creating User - History',
OUSR.createDate AS 'Creation Date - History',
OUSR.userSign2 AS 'Updating User - History',
OUSR.updateDate AS 'Date of Update - History',
OUSR.OneLogPwd AS 'At first logon change password',
OUSR.lastLogin AS 'Last Logon Date',
OUSR.LastPwds AS 'Last Passwords 1',
OUSR.LastPwds2 AS 'Last Passwords 2',
OUSR.LastPwdSet AS 'Last Password Change',
OUSR.FailedLog AS 'Failed Login Count',
OUSR.PwdNeverEx AS 'Password Never Expires',
OUSR.SalesDisc AS 'Max. Sales Discount',
OUSR.PurchDisc AS 'Max. Purchase Discount',
OUSR.LstLogoutD AS 'Last Logoff Date',
OUSR.LstLoginT AS 'Last Logon Time',
OUSR.LstLogoutT AS 'Last Logoff Time',
OUSR.LstPwdChT AS 'Last Password Change Time',
OUSR.LstPwdChB AS 'Last Password Changed By',
OUSR.RclFlag AS 'Display Recurring Transactions',
OUSR.MobileUser AS 'Mobile User',
OUSR.MobileIMEI AS 'Mobile IMEI',
OUSR.PrsWkCntEb AS 'Personal Work Center Enable',
OUSR.SnapShotId AS 'Snapshot ID',
OUSR.STData AS 'User Password Salt',
OUSR.SupportUsr AS 'Support User',
OUSR.NoSTPwdNum AS 'Password encrypted w/o Salt (cryptograph',
OUSR.DomainUser AS 'Domain user name bound in SLD',
OUSR.CUSAgree AS 'CUS Agreement',
OUSR.EmailSig AS 'E-Mail Signature',
OUSR.TPLId AS 'Template ID',
OUSR.DigCrtPath AS 'Digital Certificate Path',
OUSR.ShowNewTsk AS 'Open Worklist on Task Arrival',
OUSR.IntgrtEb AS 'Enable Setting Integration',
OUSR.AllBrnchF AS 'Allow Viewing of All (Including Unassign'
FROM OUSR AS OUSR
Related information
Users Users Object· Table: OUSR
Users is a business object that represents the users table of the SAP Business One application. The users table includes the users list, login details, and authorizations.
This object enables you to:
Add users to the users list.
Retrieve...
Users OUSR SQL Table
Customized Template UICU SQL Table
Users
Enumeration
Method
Object
UserActionRecord USR5
UserPermission USR3
Property
Branch
DTW DB
CashLimit
DTW DB
Defaults
DTW DB
Department
DTW DB
eMail
DTW DB
FaxNumber
DTW DB
Group
DB
InternalKey
DTW DB
Locked
DTW DB
MaxCashAmtForIncmngPayts
DTW DB
MaxDiscountGeneral
DTW DB
MaxDiscountPurchase
DTW DB
MaxDiscountSales
DTW DB
MobilePhoneNumber
DTW DB
Superuser
DTW DB
UserCode
DTW DB
UserName
DTW DB
UserPassword
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates