Freshmark replication server

freshmark-canonical

Program drill-down

DAILY_AGN_BAL

DAILY AGENT BALANCES. Type DSP, base table PALL_TRANS.

Field inventory

24

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 671, 25
  
1 0.0 Label 2 T -1 671, 49
  
1 0.0 Label 3 T -1 621, 25
  
1 0.0 Label 4 T -1 621, 49
  
1 0.0 Label 5 T -1 291, 25
  
1 0.0 Label 6 T -1 1, 25
  
1 0.0 Label 7 T -1 201, 193
  
1 0.0 Label 8 T -1 201, 229
  
1 0.0 Label 9 T -1 201, 265
  
1 0.0 Work 10 I -1 311, 193
$SELECT  S:AGENT_CODE;I\AGENT    $CALCULATE  I:I\AGENT;<>;  DO(LSS)  C:UCASE  F:AGENT_MAST;Y;;T\NAME=AM_NAME;AM_CODE='$I\AGENT$'  DOEND(LSS)
1 0.0 Work 11 I -1 311, 229
  
1 0.0 Work 12 I -1 311, 265
$CALCULATE  O:BACKCOLOR;C\RUN;YELLOW  O:SETFOCUS;C\RUN
1 0.0 Work 13 I 0 1, 133
  
1 0.0 Work 14 I 0 1, 169
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MKT=CM_NAME    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MKT    '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   
1 0.0 CMD 15 C -1 411, 193
$SELECT  S:AGENT_CODE;I\AGENT
1 0.0 CMD 16 C -1 331, 337
$SELECT  I:I\SDATE;=;  D:PLEASE ENTER A START DATE;ERRORM;I\SDATE    I:I\EDATE;=;  D:PLEASE ENTER AN END DATE;ERRORM;I\EDATE    I:I\ORGS;<>;  DO(SLA)    I:I\ORGS;<>;I\AGENT    D:YOU MAY NOT RUN FOR THIS AGENCY;ERRORM;I\AGENT  DOEND(SLA)        A:CONST;IN PROGRESS;T\PROG  E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRI
1 0.0 Label 17 T -1 261, 49
  
1 0.0 Label 18 T -1 441, 193
  
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