Freshmark replication server

freshmark-canonical

Program drill-down

USE_FULL_AV_BALL

USE FULL AVAILABLE BALANCE. Type DSP, base table DEBTOR_MAST.

Field inventory

23

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 3 C -1 401, 157
$SELECT  S:MAIN_BUYER;I\BUYER  
1 0.0 CMD 7 C -1 321, 229
$SELECT    'W:DEBTOR_MAST;;;DM_SET_LIM_PASS=I\PASSWORD;DM_DEBTOR='$I\BUYER$' AND (DM_MAIN_DEBTOR = '' OR DM_MAIN_DEBTOR IS NULL)  'U_UPDATE_LIMITS      U:UPDATE_LIMITS;FULL      A:CONST;;I\BUYER,I\USE_FULL,T\BUYER      O:SETFOCUS;I\BUYER  
1 0.0 H -1 0, 0
  
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    O:SETFOCUS;I\BUYER  
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 Work 2 I -1 301, 157
$SELECT  S:MAIN_BUYER;I\BUYER    $VALIDATE  M:    C:UCASE  I:I\BUYER;<>;  DO(A)    F:DEBTOR_MAST;Y;;I\MAIN_DEBTOR=DM_MAIN_DEBTOR,T\BUYER=DM_NAME;DM_DEBTOR='$I\BUYER$';I\BUYER  DOEND(A)    I:I\MAIN_DEBTOR;<>;    D:THIS IS NOT A MAIN DEBTOR;ERRORM;I\DT_DEBTOR    
1 0.0 Work 6 I -1 301, 193
$VALIDATE    C:UCASE    I:I\USE_FULL;=;    A:CONST;N;I\USE_FULL    V:Y;N  M:      O:SETFOCUS;C\UPD  O:BACKCOLOR;C\UPD;YELLOW        
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 271, 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 Label 1 T -1 21, 157
  
1 0.0 Label 4 T -1 441, 157
  
1 0.0 Label 5 T -1 21, 193
  
1 0.0 Work 1 I 0 551, 157
  
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