Freshmark replication server

freshmark-canonical

Program drill-down

INACTIVE_SUPPL_ADDR

INACTIVE SUPPLIER ADDRESS. Type DSP, base table INA_SUPPL_ADDR.

Field inventory

105

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 26 C -1 281, 85
$SELECT  I:I\AGENT;<>;  S:INA_SUPPLIER_MAST;I\SA_CODE;I\AGENT  I:I\AGENT;=;  S:INA_SUPPLIER_MAST;I\SA_CODE
1 0.0 CMD 29 C -1 281, 121
$SELECT  S:ADDR_TYPE;I\SA_TYPE
1 0.0 CMD 1 C -1 241, 265
$SELECT  S:AREA_CODE;I\SA_PCODE  
1 0.0 INA_SUPPL_ADDR ISA_TITLE D -1 531, 193
$DEFAULT  'ADDS ITEMS TO THE DROPDOWN LIST  B:ADDITEM;D\SA_TITLE;MR,MRS,MISS,DR,PROF,REV,    $VALIDATE  C:UCASE  'ONLY ALLOWS THE SPECIFIED VALUES TO BE ENTERED  B:VALIDATE;D\SA_TITLE;MR,MRS,MISS,DR,PROF,REV,
1 0.0 H -1 0, 0
  
1 0.0 INA_SUPPL_ADDR ISA_DEFAULT I -1 181, 157
  $VALIDATE  A:CONST;;W\DEFAULT,W\DEFAULT2,W\DEFAULT3    'CONVERT TEXT CASE INTO UPPER CASE  C:UCASE    'ALLOW ONLY THIS INPUT  V:N;Y      I:I\SA_DEFAULT;=;Y  DO(9)  I:W\DEF;<>;Y    DO(LP)     I:W\DEFAULT2;<>;N       DO(004)         'CALL USER ROUTINE FROM VB CODE POP WINDOW TO SET Y IN DEFAULT FIELD          U:DEFAULT
1 0.0 Work 1 I 0 291, 565
  
1 0.0 Work 1 I 0 21, 565
  
