Program drill-down
CLEAR_UNPAID_SALES
CLEAR UNPAID SALES. Type DSP, base table STK_TRANS.
Field inventory
155
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 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 | 311, 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;T\MARKET=CM_NAME,I\CHK_CREDIT=CM_RESV_CRLCHK,W\ZEROFILL=CM_DEL_LEN;CM_CODE='$I\MARKET$' F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\CHK_CREDIT=CM_RESV_DEBTOR_UPD,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_DOCNO |
||
| 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 | 421, 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,T\BUYER 'INITIALIZE GRID |
| 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 | Work 1 | I | 0 | 11, 109 | ||
| 1 | 0.0 | DM_RESERV_CARD_SCAN | I | 0 | 531, 181 | ||
| 1 | 0.0 | Work 1 | I | 0 | 611, 265 | ||
| 1 | 0.0 | Work 2 | I | 0 | 611, 289 | ||
| 1 | 0.0 | Work 1 | I | 0 | 611, 241 | ||
| 1 | 0.0 | CMD 3 | C | -1 | 391, 145 | $SELECT S:SECTION1;I\SECTION |
|
| 1 | 0.0 | Work 1 | I | 0 | 11, 133 | ||
| 1 | 0.0 | Work 1 | I | 0 | 11, 157 | ||
| 1 | 0.0 | Work 2 | I | 0 | 41, 157 | ||
| 1 | 0.0 | Work 3 | I | 0 | 71, 157 | ||
| 1 | 0.0 | Work 1 | I | 0 | 611, 205 | ||
| 1 | 0.0 | Work 1 | I | -1 | 291, 145 | $SELECT S:SECTION1;I\SECTION $VALIDATE A:CONST;;T\SECTION2 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 |
|
| 1 | 0.0 | Label 2 | T | -1 | 181, 145 | ||
| 1 | 0.0 | CMD 5 | C | -1 | 371, 181 | $SELECT S:BUYER_NUMBER;I\ST_DEBTOR |
|
| 1 | 0.0 | Label 1 | T | -1 | 391, 433 | ||
| 1 | 0.0 | TOT VAT2 | I | 0 | 41, 469 | ||
| 1 | 0.0 | PAID | I | 0 | 471, 457 | ||
| 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 | 81, 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 | Work 5 | I | 0 | 81, 565 | ||
| 1 | 0.0 | SIZE | I | 0 | 111, 565 | ||
| 1 | 0.0 | TRTYPE | I | 0 | 531, 457 | ||
| 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 | Work 2 | I | 0 | 291, 553 | ||
| 1 | 0.0 | CASHPOINT | I | 0 | 41, 361 | ||
| 1 | 0.0 | Work 1 | I | 0 | 401, 181 | ||
| 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 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 | 111, 361 | ||
| 1 | 0.0 | Work 3 | I | 0 | 121, 361 | ||
| 1 | 0.0 | Work 4 | I | 0 | 91, 361 | ||
| 1 | 0.0 | TMP | I | 0 | 291, 577 | ||
| 1 | 0.0 | SOLD QTY | I | 0 | 141, 361 | ||
| 1 | 0.0 | Work 4 | I | 0 | 511, 457 | ||
| 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 | TOT DUES | I | 0 | 141, 469 | ||
| 1 | 0.0 | TOT DUES VAT | I | 0 | 161, 469 | ||
| 1 | 0.0 | TOT LEVY | I | 0 | 221, 469 | ||
| 1 | 0.0 | TOT LEVY VAT | I | 0 | 311, 493 | ||
| 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 | 491, 457 | ||
| 1 | 0.0 | LEVY | I | 0 | 271, 493 | ||
| 1 | 0.0 | LEVY VAT | I | 0 | 291, 493 | ||
| 1 | 0.0 | DUES VAT | I | 0 | 81, 469 | ||
| 1 | 0.0 | LEVT AMOUNT | I | 0 | 201, 469 | ||
| 1 | 0.0 | LEVY_VAT | I | 0 | 251, 493 | ||
| 1 | 0.0 | CLUB FEE TEMP | I | 0 | 401, 229 | 'MIGHT USE THIS FIELD FOR THE CLUB FEE OF THE TRANSFER TRANSACTION |
|
| 1 | 0.0 | CLUBFEE VAT | I | 0 | 91, 493 | ||
| 1 | 0.0 | Work 6 | I | 0 | 371, 553 | ||
| 1 | 0.0 | Work 10 | I | 0 | 391, 577 | ||
| 1 | 0.0 | Work 7 | I | 0 | 351, 553 | ||
| 1 | 0.0 | USER | I | 0 | 81, 49 | ||
| 1 | 0.0 | USER_IP | I | 0 | 101, 49 | ||
| 1 | 0.0 | Work 1 | I | 0 | 1, 541 | ||
| 1 | 0.0 | Work 1 | I | 0 | 451, 541 | ||
| 1 | 0.0 | Work 2 | I | 0 | 471, 541 | ||
| 1 | 0.0 | COMMVAL_VAT | I | 0 | 111, 493 | ||
| 1 | 0.0 | Work 1 | I | 0 | 491, 541 | ||
| 1 | 0.0 | Work 1 | I | 0 | 321, 337 | ||
| 1 | 0.0 | SCREEN TYPE | I | 0 | 131, 49 | $DEFAULT A:CONST;SA;I\SCREEN |
|
| 1 | 0.0 | Work 1 | I | 0 | 411, 553 | ||
| 1 | 0.0 | W SM_DDATE | I | 0 | 111, 337 | ||
| 1 | 0.0 | W DELNO | I | 0 | 101, 337 | ||
| 1 | 0.0 | DM_ACCTYPE | I | 0 | 381, 217 | ||
| 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 | DM_OSBAL | I | 0 | 581, 313 | ||
| 1 | 0.0 | DM_CURR | I | 0 | 601, 313 | ||
| 1 | 0.0 | CASHIER | I | 0 | 191, 493 | ||
| 1 | 0.0 | BLOCKED | I | 0 | 231, 493 | ||
| 1 | 0.0 | USER ID | I | 0 | 211, 493 | ||
| 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_CONSI |
|
| 1 | 0.0 | Label 4 | T | -1 | 431, 145 | ||
| 1 | 0.0 | Work 1 | I | 0 | 461, 97 | ||
| 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_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 | 4.0 | STK_TRANS | ST_TRDTE | I | -1 | 291, 253 | |
| 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 |