Freshmark replication server

freshmark-canonical

Program drill-down

PED_DELETION

PED DELETION. Type DSP, base table FM_PED_MAST.

Field inventory

112

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 5 C 0 311, 517
$SELECT  I:I\TRNTYPE;<>;  DO(CHK)    A:CRLF;I\TMP;I\TMP    'A:CON;I\TMP;I\DONT_EXIST;I\TRANS    'U:DELETE_MV;DELETE_DESC;I\TRNTYPE,I\TRANS    U:DELETE_MV;DELETE;I\TRNTYPE,I\TRANS  DOEND(CHK)    A:CONST;;I\TRNTYPE  O:SETFOCUS;C\DEL;I\TRNTYPE
1 0.0 CMD 1 C -1 221, 97
$SELECT  S:PED_NUMBERS;I\PED
1 0.0 CMD 1 C 0 651, 576
  
1 0.0 CMD 3 C -1 651, 548
$SELECT      I:K\CONF_DEL;<>;1  D:DELETION NOT CONFIRMED;ERRORM;I\PED      I:K\CONF_DEL;=;1  U:PED_MAN;DELETE_PED    U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM_DESC,I\ITEM:H,I\CONT_DESC,I\CONT:H,I\CONT_MASS,I\UNALLOCQTY,I\CONFQTY,I\MASS,I\PERKG,I\TOT_VAL,I\RAND_PERCENT,I\OWING,I\ALLOCQTY:H,I\RECQTY:H,W\CONF:H    A:CO
1 0.0 Work 64 G -1 11, 253
  
1 0.0 Work 1 G -1 11, 253
  
1 0.0 H -1 1, 61
  
1 0.0 I -1 11, 229
$CALCULATE    I:I\SEQ;=;  DO(001)    A:CONST;;I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\RECQTY,I\UNALLOC_QTY,I\UNALLOCQTY,I\ALLOCQTY,W\CONF    O:DISABLEINPUT;G\GRID,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\RECQTY,I\UNALLOC_QTY,I\UNALLOCQTY,I\CONFQTY,I\ALLOCQTY    O:DISABLEINPUT;G\GRID      I:I\SCREEN_TYPE;<>;SR    U
1 0.0 Work 2 I -1 671, 229
  
1 0.0 TMP16 I 0 51, 541
  
1 0.0 ORGS I 0 21, 49
  
1 0.0 PROHIBIT_SALES I 0 101, 49
  
1 0.0 TMP1 I 0 31, 541
  
1 0.0 I -1 121, 133
$VALIDATE  C:UCASE  
1 0.0 STK_MAST SM_MARKET I 0 1, 49
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\SM_MARKET  A:ORGS;;I\ORGS    'A:PARM;1;I\SCREEN_TYPE    'I:I\SCREEN_TYPE;=;CS  'DO(CS)    'A:CONST;PED CONFIRMATION;T\HEADER1    'O:HIDE;T\RECQTY2,T\RECQTY3  'DOEND(CS)    'I:I\SCREEN_TYPE;=;TM  'DO(TM)    'A:CONST;UNALLOCATED STOCK ALLOCATION;T\HEADER    'O:HIDE;T\RECQTY1,T\RECQTY
1 0.0 DEFAULT I 0 41, 49
$DEFAULT    A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    A:USERIP;;I\IP  A:USERID;;I\USER    O:HIDE;G\GRID1    'INITIALIZE CONSIGNMENT GRID  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM_DESC,I\ITEM:H,I\CONT_DESC,I\CONT:H,I\CONT_MASS,I\RECQTY,I\CONFQTY,I\MASS,I\PERKG,I\TOT_VAL,I\RAND_PERCENT,I\O
1 0.0 Work 2 I 0 211, 517
  
1 0.0 I 0 661, 97
  
1 0.0 Work 1 I 0 341, 325
  
1 0.0 Work 6 I 0 331, 541
  
1 0.0 Work 7 I 0 301, 541
  
1 0.0 Work 8 I 0 271, 541
  
1 0.0 Work 1 I 0 421, 541
  
1 0.0 Work 2 I 0 351, 493
  
1 0.0 Work 4 I 0 11, 517
  
