📚 SAP Business One SDK Help

Table Name: AUSR

Table Description: Users - History

Field Description Type Size Related Default Value Constraints
USERID User Signature Int 6 -      
PASSWORD User Password nVarChar 254 - 0    
PASSWORD1 User Password nVarChar 8 -      
PASSWORD2 User Password nVarChar 8 -      
INTERNAL_K Internal Number Int 6 -      
USER_CODE User Code nVarChar 25 -      
U_NAME User Name nVarChar 155 -      
GROUPS Authorization Group Int 6 - 0    
PASSWORD4 Password nVarChar 254 -      
ALLOWENCES User Confirmation Text 16 -      
SUPERUSER Superuser VarChar 1 - N Y Yes
            N No
DISCOUNT Max. Discount Num 19.6 -      
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 1 - S Y Yes
            N No
            X  
            H SHA1
            S SHA256
E_Mail E-Mail nVarChar 100 -      
PortNum Mobile Phone Number nVarChar 50 -      
OutOfOffic Out of the Office VarChar 1 - N Y Yes
            N No
SendEMail Send E-Mail VarChar 1 - N Y Yes
            N No
SendSMS Send SMS VarChar 1 - N Y Yes
            N No
DfltsGroup Default nVarChar 8 OUDG      
CashLimit Cash Amount Limit VarChar 1 - N Y Yes
            N No
MaxCashSum Max. Cash Total Num 19.6 -      
Fax Fax Number nVarChar 50 -      
SendFax Send Fax VarChar 1 - N Y Yes
            N No
Locked User Confirmation VarChar 1 - N Y Yes
            N No
Department Department Int 6 OUDP -2    
Branch Branch Int 6 OUBR -2    
UserPrefs User Preferences Text 16 -      
Language Language Int 11 -      
Charset Font Language Int 6 -      
OpenCdt Open Window for Credit Vouchers Ref. Update VarChar 1 - N Y Yes
            N No
CdtPrvDays Vouchers from Last Days Int 11 - 1    
DsplyRates Display Rates Table on Startup VarChar 1 - N Y Yes
            N No
AuImpRates Import Currency Exchange Rates Automatically VarChar 1 - N Y Yes
            N No
OpenDps Open Postdated Checks Window VarChar 1 - N Y Yes
            N No
RcrFlag Display Scheduled Recurring Postings VarChar 1 - N Y Yes
            N No
CheckFiles Perform Data Check VarChar 1 - N Y Yes
            N No
OpenCredit Open Window for Postdated Credit Vouchers VarChar 1 - N Y Always
            N No
            D By Date
CreditDay1 Handle Postdated Credit Day 1 Int 6 - 1    
CreditDay2 Handle Postdated Credit Day 2 Int 6 - 15    
WallPaper Wallpaper Text 16 -      
WllPprDsp Wallpaper Display Int 6 - 1 1 Centralized
            2 Full Screen
            3 Tile
AdvImagePr Extended Image Processing VarChar 1 - N N Yes
            O No
            Y Full
ContactLog Today's Activity Alert VarChar 1 - N Y Yes
            N No
LastWarned Last Warned Date Date 8 -      
AlertPolFr Message Check Frequency (Min.) Int 6 - 5    
ScreenLock Screen Lock Delay Int 6 - 30    
ShowNewMsg Display Message/Alert on Arrival VarChar 1 - Y Y Yes
            N No
Picture Picture nVarChar 200 -      
Position Position nVarChar 90 -      
Address Address nVarChar 254 -      
Country Country/Region nVarChar 3 OCRY      
Tel1 Telephone 1 nVarChar 50 -      
Tel2 Telephone 2 nVarChar 50 -      
GENDER Gender VarChar 1 - F F Female
            M Male
Birthday Date of Birth Date 8 -      
EnbMenuFlt Enable Forbidden Menu Items VarChar 1 - N N No
            Y Yes
objType Object Type nVarChar 20 - 12    
logInstanc Log Instance Int 11 -      
userSign Creating User Int 6 OUSR      
createDate Creation Date Date 8 -      
userSign2 Updating User Int 6 OUSR      
updateDate Update Date Date 8 -      
OneLogPwd At first logon change password VarChar 1 - N N Do not change password at first login
            Y At first logon change password
lastLogin Last Logon Date Date 8 -      
LastPwds Last Passwords 1 Text 16 -      
LastPwds2 Last Passwords 2 nVarChar 254 - 0    
LastPwdSet Last Password Change Date 8 -      
FailedLog Failed Login Count Int 11 - 0    
PwdNeverEx Password Never Expires VarChar 1 - N Y Yes
            N No
