Freshmark replication server

freshmark-canonical

Program drill-down

CLEAR_RESERVED_STK

CLEAR RESERVED STOCK. Type DSP, base table STK_TRANS.

Field inventory

150

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Work 6 I 0 371, 553
  
1 0.0 Work 1 I 0 301, 337
  
1 0.0 CLUBFEE VAT I 0 91, 493
  
1 0.0 TOT DUES I 0 141, 469
  
1 0.0 DM_CURR I 0 621, 337
  
1 0.0 CASHIER I 0 191, 493
  
1 0.0 BLOCKED I 0 231, 493
  
1 0.0 USER_IP I 0 101, 49
  
1 0.0 Work 1 I 0 1, 541
  
1 0.0 USER I 0 81, 49
  
1 0.0 Work 10 I 0 391, 577
  
1 0.0 Work 7 I 0 351, 553
  
1 0.0 USER ID I 0 211, 493
  
1 0.0 DUES VAT I 0 81, 469
  
1 0.0 DM_OSBAL I 0 611, 337
  
1 0.0 STK_TRANS ST_DELIND I 0 301, 85
$DEFAULT  A:CONST;N;I\ST_DELIND    
1 0.0 LVT_TRANS I 0 451, 517
  
1 0.0 STK_TRANS ST_TRTYPE I 0 21, 361
  
1 0.0 Work 1 I 0 381, 517
  
1 0.0 TOT SLS 2 I 0 21, 469
  
1 0.0 W SM_DDATE I 0 121, 361
  
1 0.0 LEVY_VAT I 0 251, 493
  
1 0.0 CLUB FEE TEMP I 0 401, 253
'MIGHT USE THIS FIELD FOR THE CLUB FEE OF THE TRANSFER TRANSACTION
1 0.0 W DELNO I 0 101, 361
  
1 0.0 DM_ACCTYPE I 0 381, 253
  
1 0.0 Work 1 I 0 411, 553
  
1 0.0 SCREEN TYPE I 0 131, 49
$DEFAULT  A:CONST;SA;I\SCREEN
1 0.0 Work 2 I 0 471, 541
  
1 0.0 Work 1 I 0 451, 541
  
1 0.0 LEVT AMOUNT I 0 201, 469
  
1 0.0 COMMVAL_VAT I 0 111, 493
  
1 0.0 Work 1 I 0 491, 541
  
1 0.0 TOTAL CLUB FEE I 0 51, 493
  
1 0.0 TOTAL CLUB FEE VAT I 0 71, 493
  
1 0.0 Work 16 I 0 591, 481
  
1 0.0 LEVY I 0 271, 493
    
1 0.0 LEVY VAT I 0 291, 493
  
1 0.0 TOT LEVY VAT I 0 311, 493
  
1 0.0 TOT DUES VAT I 0 161, 469
  
1 0.0 TOT LEVY I 0 221, 469
  
1 0.0 Work 4 I 0 91, 361
  
1 0.0 TMP I 0 291, 577
  
1 0.0 SOLD QTY I 0 151, 361
  
1 0.0 Work 4 I 0 611, 481
  
1 0.0 Work 5 I 0 191, 577
  
1 0.0 Work 6 I 0 211, 577
  
1 0.0 TOT SLS I 0 1, 469
  
1 0.0 TOT VAT I 0 61, 469
  
1 0.0 Work 3 I 0 131, 361
  
1 0.0 Work 6 I 0 501, 517
  
1 0.0 Work 7 I 0 471, 517
  
1 0.0 Work 1 I 0 162, 564
  
1 0.0 Work 2 I 0 101, 361
  
1 0.0 Work 2 I 0 291, 553
  
1 0.0 CASHPOINT I 0 41, 361
  
1 0.0 Work 1 I 0 421, 253
  
1 0.0 Work 2 I 0 1, 361
  
1 0.0 Work 5 I 0 491, 517
  
1 0.0 Work 4 I 0 541, 517
  
1 0.0 Work 5 I 0 81, 565
  
1 0.0 SIZE I 0 111, 565
  
1 0.0 TRTYPE I 0 631, 481
  
1 0.0 SUPPLIER I 0 381, 85
  
