Freshmark replication server

freshmark-canonical

Program drill-down

DISCARDS_MAN

DISCARDS MAINTENANCE. Type DSP, base table STK_MAST.

Field inventory

131

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 DISCARD CONFIRMA I 0 381, 529
  
1 0.0 Work 1 I 0 11, 85
  
1 0.0 H -1 1, 85
  
1 0.0 STK_MAST SM_DELNO I -1 131, 109
$SELECT  'DISPLAY SELECTION WINDOW FOR DELIVERIES  I:I\ORGS;=;  S:DELIVERY_CONSIGN_2;I\SM_DELNO    I:I\ORGS;<>;  S:DELIVERY_CONSIGN_3;I\SM_DELNO;I\ORGS    '''''''''''''''''''''''''''$VALIDATE  $CALCULATE    A:VALCOLUMN;8  A:CONST;;W\TMP3,W\TMP4,W\TMP5,I\CODE,I\DIS_QTY,I\CERTNO,I\CFM,I\DEDUCT_CODE  A:CONST;;I\SD_CONSIGN
1 0.0 STK_MAST SM_DELNO T -1 1, 109
  
1 0.0 Label 2 T -1 1, 25
  
1 0.0 MARKET I 0 11, 61
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;I\ALLOW_CHANGE=CM_CHANGE_CONF_DISCQTY,T\MARKET=CM_NAME,W\ZEROFILL=CM_DEL_LEN,I\PROHIBIT_SALES=CM_PROHIBIT_SALES,W\DISCARD_CONF=CM_DISCARD_CONF    I:I\PROHIBIT_SALES;=;Y  DO(MES)    O:DISABLEINPUT;I\SM_DELNO    D:SALES ARE PROHIBI
1 0.0 STK_MAST SM_DTIME I -1 391, 109
  
1 0.0 STK_MAST SM_DTIME T -1 291, 109
  
1 0.0 STK_MAST SM_DDATE I -1 621, 109
  
1 0.0 STK_MAST SM_DDATE T -1 491, 109
  
1 0.0 STK_MAST SM_SUPP I -1 131, 145
  
1 0.0 STK_MAST SM_SUPP T -1 1, 145
  
1 0.0 STK_MAST SM_REFNO I -1 621, 145
  
1 0.0 STK_MAST SM_REFNO T -1 491, 145
  
1 0.0 STK_MAST SM_AGENT I -1 131, 169
  
1 0.0 STK_MAST SM_AGENT T -1 1, 169
  
1 0.0 STK_MAST SM_SMAN I -1 131, 193
  
1 0.0 STK_MAST SM_SMAN T -1 1, 193
  
1 0.0 STK_MAST SM_AREA I -1 621, 169
  
1 0.0 STK_MAST SM_AREA T -1 491, 169
  
1 0.0 STK_MAST SM_TRNPTR I -1 131, 217
''''  
1 0.0 STK_MAST SM_TRNPTR T -1 1, 217
  
1 0.0 STK_MAST SM_VREGNO I -1 131, 241
''''I\SM_DELNO,I\SM_DTIME,I\SM_DDATE,W\SM_DDATE,I\SM_SUPP,T\SUPP,I\SM_REFNO,I\SM_AGENT,T\AGENT,I\SM_AREA,I\SM_SMAN,T\SALESMAN,I\SM_TRNPTR,T\TRANSP,I\SM_VREGNO,,,,,,,
1 0.0 STK_MAST SM_VREGNO T -1 1, 241
  
1 0.0 STK_MAST SM_WAYBILLNO I -1 391, 241
  
1 0.0 STK_MAST SM_WAYBILLNO T -1 291, 241
  
1 0.0 GRID G -1 1, 361
  
1 0.0 Label 16 T -1 291, 25
  
1 0.0 HEAD T -1 295, 49
  
1 0.0 Label 18 T -1 621, 25
  
1 0.0 Label 19 T -1 671, 25
  
1 0.0 Label 20 T -1 621, 49
  
