Freshmark replication server

freshmark-canonical

Program drill-down

CASHPOINT_SLS_MAN

CASHPOINT SALES MAINTENANCE. Type MAN, base table DEBTOR_MAST.

Field inventory

177

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Work 3 I 0 561, 109
  
1 0.0 Work 4 I 0 611, 109
  
1 0.0 Work 5 I 0 661, 109
  
1 0.0 Work 1 I 0 81, 529
  
1 0.0 Work 2 I 0 41, 529
  
1 0.0 Work 4 I 0 161, 529
  
1 0.0 Work 5 I 0 101, 529
  
1 0.0 Work 6 I 0 121, 529
  
1 0.0 Work 3 I 0 61, 529
  
1 0.0 H -1 1, 25
  
1 0.0 Work 2 I 0 221, 85
  
1 0.0 CHANGE I -1 651, 505
  
1 0.0 Work 1 I 0 401, 505
  
1 0.0 Work 2 I 0 421, 505
  
1 0.0 Work 3 I 0 451, 85
  
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 321, 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 DEFAULT I 0 1, 49
$DEFAULT    'INITIALIZES THE DATE AND TIME INTO THE T\DATE AND T\TIME FIELDS  A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\DOCNO,I\CONSIGN,I\AGN,I\COMMODITY,I\AVAIL_QTY,I\SALES_QTY,I\PRICE,I\VAT,I\VALUE,I\PALLS_SOLD:H,I\DOC_MSG:H,I\DELDATE:H,I\DISCVAL:H,I
1 0.0 MARKET I 0 31, 49
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;I\PROHIBIT_SALES=CM_PROHIBIT_SALES,T\MARKET=CM_NAME,I\PRE=CM_CB_NOPREAMBLE    I:I\PROHIBIT_SALES;=;Y  DO(JHE)    O:DISABLEINPUT;I\DM_DEBTOR    D:SALES ARE PROHIBITED;ERRORM;I\DM_DEBTOR  DOEND(JHE)    'CHANGING TEXT CASE FOR THE F
1 0.0 ORGS I 0 61, 49
$DEFAULT  A:ORGS;;I\ORGS    
1 0.0 IP I 0 91, 49
$DEFAULT  A:USERIP;;I\IP  F:CASH_POINT;;;I\CASHPOINT=CPO_CASHPT;CPO_IP='$I\IP$'    
1 0.0 Label 13 T -1 1, 85
  
1 0.0 Label 14 T -1 1, 109
  
1 0.0 Label 15 T -1 1, 157
  
1 0.0 Label 16 T -1 1, 193
  
1 0.0 Label 17 T -1 231, 157
  
1 0.0 Label 18 T -1 481, 157
  
1 0.0 Label 19 T -1 631, 157
  
1 0.0 CASHPOINT I -1 121, 85
  
1 0.0 CASHIER I -1 121, 109
$DEFAULT  A:USERID;;I\CASHIER  'GETS CASHIER AND GETS IF CASHIER IS BLOCKED  F:CASH_MAST;;;I\CASHIER_SCAN=CSH_SCAN_CARD;CSH_CASHIER='$I\CASHIER$' AND CSH_MARKET='$I\MARKET$'
1 0.0 DEBTOR_MAST DM_DEBTOR I -1 121, 157
$ESC  U:BUYER_RESERVATION_GRID_PRETORIA;UNFLAG_CARD    $CALCULATE  '=======BASIC VALIDATION=======================================================================================================================  M:  C:UCASE    I:I\MARKET;<>;22  DO(D8A)   I:I\PRE;<>;0    DO(PR3)     I:I\PARM;<>;HEA     DO(SSQ)       U:G
1 0.0 VATNO I -1 121, 193
  
1 0.0 GROUP I -1 531, 157
$SELECT  S:BUYER_GROUP;I\GROUP    $CALCULATE    I:I\TMP2;=;1     DO(BY)       M:       C:UCASE       F:BUYER_GROUP;Y;;T\GROUP_NAME=BG_DESC;BG_CODE='$I\GROUP$';I\GROUP     DOEND(BY)  O:SETFOCUS;I\SEQ  A:CONST;+;I\SEQ  
1 0.0 CMD 25 C -1 591, 157
$SELECT  S:BUYER_GROUP;I\GROUP
1 0.0 Work 26 G -1 1, 289
  
1 0.0 AGN I -1 231, 265
  
1 0.0 COMMODITY I -1 281, 265
  
1 0.0 AVAIL_QTY I -1 431, 265
  
