Freshmark replication server

freshmark-canonical

Program drill-down

CS_OTHER_ISS_MAN

COLD STORAGE OTHER ISSUES MAINTENANCE. Type DSP, base table LOC_TRANS.

Field inventory

116

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
0 0.0 Label 7 T -1 521, 193
  
1 0.0 Label 1 T -1 401, 133
  
1 0.0 Label 4 T -1 131, 181
  
1 0.0 Label 9 T -1 551, 253
  
1 0.0 Label 14 T -1 131, 349
  
1 0.0 Label 8 T -1 381, 253
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 5 T -1 131, 205
  
1 0.0 DEBTOR_MAST DM_DEBTOR T -1 131, 133
  
1 0.0 Label 4 T -1 131, 373
  
1 0.0 Label 3 T -1 351, 181
  
1 0.0 Work 8 I 0 11, 325
  
1 0.0 Work 7 I 0 11, 301
  
1 0.0 Work 6 I 0 11, 277
  
1 0.0 Work 3 I 0 11, 253
  
1 0.0 Work 5 I 0 11, 277
  
1 0.0 Work 1 I 0 41, 277
  
1 0.0 Work 1 I 0 11, 253
  
1 0.0 Work 2 I 0 11, 253
  
1 0.0 LOC_TRANS LT_ITEM I -1 291, 181
$SELECT    'GETS PRODUCT  S:ITEM_VARIETY;I\LT_ITEM    'PUTS VARIETY INTO A SEPARATE FIELD TO BE CONCATENATED  A:SELPARM;2;W\VAR_TEMP    'CONCATENATE PRODUCT & VARIETY & PUT INTO ITEM GRID FIELD  A:CON;I\LT_ITEM;I\LT_ITEM;W\VAR_TEMP      $CALCULATE    'MANDATORY  M:    'CONVERT TO UPPERCASE  C:UCASE    'CHECK IF A VALID
1 0.0 LOC_TRANS LT_PRCONT I -1 291, 205
$SELECT  S:CONT_PD;I\LT_PRCONT;W\PRODUCT_TEMP;W\VAR_TEMP    $CALCULATE    'MANDATORY  M:    'CONVERT TO UPPERCASE  C:UCASE    'CHECK IF A VALID CONTAINER IS ENTERED  F:COMMODITY_MAST;Y;;;CO_PRODUCT='$W\PRODUCT_TEMP$' AND CO_VAR = '$W\VAR_TEMP$' AND CO_CONT = '$I\LT_PRCONT$'
1 0.0 Work 1 I 0 421, 481
  
1 0.0 LOC_TRANS LT_TRTARIFF I -1 291, 229
  $CALCULATE    'FORMAT TARIFF TO TWO DECIMAL PLACES  A:VAR;I\LT_TRTARIFF;I\LT_TRTARIFF;;#0.000  A:VAR;W\CM_CS_MIN_CHARGE;W\CM_CS_MIN_CHARGE;;#0.000  A:VAR;W\CM_CS_MAX_CHARGE;W\CM_CS_MAX_CHARGE;;#0.000    I:I\LT_TRTARIFF;=;    D:TARIFF IS INVALID;ERRORM;I\LT_TRTARIFF    I:I\MARKET;=;15  DO(15)    I:I\LT_TRTARIFF;=;0.00
