Program drill-down
SUPPL_ADDR
SUPPLIER ADDRESS. Type MAN, base table SUPPL_ADDR.
Field inventory
105
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | SUPPL_ADDR | SA_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 | Label 5 | T | -1 | 1, 157 | ||
| 1 | 0.0 | Work 1 | I | 0 | 291, 565 | ||
| 1 | 0.0 | Work 1 | I | 0 | 21, 565 | ||
| 1 | 0.0 | SUPPL_ADDR | SA_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 | SUPPL_ADDR | SA_ADDR1 | I | -1 | 181, 193 | $VALIDATE I:I\SA_DEFAULT;=;Y M: 'CONVERT TO UPPERCASE C:UCASE |
| 1 | 0.0 | SUPPL_ADDR | SA_ADDR1 | T | -1 | 1, 193 | |
| 1 | 0.0 | SUPPL_ADDR | SA_ADDR2 | I | -1 | 181, 217 | $VALIDATE 'CONVERT TO UPPERCASE C:UCASE |
| 1 | 0.0 | SUPPL_ADDR | SA_ADDR3 | I | -1 | 181, 241 | $VALIDATE 'CONVERT TO UPPERCASE C:UCASE |
| 1 | 0.0 | SUPPL_ADDR | SA_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 | SUPPL_ADDR | SA_CELLNO | T | -1 | 1, 445 | |
| 1 | 0.0 | SUPPL_ADDR | SA_CODE | I | -1 | 181, 85 | $SELECT I:I\AGENT;<>; S:SUPPLIER_MAST1;I\SA_CODE;I\AGENT I:I\AGENT;=; S:SUPPLIER_MAST;I\SA_CODE $CALCULATE F:SUPPL_ADDR;;;I\SA_TYPE=SA_TYPE;SA_CODE='$I\SA_CODE$' AND SA_DEFAULT='Y' $VALIDATE A:CONST;;I\SUPLNAME,T\NAME 'MANDATORY FIELD M: 'CONVERT TO UPPERCASE C:UCASE 'ZERO FILL THIS FIELD TO SIX DIGI |
| 1 | 0.0 | SUPPL_ADDR | SA_CODE | T | -1 | 1, 85 | |
| 1 | 0.0 | SUPPL_ADDR | SA_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 | SUPPL_ADDR | SA_EMAIL | T | -1 | 1, 469 | |
| 1 | 0.0 | SUPPL_ADDR | SA_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 | SUPPL_ADDR | SA_FAXNO | T | -1 | 1, 421 | |
| 1 | 0.0 | SUPPL_ADDR | SA_CONT_FNAME | I | -1 | 181, 301 | $VALIDATE 'MANDATORY FIELD 'M: 'CONVERT TO UPPERCASE C:UCASE |
| 1 | 0.0 | SUPPL_ADDR | SA_CONT_FNAME | T | -1 | 1, 301 | |
| 1 | 0.0 | SUPPL_ADDR | SA_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 | SUPPL_ADDR | SA_NAME | T | -1 | 321, 157 | |
| 1 | 0.0 | SUPPL_ADDR | SA_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 | SUPPL_ADDR | SA_PCODE | T | -1 | 1, 265 | |
| 1 | 0.0 | SUPPL_ADDR | SA_CONT_SNAME | I | -1 | 181, 325 | $VALIDATE 'MANDATORY FIELD 'M: 'CONVERT TO UPPERCASE C:UCASE |
| 1 | 0.0 | SUPPL_ADDR | SA_CONT_SNAME | T | -1 | 1, 325 | |
| 1 | 0.0 | SUPPL_ADDR | SA_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 | SUPPL_ADDR | SA_TELNO1 | T | -1 | 1, 349 | |
| 1 | 0.0 | SUPPL_ADDR | SA_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 | SUPPL_ADDR | SA_TELNO2 | T | -1 | 1, 373 | |
| 1 | 0.0 | SUPPL_ADDR | SA_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 | SUPPL_ADDR | SA_TELNO3 | T | -1 | 1, 397 | |
| 1 | 0.0 | SUPPL_ADDR | SA_TITLE | T | -1 | 441, 193 | |
| 1 | 0.0 | SUPPL_ADDR | SA_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 | SUPPL_ADDR | SA_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 | 321, 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 | 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 | CMD 26 | C | -1 | 281, 85 | $SELECT I:I\AGENT;<>; S:SUPPLIER_MAST1;I\SA_CODE;I\AGENT I:I\AGENT;=; S:SUPPLIER_MAST;I\SA_CODE |
|
| 1 | 0.0 | CMD 29 | C | -1 | 281, 121 | $SELECT S:ADDR_TYPE;I\SA_TYPE |
|
| 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 | Label 9 | T | -1 | 321, 85 | ||
| 1 | 0.0 | Label 11 | T | -1 | 321, 121 | ||
| 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!!!!!!!!! |
| 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 | 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 | SUPPL_ADDR | SA_GPSE | I | 0 | 551, 529 | |
| 1 | 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 ========================================================================================================== ======================================================== |
| 1 | 0.0 | Work 2 | I | 0 | 341, 541 | ||
| 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 | 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 | Label 7 | T | 0 | 641, 193 | ||
| 1 | 0.0 | Work 8 | I | 0 | 441, 529 | ||
| 1 | 0.0 | Work 9 | I | 0 | 481, 529 | ||
| 1 | 0.0 | Label 1 | T | 0 | 1, 493 | ||
| 1 | 0.0 | SUPPL_ADDR | SA_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 | CMD 1 | C | -1 | 241, 265 | $SELECT S:AREA_CODE;I\SA_PCODE |
|
| 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 | 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 | |
| 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 |
|
| 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 |