1 0.0 PRE I 0 211, 121
  
1 0.0 VAT I -1 621, 265
  
1 0.0 VALUE I -1 681, 265
  
1 0.0 Label 38 T -1 1, 241
  
1 0.0 Label 39 T -1 31, 241
  
1 0.0 Label 40 T -1 101, 241
  
1 0.0 Label 41 T -1 231, 241
  
1 0.0 Label 42 T -1 281, 241
  
1 0.0 Label 43 T -1 431, 241
  
1 0.0 Label 44 T -1 431, 217
  
1 0.0 Label 45 T -1 491, 241
  
1 0.0 Label 46 T -1 491, 217
  
1 0.0 Label 47 T -1 551, 241
  
1 0.0 Label 48 T -1 621, 241
  
1 0.0 Label 49 T -1 681, 241
  
1 0.0 Label 50 T -1 761, 241
  
1 0.0 CMD 51 C -1 201, 265
$SELECT  S:CONS_QTY;I\CONSIGN
1 0.0 Label 52 T -1 1, 409
  
1 0.0 Work 53 I -1 1, 433
  
1 0.0 Label 54 T 0 301, 553
  
1 0.0 Label 56 T -1 511, 433
  
1 0.0 I 0 361, 553
  
1 0.0 TOTAL I -1 401, 469
  
1 0.0 CMD 60 C -1 741, 433
$SELECT  S:PAYMENT_METHOD;I\PMT_METH;I\MARKET    
1 0.0 Label 61 T -1 211, 469
  
1 0.0 Work 8 I 0 391, 109
  
1 0.0 Work 62 I 0 81, 505
  
1 0.0 Work 63 I 0 61, 505
  
1 0.0 Work 64 I 0 41, 505
  
1 0.0 Work 65 I 0 201, 457
  
1 0.0 Work 7 I 0 141, 529
  
1 0.0 Work 9 I 0 61, 457
  
1 0.0 Work 10 I 0 161, 457
  
1 0.0 Work 11 I 0 41, 457
  
1 0.0 Work 12 I 0 181, 457
  
1 0.0 Work 14 I 0 141, 457
  
1 0.0 Work 15 I 0 121, 457
  
1 0.0 Work 16 I 0 101, 457
  
1 0.0 Work 17 I 0 81, 457
  
1 0.0 Label 18 T 0 1, 457
  
1 0.0 Work 20 I 0 121, 481
  
1 0.0 Work 21 I 0 101, 481
  
1 0.0 Work 22 I 0 81, 481
  
1 0.0 Work 23 I 0 61, 481
  
1 0.0 Work 24 I 0 41, 481
  
1 0.0 Label 25 T 0 1, 481
  
1 0.0 Label 26 T 0 1, 505
  
1 0.0 Label 27 T 0 1, 529
  
1 0.0 Work 29 I 0 81, 553
  
1 0.0 Work 30 I 0 61, 553
  
1 0.0 Work 31 I 0 61, 577
  
1 0.0 Work 32 I 0 41, 553
  
1 0.0 Work 33 I 0 41, 577
  
1 0.0 Label 34 T 0 1, 553
  
1 0.0 Label 35 T 0 1, 577
  
1 0.0 Work 36 I 0 301, 577
  
1 0.0 Work 37 I 0 321, 577
  
1 0.0 Work 38 I 0 341, 577
  
1 0.0 Work 39 I 0 241, 577
  
1 0.0 Work 40 I 0 261, 577
  
1 0.0 Work 41 I 0 281, 577
  
1 0.0 Label 42 T 0 201, 577
  
1 0.0 Work 1 I 0 161, 505
  
1 0.0 Work 2 I 0 201, 505
  
1 0.0 Work 3 I 0 181, 505
  
1 0.0 Work 4 I 0 241, 553
  
1 0.0 Work 5 I 0 261, 553
  
1 0.0 Work 6 I 0 141, 505
  
1 0.0 Work 7 I 0 121, 505
  
1 0.0 Work 8 I 0 101, 505
  
1 0.0 Label 1 T 0 201, 553
  
1 0.0 Work 1 I 0 221, 505
  
1 0.0 Work 1 I 0 591, 541
$BEFORE_WRITE    '==================================  'TO CHECK FOR LOCKS (JD 2010-11-15)  ''U:ZZGRID_VALIDATE;INIT_GRID;G\GRID  'TO CHECK FOR LOCKS (JD 2010-11-15)  '==================================    I:I\PMT_METH;<>;  DO(SCR)    I:I\PMT_METH;=;CA    DO(CA)  '    U:CASHPOINT_SALES;ZV_GEN;I\CODEFLD,I\USERID,I\DM_DEB
1 0.0 Work 4 I 0 471, 85
  
