Freshmark replication server

freshmark-canonical

Program drill-down

CS_OTHER_DEP_MAN

COLD STORAGE OTHER DEPOSITS MAINT L/R. Type UPD, base table DEBTOR_MAST.

Field inventory

73

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Work I 0 491, 157
  
1 0.0 Label 2 T -1 81, 169
  
1 0.0 LOC_TRANS LT_SECTION I -1 251, 217
$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$';I\LT_SECTION
1 0.0 LOC_TRANS LT_SHELF I -1 281, 217
$SELECT  'S:ROOM_SHELVES;I\LT_SHELF;I\LT_LOCA;I\LT_SECTION  S:ROOM_SHELVES2;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$';I\LT_SHELF    'PUT CURRENT DATE IN
1 0.0 Work 36 I -1 501, 217
$SELECT6  I:I\LT_DEPNO;=;*****  DO(001)    U:CS_OTHER_DEP_MAN;PALLET_ENTRY  DOEND(001)    $CALCULATE    U:CS_OTHER_DEP_MANO;SEARCH_FOR_STRING  I:I\PALLET;<>;    DO(001)      I:I\RESULT;<>;Y        D:PRESS F6 TO DEPOSIT NEW PALLETS, ENTER TO EDIT OR LEAVE BLANK;ERRORM    DOEND(001)    ^I:I\LT_TRANS;<>;  ^DO(001)  ^  I:I
1 0.0 LT_PRCONT I -1 181, 217
$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$';I\LT_PRCONT
1 0.0 Label 1 T 0 11, 169
  
1 0.0 USERID I 0 101, 61
$DEFAULT  A:USERID;;I\USERID  
1 0.0 CMD 44 C -1 261, 109
$SELECT  'S:DEBTOR;I\DM_DEBTOR  S:DEBTOR_TRANS;I\DM_DEBTOR;I\MARKET
1 0.0 LT_ITEM I -1 121, 217
$SELECT    'GETS PRODUCTZ  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 VALI
1 0.0 LOC_TRANS LT_DEPNO I -1 81, 217
  
1 0.0 LOC_TRANS LT_TRANS I -1 11, 217
$SELECT  S:G:G\GRID:R1    $CALCULATE    'IF <> + GET RECORD FROM THE GRID  I:I\LT_TRANS;<>;+    DO(001)      'I:I\LT_DEPNO;=;*****         'U:ZZGRID_SPLIT;GRID_TO_SCREEN;G\GRID;I\LT_TRANS        U:ZZGRID_SPLIT;GRID_TO_SCREEN;G\GRID;I\LT_TRANS      A:CONST;*****;I\LT_DEPNO    DOEND(001)      'IF NOT EMPTY, CHECK IF VALI
1 0.0 DEBTOR_MAST DM_DEBTOR T -1 11, 109
  
1 0.0 Work 40 I -1 761, 217
$CALCULATE    'CONVERT TO UPPERCASE  C:UCASE    'ONLY THE Y, X OR BLANK ARE ACCEPTED VALUES FOR THIS FIELD  V:Y;X;    'IF "Y" IS ENTERED, PUT DATA INTO THE GRID, CLEAR GRID FIELDS.  'I:W\DEL;=;Y  I:W\DEL;=;$$$    DO(001)      'PUT DATA INTO GRID FROM FIELDS      U:ZZGRID_SPLIT;SCREEN_TO_GRID;G\GRID;I\LT_TRANS        'C
1 0.0 Label 18 T -1 501, 193
  
1 0.0 Label 15 T -1 441, 193
  
1 0.0 LOC_TRANS LT_LOCA I -1 211, 217
$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.;ERRORM;I\LT_LOCA    'CHECK IF A VALID ROOM IS ENTERED AND GET CHARGE TYPE OF THE ROOM AND THE ROOM TYPE  'F:LOCATION_MAST;Y;;W\
1 0.0 Label 11 T 0 371, 193
  
1 0.0 Label 10 T -1 321, 193
  
1 0.0 Label 19 T -1 551, 193
  
1 0.0 Label 20 T -1 611, 193
  
1 0.0 Label 21 T -1 761, 193
  
1 0.0 Label 4 T -1 121, 193
  
1 0.0 Label 9 T -1 281, 193
  
1 0.0 Label 6 T -1 221, 193
  
1 0.0 Label 14 T -1 441, 169
  
1 0.0 Label 8 T -1 251, 193
  
1 0.0 Label 7 T -1 221, 169
  
1 0.0 Label 5 T -1 181, 193
  
1 0.0 DEBTOR_MAST DM_DEBTOR I -1 161, 109
$SELECT  'S:DEBTOR;I\DM_DEBTOR  S:DEBTOR_TRANS;I\DM_DEBTOR;I\MARKET    $CALCULATE    'INITIALIZES THE GRID WITH ITS COLUMNS MATCHING THE FIELDS ALONG THE TOP OF IT  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\LT_TRANS,I\PALLET_MULTIVALUES:H,I\LT_DEPNO,I\LT_ITEM,I\LT_PRCONT,I\LT_LOCA,I\LT_SECTION,I\LT_SHELF,I\LT_DEP_DATE,I\LT_DEP
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:TIME;HH:MM:SS;T\TIME  'A:TIMER_ON;1000    'INITIALIZES THE GRID WITH ITS COLUMNS MATCHING THE FIELDS ALONG THE TOP OF IT  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\LT_TRANS,I\PALLET_MULTIVALUES:H,I\LT_DEPNO,I\LT_ITEM,I\LT_P
1 0.0 Label 1 T -1 301, 109
  
