Program drill-down
SELT_PROF_SALES_BYR2
VALIDATE SELECTED PROF SALES BYR. Type DSP, base table DEBTOR_MAST.
Field inventory
115
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | CMD 2 | C | -1 | 261, 121 | $SELECT S:DEBTOR_PROV_SALES2;I\DM_DEBTOR |
|
| 1 | 0.0 | CMD 3 | C | -1 | 651, 548 | $SCMD_FOCUS O:BACKCOLOR;C\UPDATE;YELLOW $SELECT I:I\DM_DEBTOR2;=; D:ENTER VALIDATION BUYER;ERRORM;I\DM_DEBTOR2 'ANOTHER CHECK HERE BECAUSE PEOPLE ARE TRYING TO GIPPO THE SYSTEM I:I\BUYER_TYPE2;<>;CA DO(NOT_CB) U:PROV_SALES_VAL_MAN;CRED_LIM U:POP_GRID;SUM_CRLIM I:I\CRIND;=;N DO(JEE) A:CONST;E |
|
| 1 | 0.0 | CPO_CASHPT | I | 0 | 131, 61 | ||
| 1 | 0.0 | DOCNO | I | 0 | 701, 229 | ||
| 1 | 0.0 | DATE | I | -1 | 651, 253 | ||
| 1 | 0.0 | Label 8 | T | -1 | 21, 145 | ||
| 1 | 0.0 | RECEIPT | I | -1 | 141, 145 | $VALIDATE M: I:I\RECEIPT;<>; DO(FLA) U:CLEARGRID;CLEAR;G\GRID A:VAR;I\RECEIPT;I\RECEIPT;;000000 F:STK_TRANS;Y;;;ST_MARKET='$I\MARKET$' AND ST_DEBTOR='$I\DM_DEBTOR$' AND ST_TRTYPE = 'PS' AND ST_PSSTAT = 'N' AND ST_RECNO = '$I\RECEIPT$';I\RECEIPT U:POP_GRID;POPULATE;G\GRID,I\DM_DEBTOR,I\TOTAL,I\PARM DOEND(FLA |
|
| 1 | 0.0 | PROXY_BUYER | I | 0 | 431, 85 | ||
| 1 | 0.0 | Label 1 | T | -1 | 251, 433 | ||
| 1 | 0.0 | PAY_METH | I | -1 | 361, 433 | $SELECT S:PAYMENT_METHOD;I\PAY_METH;I\MARKET $VALIDATE I:I\BUYER_TYPE2;=;CA DO(VEW) M: F:CASH_PAYMTHD;Y;;;CPM_PAYMETH='$I\PAY_METH$';I\PAY_METH DOEND(VEW) $CALCULATE C:UCASE F:CASH_PAYMTHD;Y;;;CPM_PAYMETH='$I\PAY_METH$';I\PAY_METH O:DISABLEINPUT;I\AMT_TENDERED I:I\BUYER_TYPE2;<>;CA DO(WER) |
|
| 1 | 0.0 | Work 21 | G | -1 | 11, 277 | ||
| 1 | 0.0 | H | -1 | 1, 25 | |||
| 1 | 0.0 | Work 2 | I | 0 | 291, 505 | ||
| 1 | 0.0 | Work 1 | I | 0 | 221, 505 | ||
| 1 | 0.0 | Work 1 | I | 0 | 11, 505 | ||
| 1 | 0.0 | Work 6 | I | 0 | 111, 529 | ||
| 1 | 0.0 | Work 5 | I | 0 | 141, 529 | ||
| 1 | 0.0 | Work 4 | I | 0 | 171, 529 | ||
| 1 | 0.0 | Work 3 | I | 0 | 81, 529 | ||
| 1 | 0.0 | Work 2 | I | 0 | 51, 529 | ||
| 1 | 0.0 | Work 23 | I | -1 | 101, 253 | ||
| 1 | 0.0 | DEBTOR_MAST | DM_DEBTOR | I | -1 | 141, 121 | $SELECT I:I\ORGS;=; S:DEBTOR_PROV_SALES2;I\DM_DEBTOR '''S:DEBTOR_PROV_SALES;I\DM_DEBTOR $CALCULATE A:CONST;;I\ERROR M: 'THIS FUNCTION CLEARS THE GRID U:CLEARGRID;CLEAR;G\GRID F:DEBTOR_MAST;;;I\PROXY_BUYER=DM_PROXY_PROV,T\NAME=DM_NAME;DM_MARKET='$I\MARKET$' AND DM_DEBTOR='$I\DM_DEBTOR$';I\DM_DEBTOR I:I\P |
| 1 | 0.0 | Work 24 | I | -1 | 191, 253 | ||
| 1 | 0.0 | Work 8 | I | 0 | 51, 505 | ||
| 1 | 0.0 | Work 9 | I | 0 | 111, 505 | ||
| 1 | 0.0 | Work 11 | I | 0 | 41, 61 | $DEFAULT A:ORG;;I\MARKET 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;I\DEFRECS=CM_NOREC_PRN,T\MARKET=CM_NAME,I\TMP2=CM_PROHIBIT_SALES,I\GRP=CM_BUYGRP,I\VALCHEQUE=CM_CHEQUE_DETS A:VAR;I\DEFRECS;I\NUMRECS 'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE C:MCASE;;T\MARKET I:I\TMP2;=;Y D:SALES |
|
| 1 | 0.0 | Work 1 | I | 0 | 71, 61 | $DEFAULT 'LOAD AGENT CODE A:ORGS;;I\ORGS I:I\ORGS;<>; O:HIDE;C\LOOK ''A:SETPWFIELD;I\DM_DEBTOR A:SETPWFIELD;I\DM_DEBTOR2 |
|
| 1 | 0.0 | Work 18 | I | -1 | 611, 109 | ||
| 1 | 0.0 | Work 19 | I | -1 | 611, 145 | ||
| 1 | 0.0 | Work 25 | I | -1 | 331, 253 | ||
| 1 | 0.0 | Work 26 | I | -1 | 381, 253 | ||
| 1 | 0.0 | Work 27 | I | -1 | 511, 253 | ||
| 1 | 0.0 | Work 28 | I | -1 | 571, 253 | ||
| 1 | 0.0 | Work 29 | I | -1 | 51, 253 | ||
| 1 | 0.0 | Work 30 | I | 0 | 651, 253 | ||
| 1 | 0.0 | Work 31 | I | -1 | 721, 253 | $CALCULATE C:UCASE V:Y;N; I:I\VALIDATE;=; A:CONST;N;I\VALIDATE U:ZZGRID_SPLIT;SCREEN_TO_GRID;G\GRID;I\LINE U:POP_GRID;SUM_SELECTED A:CONST;$I\TOT_RND$;I\TOTAL I:I\BUYER_TYPE2;<>;CA DO(NOT_VF) A:CONST;;I\PAY_METH O:DISABLEINPUT;I\PAY_METH O:HIDE;T\TENDERED,I\AMT_TENDERED,T\CHANGE,I\CHANGE U:P |
|
| 1 | 0.0 | Work 4 | I | 0 | 411, 529 | ||
| 1 | 0.0 | Work 44 | I | -1 | 581, 433 | ||
| 1 | 0.0 | Work 45 | I | -1 | 141, 433 | ||
| 1 | 0.0 | Work 1 | I | 0 | 751, 145 | ||
| 1 | 0.0 | Work 1 | I | 0 | 141, 505 | ||
| 1 | 0.0 | Work 1 | I | 0 | 201, 529 | ||
| 1 | 0.0 | Work 2 | I | 0 | 151, 61 | ||
| 1 | 0.0 | Work 1 | I | 0 | 231, 529 | ||
| 1 | 0.0 | Work 1 | I | 0 | 261, 529 | ||
| 1 | 0.0 | Work 1 | I | 0 | 291, 529 | ||
| 1 | 0.0 | Work 2 | I | 0 | 321, 529 | ||
| 1 | 0.0 | Work 3 | I | 0 | 351, 529 | ||
| 1 | 0.0 | Work 2 | I | 0 | 81, 505 | ||
| 1 | 0.0 | Work 1 | I | 0 | 101, 61 | ||
| 1 | 0.0 | Work 1 | I | 0 | 381, 529 | ||
| 1 | 0.0 | BUYER_TYPE | I | 0 | 201, 505 | ||
| 1 | 0.0 | Work 4 | I | -1 | 451, 253 | ||
| 1 | 0.0 | Work 2 | I | 0 | 171, 505 | ||
| 1 | 0.0 | Work 1 | I | -1 | 11, 253 | $SELECT S:G:G\GRID:L1;I\LINE $VALIDATE I:I\LINE;<>; DO(LINE) U:ZZGRID_SPLIT;GRID_TO_SCREEN;G\GRID;I\LINE O:ENABLEINPUT;I\VALIDATE DOEND(LINE) I:I\LINE;=; DO(O) O:DISABLEINPUT;G\GRID,I\VALIDATE A:CONST;$I\TOT_RND$;I\TOTAL 'U:POP_GRID;SUM_SELECTED I:I\TOTAL;=;0.00 D:SELECT A SALE TO VALIDAT |
|
| 1 | 0.0 | Work 1 | I | 0 | 261, 505 | ||
| 1 | 0.0 | Label 1 | T | -1 | 721, 229 | ||
| 1 | 0.0 | Label 7 | T | -1 | 701, 25 | ||
| 1 | 0.0 | DEBTOR_MAST | DM_DEBTOR | T | -1 | 21, 121 | |
| 1 | 0.0 | Label 3 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 4 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 6 | T | -1 | 651, 25 | ||
| 1 | 0.0 | Label 9 | T | -1 | 701, 49 | ||
| 1 | 0.0 | Label 8 | T | -1 | 651, 49 | ||
| 1 | 0.0 | Label 10 | T | -1 | 11, 469 | ||
| 1 | 0.0 | Label 12 | T | -1 | 301, 121 | ||
| 1 | 0.0 | Label 16 | T | -1 | 531, 109 | ||
| 1 | 0.0 | Label 17 | T | -1 | 531, 145 | ||
| 1 | 0.0 | Label 20 | T | -1 | 651, 145 | ||
| 1 | 0.0 | Label 33 | T | -1 | 101, 229 | ||
| 1 | 0.0 | Label 34 | T | -1 | 51, 229 | ||
| 1 | 0.0 | Label 35 | T | -1 | 191, 229 | ||
| 1 | 0.0 | Label 36 | T | -1 | 331, 229 | ||
| 1 | 0.0 | Label 37 | T | -1 | 381, 229 | ||
| 1 | 0.0 | Label 38 | T | -1 | 511, 229 | ||
| 1 | 0.0 | Label 39 | T | -1 | 571, 229 | ||
| 1 | 0.0 | Label 40 | T | 0 | 731, 229 | ||
| 1 | 0.0 | Label 41 | T | -1 | 651, 229 | ||
| 1 | 0.0 | Label 42 | T | -1 | 481, 433 | ||
| 1 | 0.0 | Label 43 | T | -1 | 11, 433 | ||
| 1 | 0.0 | Label 3 | T | -1 | 451, 229 | ||
| 1 | 0.0 | Label 2 | T | -1 | 191, 49 | ||
| 1 | 0.0 | Label 2 | T | -1 | 11, 229 | ||
| 1 | 0.0 | Work 1 | I | -1 | 141, 181 | $SELECT S:DEBTOR_PROV_SALES;I\DM_DEBTOR2 $CALCULATE A:CONST;;W\TEMP4 $VALIDATE M: A:CONST;;I\PAY_METH,I\CH,I\TRCHG,I\MAIN_DEBTOR,I\CALLCHQ,I\CHV,I\CH_DUE,I\TRIND,I\ERROR,I\CRED_LIMIT O:DISABLEINPUT;I\TRCHG 'CALL A FUNCTION THAT VALIDATES THE PREAMBLE U:VALIDATE_PREAMBLE;VALIDATE;I\DM_DEBTOR2,I\TMP4 |
|
| 1 | 0.0 | Work 2 | I | 0 | 31, 505 | ||
| 1 | 0.0 | Work 3 | I | 0 | 11, 529 | ||
| 1 | 0.0 | Work 4 | I | 0 | 31, 529 | ||
| 1 | 0.0 | Label 6 | T | -1 | 21, 181 | ||
| 1 | 0.0 | Label 7 | T | -1 | 301, 181 | ||
| 1 | 0.0 | CMD 8 | C | -1 | 261, 181 | ||
| 1 | 0.0 | TEMP4 | I | 0 | 51, 481 | ||
| 1 | 0.0 | Work 1 | I | -1 | 581, 469 | $CALCULATE U:CATCHCHARS;FALSE '$DEFAULT I:I\AMT_TENDERED;=; A:CONST;0;I\AMT_TENDERED I:I\PAY_METH;=;CH A:SUB;I\AMT_TENDERED;I\CHANGE;I\CH_DUE;#0.00 I:I\PAY_METH;<>;CH A:SUB;I\AMT_TENDERED;I\CHANGE;I\TOTAL;#0.00 I:I\BUYER_TYPE2;=;CA DO(NNJ) I:I\PAY_METH;=;CH DO(KUK) I:I\AMT_TENDERED;<;I\CH |
|
| 1 | 0.0 | Label 16 | T | -1 | 21, 97 | ||
| 1 | 0.0 | NUMRECS | I | -1 | 141, 97 | $CALCULATE I:I\NUMRECS;=;0;NUM A:VAR;I\DEFRECS;I\NUMRECS I:I\NUMRECS;=; A:VAR;I\DEFRECS;I\NUMRECS I:I\NUMRECS;>;10;NUM D:YOU MAY NOT PRINT MORE THAN 10 INVOICES;ERRORM;I\NUMRECS |
|
| 1 | 0.0 | Work 18 | I | 0 | 171, 97 | ||
| 1 | 0.0 | VALCHEQUE | I | 0 | 431, 61 | ||
| 1 | 0.0 | CRIND | I | 0 | 411, 85 | ||
| 1 | 0.0 | MAIN_DEBTOR | I | 0 | 411, 109 | ||
| 1 | 0.0 | TRIND | I | 0 | 431, 109 | ||
| 1 | 0.0 | CALLCHQ | I | 0 | 451, 109 | ||
| 1 | 0.0 | Work 2 | I | -1 | 581, 505 | ||
| 1 | 0.0 | Label 3 | T | -1 | 481, 469 | ||
| 1 | 0.0 | Label 4 | T | -1 | 481, 505 | ||
| 1 | 0.0 | CODEFLD | I | 0 | 411, 61 | ||
| 1 | 0.0 | Label 8 | T | -1 | 531, 181 | ||
| 1 | 0.0 | TRCHG | I | -1 | 611, 181 | $CALCULATE C:UCASE V:Y;N; I:I\TRCHG;=; A:CONST;N;I\TRCHG 'SHOW THE BUYERS CREDIT LIMIT(CR LIMIT - OUTSTDNG BAL - GRID TOTAL) I:I\BUYER_TYPE2;<>;CA DO(NOT_CA) A:CONST;;I\PAY_METH O:DISABLEINPUT;I\PAY_METH O:HIDE;T\TENDERED,I\AMT_TENDERED,T\CHANGE,I\CHANGE U:PROV_SALES_VAL_MAN;CRED_LIM_DISPLAY I:I\CR |
|
| 1 | 0.0 | CHV | I | 0 | 411, 133 | ||
| 1 | 0.0 | CH_DUE | I | 0 | 431, 133 | ||
| 1 | 0.0 | Label 6 | T | -1 | 251, 469 | ||
| 1 | 0.0 | CH | I | -1 | 361, 469 | ||
| 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 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 1, 25 |