Freshmark replication server

freshmark-canonical

Program drill-down

DUMP_BUYER_PURCH_PRE

BUYER PURCHASE DUMP. Type DSP, base table STK_TRANS.

Field inventory

39

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Label 1 T -1 1, 25
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 Label 3 T -1 301, 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 H -1 0, 0
  
1 0.0 Label 11 T -1 261, 193
  
1 0.0 Label 12 T -1 261, 229
  
1 0.0 Label 13 T -1 261, 265
  
1 0.0 Label 14 T -1 261, 301
  
1 0.0 Label 15 T -1 261, 337
  
1 0.0 Label 16 T -1 261, 373
  
1 0.0 Label 17 T -1 261, 409
  
1 0.0 Work 18 I -1 371, 157
$SELECT  S:AGENT_CODE;I\AGENT    $CALCULATE    C:UCASE  I:I\AGENT;<>;  F:AGENT_MAST;Y;;T\ANAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT    I:I\AGENT;=;  A:CONST;;T\NAME
1 0.0 Work 19 I -1 371, 193
$SELECT  S:MAIN_DEBTOR;I\DEBTOR    $CALCULATE  A:CONST;;T\NAME  M:  C:UCASE    'CHECK IF EXISTS  F:DEBTOR_MAST;Y;;T\NAME=DM_NAME;DM_DEBTOR='$I\DEBTOR$';I\DEBTOR
1 0.0 Work 20 I -1 371, 229
$CALCULATE  I:I\FROM_DATE;=;  A:DATE;DD MMM YYYY;I\FROM_DATE
1 0.0 Work 21 I -1 371, 265
$CALCULATE  I:I\TO_DATE;=;  A:DATE;DD MMM YYYY;I\TO_DATE
1 0.0 Work 22 I -1 371, 301
$VALIDATE    I:I\FROM_TIME;<>;  DO(1)   'CHECK THAT THE THIRD DIGIT IS A ":"   A:MID;I\FROM_TIME,3,1;I\TMP1     I:I\TMP1;<>;:    D:ENTER IN FORMAT XX:XX;ERRORM;I\FROM_TIME     'CHECK THAT THE FIRST TWO DIGITS ARE BETWEEN 00 AND 24   A:LEFT;I\FROM_TIME,2;I\TMP1     I:I\TMP1;>;23    D:CANNOT BE GREATER THAN 23:59;ERRORM;
1 0.0 Work 23 I -1 371, 337
$VALIDATE    I:I\TO_TIME;<>;  DO(2)   A:MID;I\TO_TIME,3,1;I\TMP2     I:I\TMP2;<>;:     D:ENTER IN FORMAT XX:XX;ERRORM;I\TO_TIME     'CHECK THAT THE FIRST TWO DIGITS ARE BETWEEN 00 AND 24   A:LEFT;I\TO_TIME,2;I\TMP2     I:I\TMP2;>;23    D:CANNOT BE GREATER THAN 23:59;ERRORM;I\TO_TIME     'CHECK THAT THE LAST TWO DIGITS 
1 0.0 Work 24 I -1 371, 373
$VALIDATE    'UPPERCASE  C:UCASE    V:N;;Y  I:I\PAID;=;  DO(1)  'A:CONST;N;I\PAID  DOEND(1)
1 0.0 Work 25 I -1 371, 409
$VALIDATE    'UPPERCASE  C:UCASE    V:N;Y  I:I\DUMP;=;  DO(1)  A:CONST;N;I\DUMP  DOEND(1)  O:BACKCOLOR;C\DUMP;YELLOW  O:SETFOCUS;C\DUMP
1 0.0 CMD 26 C -1 471, 157
$SELECT  S:AGENT_CODE;I\AGENT
1 0.0 CMD 28 C -1 471, 193
$SELECT  S:MAIN_DEBTOR;I\DEBTOR
1 0.0 Label 29 T -1 501, 157
  
1 0.0 Label 30 T -1 501, 193
  
1 0.0 CMD 31 C -1 291, 445
$SELECT    A:CONST;DUMP IN PROGRESS;T\PROG  E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_BUYER_PURCHASE_DUMP_PRE;$I\MARKET$,$I\FROM_DATE$,$I\TO_DATE$,$I\FROM_TIME$,$I\TO_TIME$,$I\DEBTOR$,$I\AGENT$,$I\PAID$,$I\DUMP$,S  A:CONST;DUMP COMPLETED!!;T\PROG    A:DATE;DD MMM YYYY;I\FROM_DATE  A:DATE;DD MMM YYYY;I\TO
1 0.0 Label 32 T -1 281, 469
  
1 0.0 Work 33 I 0 1, 493
  
1 0.0 Work 34 I 0 1, 457
  
1 0.0 Label 10 T -1 261, 157
  
1 0.0 Work 8 I 0 1, 61
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET  A:ORGS;;I\ORGS  A:ORGS;;I\AGENT  '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    'INITIALIZES THE DATE AND TIME INTO THE T\DATE AND T\TIME FIELDS  A:DATE;DD MMM YYYY;T\DATE  A:TIM
1 0.0 Work 9 I 0 31, 61
  
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
  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_UPDATE Z 0 0, 0