Freshmark replication server

freshmark-canonical

Program drill-down

MSCOA_TRANS_UPDATE

MSCOA TRANSACTION UPDATE. Type DSP, base table MSCOA_MASTER.

Field inventory

28

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 1 C -1 321, 289
$SELECT  U:MSCOA_TRANS_UPDATE;UPDATE  A:CONST;;I\MM_CODE,I\MM_DESC,W\AMOUNT,W\VAT,I\AMOUNT,I\VAT  O:SETFOCUS;I\MM_CODE
1 0.0 H -1 1, 25
  
1 0.0 Work 8 I 0 1, 97
  
1 0.0 I -1 331, 169
  
1 0.0 I 0 1, 133
  
1 0.0 Work 1 I 0 1, 157
  
1 0.0 Work 2 I 0 1, 181
  
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,I\MM_DESC  
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 I -1 331, 133
$CALCULATE  I:I\MM_CODE;<>;  F:MSCOA_MASTER;;;I\MM_DESC=MM_DESC;MM_CODE='$I\MM_CODE$' AND MM_TYPE = 'O';I\MM_CODE  I:I\MM_DESC;=;  D:ENTER OTHER TRANSACTION CODE;ERRORM;I\MM_CODE      I:I\MM_CODE;<>;  F:MSCOA_TRANS;;;I\AMOUNT=MT_AMOUNT,I\VAT=MT_VAT,W\AMOUNT=MT_AMOUNT,W\VAT=MT_VAT;MT_CODE='$I\MM_CODE$' AND MT_UPLOADED =
1 0.0 I -1 331, 205
  
1 0.0 I -1 331, 241
$VALIDATE    O:SETFOCUS;C\CREATE  O:BACKCOLOR;C\CREATE;YELLOW
1 0.0 Label 3 T -1 191, 169
  
1 0.0 Label 8 T -1 291, 25
  
1 0.0 Label 7 T -1 281, 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 Label 1 T -1 191, 133
  
1 0.0 Label 5 T -1 191, 205
  
1 0.0 Label 6 T -1 191, 241
  
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