Program drill-down
PALLET_MAN
PALLET MAINTENANCE. Type MDL, base table PALL_MAST.
Field inventory
69
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | PALL_MAST | PM_PALL | I | -1 | 241, 97 | $SELECT S:PALLET_CODE;I\PM_PALL $VALIDATE M: C:UCASE 'A:ISNUMERIC;I\PM_PALL;I\TMP1 F:PALL_MAST;;;I\TMP_NEW=PM_PALL;PM_PALL='$I\PM_PALL$' I:I\TMP_NEW;<>; F:PALL_MAST;;;I\TMP_OLDFEE=PM_PALFEE,I\DELIND=PM_DELIND;PM_PALL='$I\PM_PALL$' I:I\DELIND;=;Y D:THE PALLET HAS ALREADY BEEN DELETED;ERRORM;I\PM_PALL |
| 1 | 0.0 | PALL_MAST | PM_PALFEE | T | -1 | 51, 385 | |
| 1 | 0.0 | PALL_MAST | PM_MINPER | T | -1 | 351, 421 | |
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | PALL_MAST | PM_ALTDESC | I | -1 | 241, 205 | $VALIDATE C:UCASE |
| 1 | 0.0 | PALL_MAST | PM_ALTDESC | T | -1 | 51, 205 | |
| 1 | 0.0 | Label 22 | T | -1 | 1, 25 | ||
| 1 | 0.0 | PALL_MAST | PM_DEPOSIT | T | -1 | 51, 349 | |
| 1 | 0.0 | PALL_MAST | PM_DESC | I | -1 | 241, 169 | $VALIDATE M: C:UCASE |
| 1 | 0.0 | PALL_MAST | PM_DESC | T | -1 | 51, 169 | |
| 1 | 0.0 | CMD 21 | C | -1 | 291, 313 | $SELECT 'S:SECT_MAST;I\PM_SECT S:SECTION_CODE;I\PM_SECT |
|
| 1 | 0.0 | Label 1 | T | -1 | 51, 493 | ||
| 1 | 0.0 | Work 1 | I | 0 | 421, 505 | ||
| 1 | 0.0 | PALL_MAST | PM_DELIND | I | 0 | 81, 529 | |
| 1 | 0.0 | PALL_MAST | PM_MAXPER | T | -1 | 351, 385 | |
| 1 | 0.0 | PALL_MAST | PM_DF_VATCDE | T | -1 | 451, 265 | |
| 1 | 0.0 | PALL_MAST | PM_FEEVAT | T | -1 | 451, 301 | |
| 1 | 0.0 | PALL_MAST | PM_BLOCK_PALL | I | -1 | 201, 493 | $VALIDATE C:UCASE I:I\BLOCK_PALL;=; V:Y;N |
| 1 | 0.0 | PALL_MAST | PM_PALL | T | -1 | 51, 97 | |
| 1 | 0.0 | PALL_MAST | PM_RETDAYS | T | -1 | 351, 349 | |
| 1 | 0.0 | PALL_MAST | PM_SECT | T | -1 | 51, 313 | |
| 1 | 0.0 | PALL_MAST | PM_TYPE | T | -1 | 51, 241 | |
| 1 | 0.0 | PALL_MAST | PM_USAGE | T | -1 | 51, 457 | |
| 1 | 0.0 | Label 1 | T | -1 | 51, 277 | ||
| 1 | 0.0 | PALL_MAST | PM_USAGE_FEE | T | -1 | 51, 421 | |
| 1 | 0.0 | CMD 20 | C | -1 | 291, 241 | $SELECT S:PALLET;I\PM_TYPE |
|
| 1 | 0.0 | CMD 19 | C | -1 | 301, 97 | $SELECT S:PALLET_CODE;I\PM_PALL |
|
| 1 | 0.0 | Label 23 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 24 | T | -1 | 307, 49 | ||
| 1 | 0.0 | Label 25 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 26 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 27 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 28 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Work 1 | I | 0 | 71, 61 | $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 O:HIDE;T\CHEP_PALL,I\CHEP_PALL $BEFORE_DELETE 'NOT ALLOW USERS TO DELETE WHILE THESE FIELDS ARE EMPTY I:I\PM_PALL;=; DO I:I\PM_DESC;=; I:I\PM_TYPE;=; |
|
| 1 | 0.0 | Work 2 | I | 0 | 81, 553 | ||
| 1 | 0.0 | CMD 3 | C | -1 | 661, 265 | $SELECT S:VAT;I\PM_DF_VATCDE |
|
| 1 | 0.0 | CMD 4 | C | -1 | 661, 301 | $SELECT S:VAT;I\PM_FEEVAT |
|
| 1 | 0.0 | Work 13 | I | 0 | 101, 61 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\MARKET 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME C:MCASE;;T\MARKET |
|
| 1 | 0.0 | PALL_MAST | PM_SUPPL_ID | I | -1 | 241, 133 | |
| 1 | 0.0 | PALL_MAST | PM_SUPPL_ID | T | -1 | 51, 133 | |
| 1 | 0.0 | Work 17 | I | 0 | 161, 553 | ||
| 1 | 0.0 | Label 3 | T | 0 | 331, 553 | ||
| 1 | 0.0 | Label 1 | T | -1 | 731, 289 | ||
| 1 | 0.0 | Label 2 | T | -1 | 731, 325 | ||
| 1 | 0.0 | Label 4 | T | 0 | 281, 553 | ||
| 1 | 0.0 | Work 18 | I | 0 | 201, 553 | ||
| 1 | 0.0 | Work 1 | I | 0 | 381, 97 | ||
| 1 | 0.0 | Work 44 | I | 0 | 701, 517 | $BEFORE_WRITE I:I\TMP_NEW;<>; DO(APL) I:I\TMP_NEW;<>;I\TMP_OLDFEE;NUM U:PALLET_MAST;UPDATE_HISTORY DOEND(APL) |
|
| 1 | 0.0 | Work 45 | I | 0 | 681, 517 | ||
| 1 | 0.0 | Work 46 | I | 0 | 661, 517 | ||
| 1 | 0.0 | Label 47 | T | 0 | 621, 517 | ||
| 1 | 0.0 | Work 1 | I | 0 | 401, 505 | ||
| 1 | 1.0 | PALL_MAST | PM_SECT | I | -1 | 241, 313 | $SELECT 'S:SECT_MAST;I\PM_SECT S:SECTION_CODE;I\PM_SECT $VALIDATE 'MAKE THIS FIELD MANDATORY M: 'DISPLAY ERROR MESSAGE IF NON-EXISTING VALUE IS ENTERED F:SECT_MAST;Y;;I\PM_SECT=SE_SECT;SE_SECT='$I\PM_SECT$';I\PM_SECT |
| 1 | 1.0 | PALL_MAST | PM_TYPE | I | -1 | 241, 241 | $SELECT 'DISPLAY SELECTION WINDOW S:PALLET;I\PM_TYPE $VALIDATE 'MAKE THIS FIELD MANDATORY M: C:UCASE A:ISNUMERIC;I\PM_TYPE;I\TMP11 I:I\TMP11;=;Y A:VAR;I\PM_TYPE;I\PM_TYPE;;00 'DISPLAY ERROR MESSAGE IF NON-EXISTING VALUE IS ENTERED F:PALL_TYPE;Y;;I\PM_TYPE=PTP_TYPE;PTP_TYPE='$I\PM_TYPE$' I:I\PM_TYPE; |
| 1 | 1.0 | I | -1 | 241, 277 | |||
| 1 | 2.0 | PALL_MAST | PM_FEEVAT | I | -1 | 621, 301 | $SELECT S:VAT;I\PM_FEEVAT $VALIDATE M: A:VAR;I\PM_FEEVAT;I\PM_FEEVAT;;00 F:VAT_MAST;Y;;I\TMP3=VT_RATE;VT_CODE='$I\PM_FEEVAT$' A:CON;I\TMP3;T\FEE;"%" |
| 1 | 2.0 | PALL_MAST | PM_DF_VATCDE | I | -1 | 621, 265 | $SELECT S:VAT;I\PM_DF_VATCDE $VALIDATE M: A:VAR;I\PM_DF_VATCDE;I\PM_DF_VATCDE;;00 F:VAT_MAST;Y;;I\TMP2=VT_RATE;VT_CODE='$I\PM_DF_VATCDE$' A:CON;I\TMP2;T\DEP;"%" |
| 1 | 3.0 | PALL_MAST | PM_PALFEE | I | -1 | 201, 385 | $VALIDATE I:I\PM_PALFEE;<>; DO I:I\PM_PALFEE;<;0 D:CANNOT BE LESS THAN ZERO;ERRORM;I\PM_PALFEE DOEND F:PALL_MAST;;;I\TMP_OLDFEE=PM_PALFEE;PM_PALL='$I\PM_PALL$' |
| 1 | 3.0 | PALL_MAST | PM_DEPOSIT | I | -1 | 201, 349 | $VALIDATE I:I\PM_DEPOSIT;<>; DO I:I\PM_DEPOSIT;<;0 D:CANNOT BE LESS THAN ZERO;ERRORM;I\PM_DEPOSIT DOEND |
| 1 | 3.0 | PALL_MAST | PM_USAGE | I | -1 | 201, 457 | $VALIDATE I:I\PM_USAGE;<>; DO I:I\PM_USAGE;<;0 D:USAGE PERIOD CANNOT BE LESS THAN ZERO;ERRORM;I\PM_USAGE DOEND |
| 1 | 3.0 | PALL_MAST | PM_USAGE_FEE | I | -1 | 201, 421 | $VALIDATE I:I\PM_USAGE_FEE;<>; DO I:I\PM_USAGE_FEE;<;0 D:CANNOT BE LESS THAN ZERO;ERRORM;I\PM_USAGE_FEE DOEND |
| 1 | 4.0 | PALL_MAST | PM_MINPER | I | -1 | 521, 421 | $VALIDATE I:I\PM_MINPER;<>; DO I:I\PM_MINPER;<;0 D:CANNOT BE LESS THAN ZERO;ERRORM;I\PM_MINPER I:I\PM_MINPER;>=;I\PM_MAXPER;NUM D:MAX DAYS MUST BE GREATER THAN MIN DAYS;ERRORM;I\PM_MINPER DOEND |
| 1 | 4.0 | PALL_MAST | PM_MAXPER | I | -1 | 521, 385 | $VALIDATE I:I\PM_MAXPER;<>; DO I:I\PM_MAXPER;<;0 D:CANNOT BE LESS THAN ZERO;ERRORM;I\PM_MAXPER DOEND |
| 1 | 4.0 | PALL_MAST | PM_RETDAYS | I | -1 | 521, 349 | $VALIDATE I:I\PM_RETDAYS;<>; DO I:I\PM_RETDAYS;<;0 D:CANNOT BE LESS THAN ZERO;ERRORM;I\PM_RETDAYS DOEND A:MULT;I\PM_USAGE_FEE;I\TMP4;I\PM_RETDAYS 'A:VAR;I\PM_FEEVAT;I\PM_FEEVAT;;00 'F:VAT_MAST;Y;;I\TMP3=VT_RATE;VT_CODE='$I\PM_FEEVAT$' 'A:MULT;I\TMP4;I\TMP5;I\TMP3 'A:DIV;I\TMP5;I\TMP5;100;#0.00 'A:ADD;I\T |
| 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 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 0, 0 |