Program drill-down
VARIETYS_MAN
VARIETY MAINTENANCE. Type MAN, base table VAR_MAST.
Field inventory
45
Live detail pulled from the database.
| Page | Seq | Table | Field | Type | Visible | Position | Logic snippet |
|---|---|---|---|---|---|---|---|
| 1 | 0.0 | CMD 2 | C | -1 | 131, 193 | $SELECT S:VARIETY;I\VA_VARIETY;I\VA_PRODUCT |
|
| 1 | 0.0 | CMD 1 | C | -1 | 51, 193 | $SELECT S:PRODUCT;I\VA_PRODUCT |
|
| 1 | 0.0 | H | -1 | 0, 0 | |||
| 1 | 0.0 | VAR_MAST | VA_PRODUCT | I | -1 | 11, 193 | $SELECT S:PRODUCT;I\VA_PRODUCT $VALIDATE M: C:UCASE A:CONST;;I\VATCD,I\VAT_CODE $CALCULATE A:CONST;;I\VA_VARIETY,I\VA_DESC,I\VA_PROV_REQ,I\VA_VAR_USED,I\VA_NDAVARIETY,I\VA_BLOCKED,I\VATCD,I\VAT_CODE F:PRODUCT_MAST;Y;;I\VA_PRODUCT=PR_PRODUCT,I\VATCD=PR_VATCD,W\BLOCKED=PR_BLOCKED;PR_PRODUCT='$I\VA_PRODUCT$';I |
| 1 | 0.0 | VAR_MAST | VA_PRODUCT | T | -1 | 11, 169 | |
| 1 | 0.0 | VAR_MAST | VA_DESC | I | -1 | 241, 193 | $VALIDATE M: C:UCASE |
| 1 | 0.0 | VAR_MAST | VA_DESC | T | -1 | 241, 169 | |
| 1 | 0.0 | VAR_MAST | VA_VARIETY | I | -1 | 81, 193 | $SELECT S:VARIETY;I\VA_VARIETY;I\VA_PRODUCT $VALIDATE M: C:UCASE A:LEN;I\VA_VARIETY;I\TMPLEN I:I\TMPLEN;<>;2 D:VARIETY CODE MUST BE TWO CHARACTERS;ERRORM;I\VA_VARIETY U:ZZGRID_SPLIT;DB_TO_GRID;G\VARIETY;VAR_MAST,VA_PRODUCT='I\VA_PRODUCT',VA_VARIETY='I\VA_VARIETY' |
| 1 | 0.0 | CMD 3 | C | -1 | 211, 193 | $SELECT S:VATCD;I\VA_VATCD;I\VA_PRODUCT |
|
| 1 | 0.0 | VAR_MAST | VA_VARIETY | T | -1 | 81, 169 | |
| 1 | 0.0 | VAR_MAST | VA_NDAVARIETY | I | -1 | 581, 193 | $VALIDATE M: C:UCASE |
| 1 | 0.0 | VAR_MAST | VA_NDAVARIETY | T | -1 | 581, 145 | |
| 1 | 0.0 | Label 8 | T | -1 | 301, 49 | ||
| 1 | 0.0 | Label 1 | T | -1 | 291, 25 | ||
| 1 | 0.0 | Label 2 | T | -1 | 1, 25 | ||
| 1 | 0.0 | Label 3 | T | -1 | 621, 25 | ||
| 1 | 0.0 | Label 4 | T | -1 | 621, 49 | ||
| 1 | 0.0 | Label 5 | T | -1 | 671, 25 | ||
| 1 | 0.0 | Label 6 | T | -1 | 671, 49 | ||
| 1 | 0.0 | DEFAULT | I | 0 | 1, 49 | $DEFAULT A:DATE;DD MMM/YYYY;T\DATE A:TIME;HH:MM:SS;T\TIME A:TIMER_ON;1000 U:ZZGRID_SPLIT;INIT_GRID;G\VARIETY;I\VA_PRODUCT,I\VA_VARIETY,I\VA_VATCD,I\VA_DESC,I\VA_PROV_REQ,I\VA_VAR_USED,I\VA_NDAVARIETY,I\VA_BLOCKED,I\VA_BAR_CODE 'U:ZZGRID_SPLIT;DB_TO_GRID;G\VARIETY;VAR_MAST $AFTER_READ I:I\VA_BLOCKED;=; A:C |
|
| 1 | 0.0 | Work 3 | G | -1 | 11, 217 | ||
| 1 | 0.0 | Work 24 | I | 0 | 41, 49 | $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 | Label 2 | T | -1 | 511, 169 | ||
| 1 | 0.0 | VAR_MAST | VA_VAR_USED | I | -1 | 511, 193 | $VALIDATE C:UCASE V:Y;N; I:I\VA_VAR_USED;=; A:CONST;Y;I\VA_VAR_USED |
| 1 | 0.0 | VAR_MAST | VA_VAR_USED | T | -1 | 511, 145 | |
| 1 | 0.0 | Label 3 | T | -1 | 581, 169 | ||
| 1 | 0.0 | Label 1 | T | -1 | 641, 169 | ||
| 1 | 0.0 | VAR_MAST | VA_BLOCKED | I | -1 | 641, 193 | $VALIDATE 'CONVERT TO UPPERCASE C:UCASE 'ALLOW ONLY Y OR N V:Y;N; I:I\VA_BLOCKED;=; A:CONST;N;I\VA_BLOCKED |
| 1 | 0.0 | Label 1 | T | -1 | 701, 169 | ||
| 1 | 0.0 | I | 0 | 121, 529 | |||
| 1 | 0.0 | TMPLEN | I | 0 | 61, 529 | ||
| 1 | 0.0 | BLOCKED | I | 0 | 101, 529 | ||
| 1 | 0.0 | Label 4 | T | -1 | 471, 169 | ||
| 1 | 0.0 | VAR_MAST | VA_PROV_REQ | T | 0 | 451, 85 | |
| 1 | 0.0 | VAR_MAST | VA_PROV_REQ | I | -1 | 471, 193 | $VALIDATE C:UCASE V:Y;N; I:I\VA_PROV_REQ;=; A:CONST;N;I\VA_PROV_REQ |
| 1 | 0.0 | VAR_MAST | VA_BAR_CODE | I | -1 | 691, 193 | |
| 1 | 0.0 | Label 2 | T | -1 | 161, 145 | ||
| 1 | 0.0 | Label 3 | T | -1 | 471, 145 | ||
| 1 | 0.0 | Label 4 | T | -1 | 161, 169 | ||
| 1 | 0.0 | VAR_MAST | VA_VATCD | I | -1 | 161, 193 | $SELECT S:VATCD;I\VA_VATCD;I\VA_PRODUCT '$CALCULATE 'I:I\VATCD;<>;I\VA_VATCD 'A:CONST;$I\VA_VATCDE$;I\VATCD |
| 10 | 0.0 | ZX_PRINT | Z | 0 | 0, 0 | ||
| 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 |