1 0.0 LOC_TRANS LT_DEPNO I -1 291, 109
$SELECT  I:I\MARKET;<>;18  S:DEPOSIT_NO;I\LT_DEPNO;I\MARKET    I:I\MARKET;=;18  S:DEPOSIT_NO_DBN;I\LT_DEPNO;I\MARKET;I\BUYER    '''S:DEPOSIT_NO_1;I\LT_DEPNO;I\MARKET    $CALCULATE  '*****SIYA****20111111  A:DATE;DD MMM YYYY;I\ISSDATE  A:DATE;DD MMM YYYY;W\TODAY  A:TIME;HH:MM;I\ISDTIME  '*****SIYA****20111111    'A:CONS
1 0.0 Work 2 I 0 11, 349
  
1 0.0 Work 1 I 0 11, 373
  
1 0.0 Work 9 I 0 41, 253
  
1 0.0 Work 5 I 0 621, 301
  
1 0.0 Work 1 I 0 621, 517
  
1 0.0 Work 1 I 0 621, 325
  
1 0.0 Work 2 I 0 591, 325
  
1 0.0 Work 1 I 0 11, 277
  
1 0.0 Work 10 I 0 651, 157
  
1 0.0 Work 1 I -1 521, 157
  
1 0.0 LOC_TRANS LT_COMMENT I -1 291, 277
$CALCULATE    'CONVERT TO UPPERCASE  C:UCASE
1 0.0 Work 1 I -1 291, 85
$SELECT  S:DEBTOR_CODE;I\BUYER    $CALCULATE  M:  C:UCASE    'VALIDATE THE PREAMBLE  F:PREAMBLE_DEBTOR;;PDR_DEBTOR;I\TMP1=PDR_DEBTOR  I:I\MARKET;<>;14  DO(NOK)    I:I\MARKET;<>;21    DO(C98)      I:I\TMP1;=;      DO(PA)         I:I\PARM;<>;HEA        DO(VAV)          I:I\PARM;<>;HED          DO(VAK)            U:GET_BU
1 0.0 USERID I 0 101, 61
$DEFAULT  A:USERID;;I\USERID  
1 0.0 LOC_TRANS LT_PRQTY_AVAIL I -1 291, 349
$CALCULATE    'FIELD = LT_PRQTY  'IDENTIFIER = I\LT_PRQTY     'MANDATORY  M:    I:I\LT_PRQTY;=;0    D:DEPOSIT QTY MUST BE GREATER THAN ZERO.;ERRORM    I:W\CHG_TYPE;=;C  DO(001)    O:DISABLEINPUT;I\LT_PRCONT    A:VAR;I\LT_PRQTY;I\LT_CONT_CHG_QTY  DOEND(001)    I:W\CHG_TYPE;=;P    O:ENABLEINPUT;I\LT_PRCONT    
1 0.0 LOC_TRANS LT_CS_PRDTYPE I -1 491, 229
$SELECT  S:PERIOD_TYPE;I\LT_CS_PRDTYPE    $CALCULATE    'MANDATORY  M:    'CONVERT TO UPPERCASE  C:UCASE    'CHECK IF A VALID PERIOD IS ENTERED  F:PERIOD_TYPE;Y;;;PT_TYPE='$I\LT_CS_PRDTYPE$'
1 0.0 Work 2 I 0 21, 121
  
1 0.0 Work 12 I 0 651, 181
  
1 0.0 Work 8 I -1 291, 505
  
1 0.0 Work 5 I -1 291, 433
$VALIDATE    'ADDED THIS IF STATEMENT TO CATER FOR INVALID DEPOSIT BEING ENTERED   I:I\LT_DEBTOR;<>;  DO(999)      'MANDATORY  M:    I:I\ISSUE_QTY;>;I\LT_PRQTY_AVAIL;NUM    D:ISSUE QTY CAN'T BE GREATER THAN DEPOSIT QTY;ERRORM    I:I\ISSUE_QTY;=;0;NUM    DO(JRD)      D:ISSUE QTY MUST BE GREATER THAN ZERO;ERRORM;I\ISSUE_
1 0.0 Work 1 I 0 121, 61
  
1 0.0 I 0 291, 529
$VALIDATE    V:1;2;    I:I\LT_PAY_OPTION;=;    A:CONST;2;I\LT_PAY_OPTION
1 0.0 Work 2 I -1 291, 457
  
1 0.0 Work 1 I 0 191, 229
  
1 0.0 Work 2 I 0 11, 217
  
1 0.0 Work 1 I 0 11, 193
  
1 0.0 LOC_TRANS LT_PALL_QTY_AVAIL I -1 541, 409
  
1 0.0 Work 2 I 0 21, 145
  
1 0.0 Work 6 I 0 591, 301
  
1 0.0 Work 2 I -1 291, 301
$VALIDATE  I:I\ISSDATE;=;      A:DATE;DD MMM YYYY;I\ISSDATE  I:I\ISSDATE;<>;    DO(DATE)      A:DATEDIFF;W\TODAY;I\DATEDIFF;I\ISSDATE      I:I\DATEDIFF;<;0      D:ISSUE DATE CANNOT BE GREATER THAN TODAY'S DATE;ERRORM;I\ISSDATE      I:I\DATEDIFF;>;0     DO(CHK)      A:DATEDIFF;I\LT_DEP_DATE;I\DATEDIFF;I\ISSDATE     I:I\
1 0.0 Work 4 I -1 521, 301
$VALIDATE  I:I\MARKET;=;17  DO(17)    A:DATE;DD MMM YYYY HH:MM;W\CURRENT_DATE  A:CON;I\LT_DEP_DATE," ",I\LT_DEP_TIME;W\DEPOSIT_DATE_TIME        DO(TIME)  'CHECK THAT THE THIRD DIGIT IS A ":"  A:MID;I\ISDTIME,3,1;I\TMP1    I:I\TMP1;<>;:    D:ENTER TIME IN FORMAT XX:XX;ERRORM;I\ISDTIME    'CHECK THAT THE FIRST TWO DIGITS
1 0.0 IP I 0 81, 61
$DEFAULT  A:USERIP;;I\IP  
1 0.0 LOC_TRANS LT_LOCA I -1 291, 253
$SELECT  S:LOCATION_CS_CODES;I\LT_LOCA    $CALCULATE    'MANDATORY  M:    'CONVERT TO UPPERCASE  C:UCASE    'IF LOCATION IS BLANK, DISPLAY ERROR  I:I\LT_LOCA;=;    D:ROOM NO. CAN NOT BE BLANK.    'CHECK IF A VALID ROOM IS ENTERED AND GET CHARGE TYPE OF THE ROOM AND THE ROOM TYPE  F:LOCATION_MAST;Y;;W\LM_TYPE=LM_TYPE,W\
1 0.0 ORGS I 0 61, 61
$DEFAULT  A:ORGS;;I\ORGS  
1 0.0 MARKET I 0 41, 61
$DEFAULT    'LOAD MARKET CODE  A:ORG;;I\MARKET  I:I\MARKET;<>;17  O:HIDE;T\ISSDATE,I\ISSDATE,T\ISDTIME,I\ISDTIME    I:I\MARKET;<>;18  DO(NOT18)    O:HIDE;T\BUYER,I\BUYER,T\BUYER_NAME    O:SETFOCUS;I\LT_DEPNO  DOEND(NOT18)    'LOAD MARKET  NAME  F:CLIENT_MAST;;;T\MARKET=CM_NAME,I\RFID=CM_USE_RFID;CM_CODE='$I\MARKET$';  
1 0.0 Work 1 I 0 451, 109
  
1 0.0 LOC_TRANS LT_SECTION I -1 491, 253
$SELECT  S:ROOM_SECTION;I\LT_SECTION;I\LT_LOCA    $CALCULATE    'MANDATORY  M:    'CONVERT TO UPPERCASE  C:UCASE    'CHECK IF A VALID SECTION IS ENTERED  F:ROOM_DET;Y;;;RD_ROOM='$I\LT_LOCA$' AND RD_SECTION = '$I\LT_SECTION$'
1 0.0 LOC_TRANS LT_DEBTOR I -1 291, 133
  
1 0.0 Work 1 I 0 641, 409
  
1 0.0 CMD 1 C -1 411, 109
$SELECT  S:DEPOSIT_NO;I\LT_DEPNO;I\MARKET  '''S:DEPOSIT_NO_1;I\LT_DEPNO;I\MARKET
1 0.0 CMD 3 C -1 651, 545
$SELECT    'CHECK IF A VALID DEPOSIT IS ENTERED AND GET THE DEBTOR ON THE DEPOSIT   'F:LOC_TRANS;Y;;I\LT_DEBTOR=LT_DEBTOR;LT_DEPNO='$I\LT_DEPNO$' AND LT_MARKET='$I\MARKET$' ;I\LT_DEPNO   MT20110112   F:LOC_TRANS;Y;;I\LT_DEBTOR=LT_DEBTOR;LT_DEPNO='$I\LT_DEPNO$' AND LT_MARKET='$I\MARKET$' AND LT_DELIND <>'Y';I\LT_DEPNO  
1 0.0 Label 18 T -1 131, 409
  
