Freshmark replication server

freshmark-canonical

Program drill-down

PALLET_MAN

PALLET MAINTENANCE. Type MDL, base table PALL_MAST.

Field inventory

69

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 PALL_MAST PM_PALL I -1 241, 97
$SELECT  S:PALLET_CODE;I\PM_PALL    $VALIDATE  M:  C:UCASE  'A:ISNUMERIC;I\PM_PALL;I\TMP1    F:PALL_MAST;;;I\TMP_NEW=PM_PALL;PM_PALL='$I\PM_PALL$'  I:I\TMP_NEW;<>;  F:PALL_MAST;;;I\TMP_OLDFEE=PM_PALFEE,I\DELIND=PM_DELIND;PM_PALL='$I\PM_PALL$'    I:I\DELIND;=;Y  D:THE PALLET HAS ALREADY BEEN DELETED;ERRORM;I\PM_PALL    
1 0.0 PALL_MAST PM_PALFEE T -1 51, 385
  
1 0.0 PALL_MAST PM_MINPER T -1 351, 421
  
1 0.0 H -1 0, 0
  
1 0.0 PALL_MAST PM_ALTDESC I -1 241, 205
$VALIDATE  C:UCASE  
1 0.0 PALL_MAST PM_ALTDESC T -1 51, 205
  
1 0.0 Label 22 T -1 1, 25
  
1 0.0 PALL_MAST PM_DEPOSIT T -1 51, 349
  
1 0.0 PALL_MAST PM_DESC I -1 241, 169
$VALIDATE  M:  C:UCASE
1 0.0 PALL_MAST PM_DESC T -1 51, 169
  
1 0.0 CMD 21 C -1 291, 313
$SELECT  'S:SECT_MAST;I\PM_SECT  S:SECTION_CODE;I\PM_SECT
1 0.0 Label 1 T -1 51, 493
  
1 0.0 Work 1 I 0 421, 505
  
1 0.0 PALL_MAST PM_DELIND I 0 81, 529
  
1 0.0 PALL_MAST PM_MAXPER T -1 351, 385
  
1 0.0 PALL_MAST PM_DF_VATCDE T -1 451, 265
  
1 0.0 PALL_MAST PM_FEEVAT T -1 451, 301
  
1 0.0 PALL_MAST PM_BLOCK_PALL I -1 201, 493
$VALIDATE    C:UCASE  I:I\BLOCK_PALL;=;    V:Y;N  
1 0.0 PALL_MAST PM_PALL T -1 51, 97
  
1 0.0 PALL_MAST PM_RETDAYS T -1 351, 349
  
1 0.0 PALL_MAST PM_SECT T -1 51, 313
  
1 0.0 PALL_MAST PM_TYPE T -1 51, 241
  
1 0.0 PALL_MAST PM_USAGE T -1 51, 457
  
1 0.0 Label 1 T -1 51, 277
  
1 0.0 PALL_MAST PM_USAGE_FEE T -1 51, 421
  
1 0.0 CMD 20 C -1 291, 241
$SELECT  S:PALLET;I\PM_TYPE
1 0.0 CMD 19 C -1 301, 97
$SELECT  S:PALLET_CODE;I\PM_PALL
1 0.0 Label 23 T -1 291, 25
  
1 0.0 Label 24 T -1 307, 49
  
1 0.0 Label 25 T -1 621, 49
  
1 0.0 Label 26 T -1 671, 49
  
1 0.0 Label 27 T -1 621, 25
  
1 0.0 Label 28 T -1 671, 25
  
1 0.0 Work 1 I 0 71, 61
$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    O:HIDE;T\CHEP_PALL,I\CHEP_PALL    $BEFORE_DELETE    'NOT ALLOW USERS TO DELETE WHILE THESE FIELDS ARE EMPTY    I:I\PM_PALL;=;    DO     I:I\PM_DESC;=;     I:I\PM_TYPE;=;     
1 0.0 Work 2 I 0 81, 553
  
1 0.0 CMD 3 C -1 661, 265
$SELECT  S:VAT;I\PM_DF_VATCDE
1 0.0 CMD 4 C -1 661, 301
$SELECT  S:VAT;I\PM_FEEVAT
1 0.0 Work 13 I 0 101, 61
$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 PALL_MAST PM_SUPPL_ID I -1 241, 133
  
1 0.0 PALL_MAST PM_SUPPL_ID T -1 51, 133
  
1 0.0 Work 17 I 0 161, 553
  
1 0.0 Label 3 T 0 331, 553
  
1 0.0 Label 1 T -1 731, 289
  
1 0.0 Label 2 T -1 731, 325
  
1 0.0 Label 4 T 0 281, 553
  
1 0.0 Work 18 I 0 201, 553
  
1 0.0 Work 1 I 0 381, 97
  
1 0.0 Work 44 I 0 701, 517
$BEFORE_WRITE  I:I\TMP_NEW;<>;  DO(APL)    I:I\TMP_NEW;<>;I\TMP_OLDFEE;NUM    U:PALLET_MAST;UPDATE_HISTORY  DOEND(APL)
1 0.0 Work 45 I 0 681, 517
  
1 0.0 Work 46 I 0 661, 517
  
1 0.0 Label 47 T 0 621, 517
  
