biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Financials / Business Places
API AUSR
AUSR - Archive Users - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
USERID KEY UNIQUEUser SignatureInt
6
PRIMARYYes
PASSWORDUser PasswordnVarChar
127
0
PASSWORD1User PasswordnVarChar
8
PASSWORD2User PasswordnVarChar
8
INTERNAL_KInternal NumberInt
6
USER_CODEUser CodenVarChar
8
U_NAMEUser NamenVarChar
127
GROUPSAuthorization GroupInt
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) Free
1
H
E_MailE-MailnVarChar
100
PortNumMobile Phone NumbernVarChar
50
OutOfOfficOut of the OfficeVarChar
Y) Yes
N) No
1
N
SendEMailSend E-MailVarChar
Y) Yes
N) No
1
N
SendSMSSend SMSVarChar
Y) Yes
N) No
1
N
DfltsGroupDefaultnVarChar
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 ConfirmationVarChar
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 Vouchers Ref. UpdVarChar
Y) Yes
N) No
1
N
CdtPrvDaysVouchers from Last DaysInt
11
1
DsplyRatesDisplay Rates Table on StartupVarChar
Y) Yes
N) No
1
N
AuImpRatesImport Currency Exchange Rates AutomaticVarChar
Y) Yes
N) No
1
N
OpenDpsOpen Postdated Checks WindowVarChar
Y) Yes
N) No
1
N
RcrFlagDisplay Scheduled Recurring PostingsVarChar
Y) Yes
N) No
1
N
CheckFilesPerform Data CheckVarChar
Y) Yes
N) No
1
N
OpenCreditOpen Window for Postdated Credit VoucherVarChar
Y) Always
N) No
D) By Date
1
N
CreditDay1Handle Postdated Credit Day 1Int
6
1
CreditDay2Handle Postdated Credit Day 2Int
6
15
WallPaperWallpaperText
16
WllPprDspWallpaper DisplayInt
1) Centralized
2) Full Screen
3) Tile
6
1
AdvImagePrExtended Image ProcessingVarChar
N) Yes
O) No
Y) Full
1
N
ContactLogToday's Activity AlertVarChar
Y) Yes
N) No
1
N
LastWarnedLast Warned DateDate
8
AlertPolFrMessage Check Frequency (Min.)Int
6
5
ScreenLockScreen Lock DelayInt
6
30
ShowNewMsgDisplay Message/Alert 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
BirthdayDate of BirthDate
8
EnbMenuFltEnable Forbidden Menu ItemsVarChar
N) No
Y) Yes
1
N
objTypeObject TypenVarChar
20
12
logInstancLog InstanceInt
11
userSignCreating UserInt
6OUSR
Users
createDateCreation DateDate
8
userSign2Updating UserInt
6OUSR
Users
updateDateUpdate DateDate
8
OneLogPwdAt first logon change passwordVarChar
N) Do not change password at first login
Y) At first logon change password
1
N
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
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 AUSR.USERID AS 'User Signature', AUSR.PASSWORD AS 'User Password', AUSR.PASSWORD1 AS 'User Password', AUSR.PASSWORD2 AS 'User Password', AUSR.INTERNAL_K AS 'Internal Number', AUSR.USER_CODE AS 'User Code', AUSR.U_NAME AS 'User Name', AUSR.GROUPS AS 'Authorization Group', AUSR.PASSWORD4 AS 'Password', AUSR.ALLOWENCES AS 'User Confirmation', AUSR.SUPERUSER AS 'Superuser', AUSR.DISCOUNT AS 'Max. Discount', AUSR.PASSWORD3 AS 'User Password', AUSR.Info1File AS 'Info1File', AUSR.Info1Field AS 'Info1Field', AUSR.Info2File AS 'Info2File', AUSR.Info2Field AS 'Info2Field', AUSR.Info3File AS 'Info3File', AUSR.Info3Field AS 'Info3Field', AUSR.Info4File AS 'Info4File', AUSR.Info4Field AS 'Info4Field', AUSR.dType AS 'dType', AUSR.E_Mail AS 'E-Mail', AUSR.PortNum AS 'Mobile Phone Number', AUSR.OutOfOffic AS 'Out of the Office', AUSR.SendEMail AS 'Send E-Mail', AUSR.SendSMS AS 'Send SMS', AUSR.DfltsGroup AS 'Default', AUSR.CashLimit AS 'Cash Amount Limit', AUSR.MaxCashSum AS 'Max. Cash Total', AUSR.Fax AS 'Fax Number', AUSR.SendFax AS 'Send Fax', AUSR.Locked AS 'User Confirmation', AUSR.Department AS 'Department', AUSR.Branch AS 'Branch', AUSR.UserPrefs AS 'User Preferences', AUSR.Language AS 'Language', AUSR.Charset AS 'Font Language', AUSR.OpenCdt AS 'Open Window for Credit Vouchers Ref. Upd', AUSR.CdtPrvDays AS 'Vouchers from Last Days', AUSR.DsplyRates AS 'Display Rates Table on Startup', AUSR.AuImpRates AS 'Import Currency Exchange Rates Automatic', AUSR.OpenDps AS 'Open Postdated Checks Window', AUSR.RcrFlag AS 'Display Scheduled Recurring Postings', AUSR.CheckFiles AS 'Perform Data Check', AUSR.OpenCredit AS 'Open Window for Postdated Credit Voucher', AUSR.CreditDay1 AS 'Handle Postdated Credit Day 1', AUSR.CreditDay2 AS 'Handle Postdated Credit Day 2', AUSR.WallPaper AS 'Wallpaper', AUSR.WllPprDsp AS 'Wallpaper Display', AUSR.AdvImagePr AS 'Extended Image Processing', AUSR.ContactLog AS 'Today's Activity Alert', AUSR.LastWarned AS 'Last Warned Date', AUSR.AlertPolFr AS 'Message Check Frequency (Min.)', AUSR.ScreenLock AS 'Screen Lock Delay', AUSR.ShowNewMsg AS 'Display Message/Alert on Arrival', AUSR.Picture AS 'Picture', AUSR.Position AS 'Position', AUSR.Address AS 'Address', AUSR.Country AS 'Country', AUSR.Tel1 AS 'Telephone 1', AUSR.Tel2 AS 'Telephone 2', AUSR.GENDER AS 'Gender', AUSR.Birthday AS 'Date of Birth', AUSR.EnbMenuFlt AS 'Enable Forbidden Menu Items', AUSR.objType AS 'Object Type', AUSR.logInstanc AS 'Log Instance', AUSR.userSign AS 'Creating User', AUSR.createDate AS 'Creation Date', AUSR.userSign2 AS 'Updating User', AUSR.updateDate AS 'Update Date', AUSR.OneLogPwd AS 'At first logon change password', AUSR.lastLogin AS 'Last Logon Date', AUSR.LastPwds AS 'Last Passwords 1', AUSR.LastPwds2 AS 'Last Passwords 2', AUSR.LastPwdSet AS 'Last Password Change', AUSR.FailedLog AS 'Failed Login Count', AUSR.PwdNeverEx AS 'Password Never Expires', AUSR.SalesDisc AS 'Max. Sales Discount', AUSR.PurchDisc AS 'Max. Purchase Discount', AUSR.LstLogoutD AS 'Last Logoff Date', AUSR.LstLoginT AS 'Last Logon Time', AUSR.LstLogoutT AS 'Last Logoff Time', AUSR.LstPwdChT AS 'Last Password Change Time', AUSR.LstPwdChB AS 'Last Password Changed By', AUSR.RclFlag AS 'Display Recurring Transactions', AUSR.MobileUser AS 'Mobile User', AUSR.MobileIMEI AS 'Mobile IMEI', AUSR.PrsWkCntEb AS 'Personal Work Center Enable', AUSR.SnapShotId AS 'Snapshot ID', AUSR.STData AS 'User Password Salt', AUSR.SupportUsr AS 'Support User', AUSR.NoSTPwdNum AS 'Password encrypted w/o Salt (cryptograph', AUSR.DomainUser AS 'Domain user name bound in SLD', AUSR.CUSAgree AS 'CUS Agreement', AUSR.EmailSig AS 'E-Mail Signature', AUSR.TPLId AS 'Template ID', AUSR.DigCrtPath AS 'Digital Certificate Path', AUSR.ShowNewTsk AS 'Open Worklist on Task Arrival', AUSR.IntgrtEb AS 'Enable Setting Integration', AUSR.AllBrnchF AS 'Allow Viewing of All (Including Unassign' FROM AUSR AS AUSR

Related information


Branches OUBR SQL Table

Countries OCRY SQL Table

Departments OUDP SQL Table

User Defaults OUDG SQL Table

Customized Template UICU SQL Table

Users OUSR SQL Table



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