Freshmark replication server

freshmark-canonical

Program drill-down

BUYER_TURNOVER

BUYERS TURNOVER. Type DSP, base table STK_MAST.

Field inventory

50

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 3 C 0 101, 157
$SELECT  'S:SUPPLIER_CODE3;I\SUPPL_NO  S:SUPPLIER_CODE2;I\SUPPL_NO;I\MARKET;I\AGENT
1 0.0 CMD 5 C -1 651, 546
$SCMD_FOCUS  O:BACKCOLOR;C\CREATE;YELLOW    $SELECT    I:I\AGENT;<>;  F:AGENT_MAST;Y;;T\AGENT1=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT    I:I\TO_DATE;=;  A:CONST;$T\DATE$;I\TO_DATE    I:I\FROM_DATE;=;  A:CONST;$T\DATE$;I\FROM_DATE    I:I\FROM_BUYER;=;  DO(00)  I:I\TO_BUYER;<>;  D:PLEASE ENTER A FROM BUYER;ERRORM;I\FROM_BUY
1 0.0 CMD 4 C 0 101, 133
$SELECT  S:DELIVERY_NO2;I\DELNO;I\MARKET;I\AGENT  
1 0.0 CMD 1 C -1 391, 145
$SELECT  S:AGENT_CODE;I\AGENT
1 0.0 H -1 0, 0
  
1 0.0 Work 9 I 0 561, 493
  
1 0.0 Work 3 I 0 11, 193
  
1 0.0 DELNO I 0 531, 493
  
1 0.0 Work 1 I 0 1, 73
  
1 0.0 Work 8 I -1 341, 217
$VALIDATE    I:I\TO_DATE;=;  A:CONST;$T\DATE$;I\TO_DATE    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      
1 0.0 AGENT I -1 341, 145
$SELECT  S:AGENT_CODE;I\AGENT    $VALIDATE  A:CONST;;T\PROG   C:UCASE  I:I\AGENT;<>;  F:AGENT_MAST;Y;;T\AGENT1=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT    $AFTER_READ  A:ORGS;I\AGENT  F:AGENT_MAST;;AM_CODE;T\AGENT1=AM_NAME;AM_CODE='$I\AGENT$'        
1 0.0 Work 1 I 0 501, 493
  
1 0.0 Work 2 I 0 581, 145
$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\PERCENT   DOEND(AGENT)    I:I\ORGS;=;   DO(NO_AGENT)    O:ENABLEINPUT;I\AGENT,C\AGENT    O:SETFOCUS;I\AGENT   DOEND(NO_AGENT
1 0.0 SUPPL_NO I 0 1, 157
$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:SUPPLIER_CODE3;I\SUPPL_NO  'S:SUPPLIER_CODE2;I\SUPPL_NO;I\MARKET;I\AGENT    '$VALIDATE  ''M:    'I:I\SUPPL_NO;<>;  '  DO(SUPPL)  '   '
1 0.0 MARKET I 0 111, 37
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\CM_DIRECT=CM_DIRECT    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MARKET    'RETRIVING AGENT NAME  $DEFAULT  'A:ORGS;I\ORGS,I\AGENT  A:VAR;I\AGENT;I\ORGS  I:I\OGRS;<>;  DO(ORGS)  F:AG
1 0.0 DEFAULT I 0 141, 37
'DISPLAYING TIME  $DEFAULT  A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    A:CONST;$T\DATE$;I\FROM_DATE,I\TO_DATE
1 0.0 Work 7 I -1 341, 181
$VALIDATE    I:I\FROM_DATE;=;  A:CONST;$T\DATE$;I\FROM_DATE    
1 0.0 Label 1 T 0 1, 109
  
1 0.0 Label 5 T -1 191, 181
  
1 0.0 Label 6 T -1 191, 217
  
1 0.0 Label 4 T -1 291, 49
  
1 0.0 Label 1 T 0 1, 133
  
1 0.0 Label 11 T -1 671, 49
  
1 0.0 Label 10 T -1 191, 145
  
1 0.0 Label 9 T -1 431, 145
  
1 0.0 Label 1 T -1 301, 493
  
1 0.0 Label 3 T -1 291, 25
  
1 0.0 Label 9 T -1 621, 25
  
1 0.0 Label 5 T -1 1, 25
  
1 0.0 Label 8 T -1 621, 49
  
1 0.0 Label 10 T -1 671, 25
  
1 0.0 Label 1 T -1 191, 253
  
1 0.0 Label 2 T -1 191, 289
  
1 0.0 Label 3 T -1 191, 325
  
1 0.0 Label 4 T -1 191, 361
  
1 0.0 Label 5 T -1 191, 397
  
1 0.0 Work 6 I -1 341, 253
  
1 0.0 Work 7 I -1 341, 289
  
1 0.0 Work 8 I -1 341, 325
$SELECT  S:ACCOUNT_TYPE;I\ACC_TYPE    $VALIDATE  A:CONST;;T\PROG   C:UCASE  I:I\ACC_TYPE;<>;  F:ACCOUNT_TYPE;Y;;T\ACC_TYPE1=AT_DESC;AT_CODE='$I\ACC_TYPE$';I\ACC_TYPE    $AFTER_READ  A:ORGS;I\AGENT  F:ACCOUNT_TYPE;;AT_CODE;T\ACC_TYPE1=AT_DESC;AT_CODE='$I\ACC_TYPE$'  
1 0.0 Work 9 I -1 341, 361
$SELECT  S:BUYER_GROUP;I\BUYER_GROUP    $VALIDATE  A:CONST;;T\PROG   C:UCASE  I:I\BUYER_GROUP;<>;  F:BUYER_GROUP;Y;;T\BUYER_GROUP1=BG_DESC;BG_CODE='$I\BUYER_GROUP$';I\BUYER_GROUP    $AFTER_READ  A:ORGS;I\AGENT  F:BUYER_GROUP;;BG_CODE;T\BUYER_GROUP1=BG_DESC;BG_CODE='$I\BUYER_GROUP$'  
1 0.0 Work 10 I -1 341, 397
$VALIDATE    C:UCASE      V:N;Y    O:SETFOCUS;C\CREATE  O:BACKCOLOR;C\CREATE;YELLOW      
1 0.0 Label 1 T -1 481, 325
  
1 0.0 CMD 2 C -1 441, 361
$SELECT  S:BUYER_GROUP;I\BUYER_GROUP
1 0.0 CMD 1 C -1 441, 325
$SELECT  S:ACCOUNT_TYPE;I\ACC_TYPE
1 0.0 Label 2 T -1 481, 361
  
10 0.0 ZX_EXIT Z 0 0, 0
  
10 0.0 ZX_UPDATE 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_PRINT Z 0 0, 0