Home > Technical > Table Definitions > USERCODE

USERCODE

Column

Type

Description

STRUSERCODE

VARCHAR(20)

 

STRUSERNAME

VARCHAR(50)

 

INTLEVEL

INT

 

INTUSERCODE

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)