Freshmark replication server

freshmark-canonical

Program drill-down

REMOVE_FINPDTE

REMOVE FINAL PAYMENT. Type DSP, base table STK_MAST.

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 1 T -1 1, 25
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 3 T -1 281, 49
  
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 DELCOUNT I 0 11, 109
  
1 0.0 ORGS I 0 31, 73
  
1 0.0 Label 10 T -1 201, 109
  
1 0.0 AGENT I -1 321, 109
$SELECT  S:AGENT_CODE;I\AGENT    $CALCULATE  M:  C:UCASE    'LOOK UP AGENT NAME  F:AGENT_MAST;Y;;T\AGN_NAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT
1 0.0 CMD 12 C -1 441, 109
$SELECT  S:AGENT_CODE;I\AGENT
1 0.0 DELDATE I 0 491, 145
  
1 0.0 MARKET I 0 11, 73
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET  A:ORGS;;I\ORGS    '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\TI
1 0.0 CMD 15 C -1 251, 325
$SELECT  I:I\ORGS;<>;  DO(AGC)    I:I\AGENT;<>;I\ORGS    D:AGENT SELECTED DOES NOT MATCH AGENT LOGGED IN!;ERRORM;I\DELIVNO  DOEND(AGC)    'CHECK THAT THE DELIVERY NUMBER EXISTS  F:STK_MAST;Y;;;SM_MARKET='$I\MARKET$' AND SM_AGENT = '$I\AGENT$' AND SM_DELNO = '$I\DELIVNO$';I\DELIVNO    F:STK_MAST;;;I\FINPDTE=SM_FINPDTE;S
1 0.0 Label 16 T -1 301, 361
  
1 0.0 Label 17 T -1 91, 229
  
1 0.0 Label 18 T -1 201, 145
  
1 0.0 CMD 19 C -1 441, 145
$SELECT  S:DELIVERY_FINS;I\DELIVNO;I\AGENT  A:SELPARM;2;I\DELDATE  
1 0.0 DELIVNO I -1 321, 145
$SELECT  S:DELIVERY_FINS;I\DELIVNO;I\AGENT  A:SELPARM;2;I\DELDATE    $CALCULATE  M:  A:VAR;I\DELIVNO;I\DELIVNO;;000000    'CHECK THAT THE DELIVERY NUMBER EXISTS  F:STK_MAST;Y;;;SM_MARKET='$I\MARKET$' AND SM_AGENT = '$I\AGENT$' AND SM_DELNO = '$I\DELIVNO$';I\DELIVNO    '!!!!!!!!!  'JDJDJDJDJ  '!!!!!!!!!  U:CONSIGNMENT_E
1 0.0 Label 21 T -1 491, 109
  
1 0.0 Label 22 T -1 11, 253
  
1 0.0 FINPDTE I 0 601, 145
  
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