1 0.0 SD_TOTCOM I 0 121, 469
  
1 0.0 PALL_TRANS PT_PALL I 0 1, 421
  
1 0.0 PALL_TRANS PT_TRVAL I 0 141, 421
  
1 0.0 PALL_TRANS PT_TRVAT I 0 211, 421
  
1 0.0 PALL_TRANS PT_TRQTY I 0 71, 421
  
1 0.0 Work 5 I 0 281, 421
  
1 0.0 Work 7 I 0 61, 565
  
1 0.0 Work 1 I 0 142, 564
  
1 0.0 H -1 1, 61
  
1 0.0 Label 1 T -1 1, 25
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 3 T -1 291, 49
  
1 0.0 Label 4 T -1 621, 25
  
1 0.0 Label 5 T -1 671, 25
  
1 0.0 Label 6 T -1 621, 49
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 MARKET CODE I 0 1, 49
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD AGENT CODE  A:ORGS;;I\AGENT    'LOAD MARKET  NAME  'F:CLIENT_MAST;;CM_CODE;I\CHK_CREDIT=CM_RESV_CRLCHK,T\MARKET=CM_NAME,W\ZEROFILL=CM_DEL_LEN;CM_CODE='$I\MARKET$'  F:CLIENT_MAST;;CM_CODE;I\CHK_CREDIT=CM_RESV_DEBTOR_UPD,T\MARKET=CM_NAME,W\ZEROFILL=CM_DEL_LEN;CM_CODE=
1 0.0 DEFAULT I 0 41, 49
$DEFAULT    A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    LOAD THE CURRENT USER'S NAME  A:USERNAME;;I\USER    LOAD THE CURRENT USER'S IP ADDRESS  A:USERIP;;I\USER_IP    'INITIALIZE GRID  U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\PT_PALL,I\PT_TRQTY,I\PT_TRVAL,I\PT_TRVAT,I\PT_VAL  'U:ZZGRID_SPLIT;INIT_GRI
1 0.0 I -1 131, 85
'RETRIVING AGENT NAME  $DEFAULT  'PUTS PIC ON THE UPDATE BUTTON  O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\UPDATE      A:ORGS;I\AGENT  F:AGENT_MAST;;;T\AGENT=AM_NAME,I\UNPAID_PARM=AM_CLR_UNPD_SALES;AM_CODE='$I\AGENT$'    I:I\AGENT;<>;    DO(AGENT)     O:HIDE;C\UPDATE     O:SHOW;I\AGENT,T\AGENT,I\ST_DOC
1 0.0 Label 11 T -1 11, 85
  
1 0.0 Label 13 T -1 191, 85
  
1 0.0 Work 14 I 0 1, 565
  
1 0.0 ST_DOCNO T -1 181, 217
  
1 0.0 CMD 17 C -1 391, 217
$SELECT  A:CONST;SA;I\TRTYPE    'DISPLAY A SELECTION WINDOW  I:I\AGENT;=;  S:DOC_NO3;I\ST_DOCNO;I\MARKET;I\TRTYPE  'IF SECTION AND BUYER FIELDS ARE EMPTY  I:I\AGENT;<>;   DO(01)    I:I\SECTION;=;     DO(02)      I:I\ST_DEBTOR;=;      S:DOC_NO_AGENT_SALE2;I\ST_DOCNO;I\MARKET;I\TRTYPE;I\AGENT     DOEND(02)   DOEND(01)   
1 0.0 Work 1 I 0 21, 565
  
1 0.0 USER IP I 0 61, 361
  
1 0.0 Work 2 I 0 41, 565
  
1 0.0 Label 6 T -1 401, 181
  
1 0.0 STK_TRANS ST_DEBTOR I -1 291, 181
$SELECT  S:BUYER_NUMBER;I\ST_DEBTOR      $VALIDATE  A:CONST;;T\PROC  A:CONST;;I\ST_CONSIGN,I\SD_ITEM,I\PT_PALL,I\PT_TRQTY,I\PT_TRVAL,I\PT_TRVAT,I\PT_VAL,I\SD_CONT,I\GRADE,I\ST_DOCNO,I\ST_TRDTE  A:CONST;;I\ST_TRQTY,I\ST_TRPRICE,I\ST_TRVAT,I\VALUE,I\ST_COMMVAL,I\LEVY,I\ST_CLUBFEE,W\TOTSLS        'INITIALIZE GRID  U:ZZGRI
1 0.0 Label 5 T -1 181, 181
  
