Freshmark replication server

freshmark-canonical

Program drill-down

SFS_TARGET_PRICE_MAN

SFS TARGET PRICE MAN. Type MAN, base table TARGET_PRICE.

Field inventory

27

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 TARGET_PRICE TP_CONT I -1 351, 241
$SELECT  S:CONT_PR_ONLY;I\TP_CONT;I\TP_PRODUCT;I\TP_CONT
1 0.0 TARGET_PRICE TP_CONT T -1 201, 241
  
1 0.0 TARGET_PRICE TP_EFFECTIVE I -1 351, 277
$CALCULATE  A:VAR;I\TP_EFFECTIVE;I\TP_EFFECTIVE;;YYYY/MM/DD
1 0.0 TARGET_PRICE TP_EFFECTIVE T -1 201, 277
  
1 0.0 TARGET_PRICE TP_MARKET I 0 31, 73
  
1 0.0 TARGET_PRICE TP_PRICE I -1 351, 313
  
1 0.0 TARGET_PRICE TP_PRICE T -1 201, 313
  
1 0.0 TARGET_PRICE TP_PRODUCT I -1 351, 205
$SELECT  S:PRODUCT1;I\TP_PRODUCT    $VALIDATE  M:  C:UCASE  F:PRODUCT_MAST;Y;;T\PROD_DESC=PR_DESC;PR_PRODUCT='$I\TP_PRODUCT$';I\TP_PRODUCT
1 0.0 TARGET_PRICE TP_PRODUCT T -1 201, 205
  
1 0.0 Work 6 I 0 1, 73
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET  A:ORG;;I\TP_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    '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;
1 0.0 Label 7 T -1 1, 25
  
1 0.0 Label 8 T -1 291, 25
  
1 0.0 Label 9 T -1 277, 49
  
1 0.0 Label 10 T -1 621, 25
  
1 0.0 Label 11 T -1 671, 25
  
1 0.0 Label 12 T -1 621, 49
  
1 0.0 Label 13 T -1 671, 49
  
1 0.0 CMD 14 C -1 391, 205
$SELECT  S:PRODUCT1;I\TP_PRODUCT
1 0.0 CMD 15 C -1 391, 241
$SELECT  S:CONT_PR_ONLY;I\TP_CONT;I\TP_PRODUCT;I\TP_CONT
1 0.0 Label 16 T -1 431, 205
  
1 0.0 Label 17 T -1 431, 241
  
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