Freshmark replication server

freshmark-canonical

Program drill-down

AGN_POOL_PURCHASES

AGENT PALLET POOL PURCHASES. Type MAN, base table STK_DETS.

Field inventory

50

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Work 1 I -1 31, 217
  
1 0.0 Work 2 I -1 81, 217
  
1 0.0 Label 10 T -1 681, 217
  
1 0.0 H -1 0, 0
  
1 0.0 CODE T -1 81, 193
  
1 0.0 PALLC T -1 81, 169
  
1 0.0 Label 23 T -1 161, 193
  
1 0.0 STK_DETS SD_CONSIGN I -1 181, 133
$SELECT  S:CONSIGN_NO;I\SD_CONSIGN    $CALCULATE  M:  C:UCASE  F:STK_DETS;Y;;I\TMP1=SD_DELNO;SD_CONSIGN='$I\SD_CONSIGN$';I\SD_CONSIGN  F:STK_MAST;;;I\SUPPL=SM_SUPP;SM_DELNO='$I\TMP1$'  F:SUPPLIER_MAST;;;T\SUPP_DESC=SUM_NAME;SUM_SUPPL='$I\SUPPL$'    U:AGN_PALL_RETURNS;POPULATE_GRID    $VALIDATE  M:  C:UCASE  F:STK_DETS;
1 0.0 STK_DETS SD_CONSIGN T -1 41, 133
  
1 0.0 QTYRC T -1 321, 169
  
1 0.0 Label 20 T -1 31, 193
  
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 301, 25
  
1 0.0 Label 10 T -1 261, 49
  
1 0.0 REC T -1 311, 193
  
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
1 0.0 CMD 17 C -1 311, 133
$SELECT  S:CONSIGN_NO;I\SD_CONSIGN
1 0.0 CMD 3 C -1 121, 217
  
1 0.0 Label 4 T -1 161, 217
  
1 0.0 Label 5 T -1 301, 217
  
1 0.0 PREVQTYR T -1 551, 193
  
1 0.0 RET T -1 711, 193
  
1 0.0 QTYRT T -1 631, 193
  
1 0.0 PREV T -1 551, 169
  
1 0.0 QTYSD T -1 471, 169
  
1 0.0 SOLD T -1 471, 193
  
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 Work 6 I -1 411, 217
  
1 0.0 Work 7 I -1 561, 217
  
1 0.0 Label 9 T -1 631, 217
  
1 0.0 Label 3 T 0 351, 133
  
1 0.0 Label 4 T 0 351, 133
  
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