Freshmark replication server

freshmark-canonical

Program drill-down

FLOOR_STORAGE_RATE

FLOOR STORAGE RATE. Type MAN, base table PRODUCT_MAST.

Field inventory

22

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 4 C -1 441, 121
$SELECT  S:PRODUCT;I\PR_PRODUCT  
1 0.0 H -1 1, 25
  
1 0.0 PRODUCT_MAST PR_PRODUCT I -1 391, 121
$SELECT  S:PRODUCT_NOBLOCK;I\PR_PRODUCT    $VALIDATE  M:  'CONVERT TO UPPERCASE  C:UCASE    F:PRODUCT_MAST;Y;;;PR_PRODUCT='$I\PR_PRODUCT$';I\PR_PRODUCT    $AFTER_READ    I:I\PR_BLOCKED;=;  A:CONST;N;I\PR_BLOCKED    $BEFORE_READ  A:CONST;;I\LEVY
1 0.0 PRODUCT_MAST PR_FLR_RATE I -1 391, 157
$VALIDATE  
1 0.0 PRODUCT_MAST PR_FLR_DAYS I -1 391, 193
$VALIDATE  
1 0.0 DEFAULT I 0 1, 73
$DEFAULT    A:DATE;DD MMM/YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    
1 0.0 Work 15 I 0 51, 73
$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 Label 8 T -1 291, 25
  
1 0.0 PRODUCT_MAST PR_PRODUCT T -1 291, 121
  
1 0.0 PRODUCT_MAST PR_FLR_RATE T -1 291, 157
  
1 0.0 PRODUCT_MAST PR_FLR_DAYS T -1 291, 193
  
1 0.0 Label 7 T -1 301, 49
  
1 0.0 Label 9 T -1 1, 25
  
1 0.0 Label 5 T -1 671, 25
  
1 0.0 Label 6 T -1 671, 49
  
1 0.0 Label 1 T -1 621, 49
  
1 0.0 Label 2 T -1 621, 25
  
10 0.0 ZX_PRINT Z 0 1, 25
  
10 0.0 ZX_SELECT Z 0 1, 25
  
10 0.0 ZX_DELETE Z 0 1, 25
  
10 0.0 ZX_UPDATE Z 0 1, 25
  
10 0.0 ZX_EXIT Z 0 1, 25