Freshmark replication server

freshmark-canonical

Program drill-down

GOODS_RECEPTION_MAN

GOODS RECEPTION MAINTENANCE. Type MAN, base table STK_MAST.

Field inventory

139

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 H -1 1, 61
  
1 0.0 AM_BLOCK_DEL I 0 271, 541
  
1 0.0 AM_DELAUTO I 0 241, 277
  
1 0.0 AM_DEL_LEN I 0 251, 541
  
1 0.0 AM_DEL_SUPPEDIT I 0 101, 277
  
1 0.0 AM_SLSM_ENTRY I 0 161, 277
  
1 0.0 CANSAVE I 0 1, 553
  
1 0.0 CMD 1 C 0 651, 576
  
1 0.0 CMD 15 C -1 211, 85
  '$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)    $SELECT    'SELECTION IF SALES SECTIONS NOT USED  I:I\ORGS;<>;  DO(AGN)        'SELECT FOR AG
1 0.0 CMD 16 C -1 191, 133
$SELECT  S:SUPPLIER_CODE;I\SM_SUPP
1 0.0 CMD 2 C -1 571, 85
$SELECT  S:AGENT_TYPE_DEL;I\SM_DELTYPE
1 0.0 CMD 22 C -1 201, 109
$SELECT  S:AGENT_MAST_MKT;I\SM_AGENT;I\SM_MARKET
1 0.0 CMD 25 C -1 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 -1 141, 325
'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
1 0.0 CMD 5 C 0 431, 241
  
1 0.0 CMD 51 C -1 421, 325
'SELECT CONTAINER FROM SELECTION WINDOW  $SELECT  S:CONT_GATE;I\SD_CONT;I\PROD;I\VAR
1 0.0 CM_CENTRAL_PALL I 0 61, 553
  
1 0.0 CM_DELSECT I 0 261, 277
  
1 0.0 CNT_REQ I 0 280, 578
  
1 0.0 CONS T -1 451, 277
  
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 91, 241
  
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, 277
  
1 0.0 Label 1 T -1 171, 301
  
1 0.0 Label 1 T -1 741, 301
  
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 261, 49
  
1 0.0 Label 21 T -1 231, 109
  
1 0.0 Label 24 T -1 221, 181
  
1 0.0 Label 3 T -1 1, 25
  
1 0.0 Label 3 T 0 341, 205
  
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 6 T 0 331, 241
  
1 0.0 Label 68 T -1 331, 517
  
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 Work 1 I 0 541, 265
  
1 0.0 NO_LINES I 0 221, 517
  
1 0.0 ORGS I 0 331, 277
  
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, 301
  
1 0.0 SD_CONQTY T -1 451, 301
  
1 0.0 STK_DETS SD_CONSIGN I 0 251, 577
  
1 0.0 STK_DETS SD_CONT T -1 371, 301
  
1 0.0 STK_DETS SD_ITEM T -1 91, 301
  
1 0.0 SD_SEQ T -1 51, 301
  
1 0.0 SECTION I 0 261, 517
  
1 0.0 STK_MAST SM_AGENT T -1 1, 109
  
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, 85
  
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 301, 277
  
1 0.0 SUM_TFR_SUPPLNO I 0 281, 277
  
1 0.0 TMP1 I 0 201, 277
  
1 0.0 TMP16 I 0 221, 277
  
1 0.0 TMP2 I 0 181, 277
  
1 0.0 TMP3 I 0 141, 277
  
1 0.0 TMP5 I 0 291, 517
  
1 0.0 TMP6 I 0 431, 541
  
1 0.0 Work 1 I 0 591, 265
  
1 0.0 TOT_REC I 0 501, 541
  
1 0.0 Work 1 I 0 211, 241
  
1 0.0 Work 1 I 0 181, 241
  
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 351, 181
  
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 121, 241
'THIS FIELD WAS ADDED BY JUSTIN ON 10/09/08 AT KASSIE'S REQUEST    
1 0.0 Work 1 I 0 61, 277
  
1 0.0 Work 1 I 0 151, 241
  
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, 325
  
1 0.0 Work 2 I 0 81, 277
  
1 0.0 Work 2 I 0 121, 277
  
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, 349
  
1 0.0 Work 71 I 0 51, 577
  
1 0.0 Work 1 I 0 11, 253
  
1 0.0 Work 2 I 0 11, 229
  
