ADD FIELD "SelfHdl" OF "ZUser" AS character
FORMAT "X(36)"
INITIAL ""
POSITION 2
MAX-WIDTH 40
ORDER 10
MANDATORY
ADD FIELD "SelfDesc" OF "ZUser" AS character
FORMAT "X(50)"
INITIAL ""
POSITION 3
MAX-WIDTH 100
ORDER 20
ADD FIELD "UserShort" OF "ZUser" AS character
DESCRIPTION "Shortname of User"
FORMAT "X(10)"
INITIAL ""
POSITION 4
MAX-WIDTH 20
ORDER 60
MANDATORY
ADD FIELD "UserName" OF "ZUser" AS character
DESCRIPTION "Name of user"
FORMAT "X(40)"
INITIAL ""
POSITION 5
MAX-WIDTH 80
ORDER 70
ADD FIELD "Password" OF "ZUser" AS character
FORMAT "X(16)"
INITIAL ""
POSITION 6
MAX-WIDTH 32
ORDER 80
MANDATORY
ADD FIELD "GroupHdl" OF "ZUser" AS character
DESCRIPTION "Handle of the group the user belongs to"
FORMAT "X(36)"
INITIAL ""
POSITION 7
MAX-WIDTH 40
ORDER 90
ADD FIELD "Position" OF "ZUser" AS character
DESCRIPTION "Job-position of the user"
FORMAT "X(128)"
INITIAL ""
POSITION 8
MAX-WIDTH 60
ORDER 100
ADD FIELD "Phone" OF "ZUser" AS character
DESCRIPTION "Phone number of the user"
FORMAT "X(15)"
INITIAL ""
POSITION 9
MAX-WIDTH 30
ORDER 110
ADD FIELD "LangHdl" OF "ZUser" AS character
FORMAT "X(36)"
INITIAL ""
POSITION 10
MAX-WIDTH 40
ORDER 120
ADD FIELD "ClientHdl" OF "ZUser" AS character
DESCRIPTION "The client to which this record belongs. Every record access which does not use a handle must specify this field"
FORMAT "X(36)"
INITIAL ""
POSITION 11
MAX-WIDTH 40
ORDER 130
ADD FIELD "SelfKey" OF "ZUser" AS character
DESCRIPTION "The key which is used to select a record. Usually the key together with the ClientHdl uniquely identifies a record"
FORMAT "X(8)"
INITIAL ""
LABEL "Key"
POSITION 12
MAX-WIDTH 16
COLUMN-LABEL "Key"
HELP "Please enter a unique key"
ORDER 140
MANDATORY
ADD FIELD "RevCounter" OF "ZUser" AS character
DESCRIPTION "Counter which identifies every changed data with a new revision number."
FORMAT "x(15)"
INITIAL ""
LABEL "Revision"
POSITION 13
MAX-WIDTH 16
HELP "Revision counter"
ORDER 1
ADD FIELD "UserCreatedHdl" OF "ZUser" AS character
DESCRIPTION "The user who created this record"
FORMAT "X(36)"
INITIAL ""
LABEL "User created"
POSITION 14
MAX-WIDTH 40
HELP "User who created this record"
ORDER 2
ADD FIELD "UserChangedHdl" OF "ZUser" AS character
DESCRIPTION "The user who changed this record last"
FORMAT "X(36)"
INITIAL ""
LABEL "User last changed"
POSITION 15
MAX-WIDTH 40
HELP "User who changed this record last"
ORDER 3
ADD FIELD "DateCreated" OF "ZUser" AS date
DESCRIPTION "Date this record has been created"
FORMAT "99.99.9999"
INITIAL "TODAY"
LABEL "Date created"
POSITION 16
MAX-WIDTH 4
COLUMN-LABEL "Date created"
HELP "Date this record has been created"
ORDER 4
ADD FIELD "DateChanged" OF "ZUser" AS date
DESCRIPTION "Date last change of this record"
FORMAT "99.99.9999"
INITIAL "TODAY"
LABEL "Date changed"
POSITION 17
MAX-WIDTH 4
COLUMN-LABEL "Date changed"
HELP "Date last change of this record"
ORDER 5
ADD FIELD "TimeUnitCreated" OF "ZUser" AS decimal
DESCRIPTION "Days from 30.12.1899 to time the record was created. Whole part: The number of days since 30.12.1899. Fractional part: Time expressed as a fraction of a day."
FORMAT "zz,zz9.9999999999"
INITIAL "0"
LABEL "Time created"
POSITION 18
MAX-WIDTH 17
COLUMN-LABEL "Time created"
HELP "Days from 30.12.1899 to creating"
DECIMALS 10
ORDER 6
ADD FIELD "TimeUnitChanged" OF "ZUser" AS decimal
DESCRIPTION "Days from 30.12.1899 to time last change of the record. Whole part: The number of days since 30.12.1899. Fractional part: Time expressed as a fraction of a day."
FORMAT "zz,zz9.9999999999"
INITIAL "0"
LABEL "Time changed"
POSITION 19
MAX-WIDTH 17
COLUMN-LABEL "Time changed"
HELP "Days from 30.12.1899 to last change"
DECIMALS 10
ORDER 7
ADD FIELD "UserRights" OF "ZUser" AS integer
DESCRIPTION "User rights (0=Ordinary user,8=Administrator customer,9=Axilon Administrator with all rights)
"
FORMAT "9"
INITIAL "0"
LABEL "User rights"
POSITION 20
MAX-WIDTH 4
COLUMN-LABEL "Rights"
HELP "User rights (0=Ordinary,8=Admin custom,9=Admin Ax)"
ORDER 150
ADD FIELD "Deleted" OF "ZUser" AS logical
DESCRIPTION "Deleted user"
FORMAT "yes/no"
INITIAL "no"
LABEL "Deleted"
POSITION 21
MAX-WIDTH 1
HELP "Deleted user"
ORDER 160
ADD FIELD "SiteHdl" OF "ZUser" AS character
DESCRIPTION "Site of system data"
FORMAT "X(36)"
INITIAL ""
LABEL "Site"
POSITION 22
MAX-WIDTH 40
HELP "Site"
ORDER 170
ADD FIELD "Fax" OF "ZUser" AS character
FORMAT "x(20)"
INITIAL ""
POSITION 23
MAX-WIDTH 40
ORDER 180
ADD FIELD "eMail" OF "ZUser" AS character
FORMAT "X(50)"
INITIAL ""
LABEL "eMail"
POSITION 24
MAX-WIDTH 100
ORDER 190
ADD FIELD "canLogin" OF "ZUser" AS logical
FORMAT "yes/no"
INITIAL "no"
POSITION 25
MAX-WIDTH 1
ORDER 200
ADD FIELD "Misc1" OF "ZUser" AS character
FORMAT "x(80)"
INITIAL ""
POSITION 26
MAX-WIDTH 160
ORDER 210
ADD FIELD "Misc2" OF "ZUser" AS character
FORMAT "x(80)"
INITIAL ""
POSITION 27
MAX-WIDTH 160
ORDER 220
ADD FIELD "Misc3" OF "ZUser" AS character
FORMAT "x(80)"
INITIAL ""
POSITION 28
MAX-WIDTH 160
ORDER 230
ADD FIELD "GroupUser" OF "ZUser" AS character
FORMAT "x(20)"
INITIAL ""
POSITION 29
MAX-WIDTH 40
ORDER 240
ADD FIELD "LinkedToHdl" OF "ZUser" AS character
FORMAT "X(36)"
INITIAL ""
POSITION 30
MAX-WIDTH 40
ORDER 250
ADD FIELD "Linkedto2Hdl" OF "ZUser" AS character
FORMAT "X(36)"
INITIAL ""
POSITION 31
MAX-WIDTH 40
ORDER 260
ADD FIELD "isExternal" OF "ZUser" AS logical
FORMAT "yes/no"
INITIAL "no"
POSITION 32
MAX-WIDTH 1
ORDER 270
ADD FIELD "Organisation" OF "ZUser" AS character
FORMAT "x(20)"
INITIAL ""
POSITION 33
MAX-WIDTH 40
ORDER 280
ADD FIELD "isHidden" OF "ZUser" AS logical
FORMAT "yes/no"
INITIAL "no"
POSITION 34
MAX-WIDTH 1
ORDER 290
ADD FIELD "startupScreen" OF "ZUser" AS character
FORMAT "x(20)"
INITIAL ""
POSITION 35
MAX-WIDTH 40
ORDER 300
ADD FIELD "isActive" OF "ZUser" AS logical
FORMAT "yes/no"
INITIAL "no"
LABEL "Active"
POSITION 36
MAX-WIDTH 1
ORDER 310
ADD FIELD "isLocked" OF "ZUser" AS logical
FORMAT "yes/no"
INITIAL "no"
LABEL "Locked"
POSITION 37
MAX-WIDTH 1
ORDER 320
ADD FIELD "validLoginOptions" OF "ZUser" AS character
FORMAT "x(50)"
INITIAL ""
LABEL "Login options"
POSITION 38
MAX-WIDTH 100
ORDER 330
ADD FIELD "lastLogin" OF "ZUser" AS datetime-tz
FORMAT "99/99/9999 HH:MM:SS.SSS+HH:MM"
INITIAL ?
LABEL "Last login"
POSITION 39
MAX-WIDTH 12
ORDER 340
ADD FIELD "lastLoginLocation" OF "ZUser" AS character
FORMAT "x(20)"
INITIAL ""
LABEL "Last login location"
POSITION 40
MAX-WIDTH 40
ORDER 350
ADD FIELD "validLoginDomains" OF "ZUser" AS character
FORMAT "x(20)"
INITIAL ""
POSITION 41
MAX-WIDTH 40
ORDER 360
ADD FIELD "akTimeCreated" OF "ZUser" AS datetime-tz
FORMAT "99/99/9999 HH:MM:SS.SSS+HH:MM"
INITIAL "NOW"
LABEL "Time created"
POSITION 42
MAX-WIDTH 12
ORDER 370
ADD FIELD "akTimeChanged" OF "ZUser" AS datetime-tz
FORMAT "99/99/9999 HH:MM:SS.SSS+HH:MM"
INITIAL "NOW"
LABEL "Last change"
POSITION 43
MAX-WIDTH 12
ORDER 380
ADD FIELD "representativeHdl" OF "ZUser" AS character
FORMAT "X(36)"
INITIAL ""
LABEL "Representative"
POSITION 44
MAX-WIDTH 40
ORDER 390
ADD FIELD "SuperiorHdl" OF "ZUser" AS character
FORMAT "X(36)"
INITIAL ""
LABEL "Superior"
POSITION 45
MAX-WIDTH 40
ORDER 400