Program drill-down
SPL_APMLCLEVY_REPORT
MONTHLY LEVIES BY SUPPLIER. Type DSP, base table TROLLEY_MAST.
Field inventory
40
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | Label 5 | T | -1 | 241, 205 | ||
| 1 | 0.0 | CMD 5 | C | -1 | 651, 546 | $SCMD_FOCUS O:BACKCOLOR;C\CREATE;YELLOW $SELECT E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_SUPPL_APMLCLEVY_REPORT;$I\AGENT$,$I\MARKET$,$I\SUPPLIER_CODE$,$D\SELECT$,$I\FROM_DATE$,$I\TO_DATE$,$I\DUMP$,S 'A:CONST;;I\AGENT,I\LEVY_CODE,T\LEVY_DESC,I\FROM_DATE,I\TO_DATE,I\EXIST,I\EXIST_LEVY O:SETF |
|
| 1 | 0.0 | Label 1 | T | -1 | 241, 253 | ||
| 1 | 0.0 | CMD 8 | C | -1 | 421, 289 | $SELECT S:SUPPLIER_CODE3;I\SUPPLIER_CODE |
|
| 1 | 0.0 | Label 9 | T | -1 | 201, 289 | ||
| 1 | 0.0 | Label 1 | T | -1 | 431, 325 | ||
| 1 | 0.0 | Work 1 | I | 0 | 441, 469 | ||
| 1 | 0.0 | Label 1 | T | -1 | 121, 97 | ||
| 1 | 0.0 | Label 2 | T | -1 | 241, 133 | ||
| 1 | 0.0 | Label 3 | T | -1 | 241, 157 | ||
| 1 | 0.0 | Label 4 | T | -1 | 241, 181 | ||
| 1 | 0.0 | Drop 7 | D | -1 | 321, 325 | $DEFAULT 'ADDS THE SPECIFIED ITEMS TO THE COMBOBOX B:ADDITEM;D\SELECT;AV = AVOCADO,PL = PINEAPPLE,ML = MANGO,LL = LICHIE,CL = CACTUS,PO = POMEGRANATE $VALIDATE A:CONST;;T\DESC C:UCASE M: 'CHECKS THAT ONLY THE ADDED ITEMS ARE ENTERED I:D\SELECT;=;AV = AVOCADO DO(AV) 'TAKE THE LEFT MOST CHARACTER A |
|
| 1 | 0.0 | Label 4 | T | -1 | 201, 397 | ||
| 1 | 0.0 | Work 1 | I | 0 | 401, 469 | ||
| 1 | 0.0 | Label 3 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 4 | T | -1 | 281, 49 | ||
| 1 | 0.0 | TO_DATE | I | -1 | 321, 397 | $VALIDATE I:I\TO_DATE;=; A:CONST;$T\DATE$;I\TO_DATE A:DATEDIFF;I\TO_DATE;I\DATEDIFF;I\FROM_DATE I:I\DATEDIFF;<;0 D:TO DATE CANNOT BE LESS THAN FROM DATE;ERRORM;I\TO_DATE 'O:SETFOCUS;C\CREATE 'O:BACKCOLOR;C\CREATE;YELLOW |
|
| 1 | 0.0 | Label 1 | T | -1 | 201, 433 | ||
| 1 | 0.0 | Work 2 | I | -1 | 321, 433 | $VALIDATE C:UCASE I:I\DUMP;=; A:CONST;N;I\DUMP V:Y;N O:SETFOCUS;C\CREATE O:BACKCOLOR;C\CREATE;YELLOW |
|
| 1 | 0.0 | FROM_DATE | I | -1 | 321, 361 | $VALIDATE I:I\FROM_DATE;<>; DO(FDTE) O:SETFOCUS;I\TO_DATE DOEND(FDTE) I:I\FROM_DATE;=; A:CONST;$T\DATE$;I\FROM_DATE |
|
| 1 | 0.0 | Label 5 | T | -1 | 1, 25 | ||
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | Label 8 | T | -1 | 621, 49 | ||
| 1 | 0.0 | MARKET | I | 0 | 111, 37 | $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 A:VAR;I\MARKET;I\TM_MARKET $AFTER_READ A:VAR;I\MARKET;I\TM_MARKET |
|
| 1 | 0.0 | Label 11 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 9 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 10 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Work 1 | I | 0 | 261, 481 | ||
| 1 | 0.0 | Work 2 | I | 0 | 201, 481 | ||
| 1 | 0.0 | DEFAULT | I | 0 | 141, 37 | 'DISPLAYING TIME $DEFAULT A:DATE;DD MMM YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME A:TIMER_ON;1000 |
|
| 1 | 0.0 | SUPPLIER_CODE | I | -1 | 321, 289 | $DEFAULT 'PUTS PIC ON THE UPDATE BUTTON O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\CREATE $SELECT S:SUPPLIER_CODE3;I\SUPPLIER_CODE $VALIDATE A:CONST;;I\EXIST_LEVY,I\EXIST 'M: C:UCASE I:I\SUPPLIER_CODE;<>; F:SUPPLIER_MAST;Y;;T\SUPPLNAME=SUM_NAME;SUM_SUPPL='$I\SUPPLIER_CODE$' AND SUM |
|
| 1 | 0.0 | Label 2 | T | -1 | 201, 361 | ||
| 1 | 0.0 | Label 1 | T | -1 | 201, 325 | ||
| 1 | 0.0 | Label 10 | T | -1 | 451, 289 | ||
| 1 | 0.0 | Label 6 | T | -1 | 241, 229 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 0, 0 | ||
| 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 |