Freshmark replication server

freshmark-canonical

Program drill-down

CS_OTHERDEP_AMD

COLD STORAGE OTHER DEPOSIT - AMEND. Type DSP, base table LOC_TRANS.

Field inventory

88

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 4 C -1 451, 253
$SELECT  'DISPLAY A SELECTION WINDOW  S:ROOM_SECTION;I\SECT;I\ROOM_NO
1 0.0 Work 1 I 0 401, 565
  
1 0.0 CMD 1 C -1 221, 253
$SELECT  S:LOCATION_CS_CODES;I\ROOM_NO
1 0.0 CONF_DATE I 0 461, 529
  
1 0.0 Label 8 T -1 11, 337
  
1 0.0 Label 12 T -1 11, 409
  
1 0.0 Work 9 I -1 161, 337
'$CALCULATE  $VALIDATE  M:    'CHECK QTY IS NOT GREATER THAN QTY AVAIL  'I:I\QTYDEP;>;I\QTYAVAIL;NUM  'D:THIS IS GREATER THAN THE QUANTITY AVAILABLE;ERRORM;I\QTYDEP    I:I\QTYDEP;<;I\QTYISS;NUM  D:CANNOT ADJUST TO LESS THAN TOTAL ISSUE QTY ($I\QTYISS$);ERRORM;I\QTYDEP    I:I\MARKET;<>;18  U:CS_AGENT_DEP_MAN;GET_TARIFF 
1 0.0 Label 10 T -1 11, 205
  
1 0.0 Work 11 I -1 161, 205
  
1 0.0 Work 11 I -1 161, 373
'$CALCULATE  $VALIDATE    'MANDATORY  M:    'GET MIN & MAX COLD STORAGE CHARGES  F:CLIENT_MAST;Y;;I\TMP4=CM_CS_MIN_CHARGE,I\TMP5=CM_CS_MAX_CHARGE;CM_CODE='$I\MARKET$'    'CHECK IF ENTERED TARIFF IS GREATER THAN/LESS THAN MAX/MIN CHARGES  A:MULT;I\QTYDEP;I\TMP;I\TARIFF    A:VAR;I\TMP4;I\TMP4;;#0.000  A:VAR;I\TMP;I\TMP;;
1 0.0 Label 2 T -1 11, 445
  
1 0.0 Work 3 I -1 161, 445
$CALCULATE  C:UCASE    O:BACKCOLOR;C\UPDATE;YELLOW  O:SETFOCUS;C\UPDATE
1 0.0 LOC_TRANS LT_MARKET I 0 161, 73
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD AGENT CODE  A:ORGS;;I\ORGS    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\CM_DEL_LEN=CM_DEL_LEN;;  'F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\CM_DEL_LEN=CM_DEL_LEN,D\CM_CSTARIFF=CM_CSTARIFF;;  'F:CLIENT_MAST;;CM_CODE;I\TMP=SD_RECQTY,I\TMP2=SD_SLDQT
1 0.0 Work 13 I -1 161, 409
$CALCULATE    'C:UCASE    'I:I\PALLET;<>;Y  ' DO(CHK)  ' I:I\PALLET;<>;  '  D:ENTER ONLY Y OR LEAVE BLANK;ERRORM;I\PALLET  ' DOEND(CHK)    'SHOW THE POP UP IF 'Y' IS ENTERED  'I:I\PALLET;=;Y  ' DO(CHK2)  '  A:VAR;;I\PALLS_SOLD;  '  U:CS_AGENT_DEP_MAN;PALLET_CS_ENTRY  ' DOEND(CHK2)    '20221228 theunis  I:I\PALLET;<;I\Q
1 0.0 Work 4 I -1 161, 253
$SELECT  S:MKT_CS;I\ROOM_NO    $ESC  O:SETFOCUS;I\CONSIGN    '$CALCULATE  $VALIDATE  M:  C:UCASE    A:ZEROFILL;I\ROOM_NO,4,I\ROOM_NO  'MAKE SURE THE ROOM IS VALID   F:ROOM_DET;Y;RD_ROOM;;;I\ROOM_NO      'GET CHARGE TYPE OF THE ROOM AND THE ROOM TYPE  F:LOCATION_MAST;;LM_CODE;I\TMP4=LM_TYPE,I\TMP5=LM_CHG_TYPE,T\ROOMNUM=
1 0.0 Label 2 T -1 11, 109
  
