Freshmark replication server

freshmark-canonical

Program drill-down

DIR_DEL_CONF_PRE

DIRECT DELIVERY SALES CONFIRMATION. Type DSP, base table STK_MAST_DIRECT.

Field inventory

99

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Work 1 I 0 31, 85
  
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 CMD 1 C -1 651, 546
$SELECT  U:CONF_DIRDELIV_PRE;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)TOT_VAL,I\SMD_USER_CHECK  U:ZZGRID_SPLIT;CLEAR_GRID;G\GRID  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SDD_SEQ
1 0.0 Work 1 G -1 1, 277
  
1 0.0 H -1 1, 115
  
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 411, 469
$VALIDATE  M:  C:UCASE    V:Y;N    I:I\SMD_CONFIRM;=;Y  DO(CONF)  O:DISABLEINPUT;I\REASON  O:SETFOCUS;C\CREATE  O:BACKCOLOR;C\CREATE;YELLOW  DOEND(CONF)    I:I\SMD_CONFIRM;=;N  DO(CONF)  O:SETFOCUS;I\REASON  DOEND(CONF)
1 0.0 STK_DETS_DIRECT SDD_CONQTY I -1 211, 277
      
1 0.0 Work 2 I 0 1, 517
  
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_CONTMASS,I\SDD_CONQTY,I\SDD_INV_PRICE,I\SDD_INVKG_PRICE,I\SDD_AVEKG_PRICE,I\SDD_PRICE,I\SDD_TOTDUES,I\SDD_TOTDUESV   O:DISABLEINPUT;I\SDD_TOT_VAL   A:CONST;;I\SDD_ITE
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 SDD_TOTDUESV I -1 591, 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_CONTMASS I -1 171, 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 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 651, 277
  
1 0.0 I -1 521, 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_AVEKG_PRICE I -1 371, 277
  
1 0.0 STK_MAST_DIRECT SMD_MKTREFNO I 0 531, 193
  
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_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 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 STK_MAST_DIRECT SMD_CONFIRMED I 0 101, 469
  
1 0.0 Work 1 I 0 101, 541
  
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 2 T -1 1, 25
  
1 0.0 Label 6 T -1 671, 49
  
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 171, 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 591, 253
  
1 0.0 Label 10 T -1 661, 253
  
1 0.0 Label 11 T -1 241, 469
  
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 521, 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 211, 253
  
1 0.0 AGENT_NAME T 0 411, 193
  
1 0.0 TENANT T -1 1, 145
  
1 0.0 Label 8 T -1 221, 49
  
1 0.0 Label 12 T -1 461, 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 Label 1 T -1 261, 253
  
1 0.0 Label 2 T -1 321, 253
  
1 0.0 Label 3 T -1 381, 253
  
1 0.0 STK_DETS_DIRECT SDD_INV_PRICE I -1 261, 277
  
1 0.0 STK_DETS_DIRECT SDD_INVKG_PRICE I -1 321, 277
  
1 0.0 SDD_PRICE I -1 441, 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 Label 1 T -1 291, 505
  
1 0.0 Work 2 I -1 411, 505
$VALIDATE  M:  C:UCASE    O:SETFOCUS;C\CREATE  O:BACKCOLOR;C\CREATE;YELLOW
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