Freshmark replication server

freshmark-canonical

Program drill-down

GOODS_RECEPTION_DEL

GOODS RECEPTION DELETION. Type MAN, base table STK_MAST.

Field inventory

136

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Label 3 T -1 571, 505
  
1 0.0 Label 1 T -1 391, 505
  
1 0.0 H -1 1, 61
  
1 0.0 AM_BLOCK_DEL I 0 101, 553
  
1 0.0 AM_DELAUTO I 0 141, 253
  
1 0.0 AM_DEL_LEN I 0 81, 553
  
1 0.0 AM_DEL_SUPPEDIT I 0 1, 289
  
1 0.0 AM_SLSM_ENTRY I 0 101, 253
  
1 0.0 CANSAVE I 0 1, 553
  
1 0.0 CMD 1 C 0 651, 576
  
1 0.0 CMD 15 C -1 221, 109
  $SELECT    'SELECTION IF SALES SECTIONS NOT USED  I:I\SM_AGENT;<>;  DO(AGN)        'SELECT FOR AGENTS, AGENT SPECIFIC        I:I\SM_AGENT;<>;        S:DEL_NO_GOODS_MAN;I\SM_DELNO;I\SM_MARKET;I\SM_AGENT  DOEND(AGN)
1 0.0 CMD 16 C 0 191, 133
$SELECT  S:SUPPLIER_CODE;I\SM_SUPP
1 0.0 CMD 2 C 0 571, 85
$SELECT  S:AGENT_TYPE_DEL;I\SM_DELTYPE
1 0.0 CMD 22 C -1 201, 85
$SELECT  S:AGENT_MAST_MKT;I\SM_AGENT;I\SM_MARKET
1 0.0 CMD 25 C 0 191, 181
$SELECT  S:TRANSPORTER_MAST;I\SM_TRNPTR
1 0.0 CMD 3 C 0 571, 145
$SELECT  S:AREA_CODE;I\SM_AREA
1 0.0 CMD 45 C 0 141, 301
$SELECT  S:ITEM_SEL;I\SD_ITEM  A:SELPARM;2;I\TMP1  A:CON;I\SD_ITEM;I\SD_ITEM;I\TMP1
1 0.0 CMD 51 C 0 421, 301
SELECT CONTAINER FROM SELECTION WINDOW  $SELECT  S:CONT_PR_NODEL;I\SD_CONT;I\PROD;I\VAR;I\SD_CLASS;I\SD_SIZE
1 0.0 CM_CENTRAL_PALL I 0 61, 553
  
1 0.0 CM_DELSECT I 0 71, 61
  
1 0.0 CNT_REQ I 0 280, 578
  
1 0.0 CONS T -1 451, 253
  
1 0.0 DEFAULT I 0 141, 37
$DEFAULT    A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    A:USERIP;;I\IP  A:USERID;;I\USER    'U:ZZGRID_SPLIT;INIT_GRID;G\MEMBERS;I\SP_SUPPL:H,I\SP_TYPE,I\SP_ACCNO,I\SP_DATE_JOINED  'U:ZZGRID_SPLIT;DB_TO_GRID;G\MEMBERS;SUPPL_PALL_ACC,SP_SUPPL='I\CP_SUPPLIER'    'INITIALIZE CONSIGNMENT GRID  U:ZZ
1 0.0 EXIST I 0 1, 361
  
1 0.0 IP I 0 311, 577
  
1 0.0 Label 1 T -1 291, 25
  
1 0.0 Label 1 T -1 421, 253
  
1 0.0 Label 1 T -1 171, 277
  
1 0.0 Label 17 T -1 601, 85
  
1 0.0 Label 19 T -1 221, 133
  
1 0.0 Label 2 T -1 281, 49
  
1 0.0 Label 21 T -1 231, 85
  
1 0.0 Label 24 T -1 221, 181
  
1 0.0 Label 3 T -1 1, 25
  
1 0.0 Label 33 T 0 581, 229
  
1 0.0 Label 4 T -1 621, 25
  
1 0.0 Label 5 T -1 621, 49
  
1 0.0 Label 6 T -1 671, 25
  
