Freshmark replication server

freshmark-canonical

Program drill-down

USERIP_MAN

USER IP MAINTENANCE. Type MAN, base table ZU_USER.

Field inventory

84

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 6 C 0 421, 265
$SELECT  S:AGENT_MAST;I\ZU_AGENT    
1 0.0 ZU_USER ZU_LOCAL_IP3 I -1 371, 361
  
1 0.0 ZU_USER ZU_USER_LANG I -1 531, 109
'$SELECT  'S:ZZ_LANG;I\ZU_USER_LANG    '$VALIDATE  'I:I\ZU_USER_LANG;<>;  'F:ZZ_LANGUAGE;Y;ZZ_KEY;T\DESC=ZZ_DESC;ZZ_TYPE = 'LNG'    'CHANGE TEXT CASE TO UPPER CASE  'C:UCASE
1 0.0 ZU_USER ZU_WEB_PASSWORD I 0 11, 493
  
1 0.0 ZU_USER ZU_SECURITY_LEVEL I 0 241, 493
$AFTER_READ  A:CONST;5;I\ZU_SECURITY_LEVEL
1 0.0 CMD 2 C 0 531, 85
  
1 0.0 EDIT C 0 611, 457
$SELECT  I:I\ZU_USERID;<>;  E:$GBLROOT$WINDOWS\NOTEPAD.EXE $GBLROOT$LEGEND\PROJ_FMS\INI\$I\ZU_USERID$\FMS.INI  
1 0.0 CMD 8 C 0 221, 325
$SELECT  S:ZC_SEC_GROUP;I\ZU_ZC  $VALIDATE  C:UCASE  F:  M:
1 0.0 CMD 7 C -1 261, 109
$SELECT  S:ZU_USER;I\ZU_USERID
1 0.0 H -1 1, 1
X
1 0.0 ZU_USER ZU_LOCAL_IP5 I -1 371, 397
  
1 0.0 ZU_USER ZU_LEVEL I 0 241, 517
$AFTER_READ  A:CONST;5;I\ZU_LEVEL  
1 0.0 CMD 5 C 0 271, 265
  
1 0.0 ZU_USER ZU_LOCAL_IP4 I -1 591, 361
  
1 0.0 ZU_USER ZU_LOCAL_IP2 I -1 591, 325
  
1 0.0 ZU_USER ZU_LOCAL_IP I -1 371, 325
  
1 0.0 ZU_USER ZU_BLOCKED I 0 291, 493
  
1 0.0 ZU_USER ZU_GUID I 0 681, 157
  
1 0.0 RESET_WEB_PW I 0 141, 433
$DEFAULT  A:CONST;N;I\RESET_WEB_PW    $VALIDATE  C:UCASE  V:Y;N;    $BEFORE_WRITE  I:I\RESET_WEB_PW;=;Y  A:CMD5;DEFAULT;I\ZU_WEB_PASSWORD    
1 0.0 TERMID I -1 531, 169
  
1 0.0 Work 2 I 0 681, 133
  
1 0.0 Work 3 I 0 681, 97
  
1 0.0 ZU_USER ZU_NAME I -1 101, 217
'CHANGE TEXT CASE TO UPPER CASE  $VALIDATE  C:UCASE
1 0.0 ZU_USER ZU_INITIALS I -1 101, 265
'CHANGE TEXT CASE TO UPPER CASE  $VALIDATE  C:UCASE
1 0.0 ZU_USER ZU_SURNAME I -1 101, 169
'CHANGE TEXT CASE TO UPPER CASE  $VALIDATE  C:UCASE
1 0.0 ZU_USER ZU_PRINTER_TYPE I -1 531, 217
$VALIDATE  C:UCASE    I:I\ZU_PRINTER_TYPE;=;  A:CONST;C;I\ZU_PRINTER_TYPE    V:C;E
1 0.0 ZU_USER ZU_USERID I -1 101, 109
$SELECT  S:ZU_USER    $VALIDATE  M:  C:UCASE  A:CONST;;T\DESC    F:ZU_USER;Y;;I\ZU_USER_LANG=ZU_USER_LANG,I\ZU_PW_EXPIRY=ZU_PW_EXPIRY;ZU_USERID='$I\ZU_USERID$';I\ZU_USERID    I:I\ZU_USER_LANG;<>;  F:ZZ_LANGUAGE;;;T\DESC=ZZ_DESC;ZZ_KEY = '$I\ZU_USER_LANG$'    $AFTER_READ    'ADDED BY JD 20140602 - TO DEFAULT A VALUE TO 
1 0.0 ZU_USER ZU_MARKET I -1 271, 265
'$CALCULATE  'C:UCASE  'F:CLIENT_MAST;Y;;T\MARKET=CM_NAME;CM_CODE='$I\ZU_MARKET$'    
1 0.0 ZU_USER ZU_AGENT I -1 431, 265
$SELECT  S:AGENT_MAST_MKT;I\ZU_AGENT;I\ZU_MARKET    'CHANGE TEXT CASE TO UPPER CASE  '$VALIDATE  'C:UCASE    '$CALCULATE  'I:I\ZU_AGENT;<>;  'F:AGENT_MAST;Y;AM_CODE;T\AGENT=AM_NAME;AM_MARKET='$I\ZU_MARKET$';I\ZU_AGENT    'I:I\ZU_AGENT;=;  'A:CONST;;T\AGENT  
1 0.0 Label 7 T -1 11, 25
  
