Freshmark replication server

freshmark-canonical

Program drill-down

CONTAINER_LISTING

CONTAINER LISTING. Type DSP, base table PRODUCT_MAST.

Field inventory

27

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 H -1 0, 0
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 3 T -1 621, 25
  
1 0.0 Label 4 T -1 671, 25
  
1 0.0 Label 5 T -1 311, 49
  
1 0.0 Label 6 T -1 621, 49
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 Label 8 T -1 1, 25
  
1 0.0 Label 9 T -1 261, 133
  
1 0.0 Label 10 T -1 261, 181
  
1 0.0 Work 11 I -1 331, 133
$SELECT  S:COMM_LIST;I\PROD      $VALIDATE  O:SETFOCUS;I\PROD  C:UCASE;I\PROD  I:I\PROD;<>;  DO(CIA)     F:CONT_MAST;Y;;;CN_PRODUCT='$I\PROD$';I\PROD  DOEND(CIA)  O:SETFOCUS;I\VARIETY  
1 0.0 Work 12 I -1 331, 181
$SELECT  S:VARIETY;I\VARIETY;I\PROD      $VALIDATE  C:UCASE;I\VARIETY  I:I\PROD;=;  DO(1)  I:I\VARIETY;<>;  D:ENTER PRODUCT;ERRORM;I\PROD  DOEND(1)    I:I\VARIETY;<>;  F:VAR_MAST;Y;VA_VARIETY;W\VARIETY=VA_VARIETY;;I\VARIETY  I:W\VARIETY;<>;  F:VAR_MAST;Y;VA_VARIETY;VA_PRODUCT='$I\PROD$';;DOES NOT EXIST FOR THE ENTERED 
1 0.0 Work 13 I 0 1, 85
C:MCASE;;T\MKT  $DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MKT=CM_NAME    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MKT  
1 0.0 Work 14 I 0 1, 121
$DEFAULT  A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000
1 0.0 CMD 16 C -1 431, 133
$SELECT  S:COMM_LIST;I\PROD    $VALIDATE  I:I\PROD;<>;  DO(CIA)     F:VAR_MAST;Y;;;VA_PRODUCT='$I\PROD$';I\PROD  DOEND(CIA)
1 0.0 CMD 17 C -1 431, 181
$SELECT  S:VARIETY;I\VARIETY;I\PROD
1 0.0 CMD 18 C -1 331, 277
$SELECT  A:CONST;;W\VARIETY,W\CONT    C:UCASE;I\PROD,I\CONT  I:I\PROD;<>;  DO(CIA)     F:CONT_MAST;Y;;;CN_PRODUCT='$I\PROD$';I\PROD  DOEND(CIA)    C:UCASE  I:I\PROD;=;  DO(1)  I:I\VARIETY;<>;  D:ENTER PRODUCT;ERRORM;I\PROD  DOEND(1)    I:I\VARIETY;<>;  DO(2)  F:VAR_MAST;Y;;W\VARIETY=VA_VARIETY;VA_VARIETY='$I\VARIETY$';
1 0.0 Label 19 T -1 291, 301
  
1 0.0 Work 1 I 0 1, 157
  
1 0.0 Work 2 I -1 331, 229
$SELECT  S:CONT_MAST;I\CONT;I\PROD    $VALIDATE  C:UCASE;I\CONT  I:I\CONT;<>;  DO(CIA)     F:COMM_PERC;Y;;;CP_CONT='$I\CONT$';I\CONT  DOEND(CIA)  O:SETFOCUS;C\RUN  
1 0.0 CMD 3 C -1 431, 229
$SELECT  S:CONT_MAST;I\CN_CONT;I\CN_PRODUCT
1 0.0 Label 1 T -1 261, 229
  
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