Freshmark replication server

freshmark-canonical

Program drill-down

CS_STATIC_LISTING

CS STATIC LISTING. Type DSP, base table LOC_TRANS.

Field inventory

40

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 1 T -1 1, 25
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 3 T -1 271, 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 8 T -1 11, 181
  
1 0.0 Label 9 T -1 11, 349
  
1 0.0 Work 10 I -1 181, 349
'$CALCULATE  'O:SETFOCUS;C\GO  'O:BACKCOLOR;C\GO;YELLOW
1 0.0 Work 11 I -1 181, 181
$VALIDATE  V:1;2;3;4;5;6    I:I\OPTION;=;1  DO(1)  O:SHOW;T\DEPNO,I\DEPNO,C\DEPNO  O:SETFOCUS;I\DEPNO  O:ENABLEINPUT;C\DEPNO  DOEND(1)    I:I\OPTION;<>;6  O:HIDE;I\AGENT,T\AGENT,C\AGENT,I\ITEM,T\ITEM,C\ITEM    I:I\OPTION;=;6  DO(01)  O:SHOW;I\AGENT,T\AGENT,C\AGENT,I\ITEM,T\ITEM,C\ITEM  O:ENABLEINPUT;I\AGENT,T\AGENT,C\A
1 0.0 Work 12 I 0 41, 61
$DEFAULT  A:ORGS;;I\ORGS
1 0.0 Work 13 I 0 21, 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:CONST;N;I\DUMP  
1 0.0 Label 3 T -1 11, 277
  
1 0.0 Work 14 I 0 1, 61
$DEFAULT  A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000      O:HIDE;T\AGENT,C\AGENT,I\ITEM,T\ITEM,C\ITEM,I\AGENT,T\DEPNO,I\DEPNO,C\DEPNO    
1 0.0 CMD 16 C -1 301, 433
$SELECT    I:I\DEPOSITS;=;  D:PLEASE SPECIFY WHICH DEPOSITS;ERRORM;I\DEPOSITS    I:I\DEPOSITS;=;  D:PLEASE SPECIFY WHICH ROOMS;ERRORM;I\ROOMS        I:I\OPTION;=;  D:PLEASE SPECIFY AN ORDER OPTION;ERRORM;I\OPTION    'U:CS_STATIC_LISTING;VIEW 'MICHAEL 2010 APR 21 USE NEW REPORT INSTEAD OF OLD ONE  'E:$GBLROOT$LEGEND\PRO
1 0.0 Label 1 T -1 11, 385
  
1 0.0 Work 2 I -1 181, 385
$VALIDATE    C:UCASE    V:Y;N    O:SETFOCUS;C\GO  O:BACKCOLOR;C\GO;YELLOW
1 0.0 Work 1 I -1 181, 241
$SELECT  I:I\ORGS;<>;  S:DEPOSIT1;I\DEPNO;I\MARKET    I:I\ORGS;=;  S:DEPOSIT;I\DEPNO;I\MARKET    $VALIDATE  I:I\DEPNO;<>;  'A:VAR;I\LT_DEPNO;I\LT_DEPNO;;00000000000    I:I\ORGS;<>;  F:LOC_TRANS;;;;LT_DEPNO='$I\DEPNO$' AND LT_AGENT='$I\ORGS$' AND LT_TYPE= 'DP' AND LT_DELIND <> 'Y';I\DEPNO    I:I\ORGS;=;  F:LOC_TRANS;;;;
1 0.0 Label 2 T -1 11, 241
  
1 0.0 Label 1 T -1 11, 109
  
1 0.0 Label 2 T -1 11, 145
  
1 0.0 DEPOSITS I -1 181, 109
$VALIDATE    C:UCASE    V:O;A      
1 0.0 Label 17 T -1 241, 181
  
1 0.0 Label 18 T -1 241, 205
  
1 0.0 Label 4 T -1 11, 313
  
1 0.0 Work 1 I -1 181, 313
$SELECT  S:ITEM_NEW;I\ITEM    $VALIDATE  C:UCASE    I:I\ITEM;<>;  DO(OPA)    A:LEN;I\ITEM;W\LEN    A:LEFT;I\ITEM,2;W\PROD    I:W\LEN;>;2    F:STK_DETS;Y;;;SD_ITEM = '$I\ITEM$';;;   ITEM DOES NOT EXIST    I:W\LEN;<=;2    F:PRODUCT_MAST;Y;;;PR_PRODUCT='$W\PROD$';;;  PRODUCT DOES NOT EXIST      DOEND(OPA)
1 0.0 ROOMS I -1 181, 145
$VALIDATE    C:UCASE    V:M;A
1 0.0 Work 2 I -1 181, 277
$SELECT  S:AGENT_CODE;I\AGENT    $CALCULATE  A:CONST;;T\AGENT2  'M:  C:UCASE    'DISABLE AGENT FIELD FOR AGENTS  I:I\AGENT;<>;  F:AGENT_MAST;Y;;T\AGENT2=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT
1 0.0 CMD 5 C -1 281, 277
$SELECT  S:AGENT_CODE;I\AGENT
1 0.0 CMD 6 C -1 281, 313
$SELECT  S:ITEM_NEW;I\ITEM
1 0.0 Work 1 I 0 481, 397
  
1 0.0 Work 2 I 0 511, 397
  
1 0.0 CMD 3 C -1 281, 241
$SELECT  S:DEPOSIT;I\DEPNO;I\MARKET
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