Freshmark replication server

freshmark-canonical

Program drill-down

CS_TRANS_ENQUIRY

COLD STORAGE TRANSACTION ENQUIRY. Type DSP, base table STK_MAST.

Field inventory

46

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Label 2 T -1 231, 277
  
1 0.0 CMD 1 C 0 391, 121
$SELECT  S:AGENT_CODE;I\AGENT
1 0.0 Label 5 T -1 1, 25
  
1 0.0 MARKET I 0 111, 37
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MARKET=CM_NAME,I\CM_ALLOW_MNTH_REPORT=CM_ALLOW_MNTH_REPORT    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MARKET      A:VAR;I\MARKET;I\TM_MARKET    A:CONST;N;I\DUMP    $AFTER_READ  A:VAR;I\MARKET;I\TM_
1 0.0 DEFAULT I 0 141, 37
'DISPLAYING TIME  $DEFAULT  A:DATE;DD MMM YYYY;T\DATE  A:TIME;HH:MM:SS;T\TIME  '''A:TIMER_ON;1000    A:CONST;$T\DATE$;I\FROM_DATE,I\TO_DATE
1 0.0 Label 8 T -1 621, 49
  
1 0.0 Label 9 T -1 621, 25
  
1 0.0 Label 10 T -1 671, 25
  
1 0.0 Label 11 T -1 671, 49
  
1 0.0 AGENT I 0 341, 121
'RETRIVING AGENT NAME  '$DEFAULT  'A:ORGS;I\ORGS,I\AGENT  'A:VAR;I\AGENT;I\ORGS  'F:AGENT_MAST;;AM_CODE;T\AGENT1=AM_NAME;AM_CODE='$I\AGENT$'         '$SELECT  'S:AGENT_CODE;I\AGENT    '$VALIDATE  'A:CONST;;T\AGENT1  'M:  'C:UCASE  'F:AGENT_MAST;Y;;T\AGENT1=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT        '$AFTER_READ  'A:ORG
1 0.0 Label 10 T 0 221, 121
  
1 0.0 Label 9 T 0 431, 121
  
1 0.0 CMD 5 C -1 651, 546
$SCMD_FOCUS  O:BACKCOLOR;C\CREATE;YELLOW    $SELECT  A:CONST;;I\ALLOW    I:I\TO_DATE;=;    DO(04)     I:I\DEPOSIT_NO;=;     A:CONST;$T\DATE$;I\TO_DATE    DOEND(04)  I:I\TO_DATE;<>;   DO(DATE)    A:DATEDIFF;I\TO_DATE;I\DATEDIFF;I\FROM_DATE    I:I\DATEDIFF;<;0    D:TO DATE CANNOT BE LESS THAN FROM DATE;ERRORM;I\TO_DATE  
1 0.0 Label 1 T -1 351, 409
  
1 0.0 Work 3 I 0 1, 61
  
1 0.0 Work 4 I 0 1, 85
  
1 0.0 Work 2 I -1 361, 349
$VALIDATE  C:UCASE    V:Y;N    O:SETFOCUS;C\CREATE  O:BACKCOLOR;C\CREATE;YELLOW
1 0.0 DELCOUNT I 0 531, 169
  
1 0.0 Label 1 T -1 231, 169
  
