|
|
DTW Administration / Setup / Financials / Business Places
API AUSR
AUSR - Archive Users - History Table
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
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 | User Password | nVarChar | 127 | 0 | ||||
| PASSWORD1 | User Password | nVarChar | 8 | |||||
| PASSWORD2 | User Password | nVarChar | 8 | |||||
| INTERNAL_K | Internal Number | Int | 6 | |||||
| USER_CODE | User Code | nVarChar | 8 | |||||
| U_NAME | User Name | nVarChar | 127 | |||||
| GROUPS | Authorization Group | Int | 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) Free | 1 | H | |||
| E_Mail | nVarChar | 100 | ||||||
| PortNum | Mobile Phone Number | nVarChar | 50 | |||||
| OutOfOffic | Out of the 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 | Default | 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 Confirmation | 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 Vouchers Ref. Upd | VarChar | Y) Yes N) No | 1 | N | |||
| CdtPrvDays | Vouchers from Last Days | Int | 11 | 1 | ||||
| DsplyRates | Display Rates Table on Startup | VarChar | Y) Yes N) No | 1 | N | |||
| AuImpRates | Import Currency Exchange Rates Automatic | VarChar | Y) Yes N) No | 1 | N | |||
| OpenDps | Open Postdated Checks Window | VarChar | Y) Yes N) No | 1 | N | |||
| RcrFlag | Display Scheduled Recurring Postings | VarChar | Y) Yes N) No | 1 | N | |||
| CheckFiles | Perform Data Check | VarChar | Y) Yes N) No | 1 | N | |||
| OpenCredit | Open Window for Postdated Credit Voucher | VarChar | Y) Always N) No D) By Date | 1 | N | |||
| 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 | 1) Centralized 2) Full Screen 3) Tile | 6 | 1 | |||
| AdvImagePr | Extended Image Processing | VarChar | N) Yes O) No 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 (Min.) | Int | 6 | 5 | ||||
| ScreenLock | Screen Lock Delay | Int | 6 | 30 | ||||
| ShowNewMsg | Display Message/Alert 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 | Date of Birth | Date | 8 | |||||
| EnbMenuFlt | Enable Forbidden Menu Items | VarChar | N) No Y) Yes | 1 | N | |||
| objType | Object Type | nVarChar | 20 | 12 | ||||
| logInstanc | Log Instance | Int | 11 | |||||
| userSign | Creating User | Int | 6 | OUSR Users | ||||
| createDate | Creation Date | Date | 8 | |||||
| userSign2 | Updating User | Int | 6 | OUSR Users | ||||
| updateDate | Update Date | Date | 8 | |||||
| OneLogPwd | At first logon change password | VarChar | N) Do not change password at first login Y) At first logon change password | 1 | N | |||
| 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 | ||||
| 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
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
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
