List \ OUSR
Berikut ini adalah kolom yang terdapat pada tabel OUSR di SAP B1
Update: 2026-07-23
| No |
Nama Kolom |
Tipe Data |
Keterangan |
Referensi |
| 1. |
USERID |
Smallint |
User Signature |
|
| 2. |
PASSWORD |
NVarchar (254) |
User Password |
|
| 3. |
PASSWORD1 |
NVarchar (8) |
User Password |
|
| 4. |
PASSWORD2 |
NVarchar (8) |
User Password |
|
| 5. |
INTERNAL_K |
Smallint |
Internal Number |
|
| 6. |
USER_CODE |
NVarchar (25) |
User Code |
|
| 7. |
U_NAME |
NVarchar (155) |
User Name |
|
| 8. |
GROUPS |
Smallint |
User Group |
|
| 9. |
PASSWORD4 |
NVarchar (254) |
Password |
|
| 10. |
ALLOWENCES |
NClob |
User Confirmation |
|
| 11. |
SUPERUSER |
NVarchar (1) |
Superuser |
|
| 12. |
DISCOUNT |
Decimal (21, ) |
Max. Discount |
|
| 13. |
PASSWORD3 |
NVarchar (8) |
User Password |
|
| 14. |
Info1File |
NVarchar (4) |
Info1File |
|
| 15. |
Info1Field |
Smallint |
Info1Field |
|
| 16. |
Info2File |
NVarchar (4) |
Info2File |
|
| 17. |
Info2Field |
Smallint |
Info2Field |
|
| 18. |
Info3File |
NVarchar (4) |
Info3File |
|
| 19. |
Info3Field |
Smallint |
Info3Field |
|
| 20. |
Info4File |
NVarchar (4) |
Info4File |
|
| 21. |
Info4Field |
Smallint |
Info4Field |
|
| 22. |
dType |
NVarchar (1) |
dType |
|
| 23. |
E_Mail |
NVarchar (100) |
E-Mail |
|
| 24. |
PortNum |
NVarchar (50) |
Mobile Phone Number |
|
| 25. |
OutOfOffic |
NVarchar (1) |
Out of Office |
|
| 26. |
SendEMail |
NVarchar (1) |
Send E-Mail |
|
| 27. |
SendSMS |
NVarchar (1) |
Send SMS |
|
| 28. |
DfltsGroup |
NVarchar (8) |
Defaults |
|
| 29. |
CashLimit |
NVarchar (1) |
Cash Amount Limit |
|
| 30. |
MaxCashSum |
Decimal (21, ) |
Max. Cash Total |
|
| 31. |
Fax |
NVarchar (50) |
Fax Number |
|
| 32. |
SendFax |
NVarchar (1) |
Send Fax |
|
| 33. |
Locked |
NVarchar (1) |
User Locked |
|
| 34. |
Department |
Smallint |
Department |
|
| 35. |
Branch |
Smallint |
Branch |
|
| 36. |
UserPrefs |
BLOB(2147483647) |
User Preferences |
|
| 37. |
Language |
Integer |
Language |
|
| 38. |
Charset |
Smallint |
Font Language |
|
| 39. |
OpenCdt |
NVarchar (1) |
Open Window for Credit Reference |
|
| 40. |
CdtPrvDays |
Integer |
Vouchers from Last Days |
|
| 41. |
DsplyRates |
NVarchar (1) |
Display Rate Table on start up |
|
| 42. |
AuImpRates |
NVarchar (1) |
Import Currency Rates Automatically |
|
| 43. |
OpenDps |
NVarchar (1) |
Open Postdated Checks Window |
|
| 44. |
RcrFlag |
NVarchar (1) |
Display Transactions Scheduled for Today |
|
| 45. |
CheckFiles |
NVarchar (1) |
File Check |
|
| 46. |
OpenCredit |
NVarchar (1) |
Open Postdated Credit Vouchers Window |
|
| 47. |
CreditDay1 |
Smallint |
Credit Handling Day 1 |
|
| 48. |
CreditDay2 |
Smallint |
Credit Handling Day 2 |
|
| 49. |
WallPaper |
NClob |
Wallpaper |
|
| 50. |
WllPprDsp |
Smallint |
Wallpaper Display |
|
| 51. |
AdvImagePr |
NVarchar (1) |
Extended Image Processing |
|
| 52. |
ContactLog |
NVarchar (1) |
Today's Activity Alert |
|
| 53. |
LastWarned |
Time Stamp |
Last Warned Date |
|
| 54. |
AlertPolFr |
Smallint |
Message Check Frequency |
|
| 55. |
ScreenLock |
Smallint |
Screen Lock Delay |
|
| 56. |
ShowNewMsg |
NVarchar (1) |
Open Message on Arrival |
|
| 57. |
Picture |
NVarchar (200) |
Picture |
|
| 58. |
Position |
NVarchar (90) |
Position |
|
| 59. |
Address |
NVarchar (254) |
Address |
|
| 60. |
Country |
NVarchar (3) |
Country |
|
| 61. |
Tel1 |
NVarchar (50) |
Telephone 1 |
|
| 62. |
Tel2 |
NVarchar (50) |
Telephone 2 |
|
| 63. |
GENDER |
NVarchar (1) |
Gender |
|
| 64. |
Birthday |
Time Stamp |
Birthday |
|
| 65. |
EnbMenuFlt |
NVarchar (1) |
Enable Forbidden Menu Items |
|
| 66. |
objType |
NVarchar (20) |
Object Type - History |
|
| 67. |
logInstanc |
Integer |
Log Instance - History |
|
| 68. |
userSign |
Smallint |
Creating User - History |
|
| 69. |
createDate |
Time Stamp |
Creation Date - History |
|
| 70. |
userSign2 |
Smallint |
Updating User - History |
|
| 71. |
updateDate |
Time Stamp |
Date of Update - History |
|
| 72. |
OneLogPwd |
NVarchar (1) |
At first logon change password |
|
| 73. |
lastLogin |
Time Stamp |
Last Logon Date |
|
| 74. |
LastPwds |
NClob |
Last Passwords 1 |
|
| 75. |
LastPwds2 |
NVarchar (254) |
Last Passwords 2 |
|
| 76. |
LastPwdSet |
Time Stamp |
Last Password Change |
|
| 77. |
FailedLog |
Integer |
Failed Login Count |
|
| 78. |
PwdNeverEx |
NVarchar (1) |
Password Never Expires |
|
| 79. |
SalesDisc |
Decimal (21, ) |
Max. Sales Discount |
|
| 80. |
PurchDisc |
Decimal (21, ) |
Max. Purchase Discount |
|
| 81. |
LstLogoutD |
Time Stamp |
Last Logoff Date |
|
| 82. |
LstLoginT |
Integer |
Last Logon Time |
|
| 83. |
LstLogoutT |
Integer |
Last Logoff Time |
|
| 84. |
LstPwdChT |
Integer |
Last Password Change Time |
|
| 85. |
LstPwdChB |
NVarchar (8) |
Last Password Changed By |
|
| 86. |
RclFlag |
NVarchar (1) |
Display Recurring Transactions |
|
| 87. |
MobileUser |
NVarchar (1) |
Mobile User |
|
| 88. |
MobileIMEI |
NVarchar (64) |
Mobile IMEI |
|
| 89. |
PrsWkCntEb |
NVarchar (1) |
Personal Work Center Enable |
|
| 90. |
SnapShotId |
Integer |
Snapshot ID |
|
| 91. |
STData |
NVarchar (40) |
User Password Salt |
|
| 92. |
SupportUsr |
NVarchar (1) |
Support User |
|
| 93. |
NoSTPwdNum |
Smallint |
Password encrypted w/o Salt (cryptograph |
|
| 94. |
DomainUser |
NVarchar (50) |
Domain user name bound in SLD |
|
| 95. |
CUSAgree |
NVarchar (1) |
CUS Agreement |
|
| 96. |
EmailSig |
NClob |
E-Mail Signature |
|
| 97. |
TPLId |
Smallint |
Template ID |
|
| 98. |
DigCrtPath |
NClob |
Digital Certificate Path |
|
| 99. |
ShowNewTsk |
NVarchar (1) |
Open Worklist on Task Arrival |
|
| 100. |
IntgrtEb |
NVarchar (1) |
Enable Setting Integration |
|
| 101. |
AllBrnchF |
NVarchar (1) |
Allow Viewing of All (Including Unassign |
|
| 102. |
EvtNotify |
NVarchar (1) |
|
|
| 103. |
IgnDtOwn |
NVarchar (1) |
|
|
| 104. |
EnterAsTab |
NVarchar (1) |
|
|
| 105. |
DotAsSep |
NVarchar (1) |
|
|
| 106. |
MouseOnly |
NVarchar (1) |
|
|
| 107. |
Color |
Smallint |
|
|
| 108. |
SkinType |
NVarchar (254) |
|
|
| 109. |
Font |
NVarchar (50) |
|
|
| 110. |
FontSize |
Integer |
|
|
| 111. |
NaturalPer |
NVarchar (1) |
|
|
| 112. |
DPPStatus |
NVarchar (1) |
|
|
| 113. |
AutoAsnBPL |
NVarchar (1) |
|
|
| 114. |
EncryptIV |
NVarchar (100) |
|
|
| 115. |
HandleEDoc |
NVarchar (1) |
|
|
| 116. |
ShowLicBal |
NVarchar (1) |
|
|
| 117. |
LicBaHDate |
Time Stamp |
|
|
| 118. |
AttachChb |
NVarchar (1) |
|
|
