Freshmark replication server

freshmark-canonical

Program drill-down

ADD_SMAN_TO_SECTION

ADD SALESMAN TO SECTION. Type DSP, base table STOCK_EMAIL_SECT.

Field inventory

43

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 23 C -1 351, 109
$SELECT  S:AGENT_CODE;I\SLS_AGENT    
1 0.0 CMD 1 C -1 301, 397
$SELECT  U:MARKET_FUNCTIONS;ADD_SES_SMAN    I:I\ORGS;<>;  DO(AGN)    F:AGENT_MAST;;;T\NAME2=AM_NAME;AM_CODE='$I\ORGS$';    O:DISABLEINPUT;I\SLS_AGENT,C\AGENT    A:CONST;;I\SLS_CODE,T\SALES,I\SLS_SALES_SECT,I\SMAN,I\SES_CONTACT_NAME,I\SES_CONTACT_NO,T\SECT2,T\PROG    O:SETFOCUS;I\SLS_SALES_SECT  DOEND(AGN)    I:I\ORGS;=
1 0.0 H -1 1, 1
  
1 0.0 STOCK_EMAIL_SECT SES_AGENT I -1 301, 109
$SELECT  S:AGENT_CODE;I\SLS_AGENT    $VALIDATE  M:  C:UCASE    $CALCULATE  F:AGENT_MAST;Y;AM_CODE;T\NAME2=AM_NAME;;I\SLS_AGENT
1 0.0 STOCK_EMAIL_SECT SES_CONTACT_NO I -1 301, 253
$VALIDATE    I:I\SES_CONTACT_NO;<>;  DO(1)    A:LEN;I\SES_CONTACT_NO;I\TMP3    I:I\TMP3;<;10;NUM    D:PHONE NUMBER CANNOT BE LESS THAN 10 CHARACTERS;ERRORM;I\SES_CONTACT_NO      U:NUMBER_VALIDATE;TELL_CHK;I\SES_CONTACT_NO,0,I\TMP4      I:I\TMP4;<>;Y    D:FIRST DIGIT MUST BE A "0";ERRORM;I\SES_CONTACT_NO  DOEND(1)    
1 0.0 I 0 11, 505
$SELECT  'S:SALESMAN_AGENT;I\SLS_CODE;I\SLS_AGENT  
1 0.0 Work 1 I -1 301, 181
$CALCULATE  M:  A:CONST;N;I\FOUND    I:I\SMAN;<>;  DO(0)    U:MARKET_FUNCTIONS;CHECK_SMAN      I:I\FOUND;=;Y    D:SALESMAN $I\SMAN$ AREADY ASSIGNED TO THIS SECTION;ERRORM;I\SMAN       O:DISABLEINPUT;I\NEW_SECTION,T\NEW_SECTION    A:CON;I\SLS_CODE,"~";T\PROG;I\SMAN    A:CONST;$T\PROG$;I\SLS_CODE   DOEND(0)    
1 0.0 Work 2 I 0 41, 205
  
1 0.0 STOCK_EMAIL_SECT SES_CONTACT_NAME I -1 301, 217
$VALIDATE  M:  C:UCASE    
1 0.0 Work 1 I 0 41, 157
  
1 0.0 Work 2 I 0 41, 181
  
1 0.0 STOCK_EMAIL_SECT SES_WEEKLY I -1 301, 361
'$BEFORE_WRITE  'I:I\CHOICE;=;N  'U:MARKET_FUNCTIONS;ADD_SES_SMAN    'I:I\CHOICE;=;Y  'U:MARKET_FUNCTIONS;MOVE_SMAN    $VALIDATE  V:Y;N    O:SETFOCUS;C\UPDATE  O:BACKCOLOR;C\UPDATE;YELLOW
1 0.0 Work 1 I 0 31, 61
  
1 0.0 STOCK_EMAIL_SECT SES_AUTORUN I -1 301, 325
$VALIDATE  C:UCASE  V:Y;N
1 0.0 STOCK_EMAIL_SECT SES_SECTION I -1 301, 145
$SELECT  S:SECTIONS;I\SLS_SALES_SECT    $VALIDATE  C:UCASE    I:I\SLS_SALES_SECT;<>;  F:STOCK_EMAIL_SECT;;;I\SLS_CODE=SES_SMAN,T\SALES=SES_CONTACT_NAME;SES_SECTION='$I\SLS_SALES_SECT$';I\SLS_SALES_SECT    I:I\SLS_SALES_SECT;<>;  O:DISABLEINPUT;I\SLS_ITEM_SECT    I:I\SLS_SALES_SECT;=;  DO(ABA)   O:ENABLEINPUT;I\SLS_ITEM
1 0.0 Work 21 I 0 11, 61
$DEFAULT    A:DATE;DD MMM/YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    A:CONST;;T\NAME,T\NAME2  A:SETPWFIELD;I\SLS_PIN_NO  A:SETPWFIELD;I\CONFIRM_SLS_PIN_NO  A:SETPWFIELD;I\NEW_PIN    A:CONST;N;I\SES_AUTORUN,I\SES_WEEKLY,I\CHOICE  A:CONST;2;I\SES_LAYOUT  
1 0.0 STOCK_EMAIL_SECT SES_MARKET I 0 21, 61
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET  A:ORG;;I\SLS_MARKET  A:ORGS;;I\SLS_AGENT    A:VAR;I\SLS_AGENT;I\ORGS    I:I\ORGS;<>;  DO(AGN)    F:AGENT_MAST;;;T\NAME2=AM_NAME;AM_CODE='$I\ORGS$';    O:DISABLEINPUT;I\SLS_AGENT,C\AGENT    O:SETFOCUS;I\SLS_SALES_SECT  DOEND(AGN)      'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CO
1 0.0 STOCK_EMAIL_SECT SES_LAYOUT I -1 301, 289
$VALIDATE  V:1;2;3
1 0.0 Work 1 I 0 41, 253
  
1 0.0 Label 2 T 0 31, 457
  
1 0.0 T -1 141, 109
  
1 0.0 SALESMAN_MAST SLS_CELLNO T -1 141, 253
  
1 0.0 SALESMAN_MAST SLS_CODE T -1 141, 181
  
1 0.0 SALESMAN_MAST SLS_NAME T -1 141, 217
  
1 0.0 SALESMAN_MAST SLS_PIN_NO T -1 141, 361
  
1 0.0 SALESMAN_MAST SLS_PROV_SALES T -1 141, 325
  
1 0.0 SALESMAN_MAST SLS_SALES_SECT T -1 141, 145
  
1 0.0 Label 14 T -1 1, 25
  
1 0.0 Label 15 T -1 291, 25
  
1 0.0 Label 16 T -1 281, 49
  
1 0.0 Label 17 T -1 621, 49
  
1 0.0 Label 18 T -1 621, 25
  
1 0.0 Label 19 T -1 671, 49
  
1 0.0 Label 20 T -1 671, 25
  
1 0.0 Label 6 T -1 391, 109
  
1 0.0 Label 2 T -1 361, 145
  
1 0.0 Label 1 T -1 141, 289
  
1 0.0 Label 2 T 0 31, 481
  
10 0.0 ZX_PRINT Z 0 1, 1
  
10 0.0 ZX_SELECT Z 0 1, 1
  
10 0.0 ZX_DELETE Z 0 1, 1
  
10 0.0 ZX_UPDATE Z 0 1, 1
  
10 0.0 ZX_EXIT Z 0 1, 1