Freshmark replication server

freshmark-canonical

Program drill-down

MESSAGE_USERS_MAN

MESSAGE USERS MAINTENANCE. Type MDL, base table MESSAGE_USERS.

Field inventory

28

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 5 C -1 101, 229
$SELECT  S:AGENT_CODE;I\SS_AGENT  
1 0.0 CMD 6 C -1 431, 229
$SELECT  $SELECT  'SELECT THE SECTION CODE   S:SLS_SECT_PRT;I\SS_SECT;I\SS_AGENT  
1 0.0 Work 4 G -1 21, 253
  
1 0.0 H -1 0, 30
  
1 0.0 MESSAGE_USERS MU_TYPE I -1 21, 229
'$SELECT  ''SELECT THE AGENT CODE  'S:AGENT_CODE;I\SS_AGENT    $VALIDATE  'MANDATORY FIELD  M:  'CONVERT TO UPPERCASE  C:UCASE  'LOOK UP THE ENTERED CODE ON THE AGENT_MAST TABLE, IF IT DOESNT EXIST DISPLAY AN ERROR.  'F:AGENT_MAST;Y;;I\SS_AGENT=AM_CODE;AM_CODE='$I\SS_AGENT$';I\SS_AGENT  U:ZZGRID_SPLIT;DB_TO_GRID;G\GRID
1 0.0 MESSAGE_USERS MU_USERNAME I -1 461, 229
$VALIDATE  'MANDATORY FIELD  M:  C:UCASE    'I:I\SS_IP;<>;  'F:IP_MAST;Y;;;IM_PORT='$I\SS_IP$';I\SS_IP      
1 0.0 Work 1 I 0 11, 85
  
1 0.0 MESSAGE_USERS MU_SERVER I -1 131, 229
'$SELECT  'SELECT THE SECTION CODE   'S:SLS_SECT_PRT;I\SS_SECT;I\SS_AGENT    $CALCULATE  'MANDATORY FIELD  M:    'CHECKS IF THE ENTERED DATA IS NUMERIC, IF IT IS, IT IS FORMATTED TO '000'  'A:ISNUMERIC;I\SS_SECT;I\TMP1  'I:I\TMP1;=;Y  'A:VAR;I\SS_SECT;I\SS_SECT;;000  'LOOKS UP THE ENTERED CODE ON THE SECT_MAST TABLE. I
1 0.0 Work 14 I 0 41, 61
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MARKET
1 0.0 Work 15 I 0 11, 61
$DEFAULT  'INITIALIZES THE DATE AND TIME INTO THE T\DATE AND T\TIME FIELDS  A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    'INITIALISES THE GRID, AND FILLS IT WITH DATA  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\MU_TYPE,I\MU_SERVER,I\USERNAME  'U:ZZGRID_SPLIT;DB_TO_GRID;G\GRID;SLSSECT_ACCESS  
1 0.0 Work 16 I 0 41, 529
  
1 0.0 Work 1 I 0 441, 277
  
1 0.0 Work 2 I 0 11, 121
  
1 0.0 MESSAGE_USERS MU_TYPE T -1 21, 205
  
1 0.0 SLSSECT_ACCESS SS_IP T -1 451, 205
  
1 0.0 MESSAGE_USERS MU_SERVER T -1 131, 205
  
1 0.0 Label 7 T -1 1, 25
  
1 0.0 Label 8 T -1 291, 25
  
1 0.0 Label 9 T -1 241, 49
  
1 0.0 Label 10 T -1 621, 25
  
1 0.0 Label 11 T -1 671, 25
  
1 0.0 Label 12 T -1 621, 49
  
1 0.0 Label 13 T -1 671, 49
  
10 0.0 ZX_PRINT Z 0 0, 30
  
10 0.0 ZX_SELECT Z 0 0, 30
  
10 0.0 ZX_DELETE Z 0 0, 30
  
10 0.0 ZX_UPDATE Z 0 0, 30
  
10 0.0 ZX_EXIT Z 0 0, 30