Freshmark replication server

freshmark-canonical

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