1 0.0 Work 5 I 0 151, 229
  
1 0.0 Work 6 I 0 191, 229
  
1 0.0 Work 2 I 0 241, 541
  
1 0.0 Work 4 I -1 121, 97
$SELECT  S:PED_NUMBERS;I\PED      $VALIDATE  A:CONST;;I\SEQ    U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM_DESC,I\ITEM:H,I\CONT_DESC,I\CONT:H,I\CONT_MASS,I\UNALLOCQTY,I\CONFQTY,I\MASS,I\PERKG,I\TOT_VAL,I\RAND_PERCENT,I\OWING,I\ALLOCQTY:H,I\RECQTY:H,W\CONF:H    A:CONST;;I\SEQ,I\ITEM_DESC,I\ITEM,I\CONT_DESC,I\CONT,I\CON
1 0.0 Work 1 I 0 661, 121
  
1 0.0 Work 2 I 0 661, 145
  
1 0.0 Work 3 I 0 351, 517
  
1 0.0 Work 1 I 0 211, 541
  
1 0.0 TMP3 I 0 11, 541
  
1 0.0 Work 2 I 0 81, 49
  
1 0.0 IP I 0 61, 49
  
1 0.0 Work 2 I -1 51, 229
  
1 0.0 TMP2 I 0 71, 541
  
1 0.0 Work 1 I 0 211, 493
  
1 0.0 I -1 391, 97
  
1 0.0 Work 9 I 0 361, 541
  
1 0.0 Work 11 I 0 421, 517
  
1 0.0 I -1 151, 229
  
1 0.0 I 0 401, 481
$CALCULATE    'CHECK CONSIGNMENT QTY  I:I\RECQTY;<=;0;NUM  D:DELIVERY QTY CANNOT BE LESS OR EQUAL TO ZERO;ERRORM;I\RECQTY    
1 0.0 Work 3 I 0 21, 517
  
1 0.0 Work 7 I -1 431, 229
  
1 0.0 Work 1 I -1 361, 229
$CALCULATE  A:CONST;;I\TMP2    I:I\FM_TRADER_TYPE;IN;03,04  DO(9)    A:MULT;I\CONFQTY;I\TOT_VAL;I\PERKG;;#0.00    A:VAR;I\SLS_PERC;I\RAND_PERCENT;;#0.00    A:DIV;I\SLS_PERC;I\SLS_PERC;100;;#0.00    A:MULT;I\TOT_VAL;I\OWING;I\SLS_PERC;;#0.00  DOEND(9)    'SAVE SCREEN FIELDS VALUES TO GRID  U:ZZGRID_SPLIT;SCREEN_TO_GRID;
1 0.0 Work 17 I 0 101, 517
  
1 0.0 Work 12 I 0 211, 517
  
1 0.0 Work 15 I 0 211, 517
  
1 0.0 Work 8 I -1 481, 229
$VALIDATE    I:I\FM_TRADER_TYPE;IN;03,04  DO(9)    A:MULT;I\CONFQTY;I\TOT_VAL;I\PERKG;;#0.00    A:VAR;I\SLS_PERC;I\RAND_PERCENT;;#0.00    A:DIV;I\SLS_PERC;I\SLS_PERC;100;;#0.00    A:MULT;I\TOT_VAL;I\OWING;I\SLS_PERC;;#0.00  DOEND(9)    'SAVE SCREEN FIELDS VALUES TO GRID  U:ZZGRID_SPLIT;SCREEN_TO_GRID;G\GRID;I\SEQ    'C
1 0.0 Work 9 I -1 541, 229
  
1 0.0 Work 10 I -1 611, 229
  
1 0.0 Work 13 I 0 211, 517
$SELECT  S:AVAIL_TABLES;I\TRNTYPE      $CALCULATE    'CONVERT TO UPPERCASE  C:UCASE    I:I\TRNTYPE;<>;  F:FM_TABLES;;;W\TABLENO=FM_TABLENO,W\PEDNO=FM_PEDNO;FM_TABLENO='$I\TRNTYPE$';I\TRNTYPE    I:W\TABLENO;=;  D:TABLE NUMBER $I\TRNTYPE$ DOES NOT EXIST;ERRORM;I\TRNTYPE    I:W\PEDNO;<>;  D:TABLE ALREADY ALLOCATED TO PED 
1 0.0 Work 1 I 0 491, 517
  
