Program drill-down
PALL_POOL_TRANS_INT
PALLET POOL TRANSACTIONS INTERNATIONAL. Type DSP, base table PALL_MAST.
Field inventory
58
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | CMD 15 | C | -1 | 311, 205 | ''''$SELECT ''''SELECT PALLET CODE FROM THE SELECTION WINDOW ''''I:I\LINE;<>; ''''S:PALLET_CODE4;I\PM_PALL;I\AGENT '$SELECT 'SELECT PALLET CODE FROM THE SELECTION WINDOW 'I:I\AGENT;=; 'DO(DDQ) ' I:I\TRANS_TYPE;=;PP ' DO(FFE) ' I:I\LINE;<>; ' S:PALLET_CODE4;I\PM_PALL;I\POOLID ' DOEND(FFE) ' I: |
|
| 1 | 0.0 | CMD 4 | C | -1 | 101, 205 | $SELECT 'SELECT TRANSACTION TYPE FROM THE SELECTION WINDOW S:TRANS_TYPE2;I\TRANS_TYPE |
|
| 1 | 0.0 | CMD 13 | C | -1 | 441, 205 | $SELECT 'SELECTION WINDOW OF SECTION FOR ENTERED PALLET CODE AND OWNER 'I:I\PM_PALL;<>; 'S:SECTION_CODE22;I\SECT;I\PM_PALL;I\OWNER;I\AGENT '***===ADDED BY JUSTIN ON 16/08/09===================================================================================================================== I:I\AGENT;=; DO(4RF) |
|
| 1 | 0.0 | CREATE | C | -1 | 651, 545 | $SCMD_FOCUS O:BACKCOLOR;C\CREATE;YELLOW $SELECT 'COUNT GRID ROWS U:SUPPLIER_PALL_RETURN;LINE_NO;G\GRID I:I\LINE;<=;1 DO(002) D:NO RECORDS IN THE GRID TO PROCESS - RETRY;ERRORM;I\LINE A:CONST;+;I\LINE DOEND(002) I:I\LINE;>;1 U:REVERSE_SUPPLIER_PALL_RETURN;UPDATE_REVERSE_PALL_RETURNS;G\GRID,I\M |
|
| 1 | 0.0 | GRID | G | -1 | 11, 229 | ||
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | SECTION | I | 0 | 201, 445 | 'WORK FILD |
|
| 1 | 0.0 | SECT | I | -1 | 391, 205 | $DEFAULT 'CHECKING THIS PARAMETER IF THE MARKET USE SECTION OR SALESMAN F:CLIENT_MAST;;;W\SECTION=CM_PALL_SECT;CM_CODE='$I\MARKET$'; $SELECT '***===ADDED BY JUSTIN ON 16/08/09===================================================================================================================== I:I\AGENT;=; |
|
| 1 | 0.0 | Work 8 | I | 0 | 111, 49 | $DEFAULT '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 |
|
| 1 | 0.0 | Work 9 | I | 0 | 141, 49 | $DEFAULT 'PUTS PIC ON THE UPDATE BUTTON O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\CREATE 'LOAD DATE AND TIME A:DATE;DD MMM YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME A:TIMER_ON;1000 'GET USER ID AND IP A:USERIP;;I\IP A:USERID;;I\USER 'INITIAL GRID U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\LINE,I\TRANS_T |
|
| 1 | 0.0 | LINE | I | -1 | 11, 205 | $DEFAULT A:CONST;+;I\LINE '$SELECT 'S:G:G\GRID:R1 $VALIDATE '==JUSTIN=== I:I\LINE;=;+ A:CONST;;I\TRANS_TYPE,I\TRANS_DESC,I\PM_PALL,I\OWNER,I\SECT,I\SECT_DESC,I\AVAIL,I\TRANS_QTY '=========== 'IF THIS FIELD IS EMPTY DISABLE ALL FIELDS AND BUTTON THEN SET FOCUS TO CONFIRM BUTTON I:I\LINE;=; DO(005) |
|
| 1 | 0.0 | PM_PALL | I | -1 | 261, 205 | $SELECT '==JUSTIN=== 'SELECT PALLET CODE FROM THE SELECTION WINDOW I:I\AGENT;=; DO(DDQ) I:I\TRANS_TYPE;=;PP DO(FFE) I:I\LINE;<>; '''' S:PALLET_CODE8_1;I\PM_PALL DOEND(FFE) I:I\TRANS_TYPE;<>;PP DO(FEF) I:I\LINE;<>; S:PALLET_CODE4_1;I\PM_PALL;I\POOLID DOEND(FEF) DOEND(DDQ) I |
|
| 1 | 0.0 | TRANS_TYPE | I | -1 | 51, 205 | $SELECT 'SELECT TRANSACTION TYPE FROM THE SELECTION WINDOW S:TRANS_TYPE1;I\TRANS_TYPE $VALIDATE 'SET THIS FIELD MANDATORY M: C:UCASE 'COMMENTED ON CHRISTO' REQUEST BY LP20110411 'V:PS;RS;PP;PR;RP 'LOOKUP FOR AN EXISTING TRANSACTION TYPE AND DISPLAY DISCRIPTION, IF DOES NOT FOUND DISPLAY ERROR MESSAGE F |
|
| 1 | 0.0 | TRANS_DESC | I | -1 | 131, 205 | 'DISPLAY FIELD ONLY |
|
| 1 | 0.0 | OWNER | I | -1 | 341, 205 | $SELECT '===CHANGED BY JUSTIN ON 15/09/08=========================================================================================================== I:I\AGENT;=; S:MKT_POOL_OWNER;I\OWNER;I\POOLID I:I\AGENT;<>; S:AGENT_POOL_OWNER;I\OWNER;I\AGENT '================================================================== |
|
| 1 | 0.0 | SECT_DESC | I | -1 | 471, 205 | 'DISPLAY FIELD ONLY |
|
| 1 | 0.0 | AVAIL | I | -1 | 601, 205 | 'DISPLAY FIELD ONLY |
|
| 1 | 0.0 | TRANS_QTY | I | -1 | 671, 205 | $VALIDATE A:CONST;;I\CONTINUE,I\PALL_AVAIL 'SET THIS FIELD MANDATORY M: 'IF TYPE IS NOT EQUAL TO PP THEN COMPARE TRANSFERED QTY AND AVAILABLE QTY, IF TRANSFERED QTY IS GREATER THAN AVAILABLE QTY DISPLAYS ERROR MESSAGE U:REVERSE_SUPPLIER_PALL_RETURN;CHECK_AVAIL_QTY I:I\CONTINUE;<>;Y DO(001) I\TRANS_T |
|
| 1 | 0.0 | DEL | I | -1 | 751, 205 | $CALCULATE 'CHANGE TEXT CASE TO UPPER CASE C:UCASE 'ONLY THESE VALUES ALLOWED V:D; 'IF LINE FIELD CONTAINS PLUS SIGN THEN CALL ROUTINE TP COUNT THE NUMBER OF ROWS I:I\LINE;=;+ U:SUPPLIER_PALL_RETURN;LINE_NO;G\GRID 'VALIDATE ALL THE FIELDS BEFORE GET SAVED IN THE GRID 'LOOKUP FOR EXISTING PALLET CODE FROM T |
|
| 1 | 0.0 | IP | I | 0 | 151, 541 | 'WORK FIELD |
|
| 1 | 0.0 | USER | I | 0 | 171, 541 | 'WORK FIELD |
|
| 1 | 0.0 | Work 1 | I | 0 | 211, 541 | ||
| 1 | 0.0 | OWN_PALL_POOL | I | 0 | 231, 541 | ||
| 1 | 0.0 | Work 1 | I | 0 | 181, 61 | 'RETRIVING AGENT $DEFAULT A:ORGS;I\AGENT I:I\AGENT;=; F:POOLID_MAST;;;I\POOLID=PI_ID;PI_TYPE='C' F:AGENT_MAST;;;I\OWN_PALL_POOL=AM_OWN_PALL_POOL;AM_CODE='$I\AGENT$' I:I\OWN_PALL_POOL;=;0 DO(01) O:DISABLEINPUT;C\PALL,C\TYPE,C\SECT D:ERROR - ONLY ALLOWED IF AGENT HAS OWN PALLET POOL;ERRORM; DOEND(01 |
|
| 1 | 0.0 | Work 1 | I | 0 | 361, 493 | ||
| 1 | 0.0 | Work 1 | I | 0 | 591, 145 | ||
| 1 | 0.0 | Work 1 | I | 0 | 571, 109 | ||
| 1 | 0.0 | Work 2 | I | 0 | 591, 109 | ||
| 1 | 0.0 | Work 3 | I | 0 | 611, 109 | ||
| 1 | 0.0 | Work 1 | I | 0 | 461, 493 | ||
| 1 | 0.0 | Label 1 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 2 | T | -1 | 281, 49 | ||
| 1 | 0.0 | Label 3 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 4 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 5 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 6 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 7 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 10 | T | -1 | 11, 181 | ||
| 1 | 0.0 | Label 12 | T | -1 | 261, 181 | ||
| 1 | 0.0 | PM_PALL | T | 0 | 231, 133 | ||
| 1 | 0.0 | Label 14 | T | -1 | 261, 157 | ||
| 1 | 0.0 | Label 1 | T | -1 | 51, 157 | ||
| 1 | 0.0 | Label 2 | T | -1 | 51, 181 | ||
| 1 | 0.0 | Label 3 | T | 0 | 31, 133 | ||
| 1 | 0.0 | Label 6 | T | -1 | 131, 181 | ||
| 1 | 0.0 | Label 8 | T | -1 | 341, 181 | ||
| 1 | 0.0 | T | 0 | 391, 133 | |||
| 1 | 0.0 | Label 11 | T | -1 | 391, 157 | ||
| 1 | 0.0 | Label 12 | T | -1 | 391, 181 | ||
| 1 | 0.0 | Label 15 | T | -1 | 471, 181 | ||
| 1 | 0.0 | Label 17 | T | -1 | 601, 181 | ||
| 1 | 0.0 | Label 19 | T | -1 | 671, 181 | ||
| 1 | 0.0 | Label 21 | T | -1 | 751, 181 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 0, 0 |