Freshmark replication server

freshmark-canonical

Program drill-down

ABSA_LOAN_TFR

ABSA LOAN TRANSFER. Type DSP, base table ADDR_TYPE.

Field inventory

29

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 3 T -1 311, 49
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 1 T -1 1, 25
  
1 0.0 Label 4 T -1 621, 25
  
1 0.0 Label 5 T -1 671, 25
  
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 231, 121
  
1 0.0 OLD_BUYER I -1 341, 121
$SELECT  S:ABSA_DEBTOR;I\OLD_BUYER;I\MARKET    $CALCULATE  M:  C:UCASE    F:DEBTOR_MAST;Y;;I\OLD_ABSA=DM_ABSA_ACC,T\OLD_NAME=DM_NAME;DM_MARKET='$I\MARKET$' AND DM_DEBTOR='$I\OLD_BUYER$';I\OLD_BUYER  I:I\OLD_ABSA;<>;Y  D:MUST BE AN ABSA BUYER!;ERRORM;I\OLD_BUYER    'MUST HAVE LOAN AMOUNTS  F:ABSA_LOAN_TRANS;;;I\LOAN=ABL
1 0.0 CMD 10 C -1 451, 121
  
1 0.0 Label 11 T -1 491, 121
  
1 0.0 Label 12 T -1 231, 157
  
1 0.0 NEW_BUYER I -1 341, 157
$SELECT  S:ABSA_DEBTOR;I\NEW_BUYER;I\MARKET    $CALCULATE  M:  C:UCASE    'CHECK DEBTOR EXISTS  F:DEBTOR_MAST;Y;;I\ACCTYPE=DM_ACCTYPE,I\MAIN_DEBTOR=DM_MAIN_DEBTOR,I\NEW_ABSA=DM_ABSA_ACC,T\NEW_NAME=DM_NAME;DM_MARKET='$I\MARKET$' AND DM_DEBTOR='$I\NEW_BUYER$';I\NEW_BUYER    I:I\MAIN_DEBTOR;<>;  D:MUST BE A MAIN BUYER!;ER
1 0.0 CMD 14 C -1 451, 157
  
1 0.0 Label 15 T -1 491, 157
  
1 0.0 Label 16 T -1 291, 265
  
1 0.0 CMD 17 C -1 341, 229
$SELECT  '============================  'BUYER FIELDS CANNOT BE BLANK  '============================  I:I\OLD_BUYER;=;  D:PLEASE ENTER A BUYER NUMBER.;ERRORM;I\OLD_BUYER    I:I\NEW_BUYER;=;  D:PLEASE ENTER A BUYER NUMBER.;ERRORM;I\NEW_BUYER          '=====================================================  'BUYERS MUST E
1 0.0 Work 18 I 0 1, 61
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\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
1 0.0 Work 1 I 0 601, 121
  
1 0.0 Work 2 I 0 621, 121
  
1 0.0 Work 3 I 0 601, 157
  
1 0.0 Work 5 I 0 641, 157
  
1 0.0 Work 4 I 0 621, 157
  
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