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 |