1 0.0 ZU_USER ZU_EMAIL T 0 11, 433
  
1 0.0 Label 3 T -1 181, 265
  
1 0.0 Label 4 T -1 341, 265
  
1 0.0 Label 8 T -1 481, 265
  
1 0.0 ZU_USER ZU_LEVEL T 0 71, 517
  
1 0.0 ZU_USER ZU_SECURITY_LEVEL T 0 31, 493
  
1 0.0 DESC T -1 591, 109
  
1 0.0 ZU_USER ZU_USER_LANG T -1 431, 109
  
1 0.0 Label 1 T -1 491, 325
  
1 0.0 Label 2 T -1 271, 361
  
1 0.0 Label 3 T -1 491, 361
  
1 0.0 Label 4 T -1 271, 397
  
1 0.0 ZU_USER ZU_LOCAL_IP T -1 271, 325
  
1 0.0 ZU_USER ZU_PW_EXPIRY T 0 261, 433
X
1 0.0 Label 1 T 0 11, 433
  
1 0.0 ZU_USER ZU_PASSWORD T 0 511, 433
X
1 0.0 Label 1 T -1 431, 169
  
1 0.0 Label 2 T 0 1, 433
X
1 0.0 Label 1 T 0 671, 97
X
1 0.0 ZU_USER ZU_SHORTCUT T 0 11, 433
X
1 0.0 ZU_USER ZU_STATUS T 0 171, 433
X
1 0.0 ZU_USER ZU_ZC T -1 11, 325
X
1 0.0 Label 9 T -1 11, 481
X
1 0.0 ZU_USER ZU_NAME T -1 11, 217
X
1 0.0 ZU_USER ZU_INITIALS T -1 11, 265
X
1 0.0 ZU_USER ZU_SURNAME T -1 11, 169
X
1 0.0 ZU_USER ZU_USERID T -1 11, 109
X
1 0.0 ZU_USER ZU_PRINTER_TYPE T -1 431, 217
  
1 0.0 Label 2 T -1 571, 217
  
1 0.0 Work 8 I 0 41, 61
  
1 0.0 Label 5 T -1 291, 25
  
1 0.0 Label 1 T -1 621, 25
  
1 0.0 Work 7 I 0 11, 61
$DEFAULT  A:ORG;;I\ORG  A:ORGS;;I\ORGS  F:CLIENT_MAST;;;T\MARKET=CM_NAME;CM_CODE='$I\ORG$'  A:CONST;N;I\ZU_BLOCKED    A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME    A:VAR;I\ORG;I\ZU_MARKET    I:I\ORGS;<>;  A:VAR;I\ORGS;I\ZU_AGENT    I:I\ZU_AGENT;<>;  F:AGENT_MAST;;;T\AGENT=AM_NAME;AM_MARKET='$I\ZU_MARKET$' AND AM
1 0.0 Label 2 T -1 671, 25
  
1 0.0 Label 3 T -1 621, 49
  
1 0.0 Label 4 T -1 671, 49
  
1 0.0 Label 6 T -1 291, 49
  
1 1.0 ZU_USER ZU_EMAIL I 0 151, 433
  
1 1.0 ZU_USER ZU_PW_EXPIRY I 0 441, 433
X
1 1.0 ZU_USER ZU_PASSWORD I 0 601, 433
$BEFORE_WRITE  I:I\RESET_PW;=;Y    DO      A:CONST;DEFAULT;I\ZU_PASSWORD    DOEND  $AFTER_WRITE  I:I\RESET_PW;=;Y    DO      D:PASSWORD HAS BEEN SET TO DEFAULT!    DOEND
1 1.0 Work 3 I 0 141, 433
$VALIDATE  C:UCASE  V:Y;  $AFTER_WRITE  I:I\RESET_PW;=;"Y"    A:SETPW;I\ZU_USERID;I\ZU_PASSWORD
1 1.0 ZU_USER ZU_SHORTCUT I 0 11, 457
$SELECT  S:ZU_MENU
1 1.0 ZU_USER ZU_STATUS I 0 231, 433
$VALIDATE  C:UCASE  V:;D;T;A;S
1 1.0 ZU_USER ZU_ZC I -1 101, 325
$SELECT  S:ZC_SEC_GROUP;I\ZU_ZC  '$VALIDATE  'F:ZC_SEC_GROUP;Y;ZC_KEY;T\ZU_ZC_DESC=ZC_DESC  '$AFTER_READ  'F:ZC_SEC_GROUP;;ZC_KEY;T\ZU_ZC_DESC=ZC_DESC    'CHANGE TEXT CASE TO UPPER CASE  $VALIDATE  C:UCASE
10 0.0 ZX_EXIT Z 0 1, 1
X
10 0.0 ZX_UPDATE Z 0 1, 1
'$UPDATE  'U:ZZCREATE_USER;INI;I\ZU_USERID  
10 0.0 ZX_DELETE Z 0 1, 1
X
10 0.0 zzExit Z 0 1, 1
X
10 0.0 zzPrint Z 0 1, 1
X
10 0.0 ZX_PRINT Z 0 1, 1
X
10 0.0 ZX_SELECT Z 0 1, 1
X
10 0.0 zzUpdate Z 0 1, 1
X
10 0.0 zzDelete Z 0 1, 1
X
10 0.0 zzSelect Z 0 1, 1
X