Freshmark replication server

freshmark-canonical

Program drill-down

CASHPNT_REC_KLE

CASHPOINT RECEIPT ANALYSIS. Type DSP, base table STK_TRANS.

Field inventory

31

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 12 C -1 431, 145
$SELECT  S:CASHIER_CODE;I\CASHIER
1 0.0 Label 6 T -1 291, 325
  
1 0.0 Label 10 T -1 211, 253
  
1 0.0 Label 15 T -1 211, 217
  
1 0.0 Label 13 T -1 211, 145
  
1 0.0 Work 9 I 0 1, 61
$DEFAULT  A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    '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;I\SDATE  A:DATE;DD MMM YYYY;I\EDATE  A:D
1 0.0 Work 11 I -1 321, 145
$SELECT  S:CASHIER_CODE;I\CASHIER    $CALCULATE  A:CONST;;I\BUYER,T\DESC,T\BYR_NAME,T\PROG  I:I\CASHIER;<>;  F:CASH_MAST;Y;;T\DESC=CSH_DESC;CSH_CASHIER='$I\CASHIER$';I\CASHIER    I:I\CASHIER;=;  A:CONST;;I\CASHIER,I\BUYER,T\DESC,T\BYR_NAME,T\PROG
1 0.0 Work 17 I -1 321, 253
$VALIDATE  I:I\EDATE;=;  A:DATE;DD MMM YYYY;I\EDATE    A:DATEDIFF;I\EDATE;I\DATEDIFF;I\SDATE    I:I\DATEDIFF;<;0  D:TO DATE CANNOT BE LESS THAN FROM DATE;ERRORM;I\EDATE    I:I\EDATE;<>;  A:DATEDIFF;W\FRMDATE;I\DATEDIFF;I\EDATE  I:I\DATEDIFF;<;0  D:TO DATE CANNOT BE LATER THAN TODAY'S DATE;ERRORM;I\EDATE      O:SETFOCUS
1 0.0 Label 1 T -1 1, 25
  
1 0.0 H -1 0, 0
  
1 0.0 Work 14 I -1 321, 217
$VALIDATE    I:I\SDATE;=;  A:DATE;DD MMM YYYY;I\SDATE    I:I\SDATE;<>;  A:DATEDIFF;W\FRMDATE;I\DATEDIFF;I\SDATE  I:I\DATEDIFF;<;0  D:FROM DATE CANNOT BE LATER THAN TODAY'S DATE;ERRORM;I\SDATE
1 0.0 Work 8 I 0 21, 61
$DEFAULT  A:ORGS;;I\AGENT
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 3 T -1 271, 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 19 T -1 471, 145
  
1 0.0 CMD 5 C -1 321, 289
$SELECT  I:I\SDATE;=;  A:DATE;DD MMM YYYY;I\SDATE    I:I\SDATE;<>;  A:DATEDIFF;W\FRMDATE;I\DATEDIFF;I\SDATE  I:I\DATEDIFF;<;0  D:FROM DATE CANNOT BE LATER THAN TODAY'S DATE;ERRORM;I\SDATE    I:I\EDATE;=;  A:DATE;DD MMM YYYY;I\EDATE    A:DATEDIFF;I\EDATE;I\DATEDIFF;I\SDATE    I:I\DATEDIFF;<;0  D:TO DATE CANNOT BE LESS T
1 0.0 Label 1 T -1 211, 181
  
1 0.0 Work 2 I -1 321, 181
$SELECT  S:DEBTOR;I\BUYER    $VALIDATE  I:I\BUYER;<>;  F:DEBTOR_MAST;Y;;T\BYR_NAME=DM_NAME;DM_MARKET='$I\MARKET$' AND DM_DEBTOR='$I\BUYER$';I\BUYER    I:I\BUYER;=;  A:CONST;;T\BYR_NAME  
1 0.0 Label 3 T -1 471, 181
  
1 0.0 CMD 4 C -1 431, 181
  
1 0.0 Work 7 I 0 1, 97
  
1 0.0 Work 8 I 0 41, 61
  
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
  
10 0.0 ZX_PRINT Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 0, 0