1 0.0 Label 68 T -1 21, 505
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 MENMAINT C 0 701, 241
$SELECT  I:I\SM_SUPP;<>;  E:$GBLROOT$LEGEND\PROJ_FMS\BIN\MAINMENU.EXE P SUPPL_PALL_ACC_MAN $I\SM_SUPP$ <ENTER>  'LOAD SUPPLIER MEMBER DETAILS  U:DELIVERY_MAN;MEMBERS;G\MEMBERS,I\SM_SUPP  O:SETFOCUS;I\SM_SUPP
1 0.0 NO_LINES I 0 1, 517
  
1 0.0 ORGS I 0 101, 61
  
1 0.0 POOL I 0 21, 553
  
1 0.0 PROHIBIT_SALES I 0 171, 37
  
1 0.0 STK_DETS SD_COMMENT T -1 491, 277
  
1 0.0 SD_CONQTY T -1 451, 277
  
1 0.0 STK_DETS SD_CONSIGN I 0 251, 577
  
1 0.0 STK_DETS SD_CONT T -1 371, 277
  
1 0.0 STK_DETS SD_ITEM T -1 91, 277
  
1 0.0 SD_SEQ T -1 51, 277
  
1 0.0 SECTION I 0 1, 493
  
1 0.0 STK_MAST SM_AGENT T -1 1, 85
  
1 0.0 STK_MAST SM_AREA T -1 411, 145
  
1 0.0 STK_MAST SM_DDATE T -1 411, 109
  
1 0.0 STK_MAST SM_DELNO T -1 1, 109
  
1 0.0 STK_MAST SM_DELTYPE T -1 411, 85
  
1 0.0 STK_MAST SM_DTIME T -1 631, 109
  
1 0.0 STK_MAST SM_MARKET I 0 111, 37
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\SM_MARKET  A:ORGS;;I\ORGS      'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\CM_DEL_LEN=CM_DEL_LEN    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MARKET    'LOAD OPTIONS FROM CLIENT_MAST  F:CLIENT_MAST;;;I\CM_DELSECT=CM_DELSECT,I\CM_CENTRAL
1 0.0 STK_MAST SM_REFNO T -1 1, 157
  
1 0.0 STK_MAST SM_SUPP T -1 1, 133
  
1 0.0 STK_MAST SM_TRNPTR T -1 1, 181
  
1 0.0 STK_MAST SM_USER I 0 231, 577
  
1 0.0 STK_MAST SM_VREGNO T -1 1, 205
  
1 0.0 STK_MAST SM_WAYBILLNO T -1 411, 181
  
1 0.0 SUPPL_PALL_ACC SP_ACCNO I 0 632, 155
  
1 0.0 SUPPL_PALL_ACC SP_DATE_JOINED I 0 711, 155
  
1 0.0 SUPPL_PALL_ACC SP_TYPE I 0 571, 193
  
1 0.0 SUM_TFR_ACTIVE_DATE I 0 161, 253
  
1 0.0 SUM_TFR_SUPPLNO I 0 81, 61
  
1 0.0 TMP1 I 0 31, 61
  
1 0.0 TMP16 I 0 51, 61
  
1 0.0 TMP2 I 0 121, 253
  
1 0.0 TMP3 I 0 1, 337
  
1 0.0 TMP5 I 0 41, 553
  
1 0.0 TMP6 I 0 431, 541
  
1 0.0 TOT_REC I 0 501, 541
  
1 0.0 Work 1 I 0 21, 61
  
1 0.0 Work 1 I 0 1, 61
  
1 0.0 Work 1 # -1 191, 241
'I:I\SM_DELTYPE;<>;D  '  DO(NODUAL)  '    O:DISABLEINPUT;I\SM_DELTYPE  '    O:HIDE;C\SM_DELTYPE  '  DOEND(NODUAL)'    '  I:I\SM_DELTYPE;=;D  '  DO(DUAL)  '      O:ENABLEINPUT;I\SM_DELTYPE  '      O:SHOW;C\SM_DELTYPE  '      A:CONST;;I\SM_DELTYPE  '  DOEND(DUAL)
1 0.0 Work 1 I 0 101, 61
  
1 0.0 Work 1 I 0 191, 577
  
1 0.0 Work 1 I 0 451, 541
  
1 0.0 Work 1 I 0 21, 277
'THIS FIELD WAS ADDED BY JUSTIN ON 10/09/08 AT KASSIE'S REQUEST    
1 0.0 Work 1 I 0 11, 301
  
1 0.0 Work 1 I 0 11, 373
  
1 0.0 Work 2 I 0 131, 577
  
1 0.0 Work 2 I 0 211, 577
  
