Freshmark replication server

freshmark-canonical

Program drill-down

FLOORSPACE_MAN

FLOORSPACE MAN. Type DSP, base table CLIENT_MAST.

Field inventory

27

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Work 8 I 0 1, 61
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME    'CONVERT ONLY THE FIRST CHARACTER OF THE MARKET LABEL  C:MCASE;;T\MARKET    F:CLIENT_MAST;;;I\FLOOR_SPACE=CM_TOT_HALL_FLR_SPACE;;I\AGENT      O:SETFOCUS;I\FLOOR_SPACE
1 0.0 Work 9 I 0 81, 61
$DEFAULT    A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    '$CALCULATE  'U:ZZGRID_SPLIT;INIT_GRID;G\GRIDM;I\LV_CODE,I\LV_DESC,I\LV_CALC_TYPE,I\LV_RATE,I\LV_MRATE,I\LV_VATCD,I\LV_BOARD  'U:ZZGRID_SPLIT;DB_TO_GRID;G\GRIDM;LEVY_MAST    O:SETFOCUS;I\DA_CODE    '$BEFORE_DELETE  
1 0.0 Label 6 T -1 621, 49
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 Label 5 T -1 291, 49
  
1 0.0 Label 3 T -1 621, 25
  
1 0.0 Label 4 T -1 671, 25
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 1 T -1 1, 25
  
1 0.0 H -1 0, 0
  
1 0.0 Label 3 T 0 31, 169
  
1 0.0 Label 4 T 0 31, 205
  
1 0.0 Label 1 T 0 31, 97
  
1 0.0 Label 2 T -1 31, 133
  
1 0.0 CMD 5 C -1 341, 181
$SELECT    W:CLIENT_MAST;;;CM_TOT_HALL_FLR_SPACE=I\FLOOR_SPACE;;    'A:CONST;;I\FLOOR_SPACE    O:SETFOCUS;I\FLOOR_SPACE  
1 0.0 Label 8 T 0 471, 97
  
1 0.0 Work 9 I -1 331, 133
$VALIDATE    'I:I\FLOOR_SPACE;<>;  'DO(AREA1)  '  O:ENABLEINPUT;I\AREA_NAME,I\AREA_PERC    O:SETFOCUS;B\UPDATE  'DOEND(AREA1)    
1 0.0 Work 6 I 0 331, 97
$SELECT  S:AGENT_CODE;I\AGENT    $VALIDATE  M:    $CALCULATE  C:UCASE    I:I\AGENT;<>;  F:AGENT_MAST;Y;;T\AGENT=AM_NAME,I\FLOOR_SPACE=AM_FLOOR_SPACE;AM_CODE='$I\AGENT$';I\AGENT    I:I\FLOOR_SPACE;<>;    O:ENABLEINPUT;I\AREA_NAME,I\AREA_PERC    
1 0.0 CMD 7 C 0 431, 97
$SELECT  S:AGENT_CODE;I\AGENT
1 0.0 Work 10 I 0 331, 169
  
1 0.0 Work 11 I 0 331, 205
  
1 0.0 Label 12 T 0 471, 169
  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_PRINT Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_EXIT Z 0 0, 0
  
10 0.0 ZX_UPDATE Z 0 0, 0