1 0.0 Work 36 I -1 291, 409
$SELECT6    '''''''I:I\MARKET;<>;18  I:W\CHG_TYPE;<>;P    U:CS_OTHER_ISS_MAN;ISSUE_PALLETS    $VALIDATE  D:    'CALCULATE CHARGES IF CHARGE TYPE = P AND ISSUE QTY <> DEPOSIT QTY  '''''''I:I\MARKET;<>;18  I:W\CHG_TYPE;<>;P  DO(001)    I:W\CHG_TYPE;=;P      DO(001)      I:I\ISSUE_QTY;<>;I\LT_PRQTY;NUM        U:CS_OTHER_I
1 0.0 H -1 0, 0
  
1 0.0 Work 1 I -1 291, 157
  
1 0.0 Work 8 I 0 451, 373
  
1 0.0 Work 7 I 0 421, 373
  
1 0.0 Work 5 I 0 491, 373
  
1 0.0 Work 2 I 0 191, 253
  
1 0.0 Work 3 I -1 291, 373
$CALCULATE    'MANDATORY   M:    'CHECK IF ENTERED CHARGE PERIOD IS NOT GREATER THAN ORIGINALLY CALCULATED PERIOD   'I:I\LT_CHG_PRD;>;W\DAY_DIFF;NUM    ' D:CHARGE PERIOD CAN ($W\DAY_DIFF$) NOT BE GREATER THAN OVERWRITTEN VALUE ($W\DAY_DIFF$);ERRORM  
1 0.0 LOC_TRANS LT_DEP_TIME I -1 521, 325
$CALCULATE    'MANDATORY  M:    
1 0.0 Work 1 I -1 291, 481
  