1 0.0 Label 2 T -1 481, 181
  
1 0.0 Work 5 I -1 241, 133
  
1 0.0 Work 3 I -1 311, 229
  
1 0.0 Work 2 I 0 161, 517
  
1 0.0 Work 2 I 0 451, 541
  
1 0.0 Work 18 I 0 131, 517
  
1 0.0 Work 13 I 0 41, 517
  
1 0.0 Work 14 I 0 71, 517
  
1 0.0 Work 3 I 0 211, 517
  
1 0.0 Work 1 I 0 731, 229
  
1 0.0 Work 1 I 0 511, 541
  
1 0.0 Work 2 I 0 481, 541
  
1 0.0 Work 5 I 0 131, 49
  
1 0.0 Work 1 I 0 541, 541
  
1 0.0 STK_MAST SM_SUPP T 0 361, 445
  
1 0.0 Label 1 T -1 291, 25
  
1 0.0 Label 2 T -1 291, 49
  
1 0.0 Label 5 T -1 611, 205
  
1 0.0 Label 6 T -1 671, 205
  
1 0.0 T -1 481, 205
  
1 0.0 CONS T 0 361, 445
  
1 0.0 STK_DETS SD_COMMENT T -1 151, 205
  
1 0.0 Label 68 T 0 91, 541
  
1 0.0 Label 1 T -1 51, 205
  
1 0.0 Label 4 T -1 431, 205
  
1 0.0 Label 11 T 0 91, 541
  
1 0.0 Label 12 T 0 91, 541
  
1 0.0 Label 1 T -1 11, 97
  
1 0.0 Label 2 T -1 311, 205
  
1 0.0 Label 1 T -1 541, 181
  
1 0.0 SD_SEQ T -1 11, 205
  
1 0.0 T 0 361, 445
  
1 0.0 STK_MAST SM_VREGNO T -1 11, 133
  
1 0.0 Label 19 T -1 501, 97
  
1 0.0 Label 3 T -1 1, 25
  
1 0.0 Label 4 T -1 621, 25
  
1 0.0 Label 5 T -1 621, 49
  
1 0.0 Label 5 T -1 361, 181
  
1 0.0 Label 4 T 0 361, 445
  
1 0.0 Label 1 T 0 661, 145
  
1 0.0 Label 2 T -1 361, 205
  
1 0.0 Label 6 T -1 671, 25
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 STK_MAST SM_DELNO T -1 291, 97
  
1 0.0 Label 2 T 0 361, 445
  
1 0.0 Check 1 K -1 741, 481
$VALIDATE    I:K\CONF_DEL;<>;1  D:DELETION NOT CONFIRMED;ERRORM;I\PED    I:K\CONF_DEL;=;1  O:SETFOCUS;C\RUN  O:BACKCOLOR;C\RUN;YELLOW    
1 0.0 Label 2 T -1 581, 481
  
1 0.0 Label 6 T 0 731, 205
  
1 2.0 NO_OF_LINES I 0 391, 541
'$VALIDATE  'I:I\NO_OF_LINES;=;  'A:CONST;0;I\NO_OF_LINES    'I:I\NO_OF_LINES;<>;I\NO_LINES  'D:NUMBER OF LINES MUST BE EQUAL TO THE NUMBER OF ROWS IN THE GRID;ERRORM;I\NO_OF_LINES      '$VALIDATE    ''FOR PRE CHANGE 28062013  I:I\NO_LINES;=;  ''D:ERROR - NO RECORDS IN THE GRID TO PROCESS;ERRORM;I\SD_SEQ
1 2.0 TOT_REC I 0 231, 517
  
1 2.0 Label 67 T 0 91, 541
  
1 2.0 Label 1 T -1 541, 205
  
10 0.0 ZX_SELECT Z 0 1, 61
  
10 0.0 ZX_PRINT Z 0 1, 61
  
10 0.0 ZX_UPDATE Z 0 1, 61
  
10 0.0 ZX_EXIT Z 0 1, 61
  
10 0.0 ZX_DELETE Z 0 1, 61