1 0.0 INA_SUPPL_ADDR ISA_ADDR1 I -1 181, 193
$VALIDATE    I:I\SA_DEFAULT;=;Y  M:    'CONVERT TO UPPERCASE  C:UCASE  
1 0.0 INA_SUPPL_ADDR ISA_ADDR2 I -1 181, 217
$VALIDATE  'CONVERT TO UPPERCASE  C:UCASE  
1 0.0 INA_SUPPL_ADDR ISA_ADDR3 I -1 181, 241
$VALIDATE  'CONVERT TO UPPERCASE  C:UCASE  
1 0.0 INA_SUPPL_ADDR ISA_CELLNO I -1 181, 445
$VALIDATE  'ONLY PERFORMS THIS CODE IF FIELD IS NOT LEFT BLANK    I:I\MARKET;<>;L1  DO(NOTL1)  I:I\SA_CELLNO;<>;      DO(CELL)        'PUT THE LENGTH OF THE FIELD INTO TEMP FIELD        A:LEN;I\SA_CELLNO;I\TMP6        I:I\TMP6;<;10        D:CELLPHONE NUMBER CANNOT BE LESS THAN 10 CHARACTERS;ERRORM;I\SA_CELLNO        'C
1 0.0 INA_SUPPL_ADDR ISA_CODE I -1 181, 85
$SELECT  I:I\AGENT;<>;  S:INA_SUPPLIER_MAST;I\SA_CODE;I\AGENT  I:I\AGENT;=;  S:INA_SUPPLIER_MAST;I\SA_CODE    $CALCULATE  F:INA_SUPPL_ADDR;;;I\SA_TYPE=ISA_TYPE;ISA_CODE='$I\SA_CODE$' AND ISA_DEFAULT='Y'    $VALIDATE  A:CONST;;I\SUPLNAME,T\NAME  'MANDATORY FIELD  M:  'CONVERT TO UPPERCASE  C:UCASE    'ZERO FILL THIS FIE
1 0.0 INA_SUPPL_ADDR ISA_EMAIL I -1 181, 469
$VALIDATE  'MANDATORY FIELD    'DO THE FOLLOWING IF THE THIS FIELD IS NOT EMPTY  I:I\SA_EMAIL;<>;     DO(001)     'CHECKS FOR AN '@' SYMBOL IN THE EMAIL ADDRESS     U:NUMBER_VALIDATE;EMAIL_CHK;I\SA_EMAIL,@,I\TMP7     I:I\TMP7;=;N     D:EMAIL ADDRESS MUST CONTAIN THE @ SYMBOL;ERRORM;I\SA_EMAIL    DOEND(001)
1 0.0 INA_SUPPL_ADDR ISA_FAXNO I -1 181, 421
$VALIDATE  'ONLY PERFORMS THIS CODE IF FIELD IS NOT LEFT BLANK  'I:I\SA_FAXNO;<>;     'DO(CKK2)       'PUT THE LENGTH OF THE FIELD INTO TEMP FIELD       'A:LEN;I\SA_FAXNO;I\TMP5       'I:I\TMP5;<;10       'D:FAX NUMBER CANNOT BE LESS THAN 10 CHARACTERS;ERRORM;I\SA_FAXNO       'CLEAR THE TEMP FIELD       'A:CONST;;I\TMP
1 0.0 INA_SUPPL_ADDR ISA_CONT_FNAME I -1 181, 301
$VALIDATE  'MANDATORY FIELD  'M:  'CONVERT TO UPPERCASE  C:UCASE
1 0.0 INA_SUPPL_ADDR ISA_NAME I -1 471, 157
$VALIDATE  'CONVERT TO UPPERCASE  ''TAKEN OUT AS PER CHRISTO'S REQUEST ON 02/07/2021  ''C:UCASE    'I:I\SA_DEFAULT;=;Y  'M:                       CHANGED BY LAZ ON CHRISTO'S REQUEST 30/10/2008
1 0.0 INA_SUPPL_ADDR ISA_PCODE I -1 181, 265
'RK200910  $SELECT  S:AREA_CODE;I\SA_PCODE    $VALIDATE    'RK200910  C:UCASE    'CHECKS IF DEFAULT ADDR, IF SO, MANDATORY  I:I\SA_DEFAULT;=;Y  M:    CHECKS IF THE VALUE ENTERED IS NUMERIC  I:I\SA_PCODE;<>;  DO(1)   A:ISNUMERIC;I\SA_PCODE;I\TMP1     IF IT IS NOT NUMERIC, DISPLAY AN ERROR   I:I\TMP1;=;N   D:POSTAL CODE 
1 0.0 INA_SUPPL_ADDR ISA_CONT_SNAME I -1 181, 325
$VALIDATE  'MANDATORY FIELD  'M:  'CONVERT TO UPPERCASE  C:UCASE
1 0.0 INA_SUPPL_ADDR ISA_TELNO1 I -1 181, 349
$VALIDATE  'ONLY PERFORMS THIS CODE IF FIELD IS NOT LEFT BLANK  'I:I\SA_TELNO1;<>;  'DO(CHKK)     'PUT THE LENGTH OF THE FIELD INTO TEMP FIELD      'A:LEN;I\SA_TELNO1;I\TMP2     'IF LENGTH IS < 10, DISPLAY AN ERROR     'I:I\TMP2;<;10;NUM     'D:PHONE NUMBER CANNOT BE LESS THAN 10 CHARACTERS;ERRORM;I\SA_TELNO1     'CLEA
1 0.0 INA_SUPPL_ADDR ISA_TELNO2 I -1 181, 373
$VALIDATE  'ONLY PERFORM THIS CODE IF FIELD IS NOT LEFT BLANK  'I:I\SA_TELNO2;<>;   ' DO(CCK)      'PUT THWE LENGTH OF THE FIELD INTO A TEMP FIELD    '  A:LEN;I\SA_TELNO2;I\TMP3      'CHECK IF THE LENGTH IS 10, IF NOT DISPLAY AN ERROR     ' I:I\TMP3;<;10;NUM      'D:PHONE NUMBER CANNOT BE LESS THAN 10 CHARACTERS;ERRORM
1 0.0 INA_SUPPL_ADDR ISA_TELNO3 I -1 181, 397
$VALIDATE  'ONLY PERFORMS THIS CODE IF FIELD IS NOT LEFT BLANK  'I:I\SA_TELNO3;<>;     'DO(CCK2)      'PUT THE LENGTH OF THE FIELD INTO TEMP FIELD      'A:LEN;I\SA_TELNO3;I\TMP4      'I:I\TMP4;<;10;NUM      'D:PHONE NUMBER CANNOT BE LESS THAN 10 CHARACTERS;ERRORM;I\SA_TELNO3      'CLEAR THE TEMP FIELD      'A:CONST;;I\
1 0.0 INA_SUPPL_ADDR ISA_TYPE I -1 181, 121
$SELECT  'CALLS THE ADDR_TYPE SELECTION  S:ADDR_TYPE;I\SA_TYPE    $VALIDATE  'A:CONST;;W\DEF  'MANDATORY FIELD  M:      'PUT ZERO AS FIRST CHARACTER  A:LEN;I\SA_TYPE;W\TEMP5  A:ZEROFILL;I\SA_TYPE,2;I\SA_TYPE     'LOOKS UP THE ENTERED VALUE IN THE DATABASE. IF IT DOES NOT EXIST, DISPLAY AN ERROR      F:ADDR_TYPE;Y;AT_CO
1 0.0 Work 25 I 0 31, 49
$DEFAULT    A:DATE;DD MMM/YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000      'A:PARM;1;I\AGENT  'A:PARM;2;I\SA_CODE      $BEFORE_DELETE  I:I\SA_CODE;=;    DO(0003)     I:I\SA_TYPE;=;     I:I\SA_CONT_FNAME;=;     I:I\SA_CONT_SNAME;=;     D:NO RECORD SELECTED TO DELETE;ERRORM;I\SA_CODE     DOEND(0003)      I:I\SA_
1 0.0 Work 3 I 0 61, 565
  