1 0.0 Work 2 I -1 171, 301
  
1 0.0 Work 2 I 0 1, 325
  
1 0.0 Work 2 I 0 21, 325
  
1 0.0 Work 3 I 0 151, 577
  
1 0.0 Work 35 G 0 551, 145
  
1 0.0 Work 4 I 0 71, 577
  
1 0.0 Work 4 I 0 411, 541
  
1 0.0 Work 5 I 0 91, 577
  
1 0.0 Work 6 I 0 171, 577
  
1 0.0 Work 6 I 0 601, 541
  
1 0.0 Work 64 G -1 51, 301
  
1 0.0 Work 71 I 0 51, 577
  
1 0.0 STK_MAST SM_DELIND I 0 141, 61
  
1 0.0 Work 2 I 0 181, 253
  
1 0.0 CMD 4 C -1 541, 505
$SELECT  'DISPLAY A SELECTION WINDOW  S:GATE_REASON;I\REASON
1 0.0 Work 1 I 0 141, 541
  
1 1.0 DELETE K -1 251, 505
$VALIDATE  I:I\SM_MARKET;=;11  O:SETFOCUS;I\REASON    I:I\SM_MARKET;<>;11  O:SETFOCUS;Z\ZX_UPDATE  
1 1.0 STK_MAST SM_AGENT I -1 121, 85
$DEFAULT  'GET THIS USERS AGENT CODE  'A:ORGS;;I\ORGS  A:ORGS  I:I\ORGS;<>;  O:SETFOCUS;I\SM_DELNO  'O:SETFOCUS;I\SM_DELTYPE    A:CONST;+;I\SDG_CONSIGN  'GET AGENTS NAME FROM AGENT_MAST AND DISABLE AGENT CODE INPUT  I:I\SM_AGENT;<>;  DO(001)    F:AGENT_MAST;;;T\AGENT_DESC=AM_NAME,I\AM_DELAUTO=AM_DELAUTO,W\SUPPLREFNO=AM
1 1.0 STK_MAST SM_DDATE I -1 521, 109
'$AFTER_READ  ''DEFAULT CURRENT DATE  'I:I\SM_DDATE;=;  'A:DATE;DD MMM YYYY;I\SM_DDATE  'I:I\SM_DATE;=;  'A:VAR;I\SM_DDATE;I\SM_DATE      '$VALIDATE  'I:I\SM_DDATE;=;  'A:DATE;DD MMM YYYY;I\SM_DDATE     'M:  'U:DATECHECKER;FUTURE;I\SM_DDATE    ''I:I\SM_DDATE  ''M:  
1 1.0 STK_MAST SM_DELNO I -1 121, 109
  $SELECT    'SELECTION IF SALES SECTIONS NOT USED  I:I\SM_AGENT;<>;  DO(AGN)        'SELECT FOR AGENTS, AGENT SPECIFIC        I:I\SM_AGENT;<>;        S:DEL_NO_GOODS_MAN;I\SM_DELNO;I\SM_MARKET;I\SM_AGENT  DOEND(AGN)        $VALIDATE  A:CONST;Y;I\MAN  M:    I:I\PROHIBIT_SALES;=;Y  D:YOU CAN'T CONTINUE DELIVERIES ARE PRO
1 1.0 STK_MAST SM_DELTYPE I -1 521, 85
'$SELECT  'S:AGENT_TYPE_DEL;I\SM_DELTYPE      '$VALIDATE    'C:UCASE  'F:AGENT_TYPE;Y;;T\TYPE_DESC=AT_DESC;AT_CODE='$I\SM_DELTYPE$' AND AT_CODE <> 'D';I\SM_DELTYPE  'C:MCASE;;T\TYPE_DESC      'O:SETFOCUS;I\SM_DDATE  ''O:SETFOCUS;I\SM_DELNO          '$ESC  'A:CONST;;I\SM_DELNO      $AFTER_READ    I:I\SM_DELTYPE;<>;  DO(
1 1.0 STK_MAST SM_DTIME I -1 711, 109
  '$AFTER_READ  ''DEFAULT CURRENT TIME  'I:I\SM_DTIME;=;  'A:TIME;HH:MM;I\SM_DTIME  'I:I\SM_TIME;=;  'A:VAR;I\SM_DTIME;I\SM_TIME    '$VALIDATE  'I:I\SM_DTIME;=;  'A:TIME;HH:MM;I\SM_DTIME  'M:    ''CHECK THAT THE THIRD DIGIT IS A ":"  'A:MID;I\SM_DTIME,3,1;I\TMP1    'I:I\TMP1;<>;:  '  D:ENTER IN FORMAT 00:00;ERRORM;I\SM
