Freshmark replication server

freshmark-canonical

Program drill-down

CHARGE_TYPE_MAN

CHARGE TYPE MAINTENANCE. Type MAN, base table CHARGE_TYPE.

Field inventory

23

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 CHARGE_TYPE CTP_TYPE I -1 171, 205
$SELECT  S:CHARGE;I\CTP_TYPE    $VALIDATE  M:  C:UCASE    A:ISNUMERIC;I\CTP_TYPE;I\TMP2  I:I\TMP2;=;Y  A:VAR;I\CTP_TYPE;I\CTP_TYPE;;00  
1 0.0 CHARGE_TYPE CTP_TYPE T -1 171, 181
  
1 0.0 CHARGE_TYPE CTP_DESC I -1 271, 205
$VALIDATE  M:  C:UCASE    F:CHARGE_TYPE;;CTP_DESC;I\TMP1=CTP_TYPE;CTP_TYPE<>'$I\CTP_TYPE$'  I:I\TMP1;<>;  D:THAT DESCRIPTION ALREADY EXISTS;ERRORM;I\CTP_DESC
1 0.0 CHARGE_TYPE CTP_DESC T -1 271, 181
  
1 0.0 Work 4 I 0 21, 85
$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    U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\CTP_TYPE,I\CTP_DESC  U:ZZGRID_SPLIT;DB_TO_GRID;G\GRID;CHARGE_TYPE    
1 0.0 Work 5 I 0 61, 85
$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 Label 6 T -1 1, 25
  
1 0.0 Label 7 T -1 291, 25
  
1 0.0 Label 8 T -1 281, 49
  
1 0.0 Label 9 T -1 621, 25
  
1 0.0 Label 10 T -1 671, 25
  
1 0.0 Label 11 T -1 621, 49
  
1 0.0 Label 12 T -1 671, 49
  
1 0.0 Work 13 I 0 51, 529
  
1 0.0 Work 14 G -1 171, 229
  
1 0.0 CMD 16 C -1 241, 205
$SELECT  S:CHARGE;I\CTP_TYPE
1 0.0 Work 1 I 0 91, 529
  
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