Freshmark replication server

freshmark-canonical

Program drill-down

REGRADES_MAN

REGRADE CONSIGNMENT DELIVERIES. Type MAN, base table STK_MAST.

Field inventory

120

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Label 1 T 0 1, 541
  
1 0.0 Work 5 I 0 611, 229
  
1 0.0 Work 6 I 0 651, 229
  
1 0.0 H -1 0, 0
  
1 0.0 STK_MAST SM_WAYBILLNO T -1 351, 229
  
1 0.0 I -1 111, 229
  
1 0.0 Label 9 T -1 191, 169
  
1 0.0 Label 10 T -1 191, 193
  
1 0.0 I -1 641, 145
  
1 0.0 STK_MAST SM_REFNO T -1 521, 145
  
1 0.0 Work 12 G -1 11, 349
  
1 0.0 Label 16 T -1 91, 301
  
1 0.0 I -1 641, 193
  
1 0.0 STK_MAST SM_DELNO T -1 1, 109
  
1 0.0 I -1 381, 109
  
1 0.0 STK_MAST SM_DTIME T -1 301, 109
  
1 0.0 I -1 641, 109
  
1 0.0 STK_MAST SM_DDATE T -1 521, 109
  
1 0.0 STK_MAST SM_MREFNO T -1 1, 229
  
1 0.0 Label 8 T -1 191, 145
  
1 0.0 STK_MAST SM_AREA T -1 521, 193
  
1 0.0 STK_DETS SD_CONSIGN T -1 11, 301
  
1 0.0 STK_DETS SD_CONSIGN I -1 11, 325
$SELECT  S:G:G\GRID;I\SD_CONSIGN;R1    $CALCULATE  C:UCASE    F:CLIENT_MAST;;;I\DEL_LEN=CM_DEL_LEN;CM_CODE='$I\MARKET$'  A:ADD;"2";I\DEL_LEN;I\DEL_LEN  A:ZEROFILL;I\SD_CONSIGN,I\DEL_LEN;I\SD_CONSIGN    I:I\SD_CONSIGN;=;  DO(SPO)    '''A:CONST;;I\GRADE,I\SD_REGRDCD,I\SD_REGRDTE,I\ACTION,I\QTY_AVAIL    '''O:DISABLEINPUT;
1 0.0 STK_MAST SM_SUPP T -1 1, 145
  
1 0.0 I -1 111, 169
  
1 0.0 STK_MAST SM_AGENT T -1 1, 169
  
1 0.0 I -1 111, 193
  
1 0.0 STK_MAST SM_SMAN T -1 1, 193
  
1 0.0 STK_MAST SM_DELNO I -1 111, 109
$SELECT  ''I:I\ORGS;=;  ''S:DELIVERY_CONSIGN;I\SM_DELNO    S:REGRADES;I\SM_DELNO    'JD 20081209  'I:I\ORGS;<>;  'S:DELIVERY_CONSIGN_AGN;I\SM_DELNO;I\ORGS    $VALIDATE  M:      A:ZEROFILL;I\SM_DELNO,W\ZEROFILL,I\SM_DELNO    I:I\ORGS;=;  F:STK_MAST;Y;;I\SM_AGENT=SM_AGENT;SM_MARKET = '$I\MARKET$' AND SM_DELNO='$I\SM_DELN
1 0.0 STK_DETS SD_ITEM I 0 601, 265
  
1 0.0 Work 3 I 0 41, 541
  
1 0.0 Work 1 I 0 81, 61
  
1 0.0 I -1 111, 145
  
1 0.0 STK_MAST SM_WAYBILLNO I -1 441, 229
  
1 0.0 STK_DETS NOTHING I -1 91, 325
  
1 0.0 STK_DETS SD_RECQTY I -1 211, 325
  
1 0.0 STK_DETS SD_RECQTY T -1 211, 301
  
1 0.0 Label 19 T -1 271, 301
  
1 0.0 Work 20 I -1 271, 325
  
1 0.0 Label 21 T -1 371, 301
  
