Home > Technical > Table Definitions > USERCODE
Column |
Type |
Description |
VARCHAR(20) |
|
|
STRUSERNAME |
VARCHAR(50) |
|
INTLEVEL |
INT |
|
INT |
|
|
STRMANAGEMENTAREA |
VARCHAR(10) |
|
STRPASSWORD |
VARCHAR(50) |
|
STRCOMMCODE |
VARCHAR(10) |
|
STREMAIL |
VARCHAR(100) |
|
YSNACTIVE |
VARCHAR(1) |
|
STRPAYROLLCODE |
VARCHAR(30) |
|
YSNWORKSUNDAY |
VARCHAR(1) |
|
YSNWORKMONDAY |
VARCHAR(1) |
|
YSNWORKTUESDAY |
VARCHAR(1) |
|
YSNWORKWEDNESDAY |
VARCHAR(1) |
|
YSNWORKTHURSDAY |
VARCHAR(1) |
|
YSNWORKFRIDAY |
VARCHAR(1) |
|
YSNWORKSATURDAY |
VARCHAR(1) |
|
STRROSTERCOMMENT |
VARCHAR(200) |
|
YSNLOADCOST |
VARCHAR(1) |
|
INTCHANGEFLAG |
INT |
|
INTNEWFLAG |
INT |
|
INTMENUCODE |
INT |
|
STRPHONE |
VARCHAR(20) |
|
STRFAX |
VARCHAR(20) |
|
STRMOBILE |
VARCHAR(20) |
|
STRTRADECODE |
VARCHAR(10) |
|
STRPOSNAME |
VARCHAR(50) |
|
DTMBIRTHDAY |
DATETIME |
|
STRPOSPASSWORD |
VARCHAR(20) |
|
STRBUYERCODE |
VARCHAR(10) |
|
INTPOAUTHLEVEL |
INTEGER |
Authorisation level for purchase orders. |
Primary Key: STRUSERCODE
Converted from CHM to HTML with chm2web Pro 2.85 (unicode) |