Freshmark replication server

freshmark-canonical

Program drill-down

DAILY_MKT_PRICES

DAILY MARKET PRICES. Type DSP, base table TROLLEY_MAST.

Field inventory

54

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 Work 11 I -1 401, 289
  
1 0.0 CMD 1 C -1 651, 548
$SCMD_FOCUS  O:BACKCOLOR;C\RUN;YELLOW      $SELECT  A:CONST;;I\ALLOW  I:I\SELECT;=;  D:SELECTION FIELD IS MANDATORY;ERRORM;I\SELECT    'JER TEMP DELETE  'I:I\MARKET;=;11  'DO(PAF3)  '  U:DATE_TIME_CHECK;CHECK  '  I:I\TMP_IND;=;Y  '  D:TODAYS STATS ARE CLOSED UNTILL 11AM;ERRORM;I\SELECT  'DOEND(PAF3)      I:I\CM_ALLOW_M
1 0.0 Label 1 T -1 171, 505
  
1 0.0 Work 1 I -1 401, 505
$VALIDATE  C:UCASE  V:N;Y      O:SETFOCUS;C\RUN  O:BACKCOLOR;C\RUN;YELLOW
1 0.0 Label 1 T -1 171, 253
  
1 0.0 Check 2 K -1 401, 253
  
1 0.0 Label 2 T -1 281, 25
  
1 0.0 Label 3 T -1 301, 49
  
1 0.0 MARKET I 0 31, 85
$DEFAULT  O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\RUN    'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\DELNO_BY_AGENT=CM_DEL_BY_AGENT,I\CM_PROHIBIT_STATS=CM_PROHIBIT_STATS,I\CM_ALLOW_MNTH_REPORT=CM_ALLOW_MNTH_REPORT    'CONVERT ONLY THE FIRST CHAR
1 0.0 Label 5 T -1 621, 25
  
1 0.0 Label 6 T -1 671, 25
  
1 0.0 Label 7 T -1 621, 49
  
1 0.0 Label 8 T -1 671, 49
  
1 0.0 Label 9 T -1 1, 25
  
1 0.0 ORGS I 0 91, 85
$DEFAULT  A:ORGS;;I\ORGS    'I:I\ORGS;<>;  'DO(PAS)  '  O:DISABLEINPUT;C\RUN,C\COMPLETE  '  D:AGENTS MAY NOT RUN THIS SCREEN;ERRORM;  'DOEND(PAS)    'I:I\ORGS;=;  'DO(PAS)  '  O:ENABLEINPUT;C\RUN,C\COMPLETE  'DOEND(PAS)
1 0.0 Label 6 T -1 171, 217
  
1 0.0 Label 7 T -1 171, 361
  
1 0.0 Work 1 I -1 401, 217
$VALIDATE    V:1;2;3;4    I:I\SELECT;=;2  DO(02)  A:CONST;;I\END_ITEM  O:HIDE;I\END_ITEM,T\END_ITEM,C\START_ITEM,C\END_ITEM  O:SHOW;I\START_ITEM,T\START_ITEM,T\DUMP,I\DUMP  DOEND(02)    I:I\SELECT;=;1  DO(07)  O:SHOW;I\START_ITEM,T\START_ITEM,C\START_ITEM  O:ENABLEINPUT;I\START_ITEM;I\END_ITEM,C\START_ITEM,C\END_ITEM,T
1 0.0 Work 2 I -1 401, 361
$SELECT  I:I\SELECT;<>;2  DO(01)  S:ITEM_SEL;I\START_ITEM  A:SELPARM;2;I\PROD  A:CON;I\START_ITEM;I\START_ITEM;I\PROD  DOEND(01)    $VALIDATE  A:CONST;;I\PROD,I\VAR  C:UCASE    I:I\SELECT;=;2   DO(SEL)    V:PO;TO;ON    O:SETFOCUS;C\RUN    O:BACKCOLOR;C\RUN;YELLOW       DOEND(SEL)      I:I\SELECT;<>;2   DO(NOT2)    I:I\
1 0.0 Label 4 T -1 291, 97
  
