Freshmark replication server

freshmark-canonical

Program drill-down

VIEW_SUPPL_COMM

VIEW COMMISSION %. Type DSP, base table COMM_PERC.

Field inventory

54

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Work 3 G -1 91, 277
  
1 0.0 CMD 3 C -1 241, 109
  
1 0.0 CMD 1 C -1 281, 145
'DISPLAYING DATA FOR F5 FUNCTION  $SELECT  'S:SUPPLIER_MAST;I\CP_SUPPLIER    I:I\CP_AGENT;<>;    S:SUPPL_COMM;I\CP_SUPPLIER;I\CP_AGENT    I:I\CP_AGENT;=;    S:SUPPLIER_MAST;I\CP_SUPPLIER
1 0.0 CMD 3 C -1 251, 181
'DISPLAY DATA FOR F5 FUNCTION  $SELECT   S:PRODUCT_MAST;I\CP_PROD
1 0.0 Work 1 I 0 211, 61
  
1 0.0 Label 4 T -1 91, 505
  
1 0.0 Work 3 I 0 141, 61
  
1 0.0 I -1 201, 145
$SELECT  S:SUPPL_COMM;I\CP_SUPPLIER;I\CP_AGENT    $VALIDATE  M:  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\CP_PROD,I\CP_VARIETY,I\CP_CONT,I\CP_COMMPERC,I\CP_BLOCKED    I:I\CP_SUPPLIER;<>;  F:SUPPLIER_MAST;Y;;T\SUPPL_NAME=SUM_NAME;SUM_MARKET='$I\MARKET$' AND SUM_SUPPL='$I\CP_SUPPLIER$';I\CP_SUPPLIER    A:CONST;;T\PROG,I\ITEM,I\
1 0.0 Label 9 T -1 291, 217
  
1 0.0 H -1 1, 1
  
1 0.0 I -1 281, 277
'
1 0.0 Work 5 I 0 181, 61
  
1 0.0 CMD 8 C -1 251, 217
  
1 0.0 I -1 161, 277
  
1 0.0 I -1 91, 277
        
1 0.0 I -1 201, 109
$DEFAULT  'RETRIVING AGENT NAME  A:ORGS;I\CP_AGENT  F:AGENT_MAST;;AM_CODE;T\AGENT=AM_NAME;AM_MARKET='$I\MARKET$'    I:I\ORGS;<>;  O:DISABLEINPUT;I\CP_AGENT,C\3    'INITIALIZES GRID AND DATA FROM DATABASE TO GRID.  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\CP_PROD,I\CP_VARIETY,I\CP_CONT,I\CP_COMMPERC,I\CP_BLOCKED    $CALCULATE 
1 0.0 Work 4 I 0 11, 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    A:DATE;DD MMM/YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000  A:USERID;;I\USER  A:USERIP;;I\IP  
1 0.0 I -1 341, 277
    
1 0.0 ORGS I 0 31, 61
$DEFAULT  A:ORGS;I\ORGS  I:I\ORGS;<>;  O:DISABLEINPUT;I\CP_AGENT,C\3  
1 0.0 I -1 231, 277
  
1 0.0 AGENT I 0 61, 61
  
1 0.0 Work 2 I 0 81, 61
  
1 0.0 Work 1 I 0 111, 61
  
1 0.0 Work 7 I -1 201, 217
$VALIDATE  C:UCASE    I:I\CONT;<>;  DO(1)    I:I\PROD;=;    DO(1)      I:I\VARIETY;<>;      F:CONT_MAST;Y;;T\CONT_DESC=CN_DESC;CN_PRODUCT='$I\PROD$' AND CN_VAR='$I\VARIETY$' AND CN_CONT='$I\CONT$';I\CONT    DOEND(2)  DOEND(1)    A:CONST;LOADING IN PROGRESS ....;T\PROG  U:MARKET_FUNCTIONS;LOAD_COMMP;G\GRID  A:CONST;LOAD
1 0.0 Label 16 T -1 671, 25
  
1 0.0 Label 15 T -1 621, 49
  
1 0.0 Label 14 T -1 621, 25
  
1 0.0 Label 8 T -1 291, 25
  
1 0.0 Label 17 T -1 671, 49
  
1 0.0 Label 21 T -1 1, 25
  
1 0.0 Label 9 T -1 291, 49
  
1 0.0 Label 9 T -1 281, 253
  
1 0.0 T -1 91, 145
  
1 0.0 T -1 91, 109
  
1 0.0 COMM_PERC CP_VARIETY T -1 161, 253
  
1 0.0 Label 3 T -1 281, 109
  
1 0.0 COMM_PERC CP_PROD T -1 91, 253
  
1 0.0 Label 4 T -1 321, 145
  
1 0.0 Label 5 T -1 291, 181
  
1 0.0 COMM_PERC T -1 341, 253
  
1 0.0 Label 2 T -1 231, 253
  
1 0.0 Label 2 T -1 91, 181
  
1 0.0 Work 1 I -1 201, 181
$VALIDATE  C:UCASE    I:I\ITEM;<>;  DO(1)    A:LEN;I\ITEM;I\TMP1      A:LEFT;I\ITEM,2;I\PROD        I:I\TMP1;>;2    A:RIGHT;I\ITEM,2;I\VARIETY      I:I\VARIETY;<>;    F:VAR_MAST;Y;;T\ITEM_DESC=VA_DESC;VA_PRODUCT='$I\PROD$' AND VA_VARIETY='$I\VARIETY$';I\ITEM      I:I\VARIETY;=;    F:PRODUCT_MAST;Y;;T\ITEM_DESC=PR_DESC;
1 0.0 Label 6 T -1 91, 217
  
10 0.0 ZX_DELETE Z 0 1, 1
  
10 0.0 ZX_UPDATE Z 0 1, 1
  
10 0.0 ZX_EXIT Z 0 1, 1
  
10 0.0 ZX_SELECT Z 0 1, 1
  
10 0.0 ZX_PRINT Z 0 1, 1
  
10 0.0 ZX_UPDATE Z 0 1, 1
  
10 0.0 ZX_SELECT Z 0 1, 1
  
10 0.0 ZX_EXIT Z 0 1, 1
  
10 0.0 ZX_DELETE Z 0 1, 1
  
10 0.0 ZX_PRINT Z 0 1, 1