1 0.0 Work 5 I 0 491, 85
  
1 0.0 Work 6 I 0 441, 505
  
1 0.0 Work 7 I 0 461, 505
  
1 0.0 CASHIER_SCAN I 0 511, 85
  
1 0.0 CM_CB_NOPREAMBLE I 0 531, 85
  
1 0.0 Work 1 I 0 301, 121
  
1 0.0 Work 1 I 0 381, 241
  
1 0.0 Label 2 T 0 141, 481
  
1 0.0 Work 3 I 0 201, 481
  
1 0.0 Work 4 I 0 181, 481
  
1 0.0 Label 6 T -1 551, 217
  
1 0.0 Work 2 I 0 241, 505
  
1 0.0 Work 3 I 0 261, 505
  
1 0.0 Work 1 I 0 281, 505
  
1 0.0 Work 2 I 0 701, 193
  
1 0.0 Work 3 I 0 301, 505
  
1 0.0 Work 1 I 0 721, 193
  
1 0.0 TMP_IND I 0 321, 505
  
1 0.0 CR_LIM I 0 101, 553
  
1 0.0 OSBAL I 0 121, 553
  
1 0.0 CRED_AVAIL I 0 381, 157
  
1 0.0 Work 1 I 0 741, 193
  
1 0.0 CODEFLD I 0 551, 193
  
1 0.0 Work 1 I 0 341, 505
  
1 0.0 Work 1 I 0 121, 49
$DEFAULT  A:USERID;;I\USERID    U:MENU_GROUP;LOOKUP
1 0.0 Work 1 I 0 201, 241
  
1 0.0 Work 1 I 0 361, 505
  
1 0.0 DEBTOR_MAST DM_ACCTYPE I 0 141, 553
  
1 0.0 Work 2 I 0 761, 193
  
1 0.0 Work 1 I -1 401, 433
  
1 0.0 Label 2 T -1 211, 433
  
1 0.0 Work 3 I 0 381, 505
  
1 0.0 Work 4 I 0 181, 553
  
1 0.0 Work 5 I 0 161, 553
  
1 0.0 Work 1 I 0 451, 541
  
1 0.0 Work 1 I 0 381, 553
  
1 0.0 Work 2 I 0 341, 553
  
1 0.0 Work 1 I 0 431, 157
  
1 0.0 Label 6 T 0 481, 109
  
1 0.0 Work 5 I 0 221, 481
  
1 0.0 Work 2 I 0 311, 85
  
1 0.0 Work 1 I 0 281, 193
  
1 0.0 Work 1 I 0 771, 97
  
1 0.0 ACTIVE I 0 201, 85
  
1 0.0 Label 1 T -1 511, 469
  
1 0.0 Label 2 T -1 511, 505
  
1 0.0 DM_RESERV_CARD_SCAN I 0 341, 121
  
