Freshmark replication server

freshmark-canonical

Program drill-down

BUYER_TRANS_SUMM2

BUYER TRANS ENQ SUMM SLS SECT. Type DSP, base table STK_TRANS.

Field inventory

37

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 Label 1 T -1 1, 25
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 3 T -1 281, 49
  
1 0.0 Label 4 T -1 621, 25
  
1 0.0 Label 5 T -1 671, 25
  
1 0.0 Label 6 T -1 621, 49
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 Label 8 T -1 271, 253
  
1 0.0 Label 9 T -1 281, 181
  
1 0.0 SELDATE I -1 351, 181
$CALCULATE  M:  A:VAR;I\SELDATE;I\SELDATE;;YYYY/MM/DD
1 0.0 BUYER I -1 351, 253
$SELECT  S:DEBTOR;I\BUYER    $CALCULATE  M:    I:I\BUYER;<>;  DO(DDD)    F:DEBTOR_MAST;Y;;T\NAME=DM_NAME;DM_MARKET = '$I\MARKET$' AND DM_DEBTOR = '$I\BUYER$';I\BUYER  DOEND(DDD)      
1 0.0 CMD 12 C -1 451, 253
$SELECT  S:DEBTOR;I\BUYER
1 0.0 Label 13 T -1 481, 253
  
1 0.0 Work 15 I 0 41, 61
$DEFAULT  A:USERID;;I\USERID
1 0.0 Work 16 I 0 61, 61
$DEFAULT  A:USERIP;;I\IP
1 0.0 Work 17 I 0 1, 61
$DEFAULT  A:ORGS;;I\AGENT
1 0.0 Work 18 I 0 21, 61
$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    A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  ''A:TIMER_ON;1000    A:DATE;DD MMM YYYY;I\SELDATE
1 0.0 CMD 19 C -1 341, 397
$SELECT  I:I\SELDATE;=;  D:PLEASE ENTER A DATE;ERRORM;I\SELDATE    I:I\BUYER;=;  D:BUYER IS A MANDATORY FIELD;ERRORM;I\BUYER    I:I\MODE;<>;D  DO(SLA)    I:I\MODE;<>;P    D:PLEASE ENTER OPTION!;ERRORM;I\MODE  DOEND(SLA)    A:CONST;IN PROGRESS...;T\PROG    I:I\MODE;=;P  U:CALL_CONDENSED_BUYER_ENQ_SLSSECT;CALL    I:I\MOD
1 0.0 Label 1 T -1 271, 289
  
1 0.0 CMD 2 C -1 451, 289
  
1 0.0 DOCNO I -1 351, 289
$SELECT  I:I\SECTION;=;  S:DOCNO_AGN_COND;I\DOCNO;I\AGENT;I\BUYER;I\SELDATE    I:I\SECTION;<>;  S:DOCNO_AGN_COND2;I\DOCNO;I\AGENT;I\BUYER;I\SECTION;I\SELDATE    $CALCULATE  C:UCASE  I:I\DOCNO;<>;  DO(C33)    I:I\SECTION;=;    F:STK_TRANS;Y;;I\DOCNO=ST_DOCNO;ST_MARKET='$I\MARKET$' AND ST_AGENT='$I\AGENT$' AND ST_DEBTOR=
1 0.0 Label 1 T -1 271, 361
  
1 0.0 Check 2 K -1 351, 361
$CALCULATE  O:SETFOCUS;C\PRINT  O:BACKCOLOR;C\PRINT;YELLOW
1 0.0 Label 1 T -1 271, 325
  
1 0.0 MODE I -1 351, 325
$CALCULATE  C:UCASE  V:P;D;    I:I\MARKET;=;17  DO(B33)    I:I\MODE;=;    A:CONST;P;I\MODE  DOEND(B33)    I:I\MARKET;<>;17  DO(FK3)    I:I\MODE;=;    A:CONST;D;I\MODE  DOEND(FK3)    I:I\MODE;=;P  A:CONST;PRINT OPTION;T\ODESC    I:I\MODE;=;D  A:CONST;DISPLAY OPTION;T\ODESC    I:I\DOCNO;<>;  DO(D3C)    O:SETFOCUS;C\PRINT
1 0.0 Label 3 T -1 481, 325
  
1 0.0 Label 1 T -1 251, 217
  
1 0.0 Work 2 I -1 351, 217
$SELECT  S:SALES_SECTION_PRT;I\SECTION;I\AGENT  '''S:SECTION_MAST;I\SECTION  '''S:SLS_SECT_PROPER;I\SECTION;I\AGENT    $VALIDATE  A:CONST;;T\SECTION2  C:UCASE        ''I:I\SECTION;<>;  ''F:SECT_MAST;Y;;T\SECTION2=SE_DESC;SE_SECT='$I\SECTION$' AND SE_DELIND <> 'Y';I\SECTION  I:I\SECTION;<>;  F:SLSSECT_ACCESS;Y;;;SS_SECT
1 0.0 CMD 4 C -1 451, 217
$SELECT  S:SALES_SECTION_PRT;I\SMAN;I\SECTION
1 0.0 Label 3 T -1 481, 217
  
1 0.0 Label 1 T -1 341, 433
  
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