Freshmark replication server

freshmark-canonical

Program drill-down

CS_DEP_MONTLHLY_BAL

CS DEPOSITORS MONTHLY BALANCES. Type DSP, base table TROLLEY_MAST.

Field inventory

27

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
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 621, 25
  
1 0.0 Label 4 T -1 671, 25
  
1 0.0 Label 5 T -1 621, 49
  
1 0.0 Label 6 T -1 671, 49
  
1 0.0 Label 7 T -1 171, 49
  
1 0.0 Label 8 T -1 251, 157
  
1 0.0 Label 9 T -1 251, 193
  
1 0.0 Label 10 T -1 251, 229
  
1 0.0 Label 11 T -1 301, 337
  
1 0.0 Work 12 I -1 371, 157
$SELECT  S:CS_BUYERS;I\BUYER  $VALIDATE  A:CONST;;T\PROG  A:CONST;;T\NAME  I:I\BUYER;<>;  DO(01)   F:DEBTOR_MAST;Y;;W\BUYER=DM_DEBTOR,T\NAME=DM_NAME,W\ACCTYPE=DM_ACCTYPE;DM_DEBTOR='$I\BUYER$';I\BUYER   I:W\ACCTYPE;<>;SU   D:BUYER $I\BUYER$ IS NOT A COLD STORAGE BUYER;ERRORM;I\BUYER   I:W\BUYER;=;8500   D:BUYER $I\BUYER
1 0.0 Work 13 I -1 371, 193
  
1 0.0 Work 14 I -1 371, 229
$VALIDATE  I:I\EDDATE;=;  DO(02)    A:DATE;DD MMM YYYY;I\STDATE    A:DATE;DD MMM YYYY;I\EDDATE  DOEND(02)  O:SETFOCUS;C\RUN  O:BACKCOLOR;C\RUN;YELLOW
1 0.0 Work 15 I 0 11, 97
$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
1 0.0 Work 16 I 0 11, 133
'DISPLAYING TIME  $DEFAULT  A:DATE;DD MMM YYYY;T\DATE  A:DATE;DD MMM YYYY;I\STDATE  A:DATE;DD MMM YYYY;I\EDDATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000
1 0.0 CMD 17 C -1 301, 313
$SELECT  A:CONST;COLLECTING DATA . . . . .;T\PROG  E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_CS_DEP_MONTHLY_BALANCES_COPY;$I\MARKET$,$I\BUYER$,$I\STDATE$,$I\EDDATE$,S  A:CONST;DONE COLLECTING DATA . . . . .;T\PROG  A:CONST;;I\BUYER,T\NAME  O:SETFOCUS;I\BUYER  A:DATE;DD MMM YYYY;I\STDATE  A:DATE;DD MMM YY
1 0.0 H -1 0, 0
  
1 0.0 CMD 2 C -1 471, 157
$SELECT    S:CS_BUYERS;I\BUYER
1 0.0 Work 3 I 0 11, 157
  
1 0.0 Label 1 T -1 501, 157
  
1 0.0 Work 4 I 0 11, 181
  
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