Freshmark replication server

freshmark-canonical

Program drill-down

MKT_MONTHLY_DATES

MONTHLY START AND END DATES. Type MAN, base table MONTHLY_DATES.

Field inventory

32

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 1 C 0 331, 289
'$SELECT  'I:I\SUPPL;<>;  'DO(CIA)  '   F:SUPPLIER_MAST;Y;;;SUM_SUPPL='$I\SUPPL$';I\SUPPL  'DOEND(CIA)  'A:CONST;UPDATING ! ! !;T\PROG  'U:SUPPLIER_PUC_MAN;UPDATE  'A:CONST;COMPLETE ! ! !;T\PROG  'A:CONST;;I\SUPPL,I\NAME,I\ADDR1,I\ADDR2,I\ADDR3,I\PCODE,I\PUCNO,W\PUCNO  'O:SETFOCUS;I\SUPPL        
1 0.0 Work 1 I 0 400, 355
  
1 0.0 Work 9 I 0 1, 91
$DEFAULT  A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000  A:DATE;DD MMM YYYY;W\FRMDATE
1 0.0 H -1 0, 30
  
1 0.0 Work 8 I 0 21, 91
C:MCASE;;T\MKT  $DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MKT=CM_NAME    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MKT  
1 0.0 MONTHLY_DATES MD_START_DATE I -1 331, 205
$VALIDATE  A:CONST;;I\VALID_MONTH  C:UCASE    I:I\MD_START_DATE;=;  A:DATE;DD MMM YYYY;I\MD_START_DATE    I:I\MD_START_DATE;<>;  A:I\MD_START_DATE;MMM;W\MD_START_DATE    ''U:DATE_VALIDATE;START_DATE    ''I:I\VALID_MONTH;=;Y  ''D:START DATE CANNOT BE 2 MONTH'S EARLY OR LATER THAN THE MONTH ABOVE;ERRORM;I\MD_START_DATE  
1 0.0 MONTHLY_DATES MD_MONTH I -1 331, 169
$VALIDATE  C:UCASE  I:I\MD_MONTH;=;  A:DATE;MMM;I\MD_MONTH    I:I\MD_MONTH;<>;    DO(MONTH)      U:DATE_VALIDATE;CHECK_MONTH       I:I\VALID_MONTH;=;Y       D:ENTER A MONTH IN IN THIS FORMAT (MMM);ERRORM;I\MD_MONTH  DOEND(MONTH)          
1 0.0 MONTHLY_DATES MD_YEAR I -1 331, 133
$VALIDATE  A:CONST;;T\PROG    I:I\MD_YEAR;=;  A:DATE;YYYY;I\MD_YEAR    I:I\MD_YEAR;<>;  A:LEN;I\MD_YEAR;I\TMP    I:I\TMP;<;4  D:USE THE SPECIFIED FORMAT IN BRACKETS;ERRORM;I\MD_YEAR    U:DATE_VALIDATE;CHECK_YEAR    I:I\VALID_MONTH;=;Y  D:ENTER A MONTH IN IN THIS FORMAT (MMM);ERRORM;I\MD_YEAR  
1 0.0 MONTHLY_DATES MD_END_DATE I -1 331, 241
$VALIDATE  A:CONST;;I\VALID_MONTH  C:UCASE    I:I\MD_START_DATE;=;  A:DATE;DD MMM YYYY;I\MD_START_DATE    I:I\MD_START_DATE;<>;  A:I\MD_START_DATE;MMM;W\MD_START_DATE    'U:DATE_VALIDATE;START_DATE    ''I:I\VALID_MONTH;=;Y  ''D:START DATE CANNOT BE 2 MONTH'S EARLY OR LATER THAN THE MONTH ABOVE;ERRORM;I\MD_START_DATE   
1 0.0 Work 1 I 0 1, 199
  
1 0.0 Work 4 I 0 1, 91
$DEFAULT  A:USERIP;I\IP
1 0.0 Work 5 I 0 1, 91
$DEFAULT  A:USERID;I\USERID
1 0.0 Label 10 T -1 221, 133
  
1 0.0 Label 1 T -1 1, 25
  
1 0.0 Label 2 T -1 291, 25
  
1 0.0 Label 3 T -1 621, 25
  
1 0.0 Label 4 T -1 671, 25
  
1 0.0 Label 5 T -1 261, 49
  
1 0.0 Label 6 T -1 621, 49
  
1 0.0 Label 7 T -1 671, 49
  
1 0.0 Label 11 T -1 221, 169
  
1 0.0 Label 12 T -1 221, 205
  
1 0.0 Label 13 T -1 221, 241
  
1 0.0 Label 6 T -1 251, 325
  
1 0.0 Work 1 I 0 31, 199
  
1 0.0 Work 2 I 0 1, 223
  
1 0.0 Work 3 I 0 1, 259
  
10 0.0 ZX_UPDATE Z 0 0, 30
  
10 0.0 ZX_DELETE Z 0 0, 30
  
10 0.0 ZX_SELECT Z 0 0, 30
  
10 0.0 ZX_PRINT Z 0 0, 30
  
10 0.0 ZX_EXIT Z 0 0, 30