1 0.0 Work 1 I 0 131, 73
$DEFAULT    A:DATE;DD MMM/YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  'A:TIMER_ON;1000    O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\UPDATE      'A:CONST;1;I\PALLET        
1 0.0 Drop 1 D -1 421, 301
$DEFAULT  'ADDS THE SPECIFIED ITEMS TO THE COMBOBOX  B:ADDITEM;D\CM_CSTARIFF;M - MONTHLY,W - WEEKLY,D - DAILY,H - HOURLY    $VALIDATE    'CONVERT TO UPPERCASE  C:UCASE    'CHECKS THAT ONLY THE ADDED ITEMS ARE ENTERED  I:D\CM_CSTARIFF;=;M - MONTHLY    DO(M)     'TAKE THE LEFT MOST CHARACTER     A:LEFT;D\CM_CSTARIFF,1;D\
1 0.0 Label 1 T -1 231, 205
  
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 Label 3 T -1 621, 25
  
1 0.0 Label 1 T -1 291, 25
  
1 0.0 Label 2 T -1 1, 25
  
1 0.0 Label 8 T -1 251, 49
  
1 0.0 DEL DATE T -1 11, 169
  
1 0.0 Label 5 T -1 11, 253
  
1 0.0 I -1 161, 109
$SELECT  S:OTHER_DEPOSITS;I\DEPNO      $CALCULATE  A:CONST;;I\CONSIGN,I\FULLDEPNO,I\AGENT,T\AGENT_NAME,I\SUPPL,T\SUPPL_NAME,I\COMMOD,I\ITEM,I\CONT,I\QTYAVAIL  A:CONST;;I\ROOM_NO,I\SECT,I\SHELF,I\DEP_DATE,D\CM_CSTARIFF,T\PERIOD_DESC,I\QTYDEP,I\TARIFF,I\PALLET,I\REMARKS,I\DEBTOR,T\DEBTOR,W\SECT  A:CONST;;I\TRANSNO,I\DOCN
1 0.0 Work 2 I 0 581, 217
  
1 0.0 H -1 1, 31
  
1 0.0 Label 2 T -1 311, 337
  
1 0.0 Work 1 I 0 581, 169
  
1 0.0 Work 7 I -1 391, 253
$SELECT  'DISPLAY A SELECTION WINDOW  S:ROOM_SECTION;I\SECT;I\ROOM_NO    '$CALCULATE  $VALIDATE    'MANDATORY  M:    'CONVERT TO UPPERCASE  C:UCASE    'CHECK IF A VALID SECTION IS ENTERED  F:ROOM_DET;;;W\SECT=RD_SECTION;RD_ROOM='$I\ROOM_NO$' AND RD_SECTION = '$I\SECT$'  I:W\SECT;=;  D:THIS SECTION IS NOT FOR THIS ROOM 
1 0.0 Work 1 I 0 381, 373
  
1 0.0 Label 8 T -1 311, 253
  
1 0.0 Work 9 I -1 561, 253
$SELECT  'DISPLAY A SELECTION WINDOW  'S:ROOM_SHELVES;I\SHELF;I\ROOM_NO;I\SECT      '$CALCULATE  $VALIDATE    'MANDATORY  M:    'CHECK IF A VALID SHELF IS ENTERED  F:ROOM_DET;;;I\TMP=RD_SHELVES;RD_ROOM='$I\ROOM_NO$' AND RD_SHELVES='$I\SHELF$'  I:I\TMP;=;  D:SHELF $I\SHELF$ DOES NOT EXIST;ERRORM;I\SHELF  I:I\SHELF;>;I\T
1 0.0 Label 10 T -1 481, 253
  
1 0.0 Label 12 T -1 11, 373
  
1 0.0 Label 3 T -1 311, 301
  