1 0.0 Work100 I 0 391, 505
$CALCULATE  ^M:    '''''''''$VALIDATE  C:UCASE  A:LEN;I\GRADE;I\TMP350    I:I\SD_CONSIGN;<>;  DO(NDG)    I:I\TMP350;<>;2;NUM    D:GRADE MUST BE 2 CHARACTERS LONG;ERRORM;I\GRADE      'VALIDATION FOR THE CLASS - FIRST CHARACTER OF THIS FIELD - EXAMPLE THE 2 IN 2M    I:I\GRADE;<>;    DO(E2)      A:VAR;I\GRADE;W\GRADE_TEMP
1 0.0 Work 2 I 0 751, 193
  
1 0.0 Label 28 T -1 91, 277
  
1 0.0 STK_DETS SD_REGRDCD T -1 461, 301
  
1 0.0 STK_DETS SD_REGRDTE I -1 641, 325
$CALCULATE  ^M:    U:DATECHECKER;FUTURE;I\SD_REGRDTE
1 0.0 STK_DETS SD_REGRDTE T -1 641, 301
  
1 0.0 Label 25 T -1 741, 301
  
1 0.0 Work 26 I -1 741, 325
$CALCULATE  C:UCASE  V:D;  I:I\ACTION;=;D  DO(81)  I:I\TMP355;<>;Y  D:MAY NOT DELETE A NEW ENTRY;ERRORM;I\ACTION   U:REGRADES_ENTRY;DELETE_REGRADE   A:VAR;I\OLD_CLASS;I\SD_CLASS   A:VAR;I\OLD_SIZE;I\SD_SIZE  DOEND(81)    I:I\CDATE;<>;  DO(D3M)    A:VAR;T\DATE;I\TMP2;;YYYY/MM/DD    A:VAR;I\CDATE;I\CDATE;;YYYY/MM/DD     
1 0.0 Label 29 T -1 211, 277
  
1 0.0 Label 30 T -1 271, 277
  
1 0.0 Label 31 T -1 371, 277
  
1 0.0 Label 32 T -1 461, 277
  
1 0.0 Label 34 T -1 541, 301
  
1 0.0 Work 35 I -1 541, 325
  
1 0.0 Label 36 T -1 1, 25
  
1 0.0 Label 37 T -1 291, 25
  
1 0.0 Label 38 T -1 621, 49
  
1 0.0 Label 39 T -1 351, 49
  
1 0.0 Label 40 T -1 671, 25
  
1 0.0 Label 41 T -1 671, 49
  
1 0.0 Label 42 T -1 621, 25
  
1 0.0 Label 43 T -1 1, 505
  
1 0.0 Work 44 I -1 141, 505
  
1 0.0 CMD 45 C -1 211, 109
$SELECT  'I:I\ORGS;=;  'S:DELIVERY_CONSIGN;I\SM_DELNO    'I:I\ORGS;<>;  'S:DELIVERY_CONSIGN_AGN;I\SM_DELNO;I\ORGS    S:REGRADES;I\SM_DELNO    
1 0.0 Work 46 I 0 61, 541
  
1 0.0 Work 47 I 0 51, 61
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET  A:ORGS;;I\ORGS    'LOAD MARKET NAME  F:CLIENT_MAST;;CM_CODE;I\PROHIBIT_SALES=CM_PROHIBIT_SALES,T\MARKET=CM_NAME,W\ZEROFILL=CM_DEL_LEN    I:I\PROHIBIT_SALES;=;Y  DO(LAM)    O:DISABLEINPUT;I\SM_DELNO    D:SALES ARE PROHIBITED, TRANSACTION CANNOT BE DONE;ERRORM;I\SM_DELNO  DOE
1 0.0 Work 48 I 0 21, 61
$DEFAULT  'INITIALIZES THE DATE AND TIME INTO THE T\DATE AND T\TIME FIELDS  A:DATE;DD MMM/YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    ''U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SD_CONSIGN,I\COMMODITY,I\SD_RECQTY,I\QTY_AVAIL,I\SD_PREVGRD,I\GRADE,I\COUNT,I\SD_REGRDCD,I\REAS,I\SD_REGRDTE,I\SD_CLASS:H,I\SD_SIZE:H,I\SD
1 0.0 Work 49 I 0 101, 541
  
1 0.0 Work 50 I 0 81, 541
  
1 0.0 Work 51 I 0 291, 505
  
1 0.0 Work 52 I 0 321, 505
  
1 0.0 Work 53 I 0 411, 577
  
1 0.0 Work 55 I 0 201, 541
  
1 0.0 Work 56 I 0 221, 541
  
1 0.0 Work 1 I 0 121, 565
  
1 0.0 Work 2 I 0 101, 565
  
1 0.0 Work 3 I 0 81, 565
  
1 0.0 Work 4 I 0 141, 565
  
1 0.0 Work 5 I 0 61, 565
  
1 0.0 Work 6 I 0 41, 565
  
1 0.0 Work 7 I 0 161, 565
  
1 0.0 STK_DETS SD_CLASS I -1 371, 325
$SELECT  S:CLASS_NB;I\SD_CLASS    $CALCULATE  C:UCASE  I:I\SD_CLASS;=;  D:ENTER A VALID CLASS;ERRORM;I\SD_CLASS    I:I\SD_CLASS;<>;  DO(VEV)    F:COMMODITY_MAST;Y;;;CO_CLASS='$I\SD_CLASS$';I\SD_CLASS  DOEND(VEV)
1 0.0 STK_DETS SD_SIZE I -1 401, 325
$SELECT  S:SIZE_NB;I\SD_SIZE    $CALCULATE  C:UCASE  I:I\SD_SIZE;=;    'D:ENTER A VALID SIZE;ERRORM;I\SD_SIZE    'VARIETY '$I\VARIETY$' DOES NOT EXIST FOR '$I\PROD$' PRODUCT;ERRORM;I\VARIETY  I:I\SD_CLASS;<>;  DO(SZ)    I:I\SD_SIZE;<>;    DO(GRD)      F:COMMODITY_MAST;Y;;;CO_SIZE='$I\SD_SIZE$';I\SD_SIZE      'I:I\SD_SI
1 0.0 STK_DETS SD_CONT I 0 631, 265
  
1 0.0 STK_DETS SD_CONTMASS I 0 661, 265
  
1 0.0 Work 1 I 0 241, 541
  
1 0.0 Work 2 I 0 551, 541
  
1 0.0 Work 3 I 0 581, 541
$BEFORE_WRITE  '''A:CONST;;I\SD_CONSIGN,I\COMMODITY,I\SD_RECQTY,I\QTY_AVAIL,I\SD_PREVGRD,I\GRADE,I\COUNT,D\SD_REGRDCD,I\REAS,I\SD_REGRDTE,I\ACTION  A:CONST;;I\SD_CONSIGN,I\COMMODITY,I\SD_RECQTY,I\QTY_AVAIL,I\SD_PREVGRD,I\SD_CLASS,I\SD_SIZE,I\COUNT,D\SD_REGRDCD,I\REAS,I\SD_REGRDTE,I\ACTION
1 0.0 Label 2 T 0 200, 385
  