1 1.0 LINE I -1 1, 265
$SELECT  S:G:G\GRID:R1;I\SEQ  $SELECT6  S:G:G\GRID:F1;I\SEQ    $CALCULATE  I:I\SEQ;=;  DO(SFD)     O:DISABLEINPUT;I\DOCNO,I\CONSIGN,I\SALES_QTY,I\PRICE,I\MSG     I:I\BUYER_TYPE;=;CA     DO(LPZ)       A:CONST;CA;I\PMT_METH       O:SETFOCUS;I\PMT_METH     DOEND(LPZ)  DOEND(SFD)    I:I\SEQ;<>;  DO(002)    I:I\SEQ;<>;+    
1 1.0 DOCNO I -1 31, 265
$CALCULATE  '===READS AND WRITES THE DOCNO================================================================================================================  I:I\CM_CASHDOC;=;1  DO(WTY)    I:I\DOCNO;=;    A:CONST;*****;I\DOCNO        I:I\DOCNO;<>;    DO(PLS)      I:I\DOCNO;<>;*****      DO(CBG)        A:CONST;*****;I\DOC
1 1.0 CONSIGN I -1 101, 265
$SELECT  S:CONS_QTY;I\CONSIGN    $CALCULATE  M:  F:CLIENT_MAST;;;I\DEL_LEN=CM_DEL_LEN;CM_CODE='$I\MARKET$'  A:ADD;"2";I\DEL_LEN;I\DEL_LEN  A:ZEROFILL;I\CONSIGN,I\DEL_LEN;I\CONSIGN    '====GENERAL VALIDATION==================================================================================================================
1 1.0 SALES_QTY I -1 491, 265
$VALIDATE    I:I\SALES_QTY;<;0;NUM  D:QUANTITY CANNOT BE NEGATIVE;ERRORM;I\SALES_QTY        I:I\SALES_QTY;>;I\AVAIL_QTY;NUM  D:SALES QTY CANNOT BE MORE THAN AVAILABLE QTY;ERRORM;I\SALES_QTY          $CALCULATE  M:  I:I\SALES_QTY;=;0;NUM  D:QUANTITY CANNOT BE ZERO;ERRORM;I\SALES_QTY    I:I\AM_TARGET_USE;=;Y  DO(001)    
1 1.0 PRICE I -1 551, 265
$SVAR_FOCUS  I:I\SEQ;=;+  O:SETFOCUS;I\SEQ    $CALCULATE  M:    I:I\PRICE;<=;0;NUM  D:PRICE CANNOT BE ZERO;ERRORM;I\PRICE    '$VALIDATE  'I:I\PRICE;<=;0;NUM  'D:PRICE CANNOT BE ZERO;ERRORM;I\PRICE      U:CASHPOINT_SALES;VAT;I\SALES_QTY,I\PRICE,I\COMMODITY      '======GETS THE VARIANCE PERCENTAGE AND THE PRICE VARIANCE 
1 1.0 MSG I -1 761, 265
$CALCULATE  C:UCASE  V:Y;N;D;  I:I\MSG;=;  A:CONST;N;I\MSG    I:I\MSG;=;Y  U:AGENT_SALES;SALES_DOCKET_MSG    'NEW BY JD 20150316 - SET THE CONSIGNMENT AS ACTIVE  '''U:CASHPOINT_SALES;ACTIVE_LOCKS_SET  U:ZZGRID_SPLIT;SCREEN_TO_GRID;G\GRID;I\SEQ    F:PALL_DETS;;;I\TMP_PALLS=PD_CONQTY;PD_MARKET='$I\MARKET$' AND PD_AGENT='
1 2.0 AMT_TENDERED I -1 651, 469
$VALIDATE    U:CATCHCHARS;FALSE  '$DEFAULT    A:SUB;I\AMT_TENDERED;I\CHANGE;I\TOTAL;#0.00    I:I\BUYER_TYPE;=;CA    DO(BFX)      I:I\AMT_TENDERED;<;I\TOTAL;NUM      DO(001)        A:VAR;I\AMT_TENDERED;I\AMT_TENDERED;;#0.00        D:AMOUNT TENDERED CAN NOT BE LESS THAN THE TOTAL;ERRORM;I\AMT_TENDERED      DOEND(001)    
1 2.0 PMT_METH I -1 651, 433
$SELECT  S:PAYMENT_METHOD;I\PMT_METH;I\MARKET    $VALIDATE  I:I\BUYER_TYPE;=;CA  DO(VEW)      M:    I:I\PMT_METH;<>;    F:CASH_PAYMTHD;Y;;;CPM_PAYMETH='$I\PMT_METH$';I\PMT_METH  DOEND(VEW)       $CALCULATE  C:UCASE  F:CASH_PAYMTHD;Y;;;CPM_PAYMETH='$I\PMT_METH$';I\PMT_METH    I:I\BUYER_TYPE;<>;CA  DO(WER)     D:PAYMENT 
10 0.0 ZX_PRINT Z 0 1, 25
  
10 0.0 ZX_SELECT Z 0 1, 25
  
10 0.0 ZX_DELETE Z 0 1, 25
  
10 0.0 ZX_UPDATE Z 0 1, 25
$ESC  U:BUYER_RESERVATION_GRID_PRETORIA;UNFLAG_CARD    $UPDATE    ''==================================  ''TO CHECK FOR LOCKS (JD 2010-11-15)  U:ZZGRID_VALIDATE;INIT_GRID;G\GRID  ''TO CHECK FOR LOCKS (JD 2010-11-15)  ''==================================    'I:I\PMT_METH;<>;  'DO(SCR)  '  I:I\PMT_METH;=;CA  '  DO(CA)  ' 
10 0.0 ZX_EXIT Z 0 1, 25
$EXIT  U:CASHPOINT_SALES;ACTIVE_LOCKS_RESET  U:BUYER_RESERVATION_GRID_PRETORIA;UNFLAG_CARD