Freshmark replication server

freshmark-canonical

Program drill-down

CS_OTHER_DEP_MANO

COLD STORAGE OTHER DEPOSITS MAINTENANCE. Type DSP, base table DEBTOR_MAST.

Field inventory

94

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 51, 169
  
1 0.0 LOC_TRANS LT_SECTION I -1 221, 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 251, 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 INTO
1 0.0 Work 36 I -1 481, 217
  $SELECT6    ''''''I:I\MARKET;<>;18  I:W\CHG_TYPE;<>;P  DO(DURBS)    I:I\LT_DEPNO;=;*****    DO(001)      U:CS_OTHER_DEP_MANO;PALLET_ENTRY    DOEND(001)  DOEND(DURBS)    $CALCULATE      ''''''I:I\MARKET;<>;18  I:W\CHG_TYPE;<>;P  DO(DURBS)  U:CS_OTHER_DEP_MANO;SEARCH_FOR_STRING    I:I\PALLET;<>;    DO(001)      I:I\RES
1 0.0 LT_PRCONT I -1 151, 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 USERID I 0 101, 61
$DEFAULT  A:USERID;;I\USERID  
1 0.0 Label 9 T -1 251, 193
  
1 0.0 LOC_TRANS LT_DEPNO I -1 51, 217
  
1 0.0 LOC_TRANS LT_TRANS I -1 11, 217
$CALCULATE    'IF IS NOT EQUAL TO A "+" 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    DOEND(001)      'IF EMPTY SET FOCUS TO UPDATE BUTTON  I:I\LT_TRANS;=;  DO(001)    '''''''O:DISABLEINPUT;I\LT_TRANS,I\PALLET_MULTIVALUES:H,I\
1 0.0 DEBTOR_MAST DM_DEBTOR T -1 11, 97
  
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 BLANK, PUT DATA INTO THE GRID, CLEAR GRID FIELDS.  I:W\DEL;=;    DO(001)      'PUT DATA INTO GRID FROM FIELDS      U:ZZGRID_SPLIT;SCREEN_TO_GRID;G\GRID;I\LT_TRANS        'CLEAR OUT GRID SCREEN F
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;YYYY/MM/DD;I\DEPDATEME  A:TIME;HH:MM:SS;T\TIME  'A:TIMER_ON;1000    A:CONST;N;I\EXT_DP      'INITIALIZES THE GRID WITH ITS COLUMNS MATCHING THE FIELDS ALONG THE TOP OF IT  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\LT_T
1 0.0 Label 1 T -1 301, 97
  
1 0.0 Label 1 T -1 11, 193
  
1 0.0 Label 23 T -1 631, 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 291, 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 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;I\OWN_CR=CM_OWN_ROOMS,T\MARKET=CM_NAME,I\RFID=CM_USE_RFID;    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MARKET    I:I\MARKET;<>;11  DO(M)  O:DISABLEINPUT;I\LT_TRTARIFF  DOEND(M)  
1 0.0 Label 1 T 0 221, 169
  
1 0.0 ORGS I 0 61, 61
$DEFAULT  A:ORGS;;I\ORGS  
1 0.0 Label 18 T -1 481, 193
  
1 0.0 Label 15 T -1 411, 193
  