1 0.0 Work 1 I 0 401, 505
  
1 1.0 PALL_MAST PM_SECT I -1 241, 313
$SELECT  'S:SECT_MAST;I\PM_SECT  S:SECTION_CODE;I\PM_SECT      $VALIDATE  'MAKE THIS FIELD MANDATORY  M:    'DISPLAY ERROR MESSAGE IF NON-EXISTING VALUE IS ENTERED  F:SECT_MAST;Y;;I\PM_SECT=SE_SECT;SE_SECT='$I\PM_SECT$';I\PM_SECT
1 1.0 PALL_MAST PM_TYPE I -1 241, 241
$SELECT  'DISPLAY SELECTION WINDOW  S:PALLET;I\PM_TYPE    $VALIDATE  'MAKE THIS FIELD MANDATORY  M:  C:UCASE    A:ISNUMERIC;I\PM_TYPE;I\TMP11  I:I\TMP11;=;Y  A:VAR;I\PM_TYPE;I\PM_TYPE;;00    'DISPLAY ERROR MESSAGE IF NON-EXISTING VALUE IS ENTERED  F:PALL_TYPE;Y;;I\PM_TYPE=PTP_TYPE;PTP_TYPE='$I\PM_TYPE$'    I:I\PM_TYPE;
1 1.0 I -1 241, 277
  
1 2.0 PALL_MAST PM_FEEVAT I -1 621, 301
$SELECT  S:VAT;I\PM_FEEVAT    $VALIDATE  M:  A:VAR;I\PM_FEEVAT;I\PM_FEEVAT;;00  F:VAT_MAST;Y;;I\TMP3=VT_RATE;VT_CODE='$I\PM_FEEVAT$'  A:CON;I\TMP3;T\FEE;"%"  
1 2.0 PALL_MAST PM_DF_VATCDE I -1 621, 265
$SELECT  S:VAT;I\PM_DF_VATCDE    $VALIDATE  M:  A:VAR;I\PM_DF_VATCDE;I\PM_DF_VATCDE;;00  F:VAT_MAST;Y;;I\TMP2=VT_RATE;VT_CODE='$I\PM_DF_VATCDE$'  A:CON;I\TMP2;T\DEP;"%"    
1 3.0 PALL_MAST PM_PALFEE I -1 201, 385
$VALIDATE  I:I\PM_PALFEE;<>;  DO  I:I\PM_PALFEE;<;0  D:CANNOT BE LESS THAN ZERO;ERRORM;I\PM_PALFEE  DOEND    F:PALL_MAST;;;I\TMP_OLDFEE=PM_PALFEE;PM_PALL='$I\PM_PALL$'
1 3.0 PALL_MAST PM_DEPOSIT I -1 201, 349
$VALIDATE  I:I\PM_DEPOSIT;<>;  DO  I:I\PM_DEPOSIT;<;0  D:CANNOT BE LESS THAN ZERO;ERRORM;I\PM_DEPOSIT  DOEND  
1 3.0 PALL_MAST PM_USAGE I -1 201, 457
$VALIDATE  I:I\PM_USAGE;<>;  DO  I:I\PM_USAGE;<;0  D:USAGE PERIOD CANNOT BE LESS THAN ZERO;ERRORM;I\PM_USAGE  DOEND        
1 3.0 PALL_MAST PM_USAGE_FEE I -1 201, 421
$VALIDATE  I:I\PM_USAGE_FEE;<>;  DO  I:I\PM_USAGE_FEE;<;0  D:CANNOT BE LESS THAN ZERO;ERRORM;I\PM_USAGE_FEE  DOEND    
1 4.0 PALL_MAST PM_MINPER I -1 521, 421
$VALIDATE  I:I\PM_MINPER;<>;  DO  I:I\PM_MINPER;<;0  D:CANNOT BE LESS THAN ZERO;ERRORM;I\PM_MINPER  I:I\PM_MINPER;>=;I\PM_MAXPER;NUM  D:MAX DAYS MUST BE GREATER THAN MIN DAYS;ERRORM;I\PM_MINPER  DOEND      
1 4.0 PALL_MAST PM_MAXPER I -1 521, 385
$VALIDATE  I:I\PM_MAXPER;<>;  DO  I:I\PM_MAXPER;<;0  D:CANNOT BE LESS THAN ZERO;ERRORM;I\PM_MAXPER  DOEND      
1 4.0 PALL_MAST PM_RETDAYS I -1 521, 349
$VALIDATE  I:I\PM_RETDAYS;<>;  DO  I:I\PM_RETDAYS;<;0  D:CANNOT BE LESS THAN ZERO;ERRORM;I\PM_RETDAYS  DOEND    A:MULT;I\PM_USAGE_FEE;I\TMP4;I\PM_RETDAYS    'A:VAR;I\PM_FEEVAT;I\PM_FEEVAT;;00  'F:VAT_MAST;Y;;I\TMP3=VT_RATE;VT_CODE='$I\PM_FEEVAT$'  'A:MULT;I\TMP4;I\TMP5;I\TMP3  'A:DIV;I\TMP5;I\TMP5;100;#0.00  'A:ADD;I\T
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
  
10 0.0 ZX_PRINT Z 0 0, 0