Program drill-down
CS_STK_REPORT
COLD STORAGE DEPOSIT ENQUIRY. Type DSP, base table VAT_MAST.
Field inventory
41
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | Label 16 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 17 | T | -1 | 350, 25 | ||
| 1 | 0.0 | Work 15 | I | -1 | 371, 313 | $VALIDATE I:I\TDATE;=; A:DATE;DD MMM YYYY;I\TDATE O:SETFOCUS;C\RUN O:BACKCOLOR;C\RUN;YELLOW |
|
| 1 | 0.0 | Work 14 | I | -1 | 371, 289 | $VALIDATE I:I\FDATE;=; A:DATE;DD MMM YYYY;I\FDATE |
|
| 1 | 0.0 | Work 11 | I | -1 | 371, 217 | $SELECT S:ROOMS;I\ROOMNO $VALIDATE I:I\ROOMNO;<>; F:LOCATION_MAST;Y;;;LM_CODE='$I\ROOMNO$';I\ROOMNO |
|
| 1 | 0.0 | Work 12 | I | -1 | 371, 241 | $SELECT S:ITEM_NEW;I\ITEM $VALIDATE I:I\CONSIGNO;<>; DO(01) I:I\ITEM;<>; F:STK_DETS;Y;;W\ITEM=SD_ITEM;SD_CONSIGN='$I\CONSIGNO$' AND SD_ITEM='$I\ITEM$';I\ITEM ''DO(02) ''I:W\ITEM;=; ''D:ITEM $I\ITEM$ DOES NOT BELONG TO CONSIGNMENT $I\CONSIGNO$;ERRORM;I\ITEM ''DOEND(02) DOEND(01) I:I\CON |
|
| 1 | 0.0 | Work 13 | I | -1 | 371, 265 | $SELECT S:SUPPLIER_CODE;I\SUPP $VALIDATE I:I\SUPP;<>; F:SUPPLIER_MAST;Y;;;SUM_SUPPL='$I\SUPP$';I\SUPP |
|
| 1 | 0.0 | Label 9 | T | -1 | 261, 313 | ||
| 1 | 0.0 | Work 10 | I | -1 | 371, 193 | $SELECT S:CONSIGNMENT;I\CONSIGNO;I\AGENT $VALIDATE I:I\CONSIGNO;<>; F:STK_DETS;Y;;;SD_CONSIGN='$I\CONSIGNO$';I\CONSIGNO $VALIDATE 'I:I\CONSIGNO;<>; 'DO(02) 'I:I\AGENT;<>; 'F:STK_DETS;Y;;SD_CONSIGN='$I\CONSIGNO$' AND SD_AGENT='$I\AGENT$';I\AGENT 'DOEND(01) 'I:I\CONSIGNO;=; 'DO(01) 'I:I\AGENT;<>; 'F |
|
| 1 | 0.0 | Label 7 | T | -1 | 261, 265 | ||
| 1 | 0.0 | Label 8 | T | -1 | 261, 289 | ||
| 1 | 0.0 | Label 5 | T | -1 | 261, 217 | ||
| 1 | 0.0 | Label 6 | T | -1 | 261, 241 | ||
| 1 | 0.0 | Label 4 | T | -1 | 261, 193 | ||
| 1 | 0.0 | Label 3 | T | -1 | 261, 169 | ||
| 1 | 0.0 | Work 2 | I | -1 | 371, 169 | $SELECT S:AGENT_CODE;I\AGENT $VALIDATE I:I\AGENT;<>; F:AGENT_MAST;Y;;T\AGENTNAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT |
|
| 1 | 0.0 | Label 18 | T | -1 | 331, 49 | ||
| 1 | 0.0 | Label 19 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 20 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 21 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 22 | T | -1 | 671, 49 | ||
| 1 | 0.0 | CMD 1 | C | -1 | 321, 349 | $SELECT 'I:I\AGENT;<>; 'F:AGENT_MAST;Y;;T\AGENTNAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT 'I:I\CONSIGNO;<>; 'F:STK_DETS;Y;;;SD_CONSIGN='$I\CONSIGNO$';I\CONSIGNO 'I:I\ROOMNO;<>; 'F:LOCATION_MAST;Y;;;LM_CODE='$I\ROOMNO$';I\ROOMNO 'I:I\ITEM;<>; 'F:STK_DETS;Y;;;SD_ITEM='$I\ITEM$';I\ITEM 'I:I\SUPP;<>; 'F:S |
|
| 1 | 0.0 | Work 2 | I | 0 | 1, 49 | ||
| 1 | 0.0 | CMD 3 | C | -1 | 471, 169 | $SELECT S:AGENT_CODE;I\AGENT |
|
| 1 | 0.0 | CMD 4 | C | -1 | 471, 193 | $SELECT S:CONSIGNMENT;I\CONSIGNO;I\AGENT |
|
| 1 | 0.0 | CMD 5 | C | -1 | 471, 217 | $SELECT S:ROOMS;I\ROOMNO |
|
| 1 | 0.0 | CMD 6 | C | -1 | 471, 241 | $SELECT S:ITEM_NEW;I\ITEM |
|
| 1 | 0.0 | CMD 7 | C | -1 | 471, 265 | $SELECT S:SUPPLIER_CODE;I\SUPP |
|
| 1 | 0.0 | Work 8 | I | 0 | 51, 49 | $DEFAULT A:ORG;;I\MARKET A:ORGS;;I\ORGS A:DATE;DD MMM YYYY;T\DATE A:DATE;HH:MM:SS;T\TIME A:DATE;DD MMM YYYY;I\FDATE A:DATE;DD MMM YYYY;I\TDATE F:CLIENT_MAST;;;T\MARKET=CM_NAME;CM_CODE='$I\MARKET$' |
|
| 1 | 0.0 | Label 1 | T | -1 | 511, 169 | ||
| 1 | 0.0 | Work 2 | I | 0 | 511, 193 | ||
| 1 | 0.0 | Label 3 | T | -1 | 371, 397 | ||
| 1 | 0.0 | Label 3 | T | -1 | 251, 133 | ||
| 1 | 0.0 | Work 2 | I | -1 | 371, 133 | $VALIDATE V:1;2 O:SETFOCUS;C\RUN |
|
| 1 | 0.0 | Label 1 | T | -1 | 171, 97 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 0, 0 |