Program drill-down
DIRECT_DELIV_CONF
DIRECT DELIVERY SALES CONFIRMATION. Type DSP, base table STK_MAST_DIRECT.
Field inventory
98
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_CON;I\SMD_DELNO |
|
| 1 | 0.0 | CMD 3 | C | -1 | 611, 145 | ||
| 1 | 0.0 | CMD 4 | C | 0 | 171, 145 | $SELECT S:TENANT_CODE;I\SMD_TENANT |
|
| 1 | 0.0 | Work 1 | G | -1 | 1, 301 | ||
| 1 | 0.0 | H | -1 | 1, 115 | |||
| 1 | 0.0 | STK_DETS_DIRECT | SDD_BLOCK | I | -1 | 711, 277 | $CALCULATE C:UCASE V:Y;N; I:I\SDD_BLOCK;=; A:CONST;N;I\SDD_BLOCK U:ZZGRID_SPLIT;SCREEN_TO_GRID;G\GRID;I\SDD_SEQ A:CONST;+;I\SDD_SEQ 'SET FOCUS 'A:CONST;;I\SDD_ITEM,I\SDD_CLASS,I\SDD_SIZE,I\SDD_CONT,I\SDD_CONTMASS,I\SDD_PROV,I\SDD_COUNT,I\SDD_CONTQTY,I\SDD_PRICE 'A:CONST;;I\SDD_VAT,I\SDD_TOT_VAL,I\SMD_BLOCK, |
| 1 | 0.0 | I | 0 | 1, 541 | |||
| 1 | 0.0 | Work 1 | I | 0 | 1, 565 | ||
| 1 | 0.0 | Work 2 | I | 0 | 21, 541 | ||
| 1 | 0.0 | ORGS | I | 0 | 101, 49 | ||
| 1 | 0.0 | I | -1 | 451, 481 | $VALIDATE M: V:Y O:SETFOCUS;C\CREATE O:BACKCOLOR;C\CREATE;YELLOW |
||
| 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 | 61, 49 | ||
| 1 | 0.0 | STK_MAST_DIRECT | SMD_BLOCK | I | 0 | 81, 565 | |
| 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 $SELECT6 S:G:G\GRID:F1,I\SDD_SEQ $CALCULATE I:I\SDD_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, |
| 1 | 0.0 | Work 1 | I | 0 | 81, 517 | ||
| 1 | 0.0 | AGENT | I | 0 | 41, 49 | $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:USERID;;I\SMD_CONF_USER 'GET USER IP A:USERIP;;I\SMD_CONF_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 |
|
| 1 | 0.0 | STK_MAST_DIRECT | SMD_MARKET | I | 0 | 1, 49 | $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 | STK_DETS_DIRECT | SDD_VAT | I | -1 | 541, 277 | |
| 1 | 0.0 | MKT_ROOM | I | 0 | 701, 115 | ||
| 1 | 0.0 | STK_MAST_DIRECT | SMD_SUPPL_REFNO | I | -1 | 531, 169 | |
| 1 | 0.0 | Work 1 | I | 0 | 21, 517 | ||
| 1 | 0.0 | STK_DETS_DIRECT | SDD_MASS | 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 | I | -1 | 101, 145 | $SELECT S:TENANT_CODE;I\SMD_TENANT $CALCULATE M: A:VAR;I\SMD_TENANT;I\SMD_TENANT;;000 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 | 531, 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 | I | -1 | 461, 277 | |||
| 1 | 0.0 | I | -1 | 101, 169 | |||
| 1 | 0.0 | STK_MAST_DIRECT | SMD_DELNO | I | -1 | 101, 121 | $SELECT S:DIRECT_DELIV_CON;I\SMD_DELNO $VALIDATE M: O:DISABLEINPUT;I\SDD_ITEM,I\SDD_CLASS,I\SDD_SIZE,I\SDD_CONT,I\SDD_CONTMASS,I\SDD_PROV,I\SDD_COUNT O:DISABLEINPUT;I\SDD_VAT,I\SDD_TOT_VAL,I\SDD_BLOCK A:VAR;I\SMD_DELNO;I\SMD_DELNO;;000000 F:STK_MAST_DIRECT;Y;;I\SMD_USER_CHECK=SMD_USER;SMD_MARKET='$I\MARKET$' A |
| 1 | 0.0 | STK_DETS_DIRECT | SDD_PRICE | I | -1 | 391, 277 | $CALCULATE I:I\SMD_INV;<>; DO(PRICE) I:I\SDD_PRICE;<=;0 DO(PRICE15) D:PRICE MUST BE GREATER THAN ZERO;ERRORM;I\SDD_PRICE DOEND(PRICE15) I:I\SDD_CONQTY;<=;0;NUM DO(99) D:QUANTITY MUST BE GREATER THAN ZERO;ERRORM;I\SDD_CONQTY DOEND(99) F:VAR_MAST;;;I\TMP1=VA_VATCD;VA_PRODUCT='$I\PROD$' AND VA_VARIETY='$I |
| 1 | 0.0 | STK_MAST_DIRECT | SMD_MKTREFNO | I | -1 | 311, 169 | |
| 1 | 0.0 | Work 1 | I | 0 | 81, 49 | $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 A:TIME;HH:MM:SS;I\SM |
|
| 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\SDD_COUNT;I\PROD;I\;I\SDD_COUNT $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 | 121, 49 | ||
| 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 | 21, 49 | ||
| 1 | 0.0 | Work 1 | I | 0 | 231, 103 | ||
| 1 | 0.0 | DEPOSITS | I | 0 | 301, 127 | ||
| 1 | 0.0 | Work 1 | I | 0 | 141, 49 | ||
| 1 | 0.0 | Work 1 | I | 0 | 81, 541 | ||
| 1 | 0.0 | STK_MAST_DIRECT | SMD_VREGNO | I | -1 | 101, 193 | |
| 1 | 0.0 | Work 2 | I | 0 | 41, 517 | ||
| 1 | 0.0 | Work 3 | I | 0 | 61, 517 | ||
| 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 | 631, 145 | ||
| 1 | 0.0 | Label 20 | T | -1 | 701, 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 | 411, 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 | Label 11 | T | -1 | 251, 481 | ||
| 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 | 211, 169 | ||
| 1 | 0.0 | TENANT | T | -1 | 1, 145 | ||
| 1 | 0.0 | Label 8 | T | -1 | 221, 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 | 411, 169 | ||
| 1 | 0.0 | Label 1 | T | -1 | 1, 193 | ||
| 1 | 0.0 | Label 1 | T | -1 | 141, 253 | ||
| 1 | 0.0 | STK_MAST_DIRECT | SMD_CONF_DATE | I | 0 | 1, 493 | |
| 1 | 0.0 | STK_MAST_DIRECT | SMD_CONF_USER | I | 0 | 1, 469 | |
| 1 | 0.0 | STK_MAST_DIRECT | SMD_CONF_TIME | I | 0 | 101, 493 | |
| 1 | 0.0 | STK_MAST_DIRECT | SMD_CONF_IP | I | 0 | 101, 517 | |
| 1 | 0.0 | CMD 1 | C | -1 | 651, 546 | $SELECT U:CONFIRM_DIRECT_DELIV;UPDATE_STK_MAST_DIRECT;G\GRID A:CONST;;I\SMD_DELNO,I\SMD_DDATE,I\SMD_TENANT,I\SMD_SUPP,I\SMD_INV,I\SMD_MKTREFNO,I\SMD_SUPPLREFNO,I\SMD_VREGNO,T\TENANT_NAME,I\SMD_CONFIRM,I\TMP_CONF,I\SDD_VALUE,I\SMD_USER_CHECK U:ZZGRID_SPLIT;CLEAR_GRID;G\GRID U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SDD_SE |
|
| 1 | 0.0 | STK_MAST_DIRECT | SMD_CONFIRMED | I | 0 | 101, 469 | |
| 1 | 0.0 | Work 1 | I | 0 | 101, 541 | ||
| 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 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 1, 115 |