Freshmark replication server

freshmark-canonical

Program drill-down

LINK_BYRS_TO_AGENT

LINK BUYERS TO AGENTS. Type DSP, base table SUPPLIER_MAST.

Field inventory

37

Live detail pulled from the database.

Page Seq Table Field Type Visible Position Logic snippet
1 0.0 CMD 1 C -1 651, 546
$SELECT  A:CONST;PROCESSING ...;T\PROG    U:LINK_BUYERS_TO_AGENT;LINK;G\GRID    U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\LINE,I\DEBTOR,I\NAME,I\LINK  A:CONST;DONE !!!;T\PROG  A:CONST;;I\AGENT,T\AGENT_NAME,I\BUYER,I\DM_AGN_BYR,I\AM_FBUYER,I\AM_TBUYER  O:SETFOCUS;I\AGENT  O:ENABLEINPUT;G\GRID,I\LINE,I\LINK
1 0.0 Label 3 T -1 61, 181
  
1 0.0 Label 1 T -1 291, 25
  
1 0.0 Label 3 T -1 671, 25
  
1 0.0 Label 4 T -1 671, 49
  
1 0.0 Label 2 T -1 61, 145
  
1 0.0 Label 1 T -1 411, 181
  
1 0.0 Label 16 T -1 211, 181
  
1 0.0 Label 17 T -1 111, 181
  
1 0.0 Label 6 T -1 621, 25
  
1 0.0 Label 8 T -1 61, 109
  
1 0.0 Label 7 T -1 621, 49
  
1 0.0 Label 5 T -1 1, 25
  
1 0.0 Work 1 I 0 61, 49
  
1 0.0 Label 2 T -1 191, 109
  
1 0.0 Work 9 I -1 131, 109
$SELECT  S:AGENT_CODE;I\AGENT    $VALIDATE  M:  A:CONST;;T\PROG,T\NAME    C:UCASE  I:I\AGENT;<>;  DO(9)    F:AGENT_MAST;Y;;T\AGENT_NAME=AM_NAME,I\AM_FBUYER=AM_FBUYER,I\AM_TBUYER=AM_TBUYER;AM_CODE='$I\AGENT$';I\AGENT    F:DEBTOR_MAST;;;I\DM_AGN_BYR=DM_DEBTOR;DM_LINKED_AGENT='$I\AGENT$' AND DM_LINKED <> 'Y' AND DM_AGN_CR
1 0.0 Work 1 I -1 131, 145
$VALIDATE  U:LINK_BUYERS_TO_AGENT;CLEAR_GRID  C:UCASE  A:CONST;;I\ERROR  A:CONST;LOADING BUYERS ...;T\PROG    U:LINK_BUYERS_TO_AGENT;LOAD;G\GRID    I:I\ERROR;=;Y  DO(0)    A:CONST;;T\PROG    O:SETFOCUS;I\BUYER  DOEND(0)    I:I\ERROR;<>;Y  DO(9)    A:CONST;DONE LOADING !!!;T\PROG    O:ENABLEINPUT;G\GRID,I\LINE,I\LINK   
1 0.0 Work 13 I 0 1, 49
$DEFAULT  A:TIME;HH:MM:SS;T\TIME  A:DATE;DD MMM YYYY;T\DATE  A:TIMER_ON;1000    U:ZZGRID_SPLIT;INIT_GRID;G\GRID;I\LINE,I\DEBTOR,I\NAME,I\LINK    'PUTS PIC ON THE UPDATE BUTTON  O:LOADPIC;$GBLROOT$LEGEND\PROJ_FMS\PICS\NEW_TEXT_DOC.ICO;C\RUN
1 0.0 Work 2 I 0 561, 241
  
1 0.0 Work 15 I -1 211, 205
  
1 0.0 Work 14 I -1 111, 205
  
1 0.0 Work 3 I -1 61, 205
$VALIDATE  I:I\LINE;<>;  DO(LI)    U:ZZGRID_SPLIT;GRID_TO_SCREEN;G\GRID;I\LINE    O:DISABLEINPUT;G\GRID,I\DEBTOR,I\NAME,I\CR_LIMIT    O:SETFOCUS;I\AMOUNT  DOEND(LI)    I:I\LINE;=;  DO(L)    O:SETFOCUS;C\RUN    O:BACKCOLOR;C\RUN;YELLOW    O:DISABLEINPUT;G\GRID,I\LINE,I\DEBTOR,I\NAME,I\CR_LIMIT,I\AMOUNT,I\LINK  DOEND(L) 
1 0.0 Label 2 T -1 311, 49
  
1 0.0 Work 2 I -1 411, 205
$VALIDATE  C:UCASE  V:Y;N  I:I\LINK;<>;  DO(Y)    U:ZZGRID_SPLIT;SCREEN_TO_GRID;G\GRID;I\LINE    A:CONST;;I\LINE,I\DEBTOR,I\NAME,I\CR_LIMIT,I\AMOUNT,I\LINK  DOEND(Y)    O:SETFOCUS;I\LINE
1 0.0 Work 1 I 0 31, 49
$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    A:ORGS;;I\ORGS  A:CONST;$I\ORGS$;I\AGENT    I:I\ORGS;<>;  DO(03)  O:DISABLEINPUT;I\AGENT,C\AGENT  F:AGENT_MAST;;;T\AGENT_NAME=AM_NAME,I
1 0.0 H -1 0, 0
  
1 0.0 Work 12 G -1 61, 229
  
1 0.0 Label 2 T -1 521, 469
  
1 0.0 Work 1 I 0 561, 205
  
1 0.0 Work 1 I -1 661, 109
  
1 0.0 Label 2 T -1 541, 109
  
1 0.0 Work 1 I 0 561, 277
  
10 0.0 ZX_PRINT Z 0 0, 0
  
10 0.0 ZX_SELECT Z 0 0, 0
  
10 0.0 ZX_EXIT Z 0 0, 0
  
10 0.0 ZX_UPDATE Z 0 0, 0
  
10 0.0 ZX_DELETE Z 0 0, 0