Freshmark replication server

freshmark-canonical

Program drill-down

RETAILERS_PED_CONF

CONFIRM RETAILER PED. Type DSP, base table FM_PED_MAST.

Field inventory

115

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 5 C -1 241, 481
$SELECT  I:I\TRNTYPE;<>;  DO(CHK)    A:CRLF;I\TMP;I\TMP    U:DELETE_MV;DELETE;I\TRNTYPE,I\TRANS    A:SUB1;I\TBL_COUNT;I\TBL_COUNT;;#0  DOEND(CHK)    A:CONST;;I\TRNTYPE  O:SETFOCUS;C\DEL;I\TRNTYPE
1 0.0 Label 2 T -1 641, 205
  
1 0.0 Label 1 T -1 601, 205
  
1 0.0 Work 1 I 0 671, 109
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 STK_MAST SM_DELNO T -1 21, 121
  
1 0.0 Label 4 T -1 621, 25
  
1 0.0 Label 3 T -1 1, 25
  
1 0.0 Label 19 T -1 271, 121
  
1 0.0 STK_MAST SM_VREGNO T -1 21, 157
  
1 0.0 T 0 271, 157
  
1 0.0 Label 2 T -1 491, 205
  
1 0.0 SD_SEQ T -1 11, 205
  
1 0.0 Label 11 T -1 21, 445
  
1 0.0 Label 12 T -1 391, 409
  
1 0.0 Work 1 I 0 681, 169
  
1 0.0 Label 8 T -1 741, 205
  
1 0.0 STK_MAST SM_SUPP T 0 621, 493
  
1 0.0 Label 1 T -1 291, 25
  
1 0.0 Label 10 T -1 391, 481
  
1 0.0 CONS T -1 541, 205
  
1 0.0 T -1 291, 205
  
1 0.0 Work 4 I 0 541, 541
  
1 0.0 Work 4 I 0 531, 109
  
1 0.0 Work 3 I 0 521, 109
$VALIDATE  'M:    I:I\PED_FROM;<>;  DO(TEST)    F:FM_PED_MAST;Y;;;FM_PED_NUMBER='$I\PED_FROM$' AND FM_PED_CONFIRMED = 'Y';I\PED_FROM       I:I\PED_FROM;=;X    D:PLEASE ENTER AN AGENT CODE OR A PED NUMBER;ERRORM;I\PED_FROM      U:DELETE_MV;DUPLICATES;I\PED_FROM,I\PED_LIST,I\TMP10    I:I\TMP10;=;N    D:THAT VALUE ALREADY
1 0.0 Work 4 I 0 621, 493
  
1 0.0 Work 5 I 0 621, 517
  
1 0.0 Work 13 I 0 41, 517
  
1 0.0 Work 2 I 0 451, 541
  
1 0.0 Work 18 I 0 131, 517
  
1 0.0 Work 3 I -1 491, 229
  
1 0.0 Work 17 I 0 101, 517
  
1 0.0 I -1 291, 229
  
1 0.0 I -1 541, 229
$VALIDATE  A:CONST;N;W\DEL    '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 1 I 0 621, 517
$CALCULATE  A:CONST;;I\TMP2    C:UCASE    I:I\CONFQTY;<>;I\ALLOCQTY    U:PED_MAN;CONRFIM_QTY;G\GRID      I:I\TMP2;=;STOP    D:VERIFY QTY;ERRORM;I\CONFQTY        A:SUB;I\RECQTY;W\QTY_AVAIL;I\UNALLOCQTY    A:MULT;I\CONFQTY;I\MASS;I\CONT_MASS;;#0.00        I:I\FM_TRADER_TYPE;IN;03,04  DO(9)    A:MULT;I\CONFQTY;I\TOT_VAL;I
1 0.0 Work 2 I -1 91, 229
  
1 0.0 IP I 0 61, 49
  
1 0.0 Work 2 I 0 81, 49
  
1 0.0 TMP3 I 0 11, 541
  
1 0.0 Work 1 I 0 211, 541
  
1 0.0 Work 1 I 0 621, 517
  
1 0.0 Work 2 I 0 621, 493
  
1 0.0 Work 4 I 0 11, 517
  
