Program drill-down
CHEP_BUY_RET_MAN
CHEP BUYER TO POOL MAINTENANCE. Type DSP, base table PALL_TRANS.
Field inventory
121
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | CMD 3 | C | -1 | 651, 545 | $SCMD_FOCUS O:BACKCOLOR;C\CREATE;YELLOW $SELECT F:CLIENT_MAST;;;I\PROH=CM_PROHIBIT_SALES,I\PROHIBIT_AGENT_SALES=CM_PROHIBIT_AGENT_SALES;CM_CODE='$I\MARKET$'; I:I\PROH;=;Y D:SALES ARE CURRENTLY PROHIBITED;ERRORM;I\PT_DEBTOR '======================================================== 'ADDED BY MOMZ AND SIYA |
|
| 1 | 0.0 | Work 1 | I | 0 | 261, 493 | ||
| 1 | 0.0 | CMD 2 | C | -1 | 261, 121 | $SELECT I:I\MARKET;<>;23 DO(OTHER) I:I\AGENT;=; S:PAL_DOCNO1;;I\PT_DEBTOR I:I\AGENT;<>; S:PAL_DOCNO2;;I\MARKETI\AGENT;I\PT_DEBTOR DOEND(OTHER) |
|
| 1 | 0.0 | GRID | G | -1 | 1, 325 | ||
| 1 | 0.0 | H | -1 | 1, 61 | |||
| 1 | 0.0 | VALIDATED | I | 0 | 591, 541 | ||
| 1 | 0.0 | TEMP4 | I | 0 | 71, 505 | ||
| 1 | 0.0 | PERIOD | I | -1 | 551, 301 | ||
| 1 | 0.0 | PALL_TRANS | PT_DEBTOR | I | -1 | 161, 85 | $VALIDATE M: F:CLIENT_MAST;;;I\PROH=CM_PROHIBIT_SALES,I\PROHIBIT_AGENT_SALES=CM_PROHIBIT_AGENT_SALES;CM_CODE='$I\MARKET$'; I:I\PROH;=;Y D:SALES ARE CURRENTLY PROHIBITED;ERRORM;I\PT_DEBTOR F:DEBTOR_MAST;Y;;T\PT_DEBTOR2=DM_NAME,I\PT_DEBTOR=DM_DEBTOR,I\CHEP_CASH_BUYER=DM_CHEP_CASH_BUYER,I\UNREG=DM_SC_UNSEC;DM_DEB |
| 1 | 0.0 | PALL_MAST | PM_USAGE | I | -1 | 496, 301 | |
| 1 | 0.0 | PALL_TRANS | PT_CONSIGN | I | -1 | 161, 157 | |
| 1 | 0.0 | PALL_TRANS | PT_DOCNO | I | -1 | 161, 121 | $SELECT S:PAL_DOCNO1;;I\PT_DEBTOR $VALIDATE A:CONST;;I\LINE,I\PT_PALL,I\SQTY,I\PT_DEPOSIT,I\PT_DEPOSIT_VAT,I\PT_TRQTY,I\PT_TRDTE,I\PM_USAGE,I\PERIOD,I\PT_USAGE_FEE,I\PT_USAGE_VAT,W\TODAY_DIFF 'MAKE THIS FIELD MANDATORY M: 'CONVERT TO UPPERCASE C:UCASE 'VALIDATE DOCKET NUMBER F:PALL_TRANS;Y;;W\SM_DDATE= |
| 1 | 0.0 | TOTAL VAT | I | -1 | 701, 505 | ||
| 1 | 0.0 | PALL_TRANS | PT_DEPOSIT | I | -1 | 191, 301 | |
| 1 | 0.0 | PALL_TRANS | PT_TRDTE | I | -1 | 391, 301 | $CALCULATE M: I:I\PT_TRDTE;<>; DO(DIFF) 'JD WHILE GOING LIVE ON EL!!!!!!!!!!!!!!!!!!!!!!!!!!!! A:CONST;Y;I\VALIDATED 'JD WHILE GOING LIVE ON EL!!!!!!!!!!!!!!!!!!!!!!!!!!!! 'GET THE DATE DIFF A:DATEDIFF;I\PT_TRDTE;W\DIFF;I\DDTE I:W\DIFF;<;0 D:DATE RETURNED CANNOT B |
| 1 | 0.0 | Work 1 | I | -1 | 121, 481 | ||
| 1 | 0.0 | PALL_TRANS | PT_TRQTY | I | -1 | 321, 301 | $CALCULATE I:I\PT_TRQTY;=;0;NUM D:RETURNED QUANTITY MUST BE GREATER THAN ZERO;ERRORM;I\PT_TRQTY ''CHECK IF RETURNED QTY IS GREATER THAN SOLD QTY THIS CHECK COMMENTED BY LP20100126 ON JANET'S REQUEST 'I:I\PT_TRQTY;>;I\SQTY 'D:RETURNED QUANTITY CANNOT BE GREATER THAN THE SOLD QUANTITY;ERRORM;I\ |
| 1 | 0.0 | AGENTPV | I | 0 | 451, 169 | ||
| 1 | 0.0 | TOTAL FEE | I | -1 | 621, 505 | ||
| 1 | 0.0 | SOLD QTY | I | -1 | 91, 301 | ||
| 1 | 0.0 | LINE | I | -1 | 1, 301 | $VALIDATE 'DISPLAY GRID DATA I:I\LINE;<>; U:ZZGRID_SPLIT;GRID_TO_SCREEN;G\GRID;I\LINE 'CHECK THIS PALLET IS A CHEP PALLET IF PRETORIA I:I\MARKET;IN;11,18 DO(PMA) I:I\PT_PALL;<>; DO(H2N) F:PALL_MAST;;;I\CHEP=PM_TYPE;PM_PALL='$I\PT_PALL$' I:I\CHEP;<>;01 D:MAY ONLY RETURN CHEP PALLETS HERE; |
|
| 1 | 0.0 | PALL_TRANS | PT_PALL | I | -1 | 41, 301 | |
| 1 | 0.0 | PALL_TRANS | PT_DEPOSIT_VAT | I | -1 | 261, 301 | |
| 1 | 0.0 | PALL_TRANS | PT_USAGE_FEE | I | -1 | 621, 301 | |
| 1 | 0.0 | PALL_TRANS | PT_USAGE_VAT | I | -1 | 691, 301 | |
| 1 | 0.0 | DDTE | I | -1 | 161, 193 | ||
| 1 | 0.0 | DTIME | I | -1 | 161, 217 | ||
| 1 | 0.0 | I MARKET | I | 0 | 21, 61 | $DEFAULT 'PUTS PIC ON THE UPDATE BUTTON O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\CREATE 'LOAD MARKET CODE A:ORG;;I\MARKET 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME 'CONVERT ONLY THE FIRST CHARACTER OF THE MARKET LABEL C:MCASE;;T\MARKET 'LOAD MARKET PARAMENTER F:CLI |
|
| 1 | 0.0 | Mode | I | 0 | 61, 61 | $DEFAULT A:CONST;P;I\MODE I:I\MODE;=;P A:CONST;BUYER PALLET RETURN TO POOL;T\HEADING I:I\MODE;=;A A:CONST;BUYER PALLET RETURN TO AGENT;T\HEADING |
|
| 1 | 0.0 | CM_PALL_SCAN | I | 0 | 361, 121 | ||
| 1 | 0.0 | PAID | I | 0 | 41, 541 | ||
| 1 | 0.0 | AGENT | I | 0 | 81, 61 | $DEFAULT A:ORGS;;I\AGENT 'GET USERNAME A:USERNAME;;I\USER 'GET USER IP A:USERIP;;I\IP F:AGENT_MAST;;AM_CODE;W\AM_OWN_PALL_POOL=AM_OWN_PALL_POOL 'GETS USERID 1 A:USERID;;W\USERID 'GETS USER'S IP ADDRESS1 2 F:ZU_USER;;;W\USER_IP=ZU_LOCAL_IP;ZU_USERID='$W\USERID$' 'GETS C |
|
| 1 | 0.0 | USER | I | 0 | 581, 205 | ||
| 1 | 0.0 | IP | I | 0 | 61, 541 | ||
| 1 | 0.0 | SCANNED DEBTOR | I | -1 | 381, 205 | $CALCULATE 'MAKE THIS FIELD MANDATORY M: I:W\CM_PALL_SCAN;=;1 U:VALIDATE_PREAMBLE;VALIDATE;I\DEBTOR,I\TMP4 I:I\TMP4;=;2 D:ERROR - INVALID BUYER NUMBER;ERRORM;I\PT_DOCNO I:I\TMP4;<>;2 DO(PRE) I:I\PT_DEBTOR;<>;I\DEBTOR DO(3) D:ERROR - BUYER NUMBERS DO NOT MATCH;ERRORM;I\PT_DOCNO |
|
| 1 | 0.0 | SECT | I | 0 | 511, 169 | ||
| 1 | 0.0 | Work 1 | I | 0 | 681, 157 | ||
| 1 | 0.0 | SUPPL | I | 0 | 581, 121 | ||
| 1 | 0.0 | DATE DIFF | I | 0 | 561, 85 | ||
| 1 | 0.0 | USAGE | I | 0 | 491, 505 | ||
| 1 | 0.0 | W DATE | I | 0 | 279, 180 | ||
| 1 | 0.0 | MINIMUM DAYS | I | 0 | 441, 121 | ||
| 1 | 0.0 | NUMBER OF DAYS | I | 0 | 381, 121 | ||
| 1 | 0.0 | DELNO | I | 0 | 41, 61 | ||
| 1 | 0.0 | MAXIMUM PERIOD | I | 0 | 491, 121 | ||
| 1 | 0.0 | TRVAL | I | 0 | 411, 529 | ||
| 1 | 0.0 | POOL ID | I | 0 | 311, 529 | ||
| 1 | 0.0 | AM_OWN_PALL_POOL | I | 0 | 331, 529 | ||
| 1 | 0.0 | CM_PALL_SECT | I | 0 | 351, 529 | ||
| 1 | 0.0 | CASHIER | I | 0 | 31, 505 | ||
| 1 | 0.0 | CASHPT | I | 0 | 51, 505 | ||
| 1 | 0.0 | USER_IP | I | 0 | 151, 61 | ||
| 1 | 0.0 | CPO_CASHPT | I | 0 | 171, 61 | ||
| 1 | 0.0 | USERID | I | 0 | 141, 61 | ||
| 1 | 0.0 | VAT CODE | I | 0 | 171, 517 | ||
| 1 | 0.0 | TEMP 3 | I | 0 | 501, 253 | ||
| 1 | 0.0 | DF_VATCODE | I | 0 | 301, 121 | ||
| 1 | 0.0 | ACC TYPE | I | 0 | 371, 529 | ||
| 1 | 0.0 | CENTRAL POOL | I | 0 | 291, 529 | ||
| 1 | 0.0 | REFUNDED VAT | I | 0 | 221, 517 | ||
| 1 | 0.0 | SM_DDATE | I | 0 | 1, 61 | ||
| 1 | 0.0 | TEMP 2 | I | 0 | 21, 541 | ||
| 1 | 0.0 | LENGTH | I | 0 | 1, 541 | ||
| 1 | 0.0 | QTY RETURNED | I | 0 | 521, 252 | ||
| 1 | 0.0 | TEMP | I | 0 | 461, 505 | ||
| 1 | 0.0 | QTY AVAIL | I | -1 | 151, 301 | ||
| 1 | 0.0 | FEE | I | 0 | 551, 121 | ||
| 1 | 0.0 | DELIND | I | 0 | 751, 217 | ||
| 1 | 0.0 | TRANS | I | 0 | 751, 301 | ||
| 1 | 0.0 | WOFF | I | 0 | 251, 61 | ||
| 1 | 0.0 | SALE_TRNO | I | 0 | 611, 85 | ||
| 1 | 0.0 | Work 1 | I | 0 | 11, 253 | ||
| 1 | 0.0 | Work 2 | I | 0 | 641, 109 | ||
| 1 | 0.0 | Work 3 | I | 0 | 651, 133 | ||
| 1 | 0.0 | RETDAYS | I | 0 | 441, 253 | ||
| 1 | 0.0 | PALLSUPPL | I | 0 | 751, 193 | ||
| 1 | 0.0 | Label 17 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 10 | T | -1 | 271, 85 | ||
| 1 | 0.0 | Label 8 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 18 | T | -1 | 321, 253 | ||
| 1 | 0.0 | Label 16 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 15 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 14 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 9 | T | -1 | 41, 253 | ||
| 1 | 0.0 | Label 20 | T | -1 | 21, 157 | ||
| 1 | 0.0 | Label 24 | T | -1 | 91, 253 | ||
| 1 | 0.0 | Label 34 | T | -1 | 21, 121 | ||
| 1 | 0.0 | Label 3 | T | -1 | 191, 277 | ||
| 1 | 0.0 | Label 8 | T | -1 | 21, 217 | ||
| 1 | 0.0 | Label 7 | T | -1 | 41, 277 | ||
| 1 | 0.0 | Label 16 | T | -1 | 281, 277 | ||
| 1 | 0.0 | Label 3 | T | -1 | 21, 85 | ||
| 1 | 0.0 | Label 55 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 5 | T | -1 | 21, 193 | ||
| 1 | 0.0 | Label 13 | T | -1 | 321, 276 | ||
| 1 | 0.0 | Label 14 | T | -1 | 386, 276 | ||
| 1 | 0.0 | Label 15 | T | -1 | 387, 252 | ||
| 1 | 0.0 | Label 16 | T | -1 | 497, 277 | ||
| 1 | 0.0 | Label 18 | T | -1 | 551, 277 | ||
| 1 | 0.0 | Label 20 | T | -1 | 621, 277 | ||
| 1 | 0.0 | Label 59 | T | -1 | 1, 277 | ||
| 1 | 0.0 | Label 22 | T | -1 | 691, 277 | ||
| 1 | 0.0 | Label 74 | T | -1 | 541, 505 | ||
| 1 | 0.0 | Label 1 | T | -1 | 91, 277 | ||
| 1 | 0.0 | HEADING | T | -1 | 281, 49 | ||
| 1 | 0.0 | Label 10 | T | -1 | 281, 205 | ||
| 1 | 0.0 | Label 4 | T | 0 | 323, 241 | ||
| 1 | 0.0 | Label 5 | T | 0 | 403, 250 | ||
| 1 | 0.0 | Label 2 | T | -1 | 151, 253 | ||
| 1 | 0.0 | Label 3 | T | -1 | 151, 277 | ||
| 1 | 0.0 | Work 1 | I | 0 | 671, 121 | ||
| 1 | 0.0 | Work 1 | I | 0 | 191, 565 | ||
| 1 | 0.0 | Work 2 | I | 0 | 400, 490 | ||
| 1 | 0.0 | Work 3 | I | 0 | 241, 565 | ||
| 1 | 0.0 | Work 1 | I | 0 | 571, 169 | $SVAR_FOCUS U:EXIT_SCREEN |
|
| 1 | 0.0 | Work 1 | I | 0 | 471, 85 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 1, 61 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 1, 61 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 1, 61 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 1, 61 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 1, 61 |