1 0.0 Label 7 T -1 1, 313
  
1 0.0 Label 9 T -1 101, 313
  
1 0.0 Work 3 I 0 521, 517
  
1 0.0 Label 18 T -1 321, 313
  
1 0.0 Label 21 T -1 381, 313
  
1 0.0 Label 22 T -1 481, 313
  
1 0.0 Label 23 T -1 541, 313
  
1 0.0 Work 33 G -1 1, 421
  
1 0.0 DM_RESERV_CARD_SCAN I 0 511, 181
  
1 0.0 Work 1 I 0 561, 277
  
1 0.0 Work 1 I 0 561, 253
  
1 0.0 CMD 1 C -1 371, 181
$SELECT  S:BUYER_NUMBER;I\ST_DEBTOR
1 0.0 Work 2 I 0 461, 229
  
1 0.0 Work 1 I 0 561, 229
  
1 0.0 Label 2 T -1 181, 145
  
1 0.0 Label 3 T -1 421, 145
  
1 0.0 Work 4 I -1 291, 145
$SELECT  S:SECTION1;I\SECTION    $VALIDATE  A:CONST;;T\PROC  A:CONST;;T\SECTION2  A:CONST;;I\ST_CONSIGN,I\SD_ITEM,I\PT_PALL,I\PT_TRQTY,I\PT_TRVAL,I\PT_TRVAT,I\PT_VAL,I\SD_CONT,I\GRADE,I\ST_DOCNO,I\ST_TRDTE  A:CONST;;I\ST_TRQTY,I\ST_TRPRICE,I\ST_TRVAT,I\VALUE,I\ST_COMMVAL,I\LEVY,I\ST_CLUBFEE,W\TOTSLS        'INITIALIZE 
1 0.0 CMD 5 C -1 391, 145
$SELECT  S:SECTION1;I\SECTION
1 0.0 Work 1 I 0 601, 145
  
1 0.0 TOT VAT2 I 0 41, 469
  
1 0.0 PAID I 0 571, 505
  
1 0.0 Label 47 T -1 181, 253
  
1 0.0 Label 48 T -1 231, 313
  
1 0.0 STK_TRANS ST_DOCNO I -1 291, 217
$SELECT  A:CONST;SA;I\TRTYPE    'DISPLAY A SELECTION WINDOW  I:I\AGENT;=;  S:DOC_NO3;I\ST_DOCNO;I\MARKET;I\TRTYPE  'IF SECTION AND BUYER FIELDS ARE EMPTY  I:I\AGENT;<>;   DO(01)    I:I\SECTION;=;     DO(02)      I:I\ST_DEBTOR;=;      S:DOC_NO_AGENT_SALE2;I\ST_DOCNO;I\MARKET;I\TRTYPE;I\AGENT     DOEND(02)   DOEND(01)   
1 0.0 Label 54 T -1 181, 313
  
1 0.0 I_IP I 0 621, 385
  
1 0.0 Label 57 T -1 1, 397
  
1 0.0 W_USERID I 0 661, 385
  
1 0.0 Work 2 I 0 71, 361
  
1 0.0 ST_CASHIER I 0 171, 493
$DEFAULT  A:USERID;;W\USERID    I:I\AGENT;<>;  A:CONST;CR;I\ST_CASHIER    I:I\AGENT;=;    DO(1)      'VALIDATE THE USERID      F:CASH_MAST;;;W\CASHIER=CSH_CASHIER,W\BLOCKED=CSH_BLOCK;CSH_CASHIER='$W\USERID$' AND CSH_MARKET='$I\MARKET$'        'IF THIS USERID IS NOT FOR A CASHIER THEN JUST PUT 'CR' INTO I\ST_CASHIER    
1 0.0 SD_COMMP_VAT I 0 181, 469
  
1 0.0 UNPAID_PARM I 0 281, 469
  
