Program drill-down
AGNPALL_POOL_PUR_MAN
AGENT PALLET POOL PURCHASES. Type DSP, base table PALL_TRANS.
Field inventory
63
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | Work 54 | I | -1 | 541, 229 | $SELECT I:I\AGN_SMAN_SEC;=;M S:SALESMAN;I\SMAN_SEC I:I\AGN_SMAN_SEC;=;I S:SECTIONI;I\SMAN_SEC I:I\AGN_SMAN_SEC;=;S S:SECTIONS;I\SMAN_SEC $CALCULATE M: C:UCASE I:I\AGN_SMAN_SEC;=;M DO(M) F:SALESMAN_MAST;Y;;;SLS_CODE='$I\SMAN_SEC$' DOEND(M) I:I\AGN_SMAN_SEC;=;I DO(I) F:SECT_MAST;Y;;;SE_SECT='$ |
|
| 1 | 0.0 | H | -1 | 1, 85 | |||
| 1 | 0.0 | MARKET | T | -1 | 1, 85 | ||
| 1 | 0.0 | FRESHMARK | T | -1 | 291, 85 | ||
| 1 | 0.0 | SCREEN | T | -1 | 241, 109 | ||
| 1 | 0.0 | DATES | T | -1 | 621, 85 | ||
| 1 | 0.0 | DATE | T | -1 | 671, 85 | ||
| 1 | 0.0 | TIMES | T | -1 | 621, 109 | ||
| 1 | 0.0 | TIME | T | -1 | 671, 109 | ||
| 1 | 0.0 | PALL_TRANS | PT_OWNER | I | -1 | 141, 157 | $SELECT S:AGENT_CODE;I\PT_OWNER $VALIDATE M: C:UCASE F:AGENT_MAST;Y;AM_CODE;T\AGN_NAME=AM_NAME;AM_CODE='$I\PT_OWNER$';I\PT_OWNER F:CLIENT_MAST;;;I\AGN_SMAN_SEC=CM_PALL_SECT;CM_CODE='$I\MARKET$' |
| 1 | 0.0 | PALL_TRANS | PT_OWNER | T | -1 | 41, 157 | |
| 1 | 0.0 | GRID | G | -1 | 11, 253 | ||
| 1 | 0.0 | SEQ | T | -1 | 11, 205 | ||
| 1 | 0.0 | PALL | T | -1 | 61, 205 | ||
| 1 | 0.0 | CMD 27 | C | -1 | 131, 229 | $SELECT S:PALLET_CODE;I\PALL |
|
| 1 | 0.0 | COST | T | -1 | 321, 205 | ||
| 1 | 0.0 | QTY_AVAIL | T | -1 | 381, 205 | ||
| 1 | 0.0 | QTY_SOLD | T | -1 | 461, 205 | ||
| 1 | 0.0 | TOTAL_COST | T | -1 | 641, 205 | ||
| 1 | 0.0 | AGN_NAME | T | -1 | 271, 157 | ||
| 1 | 0.0 | SEQ | I | -1 | 11, 229 | $CALCULATE I:I\SEQ;<>;+ DO(TEE) I:I\SEQ;<>; DO(GET) I:I\SEQ;<>; U:ZZGRID_SPLIT;GRID_TO_SCREEN;G\GRID;I\SEQ DOEND(GET) I:I\SEQ;=; DO(GDE) O:DISABLEINPUT;I\PALL,I\COST,I\QTY_SOLD,I\SMAN_SEC,I\DEL DOEND(GDE) DOEND(TEE) I:I\SEQ;=;+ DO(SAS) A:CONST;;I\SEQ,I\PALL,I\PALL_NAME,I\ |
|
| 1 | 0.0 | PALL | I | -1 | 61, 229 | $SELECT S:PALLET_CODE;I\PALL $CALCULATE M: A:ISNUMERIC;I\PALL;I\TMP1 I:I\TMP1;=;Y A:VAR;I\PALL;I\PALL;;00 I:I\TMP1;=;N C:UCASE F:PALL_MAST;Y;;I\PALL_NAME=PM_DESC,I\COST=PM_DEPOSIT;PM_PALL='$I\PALL$';I\PALL F:PALL_POOL;;;I\QTY_AVAIL=PL_POOLQ;PL_OWNER='POOL' AND PL_PALL = '$I\PALL$' AND PL_POOLID = '1' |
|
| 1 | 0.0 | Work 2 | I | -1 | 161, 229 | ||
| 1 | 0.0 | COST | I | -1 | 321, 229 | $CALCULATE M: A:VAR;I\COST;I\COST;;#.00 I:I\COST;<=;0;NUM D:VALUE CANNOT BE ZERO OR NEGATIVE;ERRORM;I\COST |
|
| 1 | 0.0 | QTY_AVAIL | I | -1 | 381, 229 | ||
| 1 | 0.0 | QTY_SOLD | I | -1 | 461, 229 | $CALCULATE M: I:I\QTY_AVAIL;=; DO(LSD) D:THERE ARE NO PALLETS AVAILABLE;ERRORM;I\QTY_SOLD DOEND(LSD) I:I\QTY_SOLD;>;I\QTY_AVAIL DO(LKG) D:THERE ARE ONLY $I\QTY_AVAIL$ PALLETS AVAILABLE;ERRORM;I\QTY_SOLD DOEND(LKG) I:I\QTY_SOLD;=;0;NUM D:CANNOT BE ZERO;ERRORM;I\QTY_SOLD U:AGN_PALL_PUR;VAT A:VA |
|
| 1 | 0.0 | TOTAL_COST | I | -1 | 641, 229 | ||
| 1 | 0.0 | CMD 25 | C | -1 | 241, 157 | $SELECT S:AGENT_CODE;I\PT_OWNER |
|
| 1 | 0.0 | VAT | T | -1 | 591, 205 | ||
| 1 | 0.0 | VAT | I | -1 | 591, 229 | ||
| 1 | 0.0 | USERID | I | 0 | 81, 121 | $DEFAULT A:USERID;;I\USERID |
|
| 1 | 0.0 | IP | I | 0 | 61, 121 | $DEFAULT A:USERIP;;I\IP |
|
| 1 | 0.0 | MARKET | I | 0 | 41, 121 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\MARKET 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\TMP_CENTRAL_POOL=CM_CENTRAL_PALL 'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE C:MCASE;;T\MARKET |
|
| 1 | 0.0 | DEFAULT | I | 0 | 21, 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 A:TIMER_ON;1000 U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SEQ,I\PALL,I\PALL_NAME,I\COST,I\QTY_AVAIL,I\QTY_SOLD,I\SMAN_SEC,I\VAT,I\TOT_COST,I\DEL A:CONST;+;I\SEQ O:CAPTION_UPD;PROCESS |
|
| 1 | 0.0 | TMP4 | I | 0 | 101, 541 | ||
| 1 | 0.0 | TMP3 | I | 0 | 81, 541 | ||
| 1 | 0.0 | TMP2 | I | 0 | 61, 541 | ||
| 1 | 0.0 | TMP1 | I | 0 | 41, 541 | ||
| 1 | 0.0 | Label 38 | T | 0 | 1, 541 | ||
| 1 | 0.0 | TOTAL | I | -1 | 571, 493 | ||
| 1 | 0.0 | Label 48 | T | -1 | 511, 493 | ||
| 1 | 0.0 | ORGS | I | 0 | 101, 121 | $DEFAULT A:ORGS;;I\ORGS I:I\ORGS;=; DO(LAL) F:CLIENT_MAST;;;I\CENTRAL=CM_CENTRAL_PALL;CM_CODE='$I\MARKET$' I:I\CENTRAL;<>;0 DO(01) O:DISABLEINPUT;C\AGENT,C\PALLET D:ERROR - CENTRAL PALLET POOL IS NOT SETUP;ERRORM; DOEND(01) DOEND(LAL) I:I\ORGS;<>; DO(DED) F:AGENT_MAST;;;I\POOL=AM_ |
|
| 1 | 0.0 | Label 40 | T | 0 | 1, 613 | ||
| 1 | 0.0 | I | 0 | 41, 613 | |||
| 1 | 0.0 | I | 0 | 61, 613 | |||
| 1 | 0.0 | Label 53 | T | -1 | 541, 205 | ||
| 1 | 0.0 | Work 46 | I | 0 | 61, 577 | ||
| 1 | 0.0 | Label 55 | T | -1 | 541, 181 | ||
| 1 | 0.0 | Work 50 | I | -1 | 741, 229 | $CALCULATE I:I\DEL;<>;D DO(DED) A:ADD;I\TOT_COST,I\TOTAL;I\TOTAL;;#.00 U:ZZGRID_SPLIT;SCREEN_TO_GRID;G\GRID;I\SEQ A:CONST;+;I\SEQ A:CONST;;I\PALL,I\PALL_NAME,I\COST,I\QTY_AVAIL,I\QTY_SOLD,I\SMAN_SEC,I\VAT,I\TOT_COST O:SETFOCUS;I\SEQ DOEND(DED) I:I\DEL;=;D DO(DEL) I:I\SEQ;=; D:YOU MUST SPECIF |
|
| 1 | 0.0 | Label 43 | T | 0 | 1, 577 | ||
| 1 | 0.0 | Work 45 | I | 0 | 41, 577 | ||
| 1 | 0.0 | DEL | T | -1 | 741, 205 | ||
| 1 | 0.0 | Work 52 | I | 0 | 601, 571 | '$BEFORE_WRITE 'U:AGN_PALL_PUR;UPDATE_TABLES |
|
| 1 | 0.0 | Label 1 | T | -1 | 171, 205 | ||
| 1 | 0.0 | Work 2 | I | 0 | 121, 541 | ||
| 1 | 0.0 | CENTRAL | I | 0 | 311, 145 | ||
| 1 | 0.0 | POOL | I | 0 | 331, 145 | ||
| 1 | 0.0 | CMD 1 | C | -1 | 651, 553 | $SELECT U:U_AGN_PALL_PUR_INT;UPDATE_TABLES 'U:AGN_PALL_PUR;UPDATE_TABLES O:SETFOCUS;I\PT_OWNER |
|
| 10 | 0.0 | ZX_PRINT | Z | 0 | 1, 85 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 1, 85 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 1, 85 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 1, 85 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 1, 85 |