Freshmark replication server

freshmark-canonical

Program drill-down

CLAS_MAN

CLASS MAINTENANCE. Type MAN, base table CLASS_MAST.

Field inventory

32

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Label 2 T -1 581, 169
  
1 0.0 DEFAULT I 0 1, 49
$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\CLASS;I\CL_CLASS,I\CL_DESC,I\CL_ADESC,I\CL_NDACLASS,I\CL_BLOCKED  U:ZZGRID_SPLIT;DB_TO_GRID;G\CLASS;CLASS_MAST    $AFTER_READ  I:I\CL_BLOCKED;=;  A:CONST;N;I\CL_BLOCKED  
1 0.0 Label 6 T -1 671, 49
  
1 0.0 Label 5 T -1 671, 25
  
1 0.0 Label 4 T -1 621, 49
  
1 0.0 Label 3 T -1 621, 25
  
1 0.0 Label 2 T -1 1, 25
  
1 0.0 Label 8 T -1 311, 49
  
1 0.0 Label 1 T -1 291, 25
  
1 0.0 NUMTST I 0 61, 493
  
1 0.0 Work 2 G -1 51, 217
  
1 0.0 CLASS_MAST CL_NDACLASS T -1 581, 145
  
1 0.0 CLASS_MAST CL_NDACLASS I -1 581, 193
$VALIDATE  M:  C:UCASE  A:LEN;I\CL_NDACLASS;I\NDA_LEN  I:I\NDA_LEN;<>;2  D:NDA CLASS MUST BE 2 CHARACTERS;ERRORM;I\CL_NDACLASS  
1 0.0 CLASS_MAST CL_ADESC I -1 351, 193
$VALIDATE  C:UCASE    'A:CONST;;I\TMP1                        DUPLICATE DESCRIPTION VALIDATION COMMENTED BY LAZ BECAUSE MORE THAN ONE USER CAN CHOOSE NOT TO ENTER AN ALT DESCRIPTION  'A:CONST;;I\TMP2    'CALLS A USER FUNCTION WHICH CHECKS IN THE GRID FOR THE USER CODE ENTERED   'U:PALLET_TYPE;CODE_CHECK;I\CL_CLASS,G\CL
1 0.0 CLASS_MAST CL_ADESC T -1 351, 169
  
1 0.0 CMD 5 C -1 91, 193
$SELECT  S:CLASS;I\CL_CLASS
1 0.0 CLASS_MAST CL_DESC T -1 121, 169
  
1 0.0 CLASS_MAST CL_DESC I -1 121, 193
$VALIDATE  'MAKE THIS FIELD MANDATORY AND THEN CONVERT TO UPPERCASE  M:  C:UCASE    A:CONST;;I\TMP1  A:CONST;;I\TMP2    'CALLS A USER FUNCTION WHICH CHECKS IN THE GRID FOR THE USER CODE ENTERED   U:PALLET_TYPE;CODE_CHECK;I\CL_CLASS,G\CLASS,I\TMP2,I\CL_DESC    'IF THE CODE DOES NOT EXIST, CALL A FUNCTION TO CHECK IF THE
1 0.0 CLASS_MAST CL_CLASS T -1 51, 169
  
1 0.0 CLASS_MAST CL_CLASS I -1 51, 193
$SELECT  S:CLASS;I\CL_CLASS        $VALIDATE  'MAKE THIS FIELD MANDATORY AND CONVERT TO UPPERCASE  M:  C:UCASE        'ALLOW NUMBERS ONLY IN THIS FIELD  'A:ISNUMERIC;I\CL_CLASS;I\NUMTST  'I:I\NUMTST;=;N  'D:ENTER A NUMBER ONLY - NOT $I\CL_CLASS$;ERRORM;I\CL_CLASS  
1 0.0 H -1 0, 0
  
1 0.0 Work 8 I 0 41, 49
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME  C:MCASE;;T\MARKET
1 0.0 CLASS_MAST CL_BLOCKED I -1 631, 193
CHANGE CASE TO UPPER CASE AND SET THIS FIELD MANDATORY  $VALIDATE    I:I\CL_BLOCKED;=;    A:CONST;N;I\CL_BLOCKED    M:  C:UCASE  'ONLY ALLOW THESE INPUTS  V:Y;N
1 0.0 CLASS_MAST CL_BLOCKED T -1 631, 169
  
1 0.0 Work 4 I 0 91, 493
  
1 0.0 Work 1 I 0 371, 481
  
1 0.0 Work 2 I 0 400, 482
  
10 0.0 ZX_EXIT 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_SELECT Z 0 0, 0
  
10 0.0 ZX_PRINT Z 0 0, 0