Home > SyUsers

SyUsers

  • DataSet name: SysUsers
  • Uses the new RulesAPI style
  • Description: System Users
  • Last altered in the 1.5 project.

    • UserPID User Personal Login ID Varchar 80
    CompanyID Company Identifier SmallID 12
    UserCoID Users companyID, if linked BigID 12
    EmpUID Employee Unique ID BigID 12
    UserNam User Name Varchar 40
    UserPwd User Password Varchar 40
    Disabled Disabled Status Flag Varchar 1
    ViewOwn Y=can view own records, N=not Varchar 1
    AdminFlag Y (Global) or N Varchar 1
    Email Email Address Varchar 80
    LstModBy Last Modified By Name Varchar 40
    LstModDate Last Modified Date Date 32
    SMTPFQDomain SMTP Fully Qualified Domain Varchar 120
    LockSeqNbr *SYSTEM* Row Sequence Nbr Long 12