Freshmark replication server

freshmark-canonical

Program drill-down

CHEP_DELS_MAN

CHEP PALLET DELIVERY MAINTENANCE. Type DSP, base table DEBTOR_MAST.

Field inventory

91

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Work 6 I 0 121, 529
  
1 0.0 Work 1 I 0 81, 529
  
1 0.0 Work 4 I 0 161, 529
  
1 0.0 Work 5 I 0 101, 529
  
1 0.0 H -1 1, 25
  
1 0.0 DEFAULT I 0 1, 49
$DEFAULT    '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\TIME    A:VAR;T\DATE;I\DATE;;YYYY/MM/DD    U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\DELNO,I\PALL_QTY,I\FDELDATE,I\SUPP,I\SUPP_NAME,I\MSG    A:CONST;+;I\SEQ;  O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\
1 0.0 IP I 0 91, 49
$DEFAULT  A:USERIP;;I\IP  F:CASH_POINT;;;I\CASHPOINT=CPO_CASHPT;CPO_IP='$I\IP$'    
1 0.0 Work 26 G -1 11, 313
  
1 0.0 ORGS I 0 61, 49
$DEFAULT  A:ORGS;;I\ORGS    
1 0.0 MARKET I 0 31, 49
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET  A:ORGS;;I\ORGS    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME    A:VAR;I\ORGS;I\AGENT    I:I\ORGS;<>;  DO(0)    A:CONST;$I\ORGS$;I\AGENT    O:DISABLEINPUT;I\AGENT    F:AGENT_MAST;;;T\AGENT_NAME=AM_NAME;AM_CODE='$I\ORGS$';  DOEND(0)    I:I\ORGS;=;  DO(1)    O
1 0.0 I -1 121, 193
    
1 0.0 Work 1 I 0 371, 481
  
1 0.0 Work 2 I 0 271, 481
  
1 0.0 Work 1 I 0 521, 481
  
1 0.0 I -1 121, 157
  
1 0.0 Work 1 I 0 411, 157
  
1 0.0 Work 1 I -1 161, 289
  
1 0.0 I -1 121, 121
$SELECT  S:CONS;I\CONSIGN;I\MARKET;I\ORGS    $VALIDATE  M:  F:PALL_DETS;Y;;I\TDELDATE=PD_DATE,I\PALL_CODE=PD_PALL,I\PALL_AGN=PD_AGENT;PD_MARKET = '$I\MARKET$' AND PD_CONSIGN = '$I\CONSIGN$';I\CONSIGN    I:I\AGENT;<>;I\PALL_AGN  D:THE ENTERED CONSIGNMENT IS NOT FOR THE AGENT LOGGED ON!!!;ERRORM;I\CONSIGN    F:PALL_MAST;
1 0.0 I -1 261, 289
$VALIDATE  M:  O:SETFOCUS;I\MSG
1 0.0 I -1 361, 289
  
1 0.0 I -1 461, 289
  
1 0.0 Work 1 I 0 141, 457
  
1 0.0 I 0 361, 553
  
1 0.0 Work 7 I 0 141, 529
  
1 0.0 Work 29 I 0 81, 553
  
1 0.0 Work 30 I 0 61, 553
  
1 0.0 Work 31 I 0 61, 577
  
1 0.0 Work 32 I 0 41, 553
  
1 0.0 Work 33 I 0 41, 577
  
1 0.0 Work 36 I 0 301, 577
  
1 0.0 Work 37 I 0 321, 577
  
1 0.0 Work 38 I 0 341, 577
  
1 0.0 Work 39 I 0 241, 577
  
1 0.0 Work 40 I 0 261, 577
  
1 0.0 Work 41 I 0 281, 577
  
1 0.0 Work 4 I 0 241, 553
  
1 0.0 Work 5 I 0 261, 553
  
1 0.0 CR_LIM I 0 101, 553
  
1 0.0 OSBAL I 0 121, 553
  
1 0.0 Work 1 I 0 121, 49
$DEFAULT  A:USERID;;I\USERID    U:MENU_GROUP;LOOKUP
1 0.0 DEBTOR_MAST DM_ACCTYPE I 0 141, 553
  
1 0.0 Work 4 I 0 181, 553
  
1 0.0 Work 5 I 0 161, 553
  
1 0.0 Work 1 I 0 381, 553
  
1 0.0 Work 2 I 0 341, 553
  
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 291, 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 Label 13 T -1 11, 157
  
1 0.0 Label 15 T -1 11, 193
  
1 0.0 Label 17 T -1 181, 193
  
1 0.0 Label 19 T -1 181, 157
  
1 0.0 Label 38 T -1 11, 265
  
1 0.0 Label 39 T -1 61, 265
  
1 0.0 Label 40 T -1 11, 121
  
1 0.0 Label 41 T -1 261, 241
  
