Freshmark replication server

freshmark-canonical

Program drill-down

DEL_ARCHIVE_DEBTORS

DELETE ARCHIVE DAILY DEBTORS. Type DSP, base table ANNELISE_BUYERS.

Field inventory

21

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 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 261, 49
  
1 0.0 Label 8 T -1 201, 193
  
1 0.0 Work 9 I -1 311, 193
$SELECT  S:ARCHIVE_DEBTOR;I\DEBTOR    $VALIDATE  m:  I:I\DEBTOR;<>;  F:ANNELISE_BUYERS;;;W\BUYER=ANB_DEBTOR;ANB_DEBTOR='$I\DEBTOR$'  I:W\BUYER;=;  D:THIS BUYER IS NOT ARCHIVED OR DOES NOT EXIST;ERRORM;I\DEBTOR  F:DEBTOR_MAST;Y;;T\NAME=DM_NAME;DM_DEBTOR='$I\DEBTOR$'  'I:I\MAIN_DEBTOR;<>;  'D:ONLY MAIN BUYERS MUST BE ENT
1 0.0 CMD 10 C -1 301, 337
$SELECT  I:I\DEBTOR;=;  D:ENTER ARCHIVED DEBTOR NUMBER;ERRORM;I\DEBTOR    U:ARCHIVE_DAILY_DEBTOR;DELETE_ARCHIVE_DAILY_DEBTOR  A:CONST;;I\DEBTOR,T\NAME,W\BUYER  O:SETFOCUS;I\DEBTOR  
1 0.0 CMD 2 C -1 411, 193
$SELECT  S:ARCHIVE_DEBTOR;I\DEBTOR
1 0.0 Label 1 T -1 451, 193
  
1 0.0 Work 4 I 0 1, 193
$DEFAULT  A:TIME,HH:MM:SS;T\TIME  A:DATE;DD MMM YYYY;T\DATE  A:TIMER_ON;1000    O:SETFOCUS;I\DEBTOR  'O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\DELETE
1 0.0 Work 5 I 0 1, 217
  
1 0.0 Label 6 T -1 1, 25
  
1 0.0 Work 7 I 0 1, 169
$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
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