Freshmark replication server

freshmark-canonical

Program drill-down

ITEM_MAN

ITEM MAINTENANCE. Type MAN, base table PRODUCT_MAST.

Field inventory

71

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Label 8 T -1 301, 25
  
1 0.0 H -1 0, 0
  
1 0.0 PRODUCT_MAST IT_ITEM I -1 191, 73
$SELECT  S:ITEM_MAST;I\IT_ITEM  $VALIDATE  M:  C:UCASE
1 0.0 PRODUCT_MAST IT_ITEM T -1 21, 73
  
1 0.0 PRODUCT_MAST IT_DESC I -1 191, 109
$VALIDATE  C:UCASE
1 0.0 PRODUCT_MAST IT_DESC T -1 21, 109
  
1 0.0 PRODUCT_MAST IT_ADESC I -1 191, 145
$VALIDATE  C:UCASE
1 0.0 PRODUCT_MAST IT_ADESC T -1 21, 145
  
1 0.0 CMD 4 C -1 251, 73
$SELECT  S:ITEM_MAST;I\IT_ITEM;I\IT_ITEM
1 0.0 PRODUCT_MAST IT_SECT I -1 511, 73
$VALIDATE  M:  C:UCASE
1 0.0 PRODUCT_MAST IT_SECT T -1 401, 73
  
1 0.0 PRODUCT_MAST IT_COMMP I -1 191, 181
  
1 0.0 PRODUCT_MAST IT_COMMP T -1 21, 181
  
1 0.0 Label 7 T -1 331, 49
  
1 0.0 PRODUCT_MAST IT_GENLV I -1 151, 229
$VALIDATE  C:UCASE  V:Y;N;
1 0.0 PRODUCT_MAST IT_GENLV T -1 21, 229
  
1 0.0 PRODUCT_MAST IT_VATCD I -1 311, 229
$SELECT  S:VAT;I\IT_VATCD;I\IT_VATCD  $VALIDATE  M:
1 0.0 PRODUCT_MAST IT_VATCD T -1 201, 229
  
1 0.0 PRODUCT_MAST IT_PRREQ I -1 511, 229
$VAILDATE  V:Y;N;  C:UCASE
1 0.0 PRODUCT_MAST IT_PRREQ T -1 391, 229
  
1 0.0 PRODUCT_MAST IT_PRCVAR I -1 691, 229
$VAILDATE  V:A;R;  C:UCASE
1 0.0 PRODUCT_MAST IT_PRCVAR T -1 561, 229
  
1 0.0 PRODUCT_MAST IT_GRP I -1 151, 265
  
1 0.0 PRODUCT_MAST IT_GRP T -1 21, 265
  
1 0.0 PRODUCT_MAST IT_LEVY I -1 241, 409
  
1 0.0 PRODUCT_MAST IT_LEVY T -1 21, 409
  
1 0.0 PRODUCT_MAST IT_ONHREQ I -1 511, 265
$VAILDATE  V:Y;N;  C:UCASE
1 0.0 PRODUCT_MAST IT_ONHREQ T -1 391, 265
  
1 0.0 PRODUCT_MAST IT_FRTSTAT I -1 691, 265
  
1 0.0 PRODUCT_MAST IT_FRTSTAT T -1 561, 265
  
1 0.0 PRODUCT_MAST IT_APOSTAT I -1 151, 301
  
1 0.0 PRODUCT_MAST IT_APOSTAT T -1 21, 301
  
1 0.0 PRODUCT_MAST IT_BEMSTAT I -1 331, 265
$VALIDATE  I:I\IT_BEMSTAT;=;  A:VAR;I\IT_SECTION;I\IT_BEMSTAT  
1 0.0 PRODUCT_MAST IT_BEMSTAT T -1 201, 265
  
1 0.0 PRODUCT_MAST IT_BLOCK I -1 331, 373
  
1 0.0 PRODUCT_MAST IT_BLOCK T -1 201, 373
  
1 0.0 PRODUCT_MAST IT_MKTDUE I -1 511, 301
  
1 0.0 PRODUCT_MAST IT_MKTDUE T -1 391, 301
  
1 0.0 PRODUCT_MAST IT_DECFRT I -1 691, 301
$VAILDATE  V:Y;N;  C:UCASE
1 0.0 PRODUCT_MAST IT_DECFRT T -1 561, 301
  
1 0.0 PRODUCT_MAST IT_STATMASS I -1 331, 301
  
1 0.0 PRODUCT_MAST IT_STATMASS T -1 201, 301
  
1 0.0 PRODUCT_MAST IT_CONTBLK I -1 151, 373
  
1 0.0 PRODUCT_MAST IT_CONTBLK T -1 21, 373
  
1 0.0 PRODUCT_MAST IT_VARPER I -1 511, 373
  
1 0.0 PRODUCT_MAST IT_VARPER T -1 391, 373
  
1 0.0 PRODUCT_MAST IT_AGRIM I -1 151, 337
$VALIDATE  V:1;2;3;4;5;
1 0.0 PRODUCT_MAST IT_AGRIM T -1 21, 337
  
1 0.0 PRODUCT_MAST IT_PALL I -1 331, 337
$VAILDATE  V:Y;N;  C:UCASE
1 0.0 PRODUCT_MAST IT_PALL T -1 201, 337
  
1 0.0 PRODUCT_MAST IT_SPECDEL I -1 511, 337
$VAILDATE  V:Y;N;  C:UCASE
1 0.0 PRODUCT_MAST IT_SPECDEL T -1 391, 337
  
1 0.0 PRODUCT_MAST IT_EXPLIFE I -1 691, 337
  
1 0.0 PRODUCT_MAST IT_EXPLIFE T -1 561, 337
  
1 0.0 PRODUCT_MAST IT_NDAITEM I -1 501, 181
  
1 0.0 PRODUCT_MAST IT_NDAITEM T -1 371, 181
  
1 0.0 LEVY_LST I -1 151, 409
$SELECT  S:LEVY;I\LEVY_LST,I\LEVY_LST  $VALIDATE  I:I\LEVY_LST;<>;  DO(TEST)  F:LEVY_MAST;Y;LV_CODE;;;I\LEVY_LST  A:CRLF;I\LEVY_LST;I\TMP  A:CON;I\TMP;I\IT_LEVY;I\IT_LEVY  A:NOCRLF;I\IT_LEVY;I\IT_LEVY  A:CONST;;I\LEVY_LST  O:SETFOCUS;I\LEVY_LST  DOEND(TEST)
1 0.0 CMD 1 C -1 351, 229
$SELECT  S:VAT;I\IT_VATCD;I\IT_VATCD
1 0.0 CMD 2 C -1 201, 409
$SELECT  S:LEVY;I\LEVY_LST,I\LEVY_LST
1 0.0 CMD 3 C -1 201, 445
$SELECT  I:I\LEVY_LST;<>;  DO(CHK)    I:I\IT_LEVY;<>;    DO(CHK2)      U:DELETE_MV;DELETE;I\LEVY_LST,I\IT_LEVY      D:YOU ARE ABOUT TO DELETE $I\LEVY_LST$ FROM THE ITEM FILE    DOEND(CHK2)  DOEND(CHK)  A:CONST;;I\LEVY_LST
1 0.0 TMP I 0 51, 541
  
1 0.0 Label 1 T 0 1, 577
  
1 0.0 Label 9 T -1 1, 25
  
1 0.0 Label 5 T -1 661, 25
  
1 0.0 Label 6 T -1 661, 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  
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