Freshmark replication server

freshmark-canonical

Program drill-down

LOCATION_TYPE_MAN

LOCATION TYPE MAINTENANCE. Type MDL, base table LOCATION_TYPE.

Field inventory

24

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 H -1 0, 0
  
1 0.0 LOCATION_TYPE LC_DESC T -1 271, 193
  
1 0.0 LOCATION_TYPE LC_TYPE I -1 191, 217
$SELECT  'ALLOW THE USER TO PRESS 'F5' TO VIEW SELECTION WINDOW  S:LOCATION_TYPE;I\LC_TYPE    $VALIDATE  'MAKE THIS FIELD A MANDATORY FIELD  M:  'CONVERT THE VALUES ENTERED TO UPPERCASE  C:UCASE  
1 0.0 LOCATION_TYPE LC_TYPE T -1 191, 193
  
1 0.0 LOCATION_TYPE LC_DESC I -1 271, 217
$CALCULATE  'U:ZZGRID_SPLIT;SCREEN_TO_GRID;G\GRID1;I\LC_TYPE    $VALIDATE  'MAKE THIS FIELD A MANDATORY FIELD  M:  'CONVERT THE VALUES ENTERED TO UPPERCASE  C:UCASE    'REMOVE EMPTY SPACES ON EOTHER SIDE  A:TRIM;I\LC_DESC;I\LC_DESC    'CLEAR FIELDS  A:CONST;;W\TEMP1  A:CONST;;W\TEMP2    'CHECK IF CODE ALREADY EXISTS  U
1 0.0 Work 3 G -1 191, 241
  
1 0.0 CMD 4 C -1 241, 217
$SELECT  'ALLOW THE USER TO PRESS 'F5' TO VIEW SELECTION WINDOW  S:LOCATION_TYPE;I\LC_TYPE
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 281, 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\GRID1;I\LC_TYPE,I\LC_DESC  U:ZZGRID_SPLIT;DB_TO_GRID;G\GRID1;LOCATION_TYPE        'NOT ALLOWING  USERS TO DELETE AN EMPTY FIELDS  $BEFORE_DELETE  'LOOK UP FOR LOCATION TYPE IN LOCATION_MAST TABLE,IF IT IS EXIST 
1 0.0 Work 5 I 0 291, 397
  
1 0.0 Work 6 I 0 331, 397
  
1 0.0 Work 10 I 0 61, 61
$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 3 I 0 391, 397
  
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