Freshmark replication server

freshmark-canonical

Program drill-down

ADDR_TYPE

ADDRESS TYPE. Type MDL, base table ADDR_TYPE.

Field inventory

27

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Work 1 I 0 181, 493
  
1 0.0 Work 2 I 0 141, 493
  
1 0.0 H -1 1, 1
  
1 0.0 ADDR_TYPE AT_CODE I -1 191, 217
$SELECT  'ALLOW THE USER TO PRESS F5 TO VIEW A SELECTION WINDOW  S:ADDR_TYPE;I\AT_CODE    $VALIDATE  'MAKE THIS FIELD A MANDATORY FIELD  M:  'CONVERT TO UPERCASE  C:UCASE    'PUT ZERO AS FIRST CHARACTER  I:I\AT_CODE;<>;  A:LEN;I\AT_CODE;W\TEMP3  I:W\TEMP3;=;1  DO(LL)    A:ISNUMERIC;I\AT_CODE;W\TEMP4    I:W\TEMP4;=;Y   
1 0.0 ADDR_TYPE AT_CODE T -1 191, 193
  
1 0.0 ADDR_TYPE AT_DESC I -1 271, 217
$VALIDATE  'MAKE THIS FIELD A MANDATORY FIELD  M:  'CONVERT TO UPERCASE  C:UCASE    'REMOVE EMPTY SPACES ON EOTHER SIDE  A:TRIM;I\AT_DESC;I\AT_DESC      'CLEAR FIELDS  A:CONST;;W\TEMP1  A:CONST;;W\TEMP2    'CHECK IF CODE ALREADY EXISTS  U:PALLET_TYPE;CODE_CHECK;I\AT_CODE,G\ADDRESS,W\TEMP1,I\AT_DESC    I:W\TEMP1;=;N  U:
1 0.0 ADDR_TYPE AT_DESC T -1 271, 193
  
1 0.0 Work 3 G -1 191, 241
  
1 0.0 CMD 4 C -1 241, 217
$SELECT  'ALLOW THE USER TO PRESS LOOKUP BUTTON TO VIEW A SELECTION WINDOW  S:ADDR_TYPE;I\AT_CODE
1 0.0 Label 5 T -1 1, 25
  
1 0.0 Label 6 T -1 291, 25
  
1 0.0 Label 7 T -1 331, 49
  
1 0.0 Label 8 T -1 621, 49
  
1 0.0 Label 9 T -1 621, 25
  
1 0.0 Label 10 T -1 671, 49
  
1 0.0 Label 11 T -1 671, 25
  
1 0.0 Work 12 I 0 211, 121
$DEFAULT    A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    U:ZZGRID_SPLIT;INIT_GRID;G\ADDRESS;I\AT_CODE,I\AT_DESC  U:ZZGRID_SPLIT;DB_TO_GRID;G\ADDRESS;ADDR_TYPE    $BEFORE_DELETE    I:I\AT_CODE;=;  D:CANNOT DELETE, ADDRESS CODE IS BLANK;ERRORM;I\AT_CODE    I:I\AT_DESC;=;  D:CANNOT DELETE, ADDRESS
1 0.0 Work 1 I 0 31, 85
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME    'CONVERT ONLY THE FIRST CHARACTER OF THE MARKET LABEL  C:MCASE;;T\MARKET    
1 0.0 Work 1 I 0 401, 409
  
1 0.0 Work 2 I 0 451, 409
  
1 0.0 Work 1 I 0 411, 445
  
1 0.0 Work 2 I 0 451, 445
  
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_EXIT Z 0 1, 1
  
10 0.0 ZX_UPDATE Z 0 1, 1