Program drill-down
CS_STKSHEET_CPT
COLD STORAGE STOCK SHEET. Type DSP, base table VAT_MAST.
Field inventory
54
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | Work 14 | I | 0 | 11, 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 | Label 4 | T | -1 | 251, 193 | ||
| 1 | 0.0 | Label 3 | T | -1 | 251, 169 | ||
| 1 | 0.0 | Label 18 | T | -1 | 271, 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 | Label 1 | T | -1 | 511, 169 | ||
| 1 | 0.0 | Label 3 | T | -1 | 371, 409 | ||
| 1 | 0.0 | Label 3 | T | -1 | 251, 133 | ||
| 1 | 0.0 | Label 1 | T | -1 | 251, 97 | ||
| 1 | 0.0 | Label 1 | T | -1 | 251, 313 | ||
| 1 | 0.0 | Label 1 | T | -1 | 251, 289 | ||
| 1 | 0.0 | Label 16 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 6 | T | -1 | 251, 241 | ||
| 1 | 0.0 | Label 5 | T | -1 | 251, 217 | ||
| 1 | 0.0 | Label 8 | T | 0 | 11, 289 | ||
| 1 | 0.0 | Label 7 | T | -1 | 251, 265 | ||
| 1 | 0.0 | Label 9 | T | 0 | 11, 313 | ||
| 1 | 0.0 | Label 17 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Work 2 | I | -1 | 371, 313 | $SELECT S:SALESMAN_AGENT;I\SLSMAN;I\AGENT $VALIDATE C:UCASE I:I\SLSMAN;<>; DO(SLS) I:I\AGENT;<>; F:SALESMAN_MAST;Y;;T\SLSNAME=SLS_NAME;SLS_CODE='$I\SLSMAN$' AND SLS_AGENT='$I\AGENT$';I\SLSMAN I:I\AGENT;=; F:SALESMAN_MAST;Y;;;SLS_CODE='$I\SLSMAN$';I\SLSMAN DOEND(SLS) I:I\MARKET;<>;15 DO(15) |
|
| 1 | 0.0 | Work 1 | I | 0 | 71, 253 | ||
| 1 | 0.0 | Work 2 | I | -1 | 371, 133 | $VALIDATE V:1;2 O:SETFOCUS;C\RUN |
|
| 1 | 0.0 | Work 1 | I | 0 | 71, 217 | ||
| 1 | 0.0 | Work 2 | I | 0 | 1, 49 | ||
| 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 A:CONST;Y;I\STK_SHEET F:CLIENT_MAST;;;T\MARKET=CM_NAME;CM_CODE='$I\MARKET$' C:MCASE;;T\MARKET I:I\ORGS;<>; DO(0) A:VAR;I\ORGS;I\AGENT O:DISABLEINPUT;I\A |
|
| 1 | 0.0 | Work 2 | I | 0 | 511, 193 | ||
| 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 | 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 | 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 'O:SETFOCUS;C\RUN 'O:BACKCOLOR;C\RUN;YELLOW |
|
| 1 | 0.0 | Work 12 | I | -1 | 371, 241 | $SELECT S:ITEM_NEW;I\ITEM $VALIDATE I:I\ITEM;<>; DO(01) A:LEN;I\ITEM;W\TEMP I:W\TEMP;<;2 D:ENTER A VALID ITEM OR PRODUCT;ERRORM;I\ITEM I:I\CONSIGNO;<>; DO(00) I:W\TEMP;>;2 DO(ITEM) F:STK_DETS;Y;;W\ITEM=SD_ITEM;SD_CONSIGN='$I\CONSIGNO$' AND SD_ITEM='$I\ITEM$';I\ITEM DOEND(I |
|
| 1 | 0.0 | Work 15 | I | 0 | 11, 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 2 | I | -1 | 371, 337 | $SELECT S:SECTION;I\PROD_SECT $CALCULATE C:UCASE I:I\PROD_SECT;<>; F:SECT_MAST;Y;;T\SNAME=SE_DESC;SE_SECT='$I\PROD_SECT$';I\PROD_SECT I:I\PROD_SECT;=; A:CONST;;T\SNAME I:I\MARKET;=;15 DO(15) O:SETFOCUS;C\RUN O:BACKCOLOR;C\RUN;YELLOW DOEND(15) |
|
| 1 | 0.0 | Work 2 | I | -1 | 371, 289 | $SELECT S:LOC_SECTION;I\SECTION;I\MARKET |
|
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | CMD 3 | C | -1 | 471, 313 | $SELECT S:SALESMAN_AGENT;I\SLSMAN;I\AGENT I:I\AGENT;<>; F:SALESMAN_MAST;Y;;T\SLSNAME=SLS_NAME;SLS_CODE='$I\SLSMAN$' AND SLS_AGENT='$I\AGENT$';I\SLSMAN I:I\AGENT;=; F:SALESMAN_MAST;Y;;;SLS_CODE='$I\SLSMAN$';I\SLSMAN |
|
| 1 | 0.0 | CMD 7 | C | -1 | 471, 265 | $SELECT S:SUPPLIER_CODE;I\SUPP |
|
| 1 | 0.0 | CMD 6 | C | -1 | 471, 241 | $SELECT S:ITEM_NEW;I\ITEM |
|
| 1 | 0.0 | CMD 5 | C | -1 | 471, 217 | $SELECT S:ROOMS;I\ROOMNO |
|
| 1 | 0.0 | CMD 4 | C | -1 | 471, 193 | $SELECT S:CONSIGNMENT;I\CONSIGNO;I\AGENT |
|
| 1 | 0.0 | CMD 3 | C | -1 | 471, 169 | $SELECT S:AGENT_CODE;I\AGENT |
|
| 1 | 0.0 | CMD 1 | C | -1 | 371, 385 | $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 | CMD 3 | C | -1 | 471, 289 | $SELECT S:LOC_SECTION;I\SECTION;I\MARKET |
|
| 1 | 0.0 | CMD 3 | C | -1 | 471, 337 | $SELECT S:SECTION;I\PROD_SECT |
|
| 1 | 0.0 | Label 4 | T | -1 | 511, 313 | ||
| 1 | 0.0 | Label 1 | T | -1 | 251, 337 | ||
| 1 | 0.0 | Label 4 | T | -1 | 511, 337 | ||
| 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 |