1 0.0 Work 2 I -1 361, 169
$SELECT  S:CS_DELNO;I\DELIVNO    $VALIDATE  I:I\DELIVNO;<>;  DO(MZ)    '!!!!!!!!!  'JDJDJDJDJ  - 2012 09 26 -> CHRISTO REQUEST FOR PIETER IN PTA  '!!!!!!!!!  U:CONSIGNMENT_ENQUIRY;DELCOUNT    I:I\DELCOUNT;>;1  DO(MRQ)    I:I\ORGS;=;    DO(PUN)      S:MULTI_DELIVERY;I\DELIVNO;I\DELIVNO      A:SELPARM;2;I\TMP_DELDATE    
1 0.0 CMD 3 C -1 461, 169
$SELECT  S:CS_DELNO;I\DELIVNO
1 0.0 Work 1 I -1 361, 205
$SELECT  I:I\DELIVNO;=;  S:CONS_CS;I\CONSIGN    I:I\DELIVNO;<>;  S:CS_CONSIGNMENT;I\CONSIGN;I\DELIVNO        $VALIDATE  I:I\CONSIGN;<>;  DO(MZ)  U:CONSIGNMENT_ENQUIRY;CONSIGNCOUNT  I:I\CONSIGNCOUNT;>;1  DO(CONS)  I:I\ORGS;=;  S:MULTI_CONSIGN;I\CONSIGN;I\CONSIGN    A:SELPARM;3;I\TMP_DELDATE  A:VAR;I\TMP_DELDATE;I\TMP_DE
1 0.0 CMD 2 C -1 461, 205
$SELECT  I:I\DELIVNO;=;  S:CONS_CS;I\CONSIGN    I:I\DELIVNO;<>;  S:CS_CONSIGNMENT;I\CONSIGN;I\DELIVNO
1 0.0 FROM_DATE I -1 361, 277
$VALIDATE    'I:I\DEPOSIT_NO;=;  ' DO(FDTE)  '  A:CONST;$T\DATE$;I\FROM_DATE,I\TO_DATE  ' DOEND(FDTE)    I:I\FROM_DATE;=;   DO(03)    I:I\DEPOSIT_NO;=;    A:CONST;$T\DATE$;I\FROM_DATE   DOEND(03)  
1 0.0 TO_DATE I -1 361, 313
$VALIDATE  A:CONST;;I\ALLOW    I:I\TO_DATE;=;    DO(04)     I:I\DEPOSIT_NO;=;     A:CONST;$T\DATE$;I\TO_DATE    DOEND(04)  I:I\TO_DATE;<>;   DO(DATE)    A:DATEDIFF;I\TO_DATE;I\DATEDIFF;I\FROM_DATE    I:I\DATEDIFF;<;0    D:TO DATE CANNOT BE LESS THAN FROM DATE;ERRORM;I\TO_DATE   DOEND(DATE)        'I:I\CM_ALLOW_MNTH_REP
1 0.0 Label 3 T -1 231, 205
  
1 0.0 Label 3 T -1 291, 25
  
1 0.0 Label 4 T -1 241, 49
  
1 0.0 H -1 0, 0
  
1 0.0 Work 1 I 0 351, 457
  
1 0.0 Work 2 I 0 581, 121
$DEFAULT  A:ORGS;I\ORGS,I\AGENT    A:VAR;I\ORGS;I\AGENT    F:AGENT_MAST;;AM_CODE;T\AGENT1=AM_NAME;AM_CODE='$I\AGENT$'    'I:I\ORGS;<>;  ' DO(AGENT)  '  O:DISABLEINPUT;I\AGENT,C\AGENT  '  O:SETFOCUS;I\DELNO  ' DOEND(AGENT)    'I:I\ORGS;=;  ' DO(NO_AGENT)  '  O:ENABLEINPUT;I\AGENT,C\AGENT  '  O:SETFOCUS;I\AGENT  ' DOEND(
1 0.0 DEPOSIT_NO I -1 361, 241
$DEFAULT  'PUTS PIC ON THE UPDATE BUTTON  O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\CREATE    F:CLIENT_MAST;;;I\DEL_LEN=CM_DEL_LEN;CM_CODE='$I\MARKET$'        $SELECT  'I:I\ORGS;=;  'S:CS_DEPNO3;I\DEPOSIT_NO  'S:CS_DEPNO_PTA;I\DEPOSIT_NO;I\CONSIGN  'I:I\ORGS;<>;  'S:CS_DEPNO2;I\DEPOSIT_NO;I\AGENT    I:
1 0.0 Label 1 T -1 231, 241
  
1 0.0 CMD 3 C -1 461, 241
$SELECT  I:I\ORGS;=;  S:CS_DEPNO3;I\DEPOSIT_NO    I:I\ORGS;<>;  S:CS_DEPNO2;I\DEPOSIT_NO;I\AGENT
1 0.0 Label 4 T -1 231, 313
  
1 0.0 Work 1 I 0 401, 457
  
1 0.0 Work 1 I 0 231, 445
  
1 0.0 Work 1 I 0 201, 445
  
1 0.0 TMP_DELDATE I 0 561, 169
  
1 0.0 DELDATE I 0 661, 169
  
1 0.0 Label 1 T -1 231, 349
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_UPDATE Z 0 0, 0
  
10 0.0 ZX_EXIT Z 0 0, 0
  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_PRINT Z 0 0, 0