Freshmark replication server

freshmark-canonical

Program drill-down

NEW_BANK_REFNO

NEW REFERENCE NUMBERS. Type MAN, base table DEBTOR_MAST.

Field inventory

28

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Label 1 T -1 3, 25
  
1 0.0 Label 2 T -1 350, 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 350, 49
  
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 201, 157
  
1 0.0 Label 9 T -1 201, 193
  
1 0.0 Label 10 T -1 461, 157
$SELECT  S:DEBTOR;I\DM_DEBTOR
1 0.0 DEBTOR_MAST DM_DEBTOR I -1 321, 157
$SELECT  S:DEBTOR;I\DM_DEBTOR    $VALIDATE  A:CONST;;T\PROG  M:    F:DEBTOR_MAST;Y;;T\DM_NAME=DM_NAME;DM_DEBTOR='$I\DM_DEBTOR$';I\DM_DEBTOR    A:LEN;I\DM_DEBTOR;I\LEN  A:SUB;I\LEN2;I\LEN;I\LEN    I:I\LEN;<>;0;NUM  DO(0)    A:ZEROFILL;I\DM_DEBTOR,I\LEN2;I\DEBTOR  DOEND(0)  
1 0.0 Work 12 I -1 321, 193
$CALCULATE  V:1;2    U:BUYER_BANK_REFNO;GENEREATE    O:BACKCOLOR;T\DM_BANK_REFNO;YELLOW  O:SETFOCUS;I\UPDATE
1 0.0 Label 13 T -1 311, 313
  
1 0.0 DEBTOR_MAST DM_MARKET I 0 11, 61
$DEFAULT    'LOAD MARKET CODE  A:ORG;;I\DM_MARKET    '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    '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:CONST
1 0.0 H -1 0, 0
  
1 0.0 Label 18 T -1 201, 277
  
1 0.0 I 0 501, 241
  
1 0.0 Label 20 T -1 201, 229
  
1 0.0 DEBTOR_MAST DM_BANK_REFNO I -1 321, 229
  
1 0.0 CMD 23 C -1 421, 157
  
1 0.0 Work 2 I 0 501, 277
  
1 0.0 Work 3 I 0 501, 313
  
1 1.0 Work 16 I -1 321, 277
$CALCULATE  C:UCASE  V:Y;N    I:I\UPDATE;<>;Y  DO(0)    A:CONST;;I\DEBTOR,I\LEN,I\DM_DEBTOR,T\DM_NAME,I\ACC_ID,I\DM_BANK_REFNO,I\UPDATE    O:SETFOCUS;I\DM_DEBTOR  DOEND(0)    I:I\UPDATE;=;Y  DO(1)    A:CONST;UPDATED SUCCESFULLY;T\PROG    ''U:BUYER_BANK_REFNO;UPDATE    ''A:CONST;;I\DEBTOR,I\LEN,I\DM_DEBTOR,T\DM_NAME,I\A
10 0.0 ZX_UPDATE Z 0 0, 0
'$VALIDATE  'I:I\DM_DEBTOR;=;  'D:BUYER NUMBER IS MANDATORY;ERRORM;I\DM_DEBTOR    'I:I\ACC_ID;=;  'D:ACCOUNT ID IS MANDATORY;ERRORM;I\ACC_ID    'A:CONST;UPDATED SUCCESFULLY;T\PROG  'U:BUYER_BANK_REFNO;UPDATE  'A:CONST;;I\DEBTOR,I\LEN,I\DM_DEBTOR,T\DM_NAME,I\ACC_ID,I\DM_BANK_REFNO,I\UPDATE  'O:SETFOCUS;I\DM_DEBTOR    
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_PRINT Z 0 0, 0
  
10 0.0 ZX_EXIT Z 0 0, 0