1 0.0 Label 21 T -1 671, 49
  
1 0.0 STK_DETS SD_CONSIGN I -1 27, 337
  
1 0.0 STK_DETS SD_CONSIGN T -1 33, 313
  
1 0.0 I -1 111, 337
  
1 0.0 Label 24 T -1 111, 312
  
1 0.0 STK_DETS SD_RECQTY I -1 229, 337
  
1 0.0 STK_DETS SD_RECQTY T -1 229, 313
  
1 0.0 RSN_CODE T -1 321, 313
  
1 0.0 STK_DETS SD_CERTNO I -1 516, 337
$CALCULATE    'MANDATORY  M:    'CONVERT TO UPERCASE  C:UCASE
1 0.0 I -1 368, 337
  
1 0.0 T -1 368, 312
  
1 0.0 Label 29 T -1 211, 145
  
1 0.0 Label 30 T -1 211, 169
  
1 0.0 Label 31 T -1 211, 193
  
1 0.0 Label 32 T -1 211, 217
  
1 0.0 Label 33 T -1 281, 313
  
1 0.0 Work 34 I -1 280, 337
'$CALCULATE  'I:I\SD_QTY;<;0  'D:AVAILABLE QUANTITY CANNOT BE LESS THAN ZERO;ERRORM;I\SD_QTY
1 0.0 Label 35 T -1 478, 288
  
1 0.0 SD_DISQTY I -1 476, 337
$CALCULATE  'I:I\SD_DISQTY;>;I\SD_QTY  'D:DISCARDED QUANTITY MUST BE LESS OR EQUAL TO AVAILABLE QUANTITY;ERRORM;I\SD_DISQTY    'MANDATORY  M:    I:I\SD_DISQTY;=;0;NUM  D:DISCARD QUANTITY CANNOT BE ZERO;ERRORM;I\SD_DISQTY    'CHECKS IF AN ADJUSTMENT HAS BEEN MADE, AND FINAL PAYMENT DATE. DISALLOW CHANGES IF FINAL PAYMEN
1 0.0 SD_CERTNO T -1 518, 312
  
1 0.0 STK_TRANS ST_RSN_CODE D -1 321, 337
$DEFAULT  'LOAD THE COMBOBOX WITH DATABASE VALUES  B:READTABLE;D\RSN_CODE;REASON_MAST;RSN_REASON;SELECT RSN_REASON FROM REASON_MAST WHERE RSN_TYPE='DS' AND RSN_BLOCKED <> 'Y'      $CALCULATE  'VALIDATE FOR CORRECT AND EXISTING REASON CODE    'MANDATORY  M:  'UPPERCASE  C:UCASE      I:D\RSN_CODE;<>;  F:REASON_MAST;Y;RSN
1 0.0 SD_CFM T -1 599, 311
  
1 0.0 CONFIRM I -1 600, 337
$CALCULATE  'CONVERT TO UPERCASE  C:UCASE    I:I\MODE;=;C  M:    'DISPLAY ERROR MESSAGE IF ANY OTHER VALUES OTHER THAN BLANK OR 'D' ARE ENTERED  V:Y;N;    'DEFAULT TO 'N'  I:I\SD_CFM;=;  A:CONST;N;I\SD_CFM    I:I\MODE;=;C  O:SETFOCUS;I\SD_ACTION    'ALIGN COLUMNS  U:DISCARDS_UPDATE;ALIGN_COLUMNS;G\DISCARD
1 0.0 DEDUCT_TRANS DT_DEDUCT_CODE I -1 635, 337
$SELECT  'DISPLAY A SELECTION WINDOW  S:CHARGE_CODE;I\DT_DEDUCT_CODE      $CALCULATE  'VALIDATE FOR EXISTING DEDUCTION CODE    I:I\DT_DEDUCT_CODE;=;  A:CONST;;I\DT_AMOUNT       I:I\DT_DEDUCT_CODE;<>;  A:CONST;;I\DT_AMOUNT        I:I\DT_DEDUCT_CODE;<>;  F:DEDUCT_MAST;Y;DM_CODE;I\DT_AMOUNT=DM_RATE;;I\DT_DEDUCT_CODE      
1 0.0 ACTION I -1 771, 337
$CALCULATE  'CONVERT TO UPERCASE  C:UCASE    'DISPLAY ERROR MESSAGE IF ANY OTHER VALUES OTHER THAN BLANK OR 'D' ARE ENTERED  I:D\RSN_CODE;=;  D:ENTER THE REASON CODE;ERRORM;D\RSN_CODE    V:D;  I:W\LINE_TEMP;=;Y    DO(YY)      U:DISCARDS_UPDATE;INSERT_GRID_ROW;G\DISCARD,I\LINE,I\SD_CONSIGN      'A:SUB;I\SD_QTY;I\SD_QTY;
1 0.0 OLD DISQTY I 0 631, 193
  