1 0.0 LOC_TRANS LT_LOCA I -1 181, 217
$SELECT  '''S:LOCATION_CS_CODES;I\LT_LOCA    I:I\ORGS;=;  DO(AVA)    I:I\OWN_CR;=;Y    S:LOCATION_CS_CODES1;I\LT_LOCA        I:I\OWN_CR;=;N    S:LOCATION_CS_CODES;I\LT_LOCA  DOEND(AVA)    I:I\ORGS;<>;  DO(AJA)    I:I\OWN_CR;=;Y    S:LOCATION_CS_CODES2;I\LT_LOCA;I\ORGS        I:I\OWN_CR;=;N    S:LOCATION_CS_CODES;I\LT_L
1 0.0 Label 11 T -1 371, 193
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 LOC_TRANS LT_COMMENT I -1 631, 217
$CALCULATE    'CONVERT TO UPPERCASE  C:UCASE  
1 0.0 LOC_TRANS LT_CS_PRDTYPE I 0 611, 193
$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 IP I 0 81, 61
$DEFAULT  A:USERIP;;I\IP  
1 0.0 Work 1 I 0 11, 529
  
1 0.0 CMD 1 C -1 641, 549
$ESC  O:SETFOCUS;I\PRT_LABELS    $SELECT  A:DATE;YYYY/MM/DD;I\DEPDATEME    I:I\DM_DEBTOR;=;  D:DEPOSITOR CODE IS MANDATORY;ERRORM;I\DM_DEBTOR    U:CS_OTHER_DEP_MANTENANCEO;CS_OTHER_DEP_MANO_SAVE_DATA    I:I\MARKET;=;15  DO(15)    O:DISABLEINPUT;C\UPDATE    O:ENABLEINPUT;I\PRT_LABELS,I\NUMB_LABELS    O:SETFOCUS;I\PRT_LA
1 0.0 Work 1 I -1 151, 505
$ESC  A:CONST;;I\PRT_LABELS,I\NUMB_LABELS,T\DM_NAME  O:SETFOCUS;I\DM_DEBTOR  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_TIME,I\LT_PRQTY,I\PALLET,I\LT_TRTARIFF,I\LT_CS_PRDTYPE,I\LT_COMMENT,W\DEL    $VALIDATE 
1 0.0 Work 1 I 0 181, 61
  
1 0.0 LOC_TRANS LT_PRQTY I -1 411, 217
$CALCULATE    'MANDATORY  M:    I:I\LT_PRQTY;=;0;NUM    D:DEPOSIT QTY MUST BE GREATER THAN ZERO.;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  'DOEND(001)    'I:W\CHG_TYPE;=;P  '  O:ENABLEINPUT;I\LT_PRCONT
1 0.0 Label 3 T -1 51, 193
  
1 0.0 Label 10 T -1 291, 193
  
1 0.0 Label 19 T -1 531, 193
  
1 0.0 Work 1 I 0 341, 157
  
1 0.0 Label 6 T -1 191, 193
  
1 0.0 Label 14 T -1 411, 169
  
1 0.0 Label 8 T -1 221, 193
  
1 0.0 Label 7 T -1 191, 169
  
1 0.0 Work 1 I 0 281, 133
  
1 0.0 Work 1 I 0 491, 133
  
1 0.0 LOC_TRANS LT_CS_PRDTYPE D -1 591, 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 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 Label 6 T -1 621, 49
  
1 0.0 LOC_TRANS LT_DEP_TIME I -1 371, 217
$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 DEBTOR_MAST DM_DEBTOR I -1 161, 97
$SELECT  'S:DEBTOR;I\DM_DEBTOR  S:DEBTOR;I\DM_DEBTOR    $CALCULATE  O:ENABLEINPUT;C\UPDATE  O:DISABLEINPUT;I\PRT_LABELS,I\NUMB_LABELS  A:CONST;;T\DM_NAME    'CHECK IF SALES ARE PROHIBITED  F:CLIENT_MAST;Y;;I\CM_PROHIBIT_SALES=CM_PROHIBIT_SALES;CM_CODE='$I\MARKET$';I\DM_DEBTOR    I:I\CM_PROHIBIT_SALES;=;Y  DO(001)    O:
1 0.0 CMD 44 C -1 261, 97
$SELECT  'S:DEBTOR;I\DM_DEBTOR  S:DEBTOR;I\DM_DEBTOR
1 0.0 LT_ITEM I -1 111, 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 Label 21 T -1 761, 193
  
1 0.0 Work 1 I 0 261, 133
  
1 0.0 LOC_TRANS LT_TRTARIFF I -1 531, 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 Work 2 I 0 251, 133
  
1 0.0 Label 3 T -1 261, 49
  
1 0.0 Label 5 T -1 151, 193
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 Label 20 T -1 591, 193
  
1 0.0 Work 1 I 0 401, 133
  
1 0.0 Work 1 I 0 301, 133
  
1 0.0 Label 4 T -1 111, 193
  
1 0.0 Work 3 I 0 491, 85
  
1 0.0 Work 3 I 0 611, 85
  
1 0.0 Work 1 I 0 141, 61
  
1 0.0 Work 2 I -1 611, 505
$VALIDATE  I:I\NUMB_LABELS;=;0  D:ENTER A VALID NUMBER OF COPIES TO PRINT;ERRORM;I\NUMB_LABELS    I:I\NUMB_LABELS;=;  D:ENTER NUMBER OF COPIES TO PRINT;ERRORM;I\NUMB_LABELS    O:SETFOCUS;C\PRT_LABEL  O:BACKCOLOR;C\PRT_LABEL;YELLOW
1 0.0 Label 3 T -1 11, 505
  
1 0.0 Label 4 T -1 491, 505
  
1 0.0 Work 1 I 0 21, 529
  
1 0.0 CMD 2 C -1 551, 553
$SELECT    F:LOC_TRANS;;;I\TRANS_NO=MAX(LT_TRANS);LT_TYPE='DP' AND LT_DEBTOR='$I\DM_DEBTOR$';I\TRANS_NO    U:CS_DEPOSIT_LABELS;OTHER_DEP_GRID    A:CONST;;I\PRT_LABELS,I\NUMB_LABELS,T\DM_NAME,I\DM_DEBTOR,I\TRANS_NO,I\DEPDATEME  O:DISABLEINPUT;I\PRT_LABELS,I\NUMB_LABELS  O:SETFOCUS;I\DM_DEBTOR  U:ZZGRID_SPLIT;INIT_GRID;G
1 0.0 Work 3 I 0 11, 529
  
1 0.0 BLK I 0 221, 61
  
1 0.0 Work 2 I 0 671, 85
  
1 0.0 Work 4 I 0 61, 529
  
1 0.0 Work 5 I 0 91, 529
  
1 0.0 Work 6 I 0 91, 529
  
1 0.0 Work 1 I 0 641, 85
  
1 0.0 Work 7 I 0 91, 529
  
1 0.0 Work 8 I 0 91, 529
  
1 0.0 Work 9 I 0 91, 529
  
1 0.0 Work 1 I -1 161, 133
$VALIDATE  C:UCASE  V:Y;N
1 0.0 Work 3 I 0 91, 529
  
1 0.0 Label 2 T -1 11, 133
  
10 0.0 ZX_PRINT Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_UPDATE Z -1 0, 0
$ESC  O:SETFOCUS;I\PRT_LABELS    $BEFORE_WRITE  U:CS_OTHER_DEP_MANTENANCEO;CS_OTHER_DEP_MANO_SAVE_DATA    A:CONST;;I\PRT_LABELS,I\NUMB_LABELS
10 0.0 ZX_EXIT Z 0 0, 0
  
10 0.0 ZX_DELETE Z 0 0, 0