Freshmark replication server

freshmark-canonical

Program drill-down

DELIVERY_TYPE_MAN

DELIVERY TYPE MAINTENANCE. Type MDL, base table DELIVERY_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 DELIVERY_TYPE DT_TYPE I -1 191, 217
'SELECTING DT_CODE FROM DELIVERY_TYPE TABLE  $SELECT  S:DT_TYPE;I\DT_TYPE    'CHANGING CASE TO UPPER CASE AND THIS MUST BE MANDATORY  $VALIDATE  M:  C:UCASE    
1 0.0 DELIVERY_TYPE DT_TYPE T -1 191, 193
  
1 0.0 DELIVERY_TYPE DT_DESC I -1 271, 217
$VALIDATE  M:  C:UCASE      'CODE TO ENSURE THAT THE DESCRIPTION DOES NOT ALREADY EXIST IN THE GRID  'CLEAR FIELDS  A:CONST;;W\TEMP1  A:CONST;;W\TEMP2    'CHECK IF CODE ALREADY EXISTS  U:PALLET_TYPE;CODE_CHECK;I\DT_TYPE,G\DELIVERY,W\TEMP1,I\DT_DESC      I:W\TEMP1;=;N  U:PALLET_TYPE;DESC_CHECK;I\DT_DESC,G\DELIVERY,W\TEM
1 0.0 DELIVERY_TYPE DT_DESC T -1 271, 193
  
1 0.0 Work 3 G -1 191, 241
  
1 0.0 CMD 4 C -1 241, 217
'SELECTING DT_CODE FROM DELIVERY_TYPE TABLE  $SELECT  S:DT_TYPE;I\DT_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 275, 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\DELIVERY;I\DT_TYPE,I\DT_DESC  U:ZZGRID_SPLIT;DB_TO_GRID;G\DELIVERY;DELIVERY_TYPE          $BEFORE_DELETE    'NOT ALLOW USERS TO DELETE WHILE THESE FIELDS ARE EMPTY  I:I\DT_TYPE;=;    DO(LP1)      I:I\DT_DESC;=; 
1 0.0 Work 1 I 0 331, 433
  
1 0.0 Work 2 I 0 381, 433
  
1 0.0 Work 3 I 0 241, 121
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MARKET
1 0.0 Work 1 I 0 431, 433
  
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