Program drill-down
SUPPL_PALL_ACC_MAN
SUPPLIER PALLET ACCOUNT. Type MAN, base table SUPPL_PALL_ACC.
Field inventory
42
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | Label 16 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 8 | T | -1 | 291, 25 | ||
| 1 | 0.0 | H | -1 | 1, 1 | |||
| 1 | 0.0 | Label 14 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 15 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 17 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 21 | T | -1 | 1, 25 | ||
| 1 | 0.0 | SUPPL_PALL_ACC | SP_ACCNO | I | -1 | 531, 181 | $CALCULATE 'MANDATORY FIELD M: 'CONVERT TO UPPERCASE C:UCASE A:LEN;I\SP_ACCNO;W\TMP I:W\TMP;<;10 D:ACCOUNT NUMBER MUST BE 10 NUMERIC DIGITS LONG;ERRORM;I\SP_ACCNO A:LEFT;I\SP_ACCNO,2;W\TMP1 I:W\TMP1;<>;27 DO(00) I:W\TMP1;<>;01 DO(11) I:W\TMP1;<>;10 DO(12) D:FIRST TWO DIGITS MUST BE EI |
| 1 | 0.0 | Label 9 | T | -1 | 221, 49 | ||
| 1 | 0.0 | SUPPL_PALL_ACC | SP_SUPPL | I | -1 | 41, 181 | $DEFAULT A:PARM;1 A:VAR;I\SP_SUPPL;I\TMP_SUPPL $SELECT 'CALLS THE SUPPLIER_MAST SELECTION I:I\AGENT;<>; S:SUPPLIER_MAST1;I\SP_SUPPL;I\AGENT I:I\AGENT;=; S:SUPPLIER_MAST;I\SP_SUPPL $VALIDATE 'MANDATORY FIELD M: I:I\TMP_SUPPL;<>; DO(001) I:I\TMP_SUPPL;<>;I\SP_SUPPL D:YOU CAN ONLY EDIT SUPPLIE |
| 1 | 0.0 | Work 1 | I | 0 | 31, 97 | $DEFAULT 'INITIALIZES THE GIRD WITH ITS COLUMNS EQUAL TO THE FIELDS ALONG THE TOP U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SP_SUPPL,I\NAME,I\SP_TYPE,I\PALL,I\SP_ACCNO,I\SP_DATE_JOINED 'U:ZZGRID_SPLIT;DB_TO_GRID;G\GRID;SUPPL_PALL_ACC;I\SP_SUPPL; 'U:GRID_DESC_LOAD;LOAD;G\GRID,I\SP_SUPPL,SUM_NAME,SUPPLIER_MAST,SUM_SUPPL,I\ |
|
| 1 | 0.0 | SUPPL_PALL_ACC | SP_ACCNO | T | -1 | 531, 133 | |
| 1 | 0.0 | CMD 2 | C | -1 | 121, 181 | $SELECT I:I\AGENT;<>; S:SUPPLIER_MAST1;I\SP_SUPPL;I\AGENT I:I\AGENT;=; S:SUPPLIER_MAST;I\SP_SUPPL |
|
| 1 | 0.0 | Work 3 | G | -1 | 41, 205 | ||
| 1 | 0.0 | SUPPL_PALL_ACC | SP_SUPPL | T | -1 | 41, 157 | |
| 1 | 0.0 | SUPPL_PALL_ACC | SP_DATE_JOINED | T | -1 | 661, 157 | |
| 1 | 0.0 | SUPPL_PALL_ACC | SP_DATE_JOINED | I | -1 | 651, 181 | $VALIDATE I:I\SP_DATE_JOINED;=; A:DATE;DD MMM YYYY;I\SP_DATE_JOINED |
| 1 | 0.0 | Work 6 | I | 0 | 451, 469 | ||
| 1 | 0.0 | SUPPL_PALL_ACC | SP_TYPE | T | -1 | 301, 157 | |
| 1 | 0.0 | SUPPL_PALL_ACC | SP_TYPE | I | -1 | 301, 181 | $SELECT 'CALLS THE PALLET_TYPE SELECTION S:PALLET_TYPE;I\SP_TYPE $VALIDATE 'MANDATORY FIELD M: 'CONVERT TO UPPERCASE C:UCASE A:ISNUMERIC;I\SP_TYPE;I\TMP30 I:I\TMP30;=;Y A:VAR;I\SP_TYPE;I\SP_TYPE;;00 'LOOKS UP THE ENTERED VALUE IN THE DATABASE. IF IT DOES NOT EXIST, DISPOLAY AN ERROR F:PALL_TYPE;Y;;I\PALL= |
| 1 | 0.0 | CMD 3 | C | -1 | 361, 181 | $SELECT S:PALLET_TYPE;I\SP_TYPE |
|
| 1 | 0.0 | Work 2 | I | 0 | 91, 433 | ||
| 1 | 0.0 | SUPPL_PALL_ACC | SP_MARKET | I | 0 | 61, 97 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\SP_MARKET A:ORGS;;I\AGENT 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME C:MCASE;;T\MARKET |
| 1 | 0.0 | Work 1 | I | 0 | 400, 463 | ||
| 1 | 0.0 | Work 1 | I | -1 | 151, 181 | ||
| 1 | 0.0 | Work 2 | I | -1 | 391, 181 | ||
| 1 | 0.0 | Label 3 | T | -1 | 531, 157 | ||
| 1 | 0.0 | Label 4 | T | -1 | 151, 157 | ||
| 1 | 0.0 | Label 5 | T | -1 | 401, 157 | ||
| 1 | 0.0 | TMP_SUPPL | I | 0 | 91, 469 | ||
| 1 | 0.0 | Work 1 | I | 0 | 141, 469 | ||
| 1 | 0.0 | Work 7 | I | 0 | 401, 493 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 1, 1 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 1, 1 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 1, 1 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 1, 1 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 1, 1 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 1, 1 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 1, 1 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 1, 1 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 1, 1 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 1, 1 |