Program drill-down
BUYER_PALL_ACC_MAN
BUYER PALLET ACCOUNT. Type MAN, base table BUYER_PALL_ACC.
Field inventory
41
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | Label 1 | T | -1 | 121, 181 | ||
| 1 | 0.0 | H | -1 | 1, 1 | |||
| 1 | 0.0 | Label 16 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 15 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 14 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 8 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 17 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 21 | T | -1 | 1, 25 | ||
| 1 | 0.0 | BUYER_PALL_ACC | BP_ACCNO | I | -1 | 551, 205 | $VALIDATE 'MANDATORY FIELD M: 'CONVERT TO UPPERCASE C:UCASE 'U:ACCNO;MEMBERNO;G\GRID,I\BP_ACCNO,I\BP_TYPE,I\TMP2 'I:I\TMP2;='Y 'D:ACCOUNT NUMBER ALREADY EXISTS FOR THAT PALLET TYPE;ERRORM;I\BP_ACCNO F:BUYER_PALL_ACC;;BP_ACCNO;I\TMP1=BP_BUYER;BP_BUYER<>'$I\BP_BUYER$' 'I:I\TMP1;<>; 'D:ACCOUNT NUMBER ALREADY E |
| 1 | 0.0 | Label 9 | T | -1 | 241, 49 | ||
| 1 | 0.0 | BUYER_PALL_ACC | BP_BUYER | I | -1 | 11, 205 | $SELECT 'CALLS THE BUYER DEBTOR SELECTION S:BUYER DEBTOR;I\BP_BUYER $VALIDATE 'MANDATORY FIELD M: 'CONVERT TO UPPERCASE C:UCASE 'MAKES SURE THE VALUE EXISTS IN THE DATABASE F:DEBTOR_MAST;Y;DM_DEBTOR;I\BP_NAME=DM_NAME;DM_DEBTOR='$I\BP_BUYER$';I\BP_BUYER $CALCULATE 'LOADS THE GRID WITH DATA FROM THE DATABA |
| 1 | 0.0 | BUYER_PALL_ACC | BP_ACCNO | T | -1 | 541, 181 | |
| 1 | 0.0 | CMD 2 | C | -1 | 91, 205 | $SELECT S:BUYER DEBTOR;I\BP_BUYER |
|
| 1 | 0.0 | Work 3 | G | -1 | 11, 229 | ||
| 1 | 0.0 | BUYER_PALL_ACC | BP_BUYER | T | -1 | 11, 181 | |
| 1 | 0.0 | BUYER_PALL_ACC | BP_DATE_JOINED | T | -1 | 681, 181 | |
| 1 | 0.0 | BUYER_PALL_ACC | BP_DATE_JOINED | I | -1 | 681, 205 | $VALIDATE M: |
| 1 | 0.0 | BUYER_PALL_ACC | BP_TYPE | T | -1 | 311, 181 | |
| 1 | 0.0 | BUYER_PALL_ACC | BP_TYPE | I | -1 | 311, 205 | $SELECT 'CALLS THE PALLET TYPE SELECTION S:PALLET_TYPE;I\BP_TYPE $VALIDATE 'MANDATORY FIELD M: 'CONVERT TO UPPERCASE C:UCASE 'PUT ZERO AS FIRST CHARACTER A:LEN;I\BP_TYPE;W\TEMP1 I:W\TEMP1;=;1 DO(LL) A:ISNUMERIC;I\BP_TYPE;W\TEMP2 I:W\TEMP2;=;Y A:CON;"0";I\BP_TYPE;I\BP_TYPE DOEND(LL) ' |
| 1 | 0.0 | CMD 3 | C | -1 | 371, 205 | $SELECT S:PALLET_TYPE;I\BP_TYPE |
|
| 1 | 0.0 | Work 1 | I | 0 | 51, 97 | $DEFAULT U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\BP_BUYER,I\BP_NAME,I\BP_TYPE,I\BP_DESC,I\BP_ACCNO,I\BP_DATE_JOINED U:ZZGRID_SPLIT;DB_TO_GRID;G\GRID;BUYER_PALL_ACC '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 'GET THE DESCRIPT |
|
| 1 | 0.0 | Work 3 | I | 0 | 141, 457 | ||
| 1 | 0.0 | Work 4 | I | 0 | 111, 457 | ||
| 1 | 0.0 | Work 7 | I | 0 | 71, 97 | $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 | Work 3 | I | -1 | 401, 205 | ||
| 1 | 0.0 | Work 4 | I | -1 | 121, 205 | ||
| 1 | 0.0 | Label 5 | T | -1 | 401, 181 | ||
| 1 | 0.0 | Work 2 | I | 0 | 221, 457 | ||
| 1 | 0.0 | Work 3 | I | 0 | 271, 457 | ||
| 1 | 0.0 | Work 1 | I | 0 | 11, 505 | ||
| 1 | 0.0 | Work 2 | I | 0 | 121, 505 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 1, 1 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 1, 1 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 1, 1 | ||
| 10 | 0.0 | ZX_SELECT | 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 |