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 |