Program drill-down
DIRRECT_SLS_ENQ
DIRECT DELIVERY SALES ENQ. Type DSP, base table STK_MAST_DIRECT.
Field inventory
87
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | CMD 4 | C | -1 | 191, 121 | $SELECT S:DIRECT_DELIV;I\SMD_DELNO |
|
| 1 | 0.0 | CMD 3 | C | -1 | 571, 145 | ||
| 1 | 0.0 | CMD 4 | C | -1 | 171, 145 | ||
| 1 | 0.0 | Work 1 | G | -1 | 1, 277 | ||
| 1 | 0.0 | H | -1 | 1, 115 | |||
| 1 | 0.0 | STK_DETS_DIRECT | SDD_BLOCK | I | -1 | 711, 277 | |
| 1 | 0.0 | I | 0 | 1, 541 | |||
| 1 | 0.0 | Work 1 | I | 0 | 41, 517 | ||
| 1 | 0.0 | Work 1 | I | 0 | 1, 565 | ||
| 1 | 0.0 | Work 2 | I | 0 | 21, 541 | ||
| 1 | 0.0 | ORGS | I | 0 | 111, 79 | ||
| 1 | 0.0 | STK_DETS_DIRECT | SDD_CONQTY | I | -1 | 321, 277 | $CALCULATE 'CLEAR FIELD A:CONST;;W\TEMP C:UCASE 'DETERMINE THE OWNER 'F:LOCATION_MAST;;;W\TMP=LM_AGENT;LM_CODE='$I\LT_LOCA$' 'IF LM_AGENT IS NULL THE OWNER IS THE MARKET - SO U MUST GET CHARGE TYPE FROM "CLIENT_MAST" 'I:W\TEMP;=; 'F:CLIENT_MAST;;;W\CHARGE_TYPE=CM_CHG_TYPE;CM_CODE='$I\MARKET$' 'IF LM_ |
| 1 | 0.0 | Work 2 | I | 0 | 1, 517 | ||
| 1 | 0.0 | STK_DETS_DIRECT | SDD_PROV | I | -1 | 251, 277 | $SELECT I:I\SM_MARKET;<>;40 S:PROVINCE_SUPPL;I\SDD_PROV;I\SMD_SUPP;I\PROD $CALCULATE C:UCASE M: '<<<<<<<<<<<< 2016-01-13 SIYA ADDED THE CHECK BELLOW ON JANET'S REQUEST JOB NUMBER - 23999 >>>>>>>>>>>>>>> F:SUPPL_PROD_PROV;;;I\TMP_SSP_PROV=SPP_PROV;SPP_CODE='$I\SMD_SUPP$' AND SPP_PROD='$I\PROD$';I\SDD_PROV |
| 1 | 0.0 | SM_DDATE | I | 0 | 71, 79 | ||
| 1 | 0.0 | STK_MAST_DIRECT | SMD_BLOCK | I | 0 | 111, 535 | |
| 1 | 0.0 | WW | I | 0 | 281, 127 | ||
| 1 | 0.0 | CM_DEL_LEN | I | 0 | 261, 127 | ||
| 1 | 0.0 | STK_DETS_DIRECT | SDD_SEQ | I | -1 | 1, 277 | $SELECT S:G:G\GRID:R1,I\SEQ $SELECT6 S:G:G\GRID:F1,I\SEQ $CALCULATE I:I\SEQ;=; DO(001) O:DISABLEINPUT;I\SDD_ITEM,I\SDD_CLASS,I\SDD_SIZE,I\SDD_CONT,I\SDD_CONTMASS,I\SDD_PROV,I\SDD_COUNT,I\SDD_CONQTY,I\SDD_PRICE O:DISABLEINPUT;I\SDD_VAT,I\SDD_TOT_VAL,I\SDD_BLOCK A:CONST;;I\SDD_ITEM,I\SDD_CLASS,I\SDD_SIZE,I\ |
| 1 | 0.0 | AGENT | I | 0 | 21, 79 | $DEFAULT A:ORGS;;I\AGENT A:ORGS;;I\ORGS 'GET USERNAME A:USERID;;I\USER A:USERID;;I\SMD_USER 'GET USER IP A:USERIP;;I\IP A:CONST;N;I\SMD_BLOCK 'LOAD AGENT NAME F:AGENT_MAST;;AM_CODE;T\AGENT=AM_NAME 'READ FMSX DETAILS FOR THE USER AND SEE IF IT IS ALLOWED TO CHANGE TARRIF WHEN DOING COLD STORAGE ISSUES |
|
| 1 | 0.0 | STK_MAST_DIRECT | SMD_MARKET | I | 0 | 1, 79 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\MARKET 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;I\CHARGEDAILY=CM_GENERATE_CS_CHARGE,I\OWN_CR=CM_OWN_ROOMS,I\TMP_TARIFF=CM_CS_MAX_CHARGE,I\TARIFF_OVRRD=CM_CS_ALLOW_TO,T\MARKET=CM_NAME,W\CM_DEL_LEN=CM_DEL_LEN,W\VATCODE=CM_CSVATCD,W\CS_MIN=CM_CS_MIN_CHARGE,W\CS_MAX=CM_CS_MAX_CHAR |
| 1 | 0.0 | I | -1 | 541, 277 | |||
| 1 | 0.0 | MKT_ROOM | I | 0 | 701, 115 | ||
| 1 | 0.0 | STK_MAST_DIRECT | SMD_SUPPL_REFNO | I | -1 | 491, 169 | |
| 1 | 0.0 | Work 1 | I | 0 | 21, 517 | ||
| 1 | 0.0 | STK_DETS_DIRECT | SDD_CONTMASS | I | -1 | 211, 277 | |
| 1 | 0.0 | STK_DETS_DIRECT | SDD_CLASS | I | -1 | 101, 277 | $SELECT S:CLASS_ITEM;I\SDD_CLASS;I\PROD;I\VAR $CALCULATE 'M: C:UCASE I:I\SDD_CLASS;<>; DO(001) A:CONST;;I\TMP1 F:CLASS_MAST;Y;CL_CLASS;I\TMP1=CL_BLOCKED;;I\SDD_CLASS I:I\TMP1;=;Y D:THIS CLASS HAS BEEN BLOCKED;ERRORM;I\SDD_CLASS DOEND(001) A:VAR;I\SD_CLASS;I\CLASS I:I\CLASS;=; A:CONST;0;I\CLASS |
| 1 | 0.0 | STK_DETS_DIRECT | SDD_CONT | I | -1 | 171, 277 | $SELECT S:CONT_PR_NODEL;I\SDD_CONT;I\PROD;I\VAR;I\SDD_CLASS;I\SDD_SIZE $CALCULATE M: C:UCASE A:VAR;I\SD_CONT;I\TMPCONT A:CONST;;I\TMP1 F:COMMODITY_MAST;Y;CO_CONT;I\TMP1=CO_BLOCKED;CO_PRODUCT='$I\PROD$' AND CO_VAR='$I\VAR$' AND CO_CLASS='$I\SDD_CLASS$' AND CO_SIZE='$I\SDD_SIZE$';I\SD_CONT I:I\TMP1;=;Y D:T |
| 1 | 0.0 | STK_MAST_DIRECT | SMD_TENANT | I | -1 | 101, 145 | $SELECT S:TENANT_CODE;I\SMD_TENANT $CALCULATE M: F:TENANT_MAST;Y;;T\TENANT_NAME=TM_NAME;TM_CODE='$I\SMD_TENANT$';I\SMD_TENANT |
| 1 | 0.0 | STK_MAST_DIRECT | SMD_SUPP | I | -1 | 491, 145 | $SELECT S:SUPPLIER_MAST;I\SMD_SUPP $CALCULATE M: A:VAR;I\SMD_SUPP;I\SMD_SUPP;;000000 F:SUPPLIER_MAST;Y;;T\SUPPL_NAME=SUM_NAME;SUM_SUPPL='$I\SMD_SUPP$';I\SMD_SUPP |
| 1 | 0.0 | SDD_VALUE | I | -1 | 611, 277 | ||
| 1 | 0.0 | SDD_VALUE | I | -1 | 461, 277 | ||
| 1 | 0.0 | STK_MAST_DIRECT | SMD_INV | I | -1 | 101, 169 | |
| 1 | 0.0 | STK_MAST_DIRECT | SMD_DELNO | I | -1 | 101, 121 | $SELECT S:DIRECT_DELIV;I\SMD_DELNO $VALIDATE M: A:VAR;I\SMD_DELNO;I\SMD_DELNO;;000000 F:STK_MAST_DIRECT;Y;;I\SMD_DDATE=SMD_DDATE,I\SMD_TENANT=SMD_TENANT,I\SMD_SUPP=SMD_SUPP,I\SMD_INV=SMD_INV,I\SMD_MKTREFNO=SMD_MKTREFNO,I\SMD_SUPPLREFNO=SMD_SUPPL_REFNO,I\SMD_VREGNO=SMD_VREGNO;SMD_MARKET='$I\MARKET$' AND SMD_DELNO=' |
| 1 | 0.0 | STK_DETS_DIRECT | SDD_PRICE | I | -1 | 391, 277 | $DEFAULT O:DISABLEINPUT;I\LT_TRVALUE $CALCULATE 'CHECK MINUMUM U:CS_AGENT_ISS_MAN;MINIMUM I:W\FLAG2;=;N D:RE-ENTER THE NET AMOUNT FOR THIS ISSUE;ERRORM;I\LT_TRVALUE '===========================CALCULATE VAT============ BEGIN ================================ 'CALCULATE THE VAT F:VAT_MAST;;;W |
| 1 | 0.0 | STK_MAST_DIRECT | SMD_MKTREFNO | I | -1 | 491, 193 | |
| 1 | 0.0 | Work 1 | I | 0 | 91, 79 | $DEFAULT 'PUTS PIC ON THE UPDATE BUTTON O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\CREATE A:DATE;DD MMM/YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME A:TIME;HH:MM:SS;I\SMD_DTIME A:TIME;HH:MM:SS;I\SMD_TIME 'A:TIMER_ON;1000 A:DATE;YYYY/MM/DD;I\SMD_DDATE A:DATE;YYYY/MM/DD;I\SMD_DATE 'GETS WHICH SCREEN |
|
| 1 | 0.0 | STK_DETS_DIRECT | SDD_SIZE | I | -1 | 131, 277 | $SELECT S:SIZE_ITEM;I\SDD_SIZE;I\PROD;I\VAR $SELECT6 S:GRADE_ITEM;I\SDD_CLASS;I\PROD;I\VAR A:SELPARM;1;I\SDD_CLASS A:SELPARM;2;I\SDD_SIZE $CALCULATE 'M: C:UCASE I:I\SDD_SIZE;<>; DO(001) A:CONST;;I\TMP1 F:SIZE_MAST;Y;SZ_SIZE;I\TMP1=SZ_BLOCKED;;I\SDD_SIZE I:I\TMP1;=;Y D:THIS SIZE HAS BEEN BLOC |
| 1 | 0.0 | STK_DETS_DIRECT | SDD_COUNT | I | -1 | 291, 277 | $DEFAULT DIM TMP5,TMP6 $SELECT A:CON;I\CLASS;I\TMP1;I\SIZE S:COUNT_MAST_CNT;I\SD_COUNT;I\PROD;I\TMP1;I\SD_CONT $CALCULATE I:I\SDD_COUNT;<>; DO(001) A:CON;I\CLASS;I\TMP1;I\SIZE F:COUNT_MAST;;CNT_COUNT;TMP5=CNT_PRODUCT;CNT_PRODUCT='$I\PROD$' AND CNT_CONTAINER = '$I\SDD_CONT$' AND CNT_GRADE = '$I\TMP1 |
| 1 | 0.0 | STK_MAST_DIRECT | SMD_DDATE | I | 0 | 21, 565 | |
| 1 | 0.0 | STK_MAST_DIRECT | SMD_DTIME | I | 0 | 41, 541 | |
| 1 | 0.0 | STK_MAST_DIRECT | SMD_DATE | I | 0 | 41, 565 | |
| 1 | 0.0 | STK_MAST_DIRECT | SMD_TIME | I | 0 | 61, 541 | |
| 1 | 0.0 | STK_MAST_DIRECT | SMD_USER | I | 0 | 61, 565 | |
| 1 | 0.0 | Work 1 | I | 0 | 141, 79 | ||
| 1 | 0.0 | STK_DETS_DIRECT | SDD_ITEM | I | -1 | 31, 277 | $SELECT S:ITEM_SEL;I\SDD_ITEM A:SELPARM;2;I\TMP1 A:CON;I\SDD_ITEM;I\SDD_ITEM;I\TMP1 $CALCULATE M: C:UCASE A:LEFT;I\SDD_ITEM,2;I\PROD A:MID;I\SDD_ITEM,3,2;I\VAR F:VAR_MAST;Y;;I\TMP1=VA_BLOCKED,I\PROV_REQ=VA_PROV_REQ;VA_PRODUCT='$I\PROD$' AND VA_VARIETY='$I\VAR$';I\SDD_ITEM I:I\TMP1;=;Y D:THIS VARIETY HAS BE |
| 1 | 0.0 | UPDATE_FLAG | I | 0 | 3, 85 | ||
| 1 | 0.0 | Work 1 | I | 0 | 231, 103 | ||
| 1 | 0.0 | DEPOSITS | I | 0 | 301, 127 | ||
| 1 | 0.0 | Work 1 | I | 0 | 171, 79 | ||
| 1 | 0.0 | Work 1 | I | 0 | 151, 535 | ||
| 1 | 0.0 | STK_MAST_DIRECT | SMD_VREGNO | I | -1 | 101, 193 | |
| 1 | 0.0 | Label 1 | T | -1 | 201, 145 | ||
| 1 | 0.0 | Label 8 | T | -1 | 1, 229 | ||
| 1 | 0.0 | Label 2 | T | -1 | 601, 145 | ||
| 1 | 0.0 | Label 20 | T | -1 | 711, 253 | ||
| 1 | 0.0 | Label 2 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 6 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 10 | T | -1 | 251, 253 | ||
| 1 | 0.0 | Label 2 | T | -1 | 101, 253 | ||
| 1 | 0.0 | Label 12 | T | -1 | 381, 145 | ||
| 1 | 0.0 | Label 6 | T | -1 | 181, 253 | ||
| 1 | 0.0 | Label 3 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 1 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 6 | T | -1 | 541, 253 | ||
| 1 | 0.0 | Label 10 | T | -1 | 611, 253 | ||
| 1 | 0.0 | T | -1 | 1, 169 | |||
| 1 | 0.0 | Label 5 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 4 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 1 | T | -1 | 1, 253 | ||
| 1 | 0.0 | Label 4 | T | -1 | 461, 253 | ||
| 1 | 0.0 | DELNO | T | -1 | 1, 121 | ||
| 1 | 0.0 | Label 3 | T | -1 | 41, 253 | ||
| 1 | 0.0 | Label 10 | T | -1 | 321, 253 | ||
| 1 | 0.0 | AGENT_NAME | T | -1 | 381, 193 | ||
| 1 | 0.0 | TENANT | T | -1 | 1, 145 | ||
| 1 | 0.0 | Label 8 | T | -1 | 291, 49 | ||
| 1 | 0.0 | Label 12 | T | -1 | 391, 253 | ||
| 1 | 0.0 | Label 8 | T | -1 | 291, 253 | ||
| 1 | 0.0 | Label 1 | T | -1 | 381, 169 | ||
| 1 | 0.0 | Label 1 | T | -1 | 1, 193 | ||
| 1 | 0.0 | Label 1 | T | -1 | 141, 253 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 1, 115 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 1, 115 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 1, 115 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 1, 115 | $BEFORE_WRITE U:DIRECT_DELIVERY_MAN;UPDATE_STK_DETS;G\GRID U:DIRECT_DELIVERY_MAN;UPDATE_DELNO |
|
| 10 | 0.0 | ZX_EXIT | Z | 0 | 1, 115 |