Program drill-down
CHEP_DELS_MAN
CHEP PALLET DELIVERY MAINTENANCE. Type DSP, base table DEBTOR_MAST.
Field inventory
91
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | Work 6 | I | 0 | 121, 529 | ||
| 1 | 0.0 | Work 1 | I | 0 | 81, 529 | ||
| 1 | 0.0 | Work 4 | I | 0 | 161, 529 | ||
| 1 | 0.0 | Work 5 | I | 0 | 101, 529 | ||
| 1 | 0.0 | H | -1 | 1, 25 | |||
| 1 | 0.0 | DEFAULT | I | 0 | 1, 49 | $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:VAR;T\DATE;I\DATE;;YYYY/MM/DD U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\DELNO,I\PALL_QTY,I\FDELDATE,I\SUPP,I\SUPP_NAME,I\MSG A:CONST;+;I\SEQ; O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\ |
|
| 1 | 0.0 | IP | I | 0 | 91, 49 | $DEFAULT A:USERIP;;I\IP F:CASH_POINT;;;I\CASHPOINT=CPO_CASHPT;CPO_IP='$I\IP$' |
|
| 1 | 0.0 | Work 26 | G | -1 | 11, 313 | ||
| 1 | 0.0 | ORGS | I | 0 | 61, 49 | $DEFAULT A:ORGS;;I\ORGS |
|
| 1 | 0.0 | MARKET | I | 0 | 31, 49 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\MARKET A:ORGS;;I\ORGS 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME A:VAR;I\ORGS;I\AGENT I:I\ORGS;<>; DO(0) A:CONST;$I\ORGS$;I\AGENT O:DISABLEINPUT;I\AGENT F:AGENT_MAST;;;T\AGENT_NAME=AM_NAME;AM_CODE='$I\ORGS$'; DOEND(0) I:I\ORGS;=; DO(1) O |
|
| 1 | 0.0 | I | -1 | 121, 193 | |||
| 1 | 0.0 | Work 1 | I | 0 | 371, 481 | ||
| 1 | 0.0 | Work 2 | I | 0 | 271, 481 | ||
| 1 | 0.0 | Work 1 | I | 0 | 521, 481 | ||
| 1 | 0.0 | I | -1 | 121, 157 | |||
| 1 | 0.0 | Work 1 | I | 0 | 411, 157 | ||
| 1 | 0.0 | Work 1 | I | -1 | 161, 289 | ||
| 1 | 0.0 | I | -1 | 121, 121 | $SELECT S:CONS;I\CONSIGN;I\MARKET;I\ORGS $VALIDATE M: F:PALL_DETS;Y;;I\TDELDATE=PD_DATE,I\PALL_CODE=PD_PALL,I\PALL_AGN=PD_AGENT;PD_MARKET = '$I\MARKET$' AND PD_CONSIGN = '$I\CONSIGN$';I\CONSIGN I:I\AGENT;<>;I\PALL_AGN D:THE ENTERED CONSIGNMENT IS NOT FOR THE AGENT LOGGED ON!!!;ERRORM;I\CONSIGN F:PALL_MAST; |
||
| 1 | 0.0 | I | -1 | 261, 289 | $VALIDATE M: O:SETFOCUS;I\MSG |
||
| 1 | 0.0 | I | -1 | 361, 289 | |||
| 1 | 0.0 | I | -1 | 461, 289 | |||
| 1 | 0.0 | Work 1 | I | 0 | 141, 457 | ||
| 1 | 0.0 | I | 0 | 361, 553 | |||
| 1 | 0.0 | Work 7 | I | 0 | 141, 529 | ||
| 1 | 0.0 | Work 29 | I | 0 | 81, 553 | ||
| 1 | 0.0 | Work 30 | I | 0 | 61, 553 | ||
| 1 | 0.0 | Work 31 | I | 0 | 61, 577 | ||
| 1 | 0.0 | Work 32 | I | 0 | 41, 553 | ||
| 1 | 0.0 | Work 33 | I | 0 | 41, 577 | ||
| 1 | 0.0 | Work 36 | I | 0 | 301, 577 | ||
| 1 | 0.0 | Work 37 | I | 0 | 321, 577 | ||
| 1 | 0.0 | Work 38 | I | 0 | 341, 577 | ||
| 1 | 0.0 | Work 39 | I | 0 | 241, 577 | ||
| 1 | 0.0 | Work 40 | I | 0 | 261, 577 | ||
| 1 | 0.0 | Work 41 | I | 0 | 281, 577 | ||
| 1 | 0.0 | Work 4 | I | 0 | 241, 553 | ||
| 1 | 0.0 | Work 5 | I | 0 | 261, 553 | ||
| 1 | 0.0 | CR_LIM | I | 0 | 101, 553 | ||
| 1 | 0.0 | OSBAL | I | 0 | 121, 553 | ||
| 1 | 0.0 | Work 1 | I | 0 | 121, 49 | $DEFAULT A:USERID;;I\USERID U:MENU_GROUP;LOOKUP |
|
| 1 | 0.0 | DEBTOR_MAST | DM_ACCTYPE | I | 0 | 141, 553 | |
| 1 | 0.0 | Work 4 | I | 0 | 181, 553 | ||
| 1 | 0.0 | Work 5 | I | 0 | 161, 553 | ||
| 1 | 0.0 | Work 1 | I | 0 | 381, 553 | ||
| 1 | 0.0 | Work 2 | I | 0 | 341, 553 | ||
| 1 | 0.0 | Label 1 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 2 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 3 | T | -1 | 291, 49 | ||
| 1 | 0.0 | Label 4 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 5 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 6 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 7 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 13 | T | -1 | 11, 157 | ||
| 1 | 0.0 | Label 15 | T | -1 | 11, 193 | ||
| 1 | 0.0 | Label 17 | T | -1 | 181, 193 | ||
| 1 | 0.0 | Label 19 | T | -1 | 181, 157 | ||
| 1 | 0.0 | Label 38 | T | -1 | 11, 265 | ||
| 1 | 0.0 | Label 39 | T | -1 | 61, 265 | ||
| 1 | 0.0 | Label 40 | T | -1 | 11, 121 | ||
| 1 | 0.0 | Label 41 | T | -1 | 261, 241 | ||
| 1 | 0.0 | Label 42 | T | -1 | 361, 265 | ||
| 1 | 0.0 | Label 43 | T | -1 | 261, 265 | ||
| 1 | 0.0 | Label 44 | T | -1 | 461, 265 | ||
| 1 | 0.0 | CMD 1 | C | -1 | 651, 547 | $SELECT U:CHEP_DELIVEIES;ADD_TO_CONSIGMENT;G\GRID,I\SEQ U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\DELNO,I\PALL_QTY,I\FDELDATE,I\SUPP,I\SUPP_NAME,I\MSG I:I\ORGS;<>; DO(0) A:CONST;;I\SMAN,T\SMAN_NAME,I\PALL_CODE,T\PALL_DESC,I\TDELDATE,I\FDELDATE,I\CONSIGN,I\TMP1,I\TMP2 O:SETFOCUS;I\CONSIGN DOEND(0) I:I\ |
|
| 1 | 0.0 | Label 50 | T | -1 | 761, 265 | ||
| 1 | 0.0 | Label 54 | T | 0 | 301, 553 | ||
| 1 | 0.0 | Label 27 | T | -1 | 11, 85 | ||
| 1 | 0.0 | Label 34 | T | -1 | 321, 121 | ||
| 1 | 0.0 | Label 35 | T | -1 | 181, 85 | ||
| 1 | 0.0 | Label 42 | T | 0 | 201, 577 | ||
| 1 | 0.0 | Label 1 | T | 0 | 201, 553 | ||
| 1 | 0.0 | Work 2 | I | -1 | 411, 121 | ||
| 1 | 0.0 | Work 1 | I | -1 | 121, 85 | $VALIDATE U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\DELNO,I\PALL_QTY,I\FDELDATE,I\SUPP,I\SUPP_NAME,I\MSG A:CONST;+;I\SEQ; C:UCASE M: F:AGENT_MAST;Y;;T\AGENT_NAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT |
|
| 1 | 0.0 | Work 1 | I | 0 | 541, 181 | ||
| 1 | 0.0 | Work 1 | I | 0 | 41, 481 | ||
| 1 | 0.0 | Work 2 | I | 0 | 41, 505 | ||
| 1 | 0.0 | Work 1 | I | 0 | 41, 457 | ||
| 1 | 0.0 | Work 1 | I | 0 | 431, 481 | ||
| 1 | 0.0 | Work 2 | I | 0 | 461, 481 | ||
| 1 | 0.0 | Work 1 | I | 0 | 401, 481 | ||
| 1 | 0.0 | Work 1 | I | 0 | 141, 481 | ||
| 1 | 0.0 | Work 1 | I | 0 | 491, 481 | ||
| 1 | 0.0 | Label 1 | T | -1 | 161, 265 | ||
| 1 | 1.0 | LINE | I | -1 | 11, 289 | $SELECT S:G:G\GRID:R1;I\SEQ $SELECT6 S:G:G\GRID:F1;I\SEQ $CALCULATE I:I\SEQ;=; DO(SFD) O:DISABLEINPUT;I\DELNO,I\FDELDATE,I\PALL_QTY,I\SUPP,I\SUPP_NAME,I\MSG O:SETFOCUS;C\UPDATE O:BACKCOLOR;C\UPDATE;YELLOW DOEND(SFD) I:I\SEQ;<>; DO(002) I:I\SEQ;=;+ DO(004) A:CONST;;I\SEQ O:ENABLE |
|
| 1 | 1.0 | I | -1 | 61, 289 | $CALCULATE F:AUD_PALL_DETS;;;I\TMP1=SUM(APD_RECQTY);APD_MARKET='$I\MARKET$' AND LEFT(APD_CONSIGN,6)='$I\DELNO$' AND APD_PALL='$I\PALL_CODE$' AND APD_AUD_DATE = '$I\DATE$' AND APD_AUD_TYPE = 'INS' GROUP BY APD_MARKET,LEFT(APD_CONSIGN,6),APD_AUD_DATE,APD_AUD_TYPE; F:AUD_PALL_DETS;;;I\TMP2=SUM(APD_RECQTY);APD_MARKET=' |
||
| 1 | 1.0 | MSG | I | -1 | 761, 289 | $CALCULATE C:UCASE V:Y;N; I:I\MSG;=; A:CONST;N;I\MSG U:ZZGRID_SPLIT;SCREEN_TO_GRID;G\GRID;I\SEQ A:CONST;;I\DELNO,I\PALL_QTY,I\SUPP,I\SUPP_NAME,I\FDELDATE,I\TMP_SMAN,I\MSG A:CONST;+;I\SEQ O:SETFOCUS;I\SEQ |
|
| 10 | 0.0 | ZX_PRINT | Z | 0 | 1, 25 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 1, 25 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 1, 25 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 1, 25 | $ESC U:BUYER_RESERVATION_GRID_PRETORIA;UNFLAG_CARD $UPDATE ''================================== ''TO CHECK FOR LOCKS (JD 2010-11-15) U:ZZGRID_VALIDATE;INIT_GRID;G\GRID ''TO CHECK FOR LOCKS (JD 2010-11-15) ''================================== 'I:I\PMT_METH;<>; 'DO(SCR) ' I:I\PMT_METH;=;CA ' DO(CA) ' |
|
| 10 | 0.0 | ZX_EXIT | Z | 0 | 1, 25 |