1 1.0 STK_MAST SM_REFNO I -1 121, 157
  $DEFAULT  'SET SUPPLIER REF NUMBER LENGTH  'A:CONST;16;I\TMP1  'A:FIELDLEN;I\TMP1;I\SM_REFNO      $VALIDATE    ''I:W\SUPPLREFNO;=;Y  ''DO(REFNO)  ''M:  ''DOEND(REFNO)    'C:UCASE  ''A:CONST;;I\SM_REFNO  ''A:CONST;16;I\TMP1  'A:FIELDLEN;I\TMP1;I\SM_REFNO    'I:I\SUM_TFR_SUPPLNO;<>;  'DO(CHK)  ' M:  'DOEND(CHK)    'I:I
1 1.0 STK_MAST SM_SUPP I -1 121, 133
'$SELECT  'S:SUPPLIER_MAST1;I\SM_SUPP;I\SM_AGENT    '$SELECT8  'A:VAR;I\SM_SUPP;I\TMP1  'I:I\AM_DEL_SUPPEDIT;=;1  'DO(001)  ''  NN:$GBLUSER$$I\SM_DTIME$;I\TMP1  ''  I:I\SM_SUPP;=;  ''  DO(002)  '    E:$GBLROOT$LEGEND\PROJ_FMS\BIN\MAINMENU.EXE P SUPPLIER_MAN $GBLUSER$$I\SM_DTIME$ $I\SM_SUPP$  '    F:ZV_USER_DEFAULTS;;;I
1 1.0 Work 2 I -1 491, 505
$SELECT  'DISPLAY A SELECTION WINDOW  S:GATE_REASON;I\REASON    $VALIDATE  I:I\SM_MARKET;=;11  DO(R)  M:  C:UCASE  DOEND(R)  I:I\REASON;=;  A:CONST;;T\REASON_NAME      I:I\REASON;<>;  F:REASON_MAST;Y;;T\REASON_NAME=RSN_DESC;RSN_TYPE='GN' AND RSN_REASON='$I\REASON$';I\REASON      I:I\SM_MARKET;=;11  DO(11)    I:I\PASS_C
1 1.0 STK_MAST SM_TIME I 0 721, 109
  
1 1.0 STK_MAST SM_TRNPTR I -1 121, 181
'$SELECT  'S:TRANSPORTER_MAST;I\SM_TRNPTR;I\SM_AGENT    '$VALIDATE  'A:CONST;;T\TRNPTR  'C:UCASE  ''LOAD TRANSPORTER DESCRITION  'I:I\SM_TRNPTR;<>;  'F:TRANSPORTER_MAST;Y;;T\TRNPTR=TR_NAME;TR_CODE='$I\SM_TRNPTR$' AND TR_AGENT='$I\SM_AGENT$';I\SM_TRNPTR    'C:MCASE;;T\TRNPTR    $AFTER_READ  'LOAD TRANSPORTER DESCRITION 
1 1.0 STK_MAST SM_VREGNO I -1 121, 205
'$VALIDATE  'C:UCASE  
1 2.0 DELIVERY NO I 0 251, 109
  
1 2.0 Label 1 T -1 281, 505
  
1 2.0 Label 67 T 0 1, 433
  
1 2.0 NO_OF_LINES I 0 1, 457
'$VALIDATE  'I:I\NO_OF_LINES;=;  'A:CONST;0;I\NO_OF_LINES    'I:I\NO_OF_LINES;<>;I\NO_LINES  'D:NUMBER OF LINES MUST BE EQUAL TO THE NUMBER OF ROWS IN THE GRID;ERRORM;I\NO_OF_LINES      '$VALIDATE    'I:I\NO_LINES;=;  'D:ERROR - NO RECORDS IN THE GRID TO PROCESS;ERRORM;I\SD_SEQ
1 2.0 REM I 0 231, 253
  