SalesDisc Max. Sales Discount Num 19.6 -      
PurchDisc Max. Purchase Discount Num 19.6 -      
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 25 -      
RclFlag Display Recurring Transactions VarChar 1 -   Y Yes
            N No
MobileUser Mobile User VarChar 1 - N Y Yes
            N No
MobileIMEI Mobile IMEI nVarChar 64 -      
PrsWkCntEb Personal Work Center Enable VarChar 1 - N Y Yes
            N No
SnapShotId Snapshot ID Int 11 - 0    
STData User Password Salt nVarChar 40 -      
SupportUsr Support User VarChar 1 - N N No
            Y Yes
NoSTPwdNum Password encrypted w/o Salt (cryptography) Int 6 - 0    
DomainUser Domain user name bound in SLD nVarChar 50 -      
CUSAgree CUS Agreement VarChar 1 -      
            Y Yes
            N No
EmailSig E-Mail Signature Text 16 -      
TPLId Template ID Int 6 UICU      
DigCrtPath Digital Certificate Path Text 16 -      
ShowNewTsk Open Worklist on Task Arrival VarChar 1 - Y N No
            Y Yes
IntgrtEb Enable Setting Integration VarChar 1 - N Y Yes
            N No
AllBrnchF Allow Viewing of All (Including Unassigned To) Branches in Financial Reports VarChar 1 - Y Y Yes
            N No
EvtNotify Allow Event Notification VarChar 1 - Y    
IgnDtOwn Ignore Data Ownership for this user VarChar 1 - N Y Yes
            N No
EnterAsTab Use Numeric Keypad Enter Key as Tab Key VarChar 1 - N Y Yes
            N No
DotAsSep Use Del Key As Separator VarChar 1 - N Y Yes
            N No
MouseOnly Document Operation by Mouse Only VarChar 1 - N Y Yes
            N No
Color Company Color Int 6 -   0 Combined
            1 Classic
            2 Gray
            3 Violet
            4 Blue
            5 Green
            6 Yellow
            7 Orange
            8 Red
            9 Brown
SkinType Skin Type nVarChar 254 -      
Font Font nVarChar 50 -      
FontSize Font Size Int 11 -      
NaturalPer Natural Person VarChar 1 - N N No
            Y Yes
DPPStatus Data Protection Status VarChar 1 - N N None
            D Erased
            B Blocked
            U Unblocked
AutoAsnBPL Auto. Assign Branches VarChar 1 - N Y Yes
            N No
EncryptIV Encrypt IV nVarChar 100 -      
HandleEDoc Can Process Electronic Documents VarChar 1 - Y Y Yes
            N No
ShowLicBal Show License Balloon VarChar 1 - Y Y Yes
            N No
LicBaHDate License Balloon Hiding Date Date 8 -      
ShowFstMsg Show Only Part of Message VarChar 1 - N Y Yes
            N No
ShowMsgNum The Number of Message to Show Int 11 - 100    
LastClean Last Cleanup Date Date 8 -      
CleanChb Checkbox of Message Cleanup VarChar 1 - N Y Yes
            N No
CleanIbx Checkbox of Cleanup Inbox VarChar 1 - N Y Yes
            N No
CleanObx Checkbox of Cleanup Outbox VarChar 1 - N Y Yes
            N No
CleanSnt Checkbox of Cleanup Sent VarChar 1 - N Y Yes
            N No
validFor Active VarChar 1 - N Y Yes
            N No
validFrom Active From Date 8 -      
validTo Active To Date 8 -      
frozenFor Inactive VarChar 1 - N Y Yes
            N No
frozenFrom Inactive From Date 8 -      
frozenTo Inactive To Date 8 -      
ValidComm Remarks for Active Period nVarChar 30 -      
FrozenComm Remarks for Inactive Period nVarChar 30 -      
AprvDsnc Approval Decision Notification VarChar 1 - N Y Yes
            N No
ReqAprvl Requests for Approval Notification VarChar 1 - N Y Yes
            N No
RnwBlktA Renew Blanket Agreement Reminders Notification VarChar 1 - N Y Yes
            N No
SvcClRem Service Call Reminders Notification VarChar 1 - N Y Yes
            N No
SvcClAsn Service Call Assignments Notification VarChar 1 - N Y Yes
            N No
WzdTsk Wizard Tasks Notification VarChar 1 - N Y Yes
            N No
Key Unique Field
PRIMARY Yes USERID
    logInstanc