1 1.0 STK_MAST SM_AGENT I -1 121, 109
$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, 85
  '$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)        $SELECT    'SELECTION IF SALES SECTIONS NOT USED  I:I\ORGS;<>;  DO(AGN)        'SELECT FO
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;<>;  F:AGENT_TYPE;
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_DTIME    'CHE
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\SUM_TFR_SUPPLNO;<>;
1 1.0 STK_MAST SM_SMAN I 0 331, 229
'$SELECT  'S:SALESMAN_MAST;I\SM_SMAN;I\SM_AGENT    '$VALIDATE  'I:I\AM_SLSM_ENTRY;=;2  'DO(001)  '  M:  '  C:UCASE  '  A:ZEROFILL;I\SM_SMAN,3;I\SM_SMAN  '  F:SALESMAN_MAST;Y;SLS_CODE;T\SMAN_DESC=SLS_NAME;SLS_AGENT='$I\SM_AGENT$';I\SM_SMAN  '  C:MCASE;;T\SMAN_DESC  'DOEND(001)    '$AFTER_READ  'I:I\SM_SMAN;<>;  'F:SALES
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\SM_SUPP=ZV
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  I:I\SM_T
1 1.0 STK_MAST SM_VREGNO I -1 121, 205
$VALIDATE  C:UCASE  
1 2.0 DELIVERY NO I 0 241, 85
  
1 2.0 Label 1 T 0 661, 517
  
1 2.0 Label 67 T 0 1, 517
  
1 2.0 NOTE K 0 621, 517
'$VALIDATE  'O:SETFOCUS;Z\ZX_UPDATE    '$AFTER_WRITE  'I:K\NOTE;=;1  'DO(01)  'I:I\NO_LINES;<>;0  'E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_DELIVERY;$I\SM_MARKET$,$I\SM_AGENT$,$I\SM_DELNO$,P  ''I:I\NO_LINES;=;0  ''D:ERROR - NO RECORDS IN GRID TO PROCESS;ERROR;I\SD_SEQ  'DOEND(01)    'I:I\ORGS;=;  ' DO(N
1 2.0 NO_OF_LINES I 0 111, 517
'$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  'COMMENTED BY LP19052010  'I:I\NO_LINES;=;  'D:ERROR - NO RECORDS IN THE GRID TO PROCESS;ERRORM;I\SD_SEQ
1 2.0 REM I 0 641, 289
  
1 2.0 STK_DETS_GATE SDG_CONSIGN I -1 51, 325
  $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,C\ITEM,I\SD_CONT,I\SD_RECQTY,I\SD_COMMENT,W\DEL    O:DISABLEINPUT;G\DELIVE
1 2.0 STK_DETS_GATE SDG_CONT I -1 371, 325
'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)  F:CONT_MAST
1 2.0 STK_DETS_GATE SDG_ITEM I -1 91, 325
$DEFAULT  O:DISABLEINPUT;I\SD_ITEM,C\ITEM,I\SD_CONT,C\CONT,I\SD_RECQTY,I\SD_COMMENT,W\DEL          '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
1 2.0 STK_DETS_GATE SDG_RECQTY I -1 451, 325
$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    O:ENABLEINPUT;I\SD_COMMENT
1 2.0 STK_DETS_GATE SDG_REMARKS I -1 491, 325
  '$CALCULATE  $VALIDATE  'SET TEXT CASE TO UPPER CASE  C:UCASE    O:ENABLEINPUT;W\DEL
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 451, 517
'$VALIDATE  '$CALCULATE  'I:I\TOT_REC;=;  'A:CONST;0;I\TOT_REC    'I:I\TOT_REC;<>;I\TOT_REC1  'D:TOTAL RECEIVED MUST BE EQUAL TO THE TOTAL ITEM QUANTITY RECEIVED;ERRORM;I\TOT_REC    ''O:SETFOCUS;C\UPDATE  'I:I\TOT_REC;<>;0  '  DO(01)  '   O:SHOW;K\NOTE  '   O:SHOW;T\NOTE  '   O:ENABLEINPUT;K\NOTE  '  DOEND(01)        $
1 2.0 Work 2 I -1 741, 325
$VALIDATE  C:UCASE  V:X;      $CALCULATE  U:DELIVERY_MAN;CHK_MAX;G\DELIVERY,1  I:I\TMP1;<>;  D:SORRY ONLY $I\TMP1$ CONSIGNMENTS CAN BE ENTERED PER DELIVERY;ERRORM;I\SD_SEQ      A:LEFT;I\SD_ITEM,2;I\PROD  A:MID;I\SD_ITEM,3,2;I\VAR  A:CONST;;I\TMP1  F:VAR_MAST;Y;;I\TMP1=VA_BLOCKED;VA_PRODUCT='$I\PROD$' AND VA_VARIETY='$I
1 3.0 SP_SUPPL I 0 481, 229
  
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