Freshmark replication server

freshmark-canonical

Program drill-down

SALE_ACTUAL_MASS

ALLOCATE A DEDUCTION TO A SALE. Type DSP, base table STK_TRANS.

Field inventory

58

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 1 C -1 651, 553
$SCMD_FOCUS  O:BACKCOLOR;C\CREATE;YELLOW      $SELECT    A:CONST;PROCESSING...;T\PROCESS    U:GROW_DEDUCT;GROW_DED    O:SETFOCUS;I\ST_DOCNO    A:CONST;DONE PROCESSING;T\PROCESS
1 0.0 CMD 1 C -1 481, 97
$SELECT    S:DOCNO_AGN_GRO;I\ST_DOCNO;I\MARKET    
1 0.0 CMD 1 C -1 411, 373
$SELECT  'DISPLAY A SELECTION WINDOW  S:DEDUCT_CODE_GRO;I\ST_DED_CODE
1 0.0 Work 13 G 0 21, 253
  
1 0.0 H -1 1, 25
  
1 0.0 SD_DELNO I 0 191, 517
  
1 0.0 Work 1 I 0 231, 517
  
1 0.0 SD_CONT I 0 81, 517
  
1 0.0 SD_CLASS I 0 111, 517
  
1 0.0 SD_CONTMASS I 0 151, 517
  
1 0.0 PROD I 0 431, 517
  
1 0.0 PROHIBIT_SALES I 0 561, 457
  
1 0.0 VARIETY I 0 381, 517
  
1 0.0 Work 10 I 0 421, 457
  
1 0.0 Work 2 I -1 371, 373
$SELECT  'DISPLAY A SELECTION WINDOW  S:DEDUCT_CODE_GRO;I\ST_DED_CODE    $VALIDATE  M:  C:UCASE      I:I\ST_DED_CODE;=;  A:CONST;;T\DED_DESC    I:I\ST_DED_CODE;<>;  F:DEDUCT_MAST;Y;;T\DED_DESC=DM_DESC;DM_CODE='$I\ST_DED_CODE$';I\ST_DED_CODE    A:LEFT;T\DED_DESC,15;T\DED_DESC  C:MCASE;;T\DED_DESC
1 0.0 Work 10 I -1 371, 313
  
1 0.0 Work 11 I 0 491, 517
  
1 0.0 Work 1 I 0 331, 517
  
1 0.0 SD_ITEM I 0 261, 517
  
1 0.0 CM_DEL_LEN I 0 21, 517
  
1 0.0 SD_SIZE I 0 131, 517
  
1 0.0 STK_TRANS ST_MARKET I 0 181, 85
  
1 0.0 SUPPL I -1 371, 169
  
1 0.0 STK_DETS SD_DATE I -1 371, 241
  
1 0.0 Work 1 I 0 21, 97
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET  A:ORGS;;I\ORGS    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\PROHIBIT_SALES=CM_PROHIBIT_SALES    'CONVERT THE FIRST CHARACTER TO UPPERCASE  C:MCASE;;T\MARKET    I:I\PROHIBIT_SALES;=;Y  D:YOU CAN'T CONTINUE PROGRAM IS PROHIBITED;ERRORM;    A:VAR;I\MARKET;I
1 0.0 Work 6 I -1 371, 277
  
1 0.0 Work 4 I 0 151, 553
  
1 0.0 Work 11 I 0 91, 121
$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      O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\CREATE              
1 0.0 Work 4 I -1 371, 421
$CALCULATE  'M:  C:UCASE    
1 0.0 SD_COMM I -1 371, 205
'$AFTER_READ  'LOAD COMMODITY IF THE CONSIGNMENT IS NOT NULL  'I:I\SD_CONSIGN;<>;  'A:CON;I\COMM," ",I\SD_CLASS,I\SD_SIZE," ",I\SD_CONT," ",I\SD_CONTMASS,"KG",;I\COMM
1 0.0 STK_TRANS ST_DOCNO I -1 371, 97
$SELECT    S:DOCNO_AGN_GRO;I\ST_DOCNO;I\MARKET          $VALIDATE    M:      F:STK_TRANS;Y;;I\ST_TRDTE=ST_TRDTE,I\ST_TAXINV=ST_TAXINV,I\ST_CONSIGN=ST_CONSIGN,I\ST_DEBTOR=ST_DEBTOR,I\ST_TRQTY=ST_TRQTY,I\ST_PRICE=ST_TRPRICE;ST_MARKET='$I\MARKET$' AND ST_DOCNO = '$I\ST_DOCNO$';I\ST_DOCNO      F:STK_DETS;Y;;I\SD_AGENT=SD_A
1 0.0 Work 9 I -1 371, 133
  
1 0.0 Check 2 K -1 371, 469
$CALCULATE      O:SETFOCUS;C\CREATE   O:BACKCOLOR;C\CREATE;YELLOW
1 0.0 Label 16 T -1 671, 25
  
1 0.0 Label 8 T -1 271, 25
  
1 0.0 Label 14 T -1 621, 25
  
1 0.0 Label 15 T -1 621, 49
  
1 0.0 Label 9 T -1 231, 205
  
1 0.0 Label 8 T -1 231, 97
  
1 0.0 Label 9 T -1 221, 49
  
1 0.0 Label 17 T -1 671, 49
  
1 0.0 Label 1 T -1 1, 25
  
1 0.0 Label 2 T -1 481, 169
  
1 0.0 Label 3 T -1 231, 169
  
1 0.0 Label 2 T -1 231, 241
  
1 0.0 DEDUCTION CODE T -1 231, 373
  
1 0.0 Label 1 T -1 481, 133
  
1 0.0 Label 7 T -1 231, 313
  
1 0.0 Label 3 T -1 231, 469
  
1 0.0 Label 8 T -1 231, 133
  
1 0.0 Label 2 T -1 471, 373
  
1 0.0 Label 3 T -1 231, 421
  
1 0.0 Label 5 T -1 231, 277
  
10 0.0 ZX_UPDATE Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 1, 25
  
10 0.0 ZX_EXIT Z 0 1, 25
  
10 0.0 ZX_DELETE Z 0 1, 25
  
10 0.0 ZX_PRINT Z 0 1, 25