biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / General / Users
API OUSR / / Users
OUSR - Users Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
USERID KEY UNIQUEUser SignatureInt
6
PRIMARYYes
PASSWORD KEYUser PasswordnVarChar
127
0PASSWORDNo
PASSWORD1User PasswordnVarChar
8
PASSWORD2User PasswordnVarChar
8
INTERNAL_K KEY UNIQUEInternal NumberInt
6
INTERNALYes
USER_CODE KEY UNIQUEUser CodenVarChar
8
USER_CODEYes
U_NAMEUser NamenVarChar
127
GROUPSUser GroupInt
0
99) Deleted
6
0
PASSWORD4PasswordnVarChar
127
ALLOWENCESUser ConfirmationText
16
SUPERUSERSuperuserVarChar
Y) Yes
N) No
1
N
DISCOUNTMax. DiscountNum
20
PASSWORD3User PasswordnVarChar
8
Info1FileInfo1FilenVarChar
4
Info1FieldInfo1FieldInt
6
Info2FileInfo2FilenVarChar
4
Info2FieldInfo2FieldInt
6
Info3FileInfo3FilenVarChar
4
Info3FieldInfo3FieldInt
6
Info4FileInfo4FilenVarChar
4
Info4FieldInfo4FieldInt
6
dTypedTypeVarChar
Y) Yes
N) No
X)
H)
1
H
E_MailE-MailnVarChar
100
PortNumMobile Phone NumbernVarChar
50
OutOfOfficOut of OfficeVarChar
Y) Yes
N) No
1
N
SendEMailSend E-MailVarChar
Y) Yes
N) No
1
N
SendSMSSend SMSVarChar
Y) Yes
N) No
1
N
DfltsGroupDefaultsnVarChar
8OUDG
User Defaults
CashLimitCash Amount LimitVarChar
Y) Yes
N) No
1
N
MaxCashSumMax. Cash TotalNum
20
FaxFax NumbernVarChar
20
SendFaxSend FaxVarChar
Y) Yes
N) No
1
N
LockedUser LockedVarChar
Y) Yes
N) No
1
N
DepartmentDepartmentInt
6OUDP
Departments
-2
BranchBranchInt
6OUBR
Branches
-2
UserPrefsUser PreferencesText
16
LanguageLanguageInt
6
CharsetFont LanguageInt
6
OpenCdtOpen Window for Credit ReferenceVarChar
Y) Yes
N) No
1
N
CdtPrvDaysVouchers from Last DaysInt
11
1
DsplyRatesDisplay Rate Table on start upVarChar
Y) Yes
N) No
1
N
AuImpRatesImport Currency Rates AutomaticallyVarChar
Y) Yes
N) No
1
N
OpenDpsOpen Postdated Checks WindowVarChar
Y) Yes
N) No
1
N
RcrFlagDisplay Transactions Scheduled for TodayVarChar
Y) Yes
N) No
1
N
CheckFilesFile CheckVarChar
Y) Yes
N) No
1
N
OpenCreditOpen Postdated Credit Vouchers WindowVarChar
Y) Always
N) No
D) By Date
1
N
CreditDay1Credit Handling Day 1Int
6
1
CreditDay2Credit Handling Day 2Int
6
15
WallPaperWallpaperText
16
WllPprDspWallpaper DisplayInt
1) Centralized
2) Full Screen
3) Tile
6
1
AdvImagePrExtended Image ProcessingVarChar
N) Partial
O) Without
Y) Full
1
N
ContactLogToday's Activity AlertVarChar
Y) Yes
N) No
1
N
LastWarnedLast Warned DateDate
8
AlertPolFrMessage Check FrequencyInt
6
5
ScreenLockScreen Lock DelayInt
6
30
ShowNewMsgOpen Message on ArrivalVarChar
Y) Yes
N) No
1
Y
PicturePicturenVarChar
127
PositionPositionnVarChar
90
AddressAddressnVarChar
100
CountryCountrynVarChar
3OCRY
Countries
Tel1Telephone 1nVarChar
20
Tel2Telephone 2nVarChar
20
GENDERGenderVarChar
F) Female
M) Male
1
F
BirthdayBirthdayDate
8
EnbMenuFltEnable Forbidden Menu ItemsVarChar
N) No
Y) Yes
1
N
objTypeObject Type - HistorynVarChar
20
12
logInstancLog Instance - HistoryInt
11
userSignCreating User - HistoryInt
6OUSR
Users
createDateCreation Date - HistoryDate
8
userSign2Updating User - HistoryInt
6OUSR
Users
updateDateDate of Update - HistoryDate
8
OneLogPwdAt first logon change passwordVarChar
N) Password should not be changed at first login
Y) Password should be changed at first login
1
Y
lastLoginLast Logon DateDate
8
LastPwdsLast Passwords 1nVarChar
127
0
LastPwds2Last Passwords 2nVarChar
127
0
LastPwdSetLast Password ChangeDate
8
FailedLogFailed Login CountInt
11
0
PwdNeverExPassword Never ExpiresVarChar
Y) Yes
N) No
1
N
SalesDiscMax. Sales DiscountNum
20
PurchDiscMax. Purchase DiscountNum
20
LstLogoutDLast Logoff DateDate
8
LstLoginTLast Logon TimeInt
11
LstLogoutTLast Logoff TimeInt
11
LstPwdChTLast Password Change TimeInt
11
LstPwdChBLast Password Changed BynVarChar
8
RclFlagDisplay Recurring TransactionsVarChar
Y) Yes
N) No
1
N
MobileUserMobile UserVarChar
Y) Yes
N) No
1
N
MobileIMEIMobile IMEInVarChar
64
PrsWkCntEbPersonal Work Center EnableVarChar
Y) Yes
N) No
1
N
SnapShotIdSnapshot IDInt
11
0
STDataUser Password SaltnVarChar
40
SupportUsrSupport UserVarChar
N) No
Y) Yes
1
N
NoSTPwdNumPassword encrypted w/o Salt (cryptographInt
6
0
DomainUserDomain user name bound in SLDnVarChar
50
CUSAgreeCUS AgreementVarChar
1
EmailSigE-Mail SignatureText
16
TPLIdTemplate IDInt
6UICU
Customized Template
DigCrtPathDigital Certificate PathText
16
ShowNewTskOpen Worklist on Task ArrivalVarChar
N) No
Y) Yes
1
Y
IntgrtEbEnable Setting IntegrationVarChar
Y) Yes
N) No
1
N
AllBrnchFAllow Viewing of All (Including UnassignVarChar
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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates