Program drill-down
RETURNABLE_PALL_BYR
BUYERS OUTSTANDING PALL RETURNABLE. Type DSP, base table STK_MAST.
Field inventory
36
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | Label 8 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 9 | T | -1 | 621, 25 | ||
| 1 | 0.0 | DEFAULT | I | 0 | 141, 37 | 'DISPLAYING TIME $DEFAULT A:DATE;DD MMM YYYY;T\DATE A:DATE;DD MMM YYYY;I\TO_DATE A:TIME;HH:MM:SS;T\TIME ''A:TIMER_ON;1000 |
|
| 1 | 0.0 | CMD 5 | C | -1 | 651, 541 | $SCMD_FOCUS O:BACKCOLOR;C\CREATE;YELLOW $SELECT E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_OUTSTANDING_PALLETS_BY_BUYER_NEW;$I\MARKET$,$I\BUYER$,$I\FROM_DATE$,$I\TO_DATE$,$I\ORGS$,$I\SALESMAN$,$I\AM_SLSM_ENTRY$,$I\PALL_CODE$,S ''''''''E:$GBLROOT |
|
| 1 | 0.0 | Label 11 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 10 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 1 | T | -1 | 191, 253 | ||
| 1 | 0.0 | Work 3 | I | -1 | 361, 253 | $SELECT S:PALLET_CODE;I\PALL_CODE $VALIDATE I:I\PALL_CODE;<>; DO(01) C:UCASE F:PALL_MAST;Y;;T\PALL=PM_DESC;PM_PALL='$I\PALL_CODE$' AND PM_DELIND<>'Y';I\PALL_CODE DOEND(01) O:SETFOCUS;C\CREATE O:BACKCOLOR;C\CREATE;YELLOW |
|
| 1 | 0.0 | Work 1 | I | 0 | 400, 403 | ||
| 1 | 0.0 | I\DATEDIFF | I | 0 | 241, 373 | ||
| 1 | 0.0 | Label 3 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 4 | T | -1 | 221, 49 | ||
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | Work 2 | I | 0 | 161, 37 | $DEFAULT A:ORGS;I\ORGS,I\AGENT A:VAR;I\ORGS;I\AGENT F:AGENT_MAST;;AM_CODE;T\AGENT1=AM_NAME,I\AM_SLSM_ENTRY=AM_SLSM_ENTRY;AM_CODE='$I\AGENT$' 'I:I\ORGS;<>; ' DO(AGENT) ' O:DISABLEINPUT;I\AGENT,C\AGENT ' O:SETFOCUS;I\SUPPL_NO ' DOEND(AGENT) 'I:I\ORGS;=; ' DO(NO_AGENT) ' O:ENABLEINPUT;I\AGENT,C\AGENT |
|
| 1 | 0.0 | Work 7 | I | 0 | 631, 145 | $VALIDATE I:I\FROM_DATE;=; DO(CHK) I:I\SUPPL_NO;=; A:CONST;$T\DATE$;I\FROM_DATE 'D:FROM DATE AND SUPPLIER NO. CANNOT BE BOTH BLANK;ERRORM;I\FROM_DATE DOEND(CHK) |
|
| 1 | 0.0 | BUYER | I | -1 | 361, 145 | $DEFAULT 'PUTS PIC ON THE UPDATE BUTTON O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\CREATE $SELECT S:DEBTOR;I\BUYER $VALIDATE I:I\BUYER;<>; DO(MAL) F:DEBTOR_MAST;Y;;T\NAME=DM_NAME,I\TMP_TYPE=DM_ACCTYPE;DM_DEBTOR='$I\BUYER$';I\BUYER DOEND(MAL) I:I\BUYER;=; A:CONST;;I\BUYER,T\NAME |
|
| 1 | 0.0 | Label 1 | T | -1 | 191, 145 | ||
| 1 | 0.0 | Label 5 | T | 0 | 591, 121 | ||
| 1 | 0.0 | MARKET | I | 0 | 111, 37 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\MARKET 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME 'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE C:MCASE;;T\MARKET A:VAR;I\MARKET;I\TM_MARKET $AFTER_READ A:VAR;I\MARKET;I\TM_MARKET |
|
| 1 | 0.0 | Label 5 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Work 8 | I | -1 | 361, 181 | $VALIDATE I:I\TO_DATE;=; A:DATE;DD MMM YYYY;I\TO_DATE I:I\TO_DATE;<>; DO(001) I:I\FROM_DATE;=; A:CONST;$T\DATE$;I\FROM_DATE DOEND(001) '''''A:DATEDIFF;I\TO_DATE;I\DATEDIFF;I\FROM_DATE I:I\DATEDIFF;<;0 '''''''D:TO DATE CANNOT BE LESS THAN FROM DATE;ERRORM;I\TO_DATE 'O:SETFOCUS;C |
|
| 1 | 0.0 | Work 1 | I | -1 | 361, 217 | $SELECT I:I\MARKET;=;11 DO(01) I:I\AGENT;<>; S:NEW_CONS_SSECT;I\SALESMAN;I\AGENT I:I\AGENT;=; S:NEW_CONS_SSECT1;I\SALESMAN DOEND(01) I:I\MARKET;<>;11 DO(02) I:I\AGENT;<>; S:SALESMAN_AGENT;I\SALESMAN;I\AGENT I:I\AGENT;=; S:SALESMAN;I\SALESMAN DOEND(02) $VALIDATE I:I\SALESMAN;=; A |
|
| 1 | 0.0 | Label 2 | T | -1 | 191, 217 | ||
| 1 | 0.0 | Label 6 | T | -1 | 191, 181 | ||
| 1 | 0.0 | CMD 1 | C | -1 | 421, 145 | $SELECT S:DEBTOR;I\BUYER |
|
| 1 | 0.0 | Label 2 | T | -1 | 461, 145 | ||
| 1 | 0.0 | Work 5 | I | 0 | 1, 109 | ||
| 1 | 0.0 | Label 3 | T | -1 | 491, 217 | ||
| 1 | 0.0 | CMD 4 | C | -1 | 461, 217 | $SELECT I:I\MARKET;=;11 DO(01) I:I\AGENT;<>; S:NEW_CONS_SSECT;I\SALESMAN;I\AGN I:I\AGENT;=; S:NEW_CONS_SSECT1;I\SALESMAN DOEND(01) I:I\MARKET;<>;11 DO(02) I:I\AGENT;<>; S:SALESMAN_AGENT;I\SALESMAN;I\AGENT I:I\AGENT;=; S:SALESMAN;I\SALESMAN DOEND(02) |
|
| 1 | 0.0 | CMD 1 | C | -1 | 461, 253 | $SELECT S:PALLET_CODE;I\PALL_CODE |
|
| 1 | 0.0 | Label 2 | T | -1 | 491, 253 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 0, 0 |