1 0.0 Work 5 I -1 51, 229
$SELECT  S:FM_PRODUCTS;I\ITEM    $CALCULATE  M:  C:UCASE    F:FM_PRODUCT_MAST;Y;;I\ITEM_DESC=FM_ITEM_DESC;FM_NDA_ITEM='$I\ITEM$';I\ITEM
1 0.0 Work 6 I -1 251, 229
'SELECT CONTAINER FROM SELECTION WINDOW  $SELECT  S:CONT_GATE;I\SD_CONT;I\PROD;I\VAR    $CALCULATE  M:  C:UCASE    'LOOKUP FOR AN EXISTING CONTAINER, IF NOT FOUND DISPLAY ERROR MESSAGE AND IF BLOCKED DISPLAY ERROR MESSAGE  I:I\CONT;<>;  F:FM_CONT;Y;;I\CONT_DESC=FM_CONT_DESC;FM_CONTAINER = '$I\CONT$';I\CONT  F:FM_COMMOD
1 0.0 Work 6 I 0 331, 541
  
1 0.0 I 0 621, 493
  
1 0.0 I 0 1, 49
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\SM_MARKET  A:ORGS;;I\ORGS    A:CONST;CS;I\SCREEN_TYPE    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\CM_DEL_LEN=CM_DEL_LEN    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MARKET    'A:DATE;DD MMM YYYY;I\FM_PED_DATE  'A:TIME;HH:MM:SS;I\FM_P
1 0.0 TMP16 I 0 51, 541
  
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\CONT_MASS,I\ALLOCQTY,I\RECQTY,I\CONFQTY,I\UNALLOCQTY,I\MASS,I\PERKG,I\TOT_VAL,I\RAND_PERCENT,I\OWING,I\AGN,I\PED_NO,W\DEL    O:DISABLEINPUT;G\GRID,I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\RECQTY,I\AGN,I\PED_NO,W
1 0.0 Work 5 I -1 641, 229
$VALIDATE    I:I\PED_NO;<>;  DO(1)    F:FM_PED_MAST;Y;;;FM_PED_NUMBER='$I\PED_NO$';I\PED_NO    O:SETFOCUS;W\DEL  DOEND(1)  
1 0.0 H -1 1, 61
  
1 0.0 Work 64 G -1 11, 253
  
1 0.0 CMD 1 C 0 521, 109
  
1 0.0 CMD 4 C -1 241, 445
$SELECT  S:AVAIL_TABLES;I\TRNTYPE
1 0.0 Label 2 T 0 521, 109
  
1 0.0 Label 6 T -1 671, 25
  
1 0.0 Work 14 I 0 71, 517
  
1 0.0 TMP2 I 0 71, 541
  
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    'INITIALIZE CONSIGNMENT GRID  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\ALLOCQTY:H,I\RECQTY,I\CONFQTY:H,I\UNALLOCQTY:H,I\MASS:H,I\PERKG:H,I\TOT_VAL:H,I\RA
1 0.0 I -1 131, 157
$ESC  U:PED_MAN;RESERT_PED  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\ALLOCQTY:H,I\RECQTY,I\CONFQTY:H,I\UNALLOCQTY:H,I\MASS:H,I\PERKG:H,I\TOT_VAL:H,I\RAND_PERCENT:H,I\OWING:H,I\AGN,I\PED_NO,W\DEL    A:CONST;;I\SEQ,I\ITEM_DESC,I\ITEM,I\CONT_DESC,I\CONT,I\CONT_MASS,I\ALLOCQ
1 0.0 TMP1 I 0 31, 541
  
1 0.0 PROHIBIT_SALES I 0 101, 49
  
1 0.0 ORGS I 0 21, 49
  
1 0.0 Label 6 T -1 291, 49
  
1 0.0 Label 6 T -1 621, 409
  
1 0.0 Label 3 T 0 521, 109
  
1 0.0 Label 1 T -1 51, 205
  
1 0.0 Label 2 T -1 251, 205
  
1 0.0 Label 5 T -1 621, 49
  
1 0.0 Label 1 T -1 21, 85
  
1 0.0 Label 1 T -1 101, 205
  
1 0.0 Label 16 T -1 21, 409
  
1 0.0 Work 1 I 0 521, 109
  
1 0.0 Work 2 I 0 711, 169
  
1 0.0 Work 3 I -1 601, 229
$VALIDATE  I:I\AGN;<>;  F:AGENT_MAST;Y;;;AM_CODE='$I\AGN$';I\AGN      $ESP  O:HIDE;I\PED_NO,T\PED_NO  O:SHOW;I\AGN  O:SETFOCUS;I\AGN
1 0.0 Work 3 I -1 721, 409
  