1 0.0 Label 44 T -1 713, 311
  
1 0.0 Label 45 T -1 771, 313
  
1 0.0 Label 46 T -1 635, 311
  
1 0.0 Label 47 T -1 230, 291
  
1 0.0 Label 48 T -1 281, 289
  
1 0.0 Label 49 T -1 478, 312
  
1 0.0 Work 56 I 0 1, 529
  
1 0.0 DEFAULT I 0 41, 61
$DEFAULT    A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    'INITIALIZE GRID  U:ZZGRID_SPLIT;INIT_GRID;G\DISCARD;I\LINE,I\SD_CONSIGN,I\ST_DOCNO:H,I\SD_COMM,I\SD_RECQTY,I\FLAG:H,I\SD_QTY,D\RSN_CODE,I\ST_REASON,I\SD_DISQTY,I\SD_CERTNO,I\SD_CFM,I\SD_CLASS:H,I\SD_SIZE:H,I\SD_CONT:H,I\SD_CONTMASS:H,I\S
1 0.0 Work 52 I 0 23, 531
  
1 0.0 Work 53 I 0 44, 530
  
1 0.0 CMD 54 C -1 231, 109
$SELECT  'DISPLAY SELECTION WINDOW FOR DELIVERIES  'S:DELIVERY_CONSIGN;I\SM_DELNO  S:DELIVERY_CONSIGN_2;I\SM_DELNO  
1 0.0 STK_DETS SD_CLASS I 0 131, 541
  
1 0.0 STK_DETS SD_SIZE I 0 151, 541
  
1 0.0 STK_DETS SD_CONT I 0 171, 541
  
1 0.0 STK_DETS SD_CONTMASS I 0 201, 541
  
1 0.0 STK_DETS SD_PROV I 0 281, 565
  
1 0.0 Label 3 T -1 1, 493
  
1 0.0 Label 4 T -1 281, 493
  
1 0.0 Label 5 T -1 551, 493
  
1 0.0 Work 6 I -1 671, 493
  
1 0.0 Work 7 I -1 421, 493
  
1 0.0 Work 8 I -1 111, 493
  
1 0.0 STK_DETS SD_RETQTY I 0 191, 565
  
1 0.0 STK_DETS SD_SLDQTY I 0 171, 565
  
1 0.0 STK_DETS SD_ADJQTY I 0 151, 565
  
1 0.0 STK_DETS SD_CSQTY I 0 131, 565
  
1 0.0 STK_DETS SD_RRQTY I 0 211, 565
  
1 0.0 DEDUCT_TRANS DT_AMOUNT I -1 711, 337
  
1 0.0 C\DT_CODE C -1 680, 336
$SELECT  'DISPLAY A SELECTION WINDOW  S:CHARGE_CODE;I\DT_DEDUCT_CODE    
1 0.0 Label 4 T -1 635, 286
  
1 0.0 Label 5 T -1 712, 286
  
1 0.0 DT_DEDUCT_CODE T 0 672, 263
  
1 0.0 W DELNO I 0 261, 109
  
1 0.0 Work 1 I 0 31, 85
  
1 0.0 STK_DETS SD_CONQTY I 0 231, 565
  
