Freshmark replication server

freshmark-canonical

Program drill-down

WHOLESALE_SUP_MAN

WHOLESALE SUPPLIER MAINTENANCE. Type MAN, base table SUPPLIER_MAST.

Field inventory

158

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 71 C 0 141, 529
$SELECT  S:AREA_CODE;I\SUM_AREA
1 0.0 CMD 58 C 0 51, 133
$SELECT  S:CURRENCY;I\SUM_CURRENCY
1 0.0 CMD 78 C 0 750, 535
$SELECT  S:SALESMAN_AGENT;I\SUM_SMAN;I\SUM_AGENT_CODE
1 0.0 CMD 39 C -1 471, 265
$SELECT  S:REASON5;I\SUM_BLK_REASON    
1 0.0 CMD 7 C -1 391, 109
$SELECT  I:I\AGENT;<>;  S:SUPPLIER_MAST1;I\SUM_SUPPL;I\AGENT    I:I\AGENT;=;  S:SUPPLIER_MAST;I\SUM_SUPPL  
1 0.0 H -1 0, 0
  
1 0.0 Work 1 I 0 61, 49
  
1 0.0 Work 10 I 0 181, 61
  
1 0.0 Work 11 I 0 211, 61
  
1 0.0 Work 12 I 0 451, 73
  
1 0.0 Work 13 I 0 61, 73
$DEFAULT    'INITIALIZES THE DATE AND TIME INTO THE T\DATE AND T\TIME FIELDS  A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000          'FIXED BY JD 20130320. THIS WAS NOT TESTED AT ALL!!!  'JER ADD 14032013 B  O:HIDE;I\SUM_SMAN  O:HIDE;T\SUM_SMAM  O:HIDE;T\SUM_SMAMC  O:DISABLEINPUT;I\SUM_SMAM   'JER 
1 0.0 SUPPLIER_MAST SUM_MARKET I 0 81, 73
$DEFAULT  'LOAD MARKET CODE AND AGENT CODE    'A:PARM;3;I\AGENT    A:ORG;;I\MARKET  A:ORGS;;I\AGENT    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\DUMMY_SUPPL=CM_DUMMY_SUPPLIER  C:MCASE;;T\MARKET      A:CONST;;I\SUM_AUTH    I:I\MARKET;<>;18  O:HIDE;I\SUM_MKT_SUPPL,T\SUM_MKT_SUPPL
1 0.0 Work 80 I 0 91, 583
  
1 0.0 AGENT I 0 111, 73
'$DEFAULT  'A:PARM;3
1 0.0 Work 60 I 0 271, 553
  
1 0.0 Work 68 I 0 1, 445
  
1 0.0 SUPPLIER_MAST SUM_SUPPL I -1 311, 109
$DEFAULT  A:PARM;2  A:VAR;I\SUM_SUPPL;I\TMP_SUPPL  O:SHOWUPDATE  $SELECT  I:I\AGENT;<>;  DO(AGN)  I:I\MARKET;<>;60  S:SUPPLIER_MAST1;I\SUM_SUPPL;I\AGENT  I:I\MARKET;=;60  S:SUPPLIER_MAST;I\SUM_SUPPL;I\AGENT      DOEND(AGN)    I:I\AGENT;=;  S:SUPPLIER_MAST;I\SUM_SUPPL      ++++++++++++++++++++++++++++++++++++++  'SELECT
1 0.0 Work 19 I 0 1, 193
  
1 0.0 SUPPLIER_MAST SUM_DATE_ENTERED I -1 651, 205
  
1 0.0 Work 82 I 0 131, 583
  