1 0.0 Work 2 I 0 521, 109
$SELECT  S:AGENT_CODE;I\PED_AGENT    $ESC  U:PED_MAN;RESERT_PED  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\ALLOCQTY:H,I\RECQTY,I\CONFQTY:H,I\UNALLOCQTY:H,I\MASS:H,I\PERKG:H,I\TOT_VAL:H,I\RAND_PERCENT:H,I\OWING:H,I\AGN,I\PED_NO,W\DEL    $VALIDATE  'M:    I:I\PED_AGENT;<>; 
1 0.0 Work 3 I -1 281, 445
  
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 7 I -1 741, 229
$VALIDATE  C:UCASE  V:Y;N    $CALCULATE  C:UCASE    I:I\SEQ;=;+  U:PED_MAN;LINE_NO;G\GRID    'SAVE SCREEN FIELDS VALUES TO GRID  U:ZZGRID_SPLIT;SCREEN_TO_GRID;G\GRID;I\SEQ    'CLEAR FIELDS  A:CONST;;I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\RECQTY,I\AGN,I\PED_NO,W\DEL  O:DISBABLEINPUT;G\GRID,I\ITEM,I\IT
1 0.0 Work 2 I 0 161, 517
  
1 0.0 Work 12 I -1 501, 409
$VALIDATE  I:I\TABLE_TARIFF;<;I\TABLE_COST  D:TABLE COST IS LESS THAN THE COST PER TABLE AMOUNT;ERRORM;I\TABLE_COST
1 0.0 Work 15 I -1 191, 409
$VALIDATE  I:I\NO_OF_TABLES;=;  A:CONST;1;I\NO_OF_TABLES    A:MULT;I\NO_OF_TABLES;I\TABLE_COST;I\TABLE_TARIFF  A:VAR;I\TABLE_COST;I\TABLE_TOT  O:SETFOCUS;I\TRNTYPE
1 0.0 Work 13 I -1 191, 445
$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 NUMB
1 0.0 I -1 131, 121
$SELECT  S:PERMIT_HOLDERS;I\PERMITNO    $VALIDATE  A:CONST;;W\DELDATE,W\DELTIME,T\DELDATE  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\ALLOCQTY:H,I\RECQTY,I\CONFQTY:H,I\UNALLOCQTY:H,I\MASS:H,I\PERKG:H,I\TOT_VAL:H,I\RAND_PERCENT:H,I\OWING:H,I\AGN,I\PED_NO,W\DEL    F:FM_PERMI
1 0.0 Work 9 I 0 361, 541
  
1 0.0 Work 11 I -1 501, 481
  
1 0.0 Work 2 I 0 241, 541
  
1 0.0 Work 4 I -1 131, 85
$SELECT  S:PED_NUMBERS;I\PED      $VALIDATE  A:CONST;;I\SEQ  O:ENABLEINPUT;G\GRID,I\SEQ,I\RECQTY,W\DEL    'I:I\SCREEN_TYPE;=;CS  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\ALLOCQTY:H,I\RECQTY,I\CONFQTY:H,I\UNALLOCQTY:H,I\MASS:H,I\PERKG:H,I\TOT_VAL:H,I\RAND_PERCENT:H,I\OWIN
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 CMD 1 C -1 231, 121
$SELECT  S:PERMIT_HOLDERS;I\PERMITNO
1 0.0 CMD 1 C 0 651, 576
  
1 0.0 CMD 3 C -1 651, 548
$SELECT    U:PED_MAN;CONRFIM_PED;G\GRID,I\TRANS  U:PED_MAN;ALLOCATE_TABLES;I\TRANS    U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\ALLOCQTY:H,I\RECQTY,I\CONFQTY:H,I\UNALLOCQTY:H,I\MASS:H,I\PERKG:H,I\TOT_VAL:H,I\RAND_PERCENT:H,I\OWING:H,I\AGN,I\PED_NO,W\DEL  A:CONST;1;I\TBL1 
1 0.0 Work 1 I 0 51, 253
  
1 0.0 Work 2 I 0 151, 253
  
1 0.0 Work 3 I 0 251, 253
  
1 0.0 Work 4 I -1 351, 253
  
1 0.0 Work 5 I 0 441, 253
  
1 0.0 Work 6 I 0 541, 253
  
1 0.0 Work 7 I 0 641, 253
  
1 0.0 Work 3 I 0 171, 49
  
1 0.0 Work 1 I 0 191, 517
  
1 2.0 Label 67 T 0 91, 541
  
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
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
$ESC  U:PED_MAN;RESERT_PED  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\ITEM,I\ITEM_DESC,I\CONT,I\CONT_DESC,I\CONT_MASS,I\ALLOCQTY:H,I\RECQTY,I\CONFQTY:H,I\UNALLOCQTY:H,I\MASS:H,I\PERKG:H,I\TOT_VAL:H,I\RAND_PERCENT:H,I\OWING:H,I\AGN,I\PED_NO,W\DEL    U:PED_MAN;CLEAR_F5;I\TRANS  A:CONST;0;I\TBL_COUNT,I\NO_OF_TABLES  A:CONST
10 0.0 ZX_DELETE Z 0 1, 61