1 0.0 STK_DETS SD_PROVQTY I 0 251, 565
  
1 0.0 Work 1 I 0 311, 565
  
1 0.0 Work 2 I 0 331, 565
  
1 0.0 Work 1 I 0 371, 565
  
1 0.0 Work 1 I 0 351, 565
  
1 0.0 Work 2 I 0 391, 565
  
1 0.0 W SM_DDATE I 0 761, 109
  
1 0.0 Mode I 0 61, 61
$DEFAULT  A:PARM;1;I\MODE    I:I\MODE;=;C  DO(MODEC)    O:ENABLEINPUT;I\SD_CFM    A:CONST;DISCARDS CONFIRMATION;T\HEAD  DOEND(MODEC)    I:I\MODE;=;D  DO(MODED)    O:DISABLEINPUT;I\SD_CFM    A:CONST;DISCARDS MAINTENANCE;T\HEAD  DOEND(MODED)
1 0.0 LINE I -1 1, 337
$SELECT  'DISPLAY A SELECTION WINDOW FOR GRID VALUES  S:G:G\DISCARD:R1      $CALCULATE  O:DISABLEINPUT;I\SD_CONSIGN    I:I\LINE;=;+  D:INVALID ENTRY;ERRORM;I\LINE      A:VAR;I\LINE;W\LINE2    I:I\LINE;=;   DO(NULL)     A:CONST;;I\CODE,I\DIS_QTY,I\CERTNO,I\CFM,I\DEDUCT_CODE     A:CONST;;I\SD_CONSIGN,I\ST_DOCNO:H,I\SD_CO
1 0.0 Work 2 I 0 591, 217
  
1 0.0 UPDATE C -1 651, 541
$SELECT  A:CONST;;I\SM_DELNO,I\SM_DTIME,I\SM_DDATE,W\SM_DDATE,I\SM_SUPP,T\SUPP,I\SM_REFNO,I\SM_AGENT,T\AGENT,I\SM_AREA,I\SM_SMAN,T\SALESMAN,I\SM_TRNPTR,T\TRANSP,I\SM_VREGNO,I\SM_WAYBILLNO,I\NLINES,I\TDISCARD,I\THANDFEE,I\AVERAGE,I\AGN_DEBTOR,I\FINAL  U:CLEAR_GRID;CLEAR  O:SETFOCUS;I\SM_DELNO  
1 0.0 FINAL I 0 341, 85
  
1 0.0 TMP1 I 0 451, 313
  
1 0.0 ALLOW_CHANGE I 0 401, 73
  
1 0.0 LINE T -1 1, 313
  
1 0.0 FLAG I 0 251, 373
  
1 0.0 ST_DOCNO I 0 551, 253
  
1 0.0 DIS QTY I 0 301, 529
  
1 0.0 CODE I 0 281, 529
  
1 0.0 CERTNO I 0 321, 529
  
1 0.0 CONFIRM I 0 341, 529
  
1 0.0 DEDUCT CODE I 0 361, 529
  
1 0.0 Label 7 T 0 481, 301
  
1 0.0 W LINE TEMP I 0 1, 289
  
1 0.0 LINE TEMP I 0 21, 289
  
1 0.0 LINE 2 I 0 41, 289
  
1 0.0 ZERO FILL I 0 311, 169
  
1 0.0 Label 1 T -1 321, 289
  
1 0.0 Work 1 I 0 161, 61
$DEFAULT  A:ORGS;;I\ORGS
1 0.0 AGN_DEBTOR I 0 491, 73
  
1 0.0 TMP_QTY I 0 421, 265
  
1 0.0 Work 3 I 0 631, 217
  
10 0.0 ZX_PRINT Z 0 1, 85
  
10 0.0 ZX_SELECT Z 0 1, 85
  
10 0.0 ZX_DELETE Z 0 1, 85
  
10 0.0 ZX_UPDATE Z 0 1, 85
  
10 0.0 ZX_EXIT Z 0 1, 85