Freshmark replication server

freshmark-canonical

Program drill-down

RETAILERS_CAPTURE

CAPTURE RETAILER. Type DSP, base table FM_PED_MAST.

Field inventory

106

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 5 C 0 231, 481
$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 4 C 0 241, 445
$SELECT  S:AVAIL_TABLES;I\TRNTYPE
1 0.0 CMD 1 C -1 231, 85
$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;CAPTURE_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\RECQTY,I\AGN,I\PED_NO,W\DEL  A:CONST;1;I\TBL1  A:CONST;0;I\TBL_COUNT    A:CONST;;I\SEQ,I\ITEM_DESC,I\ITEM,I\CONT_DESC,I\CONT,I\CONT_MASS,I\ALLOCQT
1 0.0 Work 5 I -1 641, 229
$SELECT  S:PED_NUMBERS;I\PED_NO    $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 Work 64 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\CONT_MASS,I\RECQTY,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\DEL      U:PED_MAN;SUM_QTY;G\GRID,I\RECQTY    A:CONST;$I\TOT_REC$;I\QTY_TOT      
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 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\RECQTY,I\AGN,I\PED_NO,W\DEL,I\PED_FROM    A:CONST;;I\SEQ,I\ITEM_DESC,I\ITEM,I\CONT_DESC,I\CONT,I\CONT_MASS,I\ALLOCQTY,I\RECQTY,I\CONFQTY,I\MASS,I\PERKG,I\TOT_VAL,I\RAND_PERCENT,I\OWING,I\UNALLOCQTY  A:C
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;=;TM  A:CONST;UNALLOCATED STOCK ALLOCATION;T\HEADER    I:I\SCREEN_TYPE;=;CS  A:CONST;PED CONFIRMATION;T\HEADER1    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\CM_DEL_LEN=CM_DEL_LEN    'CHANGING
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\RECQTY,I\AGN,I\PED_NO,W\DEL    'PUTS PIC ON THE UPDATE BUTTON  O:LOADPIC;$GBLROOT$
1 0.0 I 0 621, 493
  
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 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  S:FM_CONTAINERS;I\CONT    $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_COMMODITY;;;I\CONT_MASS=FM_CONT_MASS;FM_ITEM='$I\ITEM$' AND
1 0.0 Work 2 I 0 241, 541
  
1 0.0 Work 4 I -1 131, 121
$SELECT  S:PED_NUMBERS;I\PED      $VALIDATE  A:CONST;;I\SEQ    I:I\SCREEN_TYPE;=;CS  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\OWING,I\UNALLOCQTY:H,I\ALLOCQTY:H    I:I\SCREEN_TYPE;=;TM  U:ZZGRID_SPLIT;INIT_GRI
1 0.0 Work 1 I 0 621, 517
  
1 0.0 Work 2 I 0 621, 493
  
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 91, 229
  
1 0.0 TMP2 I 0 71, 541
  
1 0.0 I -1 131, 85
$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\RECQTY,I\AGN,I\PED_NO,W\DEL    F:FM_PERMIT_HOLDERS;Y;;I\PERMITNO=FM_PERMITNO,I\FM_SUPPL=FM_SUPPL,T\FM_SUPPL_NAME=FM_SUPPL_NAME,I\FM_TRADER_
1 0.0 Work 9 I 0 361, 541
  
1 0.0 Work 11 I 0 501, 481
  
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 Label 8 T -1 741, 205
  
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 17 I 0 101, 517
  
1 0.0 Work 12 I 0 501, 409
  
1 0.0 Work 15 I 0 191, 409
  
1 0.0 Work 13 I 0 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 Work 3 I -1 491, 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 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 STK_MAST SM_SUPP T 0 621, 493
  
1 0.0 Label 1 T -1 291, 25
  
1 0.0 Label 10 T 0 391, 481
  
1 0.0 CONS T -1 541, 205
  
1 0.0 T -1 291, 205
  
1 0.0 Label 1 T -1 101, 205
  
1 0.0 Label 16 T 0 21, 409
  
1 0.0 Label 11 T 0 21, 445
  
1 0.0 Label 12 T 0 391, 409
  
1 0.0 Label 1 T -1 21, 121
  
1 0.0 Label 2 T -1 491, 205
  
1 0.0 SD_SEQ T -1 11, 205
  
1 0.0 T -1 271, 157
  
1 0.0 STK_MAST SM_VREGNO T -1 21, 157
  
1 0.0 Label 19 T -1 271, 85
  
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 6 T -1 671, 25
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 STK_MAST SM_DELNO T -1 21, 85
  
1 0.0 Label 6 T -1 291, 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 4 I 0 621, 493
  
1 0.0 Work 5 I 0 621, 517
  
1 0.0 Label 6 T 0 621, 409
  
1 0.0 Work 3 I 0 621, 385
  
1 0.0 Work 2 I 0 371, 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\RECQTY,I\AGN,I\PED_NO,W\DEL    $VALIDATE  'M:    I:I\PED_AGENT;<>;  DO(TEST)    F:AGENT_MAST;Y;;;AM_CODE='$I\PED_AGENT$';I\PED_AGENT      I:I\PED_AGENT;=;X    D:PLEA
1 0.0 Label 3 T 0 291, 109
  
1 0.0 Label 1 T -1 51, 205
  
1 0.0 Label 2 T -1 251, 205
  
1 0.0 Label 2 T 0 521, 109
  
1 0.0 Work 3 I 0 581, 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 461, 109
  
1 0.0 Work 4 I 0 541, 541
  
1 0.0 Work 1 I 0 681, 109
  
1 0.0 Work 2 I 0 711, 169
  
1 0.0 Label 2 T -1 641, 205
  
1 0.0 Work 3 I -1 601, 229
$SELECT  S:AGENT_CODE;I\AGN      $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 4 I -1 131, 121
$SELECT  S:PED_NUMBERS;I\PED      $VALIDATE  A:CONST;;I\SEQ    I:I\SCREEN_TYPE;=;CS  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\OWING,I\UNALLOCQTY:H,I\ALLOCQTY:H    I:I\SCREEN_TYPE;=;TM  U:ZZGRID_SPLIT;INIT_GRI
1 0.0 Work 1 I 0 681, 169
  
1 0.0 CMD 1 C 0 421, 109
  
1 0.0 Label 1 T -1 601, 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 Label 67 T 0 91, 541
  
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\RECQTY,I\AGN,I\PED_NO,W\DEL,I\PED_FROM    A:CONST;;I\SEQ,I\ITEM_DESC,I\ITEM,I\CONT_DESC,I\CONT,I\CONT_MASS,I\ALLOCQTY,I\RECQTY,I\CONFQTY,I\MASS,I\PERKG,I\TOT_VAL,I\RAND_PERCENT,I\OWING,I\UNALLOCQTY  A:C
10 0.0 ZX_DELETE Z 0 1, 61