Program drill-down
ALLOCATE_REG_DELIV
ALLOCATE REGION CODE. Type DSP, base table SUPPL_REGION.
Field inventory
35
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | CMD 1 | C | -1 | 281, 313 | $SELECT U:ALLOCATE_REGION;UPDATE A:CONST;;I\SR_SUPPL,I\SR_REGION,T\NAME,T\RNAME,I\FLAG,I\DEFAULT,W\DEFAULT,I\ST_AGENT,I\DELNO O:SETFOCUS;I\ST_AGENT |
|
| 1 | 0.0 | CMD 2 | C | -1 | 381, 205 | $SELECT S:SUPPLIER;I\SR_SUPPL |
|
| 1 | 0.0 | CMD 4 | C | -1 | 381, 241 | $SELECT S:REGION_CODE;I\SR_REGION |
|
| 1 | 0.0 | H | -1 | 1, 25 | |||
| 1 | 0.0 | Work 1 | I | 0 | 11, 217 | ||
| 1 | 0.0 | Work 3 | I | 0 | 11, 193 | ||
| 1 | 0.0 | I | -1 | 281, 205 | $SELECT S:SUPPLIER;I\SR_SUPPL $VALIDATE C:UCASE M: A:ZEROFILL;I\SR_SUPPL,6;I\SR_SUPPL C:UCASE F:SUPPLIER_MAST;Y;;T\NAME=SUM_NAME;SUM_SUPPL='$I\SR_SUPPL$';I\SR_SUPPL |
||
| 1 | 0.0 | I | -1 | 281, 241 | $SELECT S:REG_SUPPL;I\SR_REGION;I\SR_SUPPL $VALIDATE C:UCASE M: ''A:ZEROFILL;I\SR_REGION,10;I\SR_REGION F:REGION_MAST;Y;;T\RNAME=RGM_DESC;RGM_CODE='$I\SR_REGION$';I\SR_REGION O:SETFOCUS;C\RUN O:BACKCOLOR;C\RUN;YELLOW |
||
| 1 | 0.0 | Work 1 | I | 0 | 11, 169 | ||
| 1 | 0.0 | SUPPL_REGION | SR_MARKET | I | 0 | 51, 73 | $DEFAULT 'LOAD MARKET CODE A:ORG;;I\MARKET A:CONST;$I\MARKET$;I\SR_MARKET 'LOAD MARKET NAME F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME C:MCASE;;T\MARKET |
| 1 | 0.0 | DEFAULT | I | 0 | 1, 73 | $DEFAULT A:DATE;DD MMM YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME A:TIMER_ON;1000 O:DISABLEINPUT;I\FM_DATE,I\FM_TIME,I\FM_RANDS_PERKG,I\FM_STANDARD |
|
| 1 | 0.0 | Work 7 | I | 0 | 11, 133 | ||
| 1 | 0.0 | Label 3 | T | -1 | 151, 241 | ||
| 1 | 0.0 | Label 8 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 2 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 7 | T | -1 | 301, 49 | ||
| 1 | 0.0 | T | -1 | 151, 205 | |||
| 1 | 0.0 | Label 9 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 5 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 1 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 6 | T | -1 | 671, 49 | ||
| 1 | 0.0 | Label 3 | T | -1 | 411, 205 | ||
| 1 | 0.0 | Label 5 | T | -1 | 411, 241 | ||
| 1 | 0.0 | Work 1 | I | -1 | 281, 169 | $SELECT I:I\AGENT;<>; S:DELIVERY_NO2;I\DELNO;I\MARKET;I\ST_AGENT I:I\ST_AGENT;=; S:DELIVNO_ENQ;I\DELNO;I\MARKET $VALIDATE 'MAKE THIS FIELD MANDATORY M: I:I\DELNO;<>; A:ZEROFILL;I\DELNO,6;I\DELNO F:STK_MAST;Y;;I\SR_SUPPL=SM_SUPP,I\ST_AGENT=SM_AGENT;SM_DELNO = '$I\DELNO$';I\DELNO |
|
| 1 | 0.0 | Label 2 | T | -1 | 151, 169 | ||
| 1 | 0.0 | Label 2 | T | -1 | 151, 133 | ||
| 1 | 0.0 | CMD 1 | C | -1 | 381, 169 | $SELECT I:I\AGENT;<>; S:DELIVERY_NO2;I\DELNO;I\MARKET;I\ST_AGENT I:I\ST_AGENT;=; S:DELIVNO_ENQ;I\DELNO;I\MARKET |
|
| 1 | 0.0 | Label 3 | T | -1 | 411, 133 | ||
| 1 | 0.0 | CMD 2 | C | -1 | 381, 133 | $SELECT S:AGENT_CODE;I\ST_AGENT |
|
| 1 | 0.0 | Work 1 | I | -1 | 281, 133 | $SELECT S:AGENT_CODE;I\ST_AGENT $CALCULATE M: C:UCASE 'LOAD AGENT NAME F:AGENT_MAST;;;T\AGENT_NAME=AM_NAME;AM_CODE='$I\ST_AGENT$';I\ST_AGENT |
|
| 10 | 0.0 | ZX_UPDATE | Z | 0 | 1, 25 | $AFTER_WRITE I:W\DEFAULT;=;Y DO(1) U:SUPPLIER_REGION;UPDATE DOEND(1) |
|
| 10 | 0.0 | ZX_EXIT | Z | 0 | 1, 25 | ||
| 10 | 0.0 | ZX_SELECT | Z | 0 | 1, 25 | ||
| 10 | 0.0 | ZX_DELETE | Z | 0 | 1, 25 | ||
| 10 | 0.0 | ZX_PRINT | Z | 0 | 1, 25 |