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 |