1 2.0 STK_DETS_GATE SDG_CONSIGN I -1 51, 301
  '$SELECT  ''''''''''S:G:G\DELIVERY;R1  'S:G:G\DELIVERY:R1;I\SDG_CONSIGN    '$VALIDATE  'C:UCASE      '$CALCULATE    'I:I\SDG_CONSIGN;=;  'DO(001)  '  A:CONST;;I\SDG_CONSIGN,I\SD_ITEM,I\SD_CONT,I\SD_RECQTY,I\SD_COMMENT,W\DEL  '  O:DISABLEINPUT;I\SD_ITEM,I\SD_CONT,I\SD_RECQTY,I\SD_COMMENT,W\DEL  '  O:DISABLEINPUT;G\DEL
1 2.0 STK_DETS_GATE SDG_CONT I -1 371, 301
''SELECT CONTAINER FROM SELECTION WINDOW  '$SELECT  'S:CONT_GATE;I\SD_CONT;I\PROD;I\VAR    '$CALCULATE  ''SET THIS FIELD AS MANDATORY AND CHANGE CASE TO UPPER CASE  ''M:  'C:UCASE    ''LOOKUP FOR AN EXISTING CONTAINER, IF NOT FOUND DISPLAY ERROR MESSAGE AND IF BLOCKED DISPLAY ERROR MESSAGE  'I:I\SD_CONT;<>;  'DO(C1)  '
1 2.0 STK_DETS_GATE SDG_ITEM I -1 91, 301
''SELECT ITEM FROM SELECTION WINDOW  '$SELECT  'S:ITEM_SEL;I\SD_ITEM  'A:SELPARM;2;I\TMP1  'A:CON;I\SD_ITEM;I\SD_ITEM;I\TMP1    '$CALCULATE  'A:CONST;;I\SD_PROV  ''SET THIS FIELD AS MANDATORY AND CHANGE TEXT CASE TO UPPER CASE  'M:  'C:UCASE  ''GET PRODUCT LEFT 2 CHARACTERS  'A:LEFT;I\SD_ITEM,2;I\PROD  ''GET VARIETY TH
1 2.0 STK_DETS_GATE SDG_RECQTY I -1 451, 301
'$CALCULATE'    ''CHECK CONSIGNMENT QTY  'I:I\SD_RECQTY;<=;0;NUM  'D:CONSIGNMENT QTY CANNOT BE NEGATIVE OR ZERO;ERRORM;I\SD_RECQTY'    ''I:I\SD_RECQTY;=;0;NUM  ''A:VAR;I\SD_CONQTY;I\SD_RECQTY
1 2.0 STK_DETS_GATE SDG_REMARKS I -1 491, 301
    $BEFORE_WRITE        I:K\DEL;=;1  DO(03)  U:DELETE_DUMMY_SUPPL_DELIV;DELETE_DUMMY_SUPPL  A:CONST;Y;I\SM_DELIND  DOEND(03)    'A:VAR;I\USER;I\SM_USER          $AFTER_WRITE  I:K\DEL;=;1  DO(PROCESS)   'U:GOODS_RECEPTION_UPDATE;TABLE_UPDATE;G\DELIVERY,I\SM_MARKET,I\SM_AGENT,I\SM_DELNO,T\DATE,I\SM_DATE,T\TIME,I\SM_TIME
1 2.0 STK_MAST SM_AREA I -1 521, 145
'$SELECT  'S:AREA_CODE;I\SM_AREA    '$VALIDATE  'M:  'C:UCASE  'F:AREA_MAST;Y;AR_CODE;;;I\SM_AREA
1 2.0 STK_MAST SM_DATE I 0 531, 121
  
1 2.0 STK_MAST SM_WAYBILLNO I -1 521, 181
'$VALIDATE  'C:UCASE  
1 2.0 TOT_REC I -1 141, 505
  $AFTER_WRITE  I:I\ORGS;=;   DO(NOAGN)    O:ENABLEINPUT;I\SM_AGENT,C\AGENT    O:SETFOCUS;I\SM_AGENT   DOEND(NOAGN)      I:I\ORGS;<>;  DO(AGN)  O:SETFOCUS;I\SM_DELNO  O:DISABLEINPUT;I\SM_DELTYPE  O:ENABLEINPUT;I\SM_DELNO  DOEND(AGN)
1 3.0 SP_SUPPL I 0 521, 205
  
10 0.0 ZX_DELETE Z 0 1, 61
  
10 0.0 ZX_EXIT Z 0 1, 61
  
10 0.0 ZX_PRINT Z 0 1, 61
  
10 0.0 ZX_SELECT Z 0 1, 61
  
10 0.0 ZX_UPDATE Z 0 1, 61