Freshmark replication server

freshmark-canonical

Program drill-down

CONSIGN_STOCK_PRT

CONSIGN STOCK BY SALES SECT BY ITEM. Type DSP, base table STK_DETS.

Field inventory

47

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Work 14 I 0 21, 265
'$SELECT  'S:ITEM_NEW;I\ITEM      '$VALIDATE  'C:UCASE  'I:I\ITEM;<>;  'F:STK_DETS;Y;;;SD_ITEM ='$I\ITEM$';I\ITEM       'O:SETFOCUS;C\RUN  'O:BACKCOLOR;C\RUN;YELLOW            '/PRINT=PRINT_CONS_STK_BAL_BY_SLSSECT_ITEM;,11,,,S /IC:\LEGEND\PROJ_FMS\INI\LAZOLA\FMS.INI   'E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT
1 0.0 Label 4 T -1 171, 265
  
1 0.0 Label 5 T -1 221, 205
  
1 0.0 Label 5 T -1 171, 361
  
1 0.0 Label 5 T -1 511, 517
  
1 0.0 Label 6 T -1 171, 301
  
1 0.0 Label 6 T 0 21, 265
  
1 0.0 Label 7 T -1 621, 25
  
1 0.0 Label 8 T -1 671, 25
  
1 0.0 Label 9 T -1 671, 49
  
1 0.0 Work 13 I -1 391, 361
$SELECT  S:SALES_SECTION_PRT;I\SSECT;I\AGENT    $VALIDATE  I:I\SSECT;<>;  F:SLSSECT_ACCESS;Y;;;SS_SECT='$I\SSECT$';I\SSECT    'F:STK_DETS;Y;;;LEFT(SD_CONSIGN, 3)='$I\SSECT$';I\SSECT    'O:SETFOCUS;C\RUN  'O:BACKCOLOR;C\RUN;YELLOW
1 0.0 Work 3 I 0 1, 205
$DEFAULT  A:ORGS;;I\ORGS  A:CONST;$I\ORGS$;I\AGENT    I:I\ORGS;<>;  DO(03)  O:DISABLEINPUT;I\AGENT,C\AGENT   O:SETFOCUS;I\SELECTION  F:AGENT_MAST;;;T\NAME=AM_NAME;AM_CODE='$I\ORGS$'  DOEND(03)      
1 0.0 Work 18 I 0 1, 169
  
1 0.0 Work 16 I 0 1, 133
$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      I:I\MARKET;<>;65  O:HIDE;T\SELECT,I\SELECT    A:CONST;N;I\DUMP
1 0.0 Work 15 I 0 1, 97
$DEFAULT  A:USERID;;I\AGENT  A:TIME,HH:MM:SS;T\TIME  A:DATE;DD MMM YYYY;T\DATE  '''A:TIMER_ON;1000    O:SETFOCUS;I\AGENT
1 0.0 Label 1 T -1 221, 97
  
1 0.0 Label 10 T -1 621, 49
  
1 0.0 Label 17 T -1 531, 265
  
1 0.0 Label 2 T -1 221, 133
  
1 0.0 Label 2 T -1 1, 25
  
1 0.0 Label 3 T -1 221, 157
  
1 0.0 Label 3 T -1 221, 49
  
1 0.0 Label 4 T -1 221, 181
  
1 0.0 Check 2 K -1 391, 457
$VALIDATE    'O:SETFOCUS;C\RUN  'O:BACKCOLOR;C\RUN;YELLOW
1 0.0 Label 3 T -1 171, 457
  
1 0.0 Label 1 T -1 291, 25
  
1 0.0 Work 7 I -1 391, 301
$VALIDATE    V:1;2;3;4;5    
1 0.0 CMD 4 C -1 361, 517
$SELECT     A:CONST;;T\PROG    I:I\SELECTION;=;  D:PLEASE ENTER SELECTION;ERRORM;I\SELECTION        I:I\SELECTION;=;1  DO(01)  A:CONST;COLLECTING DATA...;T\PROG  E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_CONS_STK_BAL_BY_SLSSECT_ITEM;$I\AGENT$,$I\MARKET$,$I\SSECT$,$I\ITEM$,$K\DBL_SPACE$,$I\SUPPL$,$K\INDIC
1 0.0 Label 1 T -1 171, 325
  
1 0.0 Work 3 I -1 391, 325
$VALIDATE    C:UCASE    V:W;N;A  
1 0.0 Label 1 T -1 171, 481
  
1 0.0 Work 2 I -1 391, 481
$VALIDATE  C:UCASE    V:Y;N    O:SETFOCUS;C\RUN  O:BACKCOLOR;C\RUN;YELLOW
1 0.0 Label 1 T -1 221, 229
  
1 0.0 CMD 1 C -1 491, 361
$SELECT  S:SALES_SECTION_PRT;I\SSECT;I\AGENT  
1 0.0 CMD 3 C 0 121, 265
  
1 0.0 CMD 1 C -1 491, 265
$SELECT  S:AGN_CODE;I\AGENT
1 0.0 I -1 391, 265
$SELECT    S:AGN_CODE;I\AGENT    $VALIDATE  A:CONST;;T\PROG  'M:  C:UCASE  I:I\AGENT;<>;  F:AGENT_MAST;Y;;W\ACCTYPE=AM_TYPE,T\NAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT    'I:I\ORGS;<>;  'DO(01)  'D:YOU NOT ALLOWED TO ENTER ANOTHER AGENT;ERRORM;I\AGENT  'DOEND(01)  
1 0.0 H -1 0, 0
  
1 0.0 Label 1 T -1 171, 397
  
1 0.0 Work 2 I -1 391, 397
$VALIDATE    I:I\SUPPL;<>;  F:SUPPLIER_MAST;Y;;;SUM_SUPPL='$I\SUPPL$';I\SUPPL
1 0.0 Check 2 K -1 391, 433
  
1 0.0 Label 1 T -1 171, 433
  
10 0.0 ZX_UPDATE Z 0 0, 0
  
10 0.0 ZX_DELETE 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_SELECT Z 0 0, 0