1 0.0 Work 4 I 0 81, 565
  
1 0.0 Work 5 I 0 101, 565
  
1 0.0 Work 6 I 0 41, 565
  
1 0.0 Work 7 I 0 121, 565
  
1 0.0 Work 8 I 0 141, 565
  
1 0.0 SUPPL_ADDR SA_MARKET I 0 11, 49
$DEFAULT  'LOAD MARKET CODE    A:PARM;1;I\AGENT  A:PARM;1;I\AGENT1  A:PARM;2;I\SA_CODE      A:ORG;;I\MARKET  I:I\AGENT;=;  DO(AGR)    A:ORGS;;I\AGENT    A:ORGS;;I\AGENT1  DOEND(AGR)    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME  C:MCASE;;T\MARKET    'TEST!!!!!!!!!  'U:GBL_AUDIT;OFF    'TEST!!!!!!!!!  U
1 0.0 Work 1 I 0 161, 565
  
1 0.0 Work 2 I 0 191, 565
  
1 0.0 Work 2 I 0 251, 541
  
1 0.0 Work 1 I 0 221, 565
  
1 0.0 Work 2 I 0 261, 565
  
1 0.0 Work 3 I 0 321, 565
  
1 0.0 Work 1 I 0 1, 553
  
1 0.0 Work 2 I 0 291, 541
  
1 0.0 INA_SUPPL_ADDR ISA_GPSE I 0 551, 529
  
1 0.0 INA_SUPPL_ADDR ISA_GPSS I 0 521, 529
$BEFORE_WRITE    'CONCATINATE GPS CO-ORDINATES SOUTH  A:CON;W\S1,W\S2;I\SA_GPSS;W\S3    'CONCATINATE GPS CO-ORDINATES EAST  A:CON;W\E1,W\E2;I\SA_GPSE;W\E3  ==========================================================================================================  ========================================================
1 0.0 Work 2 I 0 341, 541
  
1 0.0 Work 1 I 0 121, 49
  
1 0.0 Work 1 I 0 641, 217
  
1 0.0 Work 2 I 0 681, 217
  
1 0.0 Work 3 I 0 721, 217
  
1 0.0 Work 4 I 0 641, 241
  
1 0.0 Work 5 I 0 681, 241
  
1 0.0 Work 6 I 0 721, 241
  
1 0.0 Work 8 I 0 441, 529
  
1 0.0 Work 9 I 0 481, 529
  
1 0.0 INA_SUPPL_ADDR ISA_FAX_EMAIL I 0 181, 493
$VALIDATE  I:I\SA_FAX_EMAIL;=;  A:CONST;F;I\SA_FAX_EMAIL    C:UCASE    V:F;E;
1 0.0 SUPLNAME I 0 551, 529
  
1 0.0 AGENT I 0 71, 49
  
1 0.0 Work 2 I 0 171, 49
  
1 0.0 Work 3 I 0 221, 49
  
1 0.0 Work 1 I 0 371, 565
  
1 0.0 Work 1 I 0 71, 73
  
1 0.0 Label 5 T -1 1, 157
  
1 0.0 INA_SUPPL_ADDR ISA_ADDR1 T -1 1, 193
  
