Program drill-down
CUM_PALL_BALANCES
PALLET POOL CUMULATIVE PALLET BALANCES. Type DSP, base table TROLLEY_MAST.
Field inventory
38
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | Work 4 | I | 0 | 101, 85 | ||
| 1 | 0.0 | Work 3 | I | 0 | 31, 133 | ||
| 1 | 0.0 | MARKET | I | 0 | 31, 85 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\MARKET 'A:ORGS;;I\ORGS 'A:CONST;$I\ORGS$;I\AGENT 'A:ORGS;;I\AGENT 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME 'CONVERT ONLY THE FIRST CHARACTER OF THE MARKET LABEL C:MCASE;;T\MARKET A:DATE;DD MMM YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME A:TIMER_ON;100 |
|
| 1 | 0.0 | Label 2 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 9 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 8 | T | -1 | 671, 49 | ||
| 1 | 0.0 | DATE | I | -1 | 361, 265 | $DEFAULT A:DATE;DD MMM YYYY;I\DATE_D A:DATE;DD MMM YYYY;I\TO_DATE $VALIDATE I:I\DATE_D;=; A:CONST;$T\DATE$;I\DATE_D A:CONST;$I\DATE_D$;I\TO_DATE 'I:I\DATE_D;<>; ' DO(FDTE) ' O:SETFOCUS;I\TO_DATE ' DOEND(FDTE) |
|
| 1 | 0.0 | Label 3 | T | -1 | 231, 49 | ||
| 1 | 0.0 | Label 2 | T | -1 | 231, 265 | ||
| 1 | 0.0 | Label 5 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 6 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 7 | T | -1 | 621, 49 | ||
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | CMD 1 | C | -1 | 361, 361 | $SCMD_FOCUS O:BACKCOLOR;C\RUN;YELLOW $SELECT I:I\DATE_D;=; A:CONST;$T\DATE$;I\DATE_D I:I\TO_DATE;=; A:CONST;$T\DATE$;I\TO_DATE '/PRINT=PRINT_POOL_CUMULATIVE_BALANCES;11,,07 APR 2011,12 APR 2011,,,S /IC:\LEGEND\PROJ_FMS\INI\LAZOLA\FMS.INI E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_POOL_CUMU |
|
| 1 | 0.0 | Label 1 | T | -1 | 231, 301 | ||
| 1 | 0.0 | Work 2 | I | -1 | 361, 301 | $VALIDATE I:I\TO_DATE;=; A:CONST;$T\DATE$;I\TO_DATE A:DATEDIFF;I\TO_DATE;I\DATEDIFF;I\DATE_D I:I\DATEDIFF;<;0 D:TO DATE CANNOT BE LESS THAN FROM DATE;ERRORM;I\TO_DATE O:SETFOCUS;C\RUN O:BACKCOLOR;C\RUN;YELLOW |
|
| 1 | 0.0 | Work 4 | I | 0 | 501, 445 | ||
| 1 | 0.0 | Work 5 | I | 0 | 401, 421 | ||
| 1 | 0.0 | Work 6 | I | 0 | 501, 469 | ||
| 1 | 0.0 | Work 7 | I | 0 | 401, 445 | ||
| 1 | 0.0 | Work 8 | I | 0 | 401, 469 | ||
| 1 | 0.0 | Label 12 | T | -1 | 491, 229 | ||
| 1 | 0.0 | CMD 7 | C | -1 | 461, 157 | $SELECT S:AGN_CODE;I\AGENT |
|
| 1 | 0.0 | Label 6 | T | -1 | 231, 157 | ||
| 1 | 0.0 | Work 1 | I | -1 | 361, 157 | $DEFAULT A:ORGS;;I\ORGS A:CONST;$I\ORGS$;I\AGENT I:I\ORGS;<>; DO(03) O:DISABLEINPUT;I\AGENT,C\AGENT O:SETFOCUS;I\SECTION F:AGENT_MAST;;;T\NAME=AM_NAME;AM_CODE='$I\ORGS$' DOEND(03) $SELECT S:AGN_CODE;I\AGENT $VALIDATE 'M: C:UCASE I:I\AGENT;<>; F:AGENT_MAST;Y;;T\NAME=AM_NAME;AM_CODE='$I\AGENT$ |
|
| 1 | 0.0 | Work 2 | I | -1 | 361, 193 | $SELECT I:I\AGENT;<>; S:POLL_SECT;I\SECTION;I\AGENT I:I\AGENT;=; S:SECT_MAST2;I\SECTION $VALIDATE A:CONST;;T\SE_DESC C:UCASE I:I\AGENT;<>; DO(AGN) I:I\SECTION;<>; F:PALL_POOL;Y;;PL_SECT;PL_OWNER='$I\AGENT$' AND PL_SECT='$I\SECTION$';I\SECTION DOEND(AGN) I:I\AGENT;=; DO(MKT) I:I\SECTION;<>; |
|
| 1 | 0.0 | Work 3 | I | -1 | 361, 229 | $SELECT S:PALLET_CODE3;I\PALLET $VALIDATE A:CONST;;T\SE_DESC C:UCASE I:I\PALLET;<>; F:PALL_MAST;Y;;T\DESC=PM_DESC;PM_PALL='$I\PALLET$';I\PALLET |
|
| 1 | 0.0 | Label 4 | T | -1 | 231, 229 | ||
| 1 | 0.0 | Label 5 | T | -1 | 231, 193 | ||
| 1 | 0.0 | CMD 8 | C | -1 | 461, 193 | $SELECT I:I\AGENT;<>; S:POLL_SECT;I\SECTION;I\AGENT I:I\AGENT;=; S:SECT_MAST2;I\SECTION |
|
| 1 | 0.0 | CMD 9 | C | -1 | 461, 229 | $SELECT S:PALLET_CODE3;I\PALLET |
|
| 1 | 0.0 | Label 10 | T | -1 | 491, 157 | ||
| 1 | 0.0 | Label 11 | T | -1 | 491, 193 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 0, 0 |