Freshmark replication server

freshmark-canonical

Program drill-down

STATIC_CONS

STATIC CONSIGNMENT. Type DSP, base table STK_DETS.

Field inventory

44

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Work 2 I -1 351, 313
$VALIDATE  M:  O:SETFOCUS;C\RUN
1 0.0 Label 12 T -1 671, 25
  
1 0.0 Work 18 I 0 1, 61
$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    '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   
1 0.0 Work 17 I 0 41, 61
  
1 0.0 Work 16 I -1 351, 217
$SELECT  S:PRODUCT;I\PROD    $CALCULATE    C:UCASE  A:CONST;;T\MSG  I:I\PROD;<>;  DO(1)  F:PRODUCT_MAST;Y;;T\PNAME=PR_DESC;PR_PRODUCT = '$I\PROD$';I\PROD  DOEND(1)  I:I\PROD;=;  DO(2)  O:DISABLEINPUT;I\VAR,C\VAR  DOEND(2)    
1 0.0 Label 1 T 0 201, 337
  
1 0.0 Work 2 I 0 351, 337
$VALIDATE  C:UCASE    V:Y;N    O:SETFOCUS;C\RUN  O:BACKCOLOR;C\RUN;YELLOW
1 0.0 Label 1 T -1 201, 313
  
1 0.0 Work 15 I -1 351, 265
$SELECT  S:SALESMAN_AGENT;I\SMAN;I\AGENT    $VALIDATE  A:CONST;;T\SMAN_NAME    'ZEROFILL  A:ZEROFILL;I\SMAN,3;I\SMAN    C:UCASE.  I:I\SMAN;<>;  F:SALESMAN_MAST;Y;;T\SMAN_NAME=SLS_NAME;SLS_CODE='$I\SMAN$' AND SLS_AGENT='$I\AGENT$';I\SMAN
1 0.0 Work 5 I 0 1, 253
  
1 0.0 CMD 19 C -1 451, 193
$SELECT  S:AGENT_CODE;I\AGENT
1 0.0 CMD 1 C -1 301, 385
$SELECT    E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_STATIC_CONSIGNMENT_CPT;$I\MARKET$,$I\AGENT$,$I\PROD$,$I\VAR$,$I\SMAN$,$I\SECT$,$I\INT_DAYS$,S  'E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_STATIC_CONSIGNMENT_CPT;$I\MARKET$,$I\AGENT$,$I\PROD$,$I\VAR$,$I\SMAN$,$I\SECT$,$I\INT_DAYS$,$I\DUMP
1 0.0 Work 1 I 0 1, 157
  
1 0.0 Work 2 I 0 1, 181
  
1 0.0 Work 3 I 0 1, 205
  
1 0.0 Label 1 T -1 201, 289
  
1 0.0 Work 2 I -1 351, 289
$SELECT  S:SECTION;I\SECT    $CALCULATE    C:UCASE    I:I\SECT;<>;  DO(02)  F:SECT_MAST;Y;;T\SNAME=SE_DESC;SE_SECT='$I\SECT$';I\SECT  DOEND(02)  
1 0.0 Work 4 I 0 1, 229
  
1 0.0 CMD 3 C -1 451, 289
$SELECT  S:SECTION;I\SECT  
1 0.0 H -1 0, 0
  
1 0.0 Work 1 I 0 1, 97
  
1 0.0 Work 1 I 0 1, 121
  
1 0.0 Work 13 I -1 351, 193
$SELECT  S:AGENT_CODE;I\AGENT    $CALCULATE  I:I\AGENT;<>;  DO(LSS)  C:UCASE  F:AGENT_MAST;Y;;T\NAME=AM_NAME;AM_CODE='$I\AGENT$'  DOEND(LSS)
1 0.0 Work 14 I -1 351, 241
$SELECT  S:VAR_MAST_PROD;I\VAR;I\PROD    $CALCULATE  C:UCASE  I:I\VAR;<>;  F:VAR_MAST;Y;;T\VNAME=VA_DESC;VA_PRODUCT='$I\PROD$' AND VA_VARIETY='$I\VAR$';I\VAR
1 0.0 Label 1 T -1 291, 25
  
1 0.0 Label 5 T -1 201, 265
  
1 0.0 Label 6 T -1 201, 217
  
1 0.0 Label 3 T -1 201, 193
  
1 0.0 Label 9 T -1 621, 49
  
1 0.0 Label 10 T -1 621, 25
  
1 0.0 Label 2 T -1 291, 49
  
1 0.0 Label 11 T -1 671, 49
  
1 0.0 Label 4 T -1 201, 241
  
1 0.0 Label 8 T -1 1, 25
  
1 0.0 Label 21 T -1 481, 193
  
1 0.0 Label 1 T -1 341, 421
  
1 0.0 CMD 1 C -1 451, 217
$SELECT  S:PRODUCT;I\PROD
1 0.0 CMD 2 C -1 451, 241
$SELECT  S:VAR_MAST_PROD;I\VAR;I\PROD
1 0.0 CMD 3 C -1 451, 265
$SELECT  S:SALESMAN_AGENT;I\SMAN;I\AGENT
10 0.0 ZX_UPDATE Z 0 0, 0
  
10 0.0 ZX_EXIT Z 0 0, 0
  
10 0.0 ZX_PRINT Z 0 0, 0
  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 0, 0