Freshmark replication server

freshmark-canonical

Program drill-down

AGENTS_FLOOR_MAN

AGENT FLOOR MAINTENANCE. Type MAN, base table AGENT_MAST.

Field inventory

101

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 11 C -1 471, 325
$SELECT  S:ITEM_NEW;I\ITEM
1 0.0 CMD 12 C -1 411, 481
$SELECT  A:CONST;;I\ALLOW    I:I\SDATE;=;  D:PLEASE ENTER A START DATE;ERRORM;I\SDATE    I:I\EDATE;=;  D:PLEASE ENTER AN END DATE;ERRORM;I\EDATE    I:I\ORGS;<>;  DO(SLA)    I:I\ORGS;<>;I\AGENT    D:YOU MAY NOT RUN FOR THIS AGENCY;ERRORM;I\AGENT  DOEND(SLA)    I:I\MARKET;<>;15  DO(TIME)    I:I\CM_ALLOW_MNTH_REPORT;<>;1 
1 0.0 CMD 8 C -1 471, 289
$SELECT  I:I\AGENT;<>;  S:SALESMAN_AGENT;I\SMAN;I\AGENT    I:I\AGENT;=;  S:SALESMAN;I\SMAN
1 0.0 CMD 7 C -1 471, 253
  
1 0.0 CMD 3 C -1 471, 205
$SELECT  S:SECTION;I\SECT
1 0.0 CMD 18 C -1 471, 97
$SELECT  S:AGENT_CODE;I\AGENT
1 0.0 Work 12 G -1 11, 241
  
1 0.0 H -1 0, 0
  
1 0.0 H -1 0, 0
  
1 0.0 Work 1 I -1 361, 289
$SELECT  I:I\AGENT;<>;  S:SALESMAN_AGENT;I\SMAN;I\AGENT    I:I\AGENT;=;  S:SALESMAN;I\SMAN    $VALIDATE  I:I\SMAN;<>;  DO(03)    I:I\AGENT;<>;    DO(AG)      F:SALESMAN_MAST;Y;;T\BNAME=SLS_NAME;SLS_CODE='$I\SMAN$' AND SLS_AGENT='$I\AGENT$';I\SMAN    DOEND(AG)        I:I\AGENT;=;    DO(AG)      F:SALESMAN_MAST;Y;;;SLS_C
1 0.0 Work 2 I -1 361, 361
$VALIDATE  C:UCASE  I:I\WAYBILL;<>;  F:STK_MAST;Y;;;SM_MARKET='$I\MARKET$' AND SM_WAYBILLNO='$I\WAYBILL$' AND (SM_FINPDTE='' OR ISNULL(SM_FINPDTE));I\WAYBILL
1 0.0 Work 3 I -1 361, 325
$SELECT  S:ITEM_NEW;I\ITEM    $VALIDATE    C:UCASE    I:I\ITEM;<>;  DO(OPA)    A:LEN;I\ITEM;W\LEN    A:LEFT;I\ITEM,2;W\PROD    I:W\LEN;>;2    DO(ITM)      F:STK_DETS;Y;;;SD_ITEM = '$I\ITEM$';;;  ITEM DOES NOT EXIST      F:VAR_MAST;;;T\DESC=VA_DESC;VA_PRODUCT=LEFT('$I\ITEM$',2) AND VA_VARIETY=RIGHT('$I\ITEM$',2);    DOE
1 0.0 Work 2 I -1 361, 385
$VALIDATE    I:I\START_TIME;<>;  DO(1)   'CHECK THAT THE THIRD DIGIT IS A ":"   A:MID;I\START_TIME,3,1;I\TMP1     I:I\TMP1;<>;:    D:ENTER IN FORMAT XX:XX;ERRORM;I\START_TIME     'CHECK THAT THE FIRST TWO DIGITS ARE BETWEEN 00 AND 24   A:LEFT;I\START_TIME,2;I\TMP1     I:I\TMP1;>;23    D:CANNOT BE GREATER THAN 23:59;ERR
1 0.0 Work 3 I -1 361, 253
$SELECT  S:PROVINCE;I\PROV    $VALIDATE  C:UCASE  I:I\PROV;<>;  DO(PRV)  F:PROV_MAST;Y;;T\PROV_DESC=PR_DESC;PR_PROV='$I\PROV$';I\PROV  DOEND(PRV)
1 0.0 OPT I -1 361, 445
$CALCULATE  C:UCASE    V:D;P;    I:I\OPT;=;  A:CONST;D;I\OPT    O:BACKCOLOR;C\RUN;YELLOW  O:SETFOCUS;C\RUN  
1 0.0 Work 1 I -1 361, 217
$VALIDATE    O:BACKCOLOR;C\RUN;YELLOW  O:SETFOCUS;C\RUN
1 0.0 Work 2 I -1 361, 205
$SELECT  S:SECTION;I\SECT    $VALIDATE  C:UCASE  I:I\SECT;<>;  DO(SEC)  F:SECT_MAST;Y;;T\SECTNAME=SE_DESC;SE_SECT='$I\SECT$';I\SECT  DOEND(SEC)    I:I\SECT;=;  A:CONST;ALL;I\SECT      'I:I\MARKET;=;15  'DO(1)  '  O:BACKCOLOR;C\RUN;YELLOW  '  O:SETFOCUS;C\RUN  'DOEND(1)
1 0.0 Work 1 I 0 11, 313
  
