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 |