1 0.0 Label 1 T -1 11, 193
  
1 0.0 Label 23 T -1 651, 193
  
1 0.0 Label 5 T -1 671, 25
  
1 0.0 Label 4 T -1 621, 25
  
1 0.0 Work 1 G -1 11, 241
  
1 0.0 Label 1 T -1 1, 25
  
1 0.0 H -1 0, 0
  
1 0.0 LOC_TRANS LT_DEP_DATE I -1 321, 217
'$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    'IF DATE DIFFERENCE IS NOT WITHIN 14 DAYS OF THE CURRENT DATE, DISPLAY ERROR
1 0.0 LOC_TRANS LT_DEP_TIME I 0 371, 205
$CALCULATE    'MANDATORY  M:    I:I\CM_SRT_CLR_UPDSALES;<>;  DO  'CHECK THAT THE THIRD DIGIT IS A :  A:MID;I\CM_SRT_CLR_UPDSALES,3,1;I\TMP26  I:I\TMP26;<>;:  D:ENTER IN FORMAT XX:XX;ERRORM;I\CM_SRT_CLR_UPDSALES    'CHECK THAT THE FIRST TWO DIGITS ARE BETWEEN 00 AND 24  A:LEFT;I\CM_SRT_CLR_UPDSALES,2;I\TMP26  I:I\TMP26;
1 0.0 Label 1 T 0 251, 169
  
1 0.0 ORGS I 0 61, 61
$DEFAULT  A:ORGS;;I\ORGS  
1 0.0 MARKET I 0 41, 61
'TO LOAD MARKET NAME  $DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MARKET    
1 0.0 LOC_TRANS LT_TRTARIFF I -1 551, 217
$CALCULATE    'MANDATORY  M:    'GET MIN & MAX COLD STORAGE CHARGES  F:CLIENT_MAST;Y;;W\CM_CS_MIN_CHARGE=CM_CS_MIN_CHARGE,W\CM_CS_MAX_CHARGE=CM_CS_MAX_CHARGE;CM_CODE='$I\MARKET$';I\LT_TRTARIFF    'FORMAT TARIFF TO TWO DECIMAL PLACES  A:VAR;I\LT_TRTARIFF;I\LT_TRTARIFF;;#0.000    'FORMAT TARIFF TO TWO DECIMAL PLACES  A:V
1 0.0 LOC_TRANS LT_CS_PRDTYPE I 0 611, 169
$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 Label 3 T -1 261, 49
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 LOC_TRANS LT_COMMENT I -1 651, 217
$CALCULATE    'CONVERT TO UPPERCASE  C:UCASE
1 0.0 IP I 0 81, 61
$DEFAULT  A:USERIP;;I\IP  
1 0.0 LOC_TRANS LT_PRQTY I -1 441, 217
$CALCULATE    'MANDATORY  M:    I:I\LT_PRQTY;=;0;NUM    D:DEPOSIT QTY MUST BE GREATER THAN ZERO.;ERRORM;I\LT_PRQTY    I:I\LT_PRQTY;>;I\AVAIL_QTY;NUM    D:DEPOSIT QTY CAN NOT BE GREATER THAN AVAIL.;ERRORM;I\LT_PRQTY    'I:W\CHG_TYPE;=;C  'DO(001)  '  O:DISABLEINPUT;I\LT_PRCONT  '  A:VAR;I\LT_PRQTY;I\LT_CONT_CHG_QTY  'DO
1 0.0 Label 6 T -1 621, 49
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 Work 1 I 0 141, 145
  
1 0.0 Label 3 T -1 81, 193
  
1 0.0 Work 1 I 0 341, 157
  
1 0.0 Work 1 I 0 401, 157
  
1 0.0 Work 1 I 0 211, 145
  
1 0.0 Work 2 I 0 111, 145
  
1 0.0 Work 1 I 0 181, 145
  
1 0.0 Work 1 I 0 491, 133
  
1 0.0 LOC_TRANS LT_CS_PRDTYPE D -1 611, 217
$DEFAULT    B:ADDITEM;I\LT_CS_PRDTYPE;H,D,W,M,Y    $CALCULATE    C:UCASE  B:VALIDATE;I\LT_CS_PRDTYPE;H,D,W,M,Y
1 0.0 Label 3 T -1 401, 193
  
1 0.0 Work 1 I 0 641, 97
  
1 0.0 Work 3 I 0 371, 157
  
1 0.0 Work 2 I 0 431, 157
  
1 0.0 Work 3 I 0 431, 133
  
1 0.0 Work 2 I -1 401, 217
  
10 0.0 ZX_PRINT Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_UPDATE Z 0 0, 0
$BEFORE_WRITE  U:CS_OTHER_DEP_MANTENANCE;CS_OTHER_DEP_MAN_SAVE_DATA
10 0.0 ZX_EXIT Z 0 0, 0
  
10 0.0 ZX_DELETE Z 0 0, 0