1 0.0 Work 1 I 0 471, 481
  
1 0.0 Work 1 I 0 521, 145
  
1 0.0 CMD 1 C -1 651, 546
$SCMD_FOCUS  O:BACKCOLOR;C\UPDATE;YELLOW  $SELECT    I:I\ST_DOCNO;<>;  U:CLEAR_UNPAID_SALES;MSG2    'I:I\UNPAID_PARM;<>;0  I:I\CLEAR_SALES;=;Y    DO(CLEAR)     I:I\ST_DOCNO;<>;       DO(DOCNO)        F:STK_DETS;;;W\ACTIVE=SD_ACTIVE;SD_MARKET='$I\MARKET$' AND SD_AGENT='$I\AGENT$' AND SD_DATE='$I\DELDATE$' AND SD_CONSIGN
1 0.0 Label 1 T -1 391, 421
  
1 1.0 STK_TRANS ST_CONSIGN I -1 1, 337
  
1 1.0 STK_DETS SD_ITEM I -1 101, 337
  
1 1.0 I -1 181, 337
        
1 3.0 STK_DETS SD_CONT I -1 231, 337
        
1 4.0 STK_TRANS ST_TRDTE I -1 291, 253
  
1 4.0 STK_TRANS ST_TRQTY I -1 321, 337
  
1 4.0 STK_TRANS ST_TRPRICE I -1 381, 337
  
1 4.0 STK_TRANS ST_TRVAT I -1 481, 337
T\ST_TRDTE,I\ST_TRDTE,T\ST_DEBTOR,I\ST_DEBTOR,T\BUYER,T\ST_CONSIGN,I\ST_CONSIGN,T\SD_ITEM,I\SD_ITEM,T\GRADE,I\GRADE,T\SD_CONT,I\SD_CONT,T\QTY,I\ST_TRQTY,T\PRICE,I\ST_TRPRICE,T\VAT,I\ST_TRVAT
1 4.0 VALUE FIELD I -1 541, 337
        
1 4.0 STK_TRANS ST_COMMVAL I 0 131, 493
  
1 4.0 STK_TRANS ST_DUES I 0 101, 469
  
1 4.0 STK_TRANS ST_CLUBFEE I 0 33, 493
    
1 5.0 Work 38 I 0 16, 493
  
1 5.0 Work 41 I 0 151, 493
  
1 5.0 NEW CONTAINER I 0 241, 469
'$BEFORE_DELETE  'STOP THE DELETE FUNCTIONALITY FOR LEGEND  'A:STOPDELETE;TRUE      'CHECK FOR EMPTY FIELDS  'I:I\ST_DOCNO;=;  'D:DOCUMENT NUMBER IS EMPTY - CAN NOT DELETE RECORD;ERRORM;I\ST_DOCNO    'I:I\ST_DEBTOR;=;  'D:DEBTOR IS EMPTY - CAN NOT DELETE RECORD;ERRORM;I\ST_DEBTOR    'I:I\ST_CONSIGN;=;  'D:CONSIGNMENT I
1 6.0 STK_TRANS ST_RSN_CODE I 0 -1, 494
$SELECT  'DISPLAY A SELECTION WINDOW  S:REASON;I\ST_RSN_CODE    $VALIDATE  C:UCASE    I:I\ST_RSN_CODE;=;  A:CONST;;T\REASON      I:I\ST_RSN_CODE;<>;  F:REASON_MAST;Y;;T\REASON=RSN_DESC;RSN_REASON='$I\ST_RSN_CODE$';I\ST_RSN_CODE    A:LEFT;T\REASON,15;T\REASON  C:MCASE;;T\REASON      '$AFTER_READ  'F:REASON_MAST;;;T\REAS
10 0.0 ZX_PRINT Z 0 1, 61
  
10 0.0 ZX_SELECT Z 0 1, 61
  
10 0.0 ZX_DELETE Z 0 1, 61
  
10 0.0 ZX_UPDATE Z 0 1, 61
  
10 0.0 ZX_EXIT Z 0 1, 61
$SCMD_FOCUS  O:BACKCOLOR;Z\ZX_EXIT;YELLOW