1 0.0 Work 2 I 0 31, 313
  
1 0.0 AGENT I -1 361, 97
$SELECT  S:AGENT_CODE;I\AGENT    $CALCULATE  A:CONST;;T\PROG  I:I\AGENT;<>;  DO(LSS)  C:UCASE  F:AGENT_MAST;Y;;T\NAME=AM_NAME;AM_CODE='$I\AGENT$'  DOEND(LSS)
1 0.0 SDATE I -1 361, 133
$CALCULATE  A:CONST;;T\PROG  M:  
1 0.0 EDATE I -1 361, 169
$CALCULATE  A:CONST;;I\ALLOW  M:  I:I\CM_ALLOW_MNTH_REPORT;<>;1  DO(CHK)   U:FIX_LOC_TRANS;REPORTS_TIME_CHECK;I\SDATE,I\EDATE   I:I\ALLOW;=;N    DO(01)     O:SETFOCUS;I\SDATE    DOEND(01)  DOEND(CHK)      I:I\MARKET;<>;22  DO(1)    I:I\MARKET;=;15    DO(2)      O:SETFOCUS;I\SECT    DOEND(2)  DOEND(1)
1 0.0 Work 9 I 0 11, 337
  
1 0.0 MARKET I 0 1, 61
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\CM_ALLOW_MNTH_REPORT=CM_ALLOW_MNTH_REPORT    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MARKET    'INITIALIZES THE DATE AND TIME INTO THE T\DATE AND T\TIME FIELDS  A:DATE;DD MMM YYYY;
1 0.0 Work 4 I -1 581, 385
$VALIDATE    I:I\END_TIME;<>;  DO(2)   A:MID;I\END_TIME,3,1;I\TMP2     I:I\TMP2;<>;:     D:ENTER IN FORMAT XX:XX;ERRORM;I\END_TIME     'CHECK THAT THE FIRST TWO DIGITS ARE BETWEEN 00 AND 24   A:LEFT;I\END_TIME,2;I\TMP2     I:I\TMP2;>;23    D:CANNOT BE GREATER THAN 23:59;ERRORM;I\END_TIME     'CHECK THAT THE LAST TWO DI
1 0.0 Work 2 I -1 361, 409
$VALIDATE    I:I\ORDER;=;  A:CONST;N;I\ORDER    I:I\ORDER;<>;  C:UCASE  DO(1)    I:I\ORDER;<>;Y    DO(2)      I:I\ORDER;<>;N      D:ENTER ONE OF THE FOLLOWING Y,N OR LEAVE IT BLANK;ERRORM;I\ORDER    DOEND(2)  DOEND(1)  'O:BACKCOLOR;C\RUN;YELLOW  'O:SETFOCUS;C\RUN
1 0.0 ORGS I 0 31, 61
  
1 0.0 Work 10 I 0 11, 361
  
1 0.0 Work 1 I -1 361, 409
$VALIDATE  C:UCASE  V:Y;N;    I:I\DUMP;=;  A:CONST;N;I\DUMP    I:I\DUMP;=;Y  A:CONST;D;I\OPT    O:BACKCOLOR;C\RUN;YELLOW  O:SETFOCUS;C\RUN
1 0.0 Work 5 I 0 11, 541
  
1 0.0 Work 6 I 0 11, 505
  
1 0.0 Work 1 I 0 1, 109
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MKT=CM_NAME    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MKT    I:I\MARKET;<>;15  DO(15)    O:HIDE;I\ADDR3,T\ADDR3    O:SHOW;I\DJOIN,T\DJOIN,T\JOIN  DOEND(15)      I:I\MARKET;=;15  DO(15)    O:HIDE;I
1 0.0 Work 14 I -1 11, 241
  
1 0.0 Work 15 I -1 61, 241
  
1 0.0 Work 2 I -1 341, 241
  
1 0.0 Work 2 I -1 441, 241
  
1 0.0 Work 4 I -1 381, 157
$VALIDATE    C:UCASE    I:I\MARKET;=;15  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\CODE,I\NAME,I\ADDR1,I\ADDR2,I\ADDR3,I\PCODE,I\DJOIN:H,I\TELNO    I:I\MARKET;<>;15  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\CODE,I\NAME,I\ADDR1,I\ADDR2,I\ADDR3:H,I\PCODE,I\DJOIN,I\TELNO    I:I\TELNO_CELLNO;<>;  DO(1)  A:CONST;SEARCHING FOR MATCHING SUP
1 0.0 Work 2 I -1 591, 241
  