1 0.0 ZV_CODE I 0 1, 133
$DEFAULT  A:PARM;1    ''''$AFTER_WRITE  ''''I:I\ZV_CODE;<>;  ''''W:ZV_USER_DEFAULTS;Y;;ZV_CODE=I\ZV_CODE,ZV_TEXT=I\SUM_SUPPL;ZV_CODE='$I\ZV_CODE$'    ''''U:WRITE_SUPPL_AGENT;UPDATE    ''''I:I\NEW;=;  'E:$GBLROOT$LEGEND\PROJ_FMS\BIN\MAINMENU.EXE A SUPPL_ADDR $I\AGENT$ $I\SUM_SUPPL$  'O:SETFOCUS;Z\ZX_UPDATE  'O:SHOW;H\PA
1 0.0 SUM_FUZZY I 0 1, 337
  
1 0.0 NEW I 0 151, 577
  
1 0.0 Work 28 I 0 1, 241
  
1 0.0 Work 33 I 0 1, 181
  
1 0.0 SUM_AGENT_CODE I 0 1, 481
  
1 0.0 SUPPLIER_MAST SUM_COUNTRY I -1 311, 421
$VALIDATE  C:UCASE
1 0.0 SUPPLIER_MAST SUM_NAME I -1 311, 169
'JER ADD 08042011 B  $DEFAULT  A:CONST;;W\SUPP_NAME;  'JER ADD 08042011 E      $CALCULATE  M:  ''TAKEN OUT AS PER CHRISTO'S REQUEST ON 02/07/2021  ''C:UCASE    'JER ADD 08042011 B  'O:SETFOCUS;D\SUM_LANGUAGE    I:I\SUM_NAME;<>;      U:SM_UPD_FUZZY;RN_GEN_FUZZY      U:U_SUP_CHECK;BATCH  I:W\SUPP_NAME;=;  DO(001)    U:SM
1 0.0 SUPPLIER_MAST SUM_ID_NO I -1 311, 205
$VALIDATE    A:CONST;;I\TMP2  M:  I:I\SUM_ID_NO;=;TO FOLLOW  A:CONST;;I\SUM_ID_NO    I:I\MARKET;<>;L1  DO(NOTL1)  I:I\SUM_ID_NO;<>;     DO(001)       'PUT THE LENGTH OF THE FIELD INTO TEMP FIELD        A:LEN;I\SUM_ID_NO;I\TMP2       'IF LENGTH IS < 13, DISPLAY AN ERROR       I:I\TMP2;<;13;NUM       D:ID NUMBER CANNOT B
1 0.0 TMP_SUPPL I 0 1, 157
  
1 0.0 Work 34 I 0 761, 283
  
1 0.0 Work 27 I 0 761, 241
  
1 0.0 Work 22 I 0 1, 217
  
1 0.0 Work 83 I 0 211, 583
  
1 0.0 CHARCD I 0 1, 313
  
1 0.0 SUPPLIER_MAST SUM_BLK_REASON I -1 441, 265
$SELECT  S:REASON5;I\SUM_BLK_REASON  M:    $CALCULATE  I:I\SUM_BLK_REASON;<>;    DO(Z88)      M:      C:UCASE      F:REASON_MAST;Y;RSN_REASON;T\REASON=RSN_DESC;RSN_TYPE = 'BL';I\SUM_BLK_REASON    DOEND(Z88)  
1 0.0 Work 84 I 0 281, 583
  
1 0.0 Work 41 I 0 1, 277
  
1 0.0 Work 81 I 0 111, 583
  
1 0.0 FUZZCOUNT I 0 1, 397
  
1 0.0 Work 64 I 0 331, 577
  
1 0.0 Work 79 I 0 1, 517
  
1 0.0 SUPPLIER_MAST SUM_BLOCKED K -1 311, 265
'JER ADD 08042011   $CALCULATE    'JER ADD 08042011 B    I:K\SUM_BLOCKED;=;1      O:ENABLEINPUT;I\SUM_BLK_REASON,C\3     I:K\SUM_BLOCKED;<>;1  DO(001)    A:CONST;;I\SUM_BLK_REASON    A:CONST;;T\REASON    O:DISABLEINPUT;I\SUM_BLK_REASON,C\3    DOEND(001)  
1 0.0 SUPPLIER_MAST SUM_RET_PALL K -1 311, 313
  
1 0.0 SUPPLIER_MAST SUM_SPECULATOR K -1 501, 361
  
1 0.0 SUPPLIER_MAST SUM_COOP_MEMBER K -1 311, 361
  
1 0.0 Label 5 T 0 1, 85
  
1 0.0 Label 3 T -1 1, 25
  
1 0.0 Label 4 T -1 291, 25
  
1 0.0 Label 5 T -1 621, 25
  
1 0.0 Label 6 T -1 671, 25
  
1 0.0 Label 7 T -1 251, 49
  
1 0.0 Label 8 T -1 621, 49
  
1 0.0 Label 9 T -1 671, 49
  
1 0.0 SUM_AREA T 0 1, 505
  
1 0.0 SUM_SUPPL T -1 121, 109
  
1 0.0 Label 59 T 0 1, 133
  
1 0.0 SUM_ID_NO T -1 121, 205
  
1 0.0 Label 40 T -1 501, 265
  
1 0.0 SUM_COUNTRY T -1 121, 421
  
1 0.0 SUM_SPECULATOR T -1 371, 361
  
1 0.0 SUM_NAME T -1 121, 169
  
1 0.0 SUM_BLOCKED T -1 121, 277
  
1 0.0 SUM_LANGUAGE T 0 1, 85
  
1 0.0 Label 17 T -1 541, 205
  
1 0.0 SUM_RET_PALL T -1 121, 313
  
1 0.0 SUM_CURRENCY T 0 1, 145
  
1 0.0 Label 37 T -1 371, 265
  
1 0.0 SUM_COOP_MEMBER T -1 121, 361
  
1 0.0 Label 72 T 0 161, 529
  
1 0.0 Label 1 T -1 121, 241
  
1 0.0 SUPPLIER_MAST SUM_VAT_NO I -1 311, 241
$VALIDATE    'DEFAULT TO 'TO FOLLOW'  I:I\VAT_NUMBER;=;  A:CONST;TO FOLLOW;I\VAT_NUMBER    M:
1 0.0 I 0 121, 481
  
1 0.0 SUPPLIER_MAST SUM_WSALE_SUPPL I 0 131, 457
  
2 0.0 Work 28 I 0 31, 61
  
2 0.0 Work 55 I 0 721, 205
  
2 0.0 CMD 31 C -1 281, 109
$SELECT  I:I\AGENT2;<>;  S:SUPPLIER_MAST1;I\SA_CODE2;I\AGENT2  I:I\AGENT2;=;  S:SUPPLIER_MAST;I\SA_CODE2
2 0.0 CMD 35 C 0 31, 85
$SELECT  S:ADDR_TYPE;I\SA_TYPE2
2 0.0 SA_CODE I -1 181, 109
$SELECT  I:I\AGENT2;<>;  S:SUPPLIER_MAST1;I\SA_CODE2;I\AGENT2  I:I\AGENT2;=;  S:SUPPLIER_MAST;I\SA_CODE2    $CALCULATE  F:SUPPL_ADDR;;;I\SA_TYPE2=SA_TYPE;SA_CODE='$I\SA_CODE2$' AND SA_DEFAULT='Y'    U:SUPPL_ADDR_CHECK;CHECK  $VALIDATE  A:CONST;;I\SUPLNAME2,T\NAME2  'MANDATORY FIELD  M:  'CONVERT TO UPPERCASE  C:UCASE  
2 0.0 Work 54 I 0 681, 205
  
2 0.0 CMD 58 C -1 241, 241
$SELECT  S:AREA_CODE;I\SA_PCODE2  
2 0.0 AGENT2 I 0 71, 49
  
2 0.0 Work 22 I 0 121, 49
  
2 0.0 Work 24 I 0 221, 49
  
2 0.0 Work 23 I 0 171, 49
  
2 0.0 H -1 0, 0
  
2 0.0 Work 11 I 0 21, 565
  
2 0.0 SUPPL_ADDR SA_ADDR1 I -1 181, 169
$VALIDATE    'I:I\SA_DEFAULT2;=;Y  M:    'CONVERT TO UPPERCASE  C:UCASE  
2 0.0 SUPPL_ADDR SA_PCODE I -1 181, 241
'RK200910  $SELECT  S:AREA_CODE;I\SA_PCODE2      $VALIDATE    '''A:VAR;I\SUM_AREA;I\SA_PCODE2      'RK200910  C:UCASE    'CHECKS IF DEFAULT ADDR, IF SO, MANDATORY  'I:I\SA_DEFAULT2;=;Y  M:    CHECKS IF THE VALUE ENTERED IS NUMERIC  I:I\SA_PCODE2;<>;  DO(1)   A:ISNUMERIC;I\SA_PCODE2;I\TMP12     IF IT IS NOT NUMERIC, DIS
2 0.0 SUPPL_ADDR SA_ADDR2 I -1 181, 193
$VALIDATE  'CONVERT TO UPPERCASE  C:UCASE  
2 0.0 SUPPL_ADDR SA_TYPE I -1 181, 133
$SELECT  'CALLS THE ADDR_TYPE SELECTION  ''S:ADDR_TYPE;I\SA_TYPE2    $VALIDATE  'A:CONST;;W\DEF2  'MANDATORY FIELD  M:  I:I\SA_TYPE2;<>;01  D:ENTER ONLY '01' FOR PHYSICAL ADDRESS;ERRORM;I\SA_TYPE2    'PUT ZERO AS FIRST CHARACTER  A:LEN;I\SA_TYPE2;W\TEMP52  A:ZEROFILL;I\SA_TYPE2,2;I\SA_TYPE2     'LOOKS UP THE ENTERED VA
2 0.0 Work 20 I 0 31, 49
$DEFAULT    A:DATE;DD MMM YYYY;T\DATE2  A:TIME;HH:MM:SS;T\TIME2  A:TIMER_ON;1000      'A:PARM;1;I\AGENT2  'A:PARM;2;I\SA_CODE2      ''''$BEFORE_DELETE  ''''I:I\SA_CODE2;=;  ''''  DO(0003)  ''''   I:I\SA_TYPE2;=;  ''''   I:I\SA_CONT_FNAME2;=;  ''''   I:I\SA_CONT_SNAME2;=;  ''''   D:NO RECORD SELECTED TO DELETE;ERRORM;I\
2 0.0 Work 19 I 0 11, 49
$DEFAULT  'LOAD MARKET CODE    A:PARM;1;I\AGENT2  A:PARM;1;I\AGENT12  A:PARM;2;I\SA_CODE2      A:ORG;;I\MARKET2  I:I\AGENT2;=;  DO(AGR)    A:ORGS;;I\AGENT2    A:ORGS;;I\AGENT12  DOEND(AGR)    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET2=CM_NAME  C:MCASE;;T\MARKET2    'TEST!!!!!!!!!  'U:GBL_AUDIT;OFF    'TEST!!!
2 0.0 Work 22 I 0 291, 565
  
2 0.0 Work 51 I 0 721, 169
  
2 0.0 Work 50 I 0 681, 169
  
2 0.0 Work 49 I 0 641, 169
  
2 0.0 SUPPL_ADDR SA_CELLNO I -1 181, 301
  $VALIDATE    'MANDATORY FIELD  M:      'ONLY PERFORMS THIS CODE IF FIELD IS NOT LEFT BLANK    I:I\MARKET2;<>;L1  DO(NOTL1)  I:I\SA_CELLNO2;<>;      DO(CELL)        'PUT THE LENGTH OF THE FIELD INTO TEMP FIELD        A:LEN;I\SA_CELLNO2;I\TMP62        I:I\TMP62;<;10        D:CELLPHONE NUMBER CANNOT BE LESS THAN 10 CHAR
2 0.0 SUPPL_ADDR SA_TELNO2 I 0 11, 73
$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
2 0.0 Work 10 I 0 1, 553
  
2 0.0 SUPPL_ADDR SA_TELNO3 I 0 91, 73
$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\
2 0.0 SUPPL_ADDR SA_ADDR3 I -1 181, 217
$VALIDATE  'CONVERT TO UPPERCASE  C:UCASE  
2 0.0 SUPPL_ADDR SA_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  ==========================================================================================================  ============================================
2 0.0 Work 53 I 0 641, 205
  
2 0.0 Work 8 I 0 291, 541
  
2 0.0 SUPPL_ADDR SA_GPSE I 0 551, 529
  
2 0.0 Work 19 I 0 191, 565
  
2 0.0 Work 21 I 0 261, 565
  
2 0.0 Work 23 I 0 371, 565
  
2 0.0 Work 12 I 0 41, 565
  
2 0.0 SUPPL_ADDR SA_FAXNO I 0 1, 73
$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
2 0.0 Work 2 I 0 481, 525
  
2 0.0 Work 16 I 0 121, 565
  
2 0.0 Work 20 I 0 221, 565
  
2 0.0 Work 3 I 0 441, 529
  
2 0.0 SUPLNAME I 0 551, 529
  
2 0.0 Work 14 I 0 81, 565
  
2 0.0 Work 18 I 0 161, 565
  
2 0.0 Work 7 I 0 251, 541
  
2 0.0 Work 9 I 0 341, 541
  
2 0.0 Work 13 I 0 61, 565
  
2 0.0 Work 15 I 0 101, 565
  
2 0.0 Work 17 I 0 141, 565
  
2 0.0 SUPPL_ADDR SA_ROAD_DIST I 0 651, 97
  
2 0.0 SUPPL_ADDR SA_SLINE_DIST I 0 21, 73
  
2 0.0 Label 18 T -1 671, 25
  
2 0.0 Label 15 T -1 1, 25
  
2 0.0 Label 16 T -1 291, 25
  
2 0.0 Label 17 T -1 621, 25
  
2 0.0 Label 70 T 0 481, 73
  
2 0.0 SA_CODE T -1 1, 109
  
2 0.0 Label 25 T -1 261, 49
  
2 0.0 Label 26 T -1 621, 49
  
2 0.0 Label 27 T -1 671, 49
  
2 0.0 Label 32 T -1 321, 109
  
2 0.0 SA_TYPE T -1 1, 145
  
2 0.0 Label 36 T 0 31, 73
  
2 0.0 Label 37 T 0 31, 73
  
2 0.0 SA_ADDR1 T -1 1, 169
  
2 0.0 Label 47 T 0 641, 133
  
2 0.0 SA_PCODE T -1 1, 241
  
2 0.0 SA_TELNO2 T 0 11, 73
  
2 0.0 SA_TELNO3 T -1 1, 373
  
2 0.0 SA_FAXNO T 0 71, 49
  
2 0.0 Label 74 T 0 461, 73
  
2 0.0 SA_CELLNO T -1 1, 301
  
2 0.0 Label 77 T 0 581, 85
  
2 0.0 Label 1 T -1 1, 337
  
2 0.0 Work 2 I -1 181, 337
  $VALIDATE    'MANDATORY FIELD      'ONLY PERFORMS THIS CODE IF FIELD IS NOT LEFT BLANK    I:I\MARKET2;<>;L1  DO(NOTL1)  I:I\TELNO;<>;      DO(CELL)        'PUT THE LENGTH OF THE FIELD INTO TEMP FIELD        A:LEN;I\TELNO;I\TMP62        I:I\TMP62;<;10        D:TELEPHONE NUMBER CANNOT BE LESS THAN 10 CHARACTERS;ERRORM;
2 0.0 Work 3 I -1 181, 373
$VALIDATE  'MANDATORY FIELD    'DO THE FOLLOWING IF THE THIS FIELD IS NOT EMPTY  I:I\EMAIL_ADD;<>;     DO(001)     'CHECKS FOR AN '@' SYMBOL IN THE EMAIL ADDRESS     U:NUMBER_VALIDATE;EMAIL_CHK;I\SA_EMAIL2,@,I\TMP72     I:I\TMP72;=;N     D:EMAIL ADDRESS MUST CONTAIN THE @ SYMBOL;ERRORM;I\EMAIL_ADD    DOEND(001)
2 0.0 Label 4 T -1 231, 133
  
2 0.0 SA_DEFAULT I 0 1, 409
  
2 2.0 CMD 29 C 0 21, 97
'$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\S12,W\S22,W\S32,W\E12,W\E22,W\E32,W\MS12,W\MS22,W\MS32,W\ME12,W\ME22,W\ME32  O:SETFOCUS;I\SA_ROAD_DIST2  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_EXIT Z 0 0, 0
  
10 0.0 ZX_PRINT Z 0 0, 0
  
10 0.0 ZX_UPDATE Z 0 0, 0
'$SELECT  $BEFORE_WRITE  '$CALCULATE  '$VALIDATE  '$SELECT    A:CONST;Y;I\WSALE  'W:SUPPLIER_MAST;Y;;SUM_MARKET=I\MARKET,SUM_SUPPL=I\SUM_SUPPL;SUM_SUPPL='$I\SUM_SUPPL$'  'W:SUPPLIER_MAST;;;SUM_NAME=I\SUM_NAME,SUM_ID_NO=I\SUM_ID_NO,SUM_RET_PALL=K\SUM_RET_PALL,SUM_COUNTRY=I\SUM_COUNTRY,SUM_COOP_MEMBER=K\SUM_COOP_MEMBER,S