Freshmark replication server

freshmark-canonical

Program drill-down

AGN_CLASSIF_MAN

AGENT CLASSIFICATIONS MAINTENANCE. Type MAN, base table AGENT_MAST.

Field inventory

28

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 H -1 0, 0
  
1 0.0 Label 1 T -1 1, 25
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 3 T -1 241, 49
  
1 0.0 Label 4 T -1 621, 25
  
1 0.0 Label 5 T -1 671, 25
  
1 0.0 Label 6 T -1 621, 49
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 Label 8 T -1 181, 169
  
1 0.0 AGENT_MAST AM_RACE D -1 301, 169
$DEFAULT  'ADD ITEMS INTO THE COMBOBOX  B:ADDITEM;D\RACE;WHITE,BLACK,INDIAN,COLOURED,OTHER    $VALIDATE    'UPPERCASE  C:UCASE
1 0.0 AGENT_MAST AM_GENDER D -1 301, 205
$DEFAULT  'ADD ITEMS INTO THE COMBOBOX  B:ADDITEM;D\GENDER;M,F    $VALIDATE    'UPPERCASE  C:UCASE
1 0.0 Label 11 T -1 181, 205
  
1 0.0 AGENT_MAST AM_CTYPE D -1 301, 241
$DEFAULT  'ADD ITEMS INTO THE COMBOBOX  B:ADDITEM;D\CTYPE;CLOSE CORP,TRADING AS        $VALIDATE    'UPPERCASE  C:UCASE  
1 0.0 Label 14 T -1 181, 241
  
1 0.0 I 0 1, 61
$DEFAULT    'LOAD MARKET CODE  A:ORG;;I\MARKET  A:ORGS;;I\ORGS    '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    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MARKET    'INITIALIZES THE DATE AND TIME 
1 0.0 Work 16 I 0 31, 61
$DEFAULT  A:DATE;DD MMM YYYY;T\DATE  'A:DATE;DD MMM YYYY;I\FROMDATE  'A:DATE;DD MMM YYYY;I\TODATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000      $DEFAULT  A:ORGS;;I\ORGS    I:I\ORGS;<>;  DO(SQS)    A:VAR;I\ORGS;I\AGENT    O:DISABLEINPUT;I\AGENT    O:DISABLEINPUT;C\AGN    F:AGENT_MAST;;;T\AGN_NAME=AM_NAME;AM_CODE = '$I\O
1 0.0 AGENT_MAST AM_CODE I -1 301, 133
$SELECT  S:AGENT_CODE;I\AGENT    $CALCULATE  C:UCASE  M:  I:I\AGENT;<>;  F:AGENT_MAST;Y;;T\AGN_NAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT
1 0.0 CMD 20 C -1 401, 133
$SELECT  S:AGENT_CODE;I\AGENT
1 0.0 Label 22 T -1 451, 133
  
1 0.0 Label 17 T -1 181, 133
  
1 0.0 I 0 441, 241
  
1 0.0 AGENT_MAST AM_BEE D -1 561, 169
$DEFAULT  'ADD ITEMS INTO THE COMBOBOX  B:ADDITEM;D\STATUS;1,2,3,4,5,6,7,8  
1 0.0 Label 2 T -1 451, 169
  
10 0.0 ZX_PRINT Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_UPDATE Z 0 0, 0
  
10 0.0 ZX_EXIT Z 0 0, 0