Freshmark replication server

freshmark-canonical

Program drill-down

AGN_STK_SHT_FOR_DUR

AGENT STOCK SHEET BY SECT,ITEM,SUPPL. Type DSP, base table STK_MAST.

Field inventory

45

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 1 C -1 391, 133
$SELECT  S:AGENT_CODE;I\AGENT
1 0.0 CMD 3 C -1 441, 205
$SELECT  S:SECT_MAST4;I\SECTION
1 0.0 CMD 6 C -1 441, 277
$SELECT  S:SUPPLIER_CODE;I\SUPPLIER  
1 0.0 CMD 1 C -1 271, 361
$SELECT  I:I\MARKET;<>;15  DO(N_15)  A:CONST;IN PROGRESS ...;T\PROG  E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_AGN_STOCK_SECT_ITEM_SUPP;$I\MARKET$,$I\AGENT$,$I\SMAN$,$I\SECTION$,$I\ITEM$,$I\SUPPLIER$,$I\NOT_AUTO$,$I\DUMP$,S  A:CONST;COMPLETE;T\PROG    I:I\ORGS;<>;   DO(AGENT)    O:DISABLEINPUT;I\AGENT,C\
1 0.0 Work 1 I 0 1, 253
  
1 0.0 Work 1 I 0 1, 217
  
1 0.0 Label 1 T -1 311, 397
  
1 0.0 H -1 0, 30
  
1 0.0 MARKET I 0 111, 67
$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    '20230329 THEUNIS FOR AUTO RUN  A:CONST;N;I\NOT_AUTO    A:VAR;I\MARKET;I\TM_MARKET    A:CONST;N;I\DUMP    $AFTER_READ  A:VAR;I\MA
1 0.0 DEFAULT I 0 141, 67
'DISPLAYING TIME  $DEFAULT  A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  'A:TIMER_ON;1000
1 0.0 AGENT I -1 341, 133
$SELECT  S:AGENT_CODE;I\AGENT    $VALIDATE  A:CONST;;T\AGENT1,I\SUPPLIER,I\ITEM,I\SECTION,T\SUPP_DESC,T\ITEM_DESC,T\SECT_DESC,T\PROG    C:UCASE  I:I\AGENT;<>;    F:AGENT_MAST;Y;AM_CODE;T\AGENT1=AM_NAME;AM_CODE='$I\AGENT$'    $AFTER_READ  I:I\AGENT;<>;    F:AGENT_MAST;Y;AM_CODE;T\AGENT1=AM_NAME;AM_CODE='$I\AGENT$'      
1 0.0 Work 2 I 0 161, 67
$DEFAULT  A:ORGS;I\ORGS,I\AGENT    A:VAR;I\ORGS;I\AGENT    F:AGENT_MAST;;AM_CODE;T\AGENT1=AM_NAME;AM_CODE='$I\AGENT$'    I:I\ORGS;<>;   DO(AGENT)    O:DISABLEINPUT;I\AGENT,C\AGENT    O:SETFOCUS;I\SECTION   DOEND(AGENT)    I:I\ORGS;=;   DO(NO_AGENT)    O:ENABLEINPUT;I\AGENT,C\AGENT    O:SETFOCUS;I\AGENT   DOEND(NO_AGENT
1 0.0 SECTION I -1 341, 205
$DEFAULT  'PUTS PIC ON THE UPDATE BUTTON  O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\CREATE    F:CLIENT_MAST;;;I\DEL_LEN=CM_DEL_LEN;CM_CODE='$I\MARKET$'    $SELECT  S:SECT_MAST4;I\SECTION      $VALIDATE  'M:  A:CONST;;T\SECT_DESC    C:UCASE  I:I\SECTION;<>;  F:SECT_MAST;Y;SE_SECT;T\SECT_DESC=SE_DESC;;I\
1 0.0 Work 2 I -1 341, 277
$SELECT  S:SUPPLIER_CODE;I\SUPPLIER    $VALIDATE    C:UCASE  I:I\SUPPLIER;<>;    F:SUPPLIER_MAST;Y;;T\SUPP_DESC=SUM_NAME;SUM_SUPPL='$I\SUPPLIER$';I\SUPPLIER    
1 0.0 Label 1 T -1 221, 313
  
1 0.0 Label 4 T -1 481, 241
  
1 0.0 Work 5 I 0 1, 133
  
1 0.0 Work 6 I 0 31, 133
  
1 0.0 Label 5 T -1 1, 25
  
1 0.0 Label 10 T -1 671, 25
  
1 0.0 Label 8 T -1 621, 50
  
1 0.0 Label 9 T -1 621, 25
  
1 0.0 Label 11 T -1 671, 50
  
1 0.0 Label 10 T -1 221, 133
  
1 0.0 Label 9 T -1 431, 133
  
1 0.0 Label 3 T -1 291, 25
  
1 0.0 Label 4 T -1 201, 49
  
1 0.0 Label 1 T -1 221, 205
  
1 0.0 Label 1 T -1 221, 277
  
1 0.0 Label 2 T -1 481, 277
  
1 0.0 Label 3 T -1 481, 205
  
1 0.0 Label 1 T -1 221, 241
  
1 0.0 Work 2 I -1 341, 241
$SELECT  I:I\SECTION;<>;  S:ITEM_NEW3;I\ITEM;I\SECTION    I:I\SECTION;=;  S:ITEM_NEW;I\ITEM    $VALIDATE  I:I\SECTION;<>;  DO(01)      I:I\ITEM;<>;      DO(02)   '     F:STK_DETS;;;W\ITEM=SD_ITEM;SD_SECT='$I\SECTION$' AND SD_ITEM='$I\ITEM$';I\ITEM        F:STK_DETS;;;W\ITEM=SD_ITEM;SD_SECT='$I\SECTION$' AND SD_ITEM LIK
1 0.0 Label 1 T -1 221, 169
  
1 0.0 Work 2 I -1 341, 169
$SELECT  I:I\AGENT;<>;  S:SALESMAN_AGENT;I\SMAN;I\AGENT    I:I\AGENT;=;  S:SALESMAN;I\SMAN    $VALIDATE  I:I\SMAN;<>;  DO(03)    I:I\AGENT;<>;    DO(AG)      F:SALESMAN_MAST;Y;;T\BNAME=SLS_NAME;SLS_CODE='$I\SMAN$' AND SLS_AGENT='$I\AGENT$';I\SMAN    DOEND(AG)        I:I\AGENT;=;    DO(AG)      F:SALESMAN_MAST;Y;;;SLS_C
1 0.0 Label 3 T -1 431, 169
  
1 0.0 CMD 4 C -1 391, 169
$SELECT  I:I\AGENT;<>;  S:SALESMAN_AGENT;I\SMAN;I\AGENT    I:I\AGENT;=;  S:SALESMAN;I\SMAN  
1 0.0 CMD 3 C -1 441, 241
$SELECT  I:I\SECTION;<>;  S:ITEM_NEW3;I\ITEM;I\SECTION    I:I\SECTION;=;  S:ITEM_NEW;I\ITEM
1 0.0 Work 3 I -1 341, 313
$CALCULATE    C:UCASE  V:Y;N;    O:SETFOCUS;C\PRINT  O:BACKCOLOR;C\PRINT;YELLOW  
1 0.0 Work 1 I 0 1, 169
  
10 0.0 ZX_SELECT Z 0 0, 30
  
10 0.0 ZX_UPDATE Z 0 0, 30
  
10 0.0 ZX_EXIT Z 0 0, 30
  
10 0.0 ZX_DELETE Z 0 0, 30
  
10 0.0 ZX_PRINT Z 0 0, 30