1 0.0 Work 3 I 0 731, 253
  
1 0.0 Work 2 I 0 391, 481
  
1 0.0 Work 11 I 0 681, 157
  
1 0.0 Work 13 I 0 651, 205
  
1 0.0 DEFAULT I 0 11, 61
$DEFAULT    'INITIALIZES THE DATE AND TIME INTO THE T\DATE AND T\TIME FIELDS   A:DATE;DD MMM YYYY;T\DATE   A:DATE;DD MMM YYYY;I\TODAY   A:TIME;HH:MM:SS;T\TIME   A:TIMER_ON;1000    A:SETPWFIELD;I\BUYER    'PUTS PIC ON THE UPDATE BUTTON  O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\CREATE    $AFTER_READ  O:
1 0.0 LOC_TRANS LT_SHELF I -1 651, 253
$SELECT  S:ROOM_SHELVES;I\LT_SHELF;I\LT_LOCA;I\LT_SECTION    $CALCULATE    'MANDATORY  M:    'CHECK IF A VALID SHELF IS ENTERED  'F:ROOM_DET;Y;;;RD_ROOM='$I\LT_LOCA$' AND RD_SECTION = '$I\LT_SECTION$' AND RD_SHELVES = '$I\LT_SHELF$'    'PUT CURRENT DATE INTO THE DATE FIELD  A:DATE;DD MMM YYYY;I\LT_DEP_DATE  A:DATE;DD M
1 0.0 Label 2 T -1 401, 157
  
1 0.0 Label 2 T -1 131, 109
  
1 0.0 Label 11 T -1 401, 325
  
1 0.0 Label 2 T -1 131, 85
  
1 0.0 Label 1 T -1 131, 157
  
1 0.0 Label 1 T -1 131, 481
  
1 0.0 Label 10 T -1 131, 325
  
1 0.0 Label 3 T -1 331, 205
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 Label 3 T -1 271, 49
  
1 0.0 Label 6 T -1 621, 49
  
1 0.0 Label 23 T -1 131, 277
  
1 0.0 Label 9 T -1 131, 505
  
1 0.0 Label 6 T -1 131, 433
  
1 0.0 Label 5 T -1 671, 25
  
1 0.0 Label 14 T -1 531, 229
  
1 0.0 Label 4 T -1 621, 25
  
1 0.0 Label 1 T -1 1, 25
  
1 0.0 Label 3 T -1 131, 457
  
1 0.0 LOC_TRANS LT_PALL_QTY_AVAIL T -1 401, 409
  
1 0.0 Label 3 T 0 131, 529
  
1 0.0 Label 7 T -1 131, 253
  
1 0.0 Label 20 T -1 381, 229
  
1 0.0 Label 19 T -1 131, 229
  
1 0.0 Label 5 T 0 401, 517
  
1 0.0 Work 4 I 0 11, 253
  
1 0.0 LOC_TRANS LT_DEP_DATE I -1 291, 325
'$CALCULATE    '$VALIDATE    'MANDATORY  'M:    'GETS THE DATE DIFFERENCE BETWEEN CURRENT DATE AND DEPOSIT DATE  'A:DATEDIFF;I\LT_DEP_DATE;W\DAY_DIFF;W\CURRENT_DATE;;D    'GETS ABSOLUTE VALUE OF THE DATE DIFFERENCE  'A:ABS;W\DAY_DIFF;W\DAY_DIFF    'REMOVED FOLLOWING CHECK. RK200908. REASON? NONE GIVEN...  'IF DATE DIFF
1 0.0 Label 1 T -1 131, 301
  
1 0.0 Label 3 T -1 401, 301
  
1 0.0 Label 1 T -1 401, 85
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_EXIT Z 0 0, 0
  
10 0.0 ZX_UPDATE Z 0 0, 0
$BEFORE_WRITE    'CHECK IF A VALID DEPOSIT IS ENTERED AND GET THE DEBTOR ON THE DEPOSIT   F:LOC_TRANS;Y;;I\LT_DEBTOR=LT_DEBTOR;LT_DEPNO='$I\LT_DEPNO$' AND LT_MARKET='$I\MARKET$';I\LT_DEPNO    I:I\LT_DEBTOR;=;  DO(001)    D:INVALID DEPOSIT NO. ENTERED;ERRORM;I\LT_DEPNO    DOEND(001)      'CHECK IF SALES ARE PROHIBITED  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_PRINT Z 0 0, 0