Freshmark replication server

freshmark-canonical

Program drill-down

PALL_POOL_TRANS_LIST

PALLET POOL TRANSACTIONS LISTNG. Type DSP, base table STK_DETS.

Field inventory

36

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 4 C -1 321, 325
$SELECT   A:CONST;;T\PROG    A:CONST;PROCESSING !!!;T\PRO  '/PRINT=PRINT_STATIC_LISTING;BT,11,10,S /IC:\LEGEND\PROJ_FMS\INI\LAZOLA\FMS.INI  E:$GBLROOT$LEGEND\PROJ_FMS\BIN\PRINTING.EXE /PRINT=PRINT_PALLET_POOL_TRANS;$I\MARKET$,$I\AGENT$,$I\TRTYPE$,$I\FDATE$,$I\TDATE$,$I\SLS_SECT$,S  A:CONST;COMPLETE !!!;T\PROG      I:I\
1 0.0 Work 2 I -1 321, 289
$SELECT  I:I\AGENT;<>;  S:SALES_SECTION_PRT;I\SLS_SECT;I\AGENT    I:I\AGENT;=;  S:SALES_SECTION_PRT_1;I\SLS_SECT      $CALCULATE    I:I\AGENT;<>;  DO(AGN)    I:I\SLS_SECT;<>;    F:SLSSECT_ACCESS;Y;;;SS_AGENT='$I\AGENT$' AND SS_SECT='$I\SLS_SECT$';I\SLS_SECT  DOEND(AGN)      I:I\AGENT;=;  DO(MKT)    I:I\SLS_SECT;<>;    
1 0.0 CMD 1 C -1 421, 145
$SELECT  S:AGN_CODE;I\AGENT
1 0.0 CMD 2 C -1 421, 181
$SELECT  S:TRANS_TYPE1;I\TRTYPE
1 0.0 H -1 0, 0
  
1 0.0 Work 1 I 0 141, 61
  
1 0.0 Work 3 I 0 91, 61
$DEFAULT  A:ORGS;;I\ORGS  A:CONST;$I\ORGS$;I\AGENT  A:DATE;DD MMM YYYY;I\FDATE    I:I\ORGS;<>;  DO(03)    O:DISABLEINPUT;I\AGENT,C\AGENT     O:SETFOCUS;I\TRTYPE    F:AGENT_MAST;;;T\NAME=AM_NAME;AM_CODE='$I\ORGS$'  DOEND(03)    I:I\MARKET;<>;11  O:HIDE;T\SLS_SECT,I\SLS_SECT
1 0.0 Work 18 I 0 61, 61
  
1 0.0 Work 16 I 0 31, 61
$DEFAULT  'LOAD MARKET CODE  A:ORG;;I\MARKET    'LOAD MARKET  NAME  F:CLIENT_MAST;;CM_CODE;T\MKT=CM_NAME,I\CM_PROHIBIT_STATS=CM_PROHIBIT_STATS    'CHANGING TEXT CASE FOR THE FIRST CHARACTER TO UPPER CASE  C:MCASE;;T\MKT      'I:I\CM_PROHIBIT_STATS;=;Y  'DO(EXIT)  'O:DISABLEINPUT;C\RUN,C\AGENT  'D:STATS ARE PROHIBITED;E
1 0.0 Work 15 I 0 1, 61
$DEFAULT  A:USERID;;I\AGENT  A:TIME;HH:MM:SS;T\TIME  A:DATE;DD MMM YYYY;T\DATE  A:TIMER_ON;1000    A:DATE;DD MMM YYYY;I\FDATE  A:DATE;DD MMM YYYY;I\TDATE  A:DATE;DD MMM YYYY;W\FRMDATE    O:SETFOCUS;I\AGENT
1 0.0 Work 7 I -1 321, 181
$SELECT  S:TRANS_TYPE1;I\TRTYPE    $VALIDATE  C:UCASE  A:CONST;;T\PROG  I:I\TRTYPE;<>;  F:TRANS_TYPE;Y;;I\TRTYPE=TC_TRTYPE;TC_TRTYPE='$I\TRTYPE$' AND TC_TYPE='PP';I\TRTYPE        
1 0.0 I -1 321, 145
$SELECT  S:AGN_CODE;I\AGENT    $VALIDATE  A:CONST;;T\PROG,I\SLS_SECT  C:UCASE  I:I\AGENT;<>;  F:AGENT_MAST;Y;;T\NAME=AM_NAME;AM_CODE='$I\AGENT$';I\AGENT      
1 0.0 Work 3 I -1 321, 217
$VALIDATE    I:I\FDATE;=;  A:DATE;DD MMM YYYY;I\FDATE    I:I\FDATE;<>;  A:DATEDIFF;W\FRMDATE;I\DATEDIFF;I\FDATE  I:I\DATEDIFF;<;0  D:FROM DATE CANNOT BE LATER THAN TODAY'S DATE;ERRORM;I\FDATE  
1 0.0 Work 4 I -1 321, 253
$VALIDATE  I:I\TDATE;=;  A:DATE;DD MMM YYYY;I\TDATE  A:DATEDIFF;I\TDATE;I\DATEDIFF;I\FDATE  I:I\DATEDIFF;<;0  D:TO DATE CANNOT BE LESS THAN FROM DATE;ERRORM;I\TDATE    I:I\TDATE;<>;  A:DATEDIFF;W\FRMDATE;I\DATEDIFF;I\TDATE  I:I\DATEDIFF;<;0  D:TO DATE CANNOT BE LATER THAN TODAY'S DATE;ERRORM;I\TDATE    I:I\MARKET;<>;11
1 0.0 Work 5 I 0 1, 85
  
1 0.0 Work 6 I 0 31, 85
  
1 0.0 Label 4 T -1 191, 145
  
1 0.0 Label 5 T -1 301, 361
  
1 0.0 Label 6 T -1 191, 181
  
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
  
1 0.0 Label 10 T -1 621, 49
  
1 0.0 Label 17 T -1 461, 145
  
1 0.0 Label 2 T -1 1, 25
  
1 0.0 Label 3 T -1 291, 49
  
1 0.0 Label 1 T -1 291, 25
  
1 0.0 Label 1 T -1 461, 181
  
1 0.0 Label 1 T -1 191, 217
  
1 0.0 Label 2 T -1 191, 253
  
1 0.0 Label 1 T -1 191, 289
  
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