1 0.0 Label 5 T -1 291, 121
  
1 0.0 Work 10 I -1 401, 397
$SELECT  I:I\SELECT;<>;2  DO(02)  S:ITEM_SEL;I\END_ITEM  A:SELPARM;2;I\PROD2  A:CON;I\END_ITEM;I\END_ITEM;I\PROD2  DOEND(02)    $VALIDATE  A:CONST;;I\PROD2,I\VAR2  C:UCASE    I:I\SELECT;<>;2   DO(NOT2)    I:I\END_ITEM;<>;     DO(NOT_EMPTY)       A:LEFT;I\END_ITEM,2;I\PROD2      A:RIGHT;I\END_ITEM,2;I\VAR2      F:VAR_MA
1 0.0 Work 12 I -1 401, 325
$VALIDATE  A:CONST;;I\ALLOW  I:I\TO_DATE;<>;   DO(03)    I:I\FROM_DATE;<>;    DO(02)     A:DATEDIFF;I\TO_DATE;I\DATEDIFF;I\FROM_DATE     I:I\DATEDIFF;<;0     D:TO DATE CANNOT BE LESS THAN FROM DATE;ERRORM;I\TO_DATE    DOEND(02)   DOEND(03)        I:I\FROM_DATE;=;  A:CONST;$T\DATE$;I\FROM_DATE    I:I\TO_DATE;=;  A:CONST
1 0.0 Label 13 T -1 171, 289
  
1 0.0 Label 9 T -1 171, 397
  
1 0.0 Label 14 T -1 171, 325
  
1 0.0 Work 15 I 0 371, 541
  
1 0.0 Work 1 I -1 401, 433
  
1 0.0 Work 2 I -1 401, 469
$VALIDATE  
1 0.0 Label 3 T -1 171, 433
  
1 0.0 Label 4 T -1 171, 469
  
1 0.0 Label 5 T -1 291, 145
  
1 0.0 Label 1 T -1 291, 169
  
1 0.0 Work 2 I -1 401, 361
$SELECT  S:SECTION_MAST;I\SECTION    $VALIDATE  C:UCASE  I:I\SECTION;<>;  F:SECT_MAST;Y;;T\SECT_NAME=SE_DESC;SE_SECT='$I\SECTION$' AND SE_DELIND <> 'Y';I\SECTION      O:SETFOCUS;C\RUN  O:BACKCOLOR;C\RUN;YELLOW
1 0.0 Label 3 T -1 171, 361
  
1 0.0 Label 5 T -1 531, 361
  
1 0.0 CMD 5 C -1 501, 361
I:I\SELECT;<>;2  DO(01)  S:ITEM_SEL;I\START_ITEM  A:SELPARM;2;I\PROD  A:CON;I\START_ITEM;I\START_ITEM;I\PROD  DOEND(01)
1 0.0 Work 1 I 0 531, 169
  
1 0.0 Work 3 I 0 531, 193
  
1 0.0 Work 4 I 0 561, 193
  
1 0.0 CMD 4 C -1 501, 361
$SELECT  S:SECTION_MAST;I\SECTION
1 0.0 Work 2 I 0 561, 169
  
1 0.0 CMD 7 C -1 501, 397
$SELECT  I:I\SELECT;<>;2  DO(02)  S:ITEM_SEL;I\END_ITEM  A:SELPARM;2;I\PROD2  A:CON;I\END_ITEM;I\END_ITEM;I\PROD2  DOEND(02)
1 0.0 Work 1 I 0 171, 553
  
1 0.0 Work 1 I 0 121, 85
  
1 0.0 TMP_IND I 0 671, 517
  
1 0.0 Work 1 I 0 131, 553
  
1 0.0 Work 1 I 0 151, 553
  
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