1 0.0 Work 1 I -1 241, 241
  
1 0.0 Work 13 I 0 1, 73
$DEFAULT  A:TIME;HH:MM:SS;T\TIME  A:DATE;DD MMM YYYY;T\DATE  A:TIMER_ON;1000    I:I\MARKET;=;15  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\CODE,I\NAME,I\ADDR1,I\ADDR2,I\ADDR3,I\PCODE,I\DJOIN:H,I\TELNO    I:I\MARKET;<>;15  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\CODE,I\NAME,I\ADDR1,I\ADDR2,I\ADDR3:H,I\PCODE,I\DJOIN,I\TELNO
1 0.0 Work 1 I -1 381, 133
$VALIDATE    C:UCASE    I:I\MARKET;=;15  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\CODE,I\NAME,I\ADDR1,I\ADDR2,I\ADDR3,I\PCODE,I\DJOIN:H,I\TELNO    I:I\MARKET;<>;15  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\CODE,I\NAME,I\ADDR1,I\ADDR2,I\ADDR3:H,I\PCODE,I\DJOIN,I\TELNO    I:I\ADDR_SEARCH;<>;  DO(1)  A:CONST;SEARCHING FOR MATCHING SUPP
1 0.0 Work 7 I -1 691, 241
  
1 0.0 Work 9 I -1 381, 109
$VALIDATE    C:UCASE    I:I\MARKET;=;15  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\CODE,I\NAME,I\ADDR1,I\ADDR2,I\ADDR3,I\PCODE,I\DJOIN:H,I\TELNO    I:I\MARKET;<>;15  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\CODE,I\NAME,I\ADDR1,I\ADDR2,I\ADDR3:H,I\PCODE,I\DJOIN,I\TELNO    I:I\SUPPLIER;<>;  DO(1)  A:CONST;SEARCHING FOR MATCHING SUPPLIE
1 0.0 Work 4 I -1 541, 241
  
1 0.0 Label 4 T -1 231, 289
  
1 0.0 Label 5 T -1 231, 325
  
1 0.0 Label 6 T -1 231, 361
  
1 0.0 Label 1 T -1 1, 25
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 3 T -1 291, 49
  
1 0.0 Label 8 T -1 231, 97
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 Label 6 T -1 621, 49
  
1 0.0 Label 4 T -1 621, 25
  
1 0.0 Label 5 T -1 671, 25
  
1 0.0 Label 9 T -1 231, 133
  
1 0.0 Label 10 T -1 231, 169
  
1 0.0 Label 11 T -1 411, 505
  
1 0.0 Label 4 T -1 231, 253
  
1 0.0 Label 7 T -1 511, 289
  
1 0.0 Label 12 T -1 511, 325
  
1 0.0 Label 1 T -1 231, 445
  
1 0.0 Label 1 T -1 231, 205
  
1 0.0 Label 2 T 0 231, 217
  
1 0.0 Label 1 T -1 231, 217
  
1 0.0 Label 3 T -1 471, 385
  
1 0.0 Label 1 T -1 231, 409
  
1 0.0 Label 6 T -1 511, 253
  
1 0.0 Label 17 T -1 511, 97
  
1 0.0 Label 4 T -1 511, 205
  
1 0.0 Label 1 T -1 231, 385
  
1 0.0 Label 2 T -1 231, 409
  
1 0.0 Label 1 T -1 291, 25
  
1 0.0 Label 6 T -1 691, 217
  
1 0.0 Label 3 T -1 671, 25
  
1 0.0 Label 4 T -1 671, 49
  
1 0.0 Label 8 T -1 241, 109
  
1 0.0 Label 7 T -1 621, 49
  
1 0.0 Label 5 T -1 1, 25
  
1 0.0 Label 6 T -1 621, 25
  
1 0.0 Label 1 T -1 591, 217
  
1 0.0 Label 2 T -1 311, 49
  
1 0.0 Label 2 T -1 241, 133
  
1 0.0 Label 16 T -1 71, 217
  
1 0.0 Label 17 T -1 11, 217
  
1 0.0 Label 3 T -1 241, 157
  
1 0.0 Label 1 T -1 251, 217
  
1 0.0 Label 2 T -1 351, 217
  
1 0.0 Label 5 T -1 451, 217
  
1 0.0 Label 3 T -1 541, 193
  
1 0.0 Label 4 T -1 541, 217
  
10 0.0 ZX_EXIT Z 0 0, 0
  
10 0.0 ZX_PRINT Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_UPDATE Z 0 0, 0
  
10 0.0 ZX_PRINT Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_UPDATE Z 0 0, 0
  
10 0.0 ZX_EXIT Z 0 0, 0