Freshmark replication server

freshmark-canonical

Program drill-down

GROW_ALLO_TO_SALE

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

Field inventory

71

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 1 C 0 621, 253
$SELECT  'DISPLAY A SELECTION WINDOW  S:DEDUCT_CODE_GRO;I\ST_DED_CODE
1 0.0 SD_SIZE I 0 131, 517
  
1 0.0 STK_TRANS ST_MARKET I 0 101, 85
  
1 0.0 SUPPL I -1 371, 157
  
1 0.0 STK_DETS SD_DATE I -1 371, 229
  
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 PROD I 0 431, 517
  
1 0.0 PROHIBIT_SALES I 0 561, 481
  
1 0.0 VARIETY I 0 381, 517
  
1 0.0 SD_CONT I 0 81, 517
  
1 0.0 Work 1 I 0 231, 517
  
1 0.0 SD_CLASS I 0 111, 517
  
1 0.0 SD_CONTMASS I 0 151, 517
  
1 0.0 Work 4 I 0 621, 481
  
1 0.0 CMD 1 C -1 481, 85
$SELECT    S:DOCNO_AGN_GRO;I\ST_DOCNO;I\MARKET    
1 0.0 Work 10 I -1 371, 301
  
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 Work 2 I 0 591, 253
$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,T\DED_VAT=DM_VAT_CODE;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 0 441, 481
  
1 0.0 SD_DELNO I 0 191, 517
  
1 0.0 H -1 1, 25
  
1 0.0 Work 13 G 0 21, 253
  
1 0.0 CMD 1 C -1 649, 548
'$SCMD_FOCUS  'O:BACKCOLOR;C\CREATE;YELLOW    $CALCULATE  W:PASTEL_INV;Y;PI_DOCNO;PI_DOCNO=I\ST_DOCNO,PI_BUYER_INV=I\PI_BUYER_INV,PI_BUYER_PALL_INV=I\PI_BUYER_PALL_INV,PI_SUPPL_INV=I\PI_SUPPL_INV,PI_SUPPL_PALL_INV=I\PI_SUPPL_PALL_INV;PI_DOCNO = '$I\ST_DOCNO$'  O:BACKCOLOR;C\CREATE;YELLOW    $SELECT    A:CONST;PROCESSIN
1 0.0 Work 6 I -1 371, 265
  
1 0.0 Work 1 I 0 311, 553
  
1 0.0 Work 2 I 0 591, 301
  
1 0.0 Work 5 I 0 611, 517
  
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 0 591, 277
$CALCULATE  'M:  C:UCASE    F:VAT_MAST;;;I\VAT_RATE=VT_RATE;VT_CODE='$T\DED_VAT$';    A:MULT;I\VALUE;I\TMP4;I\VAT_RATE  A:DIV;I\TMP4;I\DED_VAT;100;#0.00      
1 0.0 SD_COMM I -1 371, 193
  
1 0.0 STK_TRANS ST_DOCNO I -1 371, 85
$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_AGENT,I\SD_
1 0.0 Work 9 I -1 371, 121
  
1 0.0 Check 2 K 0 371, 481
$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 171, 193
  
1 0.0 Label 8 T -1 171, 85
  
1 0.0 Label 9 T -1 271, 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, 157
  
1 0.0 Label 3 T -1 171, 157
  
1 0.0 Label 2 T -1 171, 229
  
1 0.0 DEDUCTION CODE T 0 491, 253
  
1 0.0 Label 1 T -1 481, 121
  
1 0.0 Label 7 T -1 171, 301
  
1 0.0 Label 3 T 0 231, 481
  
1 0.0 Label 8 T -1 171, 121
  
1 0.0 Label 2 T 0 651, 253
  
1 0.0 Label 3 T 0 491, 277
  
1 0.0 Label 5 T -1 171, 265
  
1 0.0 Label 3 T 0 491, 301
  
1 0.0 Label 1 T -1 171, 337
  
1 0.0 Label 2 T -1 171, 373
  
1 0.0 Label 3 T -1 171, 409
  
1 0.0 Label 4 T -1 171, 445
  
1 0.0 PASTEL_INV PI_BUYER_PALL_INV I -1 371, 373
  
1 0.0 PASTEL_INV PI_SUPPL_INV I -1 371, 409
  
1 0.0 PASTEL_INV PI_SUPPL_PALL_INV I -1 371, 445
$VALIDATE  O:SETFOCUS;C\CREATE  O:BACKCOLOR;C\CREATE;YELLOW
1 0.0 Work 2 I -1 371, 337
  
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