Program drill-down
SLS_SECT_ACCESS_MDL
SALES SECTION ACCESS. Type MDL, base table SLSSECT_ACCESS.
Field inventory
29
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | H | -1 | 0, 30 | |||
| 1 | 0.0 | SLSSECT_ACCESS | SS_AGENT | I | -1 | 191, 217 | $SELECT 'SELECT THE AGENT CODE S:AGENT_CODE;I\SS_AGENT $VALIDATE 'MANDATORY FIELD M: 'CONVERT TO UPPERCASE C:UCASE 'LOOK UP THE ENTERED CODE ON THE AGENT_MAST TABLE, IF IT DOESNT EXIST DISPLAY AN ERROR. F:AGENT_MAST;Y;;I\SS_AGENT=AM_CODE;AM_CODE='$I\SS_AGENT$';I\SS_AGENT U:ZZGRID_SPLIT;DB_TO_GRID;G\GRID;SLS |
| 1 | 0.0 | SLSSECT_ACCESS | SS_AGENT | T | -1 | 191, 193 | |
| 1 | 0.0 | SLSSECT_ACCESS | SS_IP | I | -1 | 371, 217 | $SELECT S:PORT_NO;I\SS_IP;I\SS_AGENT $VALIDATE 'MANDATORY FIELD M: I:I\SS_IP;<>; F:IP_MAST;Y;;;IM_PORT='$I\SS_IP$';I\SS_IP |
| 1 | 0.0 | CMD 1 | C | -1 | 611, 217 | $SELECT S:PORT_NO;I\SS_IP;I\SS_AGENT |
|
| 1 | 0.0 | Work 1 | I | 0 | 11, 85 | ||
| 1 | 0.0 | SLSSECT_ACCESS | SS_IP | T | -1 | 371, 193 | |
| 1 | 0.0 | SLSSECT_ACCESS | SS_SECT | I | -1 | 291, 217 | $SELECT 'SELECT THE SECTION CODE S:SLS_SECT_PRT;I\SS_SECT;I\SS_AGENT $CALCULATE 'MANDATORY FIELD M: 'CHECKS IF THE ENTERED DATA IS NUMERIC, IF IT IS, IT IS FORMATTED TO '000' A:ISNUMERIC;I\SS_SECT;I\TMP1 I:I\TMP1;=;Y A:VAR;I\SS_SECT;I\SS_SECT;;000 'LOOKS UP THE ENTERED CODE ON THE SECT_MAST TABLE. IF IT |
| 1 | 0.0 | SLSSECT_ACCESS | SS_SECT | T | -1 | 291, 193 | |
| 1 | 0.0 | Work 4 | G | -1 | 191, 241 | ||
| 1 | 0.0 | CMD 5 | C | -1 | 261, 217 | $SELECT S:AGENT_CODE;I\SS_AGENT |
|
| 1 | 0.0 | CMD 6 | C | -1 | 341, 217 | $SELECT $SELECT 'SELECT THE SECTION CODE S:SLS_SECT_PRT;I\SS_SECT;I\SS_AGENT |
|
| 1 | 0.0 | Label 7 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 8 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 9 | T | -1 | 241, 49 | ||
| 1 | 0.0 | Label 10 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 11 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 12 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 13 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Work 14 | I | 0 | 41, 61 | $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 |
|
| 1 | 0.0 | Work 15 | I | 0 | 11, 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 'INITIALISES THE GRID, AND FILLS IT WITH DATA U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\SS_AGENT,I\SS_SECT,I\SS_IP 'U:ZZGRID_SPLIT;DB_TO_GRID;G\GRID;SLSSECT_ACCESS |
|
| 1 | 0.0 | Work 16 | I | 0 | 41, 529 | ||
| 1 | 0.0 | Work 1 | I | 0 | 671, 217 | ||
| 1 | 0.0 | Work 2 | I | 0 | 11, 121 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 0, 30 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 0, 30 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 0, 30 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 0, 30 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 0, 30 |