1 0.0 Label 42 T -1 361, 265
  
1 0.0 Label 43 T -1 261, 265
  
1 0.0 Label 44 T -1 461, 265
  
1 0.0 CMD 1 C -1 651, 547
$SELECT    U:CHEP_DELIVEIES;ADD_TO_CONSIGMENT;G\GRID,I\SEQ    U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\DELNO,I\PALL_QTY,I\FDELDATE,I\SUPP,I\SUPP_NAME,I\MSG    I:I\ORGS;<>;  DO(0)    A:CONST;;I\SMAN,T\SMAN_NAME,I\PALL_CODE,T\PALL_DESC,I\TDELDATE,I\FDELDATE,I\CONSIGN,I\TMP1,I\TMP2    O:SETFOCUS;I\CONSIGN  DOEND(0)    I:I\
1 0.0 Label 50 T -1 761, 265
  
1 0.0 Label 54 T 0 301, 553
  
1 0.0 Label 27 T -1 11, 85
  
1 0.0 Label 34 T -1 321, 121
  
1 0.0 Label 35 T -1 181, 85
  
1 0.0 Label 42 T 0 201, 577
  
1 0.0 Label 1 T 0 201, 553
  
1 0.0 Work 2 I -1 411, 121
  
1 0.0 Work 1 I -1 121, 85
$VALIDATE    U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\DELNO,I\PALL_QTY,I\FDELDATE,I\SUPP,I\SUPP_NAME,I\MSG  A:CONST;+;I\SEQ;    C:UCASE  M:  F:AGENT_MAST;Y;;T\AGENT_NAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT  
1 0.0 Work 1 I 0 541, 181
  
1 0.0 Work 1 I 0 41, 481
  
1 0.0 Work 2 I 0 41, 505
  
1 0.0 Work 1 I 0 41, 457
  
1 0.0 Work 1 I 0 431, 481
  
1 0.0 Work 2 I 0 461, 481
  
1 0.0 Work 1 I 0 401, 481
  
1 0.0 Work 1 I 0 141, 481
  
1 0.0 Work 1 I 0 491, 481
  
1 0.0 Label 1 T -1 161, 265
  
1 1.0 LINE I -1 11, 289
$SELECT  S:G:G\GRID:R1;I\SEQ  $SELECT6  S:G:G\GRID:F1;I\SEQ    $CALCULATE  I:I\SEQ;=;  DO(SFD)     O:DISABLEINPUT;I\DELNO,I\FDELDATE,I\PALL_QTY,I\SUPP,I\SUPP_NAME,I\MSG     O:SETFOCUS;C\UPDATE     O:BACKCOLOR;C\UPDATE;YELLOW  DOEND(SFD)    I:I\SEQ;<>;  DO(002)    I:I\SEQ;=;+    DO(004)      A:CONST;;I\SEQ      O:ENABLE
1 1.0 I -1 61, 289
$CALCULATE    F:AUD_PALL_DETS;;;I\TMP1=SUM(APD_RECQTY);APD_MARKET='$I\MARKET$' AND LEFT(APD_CONSIGN,6)='$I\DELNO$' AND APD_PALL='$I\PALL_CODE$' AND APD_AUD_DATE = '$I\DATE$' AND APD_AUD_TYPE = 'INS' GROUP BY APD_MARKET,LEFT(APD_CONSIGN,6),APD_AUD_DATE,APD_AUD_TYPE;  F:AUD_PALL_DETS;;;I\TMP2=SUM(APD_RECQTY);APD_MARKET='
1 1.0 MSG I -1 761, 289
$CALCULATE  C:UCASE  V:Y;N;  I:I\MSG;=;  A:CONST;N;I\MSG    U:ZZGRID_SPLIT;SCREEN_TO_GRID;G\GRID;I\SEQ    A:CONST;;I\DELNO,I\PALL_QTY,I\SUPP,I\SUPP_NAME,I\FDELDATE,I\TMP_SMAN,I\MSG  A:CONST;+;I\SEQ    O:SETFOCUS;I\SEQ    
10 0.0 ZX_PRINT Z 0 1, 25
  
10 0.0 ZX_SELECT Z 0 1, 25
  
10 0.0 ZX_DELETE Z 0 1, 25
  
10 0.0 ZX_UPDATE Z 0 1, 25
$ESC  U:BUYER_RESERVATION_GRID_PRETORIA;UNFLAG_CARD    $UPDATE    ''==================================  ''TO CHECK FOR LOCKS (JD 2010-11-15)  U:ZZGRID_VALIDATE;INIT_GRID;G\GRID  ''TO CHECK FOR LOCKS (JD 2010-11-15)  ''==================================    'I:I\PMT_METH;<>;  'DO(SCR)  '  I:I\PMT_METH;=;CA  '  DO(CA)  ' 
10 0.0 ZX_EXIT Z 0 1, 25