1 0.0 Work 1 I -1 161, 301
'$CALCULATE  $VALIDATE    'DEFAULT DATE TO CURRENT  I:I\DEP_DATE;=;""  A:DATE;DD MMM YYYY;I\DEP_DATE    A:DATE;DD MMM YYYY;I\TMP  I:I\TMP;<;I\DEP_DATE;DAT  D:DEPOSIT DATE CANNOT BE GREATER THAN TODAY;ERRORM;I\DEP_DATE    'DIFF BETWEEN CURRENT DATE AND DEPOSIT DATE  A:DATEDIFF;I\DEP_DATE;I\TMP1;I\TMP;;D    'GETS ABSOLUT
1 0.0 Label 2 T -1 11, 301
  
1 0.0 Work 1 I 0 351, 529
  
1 0.0 Work 2 I 0 311, 529
  
1 0.0 Work 3 I 0 271, 529
  
1 0.0 Work 4 I 0 231, 529
  
1 0.0 Work 5 I 0 191, 529
  
1 0.0 Work 6 I 0 151, 529
  
1 0.0 Work 8 I 0 401, 529
  
1 0.0 Work 9 I 0 121, 529
  
1 0.0 Work 1 I 0 501, 505
  
1 0.0 Work 10 I -1 161, 169
  
1 0.0 Work 1 I 0 471, 169
  
1 0.0 Label 1 T -1 521, 301
  
1 0.0 Work 2 I 0 371, 169
  
1 0.0 Work 1 I 0 441, 529
  
1 0.0 I 0 211, 73
  
1 0.0 Work 1 I 0 181, 73
  
1 0.0 Work 2 I 0 581, 133
  
1 0.0 CMD 1 C -1 261, 109
$SELECT    S:CS_DEPNO;I\DEPNO;I\AGENT;I\CONSIGN
1 0.0 Work 1 I 0 621, 481
  
1 0.0 Work 2 I 0 561, 481
  
1 0.0 Label 4 T 0 431, 85
  
1 0.0 Work 1 I 0 311, 373
  
1 0.0 Work 1 I 0 441, 505
  
1 0.0 CONF_USER I 0 491, 529
  
1 0.0 Work 7 I 0 561, 505
  
1 0.0 Work 2 I 0 341, 373
  
1 0.0 Work 3 I 0 271, 373
  
1 0.0 CMD 3 C -1 651, 546
$SCMD_FOCUS  O:BACKCOLOR;C\UPDATE;YELLOW        $SELECT  'I:I\CONSIGN;=;  ' DO(CHK)  '  O:SETFOCUS;I\CONSIGN  '  D:ERROR - ENTER CONSIGNMENT AND PRESS ENTER;ERRORM;I\CONSIGN  ' DOEND(CHK)    'I:I\CONSIGN;<>;  'F:STK_DETS;Y;;;SD_CONSIGN='$I\CONSIGN$';I\CONSIGN     I:I\DEPNO;=;   DO(CHK1)    O:SETFOCUS;I\DEPNO    D:ERROR
1 0.0 Work 1 I 0 451, 385
  
1 0.0 Work 6 I 0 621, 505
  
1 0.0 LESS I 0 581, 529
  
1 0.0 Work 1 I 0 561, 385
  
1 0.0 CONF_TIME I 0 521, 529
  
1 0.0 CONFIRMED I 0 551, 529
  
1 0.0 Work 2 I 0 581, 193
  
1 0.0 Work 1 I 0 551, 97
  
1 0.0 Work 1 I -1 421, 409
  
1 0.0 QTYISS I -1 421, 337
  
1 0.0 Work 1 I 0 231, 409
  
1 0.0 Label 2 T -1 311, 409
  
1 0.0 Work 2 I 0 231, 337
  
10 0.0 ZX_PRINT Z 0 1, 145
  
10 0.0 ZX_SELECT Z 0 1, 145
  
10 0.0 ZX_DELETE Z 0 1, 145
  
10 0.0 ZX_UPDATE Z 0 1, 145
$BEFORE_WRITE  U:CS_AGDEP_AMD_MAN;UPDATE_CS_DATA    
10 0.0 ZX_EXIT Z 0 1, 145