1 0.0 Work 1 I 0 481, 529
  
1 0.0 STK_DETS SD_PREVGRD I -1 321, 325
  
1 0.0 Work 4 I 0 181, 541
  
1 0.0 Work 7 I 0 121, 541
  
1 0.0 Label 2 T -1 321, 301
  
1 0.0 T -1 321, 277
  
1 0.0 Label 2 T 0 1, 565
  
1 0.0 Work 4 I 0 191, 61
$DEFAULT  A:USERID;;I\USERID  A:USERIP;;I\IP
1 0.0 Work 5 I 0 221, 61
  
1 0.0 Work 1 I 0 161, 541
  
1 0.0 Work 2 I 0 141, 541
  
1 0.0 Work 1 I 0 181, 565
  
1 0.0 Work 1 I 0 741, 265
  
1 0.0 Work 2 I 0 761, 265
  
1 0.0 ZERO FILL I 0 321, 541
  
1 0.0 Work 1 I 0 121, 253
  
1 0.0 COMTST I 0 251, 349
  
1 0.0 Label 2 T -1 431, 301
  
1 0.0 STK_DETS SD_COUNT I -1 431, 325
$SELECT  S:COUNT;I\COUNT;I\SD_PRODUCT;I\GRADE    $CALCULATE  I:I\CONTCHK;=;Y  M:      I:I\COUNT;<>;  F:COUNT_MAST;Y;;;CNT_PRODUCT='$I\SD_PRODUCT$' AND CNT_GRADE='$I\GRADE$' AND CNT_COUNT='$I\COUNT$' AND CNT_CONTAINER = '$I\SD_CONT$';I\COUNT                    
1 0.0 CONTCHK I 0 401, 193
  
1 0.0 STK_DETS SD_REGRDCD I -1 461, 325
$SELECT  S:DEV_CODE;I\SD_REGRDCD    $CALCULATE  ^M:  'I:I\SD_CONSIGN;<>;  I:I\SD_REGRDCD;<>;  DO(NDF)    C:UCASE    F:DEVIATION_MAST;Y;AF_CODE;I\REAS=AF_DESC;AF_CODE='$I\SD_REGRDCD$';I\SD_REGRDCD  DOEND(NDF)    
1 0.0 CMD 2 C -1 511, 325
$SELECT  S:DEV_CODE;I\SD_REGRDCD
1 0.0 Work 4 I 0 381, 145
  
1 0.0 CDATE I 0 11, 277
  
1 0.0 Label 1 T 0 200, 355
  
1 0.0 Work 3 I 0 261, 385
  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_UPDATE Z 0 0, 0
  
10 0.0 ZX_EXIT Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_PRINT Z 0 0, 0