Program drill-down
MARKET_HALL_MAN
MARKET HALL MAN. Type MAN, base table MARKET_HALL.
Field inventory
43
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | CMD 5 | C | 0 | 141, 529 | '$SELECT 'W:MARKET_HALL;Y;;MH_HALL=I\AREA_NAME,MH_DESCRIPTION=I\DESCRIPTION,MH_AREAI\FLOOR_SPACE;MH_HALL='$I\AREA_NAME$'; 'A:CONST;;I\AREA_NAME,I\DESCRIPTION,I\FLOOR_SPACE 'O:SETFOCUS;I\AREA_NAME |
|
| 1 | 0.0 | CMD 7 | C | 0 | 251, 373 | '$SELECT 'S:AGENT_CODE;I\AGENT |
|
| 1 | 0.0 | CMD 3 | C | 0 | 251, 409 | '$SELECT 'S:SALESMAN_AGENT;I\SLS_CODE;I\AGENT |
|
| 1 | 0.0 | CMD 5 | C | 0 | 431, 109 | ||
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | Work 8 | I | 0 | 1, 61 | $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 O:SETFOCUS;I\AREA_NAME |
|
| 1 | 0.0 | Work 9 | I | 0 | 81, 61 | $DEFAULT A:DATE;DD MMM YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME A:TIMER_ON;1000 '$CALCULATE 'U:ZZGRID_SPLIT;INIT_GRID;G\GRIDM;I\LV_CODE,I\LV_DESC,I\LV_CALC_TYPE,I\LV_RATE,I\LV_MRATE,I\LV_VATCD,I\LV_BOARD 'U:ZZGRID_SPLIT;DB_TO_GRID;G\GRIDM;LEVY_MAST 'O:SETFOCUS;I\DA_CODE '$BEFORE_DELETE |
|
| 1 | 0.0 | MARKET_HALL | MH_AREA | I | -1 | 331, 253 | $VALIDATE 'I:I\FLOOR_SPACE;<>; 'DO(AREA1) ' O:ENABLEINPUT;I\AREA_NAME,I\AREA_PERC ' O:SETFOCUS;B\UPDATE 'DOEND(AREA1) A:SUB;I\FLOOR_SPACE;I\SPACE_ADD;I\SPACE_OR I:I\AVAILABLE_SPACE;<;I\SPACE_ADD DO(CORR01) A:SUB;I\SPACE_ADD;I\SPACE_TOO_M;I\AVAILABLE_SPACE ' O:SETFOCUS;I\FLOOR_SPACE ' O:SHOW;T\PRE |
| 1 | 0.0 | Work 6 | I | 0 | 141, 373 | '$SELECT 'S:AGENT_CODE;I\AGENT '$VALIDATE 'M: '$CALCULATE 'C:UCASE 'I:I\AGENT;<>; 'F:AGENT_MAST;Y;;T\AGENT=AM_NAME,I\FLOOR_SPACE=AM_FLOOR_SPACE;AM_CODE='$I\AGENT$';I\AGENT 'I:I\FLOOR_SPACE;<>; O:ENABLEINPUT;I\AREA_NAME,I\AREA_PERC |
|
| 1 | 0.0 | MARKET_HALL | MH_HALL | I | -1 | 331, 109 | '$SELECT 'S:AGENT_CODE;I\AGENT $VALIDATE M: $CALCULATE C:UCASE 'I:I\AGENT;<>; F:MARKET_HALL;;;I\AREA_NAME=MH_HALL,I\DESCRIPTION=MH_DESCRIPTION,I\FLOOR_SPACE=MH_AREA;MH_HALL='$I\AREA_NAME$';I\AREA_NAME A:VAR;I\FLOOR_SPACE;I\SPACE_OR F:CLIENT_MAST;Y;;I\TOT_SPACE=CM_TOT_HALL_FLR_SPACE;CM_CODE='$I\MARKET$';I |
| 1 | 0.0 | Work 11 | I | 0 | 141, 445 | ||
| 1 | 0.0 | Work 2 | I | 0 | 141, 409 | '$SELECT 'S:SALESMAN_AGENT;I\SLS_CODE;I\AGENT '$CALCULATE 'M: 'C:UCASE 'A:VAR;I\SLS_CODE;I\SLS_CODE;;000 'F:SALESMAN_MAST;;SLS_CODE;T\SALESMAN=SLS_NAME;SLS_AGENT='$I\AGENT$';I\SLS_CODE |
|
| 1 | 0.0 | Label 6 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 7 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 5 | T | -1 | 271, 49 | ||
| 1 | 0.0 | Label 3 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 4 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 2 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 1 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 3 | T | -1 | 31, 109 | ||
| 1 | 0.0 | Label 4 | T | 0 | 31, 445 | ||
| 1 | 0.0 | Label 1 | T | 0 | 31, 373 | ||
| 1 | 0.0 | Label 2 | T | -1 | 31, 253 | ||
| 1 | 0.0 | Label 8 | T | 0 | 291, 373 | ||
| 1 | 0.0 | Label 12 | T | 0 | 461, 109 | ||
| 1 | 0.0 | Label 1 | T | 0 | 31, 409 | ||
| 1 | 0.0 | Label 4 | T | 0 | 291, 409 | ||
| 1 | 0.0 | Work 6 | I | 0 | 451, 217 | ||
| 1 | 0.0 | Work 1 | I | 0 | 611, 253 | ||
| 1 | 0.0 | Label 1 | T | -1 | 31, 145 | ||
| 1 | 0.0 | MARKET_HALL | MH_DESCRIPTION | I | -1 | 331, 145 | $CALCULATE 'F:MARKET_HALL;;;I\USED_SPACE=SUM(MH_AREA);;I\DESCRIPTION 'A:SUB;I\TOT_SPACE;I\AVAILABLE_SPACE;I\USED_SPACE 'I:I\FLOOR_SPACE;<>; ' O:ENABLEINPUT;I\AREA_NAME,I\AREA_PERC |
| 1 | 0.0 | Label 2 | T | -1 | 31, 181 | ||
| 1 | 0.0 | Work 3 | I | -1 | 331, 181 | ||
| 1 | 0.0 | Label 4 | T | -1 | 31, 217 | ||
| 1 | 0.0 | Work 4 | I | 0 | 561, 325 | ||
| 1 | 0.0 | Work 5 | I | -1 | 331, 217 | ||
| 1 | 0.0 | Work 2 | I | 0 | 561, 289 | ||
| 1 | 0.0 | Label 3 | T | 0 | 451, 253 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_EXIT | Z | 0 | 0, 0 | ||
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 0, 0 | $SELECT A:CONST;;I\AREA_NAME,I\DESCRIPTION,I\FLOOR_SPACE 'O:HIDE;T\PREV,I\SPACE_OR O:SETFOCUS;I\AREA_NAME |