Freshmark replication server

freshmark-canonical

Program drill-down

USER_AUD_LISTING

USER AUDIT LISTNG. Type DSP, base table AUD_ZU_USER.

Field inventory

39

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 Label 1 T -1 231, 181
  
1 0.0 Label 1 T -1 231, 301
  
1 0.0 Work 2 I -1 351, 301
$SELECT    I:I\SELECTSORT;<>;    DO(S1)      I:I\SELECTSORT;<>;4      DO(S)        S:SEL_ZUA_AUD_DATE;I\FROM_DTAE;I\SELECTSORT      DOEND(S)    DOEND(S1)    I:I\SELECTSORT;=;  DO(A)      S:SEL_ZUA_AUD_DATE_DET;I\FROM_DATE  DOEND(A)    I:I\SELECTSORT;=;4  DO(P)      S:SEL_ZUA_AUD_DATE_PAS;I\FROM_DATE  DOEND(P)  
1 0.0 H -1 0, 0
  
1 0.0 Work 13 I 0 1, 193
'$SELECT  'S:SALES_SECTION_PRT;I\SSECT;I\AGENT    '$VALIDATE  'I:I\SSECT;<>;  'F:SLSSECT_ACCESS;Y;;;SS_SECT='$I\SSECT$';I\SSECT    'F:STK_DETS;Y;;;LEFT(SD_CONSIGN, 3)='$I\SSECT$';I\SSECT    'O:SETFOCUS;C\RUN  'O:BACKCOLOR;C\RUN;YELLOW
1 0.0 Work 3 I 0 41, 61
$DEFAULT    A:ORGS;;I\ORGS  A:CONST;$I\ORGS$;I\AGENT  'A:USERID;;I\AGENT    A:DATE;DD MMM YYYY;T\DATE  A:DATE;DD MMM YYYY;I\FROM_DATE  A:DATE;DD MMM YYYY;I\TO_DATE  A:TIME;HH:MM:SS;T\TIME  A:TIMER_ON;1000    I:I\ORGS;<>;  DO(03)  'O:DISABLEINPUT;I\AGENT,C\AGENT   O:SETFOCUS;I\SELECTION  F:AGENT_MAST;;;T\NAME=AM_NAME;AM
1 0.0 Work 18 I 0 1, 145
  
1 0.0 Work 16 I 0 1, 61
$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    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MARKET    'IN
1 0.0 Work 7 I -1 351, 265
$VALIDATE    V:1;2;3;4    $CALCULATE    I:I\SELECTION;=;1      A:CONST;A;I\SELECTSORT    I:I\SELECTION;=;2      A:CONST;D;I\SELECTSORT    I:I\SELECTION;=;3      A:CONST;;I\SELECTSORT    I:I\SELECTION;=;4      A:CONST;4;I\SELECTSORT  
1 0.0 Label 5 T -1 281, 493
  
1 0.0 Label 6 T -1 231, 265
  
1 0.0 Label 7 T -1 621, 25
  
1 0.0 Label 8 T -1 671, 25
  
1 0.0 Label 9 T -1 671, 49
$DEFAULT  
1 0.0 Label 1 T -1 231, 97
  
1 0.0 Label 10 T -1 621, 49
  
1 0.0 Label 2 T -1 231, 133
  
1 0.0 Label 2 T -1 1, 25
  
1 0.0 Label 3 T -1 231, 157
  
1 0.0 Label 3 T -1 311, 49
  
1 0.0 Label 1 T -1 291, 25
  
1 0.0 Work 4 I 0 1, 169
  
1 0.0 Label 1 T -1 231, 205
  
1 0.0 Label 1 T -1 231, 337
  
1 0.0 Work 2 I -1 351, 337
$SELECT    I:I\SELECTSORT;<>;    DO(S1)      I:I\SELECTSORT;<>;4      DO(S)        S:SEL_ZUA_AUD_DATE;I\TO_DATE;I\SELECTSORT      DOEND(S)    DOEND(S1)    I:I\SELECTSORT;=;  DO(A)      S:SEL_ZUA_AUD_DATE_DET;I\TO_DATE  DOEND(A)    I:I\SELECTSORT;=;4  DO(P)      S:SEL_ZUA_AUD_DATE_PAS;I\TO_DATE  DOEND(P)    
1 0.0 Label 1 T 0 1, 241
  
1 0.0 Work 2 I 0 51, 241
$SELECT  S:AGENT_CODE;I\AGENT    $VALIDATE    C:UCASE  I:I\AGENT;<>;  F:AGENT_MAST;Y;;T\AGENT_NAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT
1 0.0 Label 1 T -1 231, 409
  
1 0.0 Work 2 I -1 351, 409
$VALIDATE    C:UCASE  V:Y;N    O:BACKCOLOR;C\RUN;YELLOW  O:SETFOCUS;C\RUN  
1 0.0 CMD 3 C 0 151, 241
  
1 0.0 Label 1 T -1 231, 373
  
1 0.0 Work 2 I -1 351, 373
$SELECT  S:ZC_SEC_GROUP;I\MENU
1 0.0 CMD 3 C -1 401, 373
$SELECT  S:ZC_SEC_GROUP;I\MENU
1 2.0 CMD 4 C -1 251, 457
$SELECT     I:I\FROM_DATE;=;  A:DATE;DD MMM YYYY;I\FROM_DATE    I:I\TO_DATE;=;  A:DATE;DD MMM YYYY;I\TO_DATE      A:CONST;;T\PROG  I:I\SELECTION;=;  D:PLEASE ENTER SELECTION;ERRORM;I\SELECTION  E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_USER_AUD_LISTING;$I\MARKET$,$I\SELECTION$,$I\FROM_DATE$,$I\TO_DATE$,$
10 0.0 ZX_UPDATE Z 0 0, 0
  
10 0.0 ZX_DELETE Z 0 0, 0
  
10 0.0 ZX_EXIT Z 0 0, 0
  
10 0.0 ZX_PRINT Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 0, 0