Freshmark replication server

freshmark-canonical

Program drill-down

FM_TABLES_MAN

TABLES MAINTENANCE. Type MAN, base table FM_TABLES.

Field inventory

23

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 4 C -1 371, 205
$SELECT  S:RETAIL_TABLES;I\FM_TABLENO  
1 0.0 H -1 1, 25
  
1 0.0 Work 7 I 0 11, 133
  
1 0.0 FM_TABLES FM_TABLENO I -1 321, 205
$SELECT  S:RETAIL_TABLES;I\FM_TABLENO    $VALIDATE  M:  'CONVERT TO UPPERCASE  C:UCASE  
1 0.0 Label 2 T -1 211, 169
  
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  O:DISABLEINPUT;I\FM_DATE,I\FM_TIME,I\FM_RANDS_PERKG,I\FM_STANDARD  
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    F:FM_TABLES;;;I\LAST=MAX(FM_TABLENO);
1 0.0 Work 8 I 0 51, 133
  
1 0.0 Work 1 I 0 11, 169
  
1 0.0 Label 8 T -1 291, 25
  
1 0.0 T -1 211, 205
  
1 0.0 Label 7 T -1 291, 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
  
1 0.0 Work 1 I -1 321, 169
  
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