Freshmark replication server

freshmark-canonical

Program drill-down

AGNPALL_POOL_RET_MAN

BUYER_PAL_RET_AGN. Type MAN, base table STK_DETS.

Field inventory

73

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Work 2 I 0 41, 553
  
1 0.0 Work 1 I 0 691, 481
$BEFORE_WRITE  U:AGN_PALL_RETURNS;GRID_BLANKS  U:AGN_PALL_RETURNS;UPDATE_TABLES
1 0.0 Work 1 I 0 171, 469
  
1 0.0 Work 1 I 0 491, 121
  
1 0.0 Work 1 I 0 491, 457
  
1 0.0 H -1 0, 0
  
1 0.0 CODE T -1 71, 265
  
1 0.0 PALLC T -1 71, 241
  
1 0.0 Label 23 T -1 121, 265
  
1 0.0 T -1 271, 265
  
1 0.0 PALLT T -1 271, 241
  
1 0.0 DESC2 T -1 321, 265
  
1 0.0 STK_DETS SD_CONSIGN I -1 181, 133
$SELECT    'WITH QTY AVAIL ONLY  '''S:CONSIGN_NO_PALL;I\SD_CONSIGN;I\ORGS  I:I\MARKET;=;19  S:CONSIGN_NO_PALL_PMB;I\SD_CONSIGN;I\ORGS      'FOR ALL THINGS  I:I\MARKET;<>;19  S:CONSIGN_NO_PALL2;I\SD_CONSIGN;I\ORGS    $CALCULATE    M:  C:UCASE    'ZERO FILL  F:CLIENT_MAST;;;I\DEL_LEN1=CM_DEL_LEN;CM_CODE='$I\MARKET$'  A:A
1 0.0 STK_DETS SD_CONSIGN T -1 41, 133
  
1 0.0 I -1 181, 169
  
1 0.0 QTYRC T -1 471, 241
  
1 0.0 Work 3 I 0 91, 61
$DEFAULT  A:USERIP;;I\IP  
1 0.0 PREV_QTY_RET T -1 591, 265
  
1 0.0 Label 20 T -1 31, 265
  
1 0.0 Label 13 T -1 621, 49
  
1 0.0 Label 14 T -1 671, 49
  
1 0.0 Label 12 T -1 671, 25
  
1 0.0 Label 11 T -1 621, 25
  
1 0.0 MARKET T -1 1, 25
  
1 0.0 FRESHMARK T -1 291, 25
  
1 0.0 Label 10 T -1 281, 49
  
1 0.0 Work 6 I 0 31, 61
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MARKET    F:CLIENT_MAST;;;I\AGN_SMAN_SEC=CM_PALL_SECT;CM_CODE='$I\MARKET$'
1 0.0 Work 7 I 0 11, 61
$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:TIMER_ON;1000    '''''U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\PALLCODE,I\DESC1,I\PALLTYPE,I\DESC2,I\QTY_REC,I\QTY_SOLD,I\PREV_QTY_RET,I\QTY_AVAIL,I\QTY_RET,I\TEST:H  'U:ZZGRID_SPLIT;INIT_GRID
1 0.0 Work 4 I 0 71, 61
$DEFAULT  A:USERID;;I\USERID
1 0.0 Work 5 I 0 51, 61
$DEFAULT  A:ORGS;;I\ORGS    F:AGENT_MAST;;;I\DEL_LEN=AM_DEL_LEN,I\AGN_POOL=AM_OWN_PALL_POOL;AM_CODE='$I\ORGS$'  F:CLIENT_MAST;;;I\MARKET_POOL=CM_CENTRAL_PALL;CM_CODE='$I\MARKET$'    I:I\MARKET_POOL;=;0  DO(DQ)    I:I\ORGS;=;    DO(PI)      O:HIDEUPDATE      O:SHOW;T\MARK_MAY    DOEND(PI)  DOEND(DQ)    I:I\AGN_POOL;=;1 
1 0.0 T -1 41, 169
  
1 0.0 REC T -1 471, 265
  
1 0.0 Work 15 G -1 31, 289
$GRID_VALIDATE  U:AGN_PALL_RETURNS;GRID_KEY_3    $GRID_ENTERCELL  I:I\TMP2;=;N  U:AGN_PALL_RETURNS;GRID_KEY_4  D:ENTER THE QTY OF PALLETS RETURNED, PRESS TAB TO MOVE TO PROCESS OR EXIT;;G\GRID    $GRID_LEAVECELL  D:ENTER THE QTY OF PALLETS RETURNED, PRESS TAB TO MOVE TO PROCESS OR EXIT;;G\GRID    $GRID_ESC  O:SETFOCUS;
1 0.0 CMD 17 C -1 311, 133
$SELECT  'WITH QTY AVAIL ONLY  '''S:CONSIGN_NO_PALL;I\SD_CONSIGN;I\ORGS    'FOR ALL THINGS  S:CONSIGN_NO_PALL2;I\SD_CONSIGN;I\ORGS
1 0.0 Work 1 I 0 21, 553
  
1 0.0 Check 18 K 0 541, 517
  
1 0.0 Label 19 T 0 591, 517
  
1 0.0 PREVQTYR T -1 591, 241
  
1 0.0 RET T -1 711, 265
  
1 0.0 QTYRT T -1 711, 241
  
1 0.0 PREV T -1 591, 217
  
1 0.0 QTYAV T -1 651, 241
  
1 0.0 AVAIL T -1 651, 265
  
1 0.0 QTYSD T -1 531, 241
  
1 0.0 SOLD T -1 531, 265
  
1 0.0 SEQ I -1 31, 289
  
1 0.0 Work 40 I -1 71, 289
  
1 0.0 Work 41 I -1 121, 289
  
1 0.0 PALLTYPE I -1 271, 289
  
1 0.0 DESC2 I -1 321, 289
  
1 0.0 QTY_REC I -1 471, 289
  
1 0.0 PREV_QTY_RET I -1 591, 289
  
1 0.0 QTY_RET I -1 711, 289
  
1 0.0 QTY_AVAIL I -1 651, 289
  
1 0.0 QTY_SOLD I -1 531, 289
  
1 0.0 Label 51 T -1 331, 169
  
1 0.0 Work 5 I 0 401, 493
  
1 0.0 Work 1 I 0 381, 493
  
1 0.0 Work 2 I 0 361, 493
  
1 0.0 Label 3 T 0 351, 133
  
1 0.0 Label 4 T 0 351, 133
  
1 0.0 DELDATE I 0 671, 133
  
1 0.0 Work 1 I 0 371, 457
  
1 0.0 Work 2 I 0 331, 457
  
1 0.0 Work 3 I 0 61, 553
  
1 0.0 Work 2 I 0 461, 133
  
1 0.0 TEST I 0 681, 193
  
1 0.0 FINPDTE I 0 561, 157
  
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