1 0.0 INA_SUPPL_ADDR ISA_CELLNO T -1 1, 445
  
1 0.0 INA_SUPPL_ADDR ISA_CODE T -1 1, 85
  
1 0.0 INA_SUPPL_ADDR ISA_EMAIL T -1 1, 469
  
1 0.0 INA_SUPPL_ADDR ISA_FAXNO T -1 1, 421
  
1 0.0 INA_SUPPL_ADDR ISA_CONT_FNAME T -1 1, 301
  
1 0.0 INA_SUPPL_ADDR ISA_NAME T -1 321, 157
  
1 0.0 INA_SUPPL_ADDR ISA_PCODE T -1 1, 265
  
1 0.0 INA_SUPPL_ADDR ISA_CONT_SNAME T -1 1, 325
  
1 0.0 INA_SUPPL_ADDR ISA_TELNO1 T -1 1, 349
  
1 0.0 INA_SUPPL_ADDR ISA_TELNO2 T -1 1, 373
  
1 0.0 INA_SUPPL_ADDR ISA_TELNO3 T -1 1, 397
  
1 0.0 INA_SUPPL_ADDR ISA_TITLE T -1 441, 193
  
1 0.0 INA_SUPPL_ADDR ISA_TYPE T -1 1, 121
  
1 0.0 Label 18 T -1 1, 25
  
1 0.0 Label 19 T -1 291, 25
  
1 0.0 Label 20 T -1 271, 49
  
1 0.0 Label 21 T -1 621, 49
  
1 0.0 Label 22 T -1 621, 25
  
1 0.0 Label 23 T -1 671, 49
  
1 0.0 Label 24 T -1 671, 25
  
1 0.0 Label 9 T -1 321, 85
  
1 0.0 Label 11 T -1 321, 121
  
1 0.0 Label 1 T -1 451, 277
  
1 0.0 Label 2 T -1 451, 313
  
1 0.0 Label 3 T -1 451, 493
  
1 0.0 Label 13 T -1 451, 421
  
1 0.0 Label 14 T -1 451, 445
  
1 0.0 Label 17 T -1 451, 373
  
1 0.0 Label 7 T 0 641, 193
  
1 0.0 Label 1 T 0 1, 493
  
1 1.0 CMD 18 C -1 741, 373
'$SCMD_FOCUS  'O:SETFOCUS;C\CALC  '0:BACKCOLOR;C\CALC;YELLOW    $SELECT  'U:CALCULATE_GPS;CALC_GPS      U:CALCULATE_GPS_DISTANCE;CALC_GPS_DISTANCE;W\S1,W\S2,W\S3,W\E1,W\E2,W\E3,W\MS1,W\MS2,W\MS3,W\ME1,W\ME2,W\ME3  O:SETFOCUS;I\SA_ROAD_DIST  
1 1.0 Work 4 I -1 641, 277
$VALIDATE  I:W\S1;=;  A:CONST;00;W\S1  A:ZEROFILL;W\S1,2,W\S1
1 1.0 Work 5 I -1 681, 277
$VALIDATE  I:W\S2;=;  A:CONST;00;W\S2  A:ZEROFILL;W\S2,2,W\S2
1 1.0 Work 6 I -1 721, 277
$VALIDATE  I:W\S3;=;  A:CONST;00;W\S3  A:ZEROFILL;W\S3,2,W\S3
1 1.0 Work 7 I -1 641, 313
$VALIDATE  I:W\E1;=;  A:CONST;00;W\E1  A:ZEROFILL;W\E1,2,W\E1
1 1.0 Work 8 I -1 681, 313
$VALIDATE  I:W\E2;=;  A:CONST;00;W\E2  A:ZEROFILL;W\E2,2,W\E2
1 1.0 Work 9 I -1 721, 313
$VALIDATE  I:W\E3;=;  A:CONST;00;W\E3  A:ZEROFILL;W\E3,2,W\E3    'O:SETFOCUS;C\CALC      '$CALCULATE  'U:CALCULATE_GPS_DISTANCE;CALC_GPS_DISTANCE;W\S1,W\S2,W\S3,W\E1,W\E2,W\E3,W\MS1,W\MS2,W\MS3,W\ME1,W\ME2,W\ME3
1 1.0 SUPPL_ADDR SA_GGAP I -1 641, 493
  
1 1.0 SUPPL_ADDR SA_SLINE_DIST I -1 641, 421
  
1 1.0 SUPPL_ADDR SA_ROAD_DIST I -1 641, 445
  
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